For more details see the Product Feed extension page.
Create product feeds for Google Shopping, Nextag, Bing, Amazon and many other comparison shopping engines to attract more customers and drive sales to your Magento store.
To create a product feed, please go to Catalog → 'Feeds' section → Profiles.
When you create a feed, you can use ready-made templates. In this case, the feed will contain all the basic settings for the certain shopping search engine. You can do any custom adjustments while creating a feed or you can do them later.
To duplicate, generate and delete feeds in bulk select the feeds you need, click the button 'Actions' and choose the action.
Name - specify feed name.
File name - specify the feed file name.
Type - choose product feed format (XML, CSV or TXT)
Store - select for which store view you want to create the feed
Status - here you can activate or deactivate the feed.
Compress - you can set to compress the feed to Zip, Gz or Bz format when it generates and uploads to the server.
Exclude Disabled Products - set to Yes to exclude products with the disabled status from the feed.
Exclude Out of Stock Products - enable the option if you don't want to include out of stock products to the feed.
Exclude Not Visible Products - set to Yes to skip not visible products so that they won't be included in the feed.
The 'Content' tab allows configuring product data that are included in the product feed. The functionality of the tab depends on the format you select at the ‘General’ tab. If you choose XML format, you will get fields for entering the feed header, footer and product information.
Header - used to place some info into the XML header.
Item - a tag which will wrap each product in the feed.
Content - an XML editor where XML tags and attribute codes are inserted.
Tag - XML tag for the entity set up below. To add a line of data to a feed, please enter the attribute XML tag according to the specification of a particular shopping search engine (e.g. for google.com XML tag will be g:price).
Attribute - when you configure product data, you can add a new attribute, image and other entity. For example, add a Price with TAX(VAT) attribute to get more relevant information on the product prices.
Format - here you choose a format of the attribute field (as it is, data format or price format)
Optional (available only for XML feeds) - use the option to exclude an attribute which have an empty value for a product from the feed. When set to Yes: the attribute will not be added to the feed for a product for which it has an empty value.
Parent - when enabled, simple products which are associated with configurable products will output attribute value from the parent configurable product.
Footer - used to place some info into XML footer.
It is possible to add modifiers for cases when you need to modify the original values of an attribute. To do this, use ‘Add modifier’ action; select one action from the available range:
When you've chosen the modifier, click the Insert button to apply it.
In this example, we apply “HTML Escape” modifier to escape special symbols from the product description. It is important for XML format as special symbols can be treated as part of XML markup and break feed file.
For your convenience, attributes' codes are displayed when selecting an attribute to insert into the product feed.
You can also use a category mapping for any shopping platform. All you need to do is to add a new attribute from the list:
In the ‘Formats’ section, you can specify the date format for the feed file, choose how many digits should be displayed after delimiter for decimal prices. You can also specify price currency and abbreviation for it.
It's also possible to create a feed for specific products. For example, you can add configurable products in one feed, and simple products to another. At the ‘Conditions’ tab, you can specify the products that will be included into the feed you are editing.
In our example, we specified the conditions to generate the feed only for the products from the Category 36 and with the Attribute Set 'Bag'.
Decide whether to generate feed manually or by schedule. When you choose to generate feed by schedule, also specify the precise day and time of its generation.
Enable feed download on the ‘FTP Settings’ tab and enter FTP account credentials where the feed will be uploaded.
Host - FTP\SFTP server hostname or IP address.
User - FTP\SFTP username.
Password - FTP\SFTP password.
Path - path to directory on FTP\SFTP server. Please note: this path is set relative to FTP\SFTP user home directory. If the home directory is already set to desired feed destination then you don't need to set Path.
Passive Mode - can enable Passive mode for FTP connections. More on FTP modes here.
Click the Test connection button to check whether the data for the FTP\SFTP connection is correct.
These settings allow you to set utm-parameters, that will be added to the urls in your feed. Thus, you can collect all the statistics to your Google Analytics account. NOTICE: the fields Campaign Source, Campaign Medium and Campaign Name are REQUIRED.
When the feed is configured, press the Preview Feed button to preview the feed before its generation:
If you need to make changes to your store’s categories to suit the requirements of the platform where you would like to upload your feed (for example, Amazon), please go to сategories section.
Go to Catalog → 'Feed' section → Categories
To create new category mapping, please specify the name and code here.
Click on the category name to activate it and specify a new name. After you click ‘Save’ the name will be changed; previous category name will be displayed in brackets.
How does it work?
To IGNORE and exclude particular categories from the feed, CHECK the necessary boxes.
For example, if a product is assigned to the categories “Bags” and “Sale”, the extension will choose the category with the biggest value by default. In our case, it can be “Sale”. If you want to assign the product only to the “Bags” category - select the “Sale” checkbox to ignore it.
To create a new custom field, please, go to Catalog → 'Feed' section → Custom Fields → Add Custom Field button.
Custom fields are used to cover special cases: for example, when you need to change some attributes values or replace prices when meeting special conditions. You have the ability to create rule-based values for these fields.
In the example below, we've configured the rule-based custom field: when the product's Size attribute value is XS, the Price attribute for this product will be discounted for 10%.
Let's check the configuration steps:
In the General section, specify the Code and the Name for your custom field.
Then, determine Conditions for Output Value. On this step, choose attributes and their values that will be a trigger for applying the Output Value, configured below, instead of the original.
To configure the Output Value, choose the Attribute that should be changed when conditions apply, and specify the Modification to it (text, percentage or fixed value). If the Modification field contains text, the value of the custom field will be replaced with this text.
You can also specify the Default Output Value, that will be used if none of the conditions applies.
When a custom field is configured, you can insert it as an attribute to your product feed (available for all formats: xml, csv, txt):
Here are some more examples of custom fields you can configure:
When the “Price” value equals or greater than 50, replace the “Tax Class” value to “Taxable Goods”.
Replace the “Size” attribute value for “All Sizes”, when the “Gender” attribute is either “Women” or “Girls”.
Go to Admin Panel – Stores – Configuration – Amasty Extensions – Product Feed
Batch Size - specify how many products will be handled during one iteration.
URL with category - to generate an appropriate product feed, switch between shortest and longest URL paths.
Shortest Path — uses the shortest possible path in product URL;
Longest Path — uses the longest possible path in product URL;
Default Rule — utilizes the default Magento 2 rule for URLs, deactivates the extension.
For example, you have a product that is listed in 2 categories, therefore, it's available via two links:
If you choose the Shortest Path, the extension will use the first link, if you select the Longest Path - the second URL will be used.
Products in Feed Preview - specify the number of products you want to be displayed in the feed preview.
In the Email Notifications section, specify:
In the Cronjob Information section, check the information on the latest cron jobs.
Since Facebook is using the same feed format and tags as Google, the feed profile we're going to create here will work for both Google and Facebook.
Go to Feeds and click the Setup Google Feed button.
To map your category to category in Google taxonomy simply click on the category name and insert suitable category path from Google taxonomy:
Hit 'Proceed to next step' to continue.
Wizard will have all fields already filled for you so you can skip to the next step if you don't want to make any changes.
But in case you want, for example, to use short description instead of the description in your feed, then you can do it like this:
The same can be applied to all other attributes.
Also check the Options section. There you can select which storeview to take attribute values from. It's very useful when you have a multilingual store, for example, so you can create feeds using the names or descriptions in specific languages. Same works for currencies. If you have a multistore configuration with different currencies set for each store then this setting will make the Feed fetch product prices in the currency assigned to the specific store.
Hit 'Proceed to next step' to continue.
Just as in previous step here we see a list of attributes. But this time which attributes to use greatly depends on what you are selling. Google has different requirements for data that should be included in the feed. The requirements depend on your store location and the type of products you export.
For example, if you sell apparel and the Condition tag is set to New in your products, you will need to have attributes gtin, mpn and brand in the feed.
Brand should be set manually. For example, in our case, we have the brand info saved in the manufacturer attribute, so we choose it in the drop-down.
In the following example we're going to set up a feed to be uploaded to the Google servers daily, once a day, using SFTP in fully-automatic mode.
We should start from the Google Merchant account setup. Add a new feed:
The next one is important because the name of the feed file you set here should match the actual name of the file you're going to upload to Google. The same name we're going to use in Wizard a bit later:
Return to the Product Feed extension, step 4, choose SFTP as the upload method and enter the data you have received from the Google Merchant dashboard. Here also goes the filename you've set in the Google Marchant feed settings. Switch the Generate feed setting to Daily, and you’re done!
Here’s how the configured step 4 may look like:
As you click Finish and start generation, the feed profile will open and the feed generation will start, and because we configured the SFTP upload, the feed will go to the Google server, too.
After the file is uploaded to the Google server, it will be automatically processed.
Related help article on Google support site.
To let Google know that simple and configurable products you submit in the feed are related, you should use g:item_group_id tag. Add this tag to your feed profile, set it to output SKU attribute and enable Parent option.
With this setup, Feed extension will export products with same g:item_group_id if they are related, i.e. if they are associated products of the same Configurable Product. Then Google will check g:item_group_id value and treat these products as a variant of the same product.
In the most cases, this error appears when your feed has special characters inside tags. Please note the line number in the error message, then open your XML feed file and check the aforementioned line. Note the tag used in this line, then open feed profile, find the tag and add a modifier “HTML Escape”
Click Update, save and generate the feed.