Import facility not working

Resolved churchinchicago
(@churchinchicago)

3 years, 1 month ago

For some reason, I was able to import using Product CSV Import Export (BASIC) but suddenly the import is not working. I get “Failed to import product” on ALL 850+ records. The column for SKU is blank, and the column for Product equals 0- throughout. As far as I know, the import file is formatted properly (UTF-8).

Any ideas?

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

Plugin Author WebToffee
(@webtoffee)

3 years ago

Hi @churchinchicago,

Could you please share your importing CSV file and the screenshot of your import mapping screen?

Thread Starter churchinchicago
(@churchinchicago)

3 years ago

Hi @webtoffee,

Sorry, I don’t know how to attach files to my message. Can you let me know?

Thanks

Thread Starter churchinchicago
(@churchinchicago)

3 years ago

Instead of attaching files to my message, here’s the importing CSV (actually txt) file:

“sku”,”stock”,”regular_price”
“0310241464”,1.00,16.97
“0310341515”,2.00,22.99
“0310370000”,1.00,16.95
“0664241611”,0.00,8.95
“0736300384”,2.00,12.00

And here is the import mapping screen:

Row SKU Product Status Msg
X 1 0 – Failed to import product
X 2 0 – Failed to import product
X 3 0 – Failed to import product
X 4 0 – Failed to import product
X 5 0 – Failed to import product

Would appreciate your help.

Plugin Author WebToffee
(@webtoffee)

3 years ago

Hi @churchinchicago,

Please share your importing CSV file so that we can check it? You may please share it with us by uploading it to Google Drive or WeTransfer or any similar service and sharing the link. Or else you may please send it to us via support.

Thread Starter churchinchicago
(@churchinchicago)

3 years ago

Here’s the import file (txt):

https://churchinchicago-my.sharepoint.com/:t:/g/personal/kevin_johnston_churchinchicago_onmicrosoft_com/ET8dbr9O_7pBgpD6eB3ZJrQB-d4gWosgz_297zeziRc4Ig?e=haZd3k

And here’s a screen shot of the import mapping results:

https://churchinchicago-my.sharepoint.com/:i:/g/personal/kevin_johnston_churchinchicago_onmicrosoft_com/EfYAgZCvXJ1KtEdc0lLaC9cBB5clknsgbAtiNJnvkaG6fg?e=hp2fwd

Hope that works. Thank you.

Plugin Author WebToffee
(@webtoffee)

3 years ago

Hi @churchinchicago,

We are able to update the products successfully using your file on our test site without any issues. Kindly make sure that you have enabled the Update option while importing. If the issue persists please share your import log file via support so that we can check it.

Thread Starter churchinchicago
(@churchinchicago)

3 years ago

I really appreciate your support. I’ve enabled the Update option while importing. I’m not sure what you mean by an import log file. If it is the same as the screen that comes up when running the import process, it is simply the following for each record:

Row: [row number]
SKU: [blank]
Product: 0-
Status Msg: Failed to import product

Let me know what else I can provide.

Plugin Author WebToffee
(@webtoffee)

3 years ago

Hi @churchinchicago,

You can find the import log from Woocommerce>status>logs>csv-import. Please share it with us via support.

Thread Starter churchinchicago
(@churchinchicago)

3 years ago

I submitted the import log as requested.

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

The topic ‘Import facility not working’ is closed to new replies.

Tags