For product attributes that you update frequently, like price, availability, sale price, and sale price effective date, you can easily make updates using online product inventory update feeds. While you will still need to submit your full product feed at least once every 30 days, you can use the update feed for the specific attributes that are already in your full product feed: price, availability, sale price, and sale price effective date.
There are two different feed types you can use to upload your product data. The first is the main product feed file for your product data for Microsoft Merchant Center, which should be submitted at least every 30 days. Any time you upload a new product feed file, it overwrites the previous uploads.
On the other hand, you want to use the online product inventory update feed when you want to update only price, availability, sale price, and sale price effective date that’s already been submitted in your main product feed file. This means:
The online product inventory update feed can be uploaded manually through the update feed tab or via FTP/SFTP. Once the feed has been processed, the report will be available in the update feed tab on the top banner. See how to upload the online product inventory update feed below.
You can use this option if the feed file is smaller than 1GB. This is the recommended option if the feed file is larger than 4MB.
FTP/SFTP server requirements
The recommended FTP/SFTP upload mechanism is via an FTP/SFTP program. It is however possible to do so via the command line or custom scripts (such as Python’s ftplib.FTP module). The FileZilla FTP/SFTP client is recommended for all platforms.
Use the following settings for file transfer with your FTP/SFTP client:
Learn more about FTP/SFTP upload.
The feed contains five attributes, as detailed below.
|Attribute||What it is||Required in txt header row?||Can value be blank?|
|'id'||The ID of the product that will be updated. The ID must match the ID provided in the full product feed file.||Yes||No|
The price submitted here overrides the price from the last submission of the product feed file. If price is submitted, the value cannot be blank. No changes will be made if the value is blank and you’ll receive the following error message: |
Offer cannot be updated as price cannot be blank. Please add a valid price value.
The availability submitted here overrides the availability from the last submission of the product feed file. If availability is submitted, the value cannot be blank. No changes will be made if the value is blank and you’ll receive the following error message: |
Offer cannot be updated as availability cannot be blank. Please add a valid availability value.
|'sale price' and 'sale price effective date'||The sale price and sale price effective date submitted here overrides what was last submitted from the product feed file. If blank values are submitted, it will void the previous sale details submitted from the last product feed file.||No||Yes|
You can use this option if the feed file is smaller than 4MB.
Once the feed has been processed, the report will be available in the update feed tab on the top banner.
|Offer2||Out of stock|
Here are the symbols/special characters and what attribute they are accepted in.
|Symbols||Where you can use|
|Period [.]||Prices, URLs|
|Hyphen [-]||Offer Identifiers where this is valid (eg: ISBN, MPN)|
|Multi-value fields (MerchantCategory, B_Category, ads_label)|
|Any Unicode symbol||Brand, Title, Description|