Setting up Local Inventory Ads

This is your one-stop shop to get set up with Local Inventory Ads.
Important

Local Inventory Ads are currently available in Austria, Belgium, France, Germany, Italy, the Netherlands, Spain, Sweden, Switzerland, the United Kingdom and United States.

We'll show you how set up Local Inventory Ads, walking you through the steps you must take in order.

Need a refresher on Local Inventory Ads? Check out What are Local Inventory Ads?

You must import store location data from your Google My Business account to Microsoft Advertising. This is currently the only way to get your store location data set up Local Inventory Ads. You can set up an automated feed for your location data by linking your Microsoft Advertising account to your Google My Business account.

How do I connect my Google My Business account?expando image

Before you get started, here are a couple of things to keep in mind:

  • The automated feed can only be set up in the UI. The grid in the Shared Library > Business Data > Business location feed will only display location feed items that have been imported into Microsoft Advertising from Google My Business. If the location is deleted in Google My Business, it will be deleted in Microsoft Advertising as well.
  • Entries that were deleted in Microsoft Advertising will still be displayed. To see only the active business locations, you can filter the list to display All but removed.
  • Once the automated business data feed is set up, the data is refreshed every 24 hours.
  1. From the global menu, click Tools and then Business location feed.
  2. Click Choose import options and sign in to your Google My Business account.
  3. Select the account you want to import and click Continue.
  4. Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
  5. Click Import.
  1. Click Shared Library in the left navigation pane.
  2. Click Business Data and click Business location feed.
  3. Click Import and sign in to your Google My Business account.
  4. Select the account you want to import.
  5. Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
  6. Click Import.
What are the required Google My Business fields that I will need?expando image
  • Country code
  • Business name
  • Address line 1
  • City
  • Province name
  • State or province code
  • Postal code
  • StoreCode
  • Store hours
    • SundayHours
    • MondayHours
    • TuesdayHours
    • WednesdayHours
    • ThurdsayHours
    • FridayHours
    • SaturdayHours

Upload online products information: Upload online products feed through Microsoft Merchant Center. If you are already using Microsoft Shopping Campaigns, this step may not be required.

For Local Inventory Ads, you must create and submit a local products feed. A local products feed contains all the products that you sell in your stores with attributes describing the products.

How do I create a local products feed?

  1. Create a feed file that is tab-delimited plain text with the following extensions: .txt, .zip, .gz, .gzip, .tar.gz, .tgz. We only support .xml files if it is an existing Google-formatted .xml file.
  2. Include the following attributes in your local product inventory feeds.
Required attributesexpando image
Field name Description What you need to know
itemid A unique identifier for the item.

Example:
ISI1

