How To Set Up Pinterest Catalog Data Source Manually - Pinterest Shop Tab Tutorial

[@sumnerandali]

🚀 Pinterest Marketing & Advertising Course: www.udemy.com/course/pinterest-marketing-and-advertising-course-for-beginners-to-advanced/?referralCode=1C7CE38E2790CC64DD25 📜 Pinterest Catalog Data Source Details: help.pinterest.com/en/business/article/before-you-get-started-with-catalogs 🗂 Data Source Google Sheets Template (⚠ IMPORTANT: Do not request access. To edit, click on 'File', then 'Make a copy): docs.google.com/spreadsheets/d/1I_NgGlZgcjjXCtG4rbHQrj4HGGrjWIqf2UQtDD4eu1g/edit?usp=sharing 💾 Google Product Types: www.google.com/basepages/producttype/taxonomy.en-US.txt 👉 Copy this link for the Data Source URL: drive.google.com/uc?id=

[@leannefrancis8672]

Thanks so much for this fantastic tutorial. I have been back and forth with the Pinterest help team for months to no avail. There really is no clear support for this service unless you want to cough up the money to allow a third party to host your data. I started to manually upload my 200-something products pin by painful pin until I came across your video. Your clear guidance has led to my catalogue becoming verified instantly - Ah-Mazing!!!

[@jeimonroe]

This was so helpful! After watching so many other videos and reading articles unsuccessfully, I was finally able to get my catalog approved! Thank you!

[@sumnerandali]

That's amazing Jei! I felt the same way, that's why I really wanted to create this video. So glad you found it helpful 😊

[@trukke]

I searched, tried, failed many times to create product pins... Now i hope, it will work with your tutorial... Thank you!

[@justmyopinion4938]

This is so helpful. I've been struggling with Pinterest for months. They need to make it easier for users.

[@sumnerandali]

Glad it was helpful!

[@jessicagrimsman4982]

I just started my online shop two weeks ago and have found this video to be INCREDIBLY resourceful. I’ve gone back to watch it several times while optimizing my Pinterest business account and getting my catalog set up. Thank you!

[@sumnerandali]

Thank you so much for your feedback Jessica 😍 I'm so glad you found it helpful! Wishing you much success!!

[@rosiebraggie]

Thank you so so much! When I first went to the catalogue info page on pinterest I was so overwhelmed. You've made it seem so easy!

[@MOHAMMEDLAKRARI]

if you're getting issue with csv file to fill in , there is an easy way to fix that better than google drive and all of that stuff : 1) go to google sheet file 2) click on file 3) click on publish 4)choose publish on web 5) choose link format (csv , tsv ) 6) copy and paste on pinterest . and thats it .

[@hammad055]

Thanks brother. It worked for me.

[@runa1259]

thanks for your idea, it's good way to solve this

[@carolinrieger4216]

thank you, this worked fine

[@MelissaKellyHerStunts]

Hey Girl! Your video is a blessing! I got this error when I tried to upload. ANy tips? Check to make sure the URL, username and password you're using are correct and error-free, then try your upload again. Learn more; Opens a new tab

[@TheSisterBrand-]

Honestly, SOOOOO impressed. Thank you for walking us through this! This has been so daunting, without clear direction on HOW to do this! FINALLY, we found YOU!

[@tmb9126]

It's so true - daunting is the perfect word to use. Pinterest uses a language that has been so hard for me to follow and understand. Sheesh! lol

[@RoseLindo]

This was pure gold! Thank you so much, I've looked everywhere for a tutorial like this one!

[@kyzachi736]

Many thanks for this invaluable step-by-step guide, which I followed to the letter. I encountered an issue with Google Drive. For some inexplicable reason, Pinterest is not able to access the file despite me removing any restrictions as per you instructions. Not sure what the issue is as I've troubled-shooted to no avail. So, thankfully I have an Amazon S3 account where I uploaded the csv file and VOILA! It worked like a charm! Many thanks once again for sharing this great piece of content.

[@MelissaKellyHerStunts]

Can't wait to hear this video. It has been painful trying to figure this out. lol

[@pinkchickpsychic]

I just got approved. Trying to figure it all out.

[@mdhresources]

I have watched a number of videos about the Pinterest catalog that have been so confusing. I have been approved for a shop but I am on Goimagine platform so there is not direct link. Your video made it so easy to understand the spreadsheet. Thank you so much for your time and effort in making this video.

[@sumnerandali]

Wow, thank you so much for your feedback! Your comment made my day 😊 - Ali

[@mamabtinytreasures]

Finally! You are very good a explaining this process step by step. I am so happy I came across your video.

[@zel9261]

Very informative finally I can know how do it manually. Thank you so much 😊

[@daniellekat1637]

This was SO helpful!! Best tutorial I've seen on how to create a catalog!! Thank you so much!!

[@sumnerandali]

So awesome to hear!!

[@sumnerandali]

I'm so glad you found it helpful!!

[@polegoddess94]

Thank you so much for this. I’ve been trying to find something for month getting so confused. Your guidance is much appreciated. Going to work on this now!

[@thebusinessofefficiency]

This video was incredibly helpful! Thank you so much for taking the time and being so thorough.

[@sumnerandali]

You are so welcome! Glad it was helpful 😊

[@wymfyf]

Thank you so much for your knowledge! May I ask a question? My price depends on the quanity they choose from the drop-down section on the product page. For example, they select: a quanity of 5, the price is $7 a quanity of 10, the price changes to $12 How would I go about doing this? Do I add another column of 'price' and does the quantity go under 'variant_value'?

[@LauraFerguson-j5i]

Great video, and such a personable presenter. Thank you!

[@sumnerandali]

Thank you!

[@bobi1049]

This is amaazzing!!!! So much value, clear and easy to follow.....thank you so much lovely lady!

[@NICKELNCO-rt7ke]

thank you so much, you made this super easy to follow!

[@sumnerandali]

I'm so glad!

[@ghislainemahler1880]

Hello, thanks for all your great teaching! I am a newbie here and I have a quick question: Let's say I do everything as you directed, but what happens when I add new products to my Shopify store?? Do I have to create a new spreadsheet and upload it to Pinterest? What will happen to the current products showing on my Pinterest account? oh! and another question: why do you recommend doing this manually instead of automatically? What is the difference? Thank you!!

[@joshjsmith]

Loved watching you Ali. Great info!

[@sumnerandali]

Thanks so much!

[@Janet-ju5yw]

Thank you sooo much! I never would have figured this out without you! I'm not sure I quite get the variations part, but at least I can add my individual products, which is AWESOME!! Thanks again!

[@sumnerandali]

Thank you for your generosity Janet and so glad to know you found it valuable! :)

