[Solved] Copying Orders to another store

[lozaria]

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 September 13, 2016 by lozaria (see edit history)

[lozaria]

I found the problem. ps_address was the missing table!