Re: Data Source URL for Pinterest Catalog

How can I successfully upload my data source to Pinterest Catalog?

homadestudio
Tourist
7 0 2

Hello, this is cross posted in the tech thread, too. I'm not very tech savvy so I'm looking for some assistance. I am trying to upload my date source to Pinterest to create a catalog. Do I just use the format "yourshopname.com/collections/all.atom?  My report status keeps saying failed. I went and checked the errors and I don't see what the problem is. Maybe I'm doing it wrong?

 

Thanks in advance.


Donna

Homadestudio.com

Replies 56 (56)

gigi12
Visitor
1 0 0

i'm having the same issue

Jim_West
Explorer
78 1 65

This worked for me

 

https://YOURSTOREURL/collections/all.atom

 

Then select CSV and no password

tslife
Explorer
44 2 12

@Jim_West 

 

Do you mean the Shopify URL or the domain URL?

 

XX.myshopify.com?

Twentyfivefifty
Tourist
4 0 0

@Jim_West wrote:

This worked for me

 

https://YOURSTOREURL/collections/all.atom

 

Then select CSV and no password



I did this and made some headway. But got a response that 25 (seemingly random) products had errors that didn't allow the catalog to upload. The errors listed don't make much sense either since they claim there is no product description is missing in the metadata, link is missing from metadata, image link is missing from metadata, and so on.... Again, there is no rhyme or reason as to how these specific products are picked out. I don't understand why it isn't the whole catalog with these issues. Only 25 products. Thoughts on why this would be? Have you had similar issues after you used your data source URL?

tslife
Explorer
44 2 12

@Twentyfivefifty 

 

Did you use the Shopify URL or your domain URL?

 

xx.myshopify.com or your domain URL?

Twentyfivefifty
Tourist
4 0 0

Domain URL. I'm wondering if the issue I'm having is related to that though. 

tslife
Explorer
44 2 12

I tried the Shopify url and that one didn't work at all. I'll know tomorrow if the domain one works for me. 

tboone8
Visitor
2 0 1

The exact same thing just happened to me.  25 errors for no reason that's preventing me from using this service.  Did you figure out what was causing that issue?


@Twentyfivefifty wrote:

@Jim_West wrote:

This worked for me

 

https://YOURSTOREURL/collections/all.atom

 

Then select CSV and no password



I did this and made some headway. But got a response that 25 (seemingly random) products had errors that didn't allow the catalog to upload. The errors listed don't make much sense either since they claim there is no product description is missing in the metadata, link is missing from metadata, image link is missing from metadata, and so on.... Again, there is no rhyme or reason as to how these specific products are picked out. I don't understand why it isn't the whole catalog with these issues. Only 25 products. Thoughts on why this would be? Have you had similar issues after you used your data source URL?


 

Twentyfivefifty
Tourist
4 0 0

Nope. I did contact Shopify support and got the usual "send us screenshots and here's some articles to read". I haven't had the time to get them screenshots or read the same articles I already read (that seriously need updating). I've been meaning to contact Pintrest directly, but from their help community articles it seems they just want you to make "pins" for each product but customers can't buy from Pins. Still don't understand the '25' products thing either. I'll try to contact them this weekend and see what the response is. Additionally, I'll try to get with Shopify again as well. I just don't understand why they don't have a straight answer for this issue. We're not the only ones with this problem are we? I think I'll shout out to some facebook groups to see if anyone else has managed to push through this issue already. I'll post my results here. It would be appreciated if all did the same.

tboone8
Visitor
2 0 1

I reached out to Pinterest and they said to talk to Shopify...  I will do that, but I doubt that will go anywhere

tslife
Explorer
44 2 12

@USMenshop 

 

This has nothing to do with the issue at hand - we are discussing catalogs, not rich pins. 

unplugged
Excursionist
17 0 8

I am still looking for some help on this.  I have used this code to work on other feeds but for some reason Pinterest is giving me an error. 

