CSV upload for multiple products

[Subzero]

Please, Please Please help.

I have followed instructions for the plugins to ensure that I have done everything correct. I have used the sample CSV file and uploaded that so I could make this work. I have over 800 products to put up onto my website and I am looking for a reason why I keep getting error messages with next to no data in the CSV file….

Here is the error

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 (‘My Product1′,’10’,”,’no’,’6.5′,’10’,”,”,”,’Some Test Description for Product 1′)

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 (‘My Product2′,’15’,”,’no’,’6.5′,’10’,”,”,”,’Product2 Test Description’)

[amin007]

The CSV file seem to be missing any values after the “Description” field. Even if you don’t want to specify a value, those cells need to stay there.

This method might be easier for you:

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

[Author]

Posts