Getting Rid of Sample Data

If you want to delete all sample data, simply run these statements in your MySQL admin tool. These take care of products, skus, orders, categories, secondaries, product options, shopping cart, shipping methods:

-- Delete the cart
DELETE FROM tbl_cart;

-- Delete the orders
DELETE FROM tbl_orderskus;
DELETE FROM tbl_orders;

-- Delete the customers
DELETE FROM tbl_customers;

-- Delete the upsell products
DELETE FROM tbl_prdtupsell;

-- Delete the secondary categories
DELETE FROM tbl_prdtscndcat_rel ;
DELETE FROM tbl_prdtscndcats ;

-- Delete the product options
DELETE FROM tbl_prdtoption_rel ;
DELETE FROM tbl_list_optiontypes;

-- Delete the categories
DELETE FROM tbl_prdtcat_rel ;
DELETE FROM tbl_prdtcategories ;

-- Delete the sku options
DELETE FROM tbl_skuoption_rel ;
DELETE FROM tbl_skuoptions ;

-- Delete skus and products
DELETE FROM tbl_skus ;
DELETE FROM tbl_products;

-- Delete shipping methods
DELETE FROM tbl_shipmethcntry_rel ;
DELETE FROM tbl_shipmethod ;
DELETE FROM tbl_shipweights ;

Back to Cartweaver PHP FAQ, code changes, and samples