How can I resolve a CSV import error on my online store?

LukasMcLean
Visitor
2 0 1

 

I tried to upload a csv file with products from a different shop I have (not Shopify). When I upload it I get this error: "Any value after quoted field isn't allowed in line 1."

 

I don't know how to fix it.

 

Replies 4 (4)

Ecommpremium
Shopify Partner
512 43 93

kindly open csv in excel and chage the csv format accordngly like by looking at exporting one shopify product of your store csv template so all values in the top should be same like handel id etc @LukasMcLean 

- Did we solve your issue? Like & Mark As Solution to help the community
- SKYPE: ahsanaliawan
- 300+ Video Tutorials
-Website

Ablestar_Daniel
Shopify Partner
95 13 17

Hi Lukas,

 

Could you check the CSV file and see if there's any extra spaces at the end of the lines? If a line looks like this most spreadsheet programs will open it but Shopify might reject it:

"Product title","Variant price"[SPACE]

If that doesn't work could you attach the first couple lines of the file and I can take a look?

Best,

Daniel

Founder @ Ablestar ✦
Manage product data, spreadsheets, Google Shopping data, and metafields with Ablestar Bulk Product Editor. Use previews, undos, and automations to be confident your product data is correct.
Please don't forget to Like and Mark Solution to the post that helped you. Thanks!
LukasMcLean
Visitor
2 0 1

I had a space at the start of the first line and deleted it and then shopify accepted the file, but I dont think this will work with my csv file. Once it loaded there was no product title neither a price. I guess I cant import it like this from my other shop.

 

These are the first lines:

 

 

 

