Code2care : TechZone Apps & Tutorials

How To Delete OpenCart Demo Data

When we install OpenCart, the mysql database is preloaded with some dummy demo data.

If you want to have a fresh database , with no Products information in your OpenCart database all you need to do is execute the following command in mysql console.

DELETE FROM oc_address;
DELETE FROM oc_category;
DELETE FROM oc_category_description;
DELETE FROM oc_category_to_store;
DELETE FROM oc_coupon;
DELETE FROM oc_customer;
DELETE FROM oc_download;
DELETE FROM oc_download_description;
DELETE FROM oc_manufacturer;
DELETE FROM oc_manufacturer_to_store;
DELETE FROM oc_product;
DELETE FROM oc_product_description;
DELETE FROM oc_product_discount;
DELETE FROM oc_product_featured;
DELETE FROM oc_product_image;
DELETE FROM oc_product_option;
DELETE FROM oc_product_option_description;
DELETE FROM oc_product_option_value;
DELETE FROM oc_product_option_value_description;
DELETE FROM oc_product_related;
DELETE FROM oc_product_special;
DELETE FROM oc_product_to_download;
DELETE FROM oc_product_to_store;
DELETE FROM oc_review;
DELETE FROM oc_store;
DELETE FROM oc_store_description;
DELETE FROM oc_product_tags;
DELETE FROM oc_order;


Posts related to opencart.

1. OpenCart Change Default Currency

2. How To Add New Currency to OpenCart

3. How To Delete OpenCart Demo Data

Code2care : Lines of Code for Change
Code2care is an initiative to publish and share varied knowledge in technical and non-technical areas gathered during day-to-day learnings and development activities.

Android app on Google Play    

Popular tags
x 175
x 29
x 20
x 14
x 14
x 14
x 13
x 11

1000+ C Programs     PHP Tutorial     JSON Tutorial     Swift Tutorial     India Pinocdes     About Us     Privacy Policy

Code2care © 2012-17