Requirements:
50-character limit

  • ID must be unique for each item in your catalog.
  • If you are already using an online products feed, we recommend matching this value to the ID value in the online products feed.
  • If you have multiple feeds, IDs of items across different feeds still need to be unique.
  • Special ASCII characters (for example, asterisk (*), comma (,), backslash (\), ampersand (&), etc. are allowed.
title Title of the item

Example:
Women's shoes

Requirements:
Alphanumeric

150 character limit.

Don't enclose in quotes.

  • Use relevant titles that match with what users are searching for with key information first in the title (for example, Women’s over the knee boots).
  • When applicable, we recommend you include gender, size, color, material, and pattern details in title (for example, Women’s small red wool sweater).
  • Include characteristics like color to differentiate from other products.
  • Do not use all caps (for example, WOMEN’S SHOES).
  • Uploading an item for the first time will be pending review until the offer title has been successfully reviewed. Updating the offer title of an existing item will be reverted to the pending review status until it has been successfully reviewed again. The review process can take up to 3 business days.
  • The title of the item can be slightly different, but it must be for the same item.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title.
Recommended attributesexpando image
Field name Description What you need to know
description
(Required for local products if the data is not available in the online products feed)
Item description

Example:
Bright yellow 100% cotton dress shirt

Requirements:
Alphanumeric

10000 character limit.

No HTML code. Do not enclose in quotes.

  • The description from the landing page of your offer must be the same description as indicated in the feed.
  • We recommend that you include size, color, and pattern when applicable.
  • User relevant description with the most important data at the front.
  • Uploading an item for the first time will be pending review until the description has been successfully reviewed. Updating the description of an existing item will be reverted to the pending review status until it has been successfully reviewed. The review process can take up to 3 business days.
  • The description of the item can be slightly different, but it must be for the same item.
image_link
(Required for local products if the data is not available in the online products feed)
URL of an image of the item

Example:
http://www.bingshop.com/
images/ISI1.jpg

Requirements:
Alphanumeric

1000 character limit

Link must be HTTP or HTTPs only. Image must be: bmp, gif, exif, jpg, png, tiff and the recommended minimum size is 220px by 220px. The image size cannot exceed 3.9 MB.
No watermarks or free shipping text. Only one image per item.

  • Do not include any text within your images, including promotional messaging.
  • Use images with a white background for a “pop” effect.
  • Update robots.txt file to allow Microsoft Advertising to crawl your site. Your ad cannot be served if the crawling is incomplete. Learn more.
  • The image link URL is case-sensitive. Changing the casing on the URL will cause the URL to be re-crawled.
  • Uploading an item for the first time will be pending review until the image URL has been successfully crawled. Updating the image URL of an existing item will be reverted to the pending review status until it has been successfully re-crawled. The review process can take up to 3 business days.
condition Condition of item

Example:
new

Requirements:
Valid options: new; used; refurbished
Default is "new."

  • If no values are provided, the condition will be set to "new" by default.
  • 'New' products are brand new and have never been used, with the original packaging never opened.
  • 'Refurbished' products have been professionally restored, is free of defects, and comes with a warranty. It may or may not have the original packaging.
  • 'Used' products are anything other than 'new' or 'refurbished,' where the products have been used previously, with the original packaging opened or missing.
product_category Predefined product category (equivalent to google_product_category)

Example:
Software | Computer Software

Requirements:
Alphanumeric, 255 character limit, Delimiters: greater than symbol [>].
Only the greater than symbol > is a valid delimiter. Any other value is treated as invalid.
Full list of taxonomy values:

  • IDs, instead of string values, are now supported. View the updated taxonomy categories: Taxonomy and Taxonomy with IDs
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
Optional attributes expando image
Field name Description What you need to know
webitemid Alternative ID to match items between online products feed and local products feed. If you are unable to use the same value for itemid and id in your feeds, we recommend matching webitemid value in the local products feed with id value in the online products feed for the same item.
gtin
(Required for local products if the data is not available in the online products feed)
Global Trade Item Number. The GTIN field has a limit of 50 characters, with each GTIN value having up to 14 digits. For multiple GTIN values, separate by a comma and space.

Example:
00012345600012

Requirements:
Numeric, 14 digits max per value, multi-value, 50 character limit

brand
(Required for local products if the data is not available in the online products feed)
Item’s manufacturer, brand or publisher

Example:
Contoso

Requirements:
Alphanumeric

70 character limit

  • Do not add your store name as the brand unless you manufacture the product.
  • We recommend to keep the brand character limit to 70, but it can be up to 1000 characters.
  • Uploading an item for the first time will be pending review until the brand has been successfully crawled. Updating the brand of an existing item will be reverted to the pending review status until it has been successfully re-crawled. The review process can take up to 3 business days.
mpn
(Required for local products if the data is not available in the online products feed)
Manufacturer Part Number

Example:
ADNK-5020

Requirements:
Alphanumeric, 70 character limit

  • MPN should be specific to one unique product.
  • MPNs are assigned by the manufacturer.
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:
FALSE

Requirements:
Boolean: TRUE or FALSE

Products that may not have an identifier_exists attribute include custom goods, like homemade products, or products that were made before gtins were created, like antiques.
price Base price, excluding tax and shipping, submitted in local currency.

Example:
23.99

Requirements:
Numeric

0.00 to 10000000.00 (10 million)

Use two decimal places and no symbols (e.g. $).

  • The price from the landing page of your offer must be the same price as indicated in the feed.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price Items’s sale price, excluding tax and shipping

Example:
20.99

Requirements:
Numeric; Range is 0.00 to 10000000.00 (10 million); No symbols ($)

  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price_effective_date Sale’s start and end date and time

Example:
2013-11-05T08:15-05:00/2013-11-10T09:30-05:00

Requirements:
Alphanumeric; Start date must be earlier than end date.
Date and time format: YYYY-MM-DD followed by the letter 'T', the time of day followed by an expression for the time zone as defined by the ISO 8601 standard.

  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • The end date needs to be in the same format.
  • For items on sale, submit both the sale price and sale effective date attributes. If you update the sale price attribute but not the sale price effective date, the sale price will continue to be used for your item.
pick up method Pick-up options available for the store.
Example:
reserve
Requirements:
buy, reserve, and not supported
  • buy: The purchase occurs online.
  • reserve: The item is reserved online but purchased in-store.
  • not supported: The item is available only online and not for store pick-up.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
pick up sla The expected date that an item is available for pick-up.
Example:
same day
Requirements:
same day, next day
  • same day: The item is available for pick-up the same day it was ordered.
  • next day: The item is available for pick-up the day after it was ordered.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
Apparel item attributesexpando image

For apparel items, be sure to include the additional attributes if they are not provided in the online products feed.

Field name Description What you need to know
gender Gender targeted by the item

Example:
male

Requirements:
Valid options: male, female, unisex. No other option will be accepted.

We recommend including gender in the title for products where it's a distinguishing attribute.
age_group Age group targeted by the item

Example:
newborn

Requirements:
Valid Options: newborn, infant, toddler, kid, adult

color The dominant color of the item

Example:
red/black/white

Requirements:
Text: Character limit 100

Supports up to 3 values separated by a slash [/] with most dominant color first.

Color attributes, like "stainless steel" or "mahogany" are also accepted.

We recommend adding the dominant color in the title.
size Size of the item

Example:
small, medium, large

Requirements:
Alphanumeric, Max 100 characters

  • Indicate size values based on your target country.
  • Use consistent size values for the same items. (e.g., “small”, “medium”, and “large” and not “small,” “M,” and “Lg”).

How do I submit local product feeds?

Once you created your local products feed, you must submit your product information through Microsoft Merchant Center.

  1. From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
  2. From the page menu, click Feeds.
  3. Click Create feed.
  4. Enter the Feed information. Enter the Feed name, select the Location, and select Local product or Local product inventoryfrom the Feed type.
  5. Select the Input Method. You can manually upload, upload via FTP, automatically download from a URL, or import your feed file.
  6. Click Create feed.
  1. On the top menu, click Tools and then click Microsoft Merchant Center
  2. Click the store name and then the Feed management tab.
  3. Click Create feed.
  4. Enter the Feed name, select Local product feed from Feed type, and select the Location.
  5. Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
  6. Click Save.

After creating a local products feed, you need to create a local products inventory feed for your Local Inventory Ads. The local products inventory feed is needed for the list of products that you sell in each store specifically.

What is the difference between local product inventory and local product inventory update feeds?

Because your inventory price and quantity change frequently by store, you can use local product inventory update feeds for up-to-date information of your local inventory ads.

When submitting via FTP:

  • Local product inventory feeds include all of your inventory for all of your stores. You can submit the feed on a daily basis.
  • Local product inventory update feeds are used only for frequently changing details like the price and quantity of your items in specific stores.

How do I create a local products inventory feed?

  1. Create a feed file that is tab-delimited plain text with the following extensions: .txt, .zip, .gz, .gzip, .tar.gz, .tgz. We only support .xml files if it is an existing Google-formatted .xml file.
  2. Include the following attributes in your local product inventory feeds.
Required attributesexpando image
Field name Description What you need to know
store code A unique code for the item.

Example:
1234

Requirements:
Alphanumeric

  • Code must be unique for each store.
itemid A unique identifier for the item.

Example:
ISI1

Requirements:
50-character limit

  • ID must be unique for each item in your catalog.
  • If you have multiple feeds, IDs of items across different feeds still need to be unique.
  • Special ASCII characters (for example, asterisk (*), comma (,), backslash (\), ampersand (&), etc. are allowed.
quantity The number of items available in stock.

Example:
20

Requirements:
Numeric value

  • if an item is temporarily out of stock, include "0".
Optional attributes expando image
Field name Description What you need to know
price Base price, excluding tax and shipping, submitted in local currency.

Example:
23.99

Requirements:
Numeric

0.00 to 10000000.00 (10 million)

Use two decimal places and no symbols (e.g. $).

  • The price from the landing page of your offer must be the same price as indicated in the feed.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price Item’s sale price, excluding tax and shipping

Example:
20.99

Requirements:
Numeric; Range is 0.00 to 10000000.00 (10 million); No symbols ($)

  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price_effective_date Sale’s start and end date and time

Example:
2013-11-05T08:15-05:00/2013-11-10T09:30-05:00

Requirements:
Alphanumeric; Start date must be earlier than end date.
Date and time format: YYYY-MM-DD followed by the letter 'T', the time of day followed by an expression for the time zone as defined by the ISO 8601 standard.

  • The end date needs to be in the same format.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For items on sale, submit both the sale price and sale effective date attributes. If you update the sale price attribute but not the sale price effective date, the sale price will continue to be used for your item.
availability Availability of item

Example:
in stock
out of stock
preorder

Requirements:
Valid options: in stock, out of stock, preorder.

Default is "in stock."

  • If no values are provided, the availability will be set to "in stock" by default.
  • Uploading an item for the first time will be pending review until the availability has been successfully reviewed. Updating the availability of an existing item will be reverted to the pending review status until it has been processed again. The update can take up to 6 hours to process.
  • “in stock” products are available for sale and the advertiser is accepting and fulfilling orders.
  • “out of stock” products are either unavailable or the advertiser wants to exclude these products from being served temporarily.
  • “preorder” products haven’t been released yet but advertiser will accept orders and ship at the availability date.
  • Mapping details:
    in stock: InStock, LimitedAvailability
    out of stock: Discontinued, OutOfStock, SoldOut
    preorder: PreOrder, PreSale
weeks of supply The estimate of how many weeks of inventory you have.
Example:
3.5
  • Divide the quanitiy of the items available by the average of weekly items sold.
pick up method Pick-up options available for the store.
Example:
reserve
Requirements:
buy, reserve, and not supported
  • buy: The purchase occurs online.
  • reserve: The item is reserved online but purchased in-store.
  • not supported: The item is available only online and not for store pick-up.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
pick up sla The expected date that an item is available for pick-up.
Example:
same day
Requirements:
same day, next day
  • same day: The item is available for pick-up the same day it was ordered.
  • next day: The item is available for pick-up the day after it was ordered.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.

How do I submit local product feeds?

Once you created your local products feed, you must submit your product information through Microsoft Merchant Center.

  1. From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
  2. From the page menu, click Feeds.
  3. Click Create feed.
  4. Enter the Feed information. Enter the Feed name, select the Location, and select Local product or Local product inventoryfrom the Feed type.
  5. Select the Input Method. You can manually upload, upload via FTP, automatically download from a URL, or import your feed file.
  6. Click Create feed.
  1. On the top menu, click Tools and then click Microsoft Merchant Center
  2. Click the store name and then the Feed management tab.
  3. Click Create feed.
  4. Enter the Feed name, select Local product feed from Feed type, and select the Location.
  5. Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
  6. Click Save.

After you sign in to your Microsoft Advertising account:

  1. Go to the Campaigns page.
  2. Select the shopping campaign you want to use for Local Inventory Ads.
  3. Click on the Settings tab.
  4. Under Shopping settings, check the Enable local inventory ads box.
  5. Click Save.

Channel and channel exclusivity

Now that local inventory ads are enabled for your shopping campaign, you can set filters by channel and channel exclusivity.

  • Channel:
    Local store: Automatically filter to products that are sold in local stores, including products that may also be sold online.
    Online: Filter products that are only sold on your website.
  • Channel exclusivity:
    Multi-channel: Filter products that are sold both online and in store.
    Single channel: Filter products that are sold only in store or online.

You can show products sold only in local stores but not online by setting the filters to “Channel”: “Local stores” and “Channel exclusivity”: “Single-channel”.

1. Provide store location dataexpando image

You must import store location data from you Google My Business account to Microsoft Advertising. This is currently the only way to get your store location data set up Local Inventory Ads. You can set up an automated feed for your location data by linking your Microsoft Advertising account to your Google My Business account.

How do I connect my Google My Business account?expando image

Before you get started, here are a few things to keep in mind:

  • The automated feed can only be set up in the UI. The grid in the Shared Library > Business Data > Business location feed will only display location feed items that have been imported into Microsoft Advertising from Google My Business. If the location is deleted in Google My Business, it will be deleted in Microsoft Advertising as well.
  • Entries that were deleted in Microsoft Advertising will still be displayed. To see only the active business locations, you can filter the list to display All but removed.
  • Once the automated business data feed is set up, the data is refreshed every 24 hours.
  1. From the global menu, click Tools and then Business location feed.
  2. Click Choose import options and sign in to your Google My Business account.
  3. Select the account you want to import and click Continue.
  4. Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
  5. Click Import.
  1. Click Shared Library in the left navigation pane.
  2. Click Business Data and click Business location feed.
  3. Click Import and sign in to your Google My Business account.
  4. Select the account you want to import.
  5. Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
  6. Click Import.
What are the required Google My Business fields that I will need?expando image
  • Country code
  • Business name
  • Address line 1
  • City
  • Province name
  • State or province code
  • Postal code
  • StoreCode
  • Store hours
    • SundayHours
    • MondayHours
    • TuesdayHours
    • WednesdayHours
    • ThurdsayHours
    • FridayHours
    • SaturdayHours
2. Upload online products informationexpando image

Upload online products information: Upload online products feed through Microsoft Merchant Center. If you are already using Microsoft Shopping Campaigns, this step may not be required.

3. Submit local products informationexpando image

For Local Inventory Ads, you must create and submit a local products feed. A local products feed contains all the products that you sell in your stores with attributes describing the products.

How do I create a local products feed?

  1. Create a feed file that is tab-delimited plain text with the following extensions: .txt, .zip, .gz, .gzip, .tar.gz, .tgz. We only support .xml files if it is an existing Google-formatted .xml file.
  2. Include the following attributes in your local product inventory feeds.
Required attributesexpando image
Field name Description What you need to know
itemid A unique identifier for the item.

Example:
ISI1

Requirements:
50-character limit

  • ID must be unique for each item in your catalog.
  • If you are already using an online products feed, we recommend matching this value to the ID value in the online products feed.
  • If you have multiple feeds, IDs of items across different feeds still need to be unique.
  • Special ASCII characters (for example, asterisk (*), comma (,), backslash (\), ampersand (&), etc. are allowed.
title Title of the item

Example:
Women's shoes

Requirements:
Alphanumeric

150 character limit.

Don't enclose in quotes.

  • Use relevant titles that match with what users are searching for with key information first in the title (for example, Women’s over the knee boots).
  • When applicable, we recommend you include gender, size, color, material, and pattern details in title (for example, Women’s small red wool sweater).
  • Include characteristics like color to differentiate from other products.
  • Do not use all caps (for example, WOMEN’S SHOES).
  • Uploading an item for the first time will be pending review until the offer title has been successfully reviewed. Updating the offer title of an existing item will be reverted to the pending review status until it has been successfully reviewed again. The review process can take up to 3 business days.
  • The title of the item can be slightly different, but it must be for the same item.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title.
Recommended attributesexpando image
Field name Description What you need to know
description
(Required for local products if the data is not available in the online products feed)
Item description

Example:
Bright yellow 100% cotton dress shirt

Requirements:
Alphanumeric

10000 character limit.

No HTML code. Do not enclose in quotes.

  • The description from the landing page of your offer must be the same description as indicated in the feed.
  • We recommend that you include size, color, and pattern when applicable.
  • User relevant description with the most important data at the front.
  • Uploading an item for the first time will be pending review until the description has been successfully reviewed. Updating the description of an existing item will be reverted to the pending review status until it has been successfully reviewed. The review process can take up to 3 business days.
  • The description of the item can be slightly different, but it must be for the same item.
image_link
(Required for local products if the data is not available in the online products feed)
URL of an image of the item

Example:
http://www.bingshop.com/
images/ISI1.jpg

Requirements:
Alphanumeric

1000 character limit

Link must be HTTP or HTTPs only. Image must be: bmp, gif, exif, jpg, png, tiff and the recommended minimum size is 220px by 220px. The image size cannot exceed 3.9 MB.
No watermarks or free shipping text. Only one image per item.

  • Do not include any text within your images, including promotional messaging.
  • Use images with a white background for a “pop” effect.
  • Update robots.txt file to allow Microsoft Advertising to crawl your site. Your ad cannot be served if the crawling is incomplete. Learn more.
  • The image link URL is case-sensitive. Changing the casing on the URL will cause the URL to be re-crawled.
  • Uploading an item for the first time will be pending review until the image URL has been successfully crawled. Updating the image URL of an existing item will be reverted to the pending review status until it has been successfully re-crawled. The review process can take up to 3 business days.
condition Condition of item

Example:
new

Requirements:
Valid options: new; used; refurbished
Default is "new."

  • If no values are provided, the condition will be set to "new" by default.
  • 'New' products are brand new and have never been used, with the original packaging never opened.
  • 'Refurbished' products have been professionally restored, is free of defects, and comes with a warranty. It may or may not have the original packaging.
  • 'Used' products are anything other than 'new' or 'refurbished,' where the products have been used previously, with the original packaging opened or missing.
product_category Predefined product category (equivalent to google_product_category)

Example:
Software | Computer Software

Requirements:
Alphanumeric, 255 character limit
Delimiters: greater than symbol [>].
Only the greater than symbol > is a valid delimiter. Any other value is treated as invalid.
Full list of taxonomy values:

  • IDs, instead of string values, are now supported. View the updated taxonomy categories: Taxonomy and Taxonomy with IDs
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
Optional attributes expando image
Field name Description What you need to know
webitemid Alternative ID to match items between online products feed and local products feed. If you are unable to use the same value for itemid and id in your feeds, we recommend matching webitemid value in the local products feed with id value in the online products feed for the same item.
gtin
(Required for local products if the data is not available in the online products feed)
Global Trade Item Number. The GTIN field has a limit of 50 characters, with each GTIN value having up to 14 digits. For multiple GTIN values, separate by a comma and space.

Example:
00012345600012s

Requirements:
Numeric, 14 digits max per value, multi-value, 50 character limit

brand
(Required for local products if the data is not available in the online products feed)
Item’s manufacturer, brand or publisher

Example:
Contoso

Requirements:
Alphanumeric

70 character limit

  • Do not add your store name as the brand unless you manufacture the product.
  • We recommend to keep the brand character limit to 70, but it can be up to 1000 characters.
  • Uploading an item for the first time will be pending review until the brand has been successfully crawled. Updating the brand of an existing item will be reverted to the pending review status until it has been successfully re-crawled. The review process can take up to 3 business days.
mpn
(Required for local products if the data is not available in the online products feed)
Manufacturer Part Number

Example:
ADNK-5020

Requirements:
Alphanumeric, 70 character limit

  • MPN should be specific to one unique product.
  • MPNs are assigned by the manufacturer.
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:
FALSE

Requirements:
Boolean: TRUE or FALSE

Products that may not have an identifier_exists attribute include custom goods, like homemade products, or products that were made before gtins were created, like antiques.
price Base price, excluding tax and shipping, submitted in local currency.

Example:
23.99

Requirements:
Numeric

0.00 to 10000000.00 (10 million)

Use two decimal places and no symbols (e.g. $).

  • The price from the landing page of your offer must be the same price as indicated in the feed.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price Items’s sale price, excluding tax and shipping

Example:
20.99

Requirements:
Numeric; Range is 0.00 to 10000000.00 (10 million); No symbols ($)

  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price_effective_date Sale’s start and end date and time

Example:
2013-11-05T08:15-05:00/2013-11-10T09:30-05:00

Requirements:
Alphanumeric; Start date must be earlier than end date.
Date and time format: YYYY-MM-DD followed by the letter 'T', the time of day followed by an expression for the time zone as defined by the ISO 8601 standard.

  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • The end date needs to be in the same format.
  • For items on sale, submit both the sale price and sale effective date attributes. If you update the sale price attribute but not the sale price effective date, the sale price will continue to be used for your item.
pick up method Pick-up options available for the store.
Example:
reserve
Requirements:
buy, reserve, and not supported
  • buy: The purchase occurs online.
  • reserve: The item is reserved online but purchased in-store.
  • not supported: The item is available only online and not for store pick-up.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
pick up sla The expected date that an item is available for pick-up.
Example:
same day
Requirements:
same day, next day
  • same day: The item is available for pick-up the same day it was ordered.
  • next day: The item is available for pick-up the day after it was ordered.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
Apparel item attributesexpando image

For apparel items, be sure to include the additional attributes if they are not provided in the online products feed.

Field name Description What you need to know
gender Gender targeted by the item

Example:
male

Requirements:
Valid options: male, female, unisex. No other option will be accepted.

We recommend including gender in the title for products where it's a distinguishing attribute.
age_group Age group targeted by the item

Example:
newborn

Requirements:
Valid Options: newborn, infant, toddler, kid, adult

color The dominant color of the item

Example:
red/black/white

Requirements:
Text: Character limit 100

Supports up to 3 values separated by a slash [/] with most dominant color first.

Color attributes, like "stainless steel" or "mahogany" are also accepted.

We recommend adding the dominant color in the title.
size Size of the item

Example:
small, medium, large

Requirements:
Alphanumeric, Max 100 characters

  • Indicate size values based on your target country.
  • Use consistent size values for the same items. (e.g., “small”, “medium”, and “large” and not “small,” “M,” and “Lg”).

How do I submit local product feeds

Once you created your local products feed, you must submit your product information through Microsoft Merchant Center.

  1. From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
  2. From the page menu, click Feeds.
  3. Click Create feed.
  4. Enter the Feed information. Enter the Feed name, select the Location, and select Local product from the Feed type.
  5. Select the Input Method. You can manually upload, upload via FTP, automatically download from a URL, or import your feed file.
  6. Click Create feed.
  1. On the top menu, click Tools and then click Microsoft Merchant Center
  2. Click the store name and then the Feed management tab.
  3. Click Create feed.
  4. Enter the Feed name, select Local product feed from Feed type, and select the Location.
  5. Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
  6. Click Save.
4. Upload inventory informationexpando image

After creating a local products feed, you need to create a local products inventory feed for your Local Inventory Ads. The local products inventory feed is needed for the list of products that you sell in each store specifically.

What is the difference between local product inventory and local product inventory update feeds?

Because your inventory price and quantity change frequently by store, you can use local product inventory update feeds for up-to-date information of your local inventory ads.

When submitting via FTP:

  • Local product inventory feeds include all of your inventory for all of your stores. You can submit the feed on a daily basis.
  • Local product inventory update feeds are used only for frequently changing details like the price and quantity of your items in specific stores.

How do I create a local products inventory feed?

  1. Create a feed file that is tab-delimited plain text with the following extensions: .txt, .zip, .gz, .gzip, .tar.gz, .tgz. We only support .xml files if it is an existing Google-formatted .xml file.
  2. Include the following attributes in your local product inventory feeds.
Required attributesexpando image
Field name Description What you need to know
store code A unique code for the item.

Example:
1234

Requirements:
Alphanumeric

  • Code must be unique for each store.
itemid A unique identifier for the item.

Example:
ISI1

Requirements:
50-character limit

  • ID must be unique for each item in your catalog.
  • If you have multiple feeds, IDs of items across different feeds still need to be unique.
  • Special ASCII characters (for example, asterisk (*), comma (,), backslash (\), ampersand (&), etc. are allowed.
quantity The number of items available in stock.

Example:
20

Requirements:
Numeric value

  • if an item is temporarily out of stock, include "0".
Optional attributes expando image
Field name Description What you need to know
price Base price, excluding tax and shipping, submitted in local currency.

Example:
23.99

Requirements:
Numeric

0.00 to 10000000.00 (10 million)

Use two decimal places and no symbols (e.g. $).

  • The price from the landing page of your offer must be the same price as indicated in the feed.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price Item’s sale price, excluding tax and shipping

Example:
20.99

Requirements:
Numeric; Range is 0.00 to 10000000.00 (10 million); No symbols ($)

  • For the US, exclude tax in the price. For the UK, include any value added tax (VAT) in the price. See Microsoft Merchant Center catalog tax policy for more details.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • Uploading an item for the first time will be pending review until the price has been successfully reviewed. Updating the price of an existing item will be reverted to the pending review status until it has been processed again. The pricing update can take up to 6 hours to process.
  • For mobile devices or tablets, the price can be 0, as the subsidized price with a contract is allowed. For such items, you must include the phrase "only with contract" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
  • For mobile devices or tablets, the price can be 0 when payment options with multiple installments are allowed (US only). For such items, you must include the phrase "with installment plan" (or similar) in the title with the product_category value of "Electronics > Communications > Telephony > Mobile Phones" (267) for mobile devices or "Electronics > Computers > Tablet Computers" (4745) for tablets.
sale_price_effective_date Sale’s start and end date and time

Example:
2013-11-05T08:15-05:00/2013-11-10T09:30-05:00

Requirements:
Alphanumeric; Start date must be earlier than end date.
Date and time format: YYYY-MM-DD followed by the letter 'T', the time of day followed by an expression for the time zone as defined by the ISO 8601 standard.

  • The end date needs to be in the same format.
  • The store-level values in the inventory feed will override the national level values from the local products feed.
  • For items on sale, submit both the sale price and sale effective date attributes. If you update the sale price attribute but not the sale price effective date, the sale price will continue to be used for your item.
availability Availability of item

Example:
in stock
out of stock
preorder

Requirements:
Valid options: in stock, out of stock, preorder.

Default is "in stock."

  • If no values are provided, the availability will be set to "in stock" by default.
  • Uploading an item for the first time will be pending review until the availability has been successfully reviewed. Updating the availability of an existing item will be reverted to the pending review status until it has been processed again. The update can take up to 6 hours to process.
  • “in stock” products are available for sale and the advertiser is accepting and fulfilling orders.
  • “out of stock” products are either unavailable or the advertiser wants to exclude these products from being served temporarily.
  • “preorder” products haven’t been released yet but advertiser will accept orders and ship at the availability date.
  • Mapping details:
    in stock: InStock, LimitedAvailability
    out of stock: Discontinued, OutOfStock, SoldOut
    preorder: PreOrder, PreSale
weeks of supply The estimate of how many weeks of inventory you have.
Example:
3.5
  • Divide the quanitiy of the items available by the average of weekly items sold.
pick up method Pick-up options available for the store.
Example:
reserve
Requirements:
buy, reserve, and not supported
  • buy: The purchase occurs online.
  • reserve: The item is reserved online but purchased in-store.
  • not supported: The item is available only online and not for store pick-up.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.
pick up sla The expected date that an item is available for pick-up.
Example:
same day
Requirements:
same day, next day
  • same day: The item is available for pick-up the same day it was ordered.
  • next day: The item is available for pick-up the day after it was ordered.
  • Can either be at the local feed level or the inventory feed level.
  • The store level values in the inventory feed will override the national level values from the local products feed.

How do I submit local product feeds?

Once you created your local products feed, you must submit your product information through Microsoft Merchant Center.

  1. From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
  2. From the page menu, click Feeds.
  3. Click Create feed.
  4. Enter the Feed information. Enter the Feed name, select the Location, and select Local product from the Feed type.
  5. Select the Input Method. You can manually upload, upload via FTP, automatically download from a URL, or import your feed file.
  6. Click Create feed.
  1. On the top menu, click Tools and then click Microsoft Merchant Center
  2. Click the store name and then the Feed management tab.
  3. Click Create feed.
  4. Enter the Feed name, select Local product feed from Feed type, and select the Location.
  5. Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
  6. Click Save.
5. Enable shopping campaigns into Local Inventory Adsexpando image

After you sign in to your Microsoft Advertising account:

  1. Go to the Campaigns page.
  2. Select the shopping campaign you want to use for Local Inventory Ads.
  3. Click on the Settings tab.
  4. Under Shopping settings, check the Enable local inventory ads box.
  5. Click Save.

Channel and channel exclusivity

Now that local inventory ads are enabled for your shopping campaign, you can set filters by channel and channel exclusivity.

  • Channel:
    Local store: Automatically filter to products that are sold in local stores, including products that may also be sold online.
    Online: Filter products that are only sold on your website.
  • Channel exclusivity:
    Multi-channel: Filter products that are sold both online and in store.
    Single channel: Filter products that are sold only in store or online.

You can show products sold only in local stores but not online by setting the filters to “Channel”: “Local stores” and “Channel exclusivity”: “Single-channel”.

See more videos...