2024 Small Business Product Catalog in Google Sheets
Have you wondered if it would be handy to have a product catalog for your small business?
Did you know that we can create the entire online product catalog or online store experience within Google Sheets? Without payment processing, of course 🙂 You could use this to share your product info with your prospects and customers in an interactive tool.
This is how the product catalog/store appears in Google Sheets.
If this sounds interesting, please read further on the functionality and for how to use this (hint: it’s so easy. Just enter your data and you are done). You can download this Google Sheets template for free using the link below.
Free Download
Benefits of Product Catalog in Google Sheets
- Filter products by Categories
- Search products by keywords (on Product Name)
- Sort products by Price (Ascending or Descending)
- Scroll to see products in sets of 8
- Add thumbnail images to appear on the Catalog
- Add links to the website as needed on product detail sheets
- Catalog links to individual product detail sheets
- Format the catalog as needed with the usual Google Sheets formatting options
- Customize product detail pages as needed
How to create a Product catalog for your business?
Overview of Steps
- In the Input sheet, enter product categories and product data for your business.
- In the Catalog sheet, change logo and tagline text to suit your business – this is where you’ll have the catalog populated.
- In each product’s individual product detail sheet, rename the sheet to match the product name
- Update product image and highlights for each product
- Change formatting – colors, fonts, etc. as needed
Detailed Steps
Entering product data
Enter CATEGORY you need in the Categories sheet. Enter as many categories as you need.
In the Input sheet, enter Product Data in the Products table.
a. DO NOT enter anything in the THUMBNAIL IMAGE column as it is a calculated column based on the Image Link column.
b. To get the thumbnail (or the product image), open the Google Drive where the images are stored.
To get this, click on the image in the Drive folder and click on the share image that appears as shown:
c. This will open a small pop-up where you need to ensure that “Anyone with the link” has viewer access and then click on Copy Link to get the image’s link:
d. Once this link is pasted in the Image Link column, the IMAGE function in Google Sheets fetches the corresponding image from the URL.
Please ensure that the image needs to be shared as anyone with the link can view.
e. Enter the product name, price, category, highlights and the product link of each of your product.
This ends our product data entry process for one product. Repeat for all products. After you enter all your products, you can hide this sheet. Now, we are ready to customize the catalog/store appearance.
Customize Catalog Appearance
First, in the Product_Catalog sheet, change logo by changing picture as explained above. Change the tagline text to suit your business.
If you want to change the colors, fonts or any formatting, please select cells and change formatting as usual in Google Sheets using the ribbon on top.
Customizing Product Details Google Sheets
You will notice that in the catalog, there are links to product detail sheets. Each product has its own sheet where we have its image and description.
- Rename the sheet to match your product name. If your product name is Cool Product, please rename the sheet to Cool Product.
- Replace image and description with your products’ info.
- I have added two links, one to the product page on the website and the other to go back to Catalog. Replace the web link with your product web page link. You can remove the web link if you don’t need or have.
- (Optional) You can change formatting (colors, fonts) as needed. There are no formulas in the product detail sheet.
Repeat this step for each of your products.
Once you have completed all your product detail sheets, you are done. You can go back to the Product_Catalog sheet and your catalog is ready. Start. Sort, Search, Filter, Scroll. 🙂
Print/Export
You can export to PDF or print as all sheets are set up as print friendly in this Google Sheets product database template.
Limits
- Designed by default for 30 products. Can be extended if needed.
- Names of Products should match the Product Detail Sheet Names. This allows hyperlinks to function properly.
Note:
The template works ONLY when images are taken from Google Drive and with “Anyone with the link can view” access.
As always, I look forward to your feedback to understand how this can be extended to suit more small business needs. If you have any feedback or suggestions, please leave them in the comments. Thanks.
Leave a Reply