Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Suggestion: Attribute Sets


joeyjgarcia

Recommended Posts

Greetings everyone:

 

I have a shirt company and for each shirt I have to create 5 attributes (s, m, l, xl, xxl, xxxl) and I think there just has to be a better way.

 

Here is my proposal. I'd like to be able to create an attribute set, say one can be called "s_m_l_xl_xxl_xxxl" and another one can be called "3t_4t_5t", etc..... So when I add a new product, I select add Attribute Set from a drop down list.

 

Doesn't that sound much easier than the way it is done now, and doesn't make more sense to do it at that time? What do you think?

Link to comment
Share on other sites

That's going to give you some problems I think, what you need is a new table in the

database, something like this :

 

products_options_set

--------------------

 

products_options_set_id integer(5)

products_options_set_name varchar(64)

options_id integer(5)

options_values_id integer(5)

 

A bit of programming is then required to your admin products page to give you a drop-down

to select an options set to insert. On insert of a new product do a loop inserting a

products_attributes insert for each options_id/options_values_id pair for your chosen

products_options_set_id.

 

 

Regards

Alex.

Link to comment
Share on other sites

I understand what would need to be done and I've made many changes to my own version of OSC.

 

I would probably add a new page, after Product Attributes. Yes, I would have to add a new table (hopefully only one) and a drop down list in the New Product page. The looping needed to build the list is basic.

 

Actually, now that I think about it, it doesn't seem that hard. One new page that populates the new table(creates teh new Set). One new column in the product table for the Set ID then in the product_info page just make the list using the Set ID.

 

But I agree it could get a little hairy.

 

Did I forget anything?

Link to comment
Share on other sites

There is something called "Alternative Attribute Handling" which gives you a bunch of tickboxes when you are adding a new product (or amending an exisitng product). It's a very quick and easy way to set up attributes and it works very well.

 

You will have to hunt the contributions area for it.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...