How does zencart clear commodity demo data and SQL Execution statement without commodity data zencart how to clear commodity demo data and SQL Execution statement without commodity data

Clear product items, attributes, and categories

Truncate table categories;

Truncate table categories_description;

# Clearing items and attributes

Truncate table media_clips;

Truncate table media_manager;

Truncate table media_to_products;

Truncate table media_types;

Truncate table music_genre;

Truncate table product_music_extra;

Truncate table product_types_to_category;

Truncate table products;

Truncate table products_attributes;

Truncate table products_attributes_download;

Truncate table products_description;

Truncate table products_discount_quantity;

Truncate table products_notifications;

Truncate table products_options;

Truncate table products_options_types;

Truncate table products_options_values;

Truncate table products_options_values_to_products_options;

Truncate table products_to_categories;

Truncate table record_artists;

Truncate table record_artists_info;

Truncate table record_company;

Truncate table record_company_info;

# Clear customer comments

Truncate table reviews;

Truncate table reviews_description;

# Clearing recommended items

Truncate table featured;

# Clear manufacturers and Materials

Truncate table manufacturers;

Truncate table manufacturers_info;

# Clear Group Prices

Truncate table group_pricing;

# Clear a promotion item

Truncate table salemaker_sales;

# Clearing special offer

Truncate table specials;

 

Deletes all products under a specified category, but does not delete this category.

Delete from 'products' where master_categories_id = 21 21 is the ID of the class to be deleted, which can be seen in the background.