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
2.3K members online now
2.3K 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 on shipping attribute

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

We're using a tab delimited product feed in the google merchant centre.  Currently we use the shipping rules for all our products, but we have some new products that will always have free shipping so we need to use the 'shipping' attribute to override the rules for those specific products.

 

I am currently trying to get this to work but am getting the following error when the feed is imported:

 

Too many column delimiters

Your items contain more attributes than those specified in the header row

 

We have tried several combinations including:

Header row desc: shipping

Shipping Desc: GB::Next Day:0.00 GBP (with and without quotes)

 

Header row desc: shipping(country:serviceSmiley Tonguerice)

Shipping Desc: GB:Next Day:0.00 GBP (without quotes - "too many delimiters")

Shipping Desc: GB:Next Day:0.00 GBP (with quotes - "too few delimiters")

 

Feed settings are:

 

Delimiter:
Autodetect
Use Quoted Fields

 

Any idea what the problem is?

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author john m
October 2015

Re: Too many column delimiters on shipping attribute

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Removed the quotes, and the spaces, and it worked.

View solution in original post

Re: Too many column delimiters on shipping attribute

[ Edited ]
Top Contributor
# 2
Top Contributor

Header : shipping(countrySmiley Tonguerice)
Value : GB:0.00 GBP

 

This should work

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

Re: Too many column delimiters on shipping attribute

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

shipping(countrySmiley Tonguerice)
GB:0.00 GBP

 

"Too few subattributes for attribute:shipping

Please make sure that the attribute includes the correct number of subattributes. All colons between subattributes, even for blank values, are required."

Marked as Best Answer.
Solution
Accepted by topic author john m
October 2015

Re: Too many column delimiters on shipping attribute

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Removed the quotes, and the spaces, and it worked.