Compare warehouses 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 more than one warehouse enabled, it can be helpful to see stock levels across locations. The Compare warehouses report helps you transfer stock, balance stock at various locations and compare inventory levels across warehouses.

Setting up the report

Access the report by clicking Reports from the left menu, then Compare warehouses.

Choose a warehouse at the top left-hand side of the screen, which acts as 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 top right-hand corner of the page.

Note: The date range of this report is used to display historic metrics such as sales and revenue, which you can add to your view by using the gear icon in the upper right corner. 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 compare warehouses 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, while 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 display zero if you have not selected at least one warehouse to compare to the destination warehouse (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 can create a transfer. First, select items to be transferred using the checkboxes on the left-hand side.

Then click '+ New transfer for [x] variants'.

You will then select your Source warehouse (the origin of available stock), your Destination warehouse (where stock is sent), and the Replenishment warehouse used to determine the quantities on the transfer.

Note: You may have different destination and replenishment warehouses if you are generating replenishment recommendations using a combined warehouse. Since combined warehouses are not real locations, a different destination warehouse must be set.

By default, the limit transfer quantities by available stock checkbox will be selected, helping to ensure you're not moving too much stock out of your source warehouse.

Once you are happy with the transfer settings, click Create transfer. You'll be taken to a page where you can adjust information and quantities just as you would with a purchase order or other warehouse transfer.

Once you're happy with the transfer details, click Create to create the transfer.

View your created transfers by clicking the menu on the left-hand side and going to Stock orders.

Did this answer your question?