Login to the SFCC Production Business Manager, and follow the below steps:
Merchant Tools > Ordering > Orders
Click “Advanced” tab, select “Paid” in “Payment” field and “Exported” in “Export”
If today is 20 July, 2022, put 17/07/2022 in “Date from” field and 20/07/2022 in “Date to” field and “9:00 am” in “Time” field to check the last 3 days exported orders
Click “Find” button at the bottom right to search
You will see the list of orders that are paid and exported
Click “All” button to show all orders on the same page
Start from the 1st row, highlight the order number and all the order details until the end of the list, right click and select “Copy”
Paste the data into the tab “SFCC” in the spreadsheet “Daily Audit of Transactions_(market)”
Login to the Comestri
Navigate to the bottom and click the tab “Orders”
Click the “Download” icon at the top right corner
Your email address should be added to the list, select your email address
Select the Start Date and End Date, this should be the same as the date range as SFCC Production
Click “Submit” button
Go to Outlook Inbox, you should have received the Comestri OMS Order Report
Open the attached file, go to the tab “Order Report”
Highlight the order number in Column A, click “!”, then select “Convert to Number”
Copy all data in the tab “Order Report” of the Comestri OMS Order Report and paste the data into the tab “Comestri Order Report” in the spreadsheet “Daily Audit of Transactions_(market)”
Go to tab “SFCC”, check column K to see if there is any order showing “N/A”
Send email to Digital Support [email protected] to alert the Regional Operations Team to follow up