Jump to content

[Solved] Copying Orders to another store


Recommended Posts

Hello,

 

I'm developing a new version PS 1.6 of a store. I wish to migrate customers, orders, products and categories. I'm updating the old version to 1.6 in order to have the same table schemas and all the categories, products and customers are migrated fine. All the records exist in ps_orders but not all orders are visible in Admin Panel / Orders

 

I'm copying ps_orders_* after copying customers, products and categories in order eventually to avoid missing keys between the tables.

 

Is it possible that I'm missing some table to copy?

 

I'm copying all these tables to the new store:

 
ps_wishlist.sql
ps_wishlist_email.sql
ps_wishlist_product.sql
ps_wishlist_product_cart.sql
 
 
ps_category.sql
ps_category_group.sql
ps_category_lang.sql
ps_category_product.sql
ps_category_shop.sql
ps_manufacturer.sql
ps_manufacturer_lang.sql
ps_manufacturer_shop.sql
ps_shop.sql
ps_shop_group.sql
ps_supplier.sql
ps_supplier_lang.sql
ps_supplier_shop.sql
ps_supply_order.sql
ps_supply_order_detail.sql
ps_supply_order_history.sql
ps_supply_order_receipt_history.sql
ps_supply_order_state.sql
ps_supply_order_state_lang.sql
 
ps_carrier.sql
ps_carrier_group.sql
ps_carrier_lang.sql
ps_carrier_shop.sql
ps_carrier_tax_rules_group_shop.sql
ps_carrier_zone.sql
ps_customer.sql
ps_customer_group.sql
ps_customer_message.sql
ps_customer_message_sync_imap.sql
ps_customer_thread.sql
ps_product.sql
ps_product_attachment.sql
ps_product_attribute.sql
ps_product_attribute_combination.sql
ps_product_attribute_image.sql
ps_product_attribute_shop.sql
ps_product_carrier.sql
ps_product_comment.sql
ps_product_comment_criterion.sql
ps_product_comment_criterion_category.sql
ps_product_comment_criterion_lang.sql
ps_product_comment_criterion_product.sql
ps_product_comment_grade.sql
ps_product_country_tax.sql
ps_product_download.sql
ps_product_group_reduction_cache.sql
ps_product_lang.sql
ps_product_sale.sql
ps_product_shop.sql
ps_product_supplier.sql
ps_product_supplier_bak.sql
ps_product_tag.sql
 
ps_orders.sql
ps_order_carrier.sql
ps_order_cart_rule.sql
ps_order_detail.sql
ps_order_detail_tax.sql
ps_order_history.sql
ps_order_invoice.sql
ps_order_invoice_payment.sql
ps_order_invoice_tax.sql
ps_order_message.sql
ps_order_message_lang.sql
ps_order_payment.sql
ps_order_return.sql
ps_order_return_detail.sql
ps_order_return_state.sql
ps_order_return_state_lang.sql
ps_order_slip.sql
ps_order_slip_detail.sql
ps_order_slip_detail_tax.sql
ps_order_state.sql
ps_order_state_lang.sql
ps_paypal_customer.sql
ps_paypal_login_user.sql
ps_paypal_order.sql
 
Many thanks for you suggestions!
Edited by lozaria (see edit history)
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...