How do I bulk edit Google Shopping attributes? •
All Google Shopping fields are product and variant 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 BPE, you may be able to import almost any value to your Shopify store as Google Shopping fields through CSV Import on BPE. 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.
| Field | Value | Can be Edited as Product Field | Can be Edited as Variant Field |
| Custom Product (Whether this product is a custom product) |
'true' or 'false' | Yes | - |
| Google Shopping product category | either 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' |
Yes | - |
| Age | 'newborn', 'infant', 'toddler', 'kids' or 'adult' | Yes | Yes |
| Gender | 'male', 'female' or 'unisex' | Yes | Yes |
| Condition | 'new', 'refurbished' or 'used' | Yes | Yes |
| Color | Up to 3 alphanumeric strings each representing a color, separated by a slash (/). For example, you may upload 'Blue' or 'Red/Yellow/Green' | Yes | Yes |
| Material | One single Unicode string representing a material | Yes | Yes |
| Size | Please refer to the Google Merchant Center Help page for the size attribute for a comprehensive list of supported size input examples. For example, you may upload 'XS', 'M' or '3XL' | - | Yes |
| Size system | 'AU', 'BR', 'CN', 'DE', 'EU', 'FR', 'IT', 'JP', 'MEX', 'UK' or 'US' | Yes | Yes |
| Size type | 'regular', 'petite', 'plus', 'tall', 'big' or 'maternity' | Yes | Yes |
| Unit pricing measure | One positive number | Yes | Yes |
| Unit pricing measure unit | Please refer to the list of all supported units below | Yes | Yes |
| Unit pricing base measure | One positive whole number (integer) | Yes | Yes |
| Unit pricing base measure unit | Please refer to the list of all supported units below | Yes | Yes |
| Manufacturer part number (MPN) | One alphanumeric string containing up to 70 characters | Yes | Yes |
| Custom Label 0 | One string containing up to 100 Unicode characters | Yes | Yes |
| Custom Label 1 | Yes | Yes | |
| Custom Label 2 | Yes | Yes | |
| Custom Label 3 | Yes | Yes | |
| Custom Label 4 | Yes | Yes |
Note that 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, select "Google Shopping" from the navigation bar or the dashboard.
After setting up the filter and previewing matching products, go to "Step 3: Choose how to edit matching products/variants". In step 3, select the Google Shopping field to edit. Note that you need to specify whether you are going to edit product or variant fields for the matching products: the upper half of the dropdown options are product fields, while the lower half are variant fields.
If you select a variant field, an Optional Step panel will pop up above Step 3 to allow you to filter variants to edit.
On Step 3, fill in the value for the Google Shopping field you wish to bulk edit to. For fields with fixed candidates for values, select the desired value from the dropdown; otherwise, fill in the value in the text box. Select "Start Bulk Edit Now", and BPE will bulk-edit the Google Shopping fields for matching product they way you want!
Method #2: CSV file based bulk edit
To edit Google Shopping fields by importing CSV/Excel spreadsheet files, select "CSV Import" from the navigation bar or the dashboard.
Follow the usual way to upload and preview the spreadsheet file. On "Step 4: Column for searching and columns for editing":
- Select the column of your spreadsheet containing the attribute you wish to edit.
- Select "Product Google Shopping" from the list of options to update if you are editing product fields, or "Variant Google Shopping Field" if you are editing variant fields.
- Select the Field you wish to edit using the column in the spreadsheet file.
