Getting Started
Import Orders
Export Orders
Meta Data
Advanced Topics
Troubleshooting
Code Snippet
Third-Party Compatibility
ChangelogOrder/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.
- Was this article helpful?
- Yes, thanks!Not really
Comments (4)
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.
Sami
September 6, 2022
I’m only able to import the first product of an order and I’ve been trying to find out how to import more than one. The tool only reads one column and if the products are stacked into one column it still reads only the first product along with it’s data; products are separated by |; e.g. name|sku|quantity|total|name|sku|quantity|total
Alan
September 19, 2022
Hi,
If you have multiple products then you have to create multiple line item columns and provide data in them. For each item, you have to create separate columns. Eg: If you have 2 items then the CSV should have 2 line_item columns ie. line_item_1 & line_item_2