[@thetsubakiblooms]

Thank you so much for your video! I've been trying to upload my catalogue for a long time but it always turns out as an error. Really appreciate this!

[@marctakeuchi7015]

Great video. I'm helping a client connect to his BigCommerce store. How does the Test your feed work? In particular "Paste the piece of feed you want to test, including the header, into the box".

[@sedrickgeniusy8395]

Thank you very much. Will get the course

[@BrendaBeltran]

I'm so glad I've found you here! Just bought your course in Udemy.

[@AcheiinBusiness]

Thank you VERY much. I Thought Pinterest really should improve this. On Tik Tok and Meta Platforms is way easier

[@friedacreates]

A fantastic tutorial, can't wait to put it to the test! I did notice too that the GoogleDoc is not accessible. Thank you!

[@sumnerandali]

You have to click on 'Make a copy' once you open the link 👍

[@milouneelen8477]

@@sumnerandali Same here, the file doesnt open but have to receive access?

[@emmatatham9211]

Wow, thank you so much for this super helpful video! You’ve made this process much easier to understand.

[@intuitivestyle754]

Thank you! This was very helpful and easy to follow xx

[@subreezy]

did it work for you? I’m getting the error of Merchant's URL is broken/inactive or requires registration.

[@intuitivestyle754]

It worked for me by following the step by step instructions. I made one mistake along the way but realised I downloaded it incorrectly. And, fixed it easy@@subreezy 👌

[@sumnerandali]

