Product Manufacturer Spreadsheets

[Guest]

When uploading large spreadsheets provided by product manufacturers, I find that it is very typical that a product may come in several variations such as one product in many colors. In this case most times the model numbers are the same for any number of colors but the SKU or part numbers are different and in some cases the prices vary.

 

Ex.:

Model #, SKU #, Image, UPC, Color,

2279-1, 2279-1-K4, ccc12685_k4.jpg, 087206831805, Cashmere,

2279-1, 2279-1-0, ccc12685_0.jpg, 040688871417, White,

2279-1, 2279-1-47, ccc12685_47.jpg, 040688871448, Almond,

2279-1, 2279-1-55, ccc12685_55.jpg, 040688871462, Innocent Blush,

2279-1, 2279-1-6, ccc12685_6.jpg, 040688871486, Skylight,

2279-1, 2279-1-Y2, ccc12685_y2.jpg, 040688871554, Sunlight,

2279-1, 2279-1-G9, ccc12685_g9.jpg, 087206340536, Sandbar,

2279-1, 2279-1-96, ccc12685_96.jpg, 040688871530, Biscuit,

2279-1, 2279-1-95, ccc12685_95.jpg, 040688871523, Ice Grey,

2279-1, 2279-1-7, ccc12685_96.jpg, 040688871493, Black Black,

2279-1, 2279-1-58, ccc12685_96.jpg, 040688871479, Thunder Grey,

2279-1, 2279-1-52, ccc12685_96.jpg, 040688871455, Navy,

2279-1, 2279-1-45, ccc12685_45.jpg, 040688871431, Wild Rose,

2279-1, 2279-1-33, ccc12685_33.jpg, 040688871424, Mexican Sand,

 

The client would like to show one item from the list above with options for each of the colors. When the option is selected the correct SKU and price should be added to the cart.

 

Is there a simple solution that I am missing or is there a contribution that can handle this issue?

 

Thanks!

 

Corey

BMF Enterprises

[♥Vger]

Easy Populate?

 

Vger

[Guest]

It says in the EasyPopulate ReadMe that the contribution doesn’t handle attributes well and that is the only way I could see it helping in this situation.

 

I was thinking about adding a field to the products database called “Display” and therefore only one of a group of products would be displayed in the index.php product listing. When a user selects that product or rather, group of products, the product_info.php page would do a query for all products in that group and then display them in a fashion of “This product also comes in the following colors:” each color would be a link to a specific products_id which would reload the product_info.php page with the new data and a new listing of “also comes in the following colors:” choices.

 

I didn’t want to get too far into this without checking for other options.

 

Any thoughts?

 

Thanks!

 

Corey

BMF Enterprises

[Guest]

It says in the EasyPopulate ReadMe that the contribution doesn’t handle attributes well and that is the only way I could see it helping in this situation.

 

I was thinking about adding a field to the products database called “Display” and therefore only one of a group of products would be displayed in the index.php product listing. When a user selects that product or rather, group of products, the product_info.php page would do a query for all products in that group and then display them in a fashion of “This product also comes in the following colors:” each color would be a link to a specific products_id which would reload the product_info.php page with the new data and a new listing of “also comes in the following colors:” choices.

 

I didn’t want to get too far into this without checking for other options.

 

Any thoughts?

 

Thanks!

 

Corey

BMF Enterprises

 

I use easypopulate (with QTPro) on my site. Although it takes some getting used to is does seem to work ok. There is about 500 product on the site with up to 12 attributes for some products.

 

Hope this helps.

[♥bruyndoncx]

master / slave products is also an option. There are differences/nuances between the two , that might make one more suitable over the other for you.