Bulk Adding Products

[Guest]

Just took over an osCommerce site for a client, and she's requested a way to bulk-add items.

 

For example, she has 100 rings to add to her site, each coming in sizes 6, 6.5, 7, 7.5, ..., 12. It seems like this would require going to the "Product Attributes" page on the admin panel and manually adding the dozen attributes for each 100 rings. 1200 steps - that's ludicrous!

 

Are we going about this the wrong way?

 

Assuming we're not, my question is: What database tables do I have to be concerned with updating if I were to create a little script to bulk add items with identical attributes like this? Again, it would both create the items and add the attributes.

 

A cursory glance would indicate products, products_attributes, and products_description.

[Flyer5]

Just took over an osCommerce site for a client, and she's requested a way to bulk-add items.

 

For example, she has 100 rings to add to her site, each coming in sizes 6, 6.5, 7, 7.5, ..., 12.  It seems like this would require going to the "Product Attributes" page on the admin panel and manually adding the dozen attributes for each 100 rings.  1200 steps - that's ludicrous!

 

Are we going about this the wrong way?

 

Assuming we're not, my question is:  What database tables do I have to be concerned with updating if I were to create a little script to bulk add items with identical attributes like this?  Again, it would both create the items and add the attributes.

 

A cursory glance would indicate products, products_attributes, and products_description.

<{POST_SNAPBACK}>

 

theres a couple of things i can think of that may help. The first is the "Attribute groups" contribution. You only need make 1 set of attributes in a group, ie sizes 4 to 9 or whatever, then add that group to the profduct.

 

The other thing may be EZ populate, another contribution that uses excell to preapare a bulk list for uploading. I believe people have had mixed success with it, but I personally have never used it.

 

F5