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.
- Was this article helpful?
- Yes, thanks!Not really
December 21, 2022
I’m having trouble understanding why this article is here?
Give me a use-case scenario. e.g., is the ability : Import line items with Product SKU available to us because IF importing orders we might need to make this a 2 step process? …
1. import the order data: id, email, customer details, etc. (with NO product data), then
2. import the product sku|qty|price associated with an order ID
If so, this would be very useful. My dB separates order data across 2 tables.
One table for order data: order_id, email, customer details, etc.
and a second table referring to the order_id (above), with only 1 sku and only 1 price, etc. — so I have many records here which refer to the same order_id. It’s difficult without knowing some involved MYSQL commands to get all the order data in one record / row for import.
I hope you can speak to this. Someone above also addresses this problem. thx
February 21, 2023
By default in WooCommerce the product and orders are linked using the product ID. The option to import item details to the orders using SKU is provided because there are chances of the product IDs on the export and import site being different when migrating. In this case, if the products have an SKU then products can be linked using the SKU instead of the ID.
December 9, 2022
In prior Versions we could enter in a column the SKUs for Cross-Sellings (ie “p1|p2”).
With the new release the Cross-Sells are only imported when we enter the internal Product-ID. Is it no more possible to have the SKUs in that column?
In advanced options we selected “Match products by their SKU”.
January 2, 2023
Yes, you can import cross-sell data based on the SKU using the pro version plugin. Please enable the option “Use SKU to link up-sells, cross-sells, and grouped products” during import.
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?
April 24, 2019
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.
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
September 19, 2022
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