Vendor Schedule Template
  • 17 May 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Vendor Schedule Template

  • Dark
    Light
  • PDF

Article summary

Download Template

This template can be used for scheduling your deliveries. Click on the link below to access and download the template.

Vendor Schedule Template.xlsx

Guidelines to Upload Vendor Template

The guidelines highlighted below are essential to follow and ensure that your schedule is uploaded to the platform correctly.

Impact AreaGuidelines
Time Format - Accepted Values1200, 1300, 2100; etc.
Date Format - Accepted ValuesYYYY-MM-DD(e.g., For the date Feb 9th, 2023 date value should be in 2023-02-09).
DeliveryFor No Delivery - Cell value is left blank.
Start Time & End TimeFor No preferred time - Add 000 in both the cells for start & end.
Mandatory FieldsThe following columns cannot be left blank: Vendor Number, Store ID, Delivery Effective Date, Delivery Expiry Date, Merchandising Effective Date, and Merchandising Expiry Date.
Mandatory Fields* If data is not applicable or available for mandatory fields, rows need to be deleted from the sheet.
Mandatory Fields* Mandatory Fields can't have duplicate values. The same combination of values across these key columns cannot be duplicated in any other row. The primary keys, in conjunction, become composite keys.
Vendor IDNo suffix or prefix to be added to the Vendor ID. * Multiple vendor numbers are not allowed in a single row; each row of data should have just one vendor number entry.
Commodity Type - Accepted ValuesChilled, Frozen, Ambient, General Merchandise, Pharmacy -RX, Pharmacy -OCT/FS.
Receiving Through - Accepted ValuesBay Door, Man Door (Receiving Door), Front Entrance, Garden Centre.
Merchandise ArrivalMerchandise arriving on a particular day should be denoted with 1; leave the cell blank if merchandise is not arriving or there is no data.
Columns NamesVendor Template Columns Names should not be altered/modified.
Vendor TemplateDo not create multiple sheets/tabs under one Spreadsheet; refrain from applying filters on schedules.

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.