CSV Pricing & Availability Upload Capability
- Yildirim, Semih
Pricing & Availability (P&A) management ensures the guests are only able to order menu items that are available, for the correct price configured by you.
For menu P&A, the source of truth is either the POS or the Digital Operations Portal (DOP) depending on the integration in your brand/market. This capability is useful when the DOP is the source of the truth.
The button Upload CSV opens a modal that allows users to make bulk P&A updates for several products and restaurants using a CSV file:
The following requirements should be fulfilled for the upload to be successful:
The name of file should follows the pattern: {brand}-{country}-{channel}-{identifier}.csv
eg. bk-de-delivery-1.csv
The file should be CSV (not XLSX)
All countries should be in ISO2 format (eg. PT, DE, ES etc.)
The values added under the price column should be specified in cents. For example, 9 Euro 50 cents should be entered as 950, not as 9.50 or 9,50.
Including an availability column to indicate if items are to be set available (1) or unavailable (0). Any item not included in the file will be left in the same status (available or unavailable) that it was.
Each file should have a single worksheet (as it is CSV), multiple worksheets cannot be added.
You need to have permissions for all the restaurants within the CSV file to make pricing & availability changes. If not, please make sure you have the right permissions assigned by a DOP admin using the User Management Module.
File format to be processed is shown below. Additionally, the lateNight.price column can be added as an optional column:
Template CSV File:
