How do I create local product inventory feeds?

Learn about creating the local product inventory feed, which is needed for the list of products that you sell in each store specifically for your Local Inventory Ads.
Note

Learn more about where Local inventory ads are available.

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

Availability

We are working with retailers who have physical stores in the United Kingdom and United States.

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 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 six 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 six 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?expando image

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

  1. From the top menu, select Tools > Merchant Center > Feeds.

    If you're using the new Microsoft Advertising navigation, from the navigation menu on the left, select Tools > Merchant Center > Feeds.

  2. Select Create feed.
  3. Enter the Feed name and then select the Feed type. You can select from three different feed types: local product inventory, local product inventory update, and local product feed.
  4. Select the Country of sale.
  5. Select the Language.
  6. Select the Input method and then enter the feed input method details. You can opt to Automatically download file from URL, upload file using FTP/SFTP, or manually upload file.
  7. Select Save.

See more videos...