Documentation, Knowledge Base, Order / Coupon / Subscription Export Import Plugin for WooCommerce
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. While importing orders, elements in the line items are separated using the pipe ‘|’ symbol. 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 product ID. In those cases, just leave the space meant for product ID empty provided that they are separated with the pipe symbol as shown below:
In general, if any of the element is not present in the line item column, then the space for it has to be kept empty separated with the pipe symbol.
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?
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.