Delete Product Data from previous SmithCart

SmithCart > How To
When developing a new ecommerce store, it's normal to test different product variations, combinations, settings, etc. If you want to clear all your test data out and start over you can use the store admin screens or if your a real hacker you can use the following SQL statements will delete all records from the following tables:
 
Products
truncate table Smith_Products
truncate table Smith_Products2
 
Categories
truncate table Smith_Category
truncate table Smith_CategoryHideRole
truncate table Smith_CategoryProduct
truncate table Smith_CategoryQtyDiscounts
truncate table Smith_CategoryShowRole
 
Product Variants:
truncate table Smith_ProductVariant
truncate table Smith_ProductVariantGroup
 
Product Variant Inventory:
truncate table Smith_ProductVariantInventory
truncate table Smith_ProductVariantInvLinker
 
Coupons:
truncate table Smith_CouponProduct
truncate table Smith_CouponRole
truncate table Smith_Coupons
truncate table Smith_CouponVariant
 
Custom Shipping Methods:
truncate table Smith_ShipCategories
truncate table Smith_ShipFree
truncate table Smith_ShipMethods
truncate table Smith_ShippingByAmount
truncate table Smith_ShippingByQuantity
truncate table Smith_ShippingByWeight
truncate table Smith_ShippingByZipCode
truncate table Smith_ShipZone
 
Sales Reps:
truncate table Smith_SalesRep
truncate table Smith_SalesRepCommission
truncate table Smith_SalesRepZone
 
Discounts:
truncate table Smith_CategoryQtyDiscounts
truncate table Smith_OrderDiscounts
truncate table Smith_ProductDiscountsByRole
truncate table Smith_ProductQtyDiscounts
truncate table Smith_VariantQtyDiscounts
 
If you would like to start fresh with a whole new store, please see the following Article for step-by-step instructions to perform a clean install of SmithCart: