Sometimes it’s hard to calculate the total value of your stock because of intensive inventory transactions. Delivrd inventory management software and its Stock Valuation Report feature give you an insight into your total inventory value with just a couple of clicks. Here’s how it works:
In the navigation bar, click Products & Inventory > Inventory List.
In the upper-right corner of the Inventory List page, hover over the … button and choose Stock Valuation Report.
And that’s it! The stock valuation report will show you the product category, available quantity, location, unit value, and total value of the product, which is unit value multiplied by quantity. Besides, Delivrd will calculate the total stock value, which is displayed in the upper-right corner of the report.
It is also possible to filter the report by specific SKU number, location, or category.
Finally, it is possible to export the stock valuation report.
Whenever you create an inventory transaction (e.g. inventory count, receive or issue) in Delivrd, you can enter a remark. Documenting transaction details in remarks is very useful, in particular when working in multi-user environment.
With Delivrd latest release, you can now search through remarks entered in transactions. You can search by entering search text in the ‘Search By Remark’ box:
When you carry out inventory transactions – stock count, receiving products to stock or issuing products to a sales order, we strongly recommend to add remarks. It makes it easier for everyone to understand why these transactions happened.
You can view these remarks in inventory transaction history, one of Delivrd’s coolest features. And now, you can update existing remarks!
If you forget to add a remark or made a mistake while inputting one, you can just visit the inventory transaction history of the relevant inventory record, click on the remark to update it, or add a new remark if one doesn’t exists.
And here’s a short clip explaining how to update remarks of any inventory transaction:
Barcode scanning is easy to implement, provides clear return on investment, will make your inventory much more accurate and will help prevent costly pick/pack/ship mistakes. Imagine standing in line in a supermarket and having to wait for the person at the counter to enter the name of all products. How slow, inefficient and error prone would that be?
In Delivrd, every process can (and should) be implemented using barcode scanning.
Barcode Scanning Process
To get started with barcode scanning, you will need:
A barcode scanner
Labels with barcodes which include the relevant data – it can be a product’s SKU number (or part number), EAN/UPC code, or a label of a package with its tracking number.
There are many types of barcode scanners, but they all work the same: you connect them to your desktop computer or tablet, and they start acting as a keyboard. When you scan a barcode label, the data from the label is read by the barcode scanner, and is passed to your desktop or tablet, as if you types the data on the barcode label.
Barcode scanners do not require any software or driver. They are similar to keyboards, so you just plug them to your computer and start using without having to install anything.
Barcode scanners can be connected to a desktop/tablet either with a wire or wireless (again, similar to keyboard).
Wired barcode scanners – These scanners have a cable running from their USB connector to the scanner itself. Here’s an example:
Wired Barcode Scanner
Wireless Barcode Scanners – These scanners are not connected with a cable to desktop/tablet, but use either bluetooth connectivity or have a small USB dongle connect wirelessly to the scanner.
Wireless Barcode Scanner
The big adventage of wireless scanners is that you are not limited by the length of the cable and you will not have to worry about the cable.
Choose a wired scanner when you are stationary, standing or sitting next to a stationary (usually desktop) completer. Use a wireless scanner when you need to move around, but keep in mind that you will still need to be able to see what you scan, so you can’t go too far from your desktop / tablet.
Recommended combinations are: wired scanner + desktop if you are stationary, wireless scanner + tablet, for mobility.
If you are using an iPad tablet, make sure your scanner is compatible. Android/Windows tablet have a much wider range of supported scanners, since the iPad does not have a USB port.
Once a scanner is connected to your computer, you can start scanning barcode labels. You can find barcode label on many products in your inventory. Some products have EAN/UPC labels, which are being scanned in supermarkets, while others would have serial numbers, which identify each product uniquely, such as computer monitors or TV screens. Many mobile phones have IMEI barcode labels attached to their backs. Here are some examples:
2D barcodes/ QR codes (middle of bottom row in image above) are not commonly used in inventory management & order fulfillment applications. If you do plan to use 2D barcodes, make sure your barcode scanner supports reading them.
Many products have barcode labels applied by the product’s manufacturers. If you manage inventory and/or sell products which are not labeled, we strongly suggest you label them or ask your supplier to label them. You can buy a label printer and print the barcodes yourself and apply them to your products, or buy pre-printed labels.
Barcode Scanning in Delivrd
Barcode scanning is key to accurate, efficient inventory management & order fulfillment.
In this tutorial, we will focus on barcode scanning in inventory management processes in Delivrd. In later tutorials, we will explain how barcode scanning is used in receiving products from purchase orders, issuing products for a sales order, and scanning barcodes in pick/pack/ship processes.
Barcode scanning in inventory management
In order for you to use barcode scanning in inventory management in Delivrd, you first have to make sure barcode labels are applied to your products.
The barcode label should include a unique number to identify each product. In Delivrd, that unique identifier is called SKU (stock keeping unit). The number on the barcode label which identifies the product should be entered in the relevant Delivrd product as SKU.
Product SKU in Delivrd
Once the SKU number in Delivrd is the same as the number on the barcode label applied to the product, you can scan the product in the search box in Delivrd’s inventory list page. Once scanned, Delivrd will find the relevant product, and then, you can perfromd any inventory transaction: inventory count, issue, receive, or transfer to another location.
Delivrd inventory management software now has a feature of sending emails with inventory alerts. To set up this feature, go to Settings and make one of the following choices in the Inventory Alert drop-down list:
Don’t send any alerts: This is a default option that does not allow to send the inventory alerts.
Send only low inventory alerts: Choose this option to send the alerts when the inventory quantity is below the reorder point or safety stock.
Send list of all inventory: Choose this option to send inventory reports for all products, regardless if the inventory quantity is below the reorder point or safety stock.
If you assigned any products to suppliers, then it is also possible to send the inventory alerts to those suppliers. To do so, just specify the email address when creating or editing a supplier record. It is possible to add multiple email addresses for a single supplier, by separating each email with a comma (,)
To send the inventory alerts, to your own email and to your suppliers, go to the Inventory List page, and from the Actions menu, select ‘Send Inventory Alerts’:
In the navigation bar on the left, click either Products & Inventory > Products or Partners > Suppliers.
In the upper-right corner of the Products List or Suppliers page, click Actions > Products – Supplier Assignment.
In the upper-right corner of the Product-Supplier Assignment page that opens, click New Product-Supplier.
In the form that opens, select the product and supplier that you are going to connect. You can also optionally add the price you buy this product from the specified supplier, and select the status of assignment – either Active or Inactive.
When ready, click Save.
The system will reflect the product-supplier assignment in the inventory list by adding the Supplier column to the page where the product record is located.
The product price will be copied to replenishment order lines that you will create with this supplier and product combination, and the system will send inventory alerts to the supplier regarding their own products – more on inventory alerts coming soon.
With Delivrd inventory management software, you can quickly update inventory for a specific product. To do it, open the Inventory List page under Products & Inventory and scan the barcode of the product on this page. If you don’t have a barcode scanner, you can manually enter the SKU, EAN, or UPC of the product in the field above the inventory list, and then click Search.
If the system finds a result, you can directly receive or issue 1 piece from inventory, or choose to receive or issue any quantity you want. You can do this with the four buttons in the Inventory Transactions column: +1, -1, Receive, or Issue.
Click the corresponding button to open a window where you can enter the transaction details. For the Receive and Issue transactions, you can enter any value in the quantity field, whereas for the +1 and -1 transactions, this field is not available for editing, as quantity of transaction is 1.
As always, any inventory transaction you enter into Delivrd will be displayed in the Inventory Transaction History
In this user guide, we’ll describe how to manage the inventory of serial numbers in multiple locations, specifically, how to create, transfer, and issue serial numbers in Delivrd. Read on!
Creating a Serial Number
To start managing the inventory of serial numbers in Delivrd, you first need to create them. You can do it in several simple steps:
In the navigation pane on the left, click Products & Inventory > Serial Numbers.
In the upper-right corner of the serial number list, click New Serial.
In the window that appears, choose the product for which you are creating the serial, and an inventory location for this serial.
After you choose a location, two things will happen:
The serial will be created in this inventory location.
A quantity of 1 piece will be added to inventory in this inventory location (there is no need to update the inventory separately).
Note: You can scan the barcode of your serial number into the serial number field instead of typing it.
Transferring a serial number to another location
To transfer a serial to another inventory location:
On the inventory list page, scan the barcode of the serial. The inventory record of the product with the inventory location of the serial will appear. You can then either issue the serial or transfer the serial to another location. To choose the destination inventory location, click Transfer Serial
In the window that appears, choose the location and add remarks, if necessary. When ready, click Save.
After you click Save, two things will happen:
Serial number location in serial inventory list will change to the new inventory location.
1 piece will be deducted from the previous inventory location of the serial number (North inventory location in this example), and 1 piece will be added to the destination inventory location.
Issuing serial numbers
If the serial number no longer remains in any inventory location that is managed in Delivrd (for example, the serial is issued to sales order, returned to vendor, or scrapped), you can issue the serial number.
After scanning the serial’s barcode label into the inventory location list search box, click Issue Serial.
2. In the window that appears, you can add a remark to record the reason for the issue. When ready, click Save.
After you click Save, two things will happen:
The inventory will be deducted in 1 piece.
The serial will be marked as out of stock, but it will still appear in the serial numbers list.
If you try to search the inventory list for a serial that was already issued, you will get an error message:
Beginners User Guide for Importing Product Data into Delivrd
After signing up to use Delivrd inventory management software you will need to import your products into the system. This can be done by importing a CSV type file into the product database.
In order to import items into the Delivrd system you need to prepare a CSV file with your products information. If you are not sure of the format the file should be in you can download a sample file as shown below
Please note the following two (2) limitations when importing source files:
Maximum file size for uploads is 100 KB.
You can upload only CSV files.
Click here for an explanation of the fields.
Starting the importing process.
Click on the Import Products from CSV file button as shown below. After doing so you will be taken to a different screen where the actual import action will be implemented.
Adding an import file
Click on the +Add File button in order to browse to your source file’s destination and select it.
Starting the upload
In order to start the uploading process once the file has been uploaded you can click on either the Start Upload or Start buttons as shown below.
Creating the products
After the file has been successfully uploaded it is now ready to be imported into the Delivrd system by clicking on the Create Products button as shown below.
After importing the file
After the file has been imported successfully you are taken directly to the Products List page so you can view the imported products directly.
Downloading a sample file
You can download a sample source file and insert your data into the relevant fields which can then be imported as explained previously.
Explanation of the fields that can be imported.
Managing inventory across multiple warehouse locations
If you keep your product inventory in multiple locations in your warehouse you can manage their quantity and distribution in fulfilling customers’ orders with Delivrd’s Locations. This can be done by the accessing the Manage Locations option via Products & Inventory → Inventory List → Actions → Manager Locations as shown below.
After clicking on the Manage Locations option you will be taken to the Locations management screen where you can add a new location as shown below.
When clicking + New Location, a new window opens in which you will add the locations details.
There are two available fields, Name and Description. Name is used for naming the location of the products and Description to describe in short detail any relevant information as shown in the example below. This says the items that the customer ordered can be found on the second shelf in the north east side of the warehouse and that each order is fulfilled by one box of product.
After filling in the fields with the correct data you can save the information by clicking the green Save button.