What is Inventory?

Your inventory is a record of the total volume of products you have stored at your location(s) and/or our fulfilment warehouses. Inventory is an advanced feature of Borderless360, and our support team will help you set it up.

Contact us at: admin@borderless360.com if you wish to add/remove products.

Having populated your inventory with products, let's look at stock levels and how to manage them.

Understanding stock levels

You'll want to know when products in your inventory are running low, what is incoming and how much of a particular SKU is available. Your Inventory page will show you the quantity of stock available at the warehouse, what has been reserved for backorders, what has been reserved for fulfillment and stock that hasn't yet been received in.

Term

Details

Physical Stock

Displays your current warehouse stock quantity

Available Stock

Quantity you have available for new orders (excluding reserved stock and orders currently being fulfilled)

Reserved Stock

Shows the quantity of stock kept for backorders

Fulfilling Stock

Details the quantity of stock that has been reserved for fulfillment

Incoming Stock

Stock that hasn’t been received in the inbound orders, such as an ASN or return

Backorder support

Backorder is the status given to the order when there is insufficient stock to fully ship it. When this happens, available stock will be reserved until the remaining stock is received. It could be the same product or another one.

When the backorder functionality is activated, the current workflow changes. Borderless360 will no longer skip an order and leave it under Out of Stock, but the system will Reserve stock for when the order can be fulfilled.

For example, consider the following order containing two different products: SKU1 (Quantity: 4) and SKU2 (Quantity: 3). However, the warehouse’s inventory only has 2 of each product. As a result, we would reserve two products from each SKU and wait for an additional two products from SKU1 and one product from SKU2 to be added to inventory before fulfilling the order.

Note: To activate backorder functionalities, please contact customer support.

Reserved Stock

Borderless360 will show you stock levels using amber-coloured low stock and red-coloured Out of stock tags, respectively. It will also display the quantity of a particular SKU that is reserved to fulfil backorders. This is labelled as Reserved stock.

What this now means is stock will be listed as Reserved until we are able to fully fulfil an order, rather than listed as Out of Stock.

Restocking items

  1. From the Dashboard, choose Orders from the sidebar.

  2. Select the items you would like to restock into inventory.

  3. In the top right click Bulk Actions then Draft. This will restock the items into your inventory.

Note: You can also action this from the order detail page.

Setting a product's Safety stock level

  1. From the Dashboard, choose Products from the sidebar.

  2. Click the name of the product whose Safety stock level you'd like to set.

  3. In the pop-up, click Go to product.

  4. In the Inventory box, add the minimum number of the product that should be in stock, e.g. 10.

  5. Click Save to finish.

Note: In this example, once the product's stock level drops below ten, it will be tagged with Low stock.

Using search and filters

You can quickly and easily find products in your inventory by searching and filtering by stock level, 3PL, SKU, date and more. The search feature has also been enhanced to allow users to search via a product's SKU, title, customs description, barcode, HS code, and stock level fields.

Viewing inventory adjustment history

You can see a record of adjustments you've made to products in the inventory by clicking Show under the History column.

Once you have clicked Show for a particular SKU, you will be taken to the the Inventory History page for that particular SKU. You can filter this view by dates and quantities as shown below

You can also search for particular transactions by reference and comment, as seen here:

You can then export this data into a report by clicking on Export, as shown here:

This will download a .csv file showing a stock transaction history report for a particular SKU. The report is a spreadsheet with Date, Reference, Comment, Adjustment and Quantity for a particular SKU.

Using the quantity filter

The quantity filter can be used to filter products by a certain quantity. You can filter products that have a quantity less than or greater than a certain figure, so you can always know when your stock levels have dipped below a certain quantity.

Using the stock adjustment filter

You can view when stock has been adjusted with a negative or positive filter. Positive stock adjustments show when new stock has been received at a chosen 3PL. Negative stock adjustments show when stock has left a 3PL (customer sales). These adjustments are dated so you can see how stock preforms over time.

Generating reports for single or multiple warehouses

Inventory page reports help give you an overview of your stock levels in three different ways.

There are three types of reports you can download for a chosen 3PL or multiple 3PLs on the Inventory page: 3PL current stock level report, 3PL dated stock level report and Stock received report. To generate a report, select Export in the top navigation panel as seen in the image below.

The 3PL current stock level report generates a spreadsheet showing a current overview of your stock on hand within a chosen or multiple 3PLs.

The 3PL dated stock level report provides the same information as the previous report but for a particular date. For example, you may want to produce reports showing stock levels for each previous calendar month.

And the Stock received report shows products that a 3PL or multiple 3PLs received within period of time. Unlike the previous report where you can see stock on a certain day, this report allows you to select a date range for which stock was received into a 3PL, as shown in the image below.

Did this answer your question?