Compare Warehouse Report
Transferring stock, balancing stock, and viewing SKUs across warehouses are all accomplished with the Compare Warehouse report
Monica avatar
Written by Monica
Updated over a week ago

If you have enabled more than one warehouse, it can be helpful to see stock levels across locations. If you need to transfer stock, balance stock at various locations or compare inventory levels across warehouses, then the Compare Warehouse report can help.

Report Set-Up

First click Reports from the left menu, then Compare Warehouses.

Choose a warehouse at the top of the screen. This is your 'destination warehouse' when preparing a transfer.

Then select which warehouses you would like to compare to this warehouse using the 'Compare To' button in the upper right corner.

Note: The date range of this report correlates to historical metrics such as sales and revenue, which you can add to your view using the gear icon in the upper right corner to select columns. The date range in the Replenishment screen determines how the forecast is calculated. The Replenishment date range will also determine replenishment recommendations and overstock.

Reading the Report

Once you have added a second location using the 'Compare To' feature, you will see new columns for Available Stock, Total Available Stock, and Total To Transfer.

Available Stock is inventory on hand at that location in excess of what will be needed during the days of stock (planning period). This metric is based on the lowest amount of stock needed (based on the forecast) during the days of stock. Any inventory available over that amount is identified as available stock. (Note that Overstock is excess inventory after the days of stock. Available stock is excess inventory during the days of stock.)

Total Available Stock is the sum of Available Stock from all compared locations. This field will appear as zero if no warehouse is set to compare to (since there is no stock available to transfer until you have a warehouse for reference). Once you set a warehouse to compare to, this field will populate.

Total To Transfer will show as the replenishment amount for the destination warehouse as long as there is available stock in a source warehouse. If there is not sufficient stock to transfer, then Total To Transfer will be reduced to the source stock amount.

Available stock can be transferred to another location to meet replenishment needs rather than order additional product from your supplier.

Creating a Transfer

Once you've determined which products have available stock and can be used to meet replenishment needs at another location, you'll create a transfer. First select items to be transferred.

Then select '+ New Transfer for Variants'.

You will then select your Source warehouse (origin of available stock), your Destination warehouse (where stock is sent), and the Replenishment location/warehouse to use for adding order quantities.

Note: You can set a Combined Warehouse as a "Replenishment" warehouse to use replenishment recommendations generated using a Combined Warehouse. Since this is not a real warehouse, a true destination warehouse must be selected.

By default, you will limit the quantity of stock to transfer to the Available Stock in the Source warehouse. 

This helps to ensure that you aren't moving too much stock out of your Source warehouse.

Finally, click Create Transfer

At this point, you can adjust information and quantities just as you would with a purchase order or other warehouse transfer.

When you click 'Save' at the bottom of the page, the transfer is created.

On the Purchase Order dashboard, you can now see the transfer listed. 

Did this answer your question?