WooCommerce order imports involve more than transferring rows from a spreadsheet. Each order links customer details, billing and shipping addresses, line items, totals, taxes, discounts and status. WooCommerce stores order data across different structures, including wp_posts and wp_postmeta and, on modern installations, High-Performance Order Storage tables. A product-style import that ignores these relationships can leave orders without products or customer associations.

WP All Import, with its WooCommerce add-on, maps CSV fields to order records and supports automatic or manual field setup. Files can also be supplied through a URL, Google Sheets, the plugin’s uploads directory or FTP/SFTP. Before importing, products must exist in the destination store and be matchable by SKU or product ID; customer records should also be available if orders need to link to existing accounts.

The workflow analyses the file, displays detected fields for review and provides an order preview before import. Billing details, line items, totals, dates and statuses merit particular scrutiny, especially on orders containing multiple products, coupons or refunds. Background batches are intended to reduce timeout problems with large imports. After processing, checking sample orders in WooCommerce verifies customer links, statuses and totals against the export.

Author of the original text: Ahmed Chougle (Oxygen)