You're welcome!

[@mamabtinytreasures]

Two quick questions 1) do I put the information that you are giving me on line 2 of the sheet? Also, if I do this for 1 product and upload, can I add a second product to the one I just entered like do 10 at a time or do I need to download then upload one product at a time? Very much appreciate the detailed help!!

[@brentcruede6544]

Fantastic tutorial... So very thorough and helpful. Great detail and especially appreciate the method to create the catalog. It's not complicated when you explain it... Great instruction. Big THANKS!

[@ColorMeMozart]

Thank you for this, so helpful! 👏

[@thewindspirits]

Thanks for this incredible video. It helped me so much through this process🌷

[@gswatch-e9e]

Thank you so much for this video! I uploaded my catalogue successfully after watching this, but now, a month later I'm getting an error message asking me to 'update my data source'. I don't understand what I need to do here, if nothing about my products has changed, how can I 'update' the data source?

[@Wilonda]

Omg, This Was So Helpful!! Definitely Saving This Video For When I Need It Again.

[@emaillistgeneratorcompany]

Hello i learn alot from this but i have a problem with fixing my pinterest catalog can you post a video on that

[@ecogardenmart]

Hi there i've been searching all over the internet on how to get my catalog approved in the easiest way possible and your video is hands down shows the best and the easiest way to do so, so thank you for a great tutorial. Secondly I would like to ask after my catalog file was validated and sent for approval I got a message from Pinterest stating that "Your product are always on sale" how do I solve this thing to get my catalog approved on Pinterest and is there a minimum requirement of number of days or months one should be active on Pinterest to apply for the Merchant Program?

[@sumnerandali]

So glad to hear that! Regarding your questions: 1. I haven't experienced that "error" before about sales. Is your catalog active despite this message? If not, I would test removing the sale while it gets activated and then try adding it after. 2. There's no minimum # of days to apply but you do need a minimum # of website visits to be approved. You can see all of the requirements here: help.pinterest.com/en/business/article/verified-merchant-program Best wishes!

[@ecogardenmart]

Thanks @@sumnerandali

[@rockyweed5496]

thank you for this information. Love from Pakistan 🇵🇰

[@Painterfamily1]

Such useful information. Thank you!!!!

[@sumnerandali]

So glad you found it valuable 😄 Thanks for the feedback!

[@lauren3085]

This tutorial was AMAZING. Thank you! My Question: Do we just upload the form one time, and then it's done? Does Pinterest push those products every day or ...? I'm not quite sure how that part of it works.

[@kaysheff8978]

thank you... it worked. Thus video is very helpful.

[@jezzybell101]

Thank you, you explained this so well!

[@sumnerandali]

So glad you found it helpful!! Thanks so much for the feedback 🥰

[@tony932209]

Been Busting my head with this for a while. This worked!! You're amazing and thank you so much for this!!

[@SusanB-dd5oe]

So Glad I found this. Great Video but I do have a question. After submitting the data source to Pinterest say I want to add new products to that particular catalog. Can I add to a catalog or do I have to create a new catalog? Thank you!

[@quiquileroux7856]

This was awesome! Taking your udemy class next. Thank you!!!

[@sumnerandali]

I'm so glad you found it helpful! And that's amazing 😍 Welcome to the family!!

[@prestonyoung6123]

Great video. She moves with lots of info. Overwhelming to someone like me. I still have one question that I still cannot figure out. Do I need to have one of those partners like Shopify for HOSTING? I am an author, and my books are sold on Amazon, Barnes & Noble, etc., and not from me directly. Can I link my Pinterest account with Amazon AS A HOST?

[@vsyakayahren5097]

Do I have to do it only once , or every time if I have new product?

[@NancyEsquivel-h3f]

Hello, thank you for the video. I have a question, if I have a shopify store, the catalog will be transferred automaticaly and it will appear on pinterest? all of the spread sheets here is if I don't have a ecommerce store?

[@seeweehomes196]

Thank you so much! This is helpful and I’m glad I found this video. 🙂

[@sumnerandali]

I'm so glad!

[@ZenLivingInsights]

