Stock up

<< Click to Display Table of Contents >>

Stock up

Navigation:  Dotypos Cloud > Item panel > Warehouses >

» Available only in Dotypos FULL and higher. «


In the item Warehouses » Stock up you will find an overview of performed stock ins, by default sorted according to date. Click in the pop-up menu 01 to choose the warehouse you want to stock in. Products will then be stocked in with the button Stock up 03. Use the buttons 06 to look into the details of the performed warehouse operations or to save the details in a .pdf file. Use the button Update 07 to stock in other products into an already finished stocking in. Use the button 02 to limit the stock in to a selected date or time period. To set the time period, have a look at this chapter.

Export the whole overview with the buttons 04 to an Excel table or a .csv file. In the case of every stock in, click on the supplier 05 and open its properties.




You can also perform a batch stock in by importing an electronic delivery note. You can find more information about this option in this chapter.


How to stock in products


In the item Warehouses » Stock up , click on the button 01 Stock up (see the figure above). This opens the page with product stock in options.



In the product stock in page use the pop-up menu to 01 filter the displayed products pursuant to the selected category. Use the button 02 to select the products to stock in. The selected products will be moved to the right-hand side, where they can be modified. The moved products on the right side “fade out,” so you can easily recognize what was moved for stocking in.



From the pop-up menu 03 select the potential supplier to be assigned to all stocked products. By turning on the switch 04 you can also stock in with a backdate. However, for products stocked in with a backdate there must not exist any more recent stocktaking.

Switch Adjust purchase price 05(if enabled) includes the entered purchase price in the average purchase price of the product. With every product add to the field 06 the stocked in quantity and save the changes by clicking on Stock in in the bottom part of the page.

Purchase price means the product purchase price per sold unit. For example, when you stock in 10 one-liter wine bottles, you just stock in the price for a 1-liter bottle. However, if you stock in 0.7-liter bottles, you have to recalculate the purchase price to one liter and then insert the recalculated price.

If you enter a negative quantity to be stocked in (e.g. -10), you are making a correction and the entered quantity will be deducted from the quantity of the relevant product in stock.

Any product you do not wish to stock in can be removed using 07.

The batch import of products with the help of a template 09 is described in the guide below.

The buttons Recalculate sell price and Just warning 08 are related to the check, or automatic calculations of the set margin. For more information, see the chapter Settings and using of margins.



You can also stock in directly on the page with the product overview. You can find this sequence in this chapter.

You can continue stock in later. By continuing stock in, the same supplier and same invoice number are preset, so the items stocked in will be added to the same stock in report.


How to perform a batch stock in of products

Dotypos also allows the stocking in of products in bulk using the import file. Electronic delivery notes from more suppliers are also supported.


Click on the button Import 01 to display the import options on the page. If you have the import file ready, upload it with the button Browse...04. If you import the stock in list from the supported suppliers, do not forget to select the right supplier from the pull-down menu 02. So Dotypos recognizes the file structure from this supplier and performs the stock in. It is important that products in the cash register have the same EAN code as the products being stocked in.

The following Czech suppliers are currently supported:





GECO / GECO picking list

Makro order / invoice

Bidfood invoice / delivery note



If you do not have the products from PEAL in your cash register created yet, they can be added using batch import from the prepared file.

If you are importing for the first time or you are not sure about the format of the import table, download the template sablona.csv 03 and fill out the table accordingly (a description of the individual fields can be found under the picture below). Select this saved table with the button Browse...04.




After selecting a CSV file 01, click on the button Upload 02 and the items in the import file will be shown in the bottom part of the page 03 for further editing. When you are done, stock in the items using the button Stock up 04.




When importing a stock in, Dotypos verifies whether products in the file for stock in correspond with products in the cash register. If they do not correspond, a dialog with unpaired products is displayed. In this dialog, unpaired products can be stocked in to current products (you can search them and then use the button Assign to stock in/assign to a product) or created as new products and then the unpaired (unknown) items can be stocked in to newly created products. You have to assign the unpaired products to a new or existing product.




How Dotypos calculates the purchase price?


Note: Dotypos does not use FIFO to calculate the purchase price.


Description of import file columns

When importing stock in, the products in the cash register are paired on the basis of ean, plu, externalid or productid. So when a product is found in the cash register by one of these criteria, it will be stocked in using data in the next columns of the import file.

The stock in import checks duplicate items. When a duplicate item in the import file is found, an error message will be displayed.

Import file for batch stock in of products


product code


product code


external product ID (selected by the customer, can be found in product details).


product ID (system-generated, can be found in product details).


Purchase price excluding VAT


Total purchase price


Sale price


Product quantity

The required items are marked in bold, other items (data) are optional. The only mandatory field is either ean, plu, externalId or productId. If the product cannot be found by ean, it is looked for by plu, then by externalId and productId.


The import file can look like this:




Please remember that products cannot be imported with the disabled option Deduct from stock.




The guide on how to correctly import a .CSV file into MS Excel can be found here.


How to display a list of corrections?

The warehouse correction list (write-offs) displays the total value of written-off items. In the upper bar, select Corrections 01 and after selecting a warehouse 02 and setting the time frame 03 the list of the performed corrections will be displayed. If you want to display the details of the selected correction, click on the button Detail 04. The selected correction can be saved in a .pdf file.



Page displaying details of selected correction:




Warehouse corrections are also displayed in the warehouse report Warehouse operations.