This template will already contain the Supplier ID, the Supplier Name, the Division (Enterprise Name), the Branch Code, the Branch Name, the Frequency (if deliveries are made weekly or fortnightly), the week commencing Start Date and the current delivery schedule.
Column G corresponds with the actual start date when the delivery schedules start from. Please enter the date of the Monday of the commencing week.
Columns H to N correspond with the actual delivery days. If the column is blank this means that the site is not set to receive a delivery on that day. Please do not enter the number zero if the site does not have a delivery day as the system will take this as being a cut off time of midnight. The numbers in these columns dictate the order cut off times, how many hours before the midnight of the delivery day when the order can be sent to the supplier. For example, if a site has a delivery day of Tuesday and the order cut off time is 12p.m the previous day, the number 12 would be entered under ‘Tuesday’ for the relevant site because from 12pm on Monday (order cut off) until midnight Tuesday (delivery day) = 12 hours.
No other alterations to the file including rows, columns or headings should be made. If anything, apart from the numeric data in columns H to N and the start date in column G are altered the file will not upload into successfully
Once the template has been updated, please send it back to your client in a .CSV (Comma delimited) file format.