Hey, Amasty blog readers!
Back in March 2018, when Google stopped to support Google Shopping ads integrations with e-commerce platforms, including Magento, we solved merchants’ problem by leveraging our Magento 2 Product Feed and Magento Product Feed extension powered up with Google Feed Wizard.
In 2019, we decided to look at the Wizard once again and streamline it to make it even more efficient.
Now let’s see how it works.
Spoiler: now you can use the Wizard to generate Facebook feeds!
- Step 0. Open Feed Wizard
- Step 1. General Settings
- Step 2. Exclude Categories
- Step 3. Rename categories
- Step 4. Basic product information
- Step 5. Optional product information
- Step 6. Update schedule
- Step 7. Run and upload the feed
Step 0. Open Feed Wizard
Go to Catalog ? Feeds ? Profiles and click the Setup Google Feed button to launch the Feed Wizard:
Step 1. General Settings
Here you can set most of the settings with the help of drop down menu. You only need to set Feed Name and File Name by yourself.
Step 2. Exclude Categories
Tick off the categories that you want to ignore and they will not get to the Google shopping feed.
For example, suppose a product is assigned to the categories “Women” and “Tops”. By default, the extension will choose the category with the biggest value. In our case, it is “Women”. To include only the “Tops” category in the feed, mark “Bottoms” in the checkbox. Ticking off irrelevant categories, you can quickly create feeds featuring multiple products.
Step 3. Rename categories
To include your ads in relevant search results, Google needs to understand your categories data. This happens smoothly only if you map categories data according to its standard (Google taxonomy).
For example, you have a category named “Shorts” where you sell summer shorts for men. First, find a relevant product name in the Google’s list of product categories. In our case, there are 4 category paths with the word shorts:
- Apparel & Accessories > Clothing > Activewear > Martial Arts Shorts
- Apparel & Accessories > Clothing > Activewear > Boxing Shorts
- Apparel & Accessories > Clothing > Activewear > Bicycle Activewear > Bicycle Shorts & Briefs
- Apparel & Accessories > Clothing > Shorts
The last one suits our product best. Now let’s copy the whole path, go back to the Google Feed Wizard, and rename the category simply by clicking on the checklist. For your convenience, the previous name is shown in brackets.
Here is how your categories may look like:
Well, categories are set and customized. It’s time to proceed to the next step.
Step 4. Basic product information
The Google Feed Wizard automatically fills all the fields for you, so you can skip Step 4 unless you want to make changes to the product feed (for example, to replace a full description with a short one in the description tag or show the price with VAT instead of a default one). Just choose the right option in the drop-down menu:
Mind the Condition field. By default, the state of the item is set as New. If you sell used or refurbished items, remember to change this setting accordingly.
Create Google shopping feeds for multiple stores (available in General Settings)
Use the Options section to specify the store from which your Magento 2 should take the product and currency data. Suppose you have two stores – one in the USA and one in the UK. As in the US store prices are in dollars, you should also choose dollars as the base currency while generating the feed. Otherwise, Google will reject your product feed. So, be careful!
Step 5. Optional product information
Depending on the items you sell, you may need to configure some extra attributes for the product feed. For example, if you sell new apparel, you need to fill brand, gtin, and mpn.
In our example, we created the Manufacturer attribute in Magento 2 and saved all brand information there. Now to let Google recognize our brand information the way we keep it in the store, we just choose the Manufacturer attribute in the drop-down menu:
To configure gtin (Global Trade Item Number) and mpn (Manufacturer Part Number) attributes, you have to create them first. For this, go to Stores – Attributes – Product and click on Add New Attribute. Then configure the settings like in the example below:
Small tip: Read this Google article to learn more about gtin and mpn.
After you created these attributes, set them for each product. If you don’t need any attributes because of the target country or product type, just select the None option and the tag won’t be added to the feed profile.
This is how Step 3 configurations can look like:
Step 6. Update schedule
Now you can automate feed updates due to the module’s seamless integration with cron. This significantly reduces the time needed for efficient feed management.
Step 7. Run and upload the feed
As an example, let’s set the feed to be uploaded to Google servers once a day via SFTP. First, go to Settings in the Google Merchant Center account and add a new feed as the screenshot shows:
At the first step, you need to test the feed to make sure it meets Google requirements:
Now that you’ve double-checked the feed, it’s time to upload it:
NB: You should name the feed file in the Google Merchant Center exactly as in the Google Feed Wizard. For the first time, why not upload a test feed to check mistakes in the feed profile? Just in case:
Now let’s configure how the feed is sent to the Google Merchant Center. On the Google Merchant dashboard, go to Settings > SFTP / FTP / GCS:
Almost done! Now let’s return to the Magento 2 Admin Panel. Step 7 of the Google Feed Wizard is still active. Choose SFTP as the upload method and enter the data you got from the Google Merchant Center.
Here’s how a configured Step 7 looks like:
To complete the feed creation, click Finish and start generation in the upper right corner. The feed will be generated by the extension and sent to the Google server straight away. Then Google checks your file and if there are any errors, you will need to correct them and re-upload the feed.
We hope the new Feed Wizard tool will help you set up Google feeds faster than ever.
Feel free to ask questions and comment below.