Your feed file is a tab delimited text file that has a different product item on each line. You create the 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 for your feed file:
Field name | Description | What you need to know |
---|---|---|
description |
Item description
Example: Requirements: |
|
id |
A unique identifier for the item.
Example: Requirements: |
|
image_link |
URL of an image 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: |
|
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: |
|
title |
Title of the item
Example: Requirements: |
|
Field name | Description | What you need to know |
---|---|---|
brand |
Item’s manufacturer, brand or publisher
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. |
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: |
|
mpn |
Manufacturer Part Number
Example: Requirements: |
|
Field name | Description | What you need to know |
---|---|---|
age_group |
Age group targeted by the item
Example: Requirements: |
|
color |
The dominant color of the item
Example: Requirements: |
|
gender |
Gender targeted by the item
Example: Requirements: |
|
size |
Size of the item
Example: Requirements: |
|
size_system |
Size system of the item
Requirements: Single value
|
|
size_type |
Size type of the item
Example: Requirements: |
size_type is recommended when the size attribute is provided. |
Field name | Description | What you need to know |
---|---|---|
additional_image_link |
The URLs of additional images
Example: Requirements: |
|
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. |
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: |
|
condition |
Condition of item
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:
|
|
excluded_destination |
The destination where you don't want your products to appear.
Example: Requirements: |
This is how you control where each individual product in your primary feed appears:
|
expiration_date |
The date the item will expire
Example: Requirements: |
If the expiration date isn't provided, items will expire after 30 days. |
included_destination |
The destination where you want your products to appear.
Example: Requirements: |
This is how you control where each individual product in your primary feed appears:
|
installment |
The monthly installment plan for a product, displayed by the number of months
Example: Requirements: |
|
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_category |
Predefined product category (equivalent to google_product_category)
Example: Requirements: |
|
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. |
shopping_ads_excluded_country |
String, 2 characters. Must be an ISO-3166-1 Alpha 2 country code. Multiple, comma separated values. Can have up to 100 country codes. |
Use this when you want to exclude countries you don't want to serve your products in. This should be used in conjunction with the additional country feed setting. |
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:
|
|
unit_pricing_measure |
The measure and dimension of product as it is sold.
Example: Requirements:
|
|
Field name | Description | What you need to know |
---|---|---|
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" 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. |
seller_name |
Merchant/Store that provides this item
Example: Requirements: |
|
Field name | Description | What you need to know |
---|---|---|
promotion_ID |
Used to group items by promotion
Requirements: |
|
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: |
|