Load the Google Shopping fields for your Shopify products 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.
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 a ready-made worksheet with your products and 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.
Maintain unit-pricing fields and custom labels 0 through 4, with product and variant analytics beside them to help 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.
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.
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.
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.
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.
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.
All of these load as columns in the Google Shopping template or any custom worksheet, next to the product and variant fields they belong to.
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 | Not in the standard CSV | Feed view only |
| Fill missing categories and identifiers in bulk | Yes | One product at a time | No | 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 | No | 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 | Saves instantly | Applies on upload | Varies |
Comparison reflects typical product feed workflows. Shopify and Google features can change over time.
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 worksheet from the Google Shopping template, 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.
Install the Mixtable Spreadsheet Editor from the Shopify App Store and create a worksheet from the Google Shopping template. Your products load 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.
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.
Open Mixtable for your store and give your product feed better data to work with.
