Please enable JavaScript to view this site.

Dotypos Cloud lets you import/export the following items from / to the Dotypos cash register system:

Products

Categories

Tags

Customers

Discount groups

Suppliers

Ingredients

Stocktaking

 

Based on your Dotypos license some items may be unavailable for import / export.  The import/export process is identical for all items. Just move in the web interface of Dotypos Cloud to Item management and to a specific list or report Ingredients overview in order to import ingredients. The heading of the page with the selected list will have the button for exporting to .xls or .csv format.

You have to subscribe to notifications from Dotypos Cloud prior to exporting data from the cash register to Excel or .csv format. The instructions for this can be found in this chapter. You can adjust the exported file and then import it back, although only in .csv format using the import button. When the adjustments have been made, you have to save the exported .xls file to the .csv format and import it back. The .xls format cannot be imported.

 

uziv_tip_icon

How to import data correctly is described in this chapter, where you can find an example of importing products and their properties using the Excel application.

We can also help you with importing into the cash register. Just download template from Dotypos Cloud and fill it out with your data. Then send this file to technical support with a request for data import. We only perform the data import using these files.

 

top

How do I import/export items to/from the cash register?

1_icon

Here is an example of the import and export of products. Then go to the item Item management » Products. Use the buttons 01 to save (export) the existing products either in .csv format or to an Excel table. To import the products, click on 02 Import.

clip0806

 

2_icon

A field will appear with the area for the import file. First, select the correct encoding 04 of the file you want to import. Then click in the area 05 to open the dialog for file selection. Now select the prepared file for import in .csv format. The file must be prepared exactly according to the stated requirements for each item (see bullets with items at the beginning of this chapter). Once you select a file, it will be uploaded to the cash register.

Click on DOWNLOAD TEMPLATE button 03 to download the template in .csv format with the sample product. This is what a .csv file suitable for import should look like.

clip0807

 

3_icon

The panel showing progress shows you when the import will be finished. The panel will show 100%. Now the file has been imported correctly. When Dotypos next synchronizes, the imported or adjusted products will be available in the touch cash register.

clip0617

 

uziv_tip_icon

Once you have clicked on the Import button, you will be able to click on DOWNLOAD TEMPLATE to download a basic template (see image above), a sample file that can be used to re-import once the data has been completed. This template already contains all the required columns, so all you need to do is add the data (in this case your product’s properties).

dulezite_sdeleni_icon

Always use this adjusted template or a modified exported file for imports. The imported file has to be in .csv format as the import of .xls(x) files or files in other formats is not supported! Never import your own files because it could harm the database’s data structure!

If you want to amend the .csv file in Excel, the columns with numbers productId, categoryId, ean, plu and others must be in the Text format. If not, the file will either not be imported at all or imported incorrectly. You can find the format settings in this chapter.

Keep all columns in the file for import even if they contain no data. Do not delete columns with no data. The file encoding must be either UTF-8 or Windows-1250 (CP-1250) to avoid any incorrect display of diacritics.

The supported types are .csv files separated with ; (semicolon) and , (comma). If you use the semicolon, you can use a comma or period to separate decimal places. If you use a comma as a data separator, you must use a period to separate decimal places.

top



This manual is for information purposes only and does not provide any warranty. The given specifications may be changed without prior notification. Illustrations and schemes are for information purposes only. The appearance and functions of both the device and software may differ based on the current version of the product and applications.

Created with from Dotypos. ©2024 Dotykačka ČR s.r.o.

  


Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC