So my products all have product options which right now my excel file is setup as follows productA | prodopt1 | prodopt2 | prodopt3 | prodopt4 | Where "|" designates a new column. The products I am referring to is Wheels/Rims. The problem that I am facing conceptually is that the different product options are not just something like color or sizes of shirts, but rather sizes of wheels which drastically change the price and various other factors. So each product option also has its other lets say 5 factors that each one is associated with. So my question is should I just drastically increase my rows and make separate rows for each product option, even though its only really one product that has one landing page, the productA landing page. Maybe there is a totally other way to do this than the way I am doing it or than the way I am explaining. What's typically done in terms of storing products in excel like this prior to even uploading to a database? Thanks all, very much! Travis
if you wanted to import from excel, yes, I would have 1 row for each option. You're dealing with a flat file, so you will have repeating records....but you can always put this data into a relational database (mysql).
I understand what you mean so if my product file looks like this now. www.wheelsandtiresusa.com/wheelsproducts.rar I should be taking the product options which are the Finishes and making them have their own row for each of the sizes...? The product file will be come a lot longer, many more rows but if that's how you guys think I should be preparing it then that is what will be done. Thank you all for reading this. Travis