Data Feed Manager
Starting at
€95
Export your products from your Magento website into csv, txt and xml data feeds for any shopping engine or market place! This extension includes all Google Shopping features and 19 sample templates.
Starting at
€95
Orders Export Tool allows you to create xml, csv and txt order files from your Magento admin panel and export them to any CRM application or order management software/platform. Any kind of export file types can be easily customized.
Starting at
€95
How to use Data Feed Manager?
STEP 1: Configure Data Feed Manager in a general way
Before being able to configure your data feeds, you should configure the extension in a general way. To do so, go to
System Config Wyomind Data Feed Manager
Cron job reporting
In the Cron job reporting tab, you can activate the cron job reporting and fill in an email address to receive the reports. You can also rename the reports as you want.
Core Settings
In the Core Settings tab, you'll need to configure a certain number of fields.
- Items in preview
By default there are 10 items in preview, if you want you can reduce or increase that number. - Items in buffer
By default, products are inserted into the file on the server every 10 items but you can reduce or increase that number. - Items in each MySql query
By default, there are 1500 items in each MySql query. - Number of advanced filters
By default, you have 10 advanced filters. If you need more, you can at any time increase that value. - Include disabled products
You have the possibility to include or not disabled products in your data feed. - Use of OR/AND statements in advanced filters
and/or statements can be used in the advanced filters simply by enabling that option. - Use canonical urls
You have the choice between several options. You can choose to use the shortest category url, the longest one or the product url. - Include not in menu categories
You can also include the categories of products that are not in the menu. - Use configurable product categories instead of the child product categories
Use the categories of the configurable products instead of the child ones. - Php memory limit
The default memory limit is 1024. - Allow trans-domain import/export
Allow import and export options. - Enable log file
Enable or disable log file.
STEP 2: Manage your data feeds with Data Feed Manager
To create and configure your data feeds, click on Create new template from:
Catalog Data Feed Manager Data Feeds
From there, you can also apply mass actions, for example delete or change the status of several data feeds in one time.
The Tool Box or so-called "Black Box"
When creating a data feed, you should see a blackbox on the right of your screen. The Data Feed Manager extension includes that tool to help you create your feed and see what is wrong.
The blackbox is inevitably a very useful tool. This will help you to configure your data feed more quickly.
Here are the different options of the blackbox:
Syntax Validation
The Check syntax button allows you to check if your syntax is correct. It helps you to see if you have forgotten a bracket or a comma by underlining in yellow the part of text that contains a mistake.
Library
If you click on Load Library , a library of your store attributes will be displayed. This makes it easier to find very quickly which attribute you need to add into your template.
Data Preview
When clicking on Check Data , you'll see a preview of your data feed. It's very useful to see if the values of your attributes are correctly retrieved or if your filters are working.
Export and import your templates
Data Feed Manager also allows you to export and import templates into/from your Magento admin.
Export
To export a template, select an existing feed from:
Catalog Data Feed Manager Data Feeds
From the dropdown under the Action column, you can choose to Export that data feed template. You can also choose to Edit the data feed and then click on Export .
Via both ways, a popup window opens and allows you to save the data feed template as a .dfm file. After that, you should find the data feed template in your 'Downloads' folder.
Import
Before anything, to import a data feed template, it must be a .dfm file.
To do so, go to:
Catalog Data Feed Manager Data Feeds
Click on Import a template . Browse the .dfm file and click on Import now .
Now, you should see that the data feed has been imported at the end of the grid in:
Catalog Data Feed Manager Data Feeds
Configuration
When creating a new data feed, you have to configure a certain number of parameters from:
Catalog Data Feed Manager Data Feeds
In that first tab is the main configuration of the data feed. You'll find several fields to fill in.
- Feed name
Enter the name of your feed. For example:
GoogleShopping - File type
Choose the format of your file between xml, csv, txt and tsv. - File name format
You have several format possibilities for your file name. For example you could choose:
GoogleShopping-2015-01-26.xml - Encoding type
Choose the encoding type of the data feed. - Path
Define the path where you want the data feed to be generated. For example:
/feeds/ - File status
Enable or disable the file. - Store View
Define which store view is concerned.
The following fields vary according to the file type you're configuring.
XML files
If you want to configure an XML file, fill in:
- Enclose xml tag content inside CDATA (recommended)
Enclose xml tags inside CDATA or not. - Remove all empty xml tags (recommended)
Remove empty xml tags or not. - Header pattern
Add your header pattern in that field. - Product pattern
This field is inevitable to configure your product pattern. - Footer pattern
Add your footer pattern in that field.
CSV, TXT, TSV files
For CSV, TXT and TSV files, fill in:
- Extra header
It will add whatever you write on the top of your file (fit in with Amazon requirements). - Include header
Allows you to include or not columns names in the first row of your file. - Columns name
Is for the attribute name (you need to look in the shopping engine specifications to know which names are required). - Pattern
Works in the same way than XML files. For example, {url} will return the product's url. You can also add any static values. - Add field button
Click on it to add a new column to your template. The fields order can be easily reordered by using the up and down arrows. - Extra footer
You can add an extra footer in that field. - Fields delimiter
Lets you choose which kind of delimiter you want to use to separate your fields. - Fields enclosure
Lets you choose which kind of enclosure you want for your data. - Escape character
Define the escape character between \ or ''.
Categories filter
You can filter your categories according to two different ways:
- Exclude all products from the selected categories.
- Include all products from the selected categories.
Note that if you don't select any category, all products will be exported.
For example, if you wish to include only products of the Apparel category, you can configure your filter in two different ways.
First of all by ticking the Include option that will allow you to include all categories that you have selected.
Or via the Exclude option that will exclude all categories you have selected.
Category mapping
In that subtab, you can map your categories to the ones of marketplaces. This step is very important so that they can make a link between their product categories and yours.
What is a category mapping?
Categories names you are using in your Magento aren't always the same than the ones used by marketplaces to reference your products.
This means you have to find out which categories have the best matching with yours, according to their taxonomy.
For example with Google Shopping, if you're selling furnitures like coffee tables, you'll have a Coffee table category in your Magento admin. But Google Merchant doesn't handle this kind of category. The closest Google product category could be Kitchen & Dining Room Table.
How to map your categories with Data Feed Manager?
Data Feed Manager provides you an easy way to input the categories of the marketplaces that are matching yours.
In your data feed configuration, for example Google Shopping. Go in the Categories tab. Then, in Category selection and mapping section, you'll find a treeview of all your categories.
First select the Google Taxonomy source on which the category mapping is based.
Taxonomy files for the main countries are directly included to allow you to map your categories more easily. You can also have a look to below documentation to know how to add a new taxonomy file.
For each category, you have a little arrow followed by mapped as. There, you'll be able to start typing a keyword in order to display a list of all categories including that keyword. You simply need to select the one you need.
Note that if you press the End key of your keyboard after typing a category mapping, the value will apply to all sub-categories.
Once all your categories are mapped, you can click on SAVE .
Here are a few guide lines for choosing the most appropriate category:
- Use the category that best describes your item. To do this, first determine the primary function of the products you are submitting. For specific items like MP3 Players, select the MP3 Players category. While some MP3 players can also serve different functions, like those that contain a clock, they are primarily MP3 Players.
- Use only one category. For some products, more than one category might be relevant. For example, an adapter to allow an MP3 player to be used in a car could be in both categories Motor Vehicles > Audio & Video and Electronics > Audio > Audio Accessories > MP3 Player Accessories. In such cases, choose the category that seems the most appropriate to you, but don't include more than one.
- Use the most specific category possible. Being specific will help to improve your data quality and so ensure that offers are presented in the right category. When viewing the taxonomy, try to navigate to the most specific category that still covers all the products that are being submitted. For instance, if you are submitting MP3 player chargers use the MP3 Player Chargers category. Conversely, if you are submitting multiple types of chargers use the Chargers category.
How to include the category to the XML template?
Finally, so that the category is retrieved in your data feed, you must add the following attribute to the XML template:
<category>{category_mapping,[0]}</category>or for Google:
<g:google_product_category>{category_mapping,[0]}</g:google_product_category>
or
{G:GOOGLE_PRODUCT_CATEGORY}Please note that this attribute is different from Product Type which is for the categories that you have defined independently in your Magento back-office.
How to add a new taxonomy file?
The taxonomy is a tree of categories that will help you match your categories to the ones of marketplaces. For example with Google Shopping, it lists all possible values for the 'Google product category' attribute.
In that page, choose the language you want to use for your taxonomy at the bottom right. Then, in the Downloadable taxonomy, open the Plain Text link that contains full category names.
Save that file and paste it in:
Magento Root DirectoryLibWyomind google
Don't forget to apply the permissions 755 to the file.
You'll then be able to choose that specific taxonomy from your data feed configuration in the Categories tab.
Filters
Data Feed Manager also allows you to filter your products on several levels according to their attribute sets or their visibility for example.
With Data Feed Manager 7.3.0 and Simple Google Shopping 9.0.0, you can now select all the filters in one click.
Product Type
First of all, you can choose to include products to your feed according to their type. For example, don't include grouped products.
Attribute Set
You have the choice to include the attribute sets you want.
Product Visibility
Then, choose the products that will be included to the feed between the products that are not visible individually, products from the Catalog, the Search results, or both.
Advanced Filters
In the Advanced filters, you can go further by setting more personalized filters.
For example, we wanted to include only products which are enabled, and which SKU and name are not null.
Here again, you have the possibility to configure your advanced filters according to several options.
- LIKE / NOT LIKE
name like %shirt: will include all products which name ends with 'shirt'.
name like Apple%: will include all products which name starts with 'Apple'. name like %women%: will include all products which name contains the 'women' character string. name not like %shirt: won't include any product which name ends with 'shirt'.name not like Apple%: won't include any product which name starts with 'Apple'. name not like %women%: won't include any product which name contains the 'women' character string.
- IS NULL / IS NOT NULL
Special price is null: will include all products that don't have special prices.SKU is not null: will include all products which SKU is not null.
- IN / NOT IN
Brand in Acer Apple Sony: will include only products from these 3 brands.Brand not in Dell Toshiba: will include all products which brand is not Dell or Toshiba.
Advanced filters can be grouped into sub-division by using AND/OR clauses.
Example:(SKU LIKE ABC% AND Brand = Acer) OR (Brand IN Dell, Toshiba AND Price >= 99.99)
The option must be enabled in
System ConfigurationWyomind Data Feed Manager
Scheduled Tasks
Data Feed Manager provides you a fully configurable schedule in the Scheduled task tab of your template configuration for each data feed. You just have to tick the days and hours when you want your feed to be generated.
If you're facing some difficulties with scheduled tasks, or if you think your feed is not automatically generated, have a look to our faq on that subject.
FTP Settings
In Data Feed Manager, you can specify ftp settings to upload your data feeds.
Select a data feed and go to the Ftp Settings tab. There you'll be able to configure some parameters:
- Enable FTP upload
Select Yes if you want to upload your data feed using FTP. - Use SFTP
Select Yes if you are using SFTP.
Secure connection (sftp) is only available in the latest version of Data Feed Manager. - Use Active mode
If you are using SFTP, you don't have to care about the passive/active mode.
For more info about Active and Passive mode, have a look to that documentation. - Host
In that field, fill in the host. For example:
ftp.wyomind.com - Login
Is your login to connect to server - Password
Is your password to connect to server - Destination directory
Is a relative path from the entry directory when you connect to the ftp. For example:
upload/
or
/
In order to be sure your settings are correct, click on Test Connection .
- If you don't have an error message, it means the connection succeeded.
- If you have an error message, you'll certainly have to check your credentials.
Note that the file is uploaded each time the feed is generated manually or automatically. In the case where you didn't get error message while testing the connection, you'll need to check that the file is well uploaded.
STEP 3: Generate and download the data feeds
Generate the data feeds
With Data Feed Manager, you can generate your data feed manually or automatically.
Manually
There are two different ways you can use to generate your data feeds manually:
- You can generate your data feeds in the grid from the action dropdown.
- Or you can do it from the data feed configuration panel by clicking on GENERATE
.
Via the cron tasks
You can generate your data feeds automatically using the
First, check that the main
If it is disabled, a warning message will appear in Data Feed Manager:
Then, you have to select in the Scheduled Task tab, the days and timeframes when you want the data feed to be updated.
From the command lines
Data Feed Manager allows generating data feed via the command lines
php -f shell/wyomind_datafeedmanager.php -- [options]The following options are available:
- --generate
Generate all data feeds - --generate id1,id2,...,idN
Generate data feeds from the given list - --list
List all data feeds
Download the data feeds
When a data feed is ready to be downloaded, the link is displayed in both, the data feed grid and the data feed page at the top of the page. You can download the data feed directly by right-clicking + saving link as or from your ftp client if the directory where the data feed is stored is not publicly accessible.
Note that the random parameter at the end of the url avoids caching issue when you download the data feed from your Magento admin.
Manage your data feed templates thanks to Data Feed Manager
10 things to know when creating an XML data feed
All XML data feeds used by shopping engines, like the one used by Google Shopping, are really simple to build but often have their own specifications.
Simple Google Shopping and Data Feed Manager provide one or more ready-to-configure templates. These templates will allow you to build a valid and well-structured data feed quickly.
- An XML data feed is using an opening and closing tag that includes a value.
<tag>value</tag> - A data feed template is made of several tags including dynamic or fixed values.
<g:id>{sku}</g:id> <price>{price}</price> <g:brand>Fixed Brand</g:brand> - Dynamic values are called variables and use the attribute codes of your Magento website. Attribute codes must be surrounded by brackets
<g:id>{sku}</g:id> <title>{name}</title> <g:color>{color}</g:color> - Between every opening and closing tags, you can also include some fixed values. Fixed values are simply text.
<g:brand>YOUR BRAND</g:brand> - You have also the possibility to add several attributes and fixed values in a same tag.
<title>{name},available in {color}-{size} for only ${price}</title> - You're allowed to use PHP code if you want to customize the pattern. You just have to write your PHP code in one single line, and it will work perfectly (check how to add PHP scripts into your templates).
<g:gender><? if (stristr($product->getName(),"dress")) return "Female"; else "Male"; ?></g:gender> - The syntactic coloration in Data Feed Manager will help you to avoid any error in your template. First, the errors will be underlined in yellow. You need to correct each error before checking syntax once again. Finally, you'll be able to check data.
- Some Magic variables will act as shortcuts to create complete portions of XML in your data feed including the appropriate variables.
{G:PRODUCT_TYPE} - You can use one or more fallback variables in case the previous is empty or null.
{color | colour | custom_color}If attributeA exists then the value will be attributeA, otherwise, the value will be attributeB, etc...
- CDATA are recommended. CDATA stands for Character Data. It means that the data in between these tags include data that could be interpreted as XML markup, but should not be. (Wikipedia article).
<description> <![CDATA[<p>Fantastic <b>Watch</b>, that not only tells you what time it is, but also gives the weather trends</p>]]> </description>
10 things to know when creating a CSV/TXT data feed
Data Feed Manager allows you to generate CSV/TXT files in addition to XML files. This particular kind of file format is required by some shopping engines like Amazon, Shopzilla, Twenga, etc.
Data Feed Manager provides you all you need to create any specific CSV/TXT file that you want.
Each shopping engine has its own requirements and column names. Some require fields enclosure, others need specific delimiters.
You may also need to add a special header to your file (for Amazon data feeds for example).
- A CSV file consists of any number of records. Each record consists of fields, separated by some other characters or strings. There is one row per record (so, one per product).
Here is an example of CSV file content:
- You need to define delimiters to separate your fields ( '; ', ', ', or tab for example) and enclosures for your data (" or ').
- You can enter the attribute names in each Columns name fields (check the shopping engine specifications to know which names are required). For example:
- You can include in each Pattern field one or several Magento attributes. An attribute is specified by its code name and must be enclosed using brackets . For example, to return the product's description, you should use:
{description}
- You can also include some fixed values. Fixed values are simply text. For example, instead of the {manufacturer} attribute, you could use directly:
YOUR BRAND - You have also the possibility to add several attributes and fixed values in a same field. For example, instead of {url}, you could use:
{url}?_campaign=google&_adwords=test123 - You can use one or more fallback variables in case the previous is empty or null.
{brand | manufacturer} - You're allowed to use PHP code if you want to customize the pattern. You just have to write your PHP code in one single line , and it will work perfectly (check how to add PHP scripts into your templates).
- You can add a field by using the button Add field. The fields order can be easily reordered by using the up and down arrows .
- The syntactic coloration in Data Feed Manager will help you to avoid any error in your template. First, the errors will be underlined in yellow . You need to correct each error before checking syntax once again. Finally, you'll be able to Check data .
Attribute specifications
PARENT ATTRIBUTES
Most of the time simple products are related to parent products like configurable, grouped and bundle products. That is why you might need to retrieve Parent attribute values instead of simple product attribute values such as url, image, description...
All the above attributes (Basic, Special and Magic) may be used to retrieve a Parent attribute value instead of a product attribute value.
All options are still available, eg: {description parent,[htmlentities]}
{attribute_code parent}
Retrieves the first parent attribute value.
The parent value is retrieved only if the simple (item) product is associated with a parent product, if not, its own attribute value is retrieved.
The parent product may be a configurable, a grouped or a bundle product. The first parent product that matches the simple product is used to get the attribute value.
Eg:
{G:PRODUCT_TYPE parent}
<g:product_type>{categories parent,[last]}</g:product_type>{attribute_code configurable}
Retrieves the first configurable parent attribute value.
The configurable product value is retrieved only if the simple product is associated to a configurable product, if not, its own attribute value is retrieved.
Eg:
{G:IMAGE_LINK configurable}
<g:image_link>{image configurable}</g:image_link>{attribute_code grouped}
Retrieves the first grouped parent attribute value.
The grouped product value is retrieved only if the simple product is associated to a grouped product, if not, its own attribute value is retrieved.
Eg :
{G:GOOGLE_PRODUCT_CATEGORY grouped}
<link>{url grouped}</link>{attribute_code bundle}
Retrieves the first bundle parent attribute value.
The bundle product value is retrieved only if the simple product is associated to a bundle product, if not, its own attribute value is retrieved.
Eg:
{G:SALE_PRICE bundle}
<g:price>{price bundle}</g:price>PRODUCT IDENTIFIERS
{id}
Retrieves the product id.
For example:
<g:id>{id}</g:id>{G:ID}
Is the shortcut for:
<g:id>{sku}</g:id>You can retrieve the id instead of the sku by adding an option:
{G:ID,[id]}{G:ITEM_GROUP_ID}
Is the shortcut for:
<g:item_group_id>{sku configurable}</g:item_group_id>{sku}
Retrieves the product SKU
For example:
<g:mpn>{sku}</g:mpn>{brand}
Retrieves the brand of the product.
For example:
<g:brand>{brand}</g:brand>{manufacturer}
Retrieves the brand of the product.
For example:
<g:manufacturer>{manufacturer}</g:manufacturer>BASIC INFORMATION
{inc}
<g:increment>{inc}</g:increment>{name}
Retrieves the product name.
Par exemple:
<g:title>{name}</g:title>{G:TITLE}
Is the shortcut for:
<title>{name}</title>{description}
Retrieves the description of the product.
For example:
<g:description>{description}</g:description>{G:DESCRIPTION}
Is the shortcut for:
<description>{description}</description>You can retrieve the short description instead by adding a parameter:
{G:DESCRIPTION,[short]}{short_description}
Retrieves the short description of the product.
For example:
<g:description>{short_description}</g:description>{condition}
Retrieves the condition of the product.
For example:
<g:condition>{condition}</g:condition>{weight}
Retrieves the weight of the product.
For example:
<g:weight>{weight}</g:weight>{magento_product_type}
Retrieves the Magento product type (simple, configurable...)
For example:
<magento_product_type>{magento_product_type}</magento_product_type>PRICES AND PROMOTIONS
{price}
Retrieves the normal price or the special price if it exists.
If prices are exclusive of VAT and the product is liable to a unique VAT rate, the price retrieved will include this rate. Otherwise, the price exclusive of tax is retrieved.
For example:
<g:price>{price}</g:price>You also have the possibility to use some parameters with this attribute:
- currency is for currency conversion. This option automatically converts the original product price to a specified currency. It uses an exchange rate already stored by you in your admin panel. By default, your local currency is used.
- vat_rate is a floating value between 0.00 and 100.00 that represents an arbitrary VAT rate to apply. This option rewrites the VAT rule for the product except if the product doesn't have any tax class.
<g:price>{price,[currency],[vat_rate]}</g:price>Here are some examples:
To convert the prices to EUR and apply a 20% VAT rate:
<g:price>{price,[EUR],[20.0]}</g:price>To convert the prices to USD and not apply any VAT rate:
<g:price>{price,[USD],[0]}</g:price>If the prices of your catalog are already including VAT:
<g:price>{price,[EUR]}</g:price>To use an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax settings (from Simple Google Shopping >= 5.1.0, and Data Feed Manager >= 3.0.0 ):
<g:price>{price,[EUR],[FR]}</g:price>This code may also be completed by an area code:
<g:price>{price,[USD],[US/NY]}</g:price>To apply the VAT corresponding to a country/area:
<g:price>{price,[USD],[-US/NY]}</g:price>To retrieve prices including different price values for simple products associated to a configurable one (from Data Feed Manager v7.3 ):
<g:price>{price parent,[EUR],[20.0]}</g:price>{G:PRICE}
Is the shortcut for:
<g:price>{price}</g:price>{normal_price}
Retrieves the price and ignores any existing special price value.
<g:price>{normal_price}</g:price>{special_price}
Retrieves the promotional price (special price) if exists.
If this price doesn't exist the value is null.
<g:price>{special_price}</g:price>{price_rules}
Retrieves either the price or the special price or the price including the catalog price rules if indicated.
For example:
<g:price>{price_rules}</g:price>You also have the possibility to use some parameters with this attribute:
- currency is for currency conversion. This option automatically converts the original product price to a specified currency. It uses an exchange rate already stored by you in your admin panel. By default, your local currency is used.
- vat_rate is a floating value between 0.00 and 100.00 that represents an arbitrary VAT rate to apply. This option rewrites the VAT rule for the product except if the product doesn't have any tax class.
- customer_group_id allows you to determine which price rules must apply for a given custom group id (by default the "NOT LOGGED IN" customer group applies)
<g:price>{price_rules,[currency],[vat_rate],[customer_group_id]}</g:price>{group_price}
Retrieves the group price if it exists. Otherwise, it displays the normal price.
For example:
<g:price>{group_price,[1],[USD],[0]}</g:price>You also have the possibility to use some parameters with this attribute:
- customer_group is the id of the customer group for which the group price is valid (check inCustomerscustomer groups).
- currency is for currency conversion. This option automatically converts the original product price to a specified currency. It uses an exchange rate already stored by you in your admin panel. By default, your local currency is used.
- vat_rate is a floating value between 0.00 and 100.00 that represents an arbitrary VAT rate to apply. This option rewrites the VAT rule for the product except if the product doesn't have any tax class.
<g:price>{group_price,[customer_group],[currency],[vat_rate]}</g:price>{G:SALE_PRICE}
<g:sale_price>{special_price}</g:sale_price>
<g:sale_price_effective_date>{special_from_date}/{special_to_date}</g:sale_price_effective_date><g:price>{normal_price}</g:price>
{G:SALE_PRICE}{is_special_price}
{is_special_price?[value_if_yes]:[value_if_no]}
- value_if_yes value to retrieve if a special price exists. By default 1.
- value_if_no value to retrieve if no special price exists. By default 0.
For example:
<g:is_special_price>{is_special_price?[yes]:[no]}<g:is_special_price>{tier_price}
Retrieves the tier price if it exists, otherwise, the value is null.
For example:
<g:price>{tier_price}</g:price>You also have the possibility to use some parameters with this attribute:
- customer_group is the id of the customer group for which the tier price is valid (check inCustomersCustomer Groups).
index is the index of the Tier Price you want to retrieve.- currency is for currency conversion. This option automatically converts the original product price to a specified currency. It uses an exchange rate already stored by you in your admin panel. By default, your local currency is used.
- vat_rate is a floating value between 0.00 and 100.00 that represents an arbitrary VAT rate to apply. This option rewrites the VAT rule for the product except if the product doesn't have any tax class.
<g:price>{tier_price,[customer_group],[index],[currency],[vat_rate]}</g:price>{min_price}
Retrieves the minimum price.
<g:price>{min_price,[EUR],[20.0]}</g:price>{max_price}
Retrieves the maximum price.
<g:price>{max_price,[EUR],[20.0]}</g:price>{G:PROMOTION_ID}
Retrieves the product promotion id if exists.
To know more about the use of this attribute, check out our doc on Google Merchant Promotions extension.LINKS
{url}
<g:link>{url}</g:link>The url attribute can receive the currency code as an url parameter to display the landing page with a specific currency, for example:
<g:link>{url}?currency=USD</g:link>
With children of configurable products {url} can be used with one additional parameter as follows:
{url,[variant]}
- variant (optional): generates the url of the configurable product including additional parameters that may help to display the price of the variant and to pre-select the configurable attribute
<link>{url,[variant]}</link>
// return for example: https://www.website.com/product-page.html?c=583&391=768#391=768{G:LINK}
Is the shortcut for:
<link>{url}</link>{image}
- index is the index of any additional images to retrieve. By default 0 (the main image).
For example:
<g:image_link>{image,[0]}</g:image_link>{G:IMAGE_LINK}
<g:image_link>{image}</g:image_link>
<g:additional_image_link>{image,[1]}</g:additional_image_link>
<g:additional_image_link>{image,[2]}</g:additional_image_link>
...{host}
Retrieves the host url, for example https://www.website.com.
An example with attribute {small_image}:
<g:image_link>{host}/media/catalog/{small_image}</g:image_link>{url_key}
<g:url>https://www.mywebsite.com/mystore_code/{url_key}</g:url>CATEGORIES
{categories}
Retrieves a list of category paths separated by "," in which the product may be found
{categories,[number_of_category_path],[from_category_level],[number_of_categories_in_each_path]}
- number_of _category_path, by default infinity
- from_category_level, by default 1 (root catalog)
- number_of_categories_in_each_path, by default infinity
Example:
<g:categories>{categories,[INF],[1],[INF]}<g:categories>2 arguments can be used to specify the path separator and the category separator:
{categories,[path_separator],[category_separator]}
- path_separator, by default "comma" (,).
- category_separator, by default "higher than" (>)
Example:
<g:categories>{categories,[,],[>]}<g:categories>Only one argument can be used to get the first or the last (deepest) category path:
Example:
<g:categories>{categories,[last]}<g:categories>
<g:categories>{categories,[first]}<g:categories>A complete list of all categories per product can be retrieved with the following method:
<? $product->getCategoriesArray(); ?>{G:PRODUCT_TYPE}
<g:product_type>category A > sub-category B </g:product_type>
<g:product_type>category A > sub-category B > sub-category C</g:product_type>{category_mapping}
Retrieves any new category that you have assigned (in the Categories filter) to the item's own product category. If no mapping is assigned to the first category found, the second category will be used etc.
{category_mapping,[index]}
- index: index of the category mapping
For example:
<category>{category_mapping,[0]}</category>
<category>{category_mapping,[1]}</category>
<category>{category_mapping,[2]}</category>
<category>{category_mapping,[3]}</category>
<category>{category_mapping,[4]}</category>Will retrieve a maximum of 5 category mappings in 5 separate tags.
{G:GOOGLE_PRODUCT_CATEGORY}
Is the shortcut for:
<g:google_product_category>{category_mapping,[0]}</g:google_product_category>This magic attribute retrieves the Google category that you assigned (in filter section/category filter) of the first category found to which the product is linked. If no Google category is assigned to the first category found, the second category will be used, if no Google category is assigned to the second, the third will be used etc.
To find the Google categories that match with your categories:https://www.google.com/support/merchants/bin/answer.py?answer=160081
Options: see {category_mapping}
{attribute_set}
Retrieves the attribute set in which the product is.
For example:
<attribute_set>{attribute_set}</attribute_set>That attribute can be useful for your Adwords campaigns.
AVAILABILITY
{status}
Retrieves either "enabled" if the product is enabled or "disabled" if the product is disabled.
{status,[value_if_enabled],[value_if_disabled]}
You can modify the default values:
- value_if_enabled: value to retrieve if the product is enabled
- value_if_disabled: value to retrieve if the product is disabled
For example:
<g:status>{status,[enabled],[disabled]}</g:status>{stock_status}
Retrieves the stock status "in stock" or "out of stock".
For example:
<g:availability>{stock_status,[instock],[outofstock]}</g:availability>{G:AVAILABILITY}
is the shortcut for:
<g:availability>{is_in_stock?[in stock]:[out of stock]:[available for order]}</g:availability>Options: see {is_in_stock}
{is_in_stock}
- value_if_in_stock value to retrieve if the product is in stock
- value_if_out_of_stock value to retrieve if the product is out of stock
- value_if_preorder value to retrieve if the product is backorderable
For example:
<g:availability>{is_in_stock?[in stock]:[out of stock]:[preorder]}</g:availability>{qty}
Retrieves the available quantity.
The quantity retrieved for the configurable products is based on the sum of simple products.
For example:
<g:availability>{qty}</g:availability>{min_sale_qty}
Retrieves the minimal sale quantity.
For example:
<g:min_sale_qty>{min_sale_qty}</g:min_sale_qty>REVIEWS
{review_count}
{review_count,[storeview_id]}
- storeview_id is the id of your store view. If not specified the current store view is used.
"*" will count all reviews for all store views.
For example:
<g:product_review_count>{review_count,[*]}</g:product_review_count>{review_average}
Retrieves the average score of all the evaluations that your customers have left for the product.
{review_average,[storeview_id],[ base_value]}
- storeview_id id of your store view. If not specified the current store view is used.
"*" will count all reviews for all store views. - base_value the base number. By default 5.
For example:
<g:product_review_average>{review_average,[*],[3]}</g:product_review_average>{G:PRODUCT_REVIEW}
<g:product_review_average>{review_average}</g:product_review_average>
<g:product_review_count>{review_count}</g:product_review_count>PRODUCT VARIANTS
{gender}
Retrieves the gender of the product.
For example:
<g:gender>{gender}</g:gender>{age_group}
Retrieves the age group of the product.
For example:
<g:age_group>{age_group}</g:age_group>{color}
Retrieves the color of the product.
For example:
<g:color>{color}</g:color>{size}
Retrieves the size of the product.
For example:
<g:size>{size}</g:size>{material}
Retrieves the material of the product.
For example:
<g:material>{material}</g:material>{pattern}
Retrieves the pattern of the product.
For example:
<g:pattern>{pattern}</g:pattern>BASIC OPTIONS
Basic attributes are the default attributes defined in Magento and also include any attributes you have defined for your products. (eg: name, description, short_description, weight, size, color)
You can apply one or more options to all of these attributes by using the following syntax:
{attribute_code,[option1],[option2],[option3],[...]}All options are executed in the written order eg:
<title>{name}</title>
<title>{name,[htmlentities],[strtolower]}</title>
<title>{name,[htmlentities],[strtolower],[ucwords]}</title>will produce:
<title>NOKIA© 2610 Phone</title>
<title>nokia© 2610 phone</title>
<title>Nokia© 2610 Phone</title>{attribute_code,[strip_tags]}
Remove all html tags.
For example:
<description>{description,[strip_tags]}</description>{attribute_code,[cleaner]}
Remove all characters that don't belong to the utf8 charset.
For example:
<title>{name,[cleaner]}</title>{attribute_code,[substr],[max_length],[end_string]}
- max_length: maximum length of the value
- end_string: string that will be added at the end of the string. By default: [...]
For example:
<description>{description,[substr],[50],[...]}</description>{attribute_code,[strtoupper]}
Transforms the value to upper case.
For example:
<title>{name,[strtoupper]}</title>{attribute_code,[strtolower]}
Transforms the value to lower case.
For example:
<title>{name,[strtolower]}</title>{attribute_code,[inline]}
Removes all EOL characters from the value.
For example:
<description>{description,[inline]}</description>{attribute_code,[html_entity_decode]}
Converts all HTML entities to their applicable characters.
For example:
<description>{description,[html_entity_decode]}</description>{attribute_code,[htmlentities]}
Converts all applicable characters to HTML entities.
For example:
<description>{description,[htmlentities]}</description>{attribute_code,[implode],[separating_string]}
Joins all array elements in a string.
- separating_string: string used between each value. By default it is a comma (,).
May be useful for multi-select attributes like color.
For example:
<g:color>{color,[implode],[,]}</g:color>will give: black, blue, red, green.
{attribute_code,[float],[decimals]}
Converts a numeric value to a floating number.
- decimals: number of floating number. By default [0].
<g:shipping_weight>{weight,[float],[2]}kg</g:shipping_weight>STOCK IN THE CHANNEL USERS
The Stocks in The Channel users can use the following attributes in order to build their data feeds :
{SC:URL}
Retrieves the canonical url of the product :
<link>https://www.example.com/product.html</link>Can be used in Data Feed Manager with {sc:url}
{SC:EAN}
Retrieves an unique ean value of the product:
<g:ean>1234567891234</g:ean>Can be used in Data Feed Manager with {sc:ean}
{SC:IMAGES}
Retrieves the associated image of each product :
<g:image_link>https://www.example.com/media/catalog/image.jpg</g:image_link>Can be used in Data Feed Manager with : {sc:images}
{SC:DESCRIPTION}
Retrieves the description for the product:
<g:description>...product description ...</g:description>A default value is retrieved when the description is empty.
Can be used in Data Feed Manager with {sc:description}
PHP API for Data Feed Manager
With Data Feed Manager you can use PHP scripts in different ways to fully customize and control the data feed output.
- Inline PHP scripts
Scripts that are added directly to the data feed template surrounded by PHP short tags (<? ... ?>)
- Custom attributes
Scripts that can be called by using the custom attribute name just like you do for any attribute in your data feed template - Custom functions
Functions that can be called by using the function name and additional parameters and that can be applied to any attribute in your data feed template
API coding standards
The Data Feed Manager PHP API uses the exact same syntax and standards than any PHP coding.
Attribute calls
For performance reasons, Data Feed Manager only loads in the collection of products the attributes that are explicitly required in the data feed template.
This means that only the attributes that are called using the template placeholders, {attribute_code}, will be added to the collection of products.
As a consequence, when you try to access the value of an attribute from the $product object, you must be sure that the attribute has been added to the collection.
Most of the time when the returned value is null for a given attribute, it means the attribute is not loaded in the collection of products.
The best way to be sure that all the attributes you need are well loaded in the
<?
/* list of required attributes
* {attribute_1} {attribute_2} {attribute_3} {attribute_4}...
*/
?>Then you should be able to get the values of these attributes in your PHP script:
<? return $product->getAttribute1();?>
<? return $product->getAttribute2();?>
<? return $product->getAttribute3();?>
....PHP functions in attribute calls
You can use any PHP function to apply in the attribute calls even if the function requires one or more additional arguments, for instance:
{name,[str_replace("Apple","Banana",$self)]}You can use several consecutive functions:
{ean,[str_pad($self,10,"0",STR_PAD_LEFT)],[str_replace("X","0",$self)]}Conditional values
To output values based on different conditions, use PHP conditional statements:
- if/else
<? /* attribute {sku} required */ if ($product->getSku()=="abc"){ return "Alphabetic"; } elseif($product->getSku()=="123"){ return "Numeric"; } else{ return "Mixed"; } ?> - switch/case
<? /* attribute {sku} required */ switch($product->getSku()){ case "abc": return "Alphabetic"; break; case "123": return "Numeric"; break; default: return "Mixed"; } ?>
Opening and closing tags
When using the PHP API inline directly in your data feed template, you must use the opening and closing short PHP tags (<? ... ?>)
<?
if($product->getData('size')=="X-Large") {
return "XL";
}
?>Outputting a value
- Return
Any value that you want to output in your data feed, must be returned with the return instruction.
<? return "Don't miss! ".$product->getTitle(); ?>
/* This script adds for each product in data feed a new ouput line
* Don't miss! Iphone 5
* Don't miss! Galaxy note 7
* ...
*/- echo, var_dump, print_r
Any value printed in the data feed through these functions will be rendered at the top of the data feed and will not be added to the final file.
Such functions must be used for debugging purposes.
<? var_dump($product->getTitle()); ?>
/* This script adds for each product in data feed a new debugging trace
* String(8) "Iphone 5"
* String(13) "Galaxy note 7"
* ...
*/Variables scope
All variables available in PHP scripts have a local scope, this means they can't be shared between several scripts.
If you wish to share a variable with different scripts all along the data feed generation process, then the variable must be set as a global variable.
<?
global $increment;
$increment++;
return $increment;
/* This script will output a incremental $variable
* 1
* 2
* 3
* ...
*/
?>API Objects, Variables and Methods
Object $product
$product is an instance of Mage_Catalog_Model_Product. It contains all methods available by default and some other specific to Data Feed Manager.
The list below is not exhaustive but lists the most useful methods.
- $product->getCategoriesArray()
Retrieves an array of arrays that describes the categories to which belongs the products - $product->getCategoryIds()
Lists all category ids in which the product may be found - $product->getVisibility()
Returns the visibility of the product (1 = not visible individually, 2 = catalog, 3 = search, 4 = catalog and search) - $product->getStatus()
Returns the status of the product (1 = enabled, 2 = disabled) - $product->getData($attributeCode)
Returns the value of the given attribute code - $product->getAttributeText($attributeCode)
Returns the textual value of the given attribute code
Object $this
$this is an instance of Wyomind_datafeedmanager_Model_Feed. It provides a few useful methods.
- $this->hasParent($product, $type="parent")
Returns a Boolean value whether a product has a parent from the given type (parent, configurable, grouped, bundle) or not
- $this->getParent($product, $type="parent", $strict=false)
Returns a product object of the given parent type (parent, configurable, grouped, bundle) if available or the product object passed as 1st parameter when $strict parameter is set on false. - $this->skip()
Skips the current product, useful to filter out some products based on specific condition
String | Integer | Boolean | Array $self
$self is the value of the attribute for the current product.
This variable is available only in the custom attributes, and in the custom functions.Variable $param
The variable $param contains an array of the parameters that have been passed to the custom function.
{{ean,[str_pad],[10],[0]}}The custom function
<?
/* var_dump($param) gives
* Array(3)[
* 0 => String(7) "str_pad",
* 1 => String(2) "10"
* 2 => String(1) "0"
* ]
*/
return str_pad($self,$param[1],$param[2],STR_PAD_LEFT);
?>Use custom attributes and custom options
Custom attributes
Data Feed Manager allows you to create your own attributes and to add them to your data feed.
To create custom attributes from your Magento admin, go to:
Catalog Data Feed Manager Custom Attributes
Some templates of use are loaded by default when installing the extension.
Here is how to proceed:
- Create a new attribute.
- Fill in the attribute code with the name of your custom attribute
- Add your custom script. No need to add the PHP tags (<? ... ?>)
- Add the new custom attribute into your data feed template in:
Catalog Data Feed Manager Data Feed
An example of custom attributes:
Replace some words in the product descriptions:
<?
$search=array('Nokia','BlackBerry','apple');
$replace=array("NOKIA","BLACKBERRY","APPLE");
return str_ireplace($search, $replace,$product->getDescription());
?>
Create a thumbnail of the product image:
<? return Mage::helper('catalog/image')->init($product, 'image')->resize(265,265); ?>
Filter out products that match a condition:
<?
if(strlen($product->getUpc())>=12) return $product->getUpc();
elseif ($product->getMpn()) return $product->getMpn();
else $this->skip();
?>
Calculate the sum of all quantity available for a configurable product:
<?
$childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null,$product);
$stock_count=0;
foreach($childProducts as $child){
$stock_count+=(int)Mage::getModel('cataloginventory/stock_item')->loadByProduct($child)->getQty();
}
return "<g:quantity>".$stock_count."</g:quantity> ";
?>Custom options
Data Feed Manager also allows you to create custom functions.
To create your own functions, go to:
Catalog Data Feed Manager Custom functions
Here is how to proceed:
- Create a new option.
- Fill in the option name with the name of your custom option.
- Define the number of additional parameters expected by your custom option.
- Add your custom script - No need to add the PHP tags (<? ... ?>)
- Add the new custom option into your data feed template.
An example of custom option:
Pad an attribute to a certain length with another string:
<?
/*
* {{ean,[str_pad],[10],[0]}}
* when ean is 12345, then the output is 0000012345
*/
return str_pad($self,$param[1],$param[2],STR_PAD_LEFT)
/*
* could also be used as a inline function
* {{ean,[str_pad($self,10,0,STR_PAD_LEFT)]}}
*/
?>
Format a number:
<?
/*
* {{price,[number_format],[2],[,]}}
* when price is 9.99345, then the output is 9,99
*/
return number_format($self,$param[1],$param[2],' ')
/*
* could also be used as a inline function
* {{ean,[number_format($self,2,',',' ')]}}
*/
?>Shopping engines configurations
How to configure my template with Google Shopping?
Useful links for Google Shopping
Google Shopping allows you to create data feed in destination of Google Shopping.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at these 2 links which will be helpful:
Once your data feed has been uploaded to your Google Merchant account, you can check what products have been added to the Google Shopping index:
https://www.google.com/products?authorid=[your Account ID]
File format with Google Shopping
Google Shopping handles CSV or XML file format (More information).
The following explanations will only concern the most used method: XML files.
File names should remain consistent for all updates.
Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with Google Shopping
Required attributes with Google Shopping depend on what kind of products you want to submit.
For complete information about required attributes, please refer to the dedicated page on the Merchant Center.
Here are the most frequent required attributes used by Google Shopping.
(Between brackets, specific name for XML files)
| Attribute | Description | |
|---|---|---|
| General attributes |
id (<g:id>) |
The unique identifier for your product (usually the SKU code) |
| Title (<title>) |
The name of your item (limited to 70 characters) For variant products, you are required to include the common title of the variant items. |
|
| Description (<description>) |
The description of the item. Google Shopping recommend you submit around 500 to 1000 characters, but you can submit up to 10000 characters. |
|
| Google product category (<g:google_product_category>) |
Google's category of the item. Indicates the category of the product being submitted, according to the Google product taxonomy. By example, for hard drives items: Electronics > Computers > Computer Components > Storage Devices > Hard Drives Please refer to our Category mapping FAQ to understand how to use it with Simple Google Shopping. |
|
| Link (<link>) |
The URL directly linking to your item's page on your website. Note: In addition, you may also specify an adwords_redirect attribute for tracking purposes. |
|
| Image link (<g:image_link>) |
The URL of the main image of the item. Google Shopping recommends images of at least 400 x 400 pixels. The accepted image formats are JPG (or JPEG), PNG, GIF, BMP and TIFF. |
|
| Condition (<g:condition>) |
The condition or state of the item. Only accepted values: new, used, refurbished. |
|
| Prices and Availability |
Availability (<g:availability>) |
The availability status of the item Only accepted values: in stock, available for order, out of stock, preorder |
| Price (<g:price>) |
The price of the item. Important : - For the US, don't include tax in the price. For all other countries, value added tax (VAT) has to be included in the price. - The price must include a currency according to ISO 4217 Standard. (by example : EUR for euros, USD for US Dollars, GBP for pounds). - For products on sale, you must use <g:sale_price> (see below) and use normal price in <g:price>. Example : <g:price>15.00 USD</g:price> |
|
| Unique Product Identifiers |
Note about unique product identifiers : except for custom made items, you need to submit at least two of the three attributes 'brand', 'gtin' and 'mpn'. | |
| Brand (<g:brand>) |
The brand of the item. You must not provide your store name as the brand unless you manufacture the product. |
|
| GTIN (<g:gtin>) |
Global Trade Item Number (GTIN) of the item. These identifiers include UPC (in North America), EAN (in Europe), JAN (in Japan), and ISBN (for books). |
|
| MPN (<g:mpn>) |
Manufacturer Part Number (MPN) of the item. This code uniquely identifies the product to its manufacturer. |
|
| Only Apparel Products |
Gender (<g:gender>) |
3 accepted values: male, female, unisex. Note: Required for all apparel items in feeds that target the US, UK, DE, FR, and JP. Recommended for other countries and product categories (might become required in the future). |
| Age group (<g:age_group>) |
2 accepted values: adult, kids. Note : Required for all apparel items in feeds that target the US, UK, DE, FR, and JP. Recommended for other countries and product categories (might become required in the future). |
|
| Shared by Apparel and Variants |
color (<g:color>) |
Color of the item. This defines the dominant color(s) of an item. Note : When a single item has multiple colors, combine them with '/' (/ with XML files) in order of prominence (dominant color first, then accent colors). |
| Size (<g:size>) |
Size of the item. Note : - required for 'clothing' and 'shoes' sub-categories within the 'apparel and accessories' category targeting the US, UK, DE, FR, and JP. - For apparel variants submitted to the US, UK, DE, FR, and JP: Each different size or size combination must be submitted as its own item, in conjunction with the 'item group id' (<g:item_group_id>). |
|
| Item group id (<g:item_group_id>) |
Shared identifier for all variants of the same product. Allows to identify all variations (size and/or color) of a same item. We recommend you to use the product'SKU parent as item group id value |
|
Recommended attributes with Google Shopping
Here are some attributes (non-exhaustive list) recommended by Google Shopping that we think could be quite useful to add in your template:
(Between brackets, specific name for XML files)
| Attribute | Description | |
|---|---|---|
| General attributes |
Product type (<g:product_type>) |
Your category of the item. This attribute also indicates the category of the product being submitted, but you can provide your own classification. You can include more than one 'product type' attribute value if products apply to more than one category. |
| Additional image link (<g:additional_image_link>) |
Additional URLs of images of the item. You can include up to 10 additional images per item by including the attribute multiple times. |
|
| Sale price (<g:sale_price>) |
Advertised sale price of the item. Important: - You must still include the <g:price> attribute in your feed, which must reflect the non-sale price you have previously sold the item for. - As the normal price, the sale price must include a currency according to ISO 4217 Standard. - You must not include a price value of 0.00 USD. |
|
| Sale price effective date (<g:sale_price_effective_date>) |
Used in conjunction with sale price, this attribute indicates the date range during which the sale price applies. Information about time format: Start and end dates separated by a forward slash (/). The start is specified by the format (YYYY-MM-DD), followed by the letter T, the time of the day when the sale starts, followed by an expression of the timezone for the sale. The end date should be in the same format. Example: 2011-03-01T13:00-0800/2011-03-11T15:30-0800 |
|
| Tax and Shipping |
Tax (<g:tax>) |
Value added tax (VAT). Providing this attribute for an item overrides the default tax costs specified in your Google Merchant Center settings. Note: This attribute is only accepted in the US, if your feed targets a country outside of the US, please do not use this attribute. |
| Shipping (<g:shipping>) |
Shipping cost. Providing this attribute for an item overrides the global shipping settings you defined in your Google Merchant Center settings. More information about shipping and tax |
|
| Shipping weight (<g:shipping_weight>) |
The weight of the product used to calculate the shipping cost of the item. If you have specified a global shipping rule that is dependent on shipping weight, this attribute will be used to calculate the shipping cost of the item automatically. Accepted weight units: lb, oz, g, kg. |
|
| AdWords attributes |
Note : These attributes help you to organize your AdWords campaigns and track the traffic to your website. | |
| Adwords grouping (<g:adwords_grouping>) |
Used to group products in an arbitrary way. It can be used for Product Filters to limit a campaign to a group of products, or Product Targets to bid differently for a group of products. Required if you want to bid differently to different subsets of products in the CPC or CPA % version. It can only hold one value. Example: <g:adwords_grouping>comforters</g:adwords_grouping> |
|
| Adwords labels (<g:adwords_labels>) |
Very similar to <g:adwords_grouping>, but it will only work on CPC. It can hold multiple values, allowing a product to be tagged with multiple labels. Example: <g:adwords_labels>clothing</g:adwords_labels><g:adwords_labels>shoes</g:adwords_labels> |
|
| Adwords redirect (<g:adwords_redirect>) |
Allows advertisers to specify a separate URL that can be used to track traffic coming from Google Shopping. Example: <g:adwords_redirect>https://www.merchant.com/product.html</g:adwords_redirect> |
|
Example of template with XML format with Google Shopping
Here is an example of template in XML format:
<g:id>{sku}</g:id>
<title>{name,[substr],[70],[...]}</title>
<link>{url}</link>
<!-- you must change the currency unit or convert the price to match with your magento store and your merchant account setting -->
<g:price>{normal_price,[USD]} USD</g:price>
{G:SALE_PRICE,[USD]}
<g:online_only>y</g:online_only>
<description>{description,[html_entity_decode],[strip_tags]}</description>
<g:condition>new</g:condition>
{G:PRODUCT_TYPE,[10]}
{G:GOOGLE_PRODUCT_CATEGORY}
{G:IMAGE_LINK}
<g:availability>{is_in_stock?[in stock]:[out of stock]}</g:availability>
<g:quantity>{qty}</g:quantity>
<g:featured_product>{is_special_price?[yes]:[no]} </g:featured_product>
<g:color>{color,[implode],[,]}</g:color>
<g:shipping_weight>{weight,[float],[2]} kg</g:shipping_weight>
{G:PRODUCT_REVIEW}
<g:manufacturer>{manufacturer}</g:manufacturer>
<!-- In most of cases brand + mpn are sufficient, eg. :-->
<g:brand>{manufacturer}</g:brand>
<g:mpn>{sku}</g:mpn>
<!-- But it is better to use one of these identifiers if available : EAN, ISBN or UPC, eg : -->
<g:gtin>{upc}</g:gtin>How to create a data feed in Google Merchant Center?
In order to submit your products to Google Shopping, you'll have to create a data feed in your Google Merchant Center.
Once you're login into Google Merchant Center, go in the Data feeds section.
You can choose between creating a New Data Feed and a New Test Data Feed.
We recommend that you start by creating a New Test Data Feed.
After clicking on New Test Data Feed, you have to choose the target country and a name for your data feed ("datafeed_test" by example).
You can confirm by clicking on Save changes.
Now you can see your data feed appears in the data feeds list.
Next step will be to setup this data feed so it will import the data feed you created with the extension Simple Google Shopping in your Magento store.
Click on the link Create schedule. You are now accessing the schedule upload options.
You can manage the Google Merchant's importation frequency. You can choose to import you data feed monthly, weekly or daily at a specific time.
Paste your data feed's URL in the field Feed URL.
Click on Schedule and fetch now to start the importation and the process of your data feed.
Your data feeds' status shows Processing...
After a few minutes, Google Merchant Center shows you the number of inserted items and offers you to display errors in your data feed.
Click on View errors will show you errors in your data feed.
Google Merchant Center discerns 2 kinds of anomaly: errors and warnings.
As long it will remain errors in your data feed, Google Merchant will not display your items in Google Shopping.
It's very important to read the errors descriptions. It will help you to understand and fix quickly your data feed's issues.
Once the errors fixed, you'll be able to proceed to the creation of a new data feed (not a test one this time) which will perform the processing and referencing of your items by Google Shopping.
The validation of the first submission of your data feed to Google can take some days because it's performing manually by Google's teams. The next submissions will be validated almost instantly.
How to configure my template with Shopping.com?
Data Feed Manager allows you to create data feed in destination of Shopping.com.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at the following link which will be helpful:
Shopping.com's feed specifications
File format for Shopping.com
Shopping.com handle CSV or XML file format.
For CSV files, data should be enclosed within double quotation marks ( " ), and tab as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>.
File name should remain consistent for all updates. (e.g. MerchantnameSDC.csv). Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes for Shopping.com
These 9 attributes are required. Products without these values will not display on Shopping.com:
(Between brackets, specific name for XML files)
| Attribute | Description |
|---|---|
| Unique Merchant SKU (Merchant_SKU) |
The unique SKU number you use internally to identify this item |
| Product Name (Product_Name) |
Product Names must be clear and concise. They should also be descriptive of the product being sold.(limited to 90 characters) |
| Product URL (Product_URL) |
URL on your website containing the product detail and buy button for the applicable product |
| Image URL (Image_URL) |
Provide the URL to the item's largest primary image. Minimum size accepted: 150 pixels on at least one side of the image. Any modern format is acceptable, i.e. JPEG, PNG, GIF, TIFF |
| Current Price (Current_Price) |
Provide your current selling price for the item before tax or shipping |
| Stock Availability (Stock_Availability) |
Denote Y or YES to show you have the product in stock and N, NO or NONE when the product is out of stock. Out-of-stock products will not be shown on Shopping.com. (Allowed values : In Stock, Yes, Y, 1, Limited availability, Out of Stock, No, N, None, Pre-Order, Back-Order) |
| Condition (Condition) |
Please use this field to indicate if the item is "New", "Used" or "Refurbished". IMPORTANT: Shopping.com currently displays "New" products only. "Used" and "Refurbished" products are rejected automatically |
| These 2 last attributes are only required for media | |
| MPN/ISBN (MPN ou ISBN) |
The ISBN is a unique machine-readable identification number. Shopping.com supports both the 10 and 13 digit versions of ISBN |
| UPC ou EAN (UPC ou EAN) |
Shopping.com supports both the 12-digit Universal Product Codes (UPC) and the 13-digit EAN codes. UPC or EAN are strongly recommended in all categories |
Recommended attributes for Shopping.com
Here are some attributes (non-exhaustive list) recommended by Shopping.com we think are quite useful to add in your template:
(Between brackets, specific name for XML files)
| Attribute | Description |
|---|---|
| Shipping Rate (Shipping_Rate) |
Shipping cost for this item. Use 0 to denote free shipping. Refer to the Merchant Account Center at Products > Edit-Shipping-Information page if you want to define Shipping Rates by Price ranges |
| Original Price (Original_Price) |
If your website displays a price drop and/or percent savings for this item, provide here the item's original price |
| Brand / Manufacturer (Brand ou Manufacturer) |
Brand, manufacturer, or publisher of the product |
| Product Description (Product_Description) |
Product Descriptions should elaborate on Product Names and provide all relevant product details (limited to 4000 characters) |
| Product Type (Product_Type) |
Provide an ordered list of nouns describing the type of product. Use a comma to separate them. Please refer to Shopping.com' specifications to find a list of relevant categories |
| Category (Category) |
Please provide a breadcrumb describing the classification of the respective product. (ie: "Electronics > Digital Cameras"). Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
| Category ID (Category_ID) |
Use the Shopping.com's taxonomy to provide the right Shopping.com's Category ID for this item |
| Parent SKU (Parent_SKU) |
If the product is one variant in a family of similar products, provide here a SKU number that uniquely identifies the family |
| Parent Name (Parent_Name) |
The name of the parent product |
Example of template for Shopping.com with XML format
Here is an example of template for a website selling t-shirts:
Header:
<?xml version="1.0" encoding="ISO-8859-1"?>
<Products>
Pattern:
<Product>
<Merchant_SKU>{sku}</Merchant_SKU>
<Product_Name>{name,[substr],[70],[...]}</Product_Name>
<Product_URL>{url parent}</Product_URL>
<Image_URL>{image parent}</Image_URL>
<Current_Price>${price,[USD],[0]}</Current_Price>
<Shipping_Rate>$7.50</Shipping_Rate>
<Stock_Availability>{is_in_stock parent?[in stock]:[out of stock]}
</Stock_Availability>
<Condition>New</Condition>
<Original_Price>${normal_price,[USD],[0]}</Original_Price>
<Manufacturer>{brand}</Manufacturer>
<Product_Description>{short_description parent,[html_entity_decode],[strip_tags]}
</Product_Description>
<Product_Type>Clothing</Product_Type>
<Category>{category_mapping,[0]}</Category>
<Category_ID>31515</Category_ID>
<Parent_SKU>{sku parent}</Parent_SKU>
<Parent_Name>{name parent,[substr],[70],[...]}</Parent_Name>
<Estimated_Ship_Date>Allow 10 days for Delivery</Estimated_Ship_Date>
<Gender>{gender}</Gender>
<Color>{color,[implode],[,]}</Color>
<Size>{size,[implode],[,]}</Size>
<Alternative_Image_URL_1>{image,[1]}</Alternative_Image_URL_1>
<Alternative_Image_URL_2>{image,[2]}</Alternative_Image_URL_2>
<Alternative_Image_URL_3>{image,[3]}</Alternative_Image_URL_3>
<Alternative_Image_URL_4>{image,[4]}</Alternative_Image_URL_4>
<Alternative_Image_URL_5>{image,[5]}</Alternative_Image_URL_5>
<Merchandising_Type>New</Merchandising_Type>
<Bundle>No</Bundle>
</Product>
Footer:
</Products>How to configure my template with Bing Shopping?
Data Feed Manager allows you to create data feed in destination of Bing Shopping.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at these 2 links which will be helpful:
File format for Bing Shopping
Bing Shopping doesn't support XML file format. You should create TXT file format.
HEADER (the line with attribute's names) is required by Bing Shopping.
Data should be enclosed without any characters, and you should use tab as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>
- No $ sign in the price values and no lbs in shipping weights (only numbers, limited to 2 decimal places)
File name should remain consistent for all updates. Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Bing Shopping recommends to use bingshopping.txt as a file name.
Required attributes for Bing Shopping
Bing Shopping requires these 6 attributes:
| Attribute | Description |
|---|---|
| MerchantProductID | You can either use internal Magento ID, either product'SKU as a unique identifier |
| Description | Detailed description of your offer (limited to 5000 characters). No HTML coding. Ensure no descriptions are wrapped in quotes. Please do not include promotional text. |
| ProductURL | URL of the product. Link to your website where a potential buyer can complete the purchase of your product. |
| ImageURL | Provide the URL to the item's largest primary image. Acceptable formats: BMP,JPG, PNG, GIF, TIFF and EXIF |
| Price | Provide your current selling price for the item before tax or shipping |
| Title | Product Names must be clear and concise (limited to 255 characters) |
Recommended attributes for Bing Shopping
Bing Shopping highly recommends to use these attributes in your template:
| Attribute | Description |
|---|---|
| Brand | The product manufacturer's name, brand name or publisher's name |
| MPN | The ISBN is a unique machine-readable identification number. Bing Shopping supports both the 10 and 13 digit versions of ISBN |
| UPC | Universal Product Code. Only 8 and 12 digit codes are supported |
| ISBN | International Standard Book Number |
| SKU | The SKU unique number of the product. Used to refer to different versions of the same product |
| Availability | The current availability for the offer. Choose only one of following values: In Stock; Out of Stock; Pre-Order; Back-Order |
| Shipping | This attribute will override any info set in the Shipping tab of your Bing Shopping account. Each shipping attribute group must be separated with a comma and the four sub-attributes by colons such as: Country:Region:Service:Price. Only Price value is required. Three colons are required even for blank values. Examples: No shipping world wide = :::0 No shipping US wide = US:::0 Multiple variables are allowed and are split with a comma = US:024*:Ground:7.95,US:MA:Ground:5.95 |
| MerchantCategory | Your internal category hierarchy for this product |
| ShippingWeight | The weight of the product in pounds. Don't use lbs sign and avoid the use of leading zeros |
| Condition | Acceptable condition values are: New; Used; Collectable; Open Box; Refurbished; Remanufactured WARNING: Currently Bing Shopping shows only new products. If not specified, Bing Shopping assumes the product is new |
| Tax | This attribute will override any info set in the Tax tab of your Bing Shopping account. Each tax attribute group must be separated with a comma and the four sub-attributes by colons such as: Country:Region:Rate:Tax_Ship. Only Rate value is required. Three colons are required even for blank values. Examples: No tax world wide = ::0: No tax US wide = US::0: Multiple variables are allowed = US:CA:8.25:y,US:926: *:8.75:y |
| B_Category | Bing Shopping Category. Bing's list of categories to match your product to Bing's standardized structure. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
Example of template for Bing Shopping with TXT format
Here is an example of template:
How to configure my template with Shopzilla?
File format for Shopzilla
Shopzilla doesn't support XML file format. You should create TXT file format.
HEADER (the line with attribute's names) is required by Shopzilla.
Data should be enclosed without any characters, and you should use tab as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>
File name should remain consistent for all updates. Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes for Shopzilla
Shopzilla requires 15 attributes in the data feed, but only 5 must contain data. Others are highly recommended by Shopzilla.
WARNING: these 15 attributes must respect this order:
- Category ID
- Manufacturer
- Title
- Description
- Product URL
- Image URL
- SKU
- Availability
- Condition
- Ship Weight
- Ship Cost
- Bid
- Promotional Code
- UPC
- Price
Bold attributes above must contain data.
Here are the 5 required attributes:
| Attribute | Description |
|---|---|
| Category ID | Shopzilla Category. You have to map your own categories by using Shopzilla's taxonomy. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
| Title | Product Names must be clear and concise (limited to 100 characters) |
| Product URL | URL of the product. Link to your website where a potential buyer can complete the purchase of your product. |
| SKU | The SKU unique number of the product. Used to refer to different versions of the same product |
| Price | Provide your current selling price for the item before tax or shipping (don't use $ sign) |
Recommended attributes for Shopzilla
Shopzilla highly recommends to use these attributes in your template:
| Attribute | Description |
|---|---|
| Manufacturer | The product manufacturer's name, brand name or publisher's name. Leave empty if you don't know the manufacture's name. |
| Description | Detailed description of your offer (limited to 1000 characters). No HTML coding. Ensure no descriptions are wrapped in quotes. Please do not include promotional text. |
| Image URL | Provide the URL to the item's largest primary image. Acceptable formats: JPG or GIF. Image size should be at least 200x200 pixels and no greater than 1000x1000. Image URLs must begin with https:// (Shopzilla doesn't support secure locations (https://) |
| Availability | Lets your consumers know if the product is currently available on your website. Choose only one of following values: In Stock, Back-Order, Pre-Order, See Site, Out of Stock, Limited Qty, Special Order. If empty, Shopzilla will default to "See Site for Availability". |
| Condition | Designates the state of the product. Acceptable condition values are: New, Refurbished, Used, Open Box, OEM. If empty, Shopzilla will default to "New". |
| Ship Weight | Designates the weight of your product (in pounds). |
| Ship Cost | Designates a flat shipping cost for the product, if desired. This field is not necessary if you plan to use the Shopzilla Shipping Tool to specify ship costs. Note: To designate free shipping, please use 0.00 |
| Bid | This is an optional field and recommended only for those merchants programmatically setting their product bids. Please refer to Feed Specifications for further information about this attribute. |
| Promotional Code | This field is used to add promotional text next to your product. Please refer to Feed Specifications for further information about this attribute. |
| UPC | Universal Product Code. Only 8 and 12 digit codes are supported |
Example of template for Shopzilla with TXT format
Here is an example of template:
How to configure my template with Amazon?
Data Feed Manager allows you to create data feed in destination of Amazon.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at this link which will be helpful:
Amazon Browse Tree Guide (BTG) (Amazon'specifications)
For Amazon Product Ads, we recommend the following documentation:
https://sellercentral.amazon.com/gp/help/
File format with Amazon
Amazon doesn't support XML file format. You should create TXT file format.
HEADER (the line with attribute's names) is required by Amazon.
ATTENTION: Amazon requires an extra-header, which allows Amazon to identify what kind of products is in you data feed, and the actual used version. Here is an example concerning Home category products:
TemplateType=Home Version=2012.0228 This row for Amazon.com use only. Do not modify or delete.
In order to use these specific extra-header, Data Feed Manager has a specific field named Extra header:
Data should be enclosed without any characters, and you should use tab as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>
File name should remain consistent for all updates. Do not include the date in your file name.
Information groups with Amazon
Amazon distinguish different information groups to describe the products you'll send them in your data feed.
Some groups are generic and suitable for all types of products:
- Basic Product information
- Offer Information
- Sales Price information
- Item discovery information
- Image Information
- FBA (Fulfillment By Amazon)
- Variation information (if your Product is available in different variations)
- Product Dimensions
- Infrequently used attributes
Beside these generic groups, there are specific groups depending on your products' categories.
Here are specific groups from Home category:
- Product specific attributes included in the "ArtAndCraft"
- Product specific attributes included in the "Kitchen"
- Product specific attributes included in the "Indoor Home"
- Product specific attributes included in the "Outdoor Home and Garden"
- Battery Information
The very first thing to do before creating your Amazon data feed is to identify which kind of products your Magento catalog contains.
Once this is done, you'll have to refer to the Amazon Browse Tree Guide (Amazon BTG) matching this product category to create your data feed in the best way.
For example, if you're selling furniture, you'll have to refer to Home Amazon BTG, which matches with following themes:
- Art and Craft
- Kitchen
- Indoor Home
- Outdoor Home and Garden
We'll use this particular example for following explanations.
Required attributes with Amazon
Usually, Amazon requires these 10 attributes in the data feed.
WARNING: These 10 attributes have to be in the data feed unless Amazon will reject it.
| Attribute | Description |
|---|---|
| SKU | The SKU unique number of the product. Used to refer to different versions of the same product |
| StandardProductID | A standard, alphanumeric string that uniquely identifies the product. This could be a Global Catalog ID (GCID), UPC, EAN or GTIN. |
| StandardIDType | The type of standard, unique identifier entered in the ProductID field. Select one of the following options: Global Catalog ID (GCID), UPC, EAN or GTIN. |
| ProductName | Product Names must be clear and concise (limited to 500 characters). Don't use special characters. |
| ProductType | Identify the product types. With our example : For all Indoor products, choose from: Kitchen, BedAndBath, ArtAndCraft, Furniture or the general category Product type of Home. Select one of the following options: Art, BedAndBath, FurnitureAndDecor, Home, Kitchen, OutdoorLiving, SeedsAndPlants. |
| Brand | The brand or manufacturer of the product. Populate this field so your brand name is displayed on the Amazon.com site. (Brand or Manufacturer is required, both are desired) |
| Manufacturer | Specify the manufacturer for your product. (Brand or Manufacturer is required, both are desired) |
| ItemType | Use this to specify what your item is. This field is primarily used for browse classification. Refer to the Browse Tree Guide (BTG) for allowed values. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
| ItemPrice | The price at which the merchant offers the product for sale, expressed in U.S. dollars. Don't use currency unit. |
| Link | The URL of the product. Must start with https:// |
Recommended attributes with Amazon
Amazon highly recommends to use these attributes in your template:
Detailed description of your offer (limited to 2000 characters).
Don't use special characters.
| Attribute | Description |
|---|---|
| Description | |
| Currency | The currency code indicating what currency the pricing data is in. (USD for US Dollars, EUR for Euro, GBP for Pounds). |
| ShippingWeight | The weight of the product when packaged to ship. A number with up to 10 digits to the left of the decimal point and 2 digits to the right of the decimal point. |
| ShippingWeightUnitOfMeasure | The unit of measure used to describe the weight of the product: OZ, LB, GR or KG. |
| MainImageURL | Provide the URL to the item's largest primary image. Preferred format: JPG. Image size must be at least 500 pixels in either height or width and should be 1000 pixels or larger. Image URLs must begin with https://. |
| OtherImageURL1-OtherImageURL8 | Additional images showing different sides of a product, the product in use, or details that aren't visible in the MAIN image. |
| Quantity | The quantity of the item you are making available for sale. Quantity is required for all "child" or stand-alone items. If left blank when first submitting the product information, the item will be displayed as "Out of stock". |
How to configure my template with Price Grabber?
Data Feed Manager allows you to create data feed in destination of Price Grabber.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at these 2 links which will be helpful:
File format with Price Grabber
Price Grabber doesn't support XML file format. You should create TXT file format.
HEADER (the line with attribute's names) is required by Price Grabber.
Data should be enclosed without any characters, and you should use tab as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>
File name should remain consistent for all updates. Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with Price Grabber
Price Grabber requires some attributes regarding to the kind of product you're selling in your store.
For example, Home & Personal Products requires 9 attributes, where Tech Products & Software only requires 7 attributes (not the same).
Please have a look at the Price Grabber Integration Guide to know exactly which attributes are required for your products.
However, here are the most current required attributes:
| Attribute | Description |
|---|---|
| Retsku | The SKU unique number of the product. Used to refer to different versions of the same product |
| Product Title | Product Names must be clear and concise (limited to 100 characters) |
| Detailed Description | Detailed description of your offer (limited to 1500 characters). No HTML coding. Ensure no descriptions are wrapped in quotes. Please do not include promotional text. |
| Categorization | Price Grabber Category. You have to map your own categories by using Price Grabber's taxonomy. By example : laptops products needs to have: Computers > Laptops & Accessories > Laptops as matching category. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
| Product URL | URL of the product. Link to your website where a potential buyer can complete the purchase of your product. |
| Primary Image URL | Provide the URL to the item's largest primary image. Image URLs must begin with https:// (Price Grabber doesn't support secure locations (https://) |
| Selling Price | Current selling price of the item. Please omit currency symbols. Prices should be provided in the appropriate currency (US Dollars for PriceGrabber.com, Pound Sterling for PriceGrabber.co.uk, Canadian Dollars for PriceGrabber.ca). |
| Manufacturer Name | The product manufacturer's name, brand name or publisher's name. Leave empty if you don't know the manufacturer's name. |
Recommended attributes with Price Grabber
Price Grabber highly recommends to use these attributes in your template:
| Attribute | Description |
|---|---|
| Manufacturer Part Number | Manufacturer-issued part number (MPN) for the product. |
| UPC / EAN | UPC (US, Canada): Unique code of 12 numbers. EAN (Europe): Unique code of 13 numbers. |
| Availability | Lets your consumers know if the product is currently available on your website. Choose only one of following values: Yes, No ou Preorder |
| Weight | The product's shipping weight. Required if you select a shipping cost formula which depends on weight. The unit for weight is pounds in the US, and kilograms for UK. |
| Shipping Cost | Required if you select "Use the shipping costs provided in my product data feed" in the Shipping section of Price Grabber Login. |
How to configure my template with Nextag?
File format with Nextag
Nextag handles TXT file format.
HEADER (the line with attribute's names) is required by Nextag.
Data should be enclosed without any characters, and you should use pipe (|) as field separator.
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>
File name should remain consistent for all updates.
Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with Nextag
Here are the required attributes for Nextag:
| Attribute | Description |
|---|---|
| Category: Nextag Numeric ID | The Nextag category of the products you are listing. You have to map your own categories by using Nextag's taxonomy. By example : laptops products needs to have: 300359 as matching category. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly Note : You must match one of the "Category" columns to a column in your feed. |
| Category: Other Format | The category of the products you are listing. These should be the categories you use on your site. Example : Computers > Laptops. Note : You must match one of the "Category" columns to a column in your feed. |
| Click-Out URL | URL of the product. |
| Condition | The condition of the products you are selling. Choose only one of following values: New, Open Box, Refurbished, Pre-Owned, Like New, Good, Very Good, Acceptable |
| Description | Detailed description of your offer. No HTML coding. Ensure no descriptions are wrapped in quotes. Please do not include promotional text. |
| Ground Shipping | The amount you charge for ground shipping. In dollars with or without the $ sign. If you use a carrier such as FedEx or UPS, you can define this on your Seller Dashboard to ensure you display accurate shipping. |
| Image URL | The URL or address of the images of your products. URL starting with https://, https:// or just www and ending with .jpg or.gif |
| ISBN | The ISBN of any book products you are selling. This field is only required if you are selling books. |
| MUZE ID | The MUZE IDs of any music, video or video game products you are selling. This field is only required if you are selling music, video or video game products. |
| Price | The price of the items you are selling. In dollars with or without the $ sign. |
| Product Name | The name of the products you are selling. |
| Seller Part # | The SKU unique number of the product. |
| Stock Status | The availability or stock status of your products. Choose only one of following values: In Stock, Yes, le nombre en stock, Out of Stock, <blank>. If you leave this blank, Nextag will assume the product is in stock. |
| Weight | The weight of your products. Number in pounds (lbs). |
Recommended attributes with Nextag
Nextag highly recommends to use these attributes in your template:
| Attribute | Description |
|---|---|
| Cost-per-Click | The Cost-per-Click or CPC that you want to pay Nextag when a buyer clicks from our site to yours. In dollars with or without the $ sign. This should only be used if you want to bid on individual products using your Product File. |
| Distributor ID | The distributor ID of your products. One of the following initials: Ingram (I, IM, IP, IA), TechData (T), eNighted (E), ISBN, UPC, LCC plus the number ID. |
| Ingram Part # | The Ingram ID of your products. |
| Manufacturer | The name of the manufacturer of your products. |
| Manufacturer Part # | The manufacturer's part number for the product. It is strongly recommended that you provide this information to improve the quality of your listings on Nextag. |
| Marketing Message | The text message you want to display on our site next to your display name. Example : Free Tax and Shipping |
| UPC | The Universal Product Code (UPC) of the products you are selling. |
| ListPrice | The item's price when it is not on sale. In dollars with or without the $ sign |
How to configure my template with Twenga?
Data Feed Manager allows you to create data feed in destination of Twenga.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at this link which will be helpful:
Twenga's feed specifications
File format with Twenga
Twenga handles CSV/TXT or XML file format.
About CSV/TXT files:
- data shouldn't be enclosed
- you can use either tab, semicolon, comma or pipe as field separator.
About XML files:
- the data feed must be UTF-8 encoded (<?xml version="1.0" encoding="UTF-8" ?>)
- catalog tags (<calalog>...</catalog>) must enclose the content.
- each product must be in product tags (<product>...</product>)
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>.
File name should remain consistent for all updates. (e.g. MerchantnameSDC.csv).
Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with Twenga
These 7 attributes are required.
Products without these values will not display on Twenga:
| Attribute | Description |
|---|---|
| product_url | URL on your website containing the product |
| designation | Product Names must be clear and concise. (limited to 255 characters) |
| price | Final price of the product, with or without VAT, depending on local regulations. |
| category | Navigation path of the product (Breadcumb). Default separator : > (greater). The category mapping of the product (by example : "Home>Televisions>LCD TVs>Thomson"). Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
| image_url | Main picture of the product. Minimum size : 500x500 pixels. Maximum size : 2000x2000 pixels. |
| description | Product's description. Only the first 180 characters will be display in Twenga |
| regular_price | Product's sale price, before any sale. Leave empty if the product doesn't have any discount. |
Recommended attributes with Twenga
Here are recommended attributes by Twenga:
| Attribute | Description |
|---|---|
| merchant_id | Product's ID. The internal product ID used by the merchant. |
| manufacturer_id | The manufacturer ID. You may use SKU for this attribute. |
| shipping_cost | Shipping cost. If not specified, leave empty or specify "NC" For free shipping, specify "0". |
| in_stock | Denote Y to show you have the product in stock and N when the product is out of stock. |
| availability | Number of products available |
| condition | For new products, use "0". For used or refurbished products, use "1". |
| upc_ean | UPC or EAN of the product. |
| brand | Brand or manufacturer of the product. |
Example of template with XML, CSV and TXT format with Twenga
Here is an example of template with XML format:
Here is an example of template with CSV format:
Here is an example of template with TXT format:
How to configure my template with Idealo?
Data Feed Manager allows you to create data feed in destination of Idealo.
Here are some tips which will be useful to create your data feed.
First, we recommend you to look at these 2 links which will be helpful:
Here are the admission requirements for Idealo:
- Your store contains at least 20 products already existing in Idealo's catalog.
- All prices are displayed in euro (including VAT)
- Your legal info is correct
- Your policies are accessible and understandable to any customer
- Customers can choose between at least 2 payment methods.
- Shipping won't exceed 15.00 for small appliances
- Shipping won't exceed 50.00 for big appliances
File format with Idealo
Idealo is used to work with CSV files.
Data shouldn't be enclosed.
You can use either tab, semicolon or pipe as field separator.
The CSV file must contain a header line describing each column's name.
Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with Idealo
These attributes are required by Idealo.
Products without these values will not display on Idealo:
| Attribute | Description |
|---|---|
| Catégorie | Internal category path. (By example: digital photography - digital camera - compact digital camera - Canon - Canon Digital Ixus 70) |
| Marque / Fabricant | The brand or manufacturer of the product |
| Produit | The name of the product |
| Référence fabricant (HAN) | The manufacturer reference |
| Prix en euro (TVA incluse) | Price in euro (including VAT) |
| Frais de port | Shipping cost. If free shipping, fill in with "0". |
| URL produit | URL on your website containing the product |
| Délai de Livraison | Delivery time / availability |
| EAN (European article number) | EAN code of the product |
| Code CIP | Only for pharmaceuticals |
| ISBN | Only for books |
| Ecotaxe | Eco-tax amount, only if not already included in the price |
Recommended attributes with Idealo
Here are attributes recommended by Idealo:
| Attribute | Description |
|---|---|
| Numéro d'article (interne) | Internal reference of the product (usually SKU) |
| information sur le produit | The description of the product (short version if available) |
| URL photo | The URL of the main picture of the product. |
| Prix Promo | Sale price of the product |
Example of template with CSV format with Idealo
Here is an example of template with CSV format:
Numéro d'article (interne);EAN (European article number);Référence fabricant (HAN);Marque / Fabricant;Produit;Catégorie;Prix en ¤ (TVA incluse);Délai de Livraison;Frais de port;URL produit;URL photo;Ecotaxe (si non incluse dans le prix);Prix Promo (facultatif)
40101966;3165140580113;GSB 14.4-2-LI;FBC BOSCH;PERCEUSE VISSEUSE 14,4V 1,3AH LI-ION;Outillages électroportatif à batterie; 518,87;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1; 418,87
40101915;0000401019151;BHP453RHEX;MAKITA;PACK PERCEUSE A PERCUSSION 18V 1,5AH LXT;Perceuses, visseuses et boulonneuses; 164,00;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1; 16,00
43302205;3148518627948;CPE.PB;FACOM;LOT DE 2 PINCES "PACK PREMIER";Pinces standards et coupantes; 68,90;Livrera sous 3 jours ouvrables après réception du paiement.;0 (si frais de port gratuits);https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1; 55,90
46600252;0000466002525;1-94-747;STANLEY TOOLS;SERVANTE DE CHANTIER LOCK & STOCK FATMAX;Boite à outils; 1122,95;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1;
45900043;3253561956294;1-95-629;STANLEY TOOLS;GILET PORTE-OUTILS FATMAX XTREM;Saccoches et porte-outils; 53,20;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1; 43,20
44800848;9999999999999;0-10-825;STANLEY TOOLS;COUTEAU CUTTER PLIABLE FATMAX;Cutteurs et ciseaux; 17,95;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1;
46600415;3253561974755;1-97-475;STANLEY TOOLS;JEU 2 TRETEAUX PLIABLES COMPACTS;Etais et trétaux de maçon; 84,45;Livrera sous 3 jours ouvrables après réception du paiement.;0 (si frais de port gratuits);https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1; 80,00
60800432;3253561951480;1-95-151;STANLEY TOOLS;LAMPE TORCHE LED PETIT MODÈLE;Torches, ampoules, et éclairage; 16,67;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1;
42606588;3253560975456;0-97-500;STANLEY TOOLS;CLE A MOLETTE A CLIQUET FATMAX;Clés de serrage à ouverture variable; 14,23;Livrera sous 3 jours ouvrables après réception du paiement.;4;https://www.idealo.fr/exemple;https://www.idealo.fr/exemple-exemple.jpg;0,1;How to configure my template with eBay?
File format with eBay
eBay handles CSV/TXT or XML file format.
About CSV/TXT files:
- data must be enclosed with double quotation marks (")
- if you intend to use the double quote character ( " ) itself and not as a delimiter, it should be repeated. For example, '15" TV' should be entered as "15"" TV".
- you must use comma as separator in CSV files, and either tab, semicolon, comma or pipe in TXT files.
About XML files:
- the data feed must be UTF-8 encoded (<?xml version="1.0" encoding="UTF-8" ?>)
- each product must be in product tags (<product>...</product>)
The following characters are forbidden within any cell:
- Smart Quotes Character ("?")
- Carriage Returns Character
- New Line Characters
- Any character whose ascii value is less than 32, e.g. Carriage Returns (ascii 10), Newline (ascii 13)
- HTML, CSS, or any other formatting languages, e.g. "\n\r", <p>, <br>.
File name should remain consistent for all updates. (e.g. ebay.csv). Do not include the date in your file name.
File name cannot contain spaces or illegal symbols.
Required attributes with eBay
These 9 attributes are required by eBay. Products without these values will not display on eBay.
(between brackets, the name to use with XML files)
| Attribute (Merchant_SKU) |
Description (Merchant_SKU) |
|---|---|
| Unique Merchant SKU (Merchant_SKU) |
The unique SKU number you use internally to identify this item. |
| Product Name (Product_Name) |
Product Names must be clear and concise. They should also be descriptive of the product being sold. Use the following template to build your product names: [MAIN BRAND] [PRODUCT NAME] [GENERIC PRODUCT TYPE] Example : Leica M7 Rangefinder 35mm Camera |
| Product URL (Product_URL) |
URL on your website containing the product detail and buy button for the applicable product. |
| Image URL (Image_URL) |
URL to the item's largest primary image. Minimum size accepted: 150x150 pixels. |
| Current Price (Current_Price) |
The current selling price for the item before tax or shipping. |
| Stock Availability (Stock_Availability) |
Denote In Stock to show you have the product in stock and Out of Stock when the product is out of stock. |
| Condition (Condition) |
Please use this field to indicate if the item is "New", "Used" or "Refurbished". IMPORTANT: eBay Commerce Network currently displays "New" products only. "Used" and "Refurbished" products are rejected automatically. |
| MPN/ISBN (media only) (MPN ou ISBN) |
The ISBN is a unique machine-readable identification number. eBay Commerce Network supports both the 10 and 13 digit versions of ISBN. |
| UPC/EAN (media only) (UPC ou EAN) |
eBay Commerce Network supports both the 12-digit Universal Product Codes (UPC) and the 13-digit EAN codes. UPC or EAN are strongly recommended in all categories. Items with UPC or EAN will be better classified in eBay Commerce Network. |
Recommended attributes with eBay
Here are attributes recommended by eBay:
(between brackets, the name to use with XML files)
| Attribute (Merchant_SKU) |
Description (Merchant_SKU) |
|---|---|
| Shipping Rate (Shipping_Rate) |
Shipping cost for this item. Use 0 to denote free shipping. |
| Original Price (Original_Price) |
The item's original price. |
| Brand / Manufacturer (Manufacturer) |
Brand, manufacturer, or publisher of the product. |
| Product Description (Product_Description) |
Product Descriptions should elaborate on Product Names and provide all relevant product details. Limited to 4000 characters. |
| Product Type (Product_Type) |
Provide an ordered list of nouns describing the type of product. Example: "Sneaker, Cross Trainer"). |
| Category (Category) |
Please provide a breadcrumb describing your classification of the respective product (use > to delimiter sub-categories) |
| Category ID (Category_ID) |
Please use the updated Category worksheet to provide the right eBay Commerce Network's Category ID for this item. (cf. "Categories" tab in eBay'specifications). Remember to use category mapping in Data Feed Manager to fill in this attribute properly. |
| Parent SKU (Parent_SKU) |
If the product is one variant in a family of similar products, provide here the SKU of the parent product. |
| Parent Name (Parent_Name) |
If the product is one variant in a family of similar products, provide here the name of the parent product. |
| Estimated Ship Date (Estimated_Ship_Date) |
Provide your estimated time frame for the shipping of the product. Example: Allow 2 - 3 weeks for delivery. |
| Gender (Gender) |
Indicate the gender(s) for whom the product is intended. Use a comma to separate them. Admited values: Men, Women, Boys, Girls, Infants and Toddlers, Unisex |
| Color (Color) |
The primary colors for the product. In the event that the product is multi-colored, please separate the colors with a slash (/). Please provide an individual record for each color. |
| Material (Material) |
Indicate the materials from which the product is intended. Values should be comma separated. |
| Size (Size) |
The size of the product. |
| Age Range (Age_Range) |
eBay strongly recommends that age ranges are included for data feeds that include toys, apparel, jewelry and sporting goods. Examples: 3 - 6 months, 5 years and up, Adult,... |
Example of template with XML format with eBay
Here is an example of template with XML format:
<Products>
<Product>
<Merchant_SKU>93345</Merchant_SKU>
<Product_Name>J. Crew White Floral Summer Sundress</Product_Name>
<Product_URL>https://www.abcxyz123.com/store/product.html</Product_URL>
<Image_URL>https://www.abcxyz123.com/images/6857623495-1000.jpg</Image_URL>
<Current_Price>$99.99</Current_Price>
<Shipping_Rate>5.95</Shipping_Rate>
<Stock_Availability>Pre-Order</Stock_Availability>
<Condition>New</Condition>
<UPC>053759061260</UPC>
<EAN></EAN>
<MPN></MPN>
<ISBN></ISBN>
<Original_Price>$199.99</Original_Price>
<Manufacturer>J. Crew</Manufacturer>
<Product_Description>Medium weight floral printed sundress. Perfect for Sunday brunch.</Product_Description>
<Product_Type>Dress > Sun Dress</Product_Type>
<Category>Clothing & Accessories > Women clothing > Dress > Sundress</Category>
<Category_ID>31515</Category_ID>
<Parent_SKU>93344</Parent_SKU>
<Parent_Name>J. Crew Floral Summer Sundress</Parent_Name>
<Estimated_Ship_Date>Allow 3-4 Weeks for Delivery</Estimated_Ship_Date>
<Gender>Women, Girls</Gender>
<Color>White</Color>
<Material>Cotton, Spandex</Material>
<Size>10</Size>
<Age_Range></Age_Range>
</Product>
</Products>Display your products on any marketplace and make the most of your data feeds thanks to Data Feed Manager
Efficiently export your products catalog to Shopping engines
- Export your products into any data feed type:
csv txt xml - Include all product types: simple, configurable, grouped, bundle... and custom types
- Create multi-stores, multi-currencies, multi-VAT-rates data feeds
Create data feeds compliant with any shopping engines requirements
- Start with the 19 sample templates
- Find any attribute in the attributes library
- Preview your data feeds and use the syntactic helper to avoid misprints
Completely customize your data feed according to your products catalog
- Add any Magento® attribute to your template
- Create attribute set and category filters
- Use OR/AND statements in your filters
- Add any PHP option
Automatically and regularly send your updated data feed to the shopping engines
- Use the scheduled tasks to automatically update and generate your data feeds
- Upload your data feeds via FTP (Ftp testing tool)
Magento® versions supported by Data Feed Manager
This extension works with Magento Community Edition and also Magento Enterprise Edition. To know if Data Feed Manager is compatible with your Magento version, please check the Compatibility tab.
Simple Google Shopping Vs Data Feed Manager
Data Feed Manager includes all the features of Simple Google Shopping but allows you to create more kinds of data feeds (csv, txt, xml) and with special features like extra-header for any shopping engine, market place or search engine such as BingShopping, Shopping.com, Shopzilla, Amazon...
Supported countries with Data Feed Manager
All countries are supported (tax rates and currencies). You just need to edit the feed for the target country. You also may have to use the appropriate currency when using prices attributes.
Supported currencies with Data Feed Manager
Each currency can be managed in your data feed. You can use different values in all price attributes in order to convert currencies.
Character encoding of the generated data feed
The char encoding of the data feed generated is UTF-8 for Simple Google Shopping. It allows the use of special characters, such as accented letters, but also Arabic and Chinese letters.
If you are using Data Feed Manager, the default char encoding is UTF-8, while no char encoding is specified in the XML header.Data Feed Manager limitations
Data Feed Manager has been tested successfully on a file containing more than 70,000 products.
Remember that the generation and export time for any quantity of products will depend on your server capacity. Generally, exporting a data feed with 10,000 products shouldn't take more than 2-3 minutes on a standard shared server.
License validity
A license is valid for an unlimited period of time on one single Magento installation.
If you use more than one Magento installation, you will have to buy a separate license for each.
if you run several domains on the same Magento installation, you will need only one license for all of them.
Although your license doesn’t have a limited period of validity, your support and upgrade period does. By purchasing an extension, you’ll be granted a 6-month support and upgrade period for free.
Passed this period, you will have to pay for a new one (see FAQ: Extension upgrade).Domains pre-registration
You can pre-register your live domain to your license and activate it in advance.
Thanks to this option, you'll be able to get the extension ready to use on your domain before it goes live.
To pre-register your production domain, go to:
my account downloads
And click on next to the extension you want your domain to pre-register on.
At the bottom of the page, below the list, click on the orange link saying:
Do you want to pre-register your domain in order to be ready to go live?Finally, enter your domain name and click on pre-register now .
Testing environments
One license is valid for an unlimited period of time on one Magento installation only.
It is possible, however, to extend or transfer your license in three cases:
- If you'd like to add your testing environments to your license.
In this case, it is possible to extend your license to an unlimited number of domains for free.
For example mywebsite-staging.com or mywebsite-dev.com - If you redirected definitively one domain to another one (301 permanent
redirection ).
In this case, you can request a license transfer for free. - If you'd like to shift your license from one Magento installation to another.
In this case, you can request a license transfer which you'll have to pay for.
To be able to use Data Feed Manager on both your production and testing environments, follow the instructions below:- Download Data Feed Manager.
(see FAQ: Extensions download). - Install Data Feed Manager on your production environment.
(see FAQ: Extensions installation) - Activate the license.
(see FAQ: Extensions activation). - From your Magento admin panel, enter your current Activation Key from:
syStem CONFIGuration WYOMING YOUR EXTENSION - Save config
Now that you can use Data Feed Manager on your production environment, repeat the same steps as above on your testing environments.The only difference this time: a notification will appear in your Magento admin.
You will be given a choice in between:
- buy a new license now
- add this domain to my license
Click on Add this domain to my license.A transfer request will then be sent to our team within an hour.
Once the request is taken care of, you will receive a confirmation email.
If your transfer request is accepted, you can use Data Feed Manager on both environments at the same time.
The order in which you activate your license on your domains does not matter.
You can start with your staging/dev/local environment or with your live domain, the process will be the same.- If you'd like to add your testing environments to your license.
Extensions installation
Before installing Data Feed Manager, you’ll have to:
- Backup your Magento installation in:
system tools backups - Disable the compiler in your Magento admin panel if it’s not already disabled:
system tools COMPILATIONS - Refresh your cache in:
systemselect cache typeactionsrefreshsubmit
Now you can install Data Feed Manager:- Download Data Feed Manager (zip file) from:
my account my downloads
Refer to FAQ here: Extensions download - Once Data Feed Manager is downloaded, open the folder and unzip it.
- Copy the content of the unzip folder and paste all files and directories in your Magento root directory (the folder content can vary according to the extension but it generally includes app, lib and skin folders).
- Once your installation is complete, don't forget to enable the compiler back (if it was already enabled before the installation) and run compilation process.
- Refresh your cache, logout from your admin panel and log back in right after.
Next step is to activate your license, to do so, click here: Extension activation
- Backup your Magento installation in:
Extensions uninstallation
To uninstall Data Feed Manager, go on its zip folder and open it.
You will find a shell file (such
as: yourextension -uninstall.sh) that you must execute on both your server and Magento root directory.Once the uninstallation is over, refresh your cache and enable the compiler back again (if you use it).
Extensions activation
Once Data Feed Manager is downloaded, you have to activate the license:
- Go to your Magento admin panel. A message pops up at the top of the page.
If the message doesn't appear then you must check that:
Wyomind's License Manager has not been removed from your installation.
system configuration advanced advanced
Wyomind's License Manager is enabled in: app/etc/modules/Wyomind_Licensemanager.xml
The HTML output for Wyomind_Licensemanager and/or Adminhtml_Notification are not disabled in your system under: - Copy your activation key.
You can find your activation key in 2 different places:
- In the confirmation email that you received after purchasing Data Feed Manager
- In your Wyomindaccount: MY ACcount My downloads, select Data Feed Manager and click on . A new page opens where you'll find your activation key (see below).
- In your Magento admin go
to: System Configuration Wyomind Your extension
Paste the activation key in the Activation Key field and choose between the automatic (yes) or the manual (no) activation method:
- By choosing Yes, the connection to Wyomind's license server will be automatic.
- By choosing No, you will have to log on to Wyomind's license server yourself.
- Save config.
- A message appears at the top of your admin panel: Activate it now! Click on that link.
- Copy and paste the license code in the License code field from your admin or simply click on Activate now!
- Finally, refresh your cache, log out and log back in straight after, to complete the installation.
To activate the license of an extension that includes other modules, you’ll have to repeat the steps described above for each, using the corresponding activation keys (each module has its own activation key).
- Go to your Magento admin panel. A message pops up at the top of the page.
Extensions download
In order to download Data Feed Manager, log into your Wyomind account:
- Go to:
my account my downloads
- Click on next to Data Feed Manager.
A new window opens.
- Choose the version of Data Feed Manager.
You will be able to choose the most recent version of Data Feed Manager (for both Magento 1 and Magento 2).
- Click on download .
Your download can start.
- Go to:
Extensions upgrade
With each purchased extension comes a free 6-month upgrade period, during which you can download and install the new version of your extension. Passing this period, you will have to purchase an additional upgrade (price depends on how long the period is)To upgrade Data Feed Manager, follow the steps below:
- Go to:
my account my downloads - Click on next to Data Feed Manager.
- Choose the latest version of Data Feed Manager (for Magento 1 and Magento 2).
- Click on download .
- Enter your current activation key and click on .
- Select the domain name.
- Choose from 1 to 12 months of Support and Upgrade period.
- Choose a professional installation or not.
- Click on BUY NOW .
To finish, don't forget to reinstall Data Feed Manager to update your Magento admin.If you can't find your download after upgrading your domain, please contact us:
https://www.wyomind.com/fr/contact.html- Go to:
XML data feed and CDATA
CDATA stands for Character Data. It means that the data in between these tags include data that could be interpreted as XML markup, but should not be.
Syntactically, CDATA behaves similarly to a comment but it is still part of the document.
CDATA sections have no encoding, so there's no way to include the string ]]> in them.
Data feeds urls
If for example, you are getting:
https://mywebsite.com/googlefeed/example_feed.xml?r=0123456789Instead of:
https://mywebsite.com/googlefeed/example_feed.xml
It's normal, actually, the url https://mywebsite.com/googlefeed/example_feed.xml is still available. The parameter ?r=0123456789 at the end of it is simply a random number to avoid cache issue when you download the data feed from your magento admin.Download the data feed
To download your file, you need to:
- Generate the file.
- Right-click on on the generated link from the grid.
- Choose the Save as option.
Use filters in the data feed configuration
Data Feed Manager provides you with multiple ways to adjust which kind of products you want in your datafeed.
In the Filters tab of your datafeed configuration, you'll find 3 sections:
- Product type
- Product visibility
- Advanced filters
Product type
In this section, you could choose which kind of product type (Simple, Configurable, Bundle, Grouped, Virtual, Downloadable) you want to export.
Case 1
By example, if you're selling t-shirts and you want to export every sizes and every colors individually, just tick Simple checkbox and leave others empty.Case 2
But if you only want to export your t-shirts and specify appart sizes and colors available, tick Configurable checkbox and leave others empty.PLEASE NOTE that Google Merchant specify that for feeds targeting US, UK, FR, and JP : Any apparel item that varies by 'color', 'material', 'pattern', and/or 'size', must be submitted as a unique combination (like in our Case 1 ).
Product visibility
In this section, you will be able to export in your datafeed the products depending on their visibility in Magento.
Case 1
Your simple products are probably not visible individually (because connected to configurable products). So you'll have to tick Not visible individually checkbox.Case 2
Just tick Catalog and Search checkboxes, it'll do it great.Advanced filters
This is probably the most powerful part of the filters section.
This section will allow you to filter your products with barely all the ways you want to. You can apply condition on each attribute of your products, like price, name, SKU, color, size, etc.
Most of the conditions available are pretty obvious : = , < , > , ≤ , ≥ , ≠
- Like and Not like are to use with the wildcards _ (any character) and % (zero or more characters)
By example, this will return only products whose name starts with 'rock and roll' (like 'rock and roll pants', 'rock and roll shirt', etc).
- null and is not null are used to identify products with empty attributes.
- in and not in are used to identify products with possible multiple values (like t-shirts whose color is black or blue or red by example).
PLEASE NOTE that attributes with multiple values (like Shirt Size) appear as a list (Small, Medium, Large). This makes you easier to select specific products.
Schedule the data feeds generation
Data Feed Manager provides you with a fully configurable schedule in the Scheduled task tab of your template configuration for each data feed.
Warning: So that it works, you must have one main scheduled task running from your server side and targeting cron.php (or cron.sh) located in the Magento root directory (each hour ideally).
If the management panel from your hosting compagny doesn't provide such a service, you can use a remote service such as: http://www.mywebcron.com.
Data Feed Manager also provides you with a cron job reporting, so you can get email reports on each data feed you will generate.
Generate and Export a data feed
Generating a data feed is totally different from exporting a data feed.
To generate a data feed from Data Feed Manager, you only need to choose Generate in the action dropdown from the data feeds list or to click on Generate from the feed configuration.
You will get an .xml, .csv or .txt file according to your configuration. This will allow you to upload your products data into the platform you want (such as Google Shopping).
To export a data feed from Data Feed Manager, you only need to choose Export in the action dropdown from the data feeds list or to click on Export from the feed configuration.You will get a .dfm file. You will be able to save a template that you have previously created from Data Feed Manager and to import it if needed into your Magento admin for example.
Some products are showing up in data feeds but they don't in other ones
This issue may come from string values with some HTML tags, non-UTF8 chars,...
In order to fix this, you could use the following options to all concerned fields:
{attribute,[strip_tags],[html_entity_decode],[inline],[cleaner]}Here is the detail of parameters used above:
- strip_tags: Remove all HTML tags
- html_entity_decode: Convert all HTML entities to their UTF8 equivalents
- inline: Remove all unneeded spaces
- cleaner: Remove all non UTF8 chars
Open a CSV file with a spreadsheet application
You have the possibility to open the generated CSV file with any spreadsheet application.
While opening your data feed, you need to make sure to select the delimiter options that correspond with your data feed configuration.
- In your data feed configuration, choose how your columns will be separated with: tabulation, comma, semi-colon...
- Generate the data feed.
- Open the data feed with a spreadsheed application.
- Choose the same delimiter and enclosure characters as in your data feed configuration.
For example, if you've chosen semi-colon as Fields delimiter, then you'll need to open the file choosing ";" as field delimiter as well as if you've choosen double quotes as the Fields enclosure, then you'll have to make sure that you've selected the same character.
Note that the Excel application won't show this popup when opening the file.
Configure FTP Settings tab
In Data Feed Manager, you can specify ftp settings to upload your data feeds.
Select a data feed and go to the Ftp Settings tab. There you'll be able to configure some parameters:
- Enable FTP upload
Select Yes if you want to upload your data feed using FTP. - Use SFTP
Select Yes if you are using SFTP.
Secure connection (sftp) is only available in the latest version of Data Feed Manager. - Use Active mode
If you are using SFTP, you don't have to care about the passive/active mode.
For more info about Active and Passive mode, have a look to that documentation. - Host
In that field, fill in the host.
For example:
ftp.wyomind.com - Login
is your login to connect to server - Password
is your password to connect to server - Destination director
is a relative path from the entry directory when you connect to the ftp.
For example:
upload/ or /
In order to be sure your settings are correct, click on Test Connection .
- If you don't have an error message, it means the connection succeeded.
- If you have an error message, you'll certainly have to check your credentials.
The file is uploaded each time the feed is generated manually or automatically.
- Enable FTP upload
Use the product custom options in the template
You can use the custom options of your products in your template.
Note: This can be done only with the last version of the module (v7.0.0)
STEP 1
Add the following snippet to your template:
{load_options,[OptionA],[OptionB]}OptionA and OptionB are the titles of the custom options of your product given in the admin area. These titles are case sensitive and space sensitive, so they must be entered exactly as they are in the admin.
As an example, we have a product with 2 custom options: LugColor and LugSize. So the product is available in Small, Medium, Large and in Black, Purple and White.
Instead of one item in our data feed we will get 9 items:
- Product 1 Small Black
- Product 1 Small Purple
- Product 1 Small White
- Product 1 Medium Black
- etc
So our template should look like the following screenshot in order to retrieve all the options of our product.
STEP 2In your data feed, you have the possibility to use the following attributes:
- {OptionA_label} {OptionB_label}
- {OptionA_sku} {OptionB_sku}
- {OptionA_price} {OptionB_price}
- {OptionA_type} {OptionB_type}
Your template must be managed to avoid any duplicated items, so instead of:
<g:id>{sku}</g:id>You must use:
<g:id>{sku} {OptionA_sku} {OptionB_sku}</g:id>and concerning the prices, you should use:
<g:price><? return {price}+{OptionA_price}+{OptionB_price}; ?></g:price>So if we take the example of our product, we should add {LugColor_label} {LugSize_label} into our template. Then for each option, it will retrieve it's own label: black, purple and white.
Configurable products in Google Shopping data feeds
As you probably know configurable products are only containers filled with not visible individually products, that Google call "variants".
That's why the configurable products should not be sent to Google Merchant because there are missing required attributes (price, color, size or any variant attribute). Instead, you should submit the simple products that have all the required information.
In your data feed template, you need to check that:
- You use the Configurable or Parent option to retrieve the information from the configurable product.
Most of the time the attributes that must be retrieved from the configurable products are url and description.
Example
<link>{url parent}</link> <description>{description parent}</description>
- All the simple products that are not visible individually and that belong to the same configurable product are grouped under the same item_group_id. This can be done easily by adding the below "Magic Attribute" in the data feed template.
{G:ITEM_GROUP_ID} - Your filters are not too restrictive. For example, if your variants are not visible individually, make sure to have ticked that option in your data feed filters.
- the categories you've selected are assigned to the simple variant. For example, if only the parent product has a category assigned, you'll be able to include product into your data feed based on the Product and parent categories.
- You use the Configurable or Parent option to retrieve the information from the configurable product.
Google Shopping Ads and performance tracking
Google Analytics provides many details about incoming traffic from Google Shopping Ads Campaigns.
However, you may want to track incoming traffic from your Shopping Ads in Google Analytics by your owns. To do so, you can use the UTM parameters with dynamic variables and/or fixed values as follows:
<link>{url}?utm_source=My Website&utm_medium={medium}&utm_campaign={campaign}&utm_term={term}&utm_content={content}</link>
Add the currency in the URL and preselect the currency in the landing page
You have the correct currency specified in your data feed. However, when a customer clicks on the link from Google Shopping, it shows the default currency instead of the correct currency.
For this reason Google may not approve your data feed and may suspend your account.
That issue has nothing to do with the extension, but you can easily fix it copying the file:
app/code/Core/Mage/Core/Model/Url.phpto:
app/code/local/Mage/Core/Model/Url.phpThen, locate the method setRoutesParams() and add the below code at the beginning of the function:
if (!is_null($this->getRequest()->getParam('currency'))) { if ($this->getRequest()->getParam('currency') != Mage::app()->getStore()->getCurrentCurrencyCode()) { Mage::app()->getStore()->setCurrentCurrencyCode($this->getRequest()->getParam('currency')); } }
The beginning of the function should now look like :// [...] public function setRouteParams(array $data, $unsetOldParams = true) { // the changes begin here if (!is_null($this->getRequest()->getParam('currency'))) { if ($this->getRequest()->getParam('currency') != Mage::app()->getStore()->getCurrentCurrencyCode()) { Mage::app()->getStore()->setCurrentCurrencyCode($this->getRequest()->getParam('currency')); } } // the changes end here if (isset($data['_type'])) { $this->setType($data['_type']); unset($data['_type']); } //[...]You can now use the below code at the end of your products urls so that the monnaie will be loaded automatically when displaying the page:
?currency=currency_code
Exampleshttp://www.website.com/men/new-arrivals/linen-blazer.html?currency=EURhttp://www.website.com/men/new-arrivals/linen-blazer.html?currency=USD
Get a list of all the categories
This can be easily achieved with a few lines of php code in the product pattern or even in the header pattern. For example:
<categories> <? if(!isset($this->done)){ $xml=null; $categories= Mage::getModel("catalog/category")->getCollection() ->addAttributeToFilter('level',array('gt'=>1)) ->addAttributeToSelect('name'); foreach($categories as $category){ $xml.="<category> <name>".$category->getName()."</name> <url>".$category->getUrl()."</url> </category>\n"; } $this->done=true; return $xml; } ?> </categories>This code will produce:
<categories> <category> <name><![CDATA[Women]]></name> <url><![CDATA[http://www.wyomind.com/women.html]]></url> </category> <category> <name><![CDATA[Men]]></name> <url><![CDATA[http://www.wyomind.com/men.html]]></url> </category> ... </categories>Exclude products from a data feed based on the category ID
You need to complete your data feed template with some php script:
<? if(in_array(CATEGORY_ID,explode(',',$product->getCategoriesIds())) $this->skip(); ?>Exclude specific products from a data feed
You have the possibility to exclude some products from the feed using advanced filters from the Filters section.
For example, you would like to filter out 3 products: SKU1, SKU2 and SKU3. Then you only have to create a NOT IN advanced filter as below:
Sometimes, advanced filters aren't enough to generate your data feed in the way you want it to be.
For example, let's say you want to extract all your catalog products, except the ones whose category mapping is Shoes. If you tick all categories except the Shoes one in the Categories section, you'll miss all uncategorized products.
In that case, you can use a code snippet in your template which will exclude the Shoes category. This will only work if you untick all categories in the Categories section:
<? // if category is Shoes then skip the product) if("{category_mapping}"=="Shoes") $this->skip(); ?>In a general notation:
<? if("{attribute_code}"=="value") $this->skip();?>Exclude enabled child products when their parent products are disabled
When you want to disable configurable products, you usually only disable parent products and not the relative simple products. The consequence is that these simple products are still present in your data feed.
To save you from the annoying task of disabling each child product, you can first enable the Include disabled products option in:
SystemConfigurationWyomindData Feed ManagerCore Setting
Then, you have to add the following script in the Product Pattern field of your data feed configuration:<? {status,[isset]} ?> <?if($this->checkReference("parent",$product)->getStatus()==2) $this->skip;?>Finally, in the Filters tab of your data feed, add:
Status | = | enabled (or 1 if the dropdown doesn't display)Sort products order in the data feed
You can add the sort order by editing app/code/local/wyomind/datafeedmanager/model/product/collection.php.
Replace all code with the below code (change "attribute" with the code of your attribute):<?php class Wyomind_Datafeedmanager_Model_Product_Collection extends Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection { public function isEnabledFlat() { return false; } public function getCollection() { return $this->addAttributeToSort('attribute', 'asc'); } } ?>Skip all the empty values of a data feed
There are several possibilities to skip the empty values of your data feed:
- You can use the advanced filters in order to filter out the products for which the value is null.
Here is how to use the advanced filters with Data Feed Manager: https://www.wyomind.com/data-feed-manager-magento.html#Filters - You can use some php scripts that will clear the output ($this->skip();) depending on your own conditions:
<? if (...something...) $this->skip(); ?> - You can also return a false boolean value in the custom attribute that will skip the corresponding products:
return false;
- You can use the advanced filters in order to filter out the products for which the value is null.
Generate custom values for a specific attribute
First, create a custom attribute, for example {attribute_name}, in:
CatalogData Feed ManagerCustom Attributes
Then, in the php section enter the code you need:if($value="A") return 123; elseif($value="B") return "456";
Don't forget to Save your custom attribute!
Finally, insert the attribute in you template:
Scheduled tasks don't work
How do cron tasks work:
- cron.php is launched regularly from your server side (every 5 minutes most of the time).
- The cron task for Data Feed Manager is targeted and evaluates if a data feed or a profile needs to be refreshed (depending on the timestamp stored in the database and on the schedule table for this specific profile).
- If the above condition matches, then the data feed and the profile is re-generated.
Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your Magento installation.
The extension includes reporting and debug tools for the scheduled tasks in:
systemconfigurationWyomindData Feed Manager
We also strongly advice to install the AOE Scheduler that will help you to monitor the Magento cron tasks.
Base table or view not found
This issue may be due to a problem during the installation process.
You can fix it by following these steps:
- Access your database via your control panel (Phpmyadmin for example).
- Delete the entry datafeedmanager_setup from the core_resource table.
Be careful, that entry depends on your extension. For example, if you have the extension called Simple Google Shopping, you should delete simplegoogleshopping_setup. - Logout from your Magento admin.
- Log into your Magento admin.
Fatal error: Mage_Core_Model_Resource_Setup.php
If your site crashes and gives this error message after uploading all files to the correct folders:
Fatal error: Class 'Wyomind_Notificationmanager_Model_Resource_Setup' not found in includes/src/Mage_Core_Model_Resource_Setup.php on line 234It probably comes from installing an extension while the compiler is still enabled.
Important note:
- If the compilation is enabled on your website, disable it first before installing any extension from:
SystemToolsCompilation
After installation re-run the compilation process and re-enable the compiler. - Before installing any extension, it's advisable to backup your Magento installation.
Here is how to disable the Magento compiler:
- Edit the following file: includes/config.php and add a # before the 2 following lines:
define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat');to get:
#define('COMPILER_INCLUDE_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'src');#define('COMPILER_COLLECT_PATH', dirname(__FILE__).DIRECTORY_SEPARATOR.'stat'); - Then go back to your website admin and re-run the compilation process.
- If the compilation is enabled on your website, disable it first before installing any extension from:
404 error in the configuration page
Most of the time log-out/log-in may solve this issue.403 forbidden error
If when saving your data feed configuration, you get:
Forbidden, You don't have permission to access /.../ on this server.
This is probably something regarding the hosting company that doesn't allow to post XML in the form.
The mod_security (security module) includes rules that stop all post/get requests including code.
In order to fix that issue, you should get in touch with your hosting company so that they can add some exceptions to the security rules.
404 error instead of the Google Taxonomy
You must apply the permissions 644 to libGoogle or libWyomind directory and all sub folders and files via FTP.
404 error instead of the extension page in the admin panel
Try to run the below request in phpmyadmin or in any database manager.
For Simple Google Shopping :
UPDATE simplegoogleshopping SET store_id=(SELECT store_id FROM core_store WHERE store_id>0 LIMIT 1);For Data Feed Manager
UPDATE datafeedmanager_configurations SET store_id=(SELECT store_id FROM core_store WHERE store_id>0 LIMIT 1);404 error page after deleting a storeview
If after deleting a storeview, you get a 404 error page, you must look in your database (with PhpMyAdmin) which store_id (i.e. storeview ID) has been deleted.
Then to fix the issue, you have to update each element from the table simplegoogleshopping or datafeedmanager (depending on your extension) with another valid store_id.
Please make sure that '/feeds/' is writable by the server
The directory in which your data feed is stored must be writable (permissions 755). You should try to use another directory such as /media/ if /feeds/ is not properly set by changing the content of Path field.
Please create the specified folder before saving the data feed configuration
You need to access your server with FTP client software (like Filezilla).
Then in your Magento root directory, you need to create the feeds folder and apply the 755 permissions.
Empty feed when opened from the browser
You may have an incorrect character in your data feed description, for example the & character.
In that case you should replace the & character with and or enclose your data between CDATA as in the example below.
Characters from the data feed aren't displayed properly
First, be sure to use special attributes which will clean your content:
{attribute,[strip_tags],[html_entity_decode],[inline],[cleaner]}If your data feed still doesn't display properly, maybe it's because you try to read it as an ISO file while Data Feed Manager creates UTF-8 encoded files.
We recommend you to read it with dedicated programs like Notepad++ or even Firefox (withDisplayEncoding typeutf8 selected).
Unable to list current working directory
The Data Feed Manager module uses a temporary directory to store data. You must make sure that var/tmp exists under your M
agento root directory, if not, you should create it.
Magento® Community Edition
- 2.3
- 2.2.7
- 2.2.6
- 2.2.5
- 2.2.4
- 2.2.3
- 2.2.2
- 2.2.1
- 2.2.0
- 2.1.9
- 2.1.8
- 2.1.7
- 2.1.6
- 2.1.5
- 2.1.4
- 2.1.3
- 2.1.2
- 2.1.15
- 2.1.11
- 2.1.1
- 2.1
- 2.0.7
- 2.0.6
- 2.0.5
- 2.0.4
- 2.0.3
- 2.0.2
- 2.0.18
- 2.0.16
- 2.0.14
- 2.0.13
- 2.0.12
- 2.0.11
- 2.0.10
- 2.0.1
- 2.0
- 1.9.4
- 1.9.3 +
- 1.9.2 +
- 1.9.1 +
- 1.9.0 +
- 1.8.1 +
- 1.8.0 +
- 1.7.0 +
- 1.6.2 +
- 1.6.1 +
- 1.6.0 +
- 1.5.1 +
- 1.5.0 +
- 1.4.2 +
- 1.4.1 +
- 1.4.0 +
- 1.3.3 +
- 1.3.2 +
- 1.3.1 +
Magento® Enterprise Edition
- 2.3
- 2.2.7
- 2.2.6
- 2.2.5
- 2.2.4
- 2.2.3
- 2.2.2
- 2.2.1
- 2.2.0
- 2.1.9
- 2.1.8
- 2.1.7
- 2.1.6
- 2.1.5
- 2.1.4
- 2.1.3
- 2.1.2
- 2.1.15
- 2.1.1
- 2.1
- 2.0.7
- 2.0.6
- 2.0.5
- 2.0.4
- 2.0.3
- 2.0.2
- 2.0.18
- 2.0.16
- 2.0.14
- 2.0.13
- 2.0.12
- 2.0.11
- 2.0.10
- 2.0.1
- 2.0
- 1.9.1 +
- 1.14.4
- 1.14.3 +
- 1.14.1 +
- 1.13.1 +
- 1.13.0 +
- 1.12.0 +
- 1.11.2 +
- 1.11.1 +
- 1.11.0 +
- 1.10.1 +
- 1.10.0 +
Log into your account to leave your review and get up to 3 months of FREE Support & Upgrade
Super extension
Very happy with extension
Abe - https://microdream.co.uk/
22nd February 2019
Great Extension
The Wyomind Data Feed Manager for Magento 1 is very effective for our Google and Facebook exports. You can customize many options and the support team provides pretty quick support, they will guide you through custom programming and login to your staging site to fix issues themselves.
Kash - https://www.lindybop.co.uk/
19th February 2019
Great!
Works great but you really should offer free upgrades for life on this extension.
NBG
19th February 2019
Great Extension to boos yout sales
We have searched a lot and found this extension. Highly recommend installing this extension as it boosts our online sales through multiple sales channels. Easy to install and very content with the results.
Rick - https://en.kleentexshop.eu/
15th February 2019
Your Extension The Data Feed manager for Magento 2 works quite nice
Data Feed Manager allows our team to quickly create various data feeds, especially Google Shopping feeds. In this way, we can set up new feeds for new markets in our multistore Magento 2. In fact, we have some issues and ideas which should be implemented. We hope Wyomind is ready to manage them.
Marcin
12th February 2019
The best extension around!
We love this extension it automated all of our feeds to third party sales platforms! Keep up the good work Wyomind!
QX Systems - https://www.qxsystems.nl
12th January 2019
Highly configurable for any of your feed needs!
Wyomind support is very responsive with any issues you may have. The extension is constantly being upgraded to remain compatible. Great experience.
Ammer - https://www.booyadirect.com/
30th December 2018
Very good extension
The Data Feed manager for Magento 1 is working good. The generation speed could be faster, but it’s still ok. The resources needed are quit big. Hopefully the extension will improve with new updates. All in all, you can say it’s a solid extension.
Daniel - https://www.etuo.pl/
21st December 2018
Great Way To Save Time In Creating Feeds For Google
I've been using this extension for a few months now and have had an overall great experience getting my Google Feeds up and running. It took a few minutes of research to figure out how to get all the fields I wanted added into the feed, but it was well worth it. When I had a couple of questions, Wyomind's team was quick to respond and was quite helpful in getting me pointed in the right direction. I've only currently used this for Google Shopping ads, but I will be utilizing it soon to create other feeds as well. Overall I would recommend this to anyone who is trying to get a Google Shopping feed going on their Magento 2 store.
Matt - https://www.lamin-x.com
19th December 2018
Good extension
We installed Data Feed manager for our Magento 1 and it's working quite well. On the improvement part we think that the speed of feed generation and the resources needed are too high. Trying to get an update of our version to see if these problems disappear.
Vicente
16th December 2018
Works well
The Data Feed manager is working well in our multistore in Magento 2. We've currently set more than 50 feeds and everything is working very smooth. The options to filter the feeds on product attributes, categories and store views come in very handy when working with various platforms which require different feeds.
Lloyd - https://www.loungeset.nl/
13th December 2018
Paramétrage facile des flux, notamment Google Shopping
L'installation est facile, et les options de configuration faciles à comprendre, même pour un non informaticien. Après appel au support pour 2 ou 3 configurations avancées des attributs "taille" notamment, le flux est généré avec succès sur Google Merchant. Je recommande.
Jacques
11th December 2018
Very great extention
Good extension with many possibilities.
Benjamin
5th December 2018
Very good extension
I am using extension and there are so many options inside. You can export all data all formats. I had a problem with configurable and child product process and I found solution. If you know your job, you can make any export.
Hakan VAR
5th December 2018
Perfect tool for eCom
An essential extension for Magento users. Easy to use and really good support. Allows our team to quickly setup new feeds for new markets, affiliates and other marketplaces. Highly recommended!
Victor - https://www.urbanista.com
26th November 2018
Great feed manager
For google shopping the best tool there is
Maarten
26th November 2018
Must have extension
Extension is so flexible that it can be used for market place feed optimization. We run this extension since many years. Never had a problem!
Jwhisky - https://jwhisky.com/
15th November 2018
Great Extension
The extension works well and as advertised.
Patrick - https://www.bakerybits.co.uk/
13th November 2018
Great extensions
Good range of extensions, highly recommended.
Hitesh
8th November 2018
Great
Great range of extensions, to fulfil what we require as a business. Highly recommended modules with good support provided too. Wyomind is one of the best developers around when it comes to Magento extensions.
John
8th November 2018
another must have extension from wyomind.
For ease to import all your items to anywhere you like. Sooooo simple to use and super easy to install. Will save hours of work and 100% increase sales
Sarah - http://cometlighting.co.uk/
6th November 2018
so far the best extension on market
I tried a lot of feed generators, but Wyomind is the one where I can configure everything smoothly. If there are no built-in option, I can few lines of php and get custom variables, calculatations. I use it for 2 years and this Data Feed Manager meet my expectatation for all price comparator feeds I need for my store. Trust me I did a lot of enhanced xmls - with variables, custom calculations of tax. Extension supports custom options, currencies, and advanced stock. You can add filters and rules to generate the feed you need. 5 stars
Jordan - https://enfamilk.pl/
4th November 2018
Great extenison
Simple setup, endless possibilities regarding filtypes and content. Have been using the extension for 3 year without any hickups.
Stale Lien - https://eshop.advania.no/
2nd November 2018
Great extension, and support.
I have used more Wyomind on several sites as a independant contractor, and I can only recommend. Great for generating feeds for different marketplaces, and has been running excellent so far. Easy to use backend and very useful extensions.
Tommy - https://signex24.com/
29th October 2018
This is a very good extension
we have been using the extension for years to publish the products in google shopping and until now we had not had any problem.
Trader
26th October 2018
Must have
we were struggling to generate datafeed for different marketplaces and this extension has helped us to go to new marketplaces very quickly. We can generate custom feeds as required with very less effort and very quickly. This is a must have for any Magento website.
damu - https://www.lowes.com.au/
23rd October 2018
Top notch service
I was excited even before purchasing the module because of the fast and excellent support provided both by chatting and by emailing my problem. I have been experimenting with the module for two days now and everything seems to work as it should. The backend is clean and straightforward with so many things to configure. I am about to purchase another module from Wyomind, because it looks that their modules worth every penny. Keep up the good work! Regards, Fay
Fay - http://foreseto.gr/
19th October 2018
Hassle free export of data feeds rock solid
Data Feed Manager helps us in overcoming a lot of export issues with Magento. Our webshop in Denmark uses a lot of funny characters, i.e. ø or æ or å. Magento always messes things up when exported. - Funny characters - Date issues (Americain vs European different formats) - Price issues (Americain vs European number format) - Weight issues (Americain vs European number format) Since Datafeed manager we have been able to overcome these problems. Most with the standard functions and some with small adjustments to the improved functions of Wyomind. Our Danish descriptions are now readible and editable in excell. prices and weights aren't multiplied by 10.000 anylonger. Great extension!!
Mark - http://www.kaffetilbud.dk/
11th October 2018
Good extension
We use this extension in our Magento 1 and Magento 2 webshop. The extension is easy to use and have a lot of functions. The manual has been extended and the support from Wyomind is excellent. I would recommend the extension to other people, also the FTP function works very well.
JP
10th October 2018
Great extension ;)
As web agency, we use this extension to manage all feeds for our Magento websites. It's simple to configure and it has great performance on creating feeds. Super useful the “custom attribute” creation, ideally to manage custom values on feeds.
Tiziano
10th October 2018
Excellent feed extension
Used this in Magento 1 and now again in Magento 2. It is a little different in Magento 2 and took quite a lot of help to get going as the syntax is a bit different. The support was very quick and attentive to help me get the first one set up. Once that was done the rest of the feeds were easy as you can duplicate feeds and rename, which is a nice feature. Endless options to filter, select categories and product types to include/exclude from the feeds. Previewing sample is a really great feature. only downside was the library did not have a complete list of useable syntax - but it is in the help file.
Jake - https://www.shoe-trees.co.uk/
9th October 2018
Most comprehensive solution for Data Feed
I have compared other feed solutions but not are even close to this one. It is worth every penny of investment.
Hilason Saddles & Tack - Eric - https://hilason.com/
7th October 2018
Most comprehensive solution for Data Feed
I have compared other feed solutions but not are even close to this one. It is worth every penny of investment.
Hilason Saddles & Tack - Eric - https://tackxas.com/
7th October 2018
Good working extension which safes alot of work
We use the Data Feed Manager for several years now with no problems at all. It saves a lot of time and manage more than 10 feeds for different price search engines and meta search engines. It is worth its money!
Christian - https://coldseason.de/
5th October 2018
great extension for google shopping
We have been using this extension for 5 years without an issue. Easy to add more feeds from any type of marketplace and or cpc comparison shopping channel. 100% vouch for this extension and commercial use on many sites online. AAAAA++++++++++++++++++++
Mark
28th September 2018
Nice extension
Good extension. User-friendly and scalable. Easy to set up for various channels. A must for an online shop that wants to carry out serious online marketing. A must so. Also easy in installation and configuration!
Klaas - https://www.werkplaatstechniek.nl/
21st September 2018
Great extension with many possibilities
We've started with the Google Shopping feed extension a couple of years ago, but needed more customisation in the feeds for other channels. The data feed manager was the solution for this. We've used this extension for over two years and push feeds to several platforms. Great support.
Joost - http://proforto.nl
19th September 2018
Excellent Extension
Having used this extension for quite some time now we can highly recommend this solution for Magento 1 or Mangento 2, this product makes it very easy to create data feeds for a wide variety of ecommerce platforms plus the support is second to none. All round excellent product and after sales service.
The Apppliance Depot - https://www.theappliancedepot.co.uk
29th August 2018
Solid extension for producing Google shopping feed
Hi, My company uses the Magento 2 version of this extension in order to generate our Google shopping feed. It is easy to configure and use. I especially appreciate the ability to quick test changes to the feed and preview 10 results. This has enhanced our troubleshooting ability and makes the work faster when we are adding in new attributes or making adjustments. Thank you to the Wyomind team for creating a nice extension for Magento. Highly recommended.
Andrew
27th August 2018
Works great
We have been using this extension for 4 years without any issues now. We do need an upgrade after 4 years for latest 1.9.3 magento compatibility, but we are very confident this will work work out great!
Bas
23rd August 2018
Must have tool for decent Google Shopping campaigning
We found out that this tool is essential for maintaining a successful Google Shopping campaign. Lots of default settings and a more than enough possibilities for customizing your feeds!
BFOUND - https://123rollenbaan.nl/
15th August 2018
Always great service
I've used a few of their modules including the Datafeed and I have always received great service and the products have always worked as expected or better. I would recommend wyomind to anyone looking for a good product and service.
ChiChi - https://www.pitmoto.com/
11th August 2018
Un module indispensable
J'utilisais jusqu'à présent le module Kongoo (Nostress) et ce depuis plusieurs années. Mais ce module est lourd et parfois un peu lent. Le module Data Feed Manager de "Wyomind" est beaucoup plus intuitif et plus paramétrable. Et le support est ultra rapide et efficace. Les mises à jours sont fréquentes et on a souvent l abonne surprise de voir de profondes améliorations, autant en ergonomie qu'en performances.
Thierry - https://e-motard.com/
24th July 2018
Good software!
We have used Data Feed Manager for many years now, just a couple words of advice, the licensing and IP block system on our staging site seems to throw issues all the time. Businesses are highly dependent on their feeds and this causes them to lose A LOT OF MONEY! But overall we are very happy with this product!
Qx Systems - https://www.qxsystems.nl/
22nd July 2018
Very useful plugin
Data Feed Manager is a very useful extension what I recommend to all my clients who need a feed manager. Also the support answer very fast to all my problems.
Gabriel - https://www.salomon.ro/
19th July 2018
Useful plugin.
The Data Feed Manager is a useful plugin to have to help automate the process of uploading multiple feeds, saving us a lot of time and energy. However, we have had some issues a long the way with certain information being pulled that may not be necessary to our shopping feeds - so the additional support is needed from time to time.
Kirsty - https://www.odylique.co.uk/
17th July 2018
Everything works fine
The extension works perfect! Wyomind have a really good support. They answer in a short time and help us in each case. I can recommend this extension. We use this extension for different datafeeds. It works since over a half year without any problems.
Pascal
12th July 2018
einfach und gute extension auch für und auf deutsch
Hallo, ich schreibe hier in German, für deutsche Nutzer. Data Feed Manager für Magento1 haben wir für das Google-Shopping in Deutschland benötigt und bis auf ein paar kleine Fehler, konnte ein sauberer und korrekter Datenfeed für das Google Merchant-Center erstellt werden. Funktioniert seit 2013. Die Extension können wir guten Gewissens weiter empfehlen.
webmatrix - https://hausarbeit-einfach.de
6th July 2018
Estensione indispensabile
Questa estensione è indispensabile, il supporto è sempre veloce gentile e molto competente. Il feed manager è molto flessibile ed è utile in molte circostanze. Direi che è una di quelle estensioni di cui non si può fare a meno.
eTonki.com - https://www.etonki.com/shop/
13th June 2018
Great plugin. Easy to install.
Great plugin. Easy to install.
Hans
12th June 2018
Great Plugin
Great plugin with the ability to extensively customise each feed. Easy to use for beginners using basic filtering tools mapped directly to your Magento environment, yet also has the capability for advanced customisation by directly entering into the xml script dialogue
John Fitzgerald - https://www.paulcostelloeman.co.uk/
7th June 2018
Great tool essential for maintaining large product feed
The feed manager is an essential tool if you want to manage large feeds for Google Shopping or simple. Products are changing constantly and trying to manually create and update a feed would be extremely time consuming. Feed Manager makes it all easy once its all setup you just let it run and keep your product feed in sync with your website.
Adam Sherratt - http://www.plumbingworld.co.uk
17th May 2018
A very flexible tool to create all kinds of feeds
This is the most flexible tool to create all kinds of feeds. All business customers require different layouts and fields, and we managed to create all of them. Especially the PHP options allow you to create all data combinations. Questions for support are answered within a working day.
Bart - https://www.ferm.com/
14th May 2018
Excellent Modules
This modules solves our feed request for Google, FB and affiliate networks. Wonderful plugin and great support.
Sid
8th May 2018
Simple to use and full of examples
Excellent extension to generate feeds for many marketplaces, the various templates already present help in an excellent way the creation of the desired feed. The syntax checking window is very useful for the preliminary verification of the feed you want to obtain.
Garnero - https://www.garneroarredamenti.com/
4th May 2018
GOOD TOOLD
An essential tool for ecommerce, one of the best on magento.
DIRECT CCTV SRL
26th April 2018
I recemmend it over any Google Shopping Feed extension
We have tried several different extensions for our Google Shopping Feed and this one is the best. Really like the live preview and error check.
Ammer Naber - http://www.booyadirect.com
23rd April 2018
Powerful extension but can break easily
Very customizable extension to generate almost any data feed you could want... however the version that was available when we purchased this extension was never able to perfectly generate a usable feed without a manual fix up of the files. For example on configurable products, many times the template asks for {{parent}}.{{anyAttribute}} except the feed would not get the data from the parent. Also some attributes would break feed generation with every new release or patch of Magento. Things that I am sure have gotten ironed out by now and probably were due to Magento bugs rather then bugs with this code. Going to give it another shot and see if I can get usable feeds automatically.
saminmontreal
18th April 2018
a very good extension
It works very well. It is great help when you need to make any complex feeds. It is important not to generate different feeds at the same time. This extension works very well with our store. Helpfull, undrestanding and fast support. Good team! Thank you!
Alex - http://abgastechnik-autoteile.de
10th April 2018
Critical extension for our store
We tried several other data feed modules before installing this one. The flexibility of this module is far better than the rest. We've never had to worry about it again.
Isaac - https://www.supplychimp.com
29th March 2018
Great extension for all
Very good extension, tried a few free ones but they all had issues so decided to buy this one and it was great. Had some technical issue but it was resolved in a couple of days. There are several similar extensions on the market, but WYOMIND created the best one. This is exactly what everyone needs to configure feeds. It allows to setup anything I can imagine for my store. Thanks for such a great extension!
Kate - https://ladyshop.ua
23rd March 2018
Versatile and meets all my needs so far
Great for setting up google shopping and also a great overal tool for many other things. Need a quick fresh Product database export? - Check. A developer recommended Wyomind to us and it was well worth the investment. Many thanks for their efforts and support.
12Game.com - https://www.12game.com
22nd March 2018
Data feed Manager is a great tool
Data feed manager is an excellent tool for an eCommerce manager that helps you set up your feeds with 0 knowledge of development, therefor saving a great amount of time. I totally recommend the use of it for every kind of e-shop!
kostantinos nt
20th March 2018
Google Shopping data made easy...
It took me hours to understand how to build a good feed for Google Shopping... and when I understood it, I realized it wasn't possible to build it easily... and having it updated regularly in the right way... I looked around and found many solutions... most of them looked promising, but a deeper investigation showed few of them were easy to set up... and even less of them were capable of handling data feeds for other engines. I already had positive experiences with Wyomind (WatchLogPro) so the choice was also quite easy. And I'm happy I did it ! I found a complete and detailed instruction set (actually a complete Google Shopping learning session !), which lead me quickly to a "set it and forget it" solution ! Thumbs up !
Michele - http://www.4shops.it
14th March 2018
Highly Customisable and versatile tool for people who want control
Excellent module. We were using this module for 3 years with google product and amazon. Initially hard to grasp as all complex things are but we very pleased to find it hadnt been dumbed down for stupid people. Id rather have to work to understand something than take it for granted. Unfortunately we couldnt afford to keep the channels going. However, we return now in full confidence that it gets the job done and well !
The Gin Box Shop - https://www.theginboxshop.co.uk
8th March 2018
An Essential Magento Tool for Highly Customizable Feeds
I’ve been using this extension since 2011 and it’s made our jobs so much easier. I would be hard pressed to find a such a feature rich and powerful feed builder that’s better than Wyomind’s Data Feed Manager. Most recently it has been a huge help in building magmi imports. But it’s also been a reliable tool for when we need to build repricer feeds for other selling channels, and shopping feeds for Google and BING.
Effi - http://www.sneakerdoctor.com/
7th March 2018
Perfect Solution
it is very good data feed solution. And it is powerfull with the good support. Thanks guys :)
Onur - http://www.karamela.com.tr
6th March 2018
Awesome solution
We use it to handle all our feeds - awesome tool to let none developers create and manage new feeds.
Martin - https://www.trendhim.dk/
2nd March 2018
On ne peut plus s'en passer
Cette extension est déjà complète à la base, mais la possibilité d'ajouter tous ses propres attributs et d'en créer via code php, c'est tout simplement fantastique! Cela nous permet de nous connecter à pratiquement n'importe quelle marketplace rapidement, de créer des flux, de trouver des soucis dans notre catalogue, et bien d'autres choses encore. Comme indiqué, on ne peut plus s'en passer et je me demande comment les autres font sans!
Bruno
2nd March 2018
Seamless and no problems
I've used this software since last year and my shopping feed has performed seamlessly and lawlessly. I'm not surprised it is recommended by developers to me. I did look around and look at other options. Reading about this one seemed to persuade me and then when I asked two different developers they said the same thing to me. It has been a great choice and I have been very very happy
Paul - http://www.photobooth-props.co.uk
27th February 2018
Order (with picture) - EN2
I like this extension. I there aren't any problem. If you're wondering whether to buy it, do it. You will be happy.
Sylwester - http://luminosfera.com.pl
25th February 2018
Good Choice - quick answers
Although my questions are quite basic I get answers very quickly, documentation is available with examples.
Georg - http://www.foeger.com
20th February 2018
An amazing tool for exporting Magento data
Using this tool has been essential for many operations on our websites, including providing dropshipping services, generating statistics, and many more. Once you get it, using the plugin is quite easy and intuitive - you can do everything with it. Thanks for the great module and support! Best product export tool on the market, hands down!!!
Elena - https://www.grabells.bg
20th February 2018
Disappointed on Required Support Contract
We purchased the plugin prior to starting our Magento 2 enterprise build as part of our developers requirements. Our development time is now approaching 12 months (much longer than we hoped but similar to any IT project). in retrospect, this was a big mistake not purchasing closer to the end of the website development cycle. After 6 months the support ends and if you are like us and plan on making upgrades to the versions during the development cycle, you will be stuck with a non-working plugin. This plugin initially worked when we were developing on 2.1.4, but stopped working after we upgraded from 2.1.4 on-ward. We are now being required to pay to be under a support contract in order to receive the updated version of the plugin for it to work. From what we remember when it worked, we think it's going to be a nice plugin to have. However, we were not expecting to have to pay support contracts just to keep it consistently working with version updates of Magento.
Tyler - http://www.SDBullion.com
8th February 2018
Excellente extension. Support ultra réactif.
Fait gagner pas mal de temps de temps par rapport au développement d'un export en ligne de commande. Très pratique pour le client final tout en gardant la possibilité d'utiliser des fonction php customs pour les cas particuliers. Très bonne extension.
Yann Charlou / Bulle Communication - https://bulle-communication.com/
2nd February 2018
Easy to Setup
This extension is very intuitive and allows you to create data feeds quickly. Simple tick boxes for most of the settings allow you to customise your feed's functionality, without demanding much technical expertise. Similarly, we have had some technical queries that were quickly resolved by their excellent support team. I would definitely recommend their product and service.
Gary - https://www.craftcompany.co.uk
31st January 2018
The best Datafeed Extension for Magento
This extension is essential if you want to create data feeds intuitively and quickly. It supports various functions, also to create datafeeds with particular fields. No Magento datafeed extension is complete like this. Support is realy fast! Thank you.
Massimino Maria Rosaria - http://www.kinnik.it
23rd January 2018
Create feeds with ease!
I've been using this extension for nearly a year - what previously seemed like a daunting task has been made so much easier being able to create multiple feeds for multiple marketplaces with ease, would definitely recommend. p.s. the datafeed manager allows for the production of feeds for a variety of marketplaces and not just limited to the ones they show, this tool offers the flexibility to create feeds and pull attributes through at the drop of a hat!
Sabina
19th January 2018
Great Datafeed extention
An excellent and easy way to manage and to export data. I have used others, so can compare and conclude that this is the one you want
Richard - https://www.felinaworld.com/nl/
18th January 2018
The best in his category
I am working at an online marketing company. We use Wyomind's data feed manager for a lot of our customers. It is a must have tool to export all product data for different feeds. Their support responds really fast and is always willing to help.
Lex - https://www.donargroenshop.nl/
18th January 2018
Must Have Tool
A real necessity for exporting live data. This extension has saved us considerable time and energy. It's much more than a just a data feed manager.
POLYP
16th January 2018
Great
Really good feed! Thanks