How to request
Download and Save the linked formatted excel document.
Compile a list of users who need access to Shop. Take a look at the Examples and the Best Practice tips below to ensure the template is filled out correctly.
Columns Required:
Column D: Site Number should be formatted with the 3-digit OpCo to include the leading zeros.
Column E: Seller Account ID should be formatted with the 6-digit account number.
Column G: Select Delivery User.
Column H: Select USBL
Optional Column:
Column F: Additional_Accounts can be used to enter account numbers when a user requires access to multiple locations.
Account numbers entered in column H need to be formatted with the 3-digit Opco number followed by a dash, then the 6-digit account number.
🚨 When entering multiple account numbers they should be separated by a comma with no spaces, e.g., 013-123456,013-567890 within the single cell.
3. Complete the Excel template for Batch User Processor.
4. Email product-enablement@sysco.com with the request to have the users provisioned along with the Excel file to upload. There is a 10-business hour turnaround time for these requests to be completed.
If there are any errors in uploading, Customer Onboarding will communicate any additional information needed to resubmit.
5. Once the users have been provisioned, they will receive an email from noreply@sysco.com with a link to set their password and log into Shop.
If a user is already provisioned with access to Sysco Pay or Shop, they will not get a Shop Activation email. They will need to navigate to the App Store and download Sysco Shop Mobile and log in with their existing email and password.
Examples
The examples below show the different user types and what columns should be filled out.
Example of a Normal User with access to one account
Example of a Multi-Buyer with access to multiple accounts
Best Practices
When adding information to the excel template, please do not change the formatting. Additional spaces before or after text, bold formatting, changing the column sequence or using special characters can cause issues at the time of upload.
Be sure to include the 3-digits of the OpSite. For example, Central Texas should be listed as 013, not 13.
Copilot Tips
Formatting site–account data correctly is a common requirement when preparing spreadsheets for batch uploads. Doing this manually can be time‑consuming and prone to errors, especially when dealing with leading zeros, separators, and multiple entries. Microsoft Copilot can simplify this task by quickly transforming raw data into the exact format required, as long as the prompt is clear and specific.
To begin, gather your raw site–account data in its original form. This may appear as separate values with spaces or line breaks, such as 022 - 522565 or 067 - 000018. When asking Copilot for help, clearly describe the structure you need. For example, specify that each entry must be formatted as a 3‑digit site number, followed by a hyphen, and then a 6‑digit account number, with multiple entries separated by commas and no spaces. Being explicit about digit length, separators, and spacing ensures Copilot produces a result that meets upload requirements.
Once prompted, Copilot can return a single, properly formatted string that combines all site–account pairs into one value suitable for Excel. For instance, the raw values listed above are transformed into 022-522565,067-000018,013-666986,049-001149. This formatted output can then be pasted directly into a single Excel cell, as shown in the spreadsheet example. Before finalizing the file, it is still good practice to visually confirm that there are no extra spaces, missing leading zeros, or unintended line breaks. Using Copilot in this way reduces manual formatting effort and helps ensure batch uploads process successfully the first time.
Click here to view our entire Help Center.