2. Creating AusPost Labels & Dispatching

Exporting the Orders from BigCommerce

• 1. Log into BigCommerce

  2. Go to Orders > View Orders.

  3. Click on the Awaiting Fulfillment link at the top of the page.

  4. Select the tickbox for all the printed and checked orders.

  5. Once you have selected the orders click on the Choose Action drop down menu at the top of the orders list and select Export Selected and then click the Confirm button. Click Print.

1. Select AusPost Export from the Template list and click Continue.

   1. Click on the Export my orders to a CSV file link.

   2. Click on the Download my Orders file link.

   3. Save the file to AUSTRALIA POST MANIFEST CREATOR - BEER CARTEL > [CURRENT YEAR e.g. 2019] > [CURRENT MONTH e.g. 1. January] > [CURRENT DATE e.g. 05-01-19]. Note you will need to create the date folder, you may need to create the Month and/or Year Folders.

   4. Add the current time to the file name e.g. 1102AM and click Save.

Run the Australia Post Excel Macro

• 1. Open the Beer Cartel Australia Post Excel Macro (Macro_BeerCartel_AUPost_V6.xlsx) located in the AUSTRALIA POST MANIFEST CREATOR - BEER CARTEL folder.

1. Click the Browse Orders CSV button.

2. Go to AUSTRALIA POST MANIFEST CREATOR - BEER CARTEL > [CURRENT YEAR e.g. 2019] > [CURRENT MONTH e.g. 1. January] > [CURRENT DATE e.g. 05-01-19] and select the BigCommerce export file with the appropriate time stamp.

3. Click the Process button.

4. Once it has finished processing it will display the message Orders processed successfully and ready for update, click the OK button.

5. Referring to the weight written on the printed orders, go through and adjust the weight in Parcel 1 Weight e.g. if the weight on the invoice says 5 (the circled number) then type the number 5 in the field cross-referencing the name to ensure it is the correct order. Note if there is more than one weight for an order because it has multiple parcels e.g. 2 x 13 then enter 13 into Parcel 1 Weight and 13 into Parcel 2 Weight. If there are more than 3 parcels, the additional weights will need to be entered via the eParcel online site post import.

   1. In the Delivery Comments fields remove any comments that do not specifically relate to delivery of the order e.g. Any gift card messages, comments about not including pricing etc. Note delivery comments will only appear when the Authority to Leave field is populated as Yes. For any other delivery comments these can be hand-written on the label once printed.

   2. Scroll right and do a visual check of the Buyer Address 1 & 2, City, State & Postcode fields for any anomalies e.g. address incorrectly imported as date in Buyer Address 1 & 2 fields, address doubled up in Buyer Address 1 & 2 fields, suburb in Buyer Address 1 & 2 fields, first digit in Buyer Postcode field not matching state in Buyer State field etc.

   3. Scroll left and click the Create eParcel CSV button, you'll receive a confirmation message when it has been completed, click the OK button.

   4. Close the Beer Cartel Australia Post Excel Macro, don't save.

Import the eParcel CSV

1. Login to Australia Post's eParcel online site: https://online.auspost.com.au/eParcel/common/auth/login.do

2. Select the radio button next to Location ID XT7 which is Beer Cartel and click the Login to Location button.

3. Click the Import Reference File hyperlink.

4. Select the Important Consignment File radio button and click the Choose File button.

