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.
- 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.
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)
- 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.
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:
Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.
