- This topic has 1 reply, 2 voices, and was last updated 11 years, 9 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
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
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′, ”,”,”,”,”,”,”,”)
Hi, please watch the video tutorial on this page and follow the instructions: