Hit ‘Cannot insert order without order status.’

Resolved xenosaga111
(@xenosaga111)

4 years, 8 months ago

WooCommerce – Version 3.7.0
Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC) – Version 1.5.1

The csv file I used was obtained from ‘WooCommerce > Order Im-Ex > Sample Order CSV hyperlink (right bottom corner)’. When I modified the columns ‘A’, ‘B’ and ‘T’ of the downloaded order csv, I hit this error message.

So, could you please assist why this error message appears when I change those mentioned columns but not appear when I change nothing for the downloaded csv? If I have used the wrong csv, could you please provide the link which I can download the correct csv?

Thanks for your assist.

Viewing 14 replies - 1 through 14 (of 14 total)

Plugin Author WebToffee
(@webtoffee)

4 years, 8 months ago

Hi @xenosaga111,

Kindly make sure that you have product status data provided in the status column of the CSV file with valid data. Also please make sure that the delimiter used in the importing CSV file is a comma(,). The basic version of the plugin only supports CSV files with comma(,) delimiter.

If the issue still persists please share us the CSV file you are importing via support.
Thread Starter xenosaga111
(@xenosaga111)

4 years, 8 months ago
Hi @webtoffee,

I have submitted the csv file via support and my ticket number is 6895.

Thanks.
- This reply was modified 4 years, 8 months ago by xenosaga111.
Plugin Author WebToffee
(@webtoffee)

4 years, 8 months ago

Hi @xenosaga111,

We have received your support ticket. Our support team will get in touch with you ASAP.
taurul
(@taurul)

4 years, 7 months ago
the same for me. it worked before but not now.
- This reply was modified 4 years, 7 months ago by taurul.
nuwud
(@nuwud)

4 years, 7 months ago

Hi, I have the same issue.

Plugin Author WebToffee
(@webtoffee)

4 years, 7 months ago

Hi @nuwud @taurul,

The issue you are facing might be because the date format in the CSV file is different. Currently, the basic version of the plugin supports importing orders having date format YYYY-MM-DD, YYYY/MM/DD and DD-MM-YYYY. Kindly make sure that you provide the date with any of these formats instead of DD/MM/YYYY. Also please make sure that the order status provided in the CSV file is valid.

If the issue still persists please reach us via support.

nuwud
(@nuwud)

4 years, 7 months ago

You were right about the dates being formatted differently, but correcting them didn’t change the error for me.

taurul
(@taurul)

4 years, 7 months ago

i’m getting the error:
Cannot insert order without order status.

Plugin Author WebToffee
(@webtoffee)

4 years, 7 months ago

Hi @nuwud @taurul,

We have released a new version for the Order import-export plugin. Please try updating the plugin to the latest version(Ver. 1.5.2) and try importing the orders.

If the issue still persists please reach us via support.

taurul
(@taurul)

4 years, 7 months ago

the same

skipped
69
null null – Cannot insert order without order status.
skipped
70
null null – Cannot insert order without order status.
skipped
71
null null – Cannot insert order without order status.
skipped
72
null null – Cannot insert order without order status.
skipped
73
null null – Cannot insert order without order status.
skipped
74
null null – Cannot insert order without order status.
skipped
75
null null – Cannot insert order without order status.
skipped
76
null null – Cannot insert order without order status.
skipped
77
null null – Cannot insert order without order status.
skipped
78
null null – Cannot insert order without order status.
skipped
79
null null – Cannot insert order without order status.
skipped
80
null null – Cannot insert order without order status.
skipped
81
null null – Cannot insert order without order status.
skipped
82
null null – Cannot insert order without order status.
skipped
83
null null – Cannot insert order without order status.
skipped
84
null null – Cannot insert order without order status.
skipped
85
null null – Cannot insert order without order status.
skipped
86
null null – Cannot insert order without order status.
skipped
87
null null – Cannot insert order without order status.

Plugin Author WebToffee
(@webtoffee)

4 years, 7 months ago

Hi @taurul,

It seems like the issue you are facing is because of either the column header name or format of the data in your CSV file is different. Kindly make sure that you use the default column header names and data format to import orders using the basic version of the plugin.
You may please export a sample order using the basic version of the plugin and use the same column header name in the exported CSV file to import new orders.

depewtechs
(@depewtechs)

4 years, 3 months ago

I just wanted to add to this for anyone who may experience this same issue after any updates. This is of no fault of the developer/Author. I had the same issue when opening the CSV in Numbers using a Mac. When I switch to Google Excel docs and copied my data over and exported to CSV as comma delimited, It worked!

tracyraftl
(@tracyraftl)

4 years, 1 month ago

Hi, I’m having the same issue. Where can I find the “default column header names and data format” so I can make sure my CSV is right? Thank you!

Plugin Author WebToffee
(@webtoffee)

4 years, 1 month ago

Hi @tracyraftl,

You can get the default column header names and data format by exporting a sample order from your site using the plugin. The exported CSV file will contain the correct column header names and data format.