Welcome to the forum. If this is your first time you can browse around and see what you like. You will need to be registered in order to post!

Join our community and talk about tech, gaming, get support for computer problems and even sale your own product.
Considering supporting us by subscribing.

Opencart phpMyAdmin Queries

Post Reply
User avatar
Site Admin
Site Admin
Posts: 47
Joined: Sat Jul 01, 2017 9:35 pm

Opencart phpMyAdmin Queries

Post by kachan64 » Wed Nov 28, 2018 10:48 am

This is a collection of code which make automation in OpenCart a bit easier. Meaning that you don't have to enable or disable settings, edit certain things individually.
To run this, make sure you have phpMyAdmin on your hosting and feel free to add your own code below:

Tested on: OpenCart 3.0.2
Earlier versions: N/A (if works for you in earlier versions, please report which version so I can update)

Set the price to 0 on all products:
This will set all product prices to 0.

Code: Select all

UPDATE oc_product SET price = '0'
Set the products to disabled:
This will effectively disable all products including the ones you previously enabled.
0 means disabled and 1 means enabled.

Code: Select all

UPDATE oc_product SET status = '0'
Reset all products back to 0 points:

Code: Select all

UPDATE oc_product SET points = '0'
Disable all country expect for one:
This will disable all country, then you can enable 1 of your choice in System > Localisation > Countries.
0 means disabled and 1 means enabled.

Code: Select all

UPDATE oc_country SET status = '0'
Removes all product description:
This will remove all product description from all products.

Code: Select all

UPDATE oc_product_description SET description = ' '
Disable all OpenCart events:
This will disable all event in OpenCart. Extensions > Events.
This should not be tested live as it could make your site none functional. This will override all disabled events as well.

Code: Select all

UPDATE oc_event SET status = '0'
PC: Custom Built Gaming PC
Monitor: Samsung S24D390H, Asus VE248H

Post Reply

Return to “OpenCart”

Who is online

Users browsing this forum: No registered users and 0 guests

Topic Subscribers

1 user subscribed to this topic: kachan64