Your feed file is a text delimited file that has a different product item on each line. You create the text delimited file and then submit it to Microsoft Merchant Center.
You can find the rules for creating the feed file at How do I create a feed file? If you're using Google feed files, make it even easier to import by using the Google Merchant Center import tool. Learn more
Here are the required and optional fields you can include in the catalog feed:
Field name | Description | What you need to know |
---|---|---|
id |
A unique identifier for the item.
Example: Requirements: |
|
title |
Title of the item
Example: Requirements: |
|
link |
Direct URL of the item's page on your website
Example: Requirements: |
|
price |
Base price, excluding tax and shipping, submitted in local currency.
Example: Requirements: |
|
description |
Item description
Example: Requirements: |
|
image_link |
URL of an image of the item
Example: Requirements: |
|
shipping |
Cost of shipping, submitted in local currency. This is a required field for Austria and Germany only. Shipping has multiple subfields and can have the following headers:
12.99 Requirements: |
|
Field name | Description | What you need to know |
---|---|---|
mpn |
Manufacturer Part Number
Example: Requirements: |
|
gtin |
Global Trade Item Number.
Up to 10 GTIN values can be provided, with a maximum of 14 digits per value. For multiple GTIN values, separate by a comma and space. Example: Requirements: |
Learn more about unique identifiers for your product ads. |
brand |
Item’s manufacturer, brand or publisher
Example: Requirements: |
|
identifier_exists (required for new products only when gtin and brand, or mpn and brand isn't available) |
Used to indicate that unique product identifiers (gtin, brand, and mpn) aren't available for a product.
Example: |
|
Field name | Description | What you need to know |
---|---|---|
gender |
Gender targeted by the item
Example: Requirements: |
|
age_group |
Age group targeted by the item
Example: Requirements: |
|
color |
The dominant color of the item
Example: Requirements: |
|
size |
Size of the item
Example: Requirements: |
|
size_type |
Size type of the item
Example: Requirements: |
size_type is recommended when the size attribute is provided. |
size_system |
Size system of the item
Requirements: Single value
|
|
Field name | Description | What you need to know |
---|---|---|
item_group_id |
Used to group items that may vary by color, material, pattern, size, age_group, or gender
Example: Requirements: |
|
material |
The material of the item
Example: Requirements: |
Values may be displayed, so we recommend you use values that users can understand. |
pattern |
The pattern or graphic print of the item
Example: Requirements: |
Values may be displayed, so we recommend you use values that users can understand. |
additional_image_link |
The URLs of additional images
Example: Requirements: |
Values may be displayed, so we recommend you use values that users can understand.
Can have up to 10 images, separated by a comma (,) delimiter. "%2C" value in the image URL should be considered as (,) and part of the image URL link (e.g., 2 image URLs that contain commas will look like: http://www.contoso.com/image2%2C3.jpg,http:// contoso.com/image2%2C4.jpg). |
Field name | Description | What you need to know |
---|---|---|
adult |
Microsoft Advertising does not support adult products.
Example: Requirements: |
Any adult products submitted in the feed will be rejected. |
availability |
Availability of item
Example: Requirements: |
|
product_category |
Predefined product category (equivalent to google_product_category)
Example: Requirements: |
|
condition |
Condition of item
Example: Requirements: |
|
expiration_date |
The date the item will expire
Example: Requirements: |
If the expiration date isn't provided, items will expire after 30 days. |
multipack |
Used when bundling multiple identical items into a single unit
Example: Requirements: |
When setting the price, it must be the total price of the multipack. |
product_type |
Your category of the item
Example: Requirements: |
You can have more than one product type if your item applies to more than one category. |
mobile_link |
Mobile landing page URL
Example: Requirements: |
Link should point to the specific product instead of your store’s home page. |
unit_pricing_measure |
The measure and dimension of product as it is sold.
Example: Requirements:
|
|
unit_pricing_base_measure |
The product’s base measure for pricing (e.g., 100ml means the price is calculated based on a 100ml unit).
Example: Requirements:
|
|
installment |
The monthly installment plan for a product, displayed by the number of months
Example: Requirements: |
|
energy_efficiency_class max_energy_efficiency_class min_energy_efficiency_class (EU and CH only. May be required by local laws or regulations.) |
The product's energy label
Example: Requirements:
|
|
Field name | Description | What you need to know |
---|---|---|
seller_name |
Merchant/Store that provides this item
Example: Requirements: |
|
ads_redirect |
Redirect URL that overrides the URL given in the "link" attribute. Ensure that this URL will redirect to the same URL as given in the "link" or "mobile_link" attribute.
Example: Requirements: |
|
custom_label_0 custom_label_1 custom_label_2 custom_label_3 custom_label_4 |
Use to identify products for ad campaign filters
Example: Requirements: |
Use custom labels to add a value to the label, such as seasonal or sale items. |
Field name | Description | What you need to know |
---|---|---|
sale_price |
Items’s sale price, excluding tax and shipping
Example: Requirements: |
|
sale_price_effective_date |
Sale’s start and end date and time
Example: Requirements: |
|
promotion_ID |
Used to group items by promotion
Requirements: |
|