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

Bulk upload using WP CSV to DB produces an error

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › Bulk upload using WP CSV to DB produces an error

Tagged: bulk upload, bulk upload csv

  • This topic has 1 reply, 2 voices, and was last updated 12 years, 2 months ago by wpCommerce.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • February 21, 2013 at 12:01 pm #8616
    snowdonkiwi
    Member

    I tried to do a bulk upload of products into estore using WP CSV to DB v1.8 and got an error. Then I tried to upload a csv with just one line. This is what I got. I am not super technical so please keep the response as simple as possible:-)

    Error occured while trying to import!

    Insert into the Database failed for the following Query:

    INSERT INTO wp_wp_eStore_tbl (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) VALUES (‘1. Stress free journey’,’8′, ‘as3tp://alkimea.s3.amazonaws.com/beat jet lag/1. stress-free journey.mp3′,’yes’,”,”,”,”,”, ‘Some Test Description for Product 1’, ‘http://www.alkimea.co/wp-content/uploads/2013/02/icon-256-jetlag-1.png’, ”,”,”,”,”,”,”,”,”,”,”,”,”,”,’0′, ”,”,”,”,”,”,”,”)

    February 21, 2013 at 10:05 pm #53986
    wpCommerce
    Moderator

    Hi, please watch the video tutorial on this page and follow the instructions:

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

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 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