Here is what i have done using the code i used for other feeds, with a minor pinterest change (again this is not working, and maybe someone sees the error);

 

1- Make a new Collection called 'Pinterest Feed' - Make sure you add in ALL products that have inventory

2- Make a new Template collection.pinterest.feed.liquid

3- add the following code (Note the Google product Category will need to be built out based on your shops needs)

{% layout none %}<?xml version=“1.0”>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
{%- paginate collection.products by 1000 -%}
<channel>
{%- for product in collection.products -%} 
  {%- if product.variants.size > 0 -%}
  {%- for variant in product.variants -%}
<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:link>{{ shop.url }}{{ variant.url }}</g:link>
<g:item_group_id>{{ product.id }}</g:item_group_id>
  <g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:condition>new</g:condition>
  <g:Size_Type>regular</g:Size_Type>
<g:image_link>https:{% if variant.image.src %}{{ variant.image.src | product_img_url: 'grande' }}{% else %}{{ product.featured_image.src | product_img_url: 'grande' }}{% endif %}</g:image_link>
{%- if product.type contains "Kids" -%} <g:agegroup>kids</g:agegroup>
  {% else %} <g:age_group>adult</g:age_group>
  {% endif %}
  <g:gtin>{{ variant.barcode }}</g:gtin>
  {%- if product.type contains "Women" -%}<g:gender>Women</g:gender>
  {%- elsif product.type contains "Men" -%}<g:gender>Men</g:gender>
  {% else %} <g:gender>Unisex</g:gender>
  {% endif %}
