I've got a VB script that reads two dimension (i.e. Colour & Size) Fashion Matrix data in CSV format and generate a Hierarchical file ready for import into Actinic. e.g. Suppose you have FitFlop Mens Dass (Style 016) in Black (001) & Chocolate (030) with a size range of UK7 to UK12, The script will generate the following:
a. All Real products as Hidden products.
b. A top level product FFL-016 with Component, Colour Attribute with two Choices, Size Attribute with 6 choices UK7-12 and all corresponding Permutations.
c. All Sub-style products, in this case FFL-016001 & FFL-016030 for the two colours, each with a component, Colour Attribute with one colour Choice, Size Attribute with 6 choices UK7-12 and all corresponding Permutations.
Sections are not considered in the script because (a) I hate them and (b) Actinic import moans if the product is under a different section. Once imported, the products can simply be moved where they need to be if not already there.
The attached Zip file contains the script, a sample data file & some notes on it. Please bear in mind that this is my first ever VB Script & was written for my use i.e. evolved rather than designed for general use. I wouldn't say its most efficient and may have redundant code in it while trying different things out. The sorting of the data within the script is done in memory, so don't try to run half a million styles in one go. Over time, I'll improve it. I use the script to create the Fashion Matrix structure and then update the remaining product data later on.
Also, like all Actinic imports, please make sure a snapshot is taken beforehand, just in case. I do not want to be liable for anyones' website.
Hope the script helps.
Nilesh
Important Notes:
===========
a. Data needs to be sorted by Style & Sub-style.
b. If Excel is used to create & save the data as CSV file, It needs to be reopened with WORDPAD (not notepad) and then saved again. This gets rid of format effectors from the file that Excel puts in.
a. All Real products as Hidden products.
b. A top level product FFL-016 with Component, Colour Attribute with two Choices, Size Attribute with 6 choices UK7-12 and all corresponding Permutations.
c. All Sub-style products, in this case FFL-016001 & FFL-016030 for the two colours, each with a component, Colour Attribute with one colour Choice, Size Attribute with 6 choices UK7-12 and all corresponding Permutations.
Sections are not considered in the script because (a) I hate them and (b) Actinic import moans if the product is under a different section. Once imported, the products can simply be moved where they need to be if not already there.
The attached Zip file contains the script, a sample data file & some notes on it. Please bear in mind that this is my first ever VB Script & was written for my use i.e. evolved rather than designed for general use. I wouldn't say its most efficient and may have redundant code in it while trying different things out. The sorting of the data within the script is done in memory, so don't try to run half a million styles in one go. Over time, I'll improve it. I use the script to create the Fashion Matrix structure and then update the remaining product data later on.
Also, like all Actinic imports, please make sure a snapshot is taken beforehand, just in case. I do not want to be liable for anyones' website.
Hope the script helps.
Nilesh
Important Notes:
===========
a. Data needs to be sorted by Style & Sub-style.
b. If Excel is used to create & save the data as CSV file, It needs to be reopened with WORDPAD (not notepad) and then saved again. This gets rid of format effectors from the file that Excel puts in.