July 4, 2019 at 12:39 pm #15473
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:
Here are some screenshots:
Any idea what can be going wrong?
Btw, I love the eStore plugin!
GeorgeJuly 5, 2019 at 2:32 am #79672adminKeymaster
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:July 5, 2019 at 6:23 pm #79673
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!
GeorgeSeptember 24, 2019 at 5:08 pm #79674
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:
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!September 25, 2019 at 12:01 am #79675wzpModerator
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?September 25, 2019 at 5:56 am #79676
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:
Thanks!September 26, 2019 at 2:08 am #79677adminKeymaster
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?September 27, 2019 at 5:01 am #79678
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!September 27, 2019 at 4:05 pm #79679wzpModerator
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.September 28, 2019 at 7:29 am #79680
I finally got it working.
– 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!
- You must be logged in to reply to this topic.