Bulk Product Edit

How do I bulk edit Google Shopping attributes?

Written guide 8 min read Advanced

All Google Shopping fields are products and variants metafields. On your Shopify store, all Google Shopping fields are stored as single-line text type product or variant metafields. While validation checking is available when you bulk-edit Google Shopping fields through our app, you may be able to import almost any value to your Shopify store as Google Shopping fields through CSV Import on our app.

However, if the value you import is not valid as the proper Google Shopping field value, Google Shopping may not be able to retrieve the attribute from your Shopify store even if you have the corresponding metafield in place, resulting in the attribute not showing properly on your Google Shopping listing. Therefore, it is essential that you make sure the value you upload through CSV is accepted by Google Shopping as an appropriate field value.


Accepted values for each Google Shopping field

Below is a list of all values (or value syntax) supported for each Google Shopping fields, as well as whether they can be edited as a product or variant field.

FieldValueCan be Edited as Product FieldCan be Edited as Variant FieldValue Source Priority
Custom Product
(Whether this product is a custom product)
‘true’ or ‘false’Yes-1. Product Google Shopping Field value of custom product
2. Default value: False
TitleOne single Unicode string representing the product titleYesYes1. The Variant Google Shopping Field value of Title
2. The Product Google Shopping Field value of Title
3. The text [product_title] – [variant_title]
4. The text [product_title]
DescriptionOne single Unicode string containing up to 5000 characters representing the product description, with HTML tags removedYesYes1. The Variant Google Shopping Field value of Description
2. The Product Google Shopping Field value of Description
3. Product description
Availability’in_stock’, ‘out_of_stock’, ‘available_for_order’YesYes1. The Variant Google Shopping Field value of Availability
2. The Product Google Shopping Field value of Availability
3. ‘in_stock’ if the inventory level is > 0, the inventory is not tracked or if overselling is enabled
4. Default value: ‘out_of_stock’
Google Product CategoryEither the digital ID number or full name as shown on the complete list of all Google product categories. For example, you may upload either ‘7398’ or ‘Animals & Pet Supplies > Pet Supplies > Bird Supplies > Bird Gyms & Playstands’YesYes1. The Variant Google Shopping Field value of Google Product Category
2. The Product Google Shopping Field value of Google Product Category
3. Product Type (if it matches a Google Category name)
4. Product Category (if it matches a Google Category name)
5. Product Tag (if it matches a Google Category name)
Product TypeOne single Unicode string representing the custom product typeYesYes1. The Variant Google Shopping Field value of Product Type
2. The Product Google Shopping Field value of Product Type
3. Product custom product type
BrandOne single Unicode string representing the custom brand; blank if no GTIN is providedYesYes1. The Variant Google Shopping Field value of Brand
2. The Product Google Shopping Field value of Brand
3. Product vendor
Age Group’newborn’, ‘infant’, ‘toddler’, ‘kids’ or ‘adult’YesYes1. The Variant Google Shopping Field value of Age Group
2. The Product Google Shopping Field value of Age Group
3. Variant option value for the option with name “Age Group”
4. Product tag value that starts with “age_group”
Gender’male’, ‘female’ or ‘unisex’YesYes1. The Variant Google Shopping Field value of Gender
2. The Product Google Shopping Field value of Gender
3. Variant option value for the option with name “Gender”
4. Product tag value that starts with “gender”
Condition’new’, ‘refurbished’ or ‘used’YesYes1. The Variant Google Shopping Field value of Condition
2. The Product Google Shopping Field value of Condition
3. Default value: “new”
ColorUp to 3 alphanumeric strings each representing a color, separated by a slash (/). For example, you may upload ‘Blue’ or ‘Red/Yellow/Green’YesYes1. The Variant Google Shopping Field value of Color
2. The Product Google Shopping Field value of Color
3. Variant option value for the option with name “Color”
4. Product tag value that starts with “color”
5. Variant option value for the option with name “Colour”
6. Product tag value that starts with “colour”
MaterialOne single Unicode string representing a materialYesYes1. The Variant Google Shopping Field value of Material
2. The Product Google Shopping Field value of Material
3. Variant option value for the option with name “Material”
4. Product tag value that starts with “material”
SizePlease refer to the Google Merchant Center Help page for a comprehensive list of supported size input examples. For example, you may upload ‘XS’, ‘M’ or ‘3XL’YesYes1. The Variant Google Shopping Field value of Size
2. The Product Google Shopping Field value of Size
3. Variant option value for the option with name “Size”
4. Product tag value that starts with “size”
Size system’AU’, ‘BR’, ‘CN’, ‘DE’, ‘EU’, ‘FR’, ‘IT’, ‘JP’, ‘MEX’, ‘UK’ or ‘US’YesYes1. The Variant Google Shopping Field value of Size System
2. The Product Google Shopping Field value of Size System
3. Variant option value for the option with name “Size System”
4. Product tag value that starts with “size_system”
Size type’regular’, ‘petite’, ‘plus’, ‘tall’, ‘big’ or ‘maternity’YesYes1. The Variant Google Shopping Field value of Size Type
2. The Product Google Shopping Field value of Size Type
3. Variant option value for the option with name “Size Type”
4. Product tag value that starts with “size_type”
Unit Pricing MeasureOne positive numberYesYes1. The Variant Google Shopping Field value of Unit Pricing Measure
2. The Product Google Shopping Field value of Unit Pricing Measure
Unit Pricing Measure UnitPlease refer to the list of all supported units belowYesYes1. The Variant Google Shopping Field value of Unit Pricing Measure Unit
2. The Product Google Shopping Field value of Unit Pricing Measure Unit
Unit Pricing Base MeasureOne positive whole number (integer)YesYes1. The Variant Google Shopping Field value of Unit Pricing Base Measure
2. The Product Google Shopping Field value of Unit Pricing Base Measure
Unit Pricing Base Measure UnitPlease refer to the list of all supported units belowYesYes1. The Variant Google Shopping Field value of Unit Pricing Base Measure Unit
2. The Product Google Shopping Field value of Unit Pricing Base Measure Unit
Manufacturer part number (MPN)One alphanumeric string containing up to 70 characters; blank if no GTIN is providedYesYes1. The Variant Google Shopping Field value of MPN
2. The Product Google Shopping Field value of MPN
3. Variant SKU
Global Trade Item Number (GTIN)One alphanumeric string containing up to 70 charactersYesYes1. The Variant Google Shopping Field value of GTIN
2. The Product Google Shopping Field value of GTIN
3. Variant Barcode
Custom Label 0One string containing up to 100 Unicode charactersYesYes1. The Variant Google Shopping Field value
2. The Product Google Shopping Field value
Custom Label 1One string containing up to 100 Unicode charactersYesYes1. The Variant Google Shopping Field value
2. The Product Google Shopping Field value
Custom Label 2One string containing up to 100 Unicode charactersYesYes1. The Variant Google Shopping Field value
2. The Product Google Shopping Field value
Custom Label 3One string containing up to 100 Unicode charactersYesYes1. The Variant Google Shopping Field value
2. The Product Google Shopping Field value
Custom Label 4One string containing up to 100 Unicode charactersYesYes1. The Variant Google Shopping Field value
2. The Product Google Shopping Field value

