How is your product data stored right now? Is the information stored nicely in database tables and in seperate fields?
Is this code value that you want to change what you have stored or how you are viewing it. What is the code? It does not look like a code in the sense of a product id so I am confused on what you are trying to do.
productid = e.g. G02-020
productdescription = e.g. T-Shirt
I then want to generate the permutations of these codes and descriptions so that it can create a new code and description
productid = G02-020/WHS
product description = T-Shirt - White Small
the first character in the product denotes category (e.g. G = clothing where 5 colours are available and 5 sizes are available, A = Gloves where no colours but maybe 6 sizes etc)
Can it be worked that it identifies the product category (by the first digit and then adds the various permutations in colour and size and adds the extension to the productid and the product extension?)
how to generate product code variants/permutations?
Hi, this is somewhat of a repost as I've tried to clarify things as much as posible.
I'm using MS Access and have a table with products.
The table has for example:-
productid = G02-020
production description = T-Shirt
The first digit (G) denotes clothing and there are 5 colour variants and 5 size variants...
I want to generate new productid codes and product descriptions for the 25 permutations of the root productid G02-020 so that....
G02-020 becomes G02-020/RES
T-Shirt becomes T-Shirt Red Small
G02-020 become G02-020/REM
T-Shirt becomes T-Shirt Red Medium
G02-020 become G02-020/REL
T-Shirt becomes T-Shirt Red Large etc ad nausea....
This is for about 800 products but the logic would be that the first character would (largely) indicate what colours and sizes are permissible e.g. Gloves A where colours are not an issue but there may be 5 sizes.
many thanks, i know the truth is out there somewhere just not sure how to get to it!