This report is to be done first thing, as it’s all orders from the previous day that are stuck within the system for a number of reasons. This means the warehouse need to manually print the labels and dispatch these asap.
The sheet we add the orders onto is here (make sure you’re on the right tab for the date):
https://beerhawk-my.sharepoint.com/:x:/g/personal/terri_beerhawk_co_uk/ETd8-LnhxhtKhVkx_tQLxCwBCd4La15W0DDOVLF_93tV5A?e=EKiS4Z
Copy the order number as a hyperlink to make it easier for the warehouse then simply put a ‘Y’ in the field dependent on the error.
Occasionally we’ll get orders for other countries that have slipped through. These must be cancelled/refunded & the customer emailed just so they’re aware we don’t ship outside of the UK.
To pull orders from SDR report (label error);
https://admin.beverage-platform.com/en/orders/?filters={orderPreparations.orderPreparationStatus[]:6}
To pull orders from Late report;
https://admin.beverage-platform.com/en/order-management/late-orders.html
Once the warehouse have printed the label for the above affected orders, they will put the tracking number on the spreadsheet for you to see.
If you are able to edit the address in BP to correct any issues then you can do so and they do not need adding to the Label Error & Later Order Spreadsheet.
If the order is in label error because it’s missing a small amount of info, e.g. a house name/number, part of a postcode etc, but they’re a regular customer – simply utilise Magento to fill in those missing details. Only do this if you’re 100% certain that bit of information is correct! This saves time/contact to the customer.
Most Label Errors will be Jersey/Guernsey/Northern Ireland. If the addresses look correct then add them to the warehouse sheet. The postcodes to look out for are:
Northern Ireland - BT Jersey - JE Guernsey – GY
If there are a lot on the list, like during busy periods you can upload these in bulk:
Highlight the relevant orders from the page on BP and copy these onto a blank spreadsheet and delete all columns except the one containing the order numbers.
Then tidy the column by selecting the whole column and remove the background colour - home tab > Colour fill drop down > select no fill.