The link to data source url is not working, can you kindly paste it here or give us another alternative to access the link..

[@KarenLusterio-tl1ek]

Such a big help!!! Glad I found this video, thank youuu! 🤍

[@successfulpeople]

Hi, thank you for this video. I have heard bad feedback regarding Pinterest for Woocommerce, 2.2 score out of possible 5 is horrible. I am more comfortable using your manual style.

[@HasanAltaf-yg8kp]

hey! you are doing very well. i have done all the thing as you said to show product catalog of etsy in pinterest . but the error coming about the return policy. can you please give me a solution about this.

[@alltshirttimes]

Wow!!! You are amazing. Thank you so much for this detailed breakdown. What a treat it was watching you and your wonderful energy. Thank you sooooooo much. Wishing you all the best. ❤🙏❤

[@subreezy]

im getting the error of: Merchant's URL is broken/inactive or requires registration.

[@BeaniBubs]

Just found your channel, so helpful, just starting on Pinterest. Thanks heaps

[@inspecialhome]

Hi there, thx for the tutorial. Just one question: for this manual setup, what if I would like to update an existing product feed? does that mean the feed URL for the existing data feed would have to change since making update would require a new csv uploaded and new linked created? if that's true, what would happen to the product pin and their engagement data I have created with the existing product feed?

[@musicheart0328]

Thank you! It worked ❤

[@sumnerandali]

You're welcome!

[@hydrokatt]

thank you for this!

[@sumnerandali]

You're welcome!

[@peterbennett4198]

So helpful, I really appreciate clear and informative instructions, thank you, definitely subscribing. One question. After I upload the initial data source for my catalog, how do I handle future updates if I add additional products? Do I upload the whole catalog with the additions or just a CSV with the new additions?

[@DomDom-lw9xo]

Thank you so much for the great information. I'm still having trouble with the variant values. How does it supposed to look in the cell? For example: if you have a red shirt that comes in small medium and large, also blue shirt that comes in small medium large.

[@TheSparklespk]

Thank you so much. This was super helpful and a God given time saver. Much gratitude.

[@creativeladyboss]

This was absolutely perfect. One question. When you add new products to the file can you just open that same file and it will save it as a csv after the edits or will you need to download the file as a csv again and reupload with the same name and overwrite the existing file.

[@katefrances287]

I have the same question. Did you get an answer?

[@Bauerash05]

Followed this step by step and when I uploaded the Google Drive URL it didn't work. Upon further reading on the Pinterest page it says it does not support a Google Drive link. Any further advice?

[@gibsonbespoke9700]

I've followed this step by step a few times now making sure I am doing everything correctly but it Pinterest is telling me to provide a valid feed url. When I copy paste the Url into a browser it automatically downloads my csv catalogue so I'm really not sure why Pinterest will not recognise it! Can you give me some tips as to what is happening? Thank you so much for providing these amazing videos to KZbin!

[@CosmicMystic]

Thank you for responding to my email and for your help, you're awesome!

[@sumnerandali]

You are so welcome! Thank you for your kind words 🥰

[@lauramcraehitchcock1500]

Thank you so much. You made this much easier to understand!

[@sorilbran]

Such a rock star. Thanks so much for this!

[@GabrielGonzalez-fx2oz]

Awesome Tutorial! My Catalog was approved However , has anyone received a 111 Image link error or 113 Price field Error. I swear everything is correct and followed exact directions for image links. Did anything change since this video?

[@sachaharlaar9316]

this was immensely helpful, thanks a lot! 🙂

[@navi66]

Hi, Very resourceful and I am a click away from creating my products page/catalog with pinterest. However, it won't accept my product feed url because it is in HTML format even though it was saved as CSV. I tried your way but the link was giving me a 404 error code. I generated the link from google docs and it didn't go through, again, because it is HTML. Any advice?

[@gdsglry-b8u]

Thank you!

[@sumnerandali]

You're welcome!

[@pampinis]

Hii! Very useful and explained video 👏 But sadly I can't upload my catalog into my Pinterest business Account.. I've been trying for a while!! And I do not know what happens but some error occurs 😭 Just in case if you know why this issue happens? I'll very glad and happy to finally resolve this problem 🥺 (it says that Pinterest Couldn't read the URL file) Thank you!

