MacPac Receiving Process

When sending your product to MacPac, there are two essential requirements PRIOR to the product's arrival. This process is designed to plan and track incoming inventory, ensuring the safety of your product and efficient order management in our warehouse.

  1. Packing Slip Requirement:

    • Before your product arrives at our warehouse, we must receive a packing slip. This slip should include product descriptions, SKUs, and/or item numbers to help us accurately identify the products. It should also specify the total number of cases and pallets. Shipments without a packing slip before delivery will incur a $100 no-slip fee at the end of the month billing cycle.

  2. Appointment for Couriers and Carriers:

    • Couriers, LTL (Less Than Truckload), and TL (Truckload) carriers are required to call and schedule a two-hour appointment window before delivery. They can reach our scheduling department at 720-887-5861 (choose option 1) to confirm the appointment. Shipments arriving without an appointment will either be turned away or subject to a $250 non-appointment fee at the end of the month billing cycle.

    Note for Carriers: If there are any changes to the appointment time, please have them call back to update their times. You can also inform carriers about this process by including the following information on the Bill of Lading: "REQUIRES APPOINTMENT TO DELIVER! CALL 720-887-5861 option 1 PRIOR TO DELIVERY."

Common carriers such as Estes Express, YRC, Reddaway, UPS Freight, FedEx Freight, and ABF are already familiar with our process and will be on the lookout for this information.

MacPac Inventory Process

MacPac relies on Google Sheets to track the inventories in our warehouse. Each client has view-only access to their inventory, allowing you to plan effectively. While we do not provide reports or other inventory sheets, you can easily download them from Google and customize them as needed.

Accessing Your Inventory:

You can access your inventory sheet through a private link sent to your team. If you haven't received this link, please contact kristi@macpacfulfillment.com, and we will provide you with the URL. This URL remains constant, so be sure to bookmark it or share it with your team.

Note on Inventory Accuracy: Please be aware that we update inventory sheets for internal use throughout the month. However, physical counts are conducted at the end of each month. This means that your inventory may be inaccurate or missing information before the final count.

Downloading and Reading the Spreadsheet:

To download the inventory, select "File" in the upper left corner, then choose "Download As." Once saved, you can open the file, unhide columns, edit numbers, and run reports as needed.

Understanding the Spreadsheet:

  • The left side (Columns A-C) is used by the MacPac team for internal purposes and doesn't require your attention.

  • The right side of the sheet is dedicated to tracking inventory. We hide past months and columns as we go to keep the sheet manageable. You can unhide columns by downloading the file.

    • Inventory columns are marked in yellow.

    • Received columns are marked in red.

    • Shipments out from MacPac are marked in green.

    • End-of-month inventory columns will have the last day of the month and say "EOM."

End-of-Month Inventory:

We do not send dedicated End-of-Month inventory reports via email. It's your team's responsibility to check your inventory spreadsheet on the last weekday of every month and locate the yellow EOM column for your physical inventory counts.

Expiration Dates and Lot Codes:

For products with expiration dates and lot codes, each expiration date is tracked as a separate product line. This meticulous tracking ensures compliance and helps prevent chargebacks when shipping multiple dates to Amazon. Rows with old expiration dates are hidden, but you can unhide them for reference.

Products within 90 days of expiration are highlighted in red, while orange and yellow indicate upcoming dates. If any products need disposal or donation, please notify us for prompt scheduling.

Setting Up Notifications:

If you'd like to receive notifications when changes are made to your inventory, follow the walkthrough provided in the link below. To minimize email frequency, we recommend selecting the "daily digest" option, especially if we update the spreadsheet multiple times a day.

Turn on notifications in a spreadsheet - Computer - Docs Editors Help

If you have any questions regarding the spreadsheets or need assistance with the download process, feel free to contact our office, and we'll be happy to guide you through it.