Data Feed Manager
Create csv, txt and xml data feeds for any search engine, shopping engine or market place ! This extension includes all Simple Google Shopping features and 17 pre-configured templates.
License from
€80
Orders Export Tool
The 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
How to configure your templates in order to generate any valid XML files ?
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 includes several default configurations that allow you to build a valid and well-structured data feed quickly. In these default configurations, you will find some ready-to-use XML templates. Data Feed Manager also includes several demo configurations that include a ready-to-use template for Google Shopping.
Basically an XML data feed is created using an opening and closing tag that includes a value.
<tag>value</tag>
For each product you are exporting, you need to choose which tag to use. There is a tag for each attribute .
<g:id>123456</g:id> <g:price>45.99 USD</g:price> <title>Nokia Phone n251</title>
When you are building your XML template in Simple Google Shopping or Data Feed Manager, you must include between every opening and closing tag a Magento attribute or a fixed value. An attribute is specified by its code name
and must be enclosed using brackets as shown.
<g:id>{sku}</g:id>
<g:price>{price}</g:price>
<title>{name}</title>
The syntactic coloration in Data Feed Manager will help you to avoid any errors in your template.
How to use product atttributes inside of your XML template ?
When you are building your XML template in Simple Google Shopping or Data Feed Manager, you must include between every opening and closing tag a Magento attribute or a fixed value.
All the default Magento attributes and also all your own attributes can only be retrieved in this way. Please refer to the Basic attributes section to learn more.
Some Magento attributes like price, image or url may have further configuration options that will correspond to your specific data feed needs. Please refer to the Specials attributes section to learn more.
Some Magic attributes are unique to the Google Shopping data feeds. These attributes act as shortcuts to create complete portions of XML in your data feed. For example:
{G:PRODUCT_TYPE}
How to generate CSV/TXT files with Data Feed Manager?
Data Feed Manager allows you to generate CSV/TXT files besides XML files.
This particular kind of file format is required by few shopping engines like Amazon, Shopzilla, Twenga, etc.
A CSV or TXT file contains data displayed in this simple way:
- There is one row per record (so, one per product)
- Data are separated by a special characters ( ' ; ',' , ', or tab by example).
Here is an example of CSV file content:
Each shopping engine has his own requirements and column names. Some require fields enclosure (" or '), others need specific delimiters (; or | or tab).
You may also need to add a special header to your file (for Amazon Data Feeds by example).
Data Feed Manager provides you all you need to create any specific CSV/TXT files you want.
To create a CSV/TXT datafeed, you just have to choose 'csv' or 'txt' in File type , in the Configuration tab of your template.
Extra header is here to fit in with Amazon requirements. It will add whatever you put in on the top of your CSV/TXT file.
Include header allows you to include or not columns'name in the first row of your CSV/TXT file.
Columns name is for the attribute name (you need to look in the shopping engine specification to know which names are required).
Pattern works in the same way than in XML files. For example, {url} will return the product's url. You can also add any static values.
For example, instead of {url} , you can use {url}?_campaign=google&_adwords=test123 .
Like in XML files, 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.
You can add a field by using the button Add field . The fields order can be easily reordered by using up and down arrows.
Field 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.
Preview lets you check if your CSV/TXT file is correct by displaying data in a table:
Go further by adding PHP scripts inside your templates
It's possible to add PHP scripts to your XML template. These scripts must be included between an opening and closing PHP tag (<? ... ?>). The value you want to display must be retrieved by using the ‘return’
instruction. You can also use a ‘product instance object’ (registered as $product variable) in order to use its specific methods.
For example, you may want to check the quantity of all items of 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> ";
?>
All incorrectly written scripts will be ignored.
Data Feed Manager extension also allows to create your own options and attributes in the following files:
- app/code/local/wyomind/datafeedmanager/myCustomOptions.php
- app/code/local/wyomind/datafeedmanager/myCustomAttributes.php
Some examples of use are given in the above files.
The created options and attributes can then be used in your data feed configuration as any other attributes and options.
{my_custom_attribute,[my_custom_option_1],[my_custom_option_2]} Basic attributes & basic options
{attribute,[option1],[option2],[option3],[...]}
All options are executed in the order written eg :
<title>{name}</title>
<title>{name,[htmlentities],[strtolower]}</title>
<title>{name,[htmlentities],[strtolower],[ucwords]}</title>
<title>NOKIA© 2610 Phone</title> <title>nokia© 2610 phone</title> <title>Nokia© 2610 Phone</title>
{attribute_code,[substr],[arg1],[arg2]}
- arg1 : maximum length of the value
- arg2 : string that will be added at the end of the string. By default [...]
{attribute_code,[implode],[arg1]}
Joins all array elements in a string
- arg1 : string used between each value. By default a coma (,)
Maybe useful for multi-select attributes like color :
{color,[implode],[,]}
gives eg : black, blue, red, green
{attribute_code,[float],[arg1]}
Converts a numeric value to a floating number
- arg1 : number of floating number. By default [0]
{attribute_code,[php_function]}
Use any PHP function that does not require an argument (ucfirst, ucwords,...).
{price}
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.
- arg1 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.
- arg2 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.
To completly remove the VAT from all prices, you can use [0]
Example : {price,[EUR],[20.0]} will apply a 20% VAT rate.
Example : {price,[USD],[0]} will converts the price from EUR to USD and will not apply any VAT rate.
/!\ : from Simple Google Shopping >= 5.1.0, and Data Feed Manager >= 3.0.0
arg2 may be an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax setting. This code may also be completed by an area code, eg : {price,[USD],[US/NY]} or {price,[EUR],[FR]}.
You can also deduce the VAT corresponding to a country/area by using this syntax : {price,[USD],[-US/NY]}
{normal_price}
Retrieves the price and ignores any existing special price value.
{normal_price,[arg1],[arg2]}
- arg1 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.
- arg2 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.
To completly remove the VAT from all prices, you can use [0]
Example : {price,[EUR],[20.0]} will apply a 20% VAT rate.
Example : {price,[USD],[0]} will converts the price from EUR to USD and will not apply any VAT rate.
/!\ : from Simple Google Shopping >= 5.1.0, and Data Feed Manager >= 3.0.0
arg2 may be an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax setting. This code may also be completed by an area code, eg : {price,[USD],[US/NY]} or {price,[EUR],[FR]}.
You can also deduce the VAT corresponding to a country/area by using this syntax : {price,[USD],[-US/NY]}
{special_price}
{sepcial_price,[arg1],[arg2]}
- arg1 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.
- arg2 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.
To completly remove the VAT from all prices, you can use [0]
Example : {price,[EUR],[20.0]} will apply a 20% VAT rate.
Example : {price,[USD],[0]} will converts the price from EUR to USD and will not apply any VAT rate.
/!\ : from Simple Google Shopping >= 5.1.0, and Data Feed Manager >= 3.0.0
arg2 may be an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax setting. This code may also be completed by an area code, eg : {price,[USD],[US/NY]} or {price,[EUR],[FR]}.
You can also deduce the VAT corresponding to a country/area by using this syntax : {price,[USD],[-US/NY]}
{price_rules}
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.
- arg1 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.
- arg2 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.
To completly remove the VAT from all prices, you can use [0]
Example : {price,[EUR],[20.0]} will apply a 20% VAT rate.
Example : {price,[USD],[0]} will converts the price from EUR to USD and will not apply any VAT rate.
arg2 may be an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax setting. This code may also be completed by an area code, eg : {price,[USD],[US/NY]} or {price,[EUR],[FR]}.
You can also deduce the VAT corresponding to a country/area by using this syntax : {price,[USD],[-US/NY]}
{is_special_price}
{is_special_price?[arg1]:[arg2]}
- arg1 value to retrieves if a special price exists. By default 1.
- arg1 value to retrieves if no special price exists. By default 0.
{min_price}, {max_price}
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.
- arg1 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.
- arg2 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.
To completly remove the VAT from all prices, you can use [0]
Example : {price,[EUR],[20.0]} will apply a 20% VAT rate.
Example : {price,[USD],[0]} will converts the price from EUR to USD and will not apply any VAT rate.
arg2 may be an ISO2 code corresponding to one of the countries for which you specified a VAT rate in your tax setting. This code may also be completed by an area code, eg : {price,[USD],[US/NY]} or {price,[EUR],[FR]}.
You can also deduce the VAT corresponding to a country/area by using this syntax : {price,[USD],[-US/NY]}
{image}
- arg1 index of any additional images to retrieve. By default 0 (the main image).
{uri} or {url_key}
<url>http://www.mywebsite.com/mystore_code/{uri}</url> {is_in_stock}
- arg1 value to retrieve if the product is in stock
- arg2 value to retrieve if the product is out of stock
{categories}
{categories,[arg1],[arg2],[arg3]}
- arg1 number of lists to retrieve. By default infinity.
- arg2 level from which to start. By default 1 (root catalog).
- arg3 number of categories in each list.
{review_count}
{review_count,[arg1]}
- arg1 id of one your store views. If not specified the current store view is used.
"*" will count all reviews for all store views
{review_average}
Retrieves the average score of all the evaluations that your customers have left for the product.
{review_average,[arg1],[arg2]}
- arg1 the base number. By default 5.
- arg2 d of your store views. If not specified the current store view is used.
"*" will count all reviews for all store views.
{category_mapping}
Retrieves any new category that you have assigned (in the filter section / category 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,[arg1]}
- arg1 index of the category mapping, eg :
<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.
/!\ from Simple Google Shopping >= 5.0.0 and Data Feed Manager >= 3.0.0
Special Attributes (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>http://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>http://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}
{G:SALE_PRICE}
<g:sale_price>{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}
{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>
... {G:PRODUCT_REVIEW}
<g:product_review_average>{review_average}</g:product_review_average>
<g:product_review_count>{review_count}</g:product_review_count>
{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>
Options : see {categories}
{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 matche to your categories :
http://www.google.com/support/merchants/bin/answer.py?answer=160081
Options : see {category_mapping}
/!\ from Simple Google Shopping >= 5.0.0 and Data Feed Manager >= 3.0.0
Parent Attributes
/!\ From Simple Google Shopping v4.8.1 and Data Feed Manager v2.6.1
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 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.
{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 configurable, grouped or a bundle product. The first parent product that matches the simple
product is used to get the attribute value.
How to configure my template with Shopping.com?
Data Feed Manager allows you to create datafeed in destination of Shopping.com.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at these 2 links which will be helpfull:
Shopping.com's taxonomy
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 usefull 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 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 commas 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 datafeed in destination of Bing Shopping.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at these 2 links which will be helpfull:
Bing Shopping Integration Guide
Bing Shopping Feed Example
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 (page 32 of Bing Shopping Integration Guide) to match your product to Bing’s standardized structure. Remember to use category mapping in Data Feed Manager to fill-in this attribute correctly |
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 datafeed, but only 5 must contain data. Others are highly recommended by Shopzilla.
WARNING: these 15 attributes must respect this order:
- 1. Category ID
- 2. Manufacturer
- 3. Title
- 4. Description
- 5. Product URL
- 6. Image URL
- 7. SKU
- 8. Availability
- 9. Condition
- 10. Ship Weight
- 11. Ship Cost
- 12. Bid
- 13. Promotional Code
- 14. UPC
- 15. 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 http:// (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 |
How to configure my template with Amazon?
Data Feed Manager allows you to create datafeed in destination of Amazon.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at this link which will be helpfull:
Amazon Browse Tree Guide (BTG) (Amazon'specifications)
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 to Amazon to identify which 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 thise 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.
Informations groups with Amazon
Amazon distincts different informations 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 groupes, there are specific groups depending of your products'categories.
Here are specifcs 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.
By example, if you're saling furnitures, 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 datafeed.
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 {{extension}} 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 http:// |
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 http://. |
| 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 datafeed in destination of Price Grabber.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at these 2 links which will be helpfull:
Price Grabber Integration Guide
Price Grabber's taxonomy
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.
By example, Home & Personal Products requires 9 attributes, where Tech Products & Software only requires 7 attributes (not the sames as well).
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 http:// (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 manufacture'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. |
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 required attributes with 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 http://, 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 datafeed in destination of Twenga.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at this link which will be helpfull:
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 datafeed 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 proudct (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'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 datafeed in destination of Idealo.
Here are some tips which will be usefull to create your datafeed.
First, we recommand you to look at these 2 links which will be helpfull:
Idealo's technical informations
Idealo'sample CSV file
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 infos are 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 use 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 names.
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 refernce |
| 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 recommended attributes 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;http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://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);http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://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);http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://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;http://www.idealo.fr/exemple;http://www.idealo.fr/exemple-exemple.jpg;0,1;
What's the difference beetwen Simple Google Shopping and Data Feed Manager ?
Data Feed Manager includes all the features of Simple Google Shopping but allows you to create more data feeds (csv, txt, xml) for any shopping engine, market place or search engine.
Which countries are supported by Data Feed Manager Extension?
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.
Does Data Feed Manager support multi-currency rates?
Yes. You can use different values in price attributes in order to convert currencies.
Which version of magento is supported by Data Feed Manager?
Data Feed Manager extension is compatible with Magento versions : 1.2.x, 1.3.X, 1.4.X, 1.5.X, 1.6.X, 1.7.x This extension also works with Magento Enterprise Edition and Magento Professional Edition.
If I want to test an extension first on a staging server, do I have to buy 2 licenses for 2 domains ?
No, you just need to contact us once you are ready to switch to your production server.
How many products may be exported at once in a data feed File ?
Data Feed Manager extension 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.
Does Data Feed Manager work with Magento compiler?
You can use a Magento compiler with Data Feed Manager.
Just be careful to disable it before installing Data Feed Manager and re-enable it when Data Feed Manager is installed.
What is the char 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.
Some products are not showing up in one of my data feeds, but they do in other ones
This issue must 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 equivalent
- inline : Remove all unneeded spaces
- cleaner : Remove all non utf8 chars
How does the category mapping work?
What is category mapping?
Categories names you are using in your Magento aren't always the same that ones used by Google Merchant to reference your products.
This means you have to find out which Google Merchant categories have the best matching with yours, according to the Google product taxonomy .
By example, if your are selling furnitures like coffee tables , you'll have a coffee table category in your Magento.
But Google Merchant doesn't handle this kind of category. The closest Google product category could be Kitchen & Dining Room Table .
So this should appears this way in your data feed:
<g:google_product_category>Furniture > Desks & Tables > Kitchen & Dining Room Tables</g:google_product_category>
This Google product category should be in your data feed, using this attribute:
<g:google_product_category>closest_google_category_name</g:google_product_category>
Please note that this attribute is different from product type where you can use your own category names.
Google recommend you include this attribute for all products, and for all target-countries. It will result in better categorization for your products.
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 improve your data quality and in turn ensures 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 being submitted. For instance, if you are submitting MP3 player chargers use the category MP3 Player Chargers. Conversely, if you are submitting multiple types of chargers use the category Chargers.
How to map my categories with Data Feed Manager?
Data Feed Manager provides you an easy way to input Google product categories matching yours.
In your data feed configuration, go in the Categories tab. Then, in Category selection and mapping section, you'll find a treeview of all your categories.
For each category, you have a little arrow and mapped as . This is the place where you have to paste the Google product category matching to your category.
Tip : if your press 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 the Save button.
How to schedule my data feed generation with Data Feed Manager?
Data Feed Manager provides you a fully configurable schedule in the Scheduled task tab of your template configuration for each data feed.
Warning : in order this to work, you must have one main scheduled task running from your server side and targeting cron.php (or cron.sh) - located in the root directory of magento - 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 a cron job reporting, so you can get email reports on each data feed you will generate.
How to avoid enabled child products to show up in the feed 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 you data feed.
To save you from the annoying task of disabling each child product, you can do this :
First, you have to enable this option :
System > Configuration > Wyomind > Data Feed Manager > Core Setting > Include disabled products
Then, you have to add the following script in your data feed configuration :
<? {status,[isset]} ?>
<?if($this->checkReference("parent",$product)->getStatus()==2) $myPattern=null;?>
In your data feed filter section add :
Status | = | enabled (or 1 if the dropdown doesn't display)
How do filters work?
Data Feed Manager provides you 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.
By example ( Case 1 ), 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.
But if you only want ( Case 2 ) 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.
In our 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.
If you're in the 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 like wildcard.
By example, this will return only products whose name contains 'rock and roll' (like 'rock and roll pants', 'rock and roll shirt', etc):
[Name] [Like] [rock and roll]
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.
How to exclude some specific products in Data Feed Manager?
Sometimes, advances filters from Filters’section aren’t enough to generate you data feed in the way you want it to be.
By 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 Shoes category in the Categories section, you’ll miss all uncategorized products.
In that kind of case, you’ll have to use a small code in your template wich will exclude Shoes category.
Warning : It will only work if you untick all categories in Categories section.
<?if("{category_mapping}"=="Shoes") $myPattern=null;?>
(if category is Shoes then skip the product).
In a general notation :
<?if("{attribute_code}"=="value") $myPattern=null;?>How to limit the number of products exported ?
You can limit the number of exported products (eg : 500) in your data feed by adding the following script in the product pattern:
<? $this->_limit=500 ?>
How to remove VAT from prices in my data feeds?
You just need to use {price,[CUR],[0]} instead of {price} in your template.
Replace CUR by the currency you need (USD for US dollars, EUR for euros, etc)
How to apply a custom VAT on my products?
You can use {price,[X.XX]} instead of {price} in your template. X.XX is a floating number between 0.00 and 100.00 representing the percentage you want to apply to the price.
How to improve my datafeed generation process?
If you have a huge number of products in your Magento (10 000+), it may occur that your datafeed generation either took too much time, either returned you an error.
This issue is usually due to the URL rewriting system.
In order to improve this process, you can try to run the following request in your database :
DELETE FROM `core_url_rewrite` WHERE `core_url_rewrite`.`options` = 'RP';
or you can completely re-initialize the whole url rewrite process in 2 steps :
1. Empty the table named core_url_rewrite in Magento database by using this syntax:
TRUNCATE core_url_rewrite
2. Reindex your URLs in your Magento admin (System>Index Management)
I have just made a payment for Data Feed Manager but I haven't received an email
1. The payment confirmation email should only take a few minutes, rarely more than one hour
2. Check your spam filter
3. Contact us: we will try again to send it
How do I activate the Wyomind Data Feed Manager extension ?
Just copy and paste the code you will retrieve in your Wyomind Manager into: system/configuration/wyomind/extension name in your admin panel and choose an activation method between Automatic (Yes) and Manual (No) .
Automatic (Yes) : you authorize a remote connection to Wyomind's license server
Manuel (No) : you connect by browsing to Wyomind's license server
Once you have put in your activation key and chosen your activation method, go to the extension page in the admin menu (catalog/Data Feed Manager) and follow the instructions.
How do I install Data Feed Manager ?
- Download the zipped extension from your Wyomind account ;
- Unzip the folder content ;
- Copy the folder content (app,skin and lib directories)
- Paste all files and directories into your Magento web site root directory ;
- Log-out from Magento admin panel ;
- Log-in to your Magento admin panel and clean the cache ;
- Installation complete.
How do I uninstall Data Feed Manager?
In order to uninstall Data Feed Manager, you must remove all the following files and directories:
- app/etc/modules/Wyomind_Data Feed Manager.xml
- app/code/local/WyomindData Feed Manager
- design/adminhtml/default/default/layout/Data Feed Manager.xml
- design/adminhtml/default/default/template/Data Feed Manager
- skin/adminhtml/default/default/Data Feed Manager
- app/locale/lang_LANG/Wyomind_Data Feed Manager.csv
Clean the cache and re-launch the compiler (if you use it).
I'm getting an error saying "Base table or view not found". How do I fix this?
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 (cPanel for example)
- - Delete the entry Data Feed Manager_setup from the table core_resource
- - Logout from your Magento admin
- - Log into your Magento admin
I get a 404 error instead of the configuration page in admin panel!
I get a 404 error instead of the extension page in admin panel!
For Simple Google Shopping :
DELETE FROM simplegoogleshopping
For Data Feed Manager
DELETE FROM datafeedmanager
I get a 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.
How do I fix the issues with scheduled tasks?
Be sure that you have correctly configured a scheduled task from the server side (cpanel) targeting the cron.php file in your magento installation.
Data Feed Manager includes reporting and debug tools for the scheduled tasks in:
system > configuration > Wyomind > Data Feed Manager
Characters from my data feed aren't displayed properly.
First, be sure you used 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 (with Display > Encoding type > utf8 selected).
The link for my data feed, in Data Feed Manager, is black (instead of orange). What does it mean?
I get a fatal error concerning 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 /home/users/silkaftp/silkandbeach.com/includes/src/Mage_Core_Model_Resource_Setup.php on line 234
It probably comes from installing an extension while the compiler is still enabled.
Important note:
• If the compilation is enabled on your website (System > Tools > Compilation). Disable it first before installing any extension. 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 the way 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.
- ✔16 preconfigured templates : Google Shopping, Le Guide, Twenga, Kelkoo,Shopping.com, BingShopping, Shopzilla, Price Grabber, Nextag, Amazon Ads, Ebay, Bestlist,...
- ✔Ability to create any data feed type : csv, txt and xml for any shopping engine
- ✔Export of all product types (simple, configurable, grouped, bundle... and custom types)
- ✔Data feed customization with any Magento attributes
- ✔Product and category filtering (exclusion/inclusion)
- ✔NEW ! FTP upload feature
- ✔Category mapping
- ✔Data feeds automatic update and task reporting
- ✔Data feeds preview and syntactic helper
- ✔Multi-stores, multi-currencies, multi-VAT-rates data feeds
- ✔Open library to create your own attributes and options
- ✔Time life free support 7/7
Support or enquiries
by email 7/7
answer under 24h