When you receive a shipment from your vendor, you'll need to receive those items on the purchase order. It is important to receive items and close purchase orders so that variants listed will no longer be considered on order. The same methods for receiving purchase orders described here also apply to warehouse transfers.
Purchase Order Status
Note that items on purchase orders with OPEN or PARTIALLY RECEIVED status will still be considered on order. If an item has been received on a partially received purchase order, then only unreceived items are considered on order. Received items will no longer be considered on order.
When to Receive in Inventory Planner
If you are connected to an Inventory Management System (such as Ordoro or Tradegecko) or Amazon, then your receiving will happen through that platform. Receiving information including units received and PO status will update in Inventory Planner once updated on your connected platform.
If you are connected to a sales platform such as Shopify, BigCommerce, WooCommerce, or Magento, then you will handle receiving in Inventory Planner.
Options to receive a purchase order include:
- Type received quantities into the purchase order and save
- Receive All
- Upload received quantities to a purchase order.
- Use a barcode scanner
- Upload a purchase order including received quantities (PO does not previously exist in Inventory Planner)
Type received quantities into the purchase order and save
You can type received quantities directly into the purchase order information in Inventory Planner.
After you've entered the received amount, click Save at the bottom of the page.
You will then see a date stamp and a new column called Good Receipts showing when and how many units were received.
If your supplier sends all items on the purchase order correctly, first celebrate. Then, you can use the 'Receive All' button at the bottom of the screen.
This will enter the same amount ordered as now received. Your purchase order status will automatically change to Closed.
Upload received quantities to a purchase order
If you have a spreadsheet of received quantities, it will be easiest to upload this information to your purchase order.
First, scroll to the bottom of the PO and click the arrow next to 'Receive All', then select 'Upload Received Quantities'.
To upload received quantities, you will need the following information including a column title for each field:
- SKU or other identifying information for the product on the PO, such as barcode, title, ID, or vendor reference (supplier SKU). Keep in mind that this identifier must be unique. For example, if you have two items with the exact same product title, then you should not use 'title' as your identifier.
- Received quantities
- Arrival date using the yyyy-mm-dd format. (Optional field for import)
- Ordered quantities (Optional field for import)
First select your file for import.
Then match up your column titles with the corresponding field in the import manager.
When you've selected the correct fields, click Upload at the bottom of the import manager.
Use a barcode scanner
If you would like to scan items while receiving to ensure the right products are received, then you can use a barcode scanner to accomplish this. You will need to be sure that all items on your purchase order have barcode information populated in Inventory Planner.
First, scroll to the bottom of the PO and click the arrow next to 'Receive All', then select 'Use Barcode Scanner'.
Using a scanner attached to your computer, scan the received item. As you scan items, you will be see the information populated in the Inventory Planner preview.
Once all items are scanned, click Save to enter the received quantities.
Upload a purchase order including received quantities
If your PO does not previously exist in Inventory Planner, then you can upload all information including the received amounts.
To import a purchase order from a spreadsheet:
- Your spreadsheet for upload needs to contain the following information including column names:
- An identifier to match products: SKU, title, ID, vendor reference, or barcode. (required)
- Quantity ordered (required)
- Vendor name (optional)
- Received quantity if the ordered products have already arrived and added to inventory. (optional)
- PO created date (optional)
- PO arrival date (optional)
- Cost price (optional)
- Landing cost price (optional)
- PO number to differentiate purchase orders. If not provided then POs are distinguished by arrival date. (optional)
- Date format such as yyyy-mm-dd (optional)
2. Go to the Purchase Order section from the left side menu.
3. At the bottom of the screen, click Actions > Import Purchase Order.
4. Attach your saved spreadsheet by clicking on Select File and locating your document.
5. Inventory Planner will match columns with your column names when possible. For other columns of information, you will need to select the correct column title to match the information type for import.
6. When all column names have been matched to their information field, click Upload at the bottom of the screen.
Receiving and Purchase Order Status
If you received some but not all items on the purchase order, then your purchase order status will change to Partially Received. If you received the same amount of items as ordered, your PO status will be Closed.
If you only received some items ordered and do not expect to receive the remaining items, you will need to indicate that the PO is Closed. You can chose 'Close' at the top of the page.
This will not add to received amounts, but will ensure that outstanding items are no longer considered 'on order' for the purposes of calculating the replenishment recommendation.