We have built store in shopify and I use Google sheet to upload and update the catalogue product feed in Facebook for advertising purpose, instead of other method like using Flexify.
In the Google sheet, I use sku for id and shopify might use content id for id therefore I am receive matching rate message like this:
May I change the feed data only to solve this without touch the installed pixel?
Thanks for your time, and any clue to help.
have you tried Pixel helper extension? It’s working in Chrome and you can just exactly what id is sent to Pixel.
You will probably find out that it’s a different number to SKU. Check it and them change the ids in your Google Sheet.
I replaced the values of ID with shopify content id then 2days later the match rate went back to normal.
while since I updated the loading in single file, I need to lookup the content ids matching the skus (which I used before as ids)
@Niki_K I tried pixel helper and could not find the way matching the 2 fields: content id (from Shopify) and id (SKU)from loading file.