[@enlightenedheart2811]

Hi: I followed your directions on how to upload a Squarespace catalogue to Pinterest and haven't been able to get a valid url to use. I've been at it for several hours. Perhaps i missed something in the way you erased part of the link but i tried it many many times with no success. Please help.

[@ydocmick]

So so helpful

[@sumnerandali]

I'm so glad!

[@mrsjsellers]

Great video! I requested access to the google doc template but still haven't received it. Thanks!!

[@sumnerandali]

"File" -> "Make a Copy" in the top-left of the sheet.

[@Leah-xy2hw]

Great video! The google sheet link only gives me the option to request access though, I can't see the file to make a copy.

[@sumnerandali]

Hi Leah and great to hear! The link should be working now to make a copy.

[@primeautobots1]

Great content. Very helpful. 🙏🏽

[@MomStreams]

Thank you so much this was sooo helpful! 🙏🏽

[@lokodesert8608]

Incredible! Thank you so much for this, excited to see how my business grows!

[@sumnerandali]

Heck yes!

[@hitherandyonstudio]

Thank you for this info. It was very easy to walk through! Question: What about when you add new products to the shop? Do I then need to add it to the CSV spreadsheet?

[@sumnerandali]

You can add them on additional rows and then download the CSV again, re-upload it to Google Drive, and then redo the Catalog form with the new link.

[@apolo2177]

extremely helpful content, some of the best by far, i have a question. we use woocomerce and when trying to add the Pinterest pixel add on it says we have to pay, but the pinterest instruction say its free. is there a way to get around the 90 fee to use the pinterest add on pixel?

[@arturbojarczuk2180]

Hey do have solve for The seller's products are always on sale issue?

[@adamlindblomphotography9807]

Hello my dear Friend! How are you today? great video! I have my website with Shopify. Would you suggest I connect Pinterest directly through my Shopify Admin? What would you suggest? I think you mentioned something about setting it up outside of shopify gives one more access to features? I hope to hear from you.

[@MarieBGiordano]

Where do I find the File for you in google drive? I couldn't figure that out

[@contact.gamingzone]

How can I open the file? It just takes me to the request access page. your google sheet link is access denied. kindly help

[@sumnerandali]

Hello, as mentioned in the video, you have to click on File > make a copy, then rename it so you can edit it.

[@chrisc.7972]

So useful, thank you so much!

[@dav6568]

Do we need to delete the row from the spreadsheet that has the guidance / example copy. So delete row 2 before saving as a csv file?

[@sumnerandali]

Hi Dav, yes you do! Thanks for checking and sorry if that wasn't clear. Best wishes!

[@andrewedwardsiphone]

THANK YOU SO MUCH FOR THIS HACK!!! Love a freeby

[@trendycatportraits]

I never EVEER write comments on any social platform. But this is one of the best informative videos i've seen in years. Thank you guys, much Love Danni 【ツ】!!!

[@lpb927]

PLEASE HELP!! I am totally confused! I did everything exactly as you describe. I first opened a company account, then verified the website etc.. Then I copied your provided spreadsheet, edited it, saved it as a .csv file and uploaded it to google drive. when I copied the link, I made sure everyone had access who owned the link. Now when i paste the link and fill in the rest of the fields, pinterest does not create a catalog but gives me the error message that: Catalogs cannot access your files. Make sure the URL, username and password are correct and then try again. Can someone help me out please?

[@daichisukehiro184]

so helpful . already subscribed☺️

[@yourtimetoshinetherapy]

I have done the columns you suggested in yellow when I upload it to Pinterest it tells me i have not enough columns. what am i doing wrong.

[@Kemikamng]

Good day Please do we need to submit the data source per product or we can just add other products down below the spreadsheet. Thank you Your tutorial was well explained

[@sumnerandali]

You can add products in the same file, just 1 per row and you should be good to go! So glad you found the video helpful!

[@Kemikamng]

@@sumnerandali was told my merchant domain is incomplete