Hi all, I’m still very new Dolibarr, so far it seems very flexible. However I am trying to get my head around something that either makes or breaks software like this for our purpose.
My problem is we have a lot of products that can all come in various colours and styles and prices. each product has around 9 price codes. the price code represents types of fabrics and leathers all in a variety of colours.
the differences between the price codes in cost changes with every type of product even though its the same price code
example.
product 1 with a price code of 61 might be worth $980
product 2 with a price code of 61 may also be worth $1050
and then within that 1 price code you may have 20 different colours
also not every product has the same price codes either
Some colours over time may be discontinued and new ones added in.
so what I need is an easy way to add or remove some of these colours, without having to do it individually for each of the 300 products. eg if I could do it once in a separate table so I could say code 61 = pink, red, yellow, grey, green etc. and then code 62 = blue orange, lilac etc.
at the same time I need to be able to select the product and then the colour and the system will then know that its product 2 with price code 62
I know I can setup every product to have 9 prices, but how do I assign these prices to the appropriate price code and how can I have the system give me a list of colours available within that price code.
Its very confusing I know, essentially I am trying to make it easy to maintain later when things like price changes occur or colour choices change, with the current database being in excess of 156000 products, when you take each poduct and multiples of colours.
Does anyone have any ideas with all the import options and the attributes options to maybe able to point me in the right direction.
