Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

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

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › eStore – Product csv file doesn't get imported via WordPress or PHPMyAdmin

  • This topic has 9 replies, 3 voices, and was last updated 2 years, 9 months ago by GeorgeK.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • July 4, 2019 at 12:39 pm #15473
    GeorgeK
    Member

    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

    July 5, 2019 at 2:32 am #79672
    admin
    Keymaster

    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

    July 5, 2019 at 6:23 pm #79673
    GeorgeK
    Member

    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

    September 24, 2019 at 5:08 pm #79674
    GeorgeK
    Member

    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!

    September 25, 2019 at 12:01 am #79675
    wzp
    Moderator

    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
    GeorgeK
    Member

    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!

    September 26, 2019 at 2:08 am #79677
    admin
    Keymaster

    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
    GeorgeK
    Member

    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!

    September 27, 2019 at 4:05 pm #79679
    wzp
    Moderator

    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
    GeorgeK
    Member

    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
Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Request a Plugin Update
  • Request Fresh Download Links
  • Contact Us

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • WP PDF Stamper Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Download Monitor

Copyright © 2022 | Tips and Tricks HQ