How to Import line items with Product SKU
Order/Coupon/Subscription Export Import Plugin for WooCommerce allows importing of orders along with line items in CSV/XML format. When importing orders, to separate the elements in line items, the pipe ‘|’ symbol is used. A sample format for inserting elements in the line item column is as 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 SKU instead of a product ID. In those cases, just enable the option “Link products using SKU instead of Product ID” before importing it.
Know more about Importing Orders.