<g:mpn>{{ variant.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>
<g:google_product_category></g:google_product_category>

  </item>
  {% endfor %}
  {% else %}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:item_group_id>{{ product.id }}</g:item_group_id>
<g:condition>new</g:condition>
  <g:Size_Type>regular</g:Size_Type>
  <g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:image_link>https:{{ product.featured_image.src | product_img_url: 'grande' }}</g:image_link>
  {%- if product.type contains "Kids" -%} <g:age_group>kids</g:age_group>
  {% else %} <g:age_group>adult</g:age_group>
  {% endif %}
<g:gtin>{{ product.barcode }}</g:gtin>
   {%- if product.type contains "Women" -%}<g:gender>Women</g:gender>
  {%- elsif product.type contains "Men" -%}<g:gender>Men</g:gender>
  {% else %} <g:gender>Unisex</g:gender>
  {% endif %}
<g:mpn>{{ product.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>
<g:google_product_category> </g:google_product_category>
  </item>
  {% endif %}
{% endfor %}
</channel>
</rss>
{% endpaginate %}

 4- In your collection page change the template to the new Pinterest collection you have created.

 

In theory this should work, as it works with other feeds I currently use. However, i get the same error "Your Feed file has an XML formatting issue. Make sure you are missing a tag"

 

If anybody can see what i am missing that would be super helpful and it will solve everybody's issue here as well.

 

thanks.

unplugged
Excursionist
17 0 8

Ok I solved it. Had one small issue i overlooked. This now 100% works for me. You will need to add in your proper Google Product Categories based on how you store functions.

 

1- Make a new Collection called 'Pinterest Feed' - Make sure you add in ALL products that have inventory

2- Make a new Template collection.pinterest.feed.liquid

3- add the following code (Note the Google product Category will need to be built out based on your shops needs)

 

{% layout none %}<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
{%- paginate collection.products by 1000 -%}
<channel>
  <title>Pinterest Date Feed</title>
  <link>[Your Store NAME]</link>
  <description>Feed for Pinterest catalog</description>
{%- for product in collection.products -%} 
  {%- if product.variants.size > 0 -%}
  {%- for variant in product.variants -%}
<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
 <g:price>{{ variant.price | money_without_currency }} USD</g:price>
  <g:link>{{ shop.url }}{{ variant.url }}</g:link>
<g:item_group_id>{{ product.id }}</g:item_group_id>
  <g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:condition>new</g:condition>
  <g:Size_Type>regular</g:Size_Type>
<g:image_link>https:{% if variant.image.src %}{{ variant.image.src | product_img_url: 'grande' }}{% else %}{{ product.featured_image.src | product_img_url: 'grande' }}{% endif %}</g:image_link>
{%- if product.type contains "Kids" -%} <g:agegroup>kids</g:agegroup>
  {% else %} <g:age_group>adult</g:age_group>
  {% endif %}
  <g:gtin>{{ variant.barcode }}</g:gtin>
  {%- if product.type contains "Women" -%}<g:gender>female</g:gender>
  {%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
  {% else %} <g:gender>unisex</g:gender>
  {% endif %}
<g:mpn>{{ variant.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "xxxx" -%}
<g:google_product_category>xxxxxxx</g:google_product_category>
{%- elsif product.type == "xxxxx"-%}<g:google_product_category>xxxxxx</g:google_product_category>
{% endif %}

  </item>
  {% endfor %}
  {% else %}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:price>{{ product.price | money_without_currency }} USD</g:price>
  <g:item_group_id>{{ product.id }}</g:item_group_id>
<g:condition>new</g:condition>
  <g:Size_Type>regular</g:Size_Type>
  <g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:image_link>https:{{ product.featured_image.src | product_img_url: 'grande' }}</g:image_link>
  {%- if product.type contains "Kids" -%} <g:age_group>kids</g:age_group>
  {% else %} <g:age_group>adult</g:age_group>
  {% endif %}
<g:gtin>{{ product.barcode }}</g:gtin>
   {%- if product.type contains "Women" -%}<g:gender>female</g:gender>
  {%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
  {% else %} <g:gender>unisex</g:gender>
  {% endif %}
<g:mpn>{{ product.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "xxxx" -%}
<g:google_product_category>xxxxxxx</g:google_product_category>
{%- elsif product.type == "xxxxx"-%}<g:google_product_category>xxxxxx</g:google_product_category>
{% endif %}

  </item>
  {% endif %}
{% endfor %}
</channel>
</rss>
{% endpaginate %}

 4- In your collection page change the template to the new Pinterest collection you have created.

5- Go to pinterest and submit your new XML feed and wait 24 hours. 

6- Enjoy.

homadestudio
Tourist
7 0 2
I certainly hope this works...I’m not super tech savvy so can you explain a little more what you mean about the google product category needing to be built out?
unplugged
Excursionist
17 0 8

Well it's actually two things that are store specific based on the code i wrote.  The Gender tag and the Google Product Category tag.

 

How I have done it is to use the 'Product Type' and map it to the Google Product Category.  The one problem is, if you have a lot of products this is time consuming to map out. Hopefully you would only need to do it once.  If you add additional Product Types later you would need to update this.  I would not be able to answer how to do this, as it is store specific on how you named all your Product Types.  It is possible to do this via tags as well, if your product types are not that gradular.

 

The gender tag is also store specific, as I mapped this our via 'Product Type' as well. If all your product types are not mapped out with gender specific verbiage, you can always do this via tags.   Unlike the Google Product Category Tag this tag is not mandatory for pinterest (it will give you an alert, not an error). However this is a very important tag if you want to market directly to women/men. With Pinterest being heavily used by women over men, it makes sense to have this tag properly installed so you can save money in marketing costs. 

lntramel
Visitor
1 0 0

 


@unplugged wrote:

Well it's actually two things that are store specific based on the code i wrote.  The Gender tag and the Google Product Category tag.

 

How I have done it is to use the 'Product Type' and map it to the Google Product Category.  The one problem is, if you have a lot of products this is time consuming to map out. Hopefully you would only need to do it once.  If you add additional Product Types later you would need to update this.  I would not be able to answer how to do this, as it is store specific on how you named all your Product Types.  It is possible to do this via tags as well, if your product types are not that gradular.

 

The gender tag is also store specific, as I mapped this our via 'Product Type' as well. If all your product types are not mapped out with gender specific verbiage, you can always do this via tags.   Unlike the Google Product Category Tag this tag is not mandatory for pinterest (it will give you an alert, not an error). However this is a very important tag if you want to market directly to women/men. With Pinterest being heavily used by women over men, it makes sense to have this tag properly installed so you can save money in marketing costs. 



Hello. I am not sure if I "Built the Google Out" Can you look at what I wrote? I think I may have done it wrong. I have 6 product types so I am not sure how elseif works when theres more than 2 options. Thank you in advance. 

 

<!-- /templates/collection.liquid -->
{% comment %}
The contents of the collection.liquid template can be found in /sections/collection-template.liquid
{% endcomment %}

{% section 'collection-template' %}

{% layout none %}<?xml version="1.0" encoding="UTF-8"?>

 

<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
{%- paginate collection.products by 1000 -%}
<channel>
<title>Pinterest Data Feed</title>
<link>https://sid-sam.myshopify.com/</link>
<description>Feed for Pinterest catalog</description>

{%- for product in collection.products -%}
{%- if product.variants.size > 0 -%}
{%- for variant in product.variants -%}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:price>{{ variant.price | money_without_currency }} USD</g:price>
<g:link>{{ shop.url }}{{ variant.url }}</g:link>
<g:item_group_id>{{ product.id }}</g:item_group_id>
<g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:condition>new</g:condition>
<g:Size_Type>regular</g:Size_Type>
<g:image_link>https:{% if variant.image.src %}{{ variant.image.src | product_img_url: 'grande' }}{% else %}{{ product.featured_image.src | product_img_url: 'grande' }}{% endif %}</g:image_link>
{%- if product.type contains "Kids" -%} <g:agegroup>kids</g:agegroup>
{% else %} <g:age_group>adult</g:age_group>
{% endif %}
<g:gtin>{{ variant.barcode }}</g:gtin>
{%- if product.type contains "Women" -%}<g:gender>female</g:gender>
{%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
{% else %} <g:gender>unisex</g:gender>
{% endif %}
<g:mpn>{{ variant.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

 

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "tops" -%}
<g:google_product_category>194</g:google_product_category>
{%- elsif product.type == "bottoms"-%}<g:google_product_category>204</g:google_product_category>
{% endif %}

 

</item>
{% endfor %}
{% else %}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:price>{{ product.price | money_without_currency }} USD</g:price>
<g:item_group_id>{{ product.id }}</g:item_group_id>
<g:condition>new</g:condition>
<g:Size_Type>regular</g:Size_Type>
<g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:image_link>https:{{ product.featured_image.src | product_img_url: 'grande' }}</g:image_link>
{%- if product.type contains "Kids" -%} <g:age_group>kids</g:age_group>
{% else %} <g:age_group>adult</g:age_group>
{% endif %}
<g:gtin>{{ product.barcode }}</g:gtin>
{%- if product.type contains "Women" -%}<g:gender>female</g:gender>
{%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
{% else %} <g:gender>unisex</g:gender>
{% endif %}
<g:mpn>{{ product.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

 

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "accessories" -%}
<g:google_product_category>166</g:google_product_category>
{%- elsif product.type == "shoes"-%}<g:google_product_category>187</g:google_product_category>
{% endif %}

</item>
{% endif %}
{% endfor %}
</channel>
</rss>
{% endpaginate %}

MikeDeveloper
Visitor
2 0 0

I am not much into google product category stuff. Can someone explain how can I add that? or is there any document? Where I need to setup google product category?

MikeDeveloper
Visitor
2 0 0
What should be final url to submit on data source? i Have tried storename,com/collections/pinterest-feed. but its not working because url should be on xml format. Can anyone help me with this?
unplugged
Excursionist
17 0 8

Yes your url should just be page if you are doing it how I instructed. 

 

example - https://YOURSTORE.com/collections/pinterest-feed

 

if you go to this page yourself.. you should see text only populate.  If you have a lot of products lets say over 500, you maybe having an issue with it fully loading.

otterkeeper
Visitor
1 0 0

If i use just the URL as stated https://MYSTORE.com/collections/pinterest-feed and XML as the type for Pinterest, I get an error stating that "Catalogs doesn't support your file type" and "Currently, Catalogs only supports the following file types: comma-separated (.CSV), tab-separated (.TSV) and extensible markup language (.XML). Save your file as one of these types and try your upload again."

 

I did the .liquid page as instructed and if i navigate to the page it just returns text. Please help with how to upload this to Pinterest. Thanks.

BigABandStore
Tourist
5 0 2

Hi, I am having exactly the same problem as other people on here - I'm verified on the Merchant Program ok but it won't upload the catalogue - I get the same message as other people with 25 products with errors. I have no clue how to fix these errors.

Someone mentioned that this thread is not about rich pins but this is how Pinterest have told me to get rich pins to work (product pins specifically). When I verify a product URL from my website it pulls through the product details (cost, availability etc) but this doesn't show on the actual pin. 

I have contacted Pinterest who reply but with unhelpful information. I have pointed out to them that their help pages are out of date but they're not interested! 

Is there a way to fix this that doesn't involve complex coding? I am totally lost looking at the coding advice here! Is there anyway that I can export my Shopify product data as a spreadsheet file and fix the data manually before uploading to Pinterest? Also how would this work in terms of dynamic info such as stock availability and new products?

Please help, am finding the Shopify/Pinterest experience really frustrating!

 

BigABandStore
Tourist
5 0 2

Not sure if anyone is still following this thread but... I may have a solution that doesn't involve coding.

If you add Google as a sales channel and try to upload your products it'll have 25+ that can't be uploaded because they are missing the required product data. I am assuming this is the same data that is missing when Pinterest tries to upload a standard Shopify catalogue.

If you follow these instructions it shows you how to add this data within the Google Shopify app (no coding - I hope) https://help.shopify.com/en/manual/promoting-marketing/create-marketing/google/syncing-products

I'm adding this data now and hopefully when Pinterest tries to upload my products again it should work... fingers crossed!

tslife
Explorer
44 2 12
What are you using for the data url on Pinterest?
BigABandStore
Tourist
5 0 2
thelondonlabel
Visitor
1 0 0

how did it go for you? All my products are correctly uploaded onto my google shopping, but i'm still having the same problem with pinterest

Samantha_Hoang
Visitor
1 0 0

Did it work?

BigABandStore
Tourist
5 0 2

Unfortunately not - I have 26 products approved by Google now but my Shopify catalogue is still failing to upload to Pinterest. 

I've contacted Pinterest several times and they are so unhelpful. It's got to the point that their recent emails just don't even make sense!

I'm hoping that when the Pinterest Shopify App is available to UK users that this will fix the problem....

creampuff
Visitor
2 0 0

I came across this problem too and tried adding .atom at the end of my shopify URL for the data source URL for Pinterest. It seemed to work at first except for the 25 error links that other people have mentioned. Then I tried to save the CSV from Shopify to my Dropbox, and use the URL from there, but that didn't work. Then I looked for the a Pinterest-compatible app (I can't use the Pinterest app because I'm based in the UK), and then saw some product feed apps like these  https://apps.shopify.com/product-feeds-generator?surface_detail=pinterest&surface_inter_position=2&s... and one called GMC Feed that I downloaded, it then generated a URL that I copied into Pinterest and the link seems to have been accepted. Now I have to wait 24-48 hours to see if it actually worked. Either way, it looks like there are apps out there than can generate product feeds for you to just copy the link to wherever you want the feed.

Maisiezz
Visitor
2 0 0

omg you lifesaver! GMC is working! for 200 feeds only but enough for now.

FINALLY!

tslife
Explorer
44 2 12

I have almost 1000 products. We shouldn't have to pay for GMC to have a working way to get Pinterest to recognize Shopify feeds. 

creampuff
Visitor
2 0 0
I know, but if we don’t know how to host a CSV file on an FTP and link it to Pinterest, this is the next best solution it seems. But yes it should be a lot easier than this and apps shouldn’t be able to profit from this.
unplugged
Excursionist
17 0 8

you need to get the google product category txt document from google and assign categories to products. Simple as that.

 

This cannot be done without that.

Andrea_Csiszlak
Visitor
1 0 0

I'm following along here and trying to understand all of this. I don't understand though where to find the google product category txt document from to set up the new template. While I'm at it...I'm not so good with code at all. If anyone has time to help I would greatly appreciate it. Thank you!

EssentialBeing
Visitor
2 0 0

Hi! I am stuck on this last step as well. I have Broklyn theme if that helps. Do I need to install an app in shopify? Need to write code? is there a template somewhere? I'm really unsure about mapping product types to google product categories. All the help is appreciated!!!!

RegalPhoenix
Tourist
3 0 3

I'm responding again bc my Pinterest profile was selected for their marketing partner program so I got a chance to ask a Pinterest expert about this. Their integrations with Shopify are in beta phase and are closed, that's why nothing works and you can't get answers. 

My catalog still isn't connected and I have to wait until they open beta testing again to even try or get help with it.

This doesn't mean there isn't a work around, it just means you all aren't crazy, it doesn't work.

I literally pinned every product from my site to my profile when I first opened my store. That works just as well bc the pins are shoppable.

EssentialBeing
Visitor
2 0 0
Thank you! This information is very helpful! When you say pinned your products, do you mean you created a new pin from add pin button within the app or did you use the pin it button on your website to add pin to your profile?
RegalPhoenix
Tourist
3 0 3
I used the Pin it button on my website to create pins on my profile! I have
the boards to match the categories and make sure each Pin is linked back to
my site. You can click the tag to make sure it shows up as a product.
Rhand
Tourist
3 0 1

Still working on the code given by contributor. Here is the code that needs updating to deal with category and or other errors:

 

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "xxxx" -%}
<g:google_product_category>xxxxxxx</g:google_product_category>
{%- elsif product.type == "xxxxx"-%}<g:google_product_category>xxxxxx</g:google_product_category>
{% endif %}

We have several product categories which we looked up at https://www.google.com/basepages/producttype/taxonomy-with-ids.en-US.txt

 

  • Foot Powders 3049 Health & Beauty Personal Care Foot Care Foot Odor Removers
  • Foot Sprays 3049 Health & Beauty Personal Care Foot Care Foot Odor Removers
  • Anti-Chafe 567 Health & Beauty Personal Care Cosmetics Skin Care
  • Muscle Balms 2915 Health & Beauty Personal Care
  • Sunscreens 2844 Health & Beauty Personal Care Cosmetics Skin Care Sunscreen
  • Hand & Foot Balms 2592 Health & Beauty Personal Care Cosmetics Skin Care Lotion & Moisturize

I understand that you can pick your own product types and just use names you like:

 

Unlike the google_product_category attribute, you choose which value to include. The values you submit for product_type can be used to organize the bidding and reporting in your Google Ads Shopping campaign.

 

and that for categories you choose the right category number. But if product_type is just what I want I doubt the if else statement would work as it does need to get the products in the correct collection...?

homadestudio
Tourist
7 0 2

Oh, so do I only need to add the category number?


@lntramel wrote:

 


@unplugged wrote:

Well it's actually two things that are store specific based on the code i wrote.  The Gender tag and the Google Product Category tag.

 

How I have done it is to use the 'Product Type' and map it to the Google Product Category.  The one problem is, if you have a lot of products this is time consuming to map out. Hopefully you would only need to do it once.  If you add additional Product Types later you would need to update this.  I would not be able to answer how to do this, as it is store specific on how you named all your Product Types.  It is possible to do this via tags as well, if your product types are not that gradular.

 

The gender tag is also store specific, as I mapped this our via 'Product Type' as well. If all your product types are not mapped out with gender specific verbiage, you can always do this via tags.   Unlike the Google Product Category Tag this tag is not mandatory for pinterest (it will give you an alert, not an error). However this is a very important tag if you want to market directly to women/men. With Pinterest being heavily used by women over men, it makes sense to have this tag properly installed so you can save money in marketing costs. 



Hello. I am not sure if I "Built the Google Out" Can you look at what I wrote? I think I may have done it wrong. I have 6 product types so I am not sure how elseif works when theres more than 2 options. Thank you in advance. 

 

<!-- /templates/collection.liquid -->
{% comment %}
The contents of the collection.liquid template can be found in /sections/collection-template.liquid
{% endcomment %}

{% section 'collection-template' %}

{% layout none %}<?xml version="1.0" encoding="UTF-8"?>

 

<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
{%- paginate collection.products by 1000 -%}
<channel>
<title>Pinterest Data Feed</title>
<link>https://sid-sam.myshopify.com/</link>
<description>Feed for Pinterest catalog</description>

{%- for product in collection.products -%}
{%- if product.variants.size > 0 -%}
{%- for variant in product.variants -%}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:price>{{ variant.price | money_without_currency }} USD</g:price>
<g:link>{{ shop.url }}{{ variant.url }}</g:link>
<g:item_group_id>{{ product.id }}</g:item_group_id>
<g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:condition>new</g:condition>
<g:Size_Type>regular</g:Size_Type>
<g:image_link>https:{% if variant.image.src %}{{ variant.image.src | product_img_url: 'grande' }}{% else %}{{ product.featured_image.src | product_img_url: 'grande' }}{% endif %}</g:image_link>
{%- if product.type contains "Kids" -%} <g:agegroup>kids</g:agegroup>
{% else %} <g:age_group>adult</g:age_group>
{% endif %}
<g:gtin>{{ variant.barcode }}</g:gtin>
{%- if product.type contains "Women" -%}<g:gender>female</g:gender>
{%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
{% else %} <g:gender>unisex</g:gender>
{% endif %}
<g:mpn>{{ variant.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

 

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "tops" -%}
<g:google_product_category>194</g:google_product_category>
{%- elsif product.type == "bottoms"-%}<g:google_product_category>204</g:google_product_category>
{% endif %}

 

</item>
{% endfor %}
{% else %}

<item>
<g:id>shopify_US_{{ product.id }}_{{ variant.id }}</g:id>
<g:title>{{ product.title | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:title>
<g:description>{{ product.description | replace: '</', ' </' | strip_html | strip_newlines | replace: '&', '&amp;' }}</g:description>
<g:price>{{ product.price | money_without_currency }} USD</g:price>
<g:item_group_id>{{ product.id }}</g:item_group_id>
<g:condition>new</g:condition>
<g:Size_Type>regular</g:Size_Type>
<g:availability>{% if product.available %}In Stock{% else %}Out of Stock{% endif %}</g:availability>
<g:image_link>https:{{ product.featured_image.src | product_img_url: 'grande' }}</g:image_link>
{%- if product.type contains "Kids" -%} <g:age_group>kids</g:age_group>
{% else %} <g:age_group>adult</g:age_group>
{% endif %}
<g:gtin>{{ product.barcode }}</g:gtin>
{%- if product.type contains "Women" -%}<g:gender>female</g:gender>
{%- elsif product.type contains "Men" -%}<g:gender>male</g:gender>
{% else %} <g:gender>unisex</g:gender>
{% endif %}
<g:mpn>{{ product.sku }}</g:mpn>
<g:product_type>{{ product.type | replace: '&', '&amp;' }}</g:product_type>

 

<!--- Add your google product info here (and deleted this note)--->
{%- if product.type == "accessories" -%}
<g:google_product_category>166</g:google_product_category>
{%- elsif product.type == "shoes"-%}<g:google_product_category>187</g:google_product_category>
{% endif %}

</item>
{% endif %}
{% endfor %}
</channel>
</rss>
{% endpaginate %}


homadestudio
Tourist
7 0 2

Can you show me an example of what the build out for the google product category would look like? Do I need to put the google product category where ALL of those red x's are?  

 

{%- if product.type == "xxxx" -%}
<g:google_product_category>xxxxxxx</g:google_product_category>
{%- elsif product.type == "xxxxx"-%}<g:google_product_category>xxxxxx</g:google_product_category>
{% endif %}

 

Should it look like this? 

 

{%- if product.type == "luggage_&_Bags > shopping_totes" -%}
<g:google_product_category>luggage_&_Bags > shopping_totes</g:google_product_category>
{%- elsif product.type == "xxxxx"-%}<g:google_product_category>luggage_&_Bags > shopping_totes</g:google_product_category>
{% endif %}

 

Thanks in advance.

USMenshop
Visitor
2 0 0

Look my message

madeformia
Visitor
1 0 0

Im having this exact issue. Any resolution?

Rhand
Tourist
3 0 1

We are having the same issue using https://domain.com/collections/all.atom .  Getting these errors

Issue type
Description
Occurrences
Error
description is missing from product metadata.
19
Error
google_product_category is missing from product metadata.
19
Error
link is missing from product metadata.
19
Error
image_link is missing from product metadata.
19
Error
availability is missing from product metadata. Possible values should be one of in stock, out of stock or preorder.
19
Error
The condition of the item is missing or the value provided is not an accepted one. Please specify whether the item is new, used or refurbished.
19
Error
price is missing from product metadata. Check that you are correctly sending a price of the form: <number> <currency>. Examples of valid price include 1.00USD and 1.00 USD. Do not include any currency symbols.
19

It seems we may have to create a custom feed .liquid page. But that is a bit much isn't it? Hoping for a solution where we can just use one of the existing feed types.

CelinieSnugally
Visitor
1 0 1

Thanks!! I wish this info was more visible! I've been looking everywhere (not super savvy) and it ends up being super simple!!

tslife
Explorer
44 2 12

This isn't working for me no matter what I do. Ugh.

RegalPhoenix
Tourist
3 0 3

I just tried it and it said file validated. It says to wait 24-48 hours.  Here's exactly what I put, hope that helps!

 

https://www.theregalphoenix.com/collections/all.atom

 


@tslife wrote:

This isn't working for me no matter what I do. Ugh.


 

Twentyfivefifty
Tourist
4 0 0

@RegalPhoenix wrote:

I just tried it and it said file validated. It says to wait 24-48 hours.  Here's exactly what I put, hope that helps!

 

https://www.theregalphoenix.com/collections/all.atom

 


@tslife wrote:

This isn't working for me no matter what I do. Ugh.


 



So, what happened after 24-48 hours? Did it work?

tslife
Explorer
44 2 12

Nope.

 

I've reached out to Pinterest and they are of NO help.


Zoey

Sep 15, 02:28

Hi Kris,

I'm taking over for Logan. Being a specialist from pinterest support team, we can help you to set up shopping campaigns or for creating product groups or promoted pins. But regarding setting up data source file with your website(in this case Shopify), you would need to get in touch with them because your website feed is completely depends on how your website is built. Thus, we recommend to get in touch with Shopify support.

As Logan sent in the previous emails, please make sure to follow the requirements while setting up data source file. Your XML file has formatting errors. So, I'd recommend to follow the below formatting tips and correct your data source file:

  • If you're using a csv, we wrap your values in double quotes to avoid any possible parsing issues
  • Additional floating delimiter (comma, tab) can result in the item or file not processing properly
  • Ensure delimiters for all your columns and rows are correctly set up by checking to make sure you have the same number of delimeters in each row.
  • The specifications for the feed must follow standardized American English for the required and set values.
  • For tab delimited or comma delimited files, data source file must be plain text, UTF-8 or Latin1 encoded.

You can find more info on data source specificationshere.

Hope this helps clarify! Let me know if you need anything else!

Thanks,
Zoey

 

This was their response.