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

Trouble importing products with CSV to DB

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Trouble importing products with CSV to DB

Tagged: csv to db, importing, spreadsheet

  • This topic has 14 replies, 5 voices, and was last updated 13 years, 3 months ago by admin.
Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • January 21, 2011 at 6:34 pm #2553
    chipcherry
    Member

    Warning: fopen(/usr/local/apache/htdocs/~chip/wp-content/plugins/wp-csv-to-db/uploads/test3.csv) [function.fopen]: failed to open stream: No such file or directory in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 46

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    ****** I have checked file permissions on the plugin files, I have reinstalled estore, and the csv to db plugin several times. I have striped the csv file to a simple test product and have gotten the same results. I checked with my host company and they were unable to determine what may be happening. I have gone through 3 separate forum postings you have on this topic, and was unable to reach a resolution. I greatly appreciate your assistance.

    January 22, 2011 at 4:54 am #28291
    amin007
    Participant

    What value do you have in the “Specify the file URL” field of the CSV to DB plugin?

    January 24, 2011 at 5:58 pm #28292
    chipcherry
    Member

    http://173.192.239.159/~chip/wp-content/plugins/wp-csv-to-db/uploads/test3.csv

    January 25, 2011 at 7:22 am #28293
    amin007
    Participant

    That looks like a temporary URL to me. You don’t have you site live yet? I have updated the plugin slightly to use absolute path to open the file. Lets see if that helps at all. Can you download a new copy of the plugin from here and give it a go:

    http://www.tipsandtricks-hq.com/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116

    Don’t forget to deactivate and delete the old copy first.

    January 25, 2011 at 8:50 pm #28294
    chipcherry
    Member

    Warning: fopen(/usr/local/apache/htdocs/~chip/wp-content/plugins/wp-csv-to-db/uploads/test3.csv) [function.fopen]: failed to open stream: No such file or directory in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 46

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    Warning: feof(): supplied argument is not a valid stream resource in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 49

    Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/chip/public_html/wp-content/plugins/wp-csv-to-db/wp-csv-to-db.php on line 51

    ********** Yes this is a temp url, we have the existing site hosted elsewhere on a different platform.

    I downloaded the new file, deactivated and deleted the existing plug in, reinstalled and got these new errors.

    Thank you for all of your help!

    January 26, 2011 at 4:10 am #28295
    amin007
    Participant

    Lets try using a relative URL. Please enter the following value in the “Specify the file URL” field and hit save location:

    uploads/test3.csv

    Now try to import it.

    January 26, 2011 at 11:02 pm #28296
    chipcherry
    Member

    Same error. I apologize I didn’t include that, we have tried removing every file level one at a time.

    I did reattempt specifically uploads/test3.csv, and received the same error.

    Thank you for all of your help!

    January 27, 2011 at 5:32 am #28297
    amin007
    Participant

    I will take a look at your site. I have sent you an email.

    April 6, 2011 at 10:09 pm #28298
    Rinaldo
    Member

    I am really sorry to bother you everyday with new problems: My import allegedly worked well, except that there are no new products in the Manager!?

    Thanks!

    April 7, 2011 at 2:01 am #28299
    amin007
    Participant

    LOL… have you changed the database prefix of your WordPress installation? Did you first try importing the two test products from the “products.csv” file to see if it works or not?

    April 7, 2011 at 7:43 am #28300
    Rinaldo
    Member

    Yes, I just tested with sample products – same result – successfully imported, but no new products in PM.

    No, I have not yet changed the table prefix.

    ?

    Thanks!

    April 8, 2011 at 5:36 am #28301
    amin007
    Participant

    I have sent you an email to get site access so I can check it out.

    April 9, 2011 at 1:22 am #28302
    amin007
    Participant

    I had a look at your CSV to DB plugin settings and it looks like you didn’t specify the values in the “Database Column Names” field.

    According to the instruction you are suppose to enter the following in the “Database Columns Names” field:

    name,price,product_download_url,downloadable,shipping_cost,available_copies,button_image_url,return_url,sales_count,description,thumbnail_url,variation1,variation2,variation3,commission,a1,p1,t1,a3,p3,t3,sra,srt,ref_text,paypal_email,custom_input,custom_input_label,variation4,aweber_list,currency_code,target_thumb_url,target_button_url,weight,product_url

    How to Bulk Upload eStore Products from a CSV File

    Please do exactly what the instruction says.

    March 1, 2012 at 8:50 am #28303
    dwilkes
    Member

    I am getting the error “There was an error uploading the file, please try again!” when trying to upload my .csv products file using wp-admin settings (csv To DB) on my website “http://www.stbedes.school.nz” I think I have followed all instructions correctly.

    March 1, 2012 at 10:15 pm #28304
    admin
    Keymaster

    Please see this video tutorial then use the technique explained there and you won’t have any issue importing content into a database table:

    http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 15 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

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

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform 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
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

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

Copyright © 2025 | Tips and Tricks HQ