Page 1 of 1

Remove all product data

Posted: 03 Oct 2019, 11:02
by cnoelker
Hello,
what's the best way to reset all product data, including prices an media?
I would like to run an import with product data on a clean system, but without have to recreate any categories, attributes, etc.

One way would be to truncate the related tables. I did already identify:
mshop_catalog_list
mshop_media
mshop_index_*
mshop_price
mshop_price_list
mshop_product
mshop_product_list
mshop_stock
mshop_text

Did I identify all tables? Is it save to truncate them and then start a new import?
Claudia

Re: Remove all product data

Posted: 03 Oct 2019, 11:33
by aimeos
Use "DELETE" but not "TRUNCATE" because "DELETE" removes the records referenced by foreign keys as well:
- mshop_catalog_list
- mshop_media
- mshop_index_*
- mshop_price
- mshop_product
- mshop_stock
- mshop_text