Remove all product data
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Remove all product data
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
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
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
- mshop_catalog_list
- mshop_media
- mshop_index_*
- mshop_price
- mshop_product
- mshop_stock
- mshop_text
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star