Hey guys,
I am using OpenCart 3 and have been adding products to my store for a few weeks.
I added about 200 products which are digital, and do not require shipping, in all my wisdom I didn't change it from 'yes' to 'no' on requires shipping bit.
Is there a way of doing this in bulk to save me a) some time in the future b) some rsi
Any help appreciated, thank you
Luke
Hi you simply can make it in your phpmyadmin. Select and open your database, click SQL tab and paste this code:
and click GO
Please check prefix of your table. Default "oc_"
This code will change the "Requires Shipping" -> "No" all of your products.
Important !!! Before you start this step, make a backup of the database.
Cheers
Code: Select all
UPDATE oc_product
SET shipping = 0Please check prefix of your table. Default "oc_"
This code will change the "Requires Shipping" -> "No" all of your products.
Important !!! Before you start this step, make a backup of the database.
Cheers
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
ok, you need use INNER JOIN...
use this code to set shipping not required by category:
change "24" from my example to your desired category number where your products should be without shipping.
of course do not forget to make backup of your database!!!
Cheers
use this code to set shipping not required by category:
Code: Select all
UPDATE oc_product p
INNER JOIN oc_product_to_category ptc
ON ptc.product_id = p.product_id
SET p.shipping = 0
WHERE ptc.category_id = 24of course do not forget to make backup of your database!!!
Cheers
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Wow, it actually worked. 214 lines updated. And the site hasn't exploded yet. Thank you very much! :-D
Give it time.lukeketchum1 wrote: ↑Wed Jul 11, 2018 8:38 pmWow, it actually worked. 214 lines updated. And the site hasn't exploded yet. Thank you very much! :-D
Just kidding
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Unfortunately, we will not see if it doespaulfeakins wrote: ↑Thu Jul 12, 2018 7:22 pmGive it time.lukeketchum1 wrote: ↑Wed Jul 11, 2018 8:38 pmWow, it actually worked. 214 lines updated. And the site hasn't exploded yet. Thank you very much! :-D
Just kidding
Custom OpenCart modules and solutions. You can write PM with additional questions... Extensions you can find here
Who is online
Users browsing this forum: Bing [Bot] and 60 guests
