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.
Comments (2)
kevin49
April 24, 2019
If you are trying to import 50 products, that are all different product ID’s, what is the easiest way to enter that information on the CSV prior to importing?
Alan
April 24, 2019
Hi,
Hope you are trying to import orders. If you are required to import 50 different products into the line item field of orders then you may please specify the ID’s of those 50 products in the line item column of corresponding orders.