X-Cart forums

[steakbbq]

I am currently pulling my hair out.

I need to have product options/variations for cigars wrapper type.

Some cigars come in different wrappers, maduro, natural, robusto etc..

Not all cigars have these options but a lot of them do.

If I do product variations that is a LOT of manual data entry, 3 rows for 3 wrapper types per product..

Shouldn't there be an easier way to input this data?

My csv I'm currently building just has extra rows with x's in them for the wrapper types they support. For example.

Cigar Name.|Maduro.|Natural..|Robusto.
1..........|x......|x........|x.......
2..........|x......|.........|........
3..........|x......|.........|........
4..........|.......|x........|x.......
5..........|x......|x........|x.......

Ignore the periods, they are just there for spacing

This is just at the end of the row for the cigar.

I am pulling the cigars from the pdf's and excels into this temporary excel where I can get them all ready to be put into the format needed for xcart. The way I am currently going I am guessing I have to make a product variation csv and for each of the cigars with wrappers ( a lot ) i need to make a row that references the product ID for every wrapper type for every product. A lot of work.

Any tips on how to do this in the most time efficient way as possible?

Also some of the cigars have different prices based on what wrapper is selected..

Is this even the right place to ask this?