CluelessinNY Posted August 5, 2005 Share Posted August 5, 2005 I sell bridal shoes and they all have unique attributes, like size, colors and fabrics. I tried to play with the prod attributes in the Admin but it doesnt give me enuf choices. any help on this?? Link to comment Share on other sites More sharing options...
Jeremy at oddly enough Posted August 5, 2005 Share Posted August 5, 2005 You can make it so that there are multiple attribute drop downs. You'd make one for size, and then populate it with the sizes you want, one for colour, one for fabric etc.. You'll be able to make it adjust the price according to the attribute selected, and you can find methods to alter the display, control the sort order (there isn't one for attributes in a stock setup), etc. You'll probably want to do some searches for attribute contribs, because it would be a serious pain to use the admin interface to assign a large number of options to products. Jeremy Link to comment Share on other sites More sharing options...
niknakgroup Posted August 5, 2005 Share Posted August 5, 2005 Hi Melissa I would personally look seriously at using csv files to add your attributes. My site has over 600 different options (chains, gemstones, metal finishes, metal colour, ring size, width, internal diameters etc. etc.) and over 70,000 attributes assigned to products. Using my admin panel for this would kill my server just trying to process the information it was getting, so I went into phpMyAdmin and added all of the attributes that way, then downloaded a dump of the data in the table "products_attributes", opened it in excel and looked at how it was constructed, then use this as a template for adding my attributes to my new products. To add 15 attributes to a product used to take me about 10 minutes whilst I waited for my pages to load, then dug through to find my options - now I have a print out of the attribute numbers in front of me, sit on excel for 30 seconds and upload it to phpMyAdmin, done! Hope that helps, please yell at me if its as clear as mud! Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) } Link to comment Share on other sites More sharing options...
CluelessinNY Posted August 5, 2005 Author Share Posted August 5, 2005 What is PHPMYAdmin? i am clueless remember? LOL Hi Melissa I would personally look seriously at using csv files to add your attributes. My site has over 600 different options (chains, gemstones, metal finishes, metal colour, ring size, width, internal diameters etc. etc.) and over 70,000 attributes assigned to products. Using my admin panel for this would kill my server just trying to process the information it was getting, so I went into phpMyAdmin and added all of the attributes that way, then downloaded a dump of the data in the table "products_attributes", opened it in excel and looked at how it was constructed, then use this as a template for adding my attributes to my new products. To add 15 attributes to a product used to take me about 10 minutes whilst I waited for my pages to load, then dug through to find my options - now I have a print out of the attribute numbers in front of me, sit on excel for 30 seconds and upload it to phpMyAdmin, done! Hope that helps, please yell at me if its as clear as mud! <{POST_SNAPBACK}> Link to comment Share on other sites More sharing options...
niknakgroup Posted August 5, 2005 Share Posted August 5, 2005 phpMyAdmin is a tool to manipulate your sql database - this is the database which powers your oscommerce store. Your host should be able to help you find your sql manipulation url, along with password and username if needed. Not all hosts use phpMyAdmin - this is a brand name, but is by far the most commonly used sql tool. If you haven't come across it before, you may have and sql control panel, a link to "your databases" or another similar location from where you can manipulate your database - without being able to get into your database you are going to come across several problems when trying to install contribs or fix your store. Hope that helps, but if not, remember, do a search for words which dumbfound you - The big G has a wealth of knowledge freely available 24/7! Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) } Link to comment Share on other sites More sharing options...
CluelessinNY Posted August 6, 2005 Author Share Posted August 6, 2005 phpMyAdmin is a tool to manipulate your sql database - this is the database which powers your oscommerce store. Your host should be able to help you find your sql manipulation url, along with password and username if needed. Not all hosts use phpMyAdmin - this is a brand name, but is by far the most commonly used sql tool. If you haven't come across it before, you may have and sql control panel, a link to "your databases" or another similar location from where you can manipulate your database - without being able to get into your database you are going to come across several problems when trying to install contribs or fix your store. Hope that helps, but if not, remember, do a search for words which dumbfound you - The big G has a wealth of knowledge freely available 24/7! <{POST_SNAPBACK}> WHAT IS THE BIG G?? Link to comment Share on other sites More sharing options...
Guest Posted August 6, 2005 Share Posted August 6, 2005 WHAT IS THE BIG G?? <{POST_SNAPBACK}> I think he means Google :P Matti Link to comment Share on other sites More sharing options...
CluelessinNY Posted August 6, 2005 Author Share Posted August 6, 2005 Ok Now I feel really stupid! :'( Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.