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 Australia, 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.

From the global menu, click Tools and then Business location feed.
Click Choose import options and sign in to your Google My Business account.
Select the account you want to import and click Continue.
Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
Click Import.

Click Shared Library in the left navigation pane.
Click Business Data and click Business location feed.
Click Import and sign in to your Google My Business account.
Select the account you want to import.
Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
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
- ThursdayHours
- 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?

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.
Include the following attributes in your local product inventory feeds.

Required attributes expando 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.

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 attributes expando 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: All languages Example feed file	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 10 word 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. The maximum word limit is 10. 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 feed 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 feed 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 attributes expando 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.

From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
From the page menu, click Feeds.
Click Create feed.
Enter the Feed information. Enter the Feed name, select the Location, and select Local product or Local product inventoryfrom the Feed type.
Select the Input Method. You can manually upload, upload via FTP, or automatically download from a URL.
Click Create feed.

On the top menu, click Tools and then click Microsoft Merchant Center
Click the store name and then the Feed management tab.
Click Create feed.
Enter the Feed name, select Local product feed from Feed type, and select the Location.
Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
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?

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.
Include the following attributes in your local product inventory feeds.

Required attributes expando 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 (whole number, no decimals)	if an item is temporarily out of stock, include "0".

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 (whole number, no decimals)

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 feed 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 feed 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.

From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
From the page menu, click Feeds.
Click Create feed.
Enter the Feed information. Enter the Feed name, select the Location, and select Local product or Local product inventoryfrom the Feed type.
Select the Input Method. You can manually upload, upload via FTP, or automatically download from a URL.
Click Create feed.

On the top menu, click Tools and then click Microsoft Merchant Center
Click the store name and then the Feed management tab.
Click Create feed.
Enter the Feed name, select Local product feed from Feed type, and select the Location.
Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
Click Save.

After you sign in to your Microsoft Advertising account:

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

Click types

Now that local inventory ads are enabled for your shopping campaign, you can set filters by click types.

Shopping ad: A click on your ad, showing an online product.
Shopping ad - local: A click on your ad, showing a local product.
Shopping ad – multichannel local: A click on the local section of your ad that has two links—one click to the local product and another click to the online product.
Shopping ad – multichannel online: A click on the in-store decoration will result in the multichannel local click reporting. A click on the main ad with the in-store decoration will result in the multichannel online click.

You can show products sold only in local stores but not online by setting the filters to “Click type”: “Shopping ad - Local”

1. Provide store location data expando 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.

From the global menu, click Tools and then Business location feed.
Click Choose import options and sign in to your Google My Business account.
Select the account you want to import and click Continue.
Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
Click Import.

Click Shared Library in the left navigation pane.
Click Business Data and click Business location feed.
Click Import and sign in to your Google My Business account.
Select the account you want to import.
Optional: Filter import details. When you add a filter, only locations that meet the conditions will be imported to Microsoft Advertising.
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
- ThursdayHours
- FridayHours
- SaturdayHours

2. Upload online products information expando 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 information expando 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?

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.
Include the following attributes in your local product inventory feeds.

Required attributes expando 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.

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 attributes expando 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: All languages Example feed file	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 10 word 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. The maximum word limit is 10. 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 feed 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 feed 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 attributes expando 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.

From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
From the page menu, click Feeds.
Click Create feed.
Enter the Feed information. Enter the Feed name, select the Location, and select Local product from the Feed type.
Select the Input Method. You can manually upload, upload via FTP, or automatically download from a URL.
Click Create feed.

On the top menu, click Tools and then click Microsoft Merchant Center
Click the store name and then the Feed management tab.
Click Create feed.
Enter the Feed name, select Local product feed from Feed type, and select the Location.
Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
Click Save.

4. Upload inventory information expando image

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?

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.
Include the following attributes in your local product inventory feeds.

Required attributes expando 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 (whole number, no decimals)	if an item is temporarily out of stock, include "0".

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 (whole number, no decimals)

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 feed 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 feed 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.

From the global menu at the top of the page, click Tools and then Microsoft Merchant Center.
From the page menu, click Feeds.
Click Create feed.
Enter the Feed information. Enter the Feed name, select the Location, and select Local product from the Feed type.
Select the Input Method. You can manually upload, upload via FTP, or automatically download from a URL.
Click Create feed.

On the top menu, click Tools and then click Microsoft Merchant Center
Click the store name and then the Feed management tab.
Click Create feed.
Enter the Feed name, select Local product feed from Feed type, and select the Location.
Enter the Feed input method details. You can opt to Automatically download file from URL, upload file using FTP, or manually upload file.
Click Save.

5. Enable shopping campaigns into Local Inventory Ads expando image

After you sign in to your Microsoft Advertising account:

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

Click types

Now that local inventory ads are enabled for your shopping campaign, you can set filters by click types.

Shopping ad: A click on your ad, showing an online product.
Shopping ad - local: A click on your ad, showing a local product.
Shopping ad – multichannel local: A click on the local section of your ad that has two links—one click to the local product and another click to the online product.
Shopping ad – multichannel online: A click on the in-store decoration will result in the multichannel local click reporting. A click on the main ad with the in-store decoration will result in the multichannel online click.

You can show products sold only in local stores but not online by setting the filters to “Click type”: “Shopping ad - Local”