I have the need to update the complete product catalog every 3 months in large 35,000 store. (Quarterly data updates from Wholesale supplier)
I have been doing this by importing CSV files (in small chuncks) to the live store. I find it really slow and if the data in not quite right I might have to redo it.
I was considering a new method. I was thinking I would refresh a cs-cart store running locally, then just restore the appropriate MySQL tables back to the live site.
I use NaviCat to do my MySQL work.
The questions I have are.
- If I want to quickly remove the entire product catalog and all things related to it, which tables must be emptied?
- An if want to dump the local tables, and restore them on the live site, which table must be included?
I’m thinking these
cscart_categories
cscart_category_
cscart_listmania_
cscart_product_*
cscart_products
cscart_products_categories
cscart_seo_names
Note all the data being imported has the same product_id as the data being removed, except of course new products. So links back to previously ordered products from Order History still work.
Are there tables I should not touch? Or other best practice I should employ?