In order to update the restaurant information in MDM we will need to submit 2 documents to GBS - please use the documents below as a template (you will have to replace the information):
| View file | ||
|---|---|---|
|
| View file | ||
|---|---|---|
|
How to submit request to GBS
Tag the PM in your project + Sudesh Bhakhar sbhakhar@rbi.com + GBSRequest@rbi.com
Add in the Subject Line - O2C FCM upload restaurant information “Brand + Country” Prod
Example: O2C FCM upload restaurant information - BK Germany Prod
As body of the text please write the following
Hi Team,
Hope you are doing good, I would like to open a ticket to upload the two files attached in this email to MDM Prod
Thanks!
Attach files to the email
After this GBS will open a ticket that will need to be resolved in 72 hrs, if this is not the case please talk to your PM. ( We are working to reduce the time in this)
How to fill out the documents
Hours:
Set up one live for each day a week for each restaurant and add the appropriate information for that daya following the headers
Example:
...
/id
...
/restaurant
...
/dayOfWeek
...
/diningRoom/drTimeOpen
...
/diningRoom/drTimeClose
...
1
...
966
...
1 - Sunday
...
12:00
...
20:00
...
2
...
966
...
2 - Monday
...
12:00
...
20:00
Restaurant information
You will add one line per restaurant and add all the information relevant to that restaurant
Foreach of the amenities mark as true or false except when there are multiple options
Drink Station you will need to add the following ids depending on what is available
Playground you will need to add the following ids depending on what is available
...
/id
...
/restaurant
...
/country
...
/ServicesGroup/doesServeBreakfast
...
/restaurantDetails/drinkStationType
...
/ServicesGroup/hasDriveThru
...
/posGroup/restaurantPOSVendor
...
/ServicesGroup/acceptCreditCard
...
/ServicesGroup/PaybackAvailable
...
/ServicesGroup/Coupons/PaperCouponsAvailable
...
/ServicesGroup/Coupons/DigitalCouponsAvailable
...
/ServicesGroup/Discounts/KingOfTheMonth
...
1
...
966
...
53
...
FALSE
...
4
...
FALSE
...
4
...
TRUE
...
TRUE
...
TRUE
...
TRUE
...
TRUE
...
2
...
4801
...
53
...
FALSE
...
3
...
TRUE
...
4
...
TRUE
...
TRUE
...
TRUE
...
TRUE
...
TRUE
...
3
...
3456
...
53
...
FALSE
...
4
...
TRUE
...
4
...
TRUE
...
TRUE
...
TRUE
...
TRUE
...
| Table of Contents |
|---|
As explained in the Restaurant document, restaurant documents and its information is fed to Sanity via a sync with MDM. This means that our platform will get the existing restaurant information from MDM and load it into Sanity. Therefore, to update restaurant information, changes need to be done at the source – in MDM.
There’s two way to update information in MDM – via RAM or via GBS request. Let’s have a look at both.
Updating information via RAM
| Info |
|---|
RAM allows franchisees to directly edit the restaurant information stored in MDM. |
Using the Restaurant Attributes Management tool https://ram.rbi.com/ , you will be able to see and edit certain attributes of your restaurants.
Some of the attributes that can be changed in RAM are:
Service Mode
Hours of Operation information
POS vendor
Mobile Ordering
Mobile Ordering Status
In summary, to edit a restaurant’s attributes in RAM:
Look up for the restaurant using the search bar. You can filter by different attributes (store id, country…)
Click on the view 👁️ button on the restaurant card
Once you’re on the restaurant view, click on the edit ✏️ icon on the top right of the page. You’ll be able to change the fields that are surfaced in RAM
Detailed guides on how to use RAM can be found here: RAM
| Note |
|---|
Note that not all restaurant attributes can be edited via RAM. In the case you’d like to edit an attribute not available in RAM, you’ll need to open a GBS request as described in the following section |
Updating information via GBS Request
| Info |
|---|
The GBS team can manually perform changes in MDM. |
You can also updated restaurant attributed by sending a request to the GBS team.
For simple changes to one restaurant, you can send an email to gbsrequest@rbi.com explaining the required change. Use the following template:
Subject: "O2C-DMT - Update Restaurant Attributes"
Hello DMT team,
Please update the follow Restaurant attributes in MDS:
[ ]
Thanks!
For multiple changes to one restaurant, please use the following excel template, which you can attach to your email to the GBS team.
Subject: "O2C-DMT - Update Restaurant Attributes (Minor Upload)"
Attachment: SIF_5.2.1 Update Restaurant attributes (Minor Upload).xlsm
Hello DMT team,
Please find the attached form to update Restaurant attributes to MDS
Thanks!
| View file | ||
|---|---|---|
|
For changes to multiple restaurants, please use the following excel template, which you can attach to your email to the GBS team.
Subject: "O2C-DMT - Update Restaurant Attributes (Major Upload)"
Attachment: SIF_5.2.1 Update Restaurant attributes (Major Upload).xlsm
Hello DMT team,
Please find the attached form to update Restaurant attributes to MDS
Thanks!
| View file | ||
|---|---|---|
|
| Expand | ||
|---|---|---|
| ||
If an error statement is showing on the excel file, preventing you to use macros, please follow the steps below.  Steps to bypass:
|
Notes on updating specific fields
Address fields
In MDS you’ll find two fields for address:
Customer facing address – this is the field used internally by MDS. It’s editable in RAM.
...
Physical address – this is the address that is sync’d with Sanity and used by our platform to display the restaurant in the Store Locator. It’s not editable in RAM – to edit it, please follow the GBS Request process described above
Service mode fields
Dine in always needs to be enabled for the store to be open in our platform
TA/DT/Delivery etc. as applicable
Hours of Operation fields
Dine in always needs to be filled in for the store to be open in our platform
TA/DT/Delivery etc. as applicable
Mobile Ordering fields
When POS ordering integration is concluded, mobile ordering should be activated in each restaurant that will have mobile ordering:
For click & collect AND/OR Delivery to work, it is essential to have the following:
POS = {name of POS vendor is RBI’s systems} (e.g., POS = PARTNER)
Mobile Ordering = ENABLED if restaurant will accept mobile orders (click and collect and/or delivery)
Mobile Ordering Status = LIVE (click and collect and/or delivery)
If mobile ordering will not be activated yet, the restaurant POS should not be turned on for mobile ordering. Hence, “Has Mobile Ordering” should be marked as “No”