Using POS barcodes and also Google Shopping.

Solved
218gift
Tourist
10 0 7

Our existing online store is currently using Google Shopping and the Google app is actually working great at the moment! All of the main products we want for sale on Google are being displayed. Most of these items are clothing and pieces made within our state and in small batches so they don't have any GTIN numbers. Within each product listing, we just leave the barcode/GTIN field blank -- that allows the products to function and display correctly on Google Shopping through that app. (Products with made up barcodes, like ones that are too short, get denied so I just erase that field.)

My question/problem comes as we approach switching our existing brick-and-mortar retail store to the Shopify POS system. If we switch the existing in-store retail to the Shopify POS system we will probably use the multiple locations function within Shopify and split inventory between retail and online. We'll also probably use the Retail Barcode Labels app to print in-store labels for price tags. However, if we do that won't we need to then include a barcode input for each product so that the Barcode Printer app has something to pull from?

If I do that, won't my Google Shopping spreadsheet be altered and include that newly added barcode as a GTIN and then make all the Google Listings invalid?

Am I looking at this correctly or is there a different way that I can transition into the Shopify POS or a different way that I can edit my existing Google Shopping fields from my existing products?

Any help would be greatly appreciated. Thanks!  www.218gift.com

0 Likes
EmmanuelFlossie
Shopify Partner
981 40 219

This is an accepted solution.

If the barcodes are not actual barcodes from the product and if they are being pushed by the Google Shopping App. Then you can remove this info in Google Merchant Center, by going to Products > Feeds > click on the feed > feed rules

Here choose GTIN as the attribute and select clear

This will now remove the values submitted.

 

Hope this helps.

I'm a Google Shopping Specialist a a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!) and a Google Premier Partner
Need Premium Data Feed Management Support? Get in touch.
218gift
Tourist
10 0 7

I think this will work! Thanks so much for your expertise and help!

We're currently finally in the process of switching over to Shopify POS now. I will let you know how it all goes when it's all connected and I'll switch this question to "solved."

It took me a bit to find the "clear" setting so I'll breakdown your steps even more in case others have this issue:

After the steps you gave, inside the feed rules, I chose "gtin" (all lowercase) as the attribute. I then scrolled down to the Modifications section and hit "add modifications." From there I choose "advanced operators" and that gave me the "clear" operation. That ended up adding a "Clear gtinattribute" rule to my Shopify Google shopping app feed.

From there, you're able to test the rule and see how it affects your feed. My first try messed it all up, so I'm glad you can test it first! If you like the test results, just apply it. 

I'll let you know how it goes once the store is all set up and the edits to the feed are in place. Thanks again!

EmmanuelFlossie
Shopify Partner
981 40 219

Great work, glad I pushed you in a good direction! :)

I'm a Google Shopping Specialist a a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!) and a Google Premier Partner
Need Premium Data Feed Management Support? Get in touch.
0 Likes
218gift
Tourist
10 0 7

Ok. Update on this process.

Initially, when I added the POS barcodes to my products, I saw many of my products switch to "not approved" for the Google feed within the Shopify Google app. Which was understandable and expected because like I mentioned earlier, I am really only using the "barcode" so we can scan items in-store with the Shopify POS (which is working great). They are barcodes, sort of but not officially, and are used only in our brick-and-mortar. I knew the barcodes would not work for Google Merchant Center.

The problem is still with Google Merchant Center. I initially thought that the fix above (having Merchant Center clear the barcode field) was working. And I thought that even though the products within the Google Shopify app were tagged as "not approved," I thought that they were still being pushed into Merchant Center where they could have their barcode field cleared. So I thought "No big deal" that the Shopify app was not approving the products. But I don't think this is the case. I don't think the app is even pushing those products into Merchant Center at all.

I've watched the number of "approved products" inside Google Merchant Center drop from over 800 down to currently 131 (and still dropping). All of the products that had "barcodes" newly added in Shopify so they could function with the POS are now "not approved" inside the Google Shopify app and are not going into Merchant Center. The listings for those products that were previously inside Merchant Center and now expiring. I've watched hundreds of products expire this past month in Merchant Center. My theory is that since these products are no longer included with the Google API feed, since the app says they are not approved because of their barcode, they are not being updated/refreshed/re-synced in Merchant Center and expiring because of it.

Wow. Is there a way for this to work? Would changing my products to "custom products" in the Google listings overwrite the barcode thing? Most are items we make ourselves. Or could I use a different app to create my Google feed; would a different Shopify app give me more control over the fields it sends to Merchant center? 

EmmanuelFlossie
Shopify Partner
981 40 219

I recommend you contact Shopify, to see if they have a solution.

This is not something my application does. It pushes all products based on your own settings. For example you could exclude products, but these are not set by my application but by your own rules such as. Exclude if product type contains hidden.

 

My best suggestion is to contact support, then if there is no fix, use a different solution.

I'm a Google Shopping Specialist a a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!) and a Google Premier Partner
Need Premium Data Feed Management Support? Get in touch.
0 Likes
LiLi-5
Excursionist
19 0 8

Hi,

I am having the exact same issue, Shopify assigned the barcodes that are being kicked back by Google. 

Did you ever solve your problem? 

Many thanks! LiLi

0 Likes
EmmanuelFlossie
Shopify Partner
981 40 219

The solution is provided in the second post, if you are interested in resolving it for yourself.

I'm a Google Shopping Specialist a a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!) and a Google Premier Partner
Need Premium Data Feed Management Support? Get in touch.
0 Likes
218gift
Tourist
10 0 7

Hello! I guess I mostly solved the issue. But after doing the steps noted above, (having google exclude the barcode/GTIN) still many of my items expired within the Merchant Center about a month later. Not sure why or how. And honestly, it's been so long I've just settled on