Support » Plugin: Order Export & Order Import for WooCommerce » About line_item_x column in csv file

  • Resolved xenosaga111


    WordPress version – 5.2.2
    Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC) version – 14.9
    line_item_1 column csv value –
    name:Men’s Cotton T-Shirt|sku:B11V2|quantity:1|total:11.88|refunded:0.00|meta:color=Red|tax:0.00
    (I downloaded and used the csv sample from here.)

    Hello, I found that the values contained in the mentioned csv column were mapped to the incorrect fields in WooCommerce > Orders > (Click on any 1 of the orders) > Item section. Inside item section in which there is a ‘Refund’ button under it, I discovered some problems.

    Problem 1
    ‘Cost’ and ‘Total’ of item section both showed $0.00.

    Problem 2
    ‘Qty’ of item section took ‘11.88’ (the value in ‘total’ of line_item_1 csv column) and showed as ’11’ in in this section instead of using the value of ‘quantity’ of csv column, which is 1.

    Problem 3
    The other details of line_item_1 column csv, for example ‘meta:color=Red’ did not show in the item section also. Actually where do those values will be shown?

    Could you please clarify or provide assist in these problems I found so far? Actually I also have a question. Am I allowed to name the parameter of line_item_1 to other name? For example, change ‘name’ of csv column to ‘name_of_cloth’, ‘quantity’ to ‘quantity_purchased’?

    Thanks very much for your assist.

Viewing 1 replies (of 1 total)
  • Plugin Author webtoffee


    Hi @xenosaga111,

    The CSV file you have downloaded from the WebToffee documentation page is supported only in the premium version of the plugin due to which the line item details are imported incorrectly.
    The basic version of the Order import-export plugin supports orders that contain simple product items only. You may have a look at the premium version of the plugin which supports import/export of order items that are variable products. You can download the CSV file that is supported by the basic version below the premium version features banner in the basic version of the plugin.

    Regarding changing the line item column header name to another name, it is necessary to have the column header to be named as line_item_1, line_item_2,..etc in order to import the order item details using the plugin.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.