Order, Coupon, Subscription Export Import for WooCommerce allows the import of orders along with line items. When importing orders, to separate the elements into line items, the pipe ‘|’ symbol is used. A sample format for inserting elements in the line item column is given below:
By default, the line items in an order are identified by product ID. There can be instances where the user needs to use an SKU instead of a product ID. In those cases, choose Yes for the option “Link products using SKU instead of Product ID” before importing it.
Linking products using product SKU
From the WordPress admin dashboard, click on WebToffee Import/Export(Pro) > Import. To connect the WooCommerce orders with products using product SKU:
- Select the post type as Order.
- Select an import method.
- Map the import columns.
- In the last step of import advanced options/ batch import and scheduling, choose Yes for the option Link products using SKU instead of Product ID.
- Click on Import to finish.
For a step-wise procedure of import, refer to How to import WooCommerce Orders.