Regularly updating your warehouse quantity is critical for tracking your total inventory and having accurate purchase order recommendations. You can update your warehouse inventory through the Items section and RestockAMZ: Restock from Warehouse. 

 

How to upload warehouse quantity in the Items section

Entering inventory manually into the Warehouse Qty column:

If you would like to update warehouse inventory manually for a few items, you can enter the information for each SKU under the Warehouse Qty column in the Items Section of ForecastRx.

 

Entering warehouse inventory in bulk with a template:

1. To upload your warehouse inventory to the Items section using a downloaded template, select Bulk Management > Download Default Required Template.

2. To upload just warehouse inventory, enter information into the ASIN, Item Name, and Warehouse Qty columns only and save your file. You can delete the other columns or leave them blank.

3. Go back into the Items section and select Bulk Management > Upload data.

4. Select Update Existing Entries and upload your file. The inventory will then populate into the Items grid. 

For future use, save the template with the three required column headers (ASIN, Item Name, and Warehouse Qty). Next time, you can enter the data into the saved template and upload it directly into the Items section with the Bulk Management > Upload Data feature. 

 

Entering warehouse inventory in bulk using downloaded data:

1. Go to the Items section and under Bulk Management, click Download Data. Be sure to have the Warehouse Qty column visible in your grid before doing so. A CSV file will download with all information on the Items Grid.

2. From here, you can enter your warehouse inventory into the Warehouse Qty column and then save the file.

3. Next, go back into the Item section > Bulk Management > Upload Data.

4. Select Update Existing Entries and upload your file. The inventory will then populate into the Items grid. 

 

How to upload warehouse quantity in RestockAMZ

If you are going to create a shipment into Amazon, you can upload warehouse inventory directly into Restock from Warehouse as you create your shipment.

1. Navigate to RestockAMZ > Restock from Warehouse and click Download warehouse inventory template. 

2. Enter SKU and Warehouse Quantity into the file for the inventory you would like to update and save the file. Product Name is an optional column.

3. Go back to Restock from Warehouse and click Choose File and Upload for the quantities to update and proceed to the shipment creation process.

 

When your shipment is complete, the units added to the Amazon shipment will be subtracted from the warehouse inventory accordingly, and the remaining quantity will then be saved into ForecastRx. 

 

Viewing Warehouse Inventory

After inventory has been uploaded, you can view them under the Warehouse Qty column in the Items section, or you can view them in Restock from Supplier under the Warehouse Inventory column. In Restock from Supplier, you will see the date the warehouse inventory was last updated for reference.