Google Shopping Template

Keeping your feeds up-to-date is vital when running Google Shopping ads for your Shopify store. Here are some of the most important metrics you need:

• Accurate, detailed product titles that include brand, model, key features, and specifications - directly impact click-through rates and relevance.
• High-quality product images showing items clearly from multiple angles on white backgrounds.
• Inventory accuracy - prevent showing out-of-stock items or incorrect availability.
• Price competitiveness - maintain accurate pricing as market conditions change.
• Feed quality score - Google rewards frequently updated, accurate product data with better visibility.
• Compliance - ensure adherence to Google’s policies and category-specific requirements.

Outdated Shopping feeds risk account suspension, lost sales, and poor ad performance. Daily updates are recommended for most merchants, something you can maintain easily with Mixtable’s Google Shopping template in a spreadsheet format.

How do you load the Google Shopping template?

• After installing the Mixtable Spreadsheet Editor app, click the Create a Workbook button.

• Select the Google Shopping pre-built template from the list that appears in the dialog.

• Now, you can bulk edit the Google Shopping fields for your Shopify products.

What data is included in the Google Shopping template?

The Google Shopping template contains the following default columns:

• Product Title
• Age
• Google product category
• Condition
• This is a custom product
• Manufacturer Part Number (MPN)
• Gender
• Color
• Material
• Size, Size system, and Size type
• Unit pricing measure and Unit pricing measure unit
• Unit pricing base measure and Unit pricing base measure unit
• Custom Label (0-4)

Fill in the missing Google Shopping data

• If there are fields with missing data in the worksheet, make sure you fill them in and keep them up to date.
• This will ensure your Google Shopping ads run uninterrupted and generate the traffic you need.

How to add Price and Inventory data to your Google Shopping feed spreadsheet

• Add а new worksheet:

  In an existing Mixtable workbook, click the (+) button to add a new worksheet.

  

• From the 1. What type of worksheet would you like to add? window, choose Shopify data worksheet.

• Then select the Products (with variants) option.

• This worksheet will load Product variant details, including Pricing information and Inventory data for the different warehouses you have in Shopify:

• From this worksheet, you can make sure your price is competitive and your inventory is accurate.

• In a similar way, you can pull the Product Images worksheet and check if your images are compatible with Google’s requirements.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.