Depending on the integration in your brand/market, the DOP could be the source of truth for pricing & availability (P&A). When that’s the case, you’ll be able to benefit from the various capabilities DOP offers for P&A management. Please reach out to your CSM for any clarification.
These capabilities are are highlighted below.
The CSV Upload Capability
The CSV Upload capability 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 (e.g. 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 and storeGroupID columns can be added as an optional column:
Template CSV File:
Note that every upload overrides the pricing & availability set previously, and uploading multiple files simultaneously is not possible. This resuls in the first file uploaded for being dropped.
The Pricing & Availability Editor
The Pricing & Availability Editor enables the franchisees and restaurant managers to make changes seamlessly. It provides the ability to change P&A for multiple restaurants/restaurant groups, products, service modes and channels simultaneously.
Important Notes:
When a single restaurant is selected in the Editor, then the current pricing & availability settings/values for all items selected are displayed. When multiple restaurants are selected, then these settings are not displayed in the Editor because different restaurants can have different pricing & availability settings for same items.
Keep combo availability rules in mind:
A combo CANNOT be made AVAILABLE before its main item is AVAILABLE
A combo CANNOT be made AVAILABLE before at least one item in its comboslots are AVAILABLE
A combo CANNOT be made AVAILABLE if it has no price
The DOP only retrieves and lists published Sanity documents (item, combo, modifier, etc.). Unpublished documents are considered drafts and therefore not listed, and deleted Sanity documents are no longer listed as well. That's why it is essential to make pricing & availability changes before deleting Sanity documents. For example, if a menu item is AVAILABLE, deleting the Sanity document for it won't mark it as UNAVAILABLE - that action still needs to be done via the DOP Editor.
Migrate (Copy) Pricing & Availability Between Restaurants
This capability enables admin users within the Digital Operations Portal to migrate (copy) pricing & availability from one base restaurant into another restaurant.
The Process
Select the Base Restaurant
Once a restaurant is selected, users will be prompted with the bottom action bar. In this bar, they will have the option to migrate (copy) the restaurant data:
The feature Migrate(Copy) Restaurant Data will be available only when the user has 1 restaurant selected.
Choose the Restaurant to Receive the Data & Confirm
After selecting the base restaurant (Restaurant_A), users then need to choose the restaurant that will receive the pricing & availability data (Restaurant_B).
Afterwards, users need to confirm the action:
Important Notes
When pricing & availability is copied from Restaurant_A into Restaurant_B, it will override all the pricing & availability data for Restaurant_B.
If Restaurant_B includes pricing & availability for PLUs that don’t exist in Restaurant_A, those PLUs will keep their existing pricing & availability configurations.
If certain menu items are having late night pricing values in restaurant_A, then the pricing will also be configured for those menu items for restaurant_B after the migrate (copy) action. However, the store would need to have the lateNight pricing enabled, and the timeslots correctly configured in Sanity. The migrate (copy) action only covers the P&A, and not the restaurant configurations for late night in Sanity.
If certain menu items are having pricing & availability values in additional channels (e.g. UberEats), then the P&A will be configured for Restaurant_B for those chanels too after the migrate (copy) action. There won’t be a need for additional channel extension configuration.
The capability doesn’t involve migrating the content aspects of the menu.