Embedded Files
IMPORTANT: prior to printing orders please check the Brewquets reamaze awaiting responses folder for any customer emails / address changes etc. If there are any address changes update these prior to printing out orders.
For Specific Day Orders, you will also need to check the order tagger Google Sheet report to make sure no orders are missing their date tags, which can happen from time to time. This can be checked here.
Please note: the "Specific Day" filter has been updated to include both open and archived orders. Once the date filter is added the correct orders will display. Should any of the orders (once the date filter has been typed in) be marked as archived then you know there is an issue with that order, i.e. it has previously been archived and should not have been. This will be quite rare but this is a safety net check to ensure we do no inadvertently archive an order without it being actually dispatched. Open this order up and investigate why it has been set to archived.
Process for printing orders:
The videos below show how to print packing slips & invoices for Standard and Specific Day orders.
For each order only an invoice is printed, as for Brewquets we no longer include any paperwork in the box.
Once you have printed invoices for Standard orders update the Share In Store Notes Google Sheet with the details of the last order that was printed up to (and including). There is no need to update the Specific Day delivery with the last one printed as these are all date specific and filtered via the date before printing.
Once printed do the following:
- paper clip the orders all in 2 piles (standard and express)
- paper clip all the gift messages in one lot (in the correct order)
- highlight any delivery instructions and product type variants (e.g. if BIG Brewquets or if nuts / jerky are to be added etc.)
- if it is a Specific Day delivery then stamp the bottom right of the invoice with the "Urgent" stamp.
Standard Delivery Order Printing and Gift Message Printing
1. Log in to the Brewquet website and go to orders
2. Click "Standard Delivery"
3. Click all the orders. Click "More Actions" then click "Print with Order Printer:
4. Under templates, select Brewquets invoice. Then click "Print"
5. To print the message, click "MSG" under templates.
6. Copy a message template and paste it to the printer application.
7. Put it in the Brewquet message file.
8. Click "Print". Make sure that the Printer is Brother QL-700
9. Alternatively, you can also do a mass printing by opening Brewquet message database
10. Go to MSG. Select all messages anc click copy.
11. Open "Brewquet Gift Message Sheet file". It is found in the shared drive Brewquets > Delivery > Australia Post - BREWQUETS
12. Paste the selected messages in the cell A2 of the Excel sheet.
13. To delete all "MSG" words, Ctrl + F. Find MSG. Replace with nothing. Click "replace all"
14. To delete the blank cells, Click F5. In the Go To Dialogue box, click "Special" then "Blank"
15. Right click cell A2 and click delete. Click "Shift Cells UP" and ok.
16. Go to the Brewquets Database file. Click File > Database > Change > Ok
17. Select the saved Excel file sheet with the new populated messages. Click Next. Then Ok
18. Click Print
Brewquets Creating Labels & Order Pick Sheet Part 1
1. Log in to the Brewquet website and go to orders
2. Click "Standard Delivery"
3. Click all the orders. Click Export
4. Copy the downloaded Excel file. Open Brewquet folder> Delivery > Australia Post - BREWQUETS > 2020. Select the date today or export date and paste the Excel file under the Standard folder.
5. In the Australia Post - BREWQUETS folder, open "Brewquets _Macro_AuPost_V9.7
6. Click Browse Orders CSV, then select the export orders file previously saved.
7. Click Process Orders. Then Ok.
8. Print the Brewquets Stock Pick List.
9. In the Brewquets _Macro_AuPost_V9.7 file, adjust the parcel weights and recheck the buyer address
10. Click Create E-Parcel CSV. Then Ok
11. Log in to Australia Post using Brewquet account. Click Reference Data > Import Reference File > Import Consignment File > Choose File > Find the recent file created.
Brewquets Creating Labels & Order Pick Sheet Part 2
12. Click Import
13. View the log file to check for any errors
14. Under Consignment, click "View Consignment Not Dispatched"
15. Check every consignment for any errors or unassigned ones.
16. Click Select all. Click Labels. Print.
Brewquets Express Order Printing & Gift Message Printing
1. Log in to the Brewquet website and go to orders
2. Click Specific Day Delivery (ALL)
3. Open the Beer & Brewquets Shared In-Notes. Copy the Date Code for specific day delivery filter
4. Paste the date code in the filter orders to filter out the orders with the specific order date
5. Check the Brewquets Order Tags Report for any yellow highlights that needs attention.
6. Go back to the Orders page. Select all orders with the specific order date. Click Export > Selected # orders > Export orders
7. Put the downloaded excel file in the "Express folder". Open Brewquet folder> Delivery > Australia Post - BREWQUETS > 2020. Select the date today or export date and paste the Excel file under the Express Folder.
8. Go back to order page. Click More Actions > Print with Order Printer
(Steps 9-23 is similar to process for standard delivery except that it is for express)
9. Under templates, select Brewquets invoice. Then click "Print"
10. To print the message, click "MSG" under templates.
11. Copy a message template and paste it to the printer application.
12. Put it in the Brewquet message file.
13. Click "Print". Make sure that the Printer is Brother QL-700
14. Alternatively, you can also do a mass printing by opening Brewquet message database
15. Go to MSG. Select all messages anc click copy.
16. Open "Brewquet Gift Message Sheet file". It is found in the shared drive Brewquets > Delivery > Australia Post - BREWQUETS
17. Paste the selected messages in the cell A2 of the Excel sheet.
18. To delete all "MSG" words, Ctrl + F. Find MSG. Replace with nothing. Click "replace all"
19. To delete the blank cells, Click F5. In the Go To Dialogue box, click "Special" then "Blank"
20. Right click cell A2 and click delete. Click "Shift Cells UP" and ok.
21. Go to the Brewquets Database file. Click File > Database > Change > Ok
22. Select the saved Excel file sheet with the new populated messages. Click Next. Then Ok
23. Click Print
Brewquets Express Order Australia Post Label & Pick Sheets Creation
1. Open the Brewquets_Macro_AuPost_V9.7 file
2. Click Browse Orders CSV
3. Select the recent Express orders file
4. Click Process Orders
5. Change the Parcel Types to "Express"
6. Change the parcel weight and recheck the address
7. Click Create Parcel CSV
8. Import to Australian Post (same process as that of the standard delivery one)
9. When printing out, use the express labels
Page updated
Report abuse