Jump to content

Export catalog copy


harry84

Recommended Posts

Hi, I have "2 different" PrestaShop 1.7.6.3 sites, I have to copy the whole catalog of products, categories, etc. via phpMyAdmin without customers, orders, etc. can you give me the complete list of tables that I have to export from one site and import to the other by phpMyAdmin?

The 2 sites have different customers, different modules, different graphics, but they must have the same products, categories, etc.

I have already copied the whole img folder, tell me if I have to copy anything else.

Link to comment
Share on other sites

If you want to be complete something like this:

"accessory","alias","attachment","attachment_lang","attribute","attribute_group","attribute_group_lang","attribute_group_shop","attribute_impact"
,"attribute_lang","attribute_shop","cart","cart_cart_rule","cart_product","cart_rule","cart_rule_carrier","cart_rule_combination","cart_rule_country"
,"cart_rule_group","cart_rule_lang","cart_rule_product_rule","cart_rule_product_rule_group","cart_rule_product_rule_value","cart_rule_shop","category"
,"category_group","category_lang","category_product","category_shop","customization","customization_field","customization_field_lang","feature"
,"feature_lang","feature_product","feature_shop","feature_value","feature_value_lang","image","image_lang","image_shop","layered_category"
,"layered_filter","layered_filter_shop","layered_friendly_url","layered_indexable_attribute_group","layered_indexable_attribute_group_lang_value"
,"layered_indexable_attribute_lang_value","layered_indexable_feature","layered_indexable_feature_lang_value","layered_indexable_feature_value_lang_value"
,"layered_price_index","layered_product_attribute","manufacturer","manufacturer_lang","manufacturer_shop","pack","product","product_attachment"
,"product_attribute","product_attribute_combination","product_attribute_image","product_attribute_shop","product_carrier","product_country_tax"
,"product_download","product_group_reduction_cache","product_lang","product_sale","product_shop","product_supplier","product_tag","range_price"
,"range_weight","required_field","risk","risk_lang","search_word","sekeyword","specific_price","specific_price_priority","specific_price_rule"
,"specific_price_rule_condition","specific_price_rule_condition_group","stock","stock_available","stock_mvt","stock_mvt_reason"
,"stock_mvt_reason_lang","supplier","supplier_lang","supplier_shop","supply_order","supply_order_detail","supply_order_history"
,"supply_order_receipt_history","supply_order_state","supply_order_state_lang","tag","tag_count","tax","tax_lang","tax_rule","tax_rules_group"
,"tax_rules_group_shop","warehouse","warehouse_carrier","warehouse_product_location","zone","zone_shop"

If you want to keep it concise ps_product*, ps_category* and ps_image* tables

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...