joeyjgarcia Posted March 18, 2004 Share Posted March 18, 2004 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 More sharing options...
Alex Bath Posted March 19, 2004 Share Posted March 19, 2004 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 More sharing options...
joeyjgarcia Posted March 19, 2004 Author Share Posted March 19, 2004 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 More sharing options...
burt Posted March 19, 2004 Share Posted March 19, 2004 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.