XTSOL|"p_id"|"p_model"|"p_stock"|"p_sorting"|"p_startpage"|"p_startpage_sort"|"p_shipping"|"p_tpl"|"p_opttpl"|"p_manufacturer"|"p_fsk18"|"p_priceNoTax"|"p_priceNoTax.1"|"p_priceNoTax.2"|"p_priceNoTax.3"|"p_tax"|"p_status"|"p_weight"|"p_ean"|"code_isbn"|"code_upc"|"code_mpn"|"code_jan"|"brand_name"|"p_disc"|"p_date_added"|"p_last_modified"|"p_date_available"|"p_ordered"|"nc_ultra_shipping_costs"|"gm_show_date_added"|"gm_show_price_offer"|"gm_show_weight"|"gm_show_qty_info"|"gm_price_status"|"gm_min_order"|"gm_graduated_qty"|"gm_options_template"|"p_vpe"|"p_vpe_status"|"p_vpe_value"|"p_image.1"|"p_image.2"|"p_image.3"|"p_image"|"p_name.en"|"p_desc.en"|"p_shortdesc.en"|"p_checkout_information.en"|"p_meta_title.en"|"p_meta_desc.en"|"p_meta_key.en"|"p_keywords.en"|"p_url.en"|"gm_url_keywords.en"|"rewrite_url.en"|"p_name.de"|"p_desc.de"|"p_shortdesc.de"|"p_checkout_information.de"|"p_meta_title.de"|"p_meta_desc.de"|"p_meta_key.de"|"p_keywords.de"|"p_url.de"|"gm_url_keywords.de"|"rewrite_url.de"|"p_cat.en"|"p_cat.de"|"google_export_availability"|"google_export_condition"|"google_category"|"p_img_alt_text.en"|"p_img_alt_text.1.en"|"p_img_alt_text.2.en"|"p_img_alt_text.3.en"|"p_img_alt_text.de"|"p_img_alt_text.1.de"|"p_img_alt_text.2.de"|"p_img_alt_text.3.de"|"p_group_permission.0"|"p_group_permission.1"|"p_group_permission.2"|"p_group_permission.3"|"specials_qty"|"specials_new_products_price"|"expires_date"|"specials_status"|"gm_priority"|"gm_changefreq"|"gm_sitemap_entry"|"p_qty_unit_id"|"p_type"|"Zusatzfeld: OpelNr.: .de [3]"|"Zusatzfeld: OpelNr.: .en [3]"|"Zusatzfeld: Siemens - Teilenummer.de [5]"|"Zusatzfeld: Siemens - Teilenummer.en [5]"|"Zusatzfeld: Siemens - Nr..de [6]"|"Zusatzfeld: Siemens - Nr..en [6]"|"Zusatzfeld: TRW - Nr..de [7]"|"Zusatzfeld: TRW - Nr..en [7]"|"Zusatzfeld: Bosch - Nr. .de [8]"|"Zusatzfeld: Bosch - Nr. .en [8]"|"Zusatzfeld: Neu - Preis.de [9]"|"Zusatzfeld: Neu - Preis.en [9]"|"Zusatzfeld: Mercedes - Nummer.de [10]"|"Zusatzfeld: Mercedes - Nummer.en [10]"|"Zusatzfeld: Mobis - Nr..de [11]"|"Zusatzfeld: Mobis - Nr..en [11]"|"p_property_image_list_id"|"Zusatzfeld: Becker - Nr. .de [12]"|"Zusatzfeld: Becker - Nr. .en [12]"|"Zusatzfeld: Artikel Nr..de [13]"|"Zusatzfeld: Artikel Nr..en [13]"|"Zusatzfeld: Ersatz-Teilenr..de [14]"|"Zusatzfeld: Ersatz-Teilenr..en [14]"|"Zusatzfeld: Siemens Nr..de [15]"|"Zusatzfeld: Siemens Nr..en [15]"|"Zusatzfeld: Autoliv Nr..de [16]"|"Zusatzfeld: Autoliv Nr..en [16]"|"Zusatzfeld: BMW Nr..de [17]"|"Zusatzfeld: BMW Nr..en [17]"|"Zusatzfeld: Verfügbarkeit:.de [18]"|"Zusatzfeld: Verfügbarkeit:.en [18]"|"Zusatzfeld: Zustand:.de [19]"|"Zusatzfeld: Zustand:.en [19]"|"Zusatzfeld: Temic-Nr.de [20]"|"Zusatzfeld: Temic-Nr.en [20]"
XTSOL|"3"|""|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-07-14 13:20:34"|"2024-03-14 16:58:38"|"1000-01-01 00:00:00"|"557.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop.jpg"|""|""|""|""|""|""|""|""|""|"product-3"|""|"Mercedes-Benz C-Klasse W203/S203 - Simulator für defekte Sitzbelegungsmatte für alle C-Klasse Modelle"|"<span style=""font-size:14px
XTSOL|"11"|"20300"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"40.2521"|""|""|""|"1"|"1"|"0.0000"|""|""|""|""|""|""|"0.00"|"2016-08-05 04:18:35"|"2024-03-11 18:07:12"|"1000-01-01 00:00:00"|"143.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"bmw_sim_20300_11_0.jpg"|""|""|""|""|""|""|""|""|""|"product-10-11"|""|"BMW 3er E36 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px
XTSOL|"15"|"SitzSim_W463"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-08-06 06:41:00"|"2024-03-12 10:43:54"|"1000-01-01 00:00:00"|"129.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop_0.jpg"|""|""|""|""|""|""|""|""|""|"product-3-15"|""|"Mercedes-Benz G-Klasse W463 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px
XTSOL|"15"|"SitzSim_W463"|"0.0000"|"0"|"0"|"0"|"1"|"standard.html"|"default"|"0"|"0"|"50.3361"|""|""|"1:45.7563"|"1"|"1"|"1.0000"|""|""|""|""|""|""|"0.00"|"2016-08-06 06:41:00"|"2024-03-12 10:43:54"|"1000-01-01 00:00:00"|"129.0000"|"0.0000"|"0"|"1"|"0"|"0"|"0"|"1.0000"|"1.0000"|"default"|"0"|"0"|"0.0000"|""|""|""|"Sim_mercedes_allgemein_shop_0.jpg"|""|""|""|""|""|""|""|""|""|"product-3-15"|""|"Mercedes-Benz G-Klasse W463 - Simulator für defekte Sitzbelegungsmatte"|"<span style=""font-size:14px

 

 

BenSmith1
Excursionist
13 1 2

If you are still looking, take a look at Mixtable. Mixtable's Excel-like spreadsheet allows you to  import products to your Shopify store in bulk   from a convenient and familiar spreadsheet interface. You can also easily select which products to edit.