Note: The values listed above are all case-sensitive.


List of All Supported Units

The following units are supported in Unit Pricing Measure Unit and Unit Pricing Base Measure Unit attributes in Google Shopping.

  • Weight: ‘oz’, ‘lb’, ‘mg’, ‘g’, ‘kg’
  • Volume (US Imperial): ‘floz’, ‘pt’, ‘qt’, ‘gal’
  • Volume (metric): ‘ml’, ‘cl’, ‘l’, ‘cbm’
  • Length: ‘in’, ‘ft’, ‘yd’, ‘cm’, ‘m’
  • Area: ‘sqft’, ‘sqm’
  • Per unit: ‘ct’

Methods to Edit Google Shopping Fields

You can edit Google Shopping fields either by bulk-edit based on filters, or import them from a Spreadsheet CSV/Excel file. We are going to introduce both of these methods.

Method #1: Filter based bulk edit

To bulk edit Google Shopping fields, go to Create Task, open Products and select Google Shopping.

  1. Set up the filter to select the products you want to bulk edit and preview the matching products.
  2. Choose how to edit matching products/variants. In this step, select whether you want to bulk edit a product or variant Google Shopping field, then choose the specific field you want to edit.
  3. Then fill in the value for the Google Shopping field you want to update. For fields with fixed value options, select the desired value from the dropdown; otherwise, enter the value in the text box.
  4. Click Start bulk editing and the app will update the Google Shopping fields for all matching products/variants.

Method #2: CSV file based bulk edit

To edit Google Shopping fields by importing CSV/Excel spreadsheet files, go to Create Task > CSV import > Products.

Follow the usual steps to upload and preview your spreadsheet file. On Step 4: Column for searching and columns for editing:

  1. Select the column in your spreadsheet that contains the attribute you want to edit.
  2. Choose Product Google Shopping Field if you’re editing product fields, or Variant Google Shopping Field if you’re editing variant fields.
  3. Select the specific field you want to edit using the corresponding column in your spreadsheet.
  4. Then click Start import.

If you have any additional questions about the topic feel free to chat us or email us at help@hextom.com