Consignment Stock

Consignment Stock

You may sell consignment stock, or commissioned goods (typically from a local supplier) and want to keep track of the products through sales and potentially receiving/returning stock. There are a few potential ways to handle this in Retailer, using different setups, with their own benefits and limitations.

The three main ways are shown below, and since they are not mutually exclusive, you could mix them together to get something that works for your business. For all three methods, you can also arrive/receive stock through Invoice Arrivals, and Returns of the item can be done through Invoice Arrivals, without much change.
Click THIS for more general information on returning stock using Invoice Arrivals.
When doing arrivals and returns of consignment products, consider the following. If you need to see quantities on hand of the product in the system when you sell, you will need to arrive, or manually adjust the product quantities. Then, process returns on the products later. Alternatively, you can sell into negatives, and only arrive the final quantities of product later.

Using Supplier

A particular supplier can be assigned as a consignment supplier (or multiple suppliers). You can differentiate them simply by adding 'Consignment' to their names (or in any other effective manner).
Many reports in Retailer (such as Supplier Sales Analysis and Stock Listing Report) can be set to run for and exclude certain suppliers. The same can be done in stock ordering so this may be the easiest one to implement.
The limitation is that certain reports like the Detailed Takings report cannot be told to include/exclude particular suppliers.
The benefit is you can continue organising stock in Departments and Categories that are mixed with other, non-consignment stock. Carrying a larger amount of consignment products is also fine with Department names and stock tags on reports still meaningful and descriptive of the product itself.
Click HERE for information on how to set up a supplier.

Using Department

A particular department can be setup as a Consignment department, specifically used for holding items on consignment. This department could be named to include the word 'Consignment' to differentiate it, and can also be marked as an Agency Department. Agency Departments have the added feature of being able to be excluded as a tickbox option on many reports (e.g. Detailed Takings Report).
This can mean that the Department name is not as meaningful or descriptive of the products, which should be fine for small numbers of consignment products that are quite similar.
Many reports can be run to exclude Agency Departments (if used here) which can be very helpful. This includes the very useful Stock Listing report, which gives you a total stock value on hand.
Click HERE for information on how to set up a Department.

Using Stock Tags

Stock tags can be created to track products on consignment, and you can have as many as is meaningful to your business without impacting or bloating reports and information.
E.g. Kitchenware Consignment tag, Foodstuff Consignment tag, Fashionwear Consignment tag.
These will need to be assigned to the relevant products.
The main drawback with this is that reports are only going to be able to include these products based on tags. The reports cannot exclude items based on these tags so if you need to run particular reports and easily exclude consignment products, this method may not be suitable.
The big advantage in using tags is allowing your products to be assigned to meaningful Departments together with other product. Any reports that use tags (e.g. Stock Listing report, Detailed Takings report) will also find it easy to list these products, and potentially show subgroups of the consignment products (if more tags were added) or include other products that have similar tags.
Click HERE for information on how to set up stock tags.


    • Related Articles

    • Supplier Stock Listing

      The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing ...

    • General Stock Listing

      The General Stock Listing Report lists selected stock items by department/category as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing stock with a ...

    • Stock Screen - Changing Details on Stock Items

      All aspects of a stock item - its name, prices, barcode, quantity on hand, stock code etc. - can be changed at any time. This is done through the Stock Screen, which is one of the most important screens in Retailer and one you will see a lot. The ...

    • Creating a Stock Item

      We have a video guide on adding a stock item into Retailer - ? Adding Stock items Creating a Stock Item If the stock wizard does not appear when you click the Add button, click HERE to enable it. The stock wizard can be accessed through several ...

    • Static Quantity (Service item)

      Static Quantity is a feature that allows you to freeze the quantity on hand of an item at 0. This is intended for service-based items like engraving or Gift vouchers. This will assist you with reports and identifying discrepancies in the QOH for live ...