- This topic has 7 replies, 3 voices, and was last updated 6 years, 8 months ago by
.
-
Posts
-
-
I have an order csv that i want to import, but the line items, the most important part, are no being imported.
When I go to the import screen, there’s no place to map the lime_item_1 header.Here’s an example of my csv. usernames, emails, and names have been replaced for confidentiality purposes.
https://www.dropbox.com/s/om44rfzlcbs1dsl/test%20transactions-5%20example.csv?dl=0
How can I get my line items to import? And how can I get the importer to have a field to map the line_items? they seem to be in the right format.
thanks.
-
Hi Arthur,
No need tomatically be imported
Please check line_item column in sample Order CSV – https://www.xadapter.com/how-to-import-and-export-woocommerce-orders-using-order-coupon-subscription-export-import-plugin/This will resolve your problem.
Regards,
Ando -
Now I have another problem. The prices are importing, but they are not being tied with an official product in my store.
Here is an example of a line item of one of the orders:
name:??????? |product_id:3795 |quantity:1 |total:15000.00 |refunded:0.00 |tax:0.00And this is what it looks like when imported.
https://snag.gy/Ryo0h3.jpgThe name isnt being imported, even though there is a product with the same name and ID in my store.
Here are couple ideas why I think this could happen:
1. The product name is in Japanese
If this is the case, is there a workaround?
2. The price in the CSV tore.
If this is the case, is there a work around?
3. The product is a variable product and that isnt reflected in the CSV.
If this is the case, what is the correct syntax for line items in the CSV for orders to get connected with products? -
Hi Arthur,
Did you make any adjustments to the csv?
Can you share the new csv? -
-
Hi Arthur,
Kindly check whether the product ids are correct. This problem comes when the product id associated with the line item is incorrect.
Else, you can use SKU in the line items field and try.Here is the sample csv link which has the SKU in line items – https://www.xadapter.com/how-to-import-and-export-woocommerce-orders-using-order-coupon-subscription-export-import-plugin/
-
his is really strange.
Here is a link to my CSVhttps://www.dropbox.com/s/n8xdj20ukj09xgy/test-transactions-21.csv?dl=0
Row 2 imported with only the product ID and name, not SKU
https://snag.gy/U1uILl.jpgname:??????? |sku:3798|product_id:3795 |quantity:1 |total:15000.00 |refunded:0.00 |tax:0.00
Line Item:
Row 3 didn’t import at all
https://snag.gy/2SXQyx.jpgLine Item:product_id:3795|quantity:1|total:13000|name:Eigo Coaching 2 Times Per Week?¥13000)|sku:3796|
Row 4 didn’t import at all
https://snag.gy/UlJLvE.jpgLine Item:product_id:3795|quantity:1|total:13000|name:???????|sku:3796|
Row 5 imported ok but the product code and variation code are the same
https://snag.gy/qWcGBJ.jpgLine Item:product_id:3795|quantity:1|sku:3796|
Here is my product info:
https://snag.gy/YzyZp4.jpgOne thing: I tried using the sku at the end without the pipe, but it made that become the price instead. So I put the pipe on the end and it seemed to work a little.
Please tell me:
1) the items I need in order for a line item to read correctly
2) the order those items need to be inI really want to get in the right order.
-
Hello Arthur,
We regret the inconvenience caused.
Let us know What error messages you received for not imported orders?Please raise a request here HERE and share your Sample CSV.
We will replicate on our site and let you know how to fix it. Hope that helps.Thank you for your cooperation.
Regards,
Veeresh
-
- You must be logged in to reply to this topic.