You can use Shopify to publish your products to Google Shopping. To give your products the best visibility, there's additional fields that you can configure within the Shopify admin:
This works great for editing a single product but there's no way to edit multiple products at once and going through, product by product, can take days.
In this article we'll show you how to you can edit these fields for multiple products at a time, either in the app or via a spreadsheet.
- You have the Bulk Product Editor app installed
- You've installed the Google Shopping app and have it set up
Editing Google Shopping Fields in the App
If you need to set a Google Shopping field for a lot of products to the same value, you can use the In-App Edit. After you've searched for the products you want to edit, click on the blue Modify Products button.
In the next section, click on the Field to Edit dropdown and scroll to the Google Shopping Fields section. Choose the field you want to edit (Age Group, for example) and then set the value for the field:
Then click Run Edit and the products will start updating.
Editing Google Shopping Fields with a Spreadsheet
In some cases you might want to set a field to have different values for different products (for example, the Manufacturer Part Number field). The easiest way to do this is to prepare a spreadsheet with two or more columns. The first column contains a product identifier (usually handle, title or product ID) while the additional columns contain the values you want to edit.
The file should look something like this:
Once you have the file ready, open up the app and go to the Spreadsheet Edit section. Click on the upload button and to upload your spreadsheet.
The app will analyze the spreadsheet and then show you the first 20 rows. In the Set to Field dropdown, scroll to the bottom and select the Google Shopping field you want to edit.
For example, here we're editing the Manufacturer Part Number:
Once you have the field selected, click on Run Edit and your products will be updated.
Caveats with Editing Google Shopping Fields
Shopify stores the Google Shopping Fields using metafields, which is different from how most fields are stored. This has a few implications:
- Edits will take longer to run since we need additional API calls to update each product
- If you're doing an In-App Edit, you won't see the old value of the Google Shopping Field in the preview box
- You won't be able to undo the edits for Google Shopping Fields. Instead, you can create a new edit to set the field back to its original value