1

We have a site that has been in development and need to update the order information from the current live site.

Is it possible to just export a number of the tables from the current live site and import into the dev site? If so, can anyone tell me which tables I need to export?

0

1 Answer 1

2

Sales Order depends on both Customers & Products, so, it'll be better if you can export the whole database to dev site.

Otherwise if you already have same Products and Customers in Dev site, then try exporting following tables:

SALES RELATED TABLES

sales_flat_creditmemo;

sales_flat_creditmemo_comment;

sales_flat_creditmemo_grid;

sales_flat_creditmemo_item;

sales_flat_invoice;

sales_flat_invoice_comment;

sales_flat_invoice_grid;

sales_flat_invoice_item;

sales_flat_order;

sales_flat_order_address;

sales_flat_order_grid;

sales_flat_order_item;

sales_flat_order_payment;

sales_flat_order_status_history;

sales_flat_quote;

sales_flat_quote_address;

sales_flat_quote_address_item;

sales_flat_quote_item;

sales_flat_quote_item_option;

sales_flat_quote_payment;

sales_flat_quote_shipping_rate;

sales_flat_shipment;

sales_flat_shipment_comment;

sales_flat_shipment_grid;

sales_flat_shipment_item;

sales_flat_shipment_track;

sales_invoiced_aggregated;

sales_invoiced_aggregated_order;

log_quote;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.