Data Source URL for Pinterest Catalog

Highlighted
Tourist
7 0 2

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


@lntramel wrote:

 


@adlamoureux 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 %}


0 Likes
Highlighted
New Member
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.

0 Likes
Highlighted
New Member
4 0 0

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!

 

0 Likes
Highlighted
New Member
4 0 0

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!

0 Likes
Highlighted
Excursionist
25 2 3
What are you using for the data url on Pinterest?
0 Likes
Highlighted
Highlighted
New Member
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

0 Likes
Highlighted
New Member
1 0 0

Did it work?

0 Likes
Highlighted
New Member
4 0 0

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....

0 Likes