harry84 Posted October 26, 2020 Share Posted October 26, 2020 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 More sharing options...
musicmaster Posted October 26, 2020 Share Posted October 26, 2020 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 More sharing options...
harry84 Posted October 27, 2020 Author Share Posted October 27, 2020 Thanks @musicmaster! There are so many tables! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now