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

Question on product feed for state sales tax and shipping please

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Novice question setting up my first google feed, analytics, adwords and really struggling...

 

Hello,  

I am setting up my product feed and had a couple of issues and I am based out of the USA.

I am working in Excel to make the feed and will convert to the proper txt format when done.

 

If I want to charge sales tax of 7% only in Florida I would first make the attribute column "tax" and I would put for each product (I have 7) the following?:   US:FL:7:n   

 

If I charge 5 dollars flat rate for USPS PRIORITY shipping anywhere in the USA I would put the following?:

US:Smiley Tongueriority Shipping:5 USD

 

Are these correct?  and also...2 more ?

 

If I put these tax and shipping rates in my "settings" in the google merchant center can I just omit them from the feed entirely or should I do both?  and last one... my first attempted feed had tax errors as I used the wrong format but later added them to my settings in the merchant center. Should I just delete and upload it again or will google see the addition in the merchant center with the correct tax info?

 

Thanks so much for any help.

 

Angela

1 Expert replyverified_user

Re: Question on product feed for state sales tax and shipping please

[ Edited ]
Top Contributor
# 2
Top Contributor

 

(1) the tax and shipping shown look correct for those scenarios;

(2) feed values override account-settings;

(3) changes require re-uploading.


given flat shipping and tax for all items within the data-feed,
the easiest likely solution would be to simply set the default
shipping and tax within the merchant-center-account and then,
delete the shipping and tax columns altogether from the feed
(spreadsheet) -- then, re-save and resubmit the data-feed file.

 

generally, any change to the feed or account requires a re-upload.

many spreadsheets add quotes around cell values simply by re-saving a file --
quotes, by default, are not allowed; the effect of quotes can be checked by
viewing the re-saved .txt (feed) file within a browser-window and verifying
the use-quoted-fields settings in the data-feeds-tab of the merchant-center.

assuming no quotes in the saved .txt file and the proper quoted
settings, then those tax and shipping values both look correct.

three colons and no quotes (after re-saving) are required for both values.

but again, given the potential spreadsheet issues for such values,
simply setting a default within the account and deleting the columns,
is the best likely solution -- unless an override for a specific item
is required.

a tax value, set within the feed-file (cell) for an item, will override
any tax information set within the account, for that specific item --
the same for shipping; to use an account-level setting, the (cell)
value for tax (or shipping) in the spreadsheet must be entirely

blank (entirely empty) or the column deleted.

see also
https://support.google.com/merchants/answer/160162
https://celebird-cloud.appspot.com/com/cktaxship?tax=US%3AFL%3A7%3An&shipping=US%3A%3APriority+Shipp...