Academy › Publish › Get found on Google
By hand, with a file, or with a spreadsheet: how your catalog gets into Merchant Center
You'll learn how to add your catalog to Merchant Center yourself, one product at a time, with a file, or with a spreadsheet, and which one works best for you so it never goes stale.
By Yodai · Published September 6, 2026 · Updated October 12, 2026
You search "flower delivery" on Google, and right at the top, before the regular results, there's a row of photos with the price under each one, and the Shopping tab shows a lot more. You have a flower shop, you have a website, you have a catalog. And you're not showing up there. The question isn't whether your business deserves to be there. It's how a product gets into that row, and who's in charge of sending it.
The safe route is to hand it over yourself: you add your catalog to Merchant Center, product by product or with a file that lists each product, its price, and its availability, and you keep it up to date. The ways of delivering it aren't interchangeable: each one asks for different upkeep, and a catalog that isn't maintained ends up showing old prices or products you don't carry anymore, which Google can reject.
Merchant Center's two doors
Merchant Center is where Google stores your catalog before deciding whether to show it in Shopping. You don't publish a polished listing there: you send raw data, row by row, and Google builds the listing from what you give it. This lesson is about where that data comes from.
If you only have a few products, you can add them one at a time right in Merchant Center, filling out a form for each one. Google only allows this once the account already has at least one product: the first time around, it requires a file or a Google Sheet, and the form is there afterward for adding or fixing things.
For everything else, you're the messenger with a file. You put together a file with one row per product and a fixed set of columns: ID, title, description, price, availability, link to the product page, link to the photo. That file is the feed, and you hand it to Merchant Center to read.
- You fill out a form for each product, no file needed.
- Only for a handful of products, and once the account already has one listed. Every price change you make by hand, listing by listing.
- Works for any website, whether or not there's an online store behind it.
- The upkeep is on you: if you don't update the file, Google keeps the old price and may reject the product.
- You decide every column, so you also decide which product gets in and which stays out.
- Can live in a spreadsheet, no coding needed.
Which one to pick: For your first upload, and as soon as you've got more than a handful of products, go with the feed: one file or spreadsheet saves you from filling out the form product by product. Adding items one at a time is for tacking on a single new product or fixing a listing once the catalog's already in there.
Inside the feed: by hand, in a spreadsheet, or scheduled
Choosing the feed doesn't settle the decision. Within the feed there are three ways to deliver it, and the one that fits you depends on how often your price and stock change.
The simplest option is uploading a CSV file by hand, from your computer, every time something changes. It works fine for a short, stable catalog: twenty or thirty products whose prices don't change more than once a month. The trouble comes if you forget to upload it. Google sticks with the data from last time, and if it doesn't match what you're actually charging on your site, it can reject the product until you fix it.
The second option is a Google Sheet that Merchant Center reads on its own every 24 hours. You don't need to know how to code. Merchant Center gives you a template, you fill it in like a regular table, and whatever you change gets picked up by Google on the next read. It's the option I recommend most for a small business: it keeps the feed current without asking you to learn anything new.
The third option is a URL that your website generates on its own with up-to-date data, and that Merchant Center downloads every 24 hours. It takes someone to build it once, a developer, or whatever tool you used to build your site, if it generates that URL for you, but after that you never touch it again. It's the most solid choice once your catalog passes a hundred items and the price or stock changes every week.
- You know that you're the one who adds your catalog to Merchant Center: one at a time or with a feed
- You know how to choose between a manual upload, a Google Sheet, or a generated URL, based on how often your catalog changes
- You're clear that the structured data on your site doesn't replace the feed
- The next decision, in the following lesson, is which product you leave out of the catalog even though you sell it
Test yourself
Answer before opening each one. If one gives you trouble, go back to the section that explains it.
1. You sell flower bouquets from your website. You have 15 products, and the price only changes for Valentine's Day and Mother's Day. What do you choose?
A feed with manual upload. The catalog is short and barely changes; scheduling a sheet or a URL is more upkeep than you need for two updates a year. You upload the file by hand those two times and that's it.
2. Your catalog is in a Google Sheet that Merchant Center reads every 24 hours, and new products take a day to show up. To speed things up, you're thinking about also uploading a file by hand with the same products. Do you need to?
No. If a day can't wait, Merchant Center lets you force a re-read of the sheet with the "Fetch now" button on that data source. Sending the same products through two channels at once just complicates things: each product ends up with the data from whichever source updated last, and you end up not knowing which one's in charge.
3. You've got 200 items on your website, stock shifts every week because you also sell at a physical store, and you don't have anyone who knows how to code. What do you set up?
A scheduled Google Sheet, not a URL generated by your website. With 200 SKUs changing every week, you need automatic updates, but without anyone to build the URL, that option only gets you halfway there; the scheduled sheet gives you the frequency without asking you to code.
The sheet solves the how. But it doesn't decide what goes in: you have items with a set price and real stock, and others, like the ones you make to order or that take three weeks to arrive, that you can't vouch for the same way yet, and that difference is what decides which listings you send to Shopping and which ones you keep on your website only.
NextThe product you're leaving out of the catalog, even though you sell it