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

Need Help with the Merchant Center Spreadsheet in a few areas.

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, this is my first attempt at the Google Merchant upload. I'm getting 2 item warnings when trying to upload a product spreadsheet.

 

1. "URL's do not belong to your website"  I correctly linked my shopify account with google using a meta link.

2. "Missing required attribute price" I originally put in "sale price attribute" would I still have to put in "price attribute?" If so, I'm not seeing an option.

 

Obviously my product is not showing up because of these errors "so I think!"

 

Any help to get back on the right path would be greatly appreciated.

2 Expert replyverified_user

Re: Need Help with the Merchant Center Spreadsheet in a few areas.

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) the link landing-page url within the submitted inventory data
must exactly match the claimed website url (domain) within the
merchant-center-account's general settings.

(2) price is always required; any additional sale_price information
must conform to all google's rules, both within the submitted data
and on the link landing-page.

that said, the best likely course would be to
simply contact shopify support directly --
https://docs.shopify.com/support

after items have been submitted properly and have
a searchable status, products may show within the
auctions based on the bid and quality factors --
such as the quality of all data submitted, click-through-rate,
link landing-page quality, the user's experience on the site,
product reviews, merchant reviews and ratings, etc.

only items with enough bid and quality
to win a slot in the auctions will be seen.

see also

https://support.google.com/merchants/answer/188486

https://support.google.com/merchants/answer/176793

https://support.google.com/merchants/answer/1344057

https://support.google.com/merchants/answer/188494

https://support.google.com/merchants/answer/1196048
https://support.google.com/adwords/answer/3455481

Re: Need Help with the Merchant Center Spreadsheet in a few areas.

Rising Star
# 3
Rising Star
Hello Charlie, you are better off using Shopify's Google Shopping APP, which allows you to automatically send all the data over.

However to answer your current question.
If you claim the site in Google Merchant it must be http://example.com and not http://example.myshopify.com

Sale price is essentially the special offer price. You need to always put in the base price, than if you are selling during a certain period for less. Than you need to use sale price and sale price effective date.
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’