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:

Line item with ProductID

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:

Line item with SKU

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.

2 thoughts on “How to Import line items with Product SKU

  1. kevin49
    kevin49 says:

    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
      Alan says:


      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.

Leave a Reply

Your email address will not be published. Required fields are marked *