line items not importing

This topic contains 7 replies, has 3 voices, and was last updated by Veeresh Veeresh 4 years, 6 months ago.

  • Author
    Posts
  • #50189
    Arthur
    Arthur
    Participant

    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.

  • #50238
    Anindo
    Anindo
    Keymaster

    Hi Arthur,

    No need to map line items while importing. It will automatically 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

  • #50252
    Arthur
    Arthur
    Participant

    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.00

    And this is what it looks like when imported.
    https://snag.gy/Ryo0h3.jpg

    The 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 doesnt match any of the prices for the product in the store.
    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?

  • #50267
    Anindo
    Anindo
    Keymaster

    Hi Arthur,

    Did you make any adjustments to the csv?
    Can you share the new csv?

  • #50286
    Arthur
    Arthur
    Participant
  • #50301
    Anindo
    Anindo
    Keymaster

    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/

  • #50370
    Arthur
    Arthur
    Participant

    his is really strange.
    Here is a link to my CSV

    https://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.jpg

    name:英語コーチング |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.jpg

    Line 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.jpg

    Line 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.jpg

    Line Item:product_id:3795|quantity:1|sku:3796|

    Here is my product info:
    https://snag.gy/YzyZp4.jpg

    One 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 in

    I really want to get this out of the way, I have almost 1000 orders that I need to get in the right order.

  • #50444
    Veeresh
    Veeresh
    Participant

    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.