Inventory management

This is an extension to the Clothing Registration system and has an additional cost of €99 per year.

We offer two subscriptions, namely the Clothing Registration system with and without the stock management included.
 

If your club is already using the Clothing Registration System and would like to add the inventory management, you can log into your account on this website and upgrade the subscription.

What is it and what are its functions?

With the inventory management, you guessed it already, you can manage your inventory. The system automatically reads how many items of clothing or materials have been handed out, handed in and are no longer usable. It does this for all 3 standard lists, so the "clothing per member, the team bag and the materials list are read out and included in the inventory management. If the same item is found in several lists, for example a presentation suit size XL, these are added together so that in the inventory management you only get one line for the presentation suit XL.

Click on the red dots for more information.

Download

Download the required data here. The download depends on the filtering. If the filtering is empty, you will download all the data, if you filter on ‘Presentation suit’ + size ‘XL’, for example, you will only get that in the download.

Item column

As soon as an item/garment is selected in 1 of the forms, it will automatically appear in this list.

Size column

This is where the sizes come in. If an item has no size, ‘N/A’ will automatically appear. will appear.

Inventory column

Here you can enter the initial stock and, if desired, the price per item.

So for example, as soon as a Presentation suit size XL is lent at the Clothing per member list, it will be visible in the list with an End Inventory of -1.... Then click the Change button to fill in your starting inventory and price.

So this inventory is the total the club has of this item. If you start the season with 400 pieces and halfway through you order another 250 pieces, you change the inventory to 650 pieces.

Handed out

This is the total number of handed out of this item. So this number is subtracted from your inventory and the result is displayed in the in stock column.

Handed in

This is the total number of Handed in of this item. This number is added back in to stock and the result is displayed in the In stock column.

No longer usable (NLU)

If an item has been handed in by everyone and its rules have been removed, Handed out, Handed in and NLU should be set to 0 here and then you can also remove this rule here.

THIS ACTION CANNOT BE UNDONE AFTERWARDS.

If you delete a line by mistake while the items are still in the system, the item and its status are simply reloaded when you refresh the page. However, the initial inventory and price per item must be entered again.

Value overview

Should you have entered a price per item, you can see the value of your starting inventory, handed out, handed in items and the total value of you item in stock.

In stock

This shows what your current inventory of items/garments is.

Search by name

Search here by item name, so for example ‘footballs’ or ‘Presentation suit’, etc.

Search by size

The search term must be exact. So if a size is in the system as 128 - 134, you can only find it if your search term is also exactly the same including the spaces.

So on 128-134 the system finds nothing. The search term is not case sensitive... so both XL and xl are found correctly.

Search

If you want to search by item or size, click this button or press Enter on your keyboard for search.

Clear

This allows you to clear the search windows again.

Delete

If an item has been handed in by everyone and its rules have been removed, the Lent, Handed in and NMB should be set to 0 here and then you can also remove this rule here.

THIS ACT CANNOT BE REMOVED AFTER that.

If you delete a line by mistake while the items are still in the system, the item and its status are simply reloaded when you refresh the page. However, the initial inventory and price per item must be entered again.

What information is collected?

In the inventory management system, the item, size and condition are automatically retrieved from the Clothing Registration System. If an item, for example a Presentation suit size S, has never been handed out, it will therefore not appear in the inventory system either.

You cannot delete items or change anything in the Clothing registration system with the inventory management! So if you click the red cross to delete something and the item still appears in the Clothing per member, the Team bag or the Materials list, the line immediately returns in the inventory management. In short, the inventory management is synchronised with the Clothing registration system and not the other way around.

What can you add yourself in the inventory management?

So as soon as 1 item is borrowed from something, it will appear in the list and you can also add the (initial) inventory and a price per item under the ‘Edit’ button.

You will then see this pop-up where you can fill in the 2 fields and save them. If you don't work with prices, you can just leave that field blank. You can change this data at any time. So if you get 100 new footballs halfway through the season, just change the 500 to 600 and you're done.

View data per item

If you click on the Value Overview button (see image), a pop-up opens. In it, you can see the total values at a glance.

Example of the pop-up::

Download as CSV file

If you click the ‘Download CSV’ button at the top of the overview, you can download an Excel file containing all stock-related data. So for each item you get a line showing stock, handed out, handed in, no longer usable and all price values. 

If you want a quick overview of the Presentation suits, for example, filter this and use the download button. You will then only get the Presentation suits in your Excel.

Upload CSV file

When you have downloaded your inventory overview, you can complete the csv file with the initial inventory and price of the items/garments and upload them into your inventory management via the upload function in one go.

Please note! You cannot add new items/garments (or set them to handed out, handed in or no longer usable) through this method. That data is determined by the lists of the Clothing Registration system itself.

Order now