5. Go to AUSTRALIA POST MANIFEST CREATOR - BEER CARTEL > [CURRENT YEAR e.g. 2019] > [CURRENT MONTH e.g. 1. January] > [CURRENT DATE e.g. 05-01-19] and select the eParcel CSV file with the name BeerCartel_eParcel_[TODAY'S DATE e.g. 05012019]_[TIME THE FILE WAS CREATED e.g. 1228PM].

6. Click the Import button.

7. You should be re-directed to a page with a confirmation message similar to the following The file with 9 records imported. An error/warning occurred during the import. Please check the log file for more details.

8. Click on the View Log File button and review the results. Errors often relate to Suburbs not matching postcodes (e.g. Sydney 3000 instead of Sydney 2000) or City being used instead of Suburb (e.g. Sydney 2064 instead of Artarmon 2064.

   1. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched.

9. Check the Invalid column for any icons.

• 1. For any orders with an orange Icon with a white A, click on the consignment number hyperlink (e.g. XT70043838). Review the error message at the top of the page. Update the suburb or postcode as necessary (check google maps, check the suggested suburb/postcode when entering either or call the customer/AusPost). Once correct click the Save button at the bottom right of the page. The page should update, the error message should disappear and should be replaced with the message Actual Weight is required, disregard this message. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched again.

  2. For any orders with an red Icon with a white X, click on the consignment number hyperlink (e.g. XT70043838). Review the error message at the top of the page. Update the address, suburb, state or postcode as necessary (check google maps, check the suggested suburb/postcode when entering either or call the customer/AusPost). Once correct click the Save button at the bottom right of the page. The page should update, the error message should disappear and should be replaced with the message Actual Weight is required, disregard this message. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched again.

  3. For any order that had more than 3 parcels, click on the consignment number hyperlink (e.g. XT70043838). In the Actual (kg) field at the bottom of the screen add the weight for the next parcel and click Save. Repeat for each additional parcel.

10. Any orders that had a red icon with a white X will need to be re-assigned to the manifest. Tick all orders that had a red icon with a white X (these orders won't have a tick in the Next Manifest Ind column) and click the Assign button at the top left and then click the OK button when prompted.

11. Click the Ref No.1 column header and ensure that all orders are sorted from lowest invoice number to highest.

12. Select all orders by click the tickbox in the tickbox column header, click the Labels button and then click the OK button when prompted.

13. Click the Print icon at the top right of the print preview pop-up.

• 1. Click the Print Using System Dialog link at the bottom.

  2. Ensure iR-ADV C5051 is selected and click Preferences.

  3. Click on the paper tray sticking out of the right of the printer diagram and it should be highlighted in blue then click the OK button.

  4. How to Load AusPost labels into Canon Printer

  5. Click the Apply button and then click the Print button.

  6. For any deliveries where there was a Delivery Comment but Authority to Leave wasn't provided, hand write the delivery message on the Australia Post label in the Delivery Comments area.

Editing Consignments

1. Login to Australia Post's eParcel online site: https://online.auspost.com.au/eParcel/common/auth/login.do

2. Select the radio button next to Location ID XT7 which is Beer Cartel and click the Login to Location button.

3. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched.

4. Click on the consignment number hyperlink (e.g. XT70043838).

5. Edit as necessary and click the Save button.

6. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched.

7. Select the tickbox next to the edited order and click the Labels button and then click OK when prompted.

8. Go to step 15 of the Import the eParcel CSV guide.

Unassigning/Deleting Consignments

If you want to hold off shipping a parcel just unassign it. If the order has been cancelled and the parcel isn't going to be shipped then delete it.

1. Login to Australia Post's eParcel online site: https://online.auspost.com.au/eParcel/common/auth/login.do

2. Select the radio button next to Location ID XT7 which is Beer Cartel and click the Login to Location button.

3. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched.

4. Select the tickbox next to the order to be unassigned/deleted and click the Assign/Delete button and then click OK when prompted.

Dispatching Consignments

1. Login to Australia Post's eParcel online site: https://online.auspost.com.au/eParcel/common/auth/login.do

2. Select the radio button next to Location ID XT7 which is Beer Cartel and click the Login to Location button.

3. In the Top Menu hover over Consignments and click View Consignments - Not Dispatched.

4. Scan down the Label Printed and Next Manifest Ind columns and ensure both are ticked for all consignments.

5. Click the Dispatch button and when prompted click the Yes button.

6. Click the Print button, two pages should print.

7. Sign the second page in the space next to where it says Sender's Signature, staple both together and place on the forklift.

   1. When Australia Post comes to pick up the parcels they will sign the top page and take the bottom page. Place the signed top page in the Australia Post Manifests box in the office upstairs.

Post-Dispatch Issues

- If the sender address is entered incorrectly and then dispatched then it is possible to cross out name and write in the correct name.

- For any issues once the parcels have been dispatched (e.g. remove a parcel from AusPost as it wasn't sent out) contact Catalina Amaro, [email protected], 9941 7778. This needs to be completed within 24 hours from dispatch and should be recorded in an email to [email protected]. See example below:

Subject: Cancel of Parcel for Delivery

Hi Catalina,

Could you please remove one parcel from our manifest today.

This is for Beer Cartel, Account Number: 7508348

Relating to Manifest: P221

And concerning Article: XT7000731201000930205

Nina Martin

506 Wanna Wanna Road

Carwoola

2620 NSW

​Could you please confirm once done.

Thanks,

Richard​