Use case for Mixtable Spreadsheet Editor
Load the Google Shopping fields for your Shopify products and variants into a spreadsheet: categories, identifiers, attributes, unit pricing, and custom labels. Fill gaps and fix inconsistencies at scale, review every change, then sync to Shopify when ready.
Google Shopping - Acme Apparel Sync 4 changesPreview Trusted by thousands of Shopify stores
What you can do
Mixtable loads the Google Shopping fields Shopify stores for each product and variant into a spreadsheet. Fix them the way you already work in Excel or Google Sheets, then sync reviewed changes back to Shopify.
Start from two ready-made worksheets, one for products and one for variants, with their Google Shopping fields already laid out as columns.
Edit age group, Google product category, condition, custom product, MPN, gender, color, material, size, size system, and size type, on the product or on each variant.
Maintain unit-pricing fields and custom labels 0 through 4, and add product and variant analytics with Mixtable Analytics Spreadsheet to define performance-based campaign groups.
Flag missing identifiers and inconsistent values with formulas and filters, then fix whole columns with copy and paste or fill down.
No formulas required: filter to products missing a field, type the correct value once, and fill it across every selected row.
Your feed app or the Google channel reads what Shopify stores. Mixtable fixes that source data, so every downstream feed improves.
All of these load as columns in the Google Shopping template or any products worksheet. Set them once for a whole product, or give each variant its own color, size, MPN, and more.
In the spreadsheet
Attribute Audit - Missing values Merchant Center disapprovals usually trace back to blanks and inconsistencies: a missing category here, three spellings of a color there. In a spreadsheet those problems are visible, sortable, and fixable in one sitting.
Guide: Audit your fields Categories - By product type Sync 3 changesPreview Google rewards clean, consistent attributes. Set the right Google product category for a whole product type at once, standardize condition and gender values, and keep color and material names uniform across every variant.
Guide: Standardize your data Custom Labels - Campaigns Sync 6 changesPreview Custom labels are how you slice your catalog into Google Ads campaigns: bestsellers, margin bands, seasons, clearance. They are only useful when they are current, and a spreadsheet is the natural place to keep them that way.
Guide: Organize your labels Feed Readiness - Summary Mixtable is not a feed-submission app, and that is the point. The Google channel or your feed app reads the product data Shopify stores. When you repair that data at the source, every feed, channel, and future export inherits the fix.
Guide: Repair your source dataReview and sync
Google Shopping edits stay as highlighted drafts in your worksheet. Open the preview, confirm each pending value, then run Sync to Shopify. Your feed app picks up the improved data from there.
| Row | Product | Field | Pending value |
|---|---|---|---|
| 2 | Merino Crew Sweater | Google category | Apparel > Sweaters |
| 3 | Corduroy Cap | MPN | CP-018 |
| 4 | Wool Scarf | Color | Charcoal |
| 5 | Merino Crew Sweater | Custom label 0 | premium=IF(C3>100,"premium","core") |
| 6 | Linen Trouser | Size system | US |
Compare
These fields are easy to set once and hard to keep clean. Here is how the usual approaches compare across a whole catalog.
| Feed data task | Mixtable | Shopify admin | CSV import and export | Feed apps |
|---|---|---|---|---|
| See all Google Shopping fields in one view | Yes, with a sheet | Buried per product | Some, as CSV columns | Feed view only |
| Fill missing categories and identifiers in bulk | Yes | One product at a time | In Excel, then re-upload | Rules, not data fixes |
| Audit for gaps and inconsistencies | Formulas and filters | No | Manual in Excel | Error reports |
| Manage custom labels for campaigns | Yes, even formula-driven | Tedious | In Excel, then re-upload | Rule-based |
| Fix the data Shopify actually stores | Yes, at the source | Yes, slowly | Limited fields | No, feed-side only |
| Review changes before they go live | Yes, then Sync to Shopify | Live when you click Save | Applies on upload | Varies |
Comparison reflects typical product feed workflows. Shopify and Google features can change over time.
Getting started
No per-product clicking, no feed-side patches. Fix the data once, at the source.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and open a spreadsheet.
Create a spreadsheet from the Google Shopping template, with worksheets for products and variants, or add the fields to your own.
Filter and sort to surface missing categories, identifiers, and inconsistent values.
Fill values down, copy and paste, or use formulas for labels and standardization.
Check every pending change, run Sync to Shopify, and let your feed pick up the fixes.
Questions
Install the Mixtable Spreadsheet Editor from the Shopify App Store and create a spreadsheet from the Google Shopping template. Your products and variants load into two worksheets with their Google Shopping fields as columns, so you can fill categories, identifiers, attributes, and labels in bulk, then review and run Sync to Shopify.
Age group, Google product category, condition, custom product, MPN, gender, color, material, size, size system, size type, unit-pricing fields, and custom labels 0 through 4. Custom product is set on the product. Every other field can be set on the product or on individual variants.
Yes. The Google Shopping template includes a variants worksheet with one row per variant, so each size or color can carry its own color, size, MPN, custom labels, and other Google Shopping fields. On a Products (with variants) worksheet, you can also choose the product or variant version of each field when you add a column.
Shopify stores the Google Shopping fields on your products and variants, and your Google channel or feed app reads them to build the feed it submits. Mixtable edits what Shopify stores, so the improvements flow into whatever feed tool you use.
Yes. MPN is one of the Google Shopping columns, and GTINs live in the barcode field on your variants, which you can bulk edit from a variants worksheet. Filter to products missing either identifier and fill them in at scale.
Filter your worksheet to rows where a field is empty, or add a helper formula that marks gaps and sort by it. You get a working list of every product missing a category, identifier, or attribute.
Custom labels 0 to 4 let you segment products in Google Ads campaigns, by season, margin band, bestseller status, clearance, or anything else. In a spreadsheet you can assign and rotate them across thousands of products at once, even from a formula.
No. Mixtable edits the Google Shopping data stored in Shopify. Feed submission stays with the Google channel app or the feed app you already use, which will pick up your cleaned-up data.
No. Edits stay highlighted drafts in your worksheet until you review them in the sync preview and run Sync to Shopify. Only then does your feed see the new values.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and give your product feed better data to work with.
