Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mass adding product attributes?


bow-viper1

Recommended Posts

  • 2 months later...

easy populate contribution...we have one site that has 175 individual sizes with over 500 price combinations

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Link to comment
Share on other sites

I haven't tried Easy Populate, but if that is easy then I would go that route. I just finished creating my enhancement for this same problem, but mine is more integrated into adding a new product. Here is my description from another post (in the Development forum, as a recommendation for the next version. amen!)

 

Product Attributes - this functionality needs a revamp! I sell clothing, so I have to add "Size" attributes to each product so for every product I add, I have to add up to 6 more attributes in another page. The attributes were taking more time than adding the products. I would like to see the Product Options/Attribtues page modified to only allow you to add Product Options and then you can create "Attribute Sets". For example, I would create an Option called "Sizes" that would have a bunch of Option values everuthing from 2T, 3T, 4T, ... XXXXL. Then I would be able to group these Attributes into Sets and give them my own name, for example for Adult T-Shirts from sizes Small to 2XL I could call it "AT S-2X". Then when I add a new product I can select from a Drop Down List just under the Manufacturer Drop Down List, I would have another Drop Down List called Attribute Sets and if my product is an Adult T-Shirt then I would select the "AT 2-2X" and the code would add the necessary rows in the products_attributes table for sizes S, M, L, XL and XXL. I actually just completed this for myself and I plan on submitting this as a contribution this weekend, but I haven't written the interface that would create the Attribute Sets on the Product Attributes page. I figure someone could add to my contribution.

 

Let me know if if you have interest in this feature. My approach would work nicely if you are going to continue to add products in the future one at a time, where Easy Populate may really useful for a batch insert, but like I said, I've never used it.

 

Joey

Link to comment
Share on other sites

joeyjgarcia,

 

I would really be interested in you contribution.

 

I have 200 products to add each with 3 Attributes, each attribute having 19 options.

 

I dread the thought of having to do this using the standard attributes allocation.

 

Please PM me the details.

 

Thanks

 

Pewe

Link to comment
Share on other sites

i have been working on this, in the round about way of utilizing a spread sheet, as easy populate does, then using a VB Script which pulls the required information from the database tables, places them in the spread sheet, then creates the SQL code for adding the options, the option values, then the attributes and finally putting them all together with the product. i was able to do 2000 products in about 5 minutes (of course had to have all the info in the spread sheet like easy populate) and it worked fairly slick. so, if someone has something which they have used, then would be good to talk.

 

one thing tho, when you have tons of attributes, as i do, the database really slows down the back end of the store, to where it is next to impossible to manage/add products.

 

thus what prompted my next step, in creating an access application for doing everything what you can do in the back room, locally on your system, and it is multi-user. still perfecting and adding reports, etc, but is starting to come together.

Link to comment
Share on other sites

Joey,

 

I was just about to open a thread regarding "attribute sets" as you call them. I would agree that the current method of adding product options is rather time consuming. Please let me know of any developments to your contribution.

 

I'm dealing with a site that requires ~25 product attributes (scents) per product (candles)

 

-Jeff

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...