lindsayanng Posted October 26, 2008 Share Posted October 26, 2008 The last time i tried to change the price of an attribute, it completely deleted that attribute from ALL other produicts that it was attached to.. It was suggested that i change attribute prices in the database tables.. i was wondering if someone can give me a little how to step by step on how to actually GET to the prices.. I have looked at it, and i can not find the prices in teh table. A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
lindsayanng Posted October 26, 2008 Author Share Posted October 26, 2008 anyone? i really need to change some prices, but i'm a little scared to do so A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
spax Posted October 27, 2008 Share Posted October 27, 2008 Access your database via phpMyAdmin, select the products_attributes table, click on the edit icon for the price you want to change, edit the price and save. Make an admin database backup before you do anything and you will be ok should you do something wrong. Did the other thing work ok? Link to comment Share on other sites More sharing options...
lindsayanng Posted October 27, 2008 Author Share Posted October 27, 2008 thats the thing.. i went to phpmyadmin, and then clicked attributes and then value_price and thats it.. i can not figure out how to edit that particular table.. what other thing/ A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
spax Posted October 27, 2008 Share Posted October 27, 2008 Once you click on the edit icon, you just edit the price value the same way you would in any text area. The other thing - sub-category password protection! Link to comment Share on other sites More sharing options...
shadow007 Posted October 27, 2008 Share Posted October 27, 2008 For the products_attributes table, you must catch the right "products_id" / "options_id" / "options_values_id"(you can find them in the url when you click on every product / option / option value), find the right record and modify its "options_values_price" Notice: backup your database at first!!! Everyone is changing the world. Everyone is a world. For everyone needs my help, PM or email if I amn't online. Link to comment Share on other sites More sharing options...
lindsayanng Posted October 27, 2008 Author Share Posted October 27, 2008 Ohh.. i think i figured it out, with the help of someone trying to accomplish the same thing. I havent tested it yet though.. as for the changing the table.. I think i found where to change it.. i clicked the product_attributes and then BROWSE.. I can see a column with the products_attribute_id and then attributes_id - how do i know which is which?? its all a tad confusing.. The id when i look at the admin side of oscommerce are all in order, and dont seem to match what the table is telling me. If i am going the change the price of one attribute across the board, how in the WORLD would i do that since attributes dont "technically" have a price attached to them until the are added to theproduct OR created into an attribute set? A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
lindsayanng Posted October 27, 2008 Author Share Posted October 27, 2008 sorry.. i just realized that i didnt say in my OP that i was trying to change the price globally so that all products that have that attribute price will change.. AND that i have attributes sets installed. A great place for newbies to start Road Map to oscommerce File Structure DO NOT PM ME FOR HELP. My time is valuable, unless i ask you to PM me, please dont. You will get better help if you post publicly. I am not as good at this as you think anyways! HOWEVER, you can visit my blog (go to my profile to see it) and post a question there, i will find time to get back and answer you Proud Memeber of the CODE BREAKERS CLUB!! Link to comment Share on other sites More sharing options...
shadow007 Posted October 27, 2008 Share Posted October 27, 2008 ...... Are you family with SQL expression? You can run SQL expression such as "update products_attributes set options_values_price = '9.99', price_prefix = '+' where options_values_id = xxx". You should replace the "xxx" with the correct option value id, you can get this id from the url(exp:http://domain/admin/products_attributes.php?action=update_option_value&value_id=2) when you click the "edit" button after every option value record in the admin panel. BTW, click the "SQL" button between "Structure" and "Search" to write and run your SQL expression Everyone is changing the world. Everyone is a world. For everyone needs my help, PM or email if I amn't online. 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.