AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
1.7K members online now
1.7K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Too many column delimiters

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello to all I hope you are having a great New Year I am a lot of thing's in my life are changing for the better.Anyhow my question is this for any one who can possibly help me Please. I am trying to add a product to Google search through : Google Merchant Center .... I have tried using the Google Spreadsheets to make this with no luck. So I downloaded it as a CSV file then opened my editor ( open office ) made corrections then uploaded the csv file to the data feeds section manually. Kept having many errors but I have been able to correct most using the built in debugger. But I am stuck with one last error: " Line 2 Too Many Column Delimiters." Also notes : "Your item contains more attributes to those in the header row"

 

I also have only 1 warning which states: "Too few sub-attributes for attribute : Shipping.

Also notes: " Please make sure the attribute includes the correct number of sub-attributes. All colons for sub-attributes , even for blank attributes, are required 

 

I have copied the debugging console which includes all text I am seeing and was wondering if anyone can have a look at this and if you have any suggestions or fixes please let me know.

 

 

 

id,title,description,condition,price,availability,link,image link,gtin,mpn,brand,google product category,gender,age group,size,color,mateiral,pattern,item group id,tax,shipping,shipping weight,sale price,sale price effective date,additional image link,product type
"1634,Electronics>Computers>Desktops",Dell OptiPlex 755 SFF Desktop Computer ,CPU:Intel Core 2 Duo Processor 2.33 GHz RAM: 2GB RAM HDD:80GB Hard Drive Operating System:Genuine Windows 7 Pro 64 bit,- Refurbished ,149.99:USD:, 'in stock' :,https://www.247virusremovers.com/store/c1/Featured_Products.html,https://www.247virusremovers.com/up... Computers",,,,,,,US:8.99,,US:30.00, US:FL:USPS,20:,,,https://www.247virusremovers.com/store/c1/Featured_Products.html,"1634,Electronics>Computers>Desktop...

 

 

 

 

Thanks for Helping 

Richard B 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September 2015

Re: Too many column delimiters

[ Edited ]
Top Contributor
# 2
Top Contributor


generally, a currently supported feed format should be submitted --
try re-saving the file as tab-delimited and be certain the feed was
registered as a .txt tab-delimited format.

the legacy csv format is not currently documented as supported
and may or may not properly process depending on the details.
https://support.google.com/merchants/answer/160567

more generally, values should not contain quotes,
commas, stray spaces, or stray marks of any kind; e.g.
refurbished<delimiter>
not
- Refurbished <delimiter>

for the (unsupported) csv remove all commas
from the description or within any other value.

also, verify the use-quoted-fields settings within the account.

quotes, commas, and values that are split across multiple lines
are the most likely triggers for delimited-related issues --
remove commas, remove quotes, and verify each item is on
one, single, contiguous, line without any breaks; especially
for the description attribute.

more generally, always view the file within a browser window

just before uploading -- to verify there are no quotes, commas,

stray marks, stray symbols, css, javascript, html, or any breaks

within values, that might have been added by the spreadsheet

simply by re-saving the file.

 

of course, if a .txt tab-delimited feed is used

the commas can remain within the values --

but the other characters can still cause issues.

 

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by MosheTLV (Top Contributor)
September 2015

Re: Too many column delimiters

[ Edited ]
Top Contributor
# 2
Top Contributor


generally, a currently supported feed format should be submitted --
try re-saving the file as tab-delimited and be certain the feed was
registered as a .txt tab-delimited format.

the legacy csv format is not currently documented as supported
and may or may not properly process depending on the details.
https://support.google.com/merchants/answer/160567

more generally, values should not contain quotes,
commas, stray spaces, or stray marks of any kind; e.g.
refurbished<delimiter>
not
- Refurbished <delimiter>

for the (unsupported) csv remove all commas
from the description or within any other value.

also, verify the use-quoted-fields settings within the account.

quotes, commas, and values that are split across multiple lines
are the most likely triggers for delimited-related issues --
remove commas, remove quotes, and verify each item is on
one, single, contiguous, line without any breaks; especially
for the description attribute.

more generally, always view the file within a browser window

just before uploading -- to verify there are no quotes, commas,

stray marks, stray symbols, css, javascript, html, or any breaks

within values, that might have been added by the spreadsheet

simply by re-saving the file.

 

of course, if a .txt tab-delimited feed is used

the commas can remain within the values --

but the other characters can still cause issues.