eStore – Product csv file doesn't get imported via WordPress or PHPMyAdmin

[GeorgeK]

Hello – hope you’re well.

I have tried to upload a CSV file to mass add products. But the file doesn’t get uploaded.

The file has just 18 rows and is less than 3 (three) KB in size.

I have watched and followed the detailed videos at:

How to Easily Import or Export any of Your WordPress Database Table Content

Here are some screenshots:

imgsafe.org/image/df294a5569

imgsafe.org/image/df2953b024

imgsafe.org/image/df2955bc97

imgsafe.org/image/df294b0326

Any idea what can be going wrong?

Btw, I love the eStore plugin!

Thanks!

George

[admin]

It looks like you are getting an “Invalid column count” error. So the number of fields you have put in the CSV file is not lining up with the number of columns in the products database table.

Try the following option as that one has step by step instructions for WP eStore and also has a products template file that should line up with eStore correctly:

https://www.tipsandtricks-hq.com/ecommerce/how-to-bulk-upload-estore-products-from-a-csv-file-775

[GeorgeK]

Thanks for the reply, Keith…

Yeah, I had used the existing template products.csv and followed the instructions in your video https://www.youtube.com/watch?v=M_5h25UZFZI

I finally got it working by manually adding one product, exporting the MySQL table as CSV, adding the new info, and then importing via PHPMyAdmin.

Thanks for the help – great plugins!

George

[GeorgeK]

Hello…

Two months later, I’m updating this thread, because I’m facing a similar issue.

I try to upload a csv file via the WP CSV/DB plugin.

I get this error:

“This is not a valid .csv file extension”.

When I try to upload via PHPMyAdmin, I see this:

imgsafe.org/image/a4c9871502

It says “36 products executed”.

However, no products are actually added to the eStore backend (there are already 20 products there, and they remained 20).

I created this csv by exporting the initial products, adding some more, and then importing. It’s the exact same process that allowed me to successfully import products two months ago.

Any idea what mistake(s) I’m making?

Thanks!

[wzp]

Have you actually opened the .CSV file, to see if the contents are correct? And… does the file name actually end with the “.csv” extension?

[GeorgeK]

Thanks for the reply.

Yes, and yes.

The page with the image I posted in my previous post seems to not always be available, due to Cloudflare timing out.

Here it is again:

ibb.co/Y3rWsS3

Thanks!

[admin]

The screenshot shows an SQL error that could be preventing the execution. Can you remove that error and then do a clean import that doesn’t show any error?

[GeorgeK]

Hi, Keith!

The error in the screenshot says “#1366 – Incorrect integer value: ” for column ‘ppv_content’ at row 1″

I’m not sure what the issue could be there.

The first row of that column says “ppv_content” (without the quotes) and then every cell in that row says “0” (again, without the quotes).

I even tried creating this on Google Sheets, downloading it as .csv, and importing it via the WP CSV/DB plugin and it says “This is not a valid .csv file extension.”

Is it possible a php extension is missing on my host?

Thanks!

[wzp]

Is it possible for you to create & post a (read only) link to a CSV file that is guaranteed to recreate the issue you are experiencing? Keep it to just the “bare minimum” number of entries required to trigger the error.

[GeorgeK]

I finally got it working.

Here’s how:

– I uploaded the .csv file to my website via cPanel file manager.

– I used the WP CSV/DB plugin, and selected:

Upload ==> From URL ==> Audio, Video, or Other File ==> Insert into post

Just FYI… Even when I download https://www.tipsandtricks-hq.com/ecommerce/wp-content/uploads/products.csv and then try to upload it via the plugin’s interface, I get the error “This is not a valid .csv file extension.”

Maybe this is related to https://wordpress.org/support/topic/this-is-not-a-valid-csv-file-extension/

Anyway, thanks again for the great plugins!

[Author]

Posts