Versions Compared

Version Old Version 16 New Version Current
Changes made by

Yildirim, Semih

Rohit Gande

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

image-20240315-130008-20240720-170621.png

Panel
bgColor#FFFAE6

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-deliverywhitelabel-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 column and storeGroupIDcolumns can be added as an optional column:

...

Once the file upload process has been started, the rows are grouped together by storeId and updates are posted to the stores/restaurants with a batch size of 10. The batch size is configurable.

If there are any failures, one toast message is displayed on the screen for each batch, with the storeId of the failed update. If there are no failures then, no toast messages are displayed.

Once the CSV has been fully processed and uploaded, all the successful and failed updates are displayed as a log in a modal.

...

Tip

Template CSV File:

View file
nameBK-DE-whitelabel-1920.06.2024.csv

Info

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.

...