I have a few hundred products so I'd like to make a change to the database using sql but I have no idea how that's done. I want to change the subtract from stock value from 1 to 0.
Last edited by jlaframboise on Fri Feb 15, 2019 4:58 am, edited 1 time in total.
Assuming it's for all your product option values, in your PHPMyAdmin, execute the following query:
Note: Change oc_ prefix if using a different table prefix for your Opencart database. An additional note would be to consider that a web server can process a maximum range of 500 rows per queries when updating - also depending on the server's capacity.
Code: Select all
UPDATE `oc_product_option_value` SET `subtract` = '0' WHERE `subtract` = '1';
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
phpmyadmin doesn't let me paste this into the sql box. I tried to paste it to the query page but it disappears and doesn't do anything. I should have warned you, I'm not real bright.
No wonder people call me stupid. I was checking the wrong table. I also was able to paste using ctrl-v instead of right clicking on the mouse. Thanks a lot.
No wonder people call me stupid. I was checking the wrong table. I also was able to paste using ctrl-v instead of right clicking on the mouse. Thanks a lot.
Last edited by jlaframboise on Fri Feb 15, 2019 4:57 am, edited 1 time in total.
I do not understand why was suggested to make changes to product options table if question wasstraightlight wrote: ↑Fri Feb 15, 2019 2:35 amAssuming it's for all your product option values, in your PHPMyAdmin, execute the following query:
Code: Select all
UPDATE `oc_product_option_value` SET `subtract` = '0' WHERE `subtract` = '1';
I think you need to change just product table...I have a few hundred products so I'd like to make a change to the database using sql but I have no idea how that's done. I want to change the subtract from stock value from 1 to 0.
So you need In phpmyadmin paste the code above to sql field and click GO
Code: Select all
UPDATE `oc_product` SET `subtract` = '0' WHERE `subtract` = '1'Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Thanks for your reply too kestas. Actually, I think I'll end up doing both. Everything was originally set to subtract from stock. The store owner wants to do that manually now so I had to change the existing values to 0. This value is set in two places, one on the data tab and the other on the options tab. I will also be setting the default to 0 or no but that is probably in one of the control pages. Thanks to both of you.
kestas wrote: ↑Fri Feb 15, 2019 4:40 amI do not understand why was suggested to make changes to product options table if question wasstraightlight wrote: ↑Fri Feb 15, 2019 2:35 amAssuming it's for all your product option values, in your PHPMyAdmin, execute the following query:
Code: Select all
UPDATE `oc_product_option_value` SET `subtract` = '0' WHERE `subtract` = '1';
Knowledge is everything, that's why.jlaframboise wrote: ↑Fri Feb 15, 2019 5:12 amThanks for your reply too kestas. Actually, I think I'll end up doing both. Everything was originally set to subtract from stock. The store owner wants to do that manually now so I had to change the existing values to 0. This value is set in two places, one on the data tab and the other on the options tab. I will also be setting the default to 0 or no but that is probably in one of the control pages. Thanks to both of you.
@jlaframboise: You are going in the right direction.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Sounds dangerous, be sure to backup the database first.jlaframboise wrote: ↑Fri Feb 15, 2019 12:57 amI'd like to make a change to the database using sql but I have no idea how that's done
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member
Who is online
Users browsing this forum: No registered users and 386 guests
