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.
Hi @ziedigital ,
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.
All right, happy to hear that you find the solution!
Have you solved this problem?
Yes:)
Hi ziedigital,
Do you mean you replaced the content IDs with the SKU numbers on Shopify?
Not really, I replace the SKU numbers with content IDs in the feeding data
to match the product ID from shopify, we cannot edit the content id, I
think, which are owned by Shopify
Can you please tell how can I do the same?
