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

Go to Catalog ? Feeds ? Profiles and click the Setup Google Feed button to launch the Feed Wizard:

magento-2-product-feed-by-amasty

google-feed-wizard-by-amasty

 

Step 1. General Settings

magento-2-google-feed-wizard

 

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.

magento-2-google-feed-wizard-exclude-cat

 

 

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:

magento-2-google0feed-wizard-rename

 

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:

magento-2-goole-feed-wizard-basic-info

 

 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.

magento-2-google-feed-wizard

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:

magento-2-google-feed-wizard-extra-info

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:

attribut-gtin-feed-wizard

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:

feed-wizard-step-3-by-amasty

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.

magento-2-google-feed-wizard-auto-updates

 

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:

magento-2-google-feed-wizard-upload

 

At the first step, you need to test the feed to make sure it meets Google requirements:

magento-2-product-feed-test

 

Now that you’ve double-checked the feed, it’s time to upload it:

magento-2-product-feed-wizard

 

 

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:

magento-2 goole-feed-wizard-name-check

 

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:

 

magento-2-product-feed-config
Select the SFTP and click Reset password. The Merchant Center will return the server address and login, which you need to complete the integration in the Google Feed Wizard:

Magento-2-google-feed-wizard-reset

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:

magentp-2-google-feed-wizard-start

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.