Post by Klimskady » Tue Oct 01, 2013 5:58 am

I am looking to basically start again with my categories, products and orders before I launch my store as I have had several test categories, etc the numbers are obviously not correct and I would like to be able to start each again from 0 so that I can re-add the categories etc I actually want starting from scratch.

Any help on this would be grand.

Active Member

Posts

Joined
Tue Jun 07, 2011 7:57 am

Post by CZechBoY » Tue Oct 01, 2013 7:29 pm

Run these sql queries:

Code: Select all

TRUNCATE TABLE `category`;
TRUNCATE TABLE `category_description`;
TRUNCATE TABLE `category_filter`;
TRUNCATE TABLE `category_path`;
TRUNCATE TABLE `category_to_layout`;
TRUNCATE TABLE `category_to_store`;
TRUNCATE TABLE `order`;
TRUNCATE TABLE `order_download`;
TRUNCATE TABLE `order_field`;
TRUNCATE TABLE `order_fraud`;
TRUNCATE TABLE `order_history`;
TRUNCATE TABLE `order_option`;
TRUNCATE TABLE `order_product`;
TRUNCATE TABLE `order_recurring`;
TRUNCATE TABLE `order_recurring_transaction`;
TRUNCATE TABLE `order_status`;
TRUNCATE TABLE `order_total`;
TRUNCATE TABLE `order_voucher`;
TRUNCATE TABLE `product`;
TRUNCATE TABLE `product_attribute`;
TRUNCATE TABLE `product_description`;
TRUNCATE TABLE `product_discount`;
TRUNCATE TABLE `product_filter`;
TRUNCATE TABLE `product_image`;
TRUNCATE TABLE `product_option`;
TRUNCATE TABLE `product_opton_value`;
TRUNCATE TABLE `product_profile`;
TRUNCATE TABLE `product_recurring`;
TRUNCATE TABLE `product_related`;
TRUNCATE TABLE `product_reward`;
TRUNCATE TABLE `product_special`;
TRUNCATE TABLE `product_to_category`;
TRUNCATE TABLE `product_to_download`;
TRUNCATE TABLE `product_to_layout`;
TRUNCATE TABLE `product_to_store`;

Mass update product descriptions/Hromadná změna popisků zboží


User avatar
Active Member

Posts

Joined
Mon Mar 19, 2012 1:39 am
Location - Europe, Czech republic; Hradec Králové, Brno

Post by Klimskady » Wed Oct 02, 2013 2:55 am

Thanks! will give it a go.

Active Member

Posts

Joined
Tue Jun 07, 2011 7:57 am
Who is online

Users browsing this forum: Bing [Bot] and 73 guests