Data Exchange (Custom Data Imports)

Importing and Exporting Custom Data Files with KORONA POS

First, we must ensure KORONA POS is set up to import CSV or Excel files. Go to the data exchange panel by navigating to Settings > Data Exchange.

Here, we will need to add the type of file you are planning to import. If you are using .CSV files, type “CSV” into the text field and click the +Add button. You can also follow this process for Excel (.XLS) files. Just type “Excel” into the line instead.

You will now be able to import and export CSV and Excel files from KORONA.

*Note: If you are going to be repeatedly importing the same fields, either for new products or existing products, please feel free to contact support. We can make a format file for you so that you do not have to select the mapping each time you import manually.

Importing Data Files into KORONA POS

Click the Import button on the box for the file type you want to import. If the import option is unavailable, you must make it so. This is explained in the section above.

You will be presented with a selection drop-down popup box. Select Customand click the Select button.

You will be taken to the import screen. Click on the Browse buttons on both the File and Formatting fields and select the file that you want to import. If you are importing a CSV, you will see a third field for Encoding. Leave the Encoding drop-down toAutomaticto reduce the possibility of importation errors.

Once you have selected your file, click the Upload button at the top of the screen.

Next, you will be taken to a screen where you can determine how KORONA POS imports the data from your File.

Select the Data Category and fields using the drop-down menus and assign them appropriately. You can also have KORONA POS ignore certain fields if needed.

The field assignment options vary based on whether you are importing a CSV file or an Excel Spreadsheet.

If you are importing an Excel file, you will need to assign the Data type to the content.

If you are importing a CSV, you will need to assign both Data Categories and Data Fields to your Content.

*Note: If your import file has column headers, you will need to tick the Skip First Line check box to ensure that there are no errors with the import.

Running Import and Available Data Category/Fields

On this screen, you will want to choose your Data Category and Data Field. We will cover a few of those data selections in this section. When finished, click Run import. You will see a popup box saying “Loading data.” When it is completed, you will see the results of the import.

Click on any of the headers to expand the information on what has been imported. There are a few additional things to go over.

If all of the products in the file are new, there’s no need to create/map product numbers, as KORONA POS will auto-generate new numbers at the end of the product file, ensuring no products are overwritten. However, it is still recommended that you add Product Numbers anyway, as the system-generated numbers start at 1 and can often be easily accidentally rung up by cashiers.

Minimal Product Import: To view the minimum requirements for importing products into KORONA POS, please visit our Minimum Product Import manual page.

Import Prices into Specific Price Group: Before importing prices, especially if you have multiple pricing for your stores or customers, you will need to specify which price group these prices are under. You will need to create a new column in your Excel/CSV file. It is recommended that you use and name that column Price Group Number. That way it will filter the prices into the designated price group by their assigned number instead of the name.

*Note: If you have multiple price groups for your products, you will want to do multiple imports for those specific price groups.

Product

Product Number: The number listed under the item and found at the checkout can be this number. This number is already in correspondence with the product and will be updated when the product is updated. If the number is unavailable, the product is displayed using the created or last known version.

Product Name: Item Name

Product Code: Additional code next to the item number, which can be an EAN, a PLU, or any other number with which items can be found.

Product Code Quantity: Belongs to the product code and describes the set of multiple packaging for which there is an EAN. Ex .: Cigarette rod with 10 boxes.

Product Retail Price (Date): The selling price of the product as of the date of import.

Store Price: Your store’s selling price (overrides retail price) of the product

Product Code Price: If the bulk item price is not equal to the individual item price, this is where that price is located

Product Code Description: Sets the description for the particular product code, such as 12pack, Single, etc.

Price Changeable: Indicates whether a price can be changed if there is no price. This product becomes an “Open” product where the price must be entered by the cashier.

Min Retail Price: If the price can be changed, this value specifies the minimum price.

Max Retail Price: If the price can be changed, this value specifies the maximum price.

Discountable: This is a yes / no field whether this product is manual or by price rules. Alternatively  0 = No, 1 = Yes

Product Description: A description text for the item. This can be on the checkout if desired.

Receipt text: If this field is imported, this text will appear on the document instead of the product name.

Allergens: Potential allergy triggers

Additives: Artificial flavors or dyes

Manual: How-to guide

Order Text: This will print on your production receipt.

Ingredients: List calories, fat, cholesterol, etc., per serving.

Nutritional Value: Text field containing

Care Instructions: Any product-specific instructions for best care

Recipe: You can list the necessary steps to cook a product.

Certificate: FEC, FDA approval (milk has these a lot of times), or other sign of approval.

Warranty Text: Warranty terms on customer receipt

Information URL: Any URL containing images or information about your product should be entered here.

Manufacturer: Information about the device manufacturer or supplier to display on customer receipt.

Product Purchase Price: This will be the Last Purchase Price, located above the supplier line inside of the product “Last PP.”

Product Cost: This will be the Additional Costs field for any additional charge on top of the product purchase price. This is located above the supplier line next to “Last PP,” called “add. costs.

Product Listed: Use 0 = No, 1 = Yes, or you can just input the text no or yes.

Product Track Inventory: Use 0 = No, 1 = Yes, or you can just input the text no or yes.

Product Force Personalization: If you are setting up a gift item you would check this box. Use 0 = No, 1 = Yes, or you can just input the text no or yes.

Product Base Unit: Type of measurement desired (gal, cu. in.)

Product Packaging Quantity: How many products go into a package.

RRP: The manufacturer’s suggested retail price, also known as the MSRP.

Deactivated: 0 = No, 1 = Yes, or you can just input the text no or yes.

Label: Text to be displayed specifically on a label print.

Quantity Denomination: The amount of products are sold per purchase.

Sales Lock: An item that may be received but not sold. It is commonly used for items that have a specific launch date.

Supplier Item Number: The number the supplier uses to pull/identify the product.

Supplier Package Item Quantity: The number of products you receive in a package from the supplier.

Supplier Package Description: Any text information your supplier uses for the product.

Supplier Container Price: The amount paid to the supplier for a case of the product. Must also be used with Supplier Package Item Quantity.

Supplier Item Price: The amount paid to the supplier for the product, sets the price on the Supplier line inside of the product.

Reorder Level:  Minimum stock of a product in a warehouse. If this value is below the reorder value, the product is included in the order proposal. Must be imported together with the organization number (warehouse) as the stock per warehouse applies.

Maximum Stock Level: Maximum stock of an item in a warehouse until the item is filled in an order. Must be imported together with the organization number (warehouse) as the stock per warehouse applies.

Bin Location: The code assigned to the location where an excess stock of an item is kept, such as a backroom location or an under/over-stock location.

Assortments

Assortment Number: Each item is assigned to an assortment. If the name is not specified, the product will be included with the assortment To the number 1.

Assortment Name: As an alternative to the number, the name of the assortment can be changed too.

Organizational Unit

Organizational number: Number of an organization. Only for the import of branches. There is no product reference.

Organization name: Name of an organization. Only for the import of branches. There is no product reference.

Inventory Receipt

Inventory Count: This is the total count for the stock level quantity of your products in your inventory. This should be used only for importing inventory counts.

Stock Order

Order Package Quantity: Packaging content at the supplier. 10 for 10 items in a single package

Stock Adjustment

Article Amount: The amount being adjusted in negative or positive.

Commodity Group

Commodity Group Number: Independent second item of the product group. This can be at the use of supplier lists for importing the assignment to the own product group structure. Ex: own Product group 1 = Snacks, supplier category 34 = Snacks; The product group key in the product group configuration is then 34.

Commodity Group Key: Reference number to the product import

Commodity Group Name: Name of product group. The number and the name can also be merchandise categories without products being imported.

Info Text

Import of any info text. The info text can be assigned to both products as well as cash or changed manually.

Producer

Producer Number: Number assigned to the producer

Producer Name: Name of producer

Store Orders

Order Quantity: The amount of orders you are placing through the store order.

Ticket Definitions

Ticket Definition Number: Number assigned to the ticket

Ticket Definition Name: Ticket Name

Parent Commodity Group

Parents Commodity Group: The Parent Commodity Group is a top level department. It can have multiple sub-groups of other Commodity Groups, for example, “Liquor” could be the Parent group of Commodity Groups like “Vodka”, “Whiskey” or “Tequila”. When importing, you will need to designate both the Parent Commodity Group, and any Commodity Groups you would like to be a sub-group of the parent. You will need to use one of the below options to designate which group is the Parent. (Note: Parent Commodity Groups cannot share exact names with Commodity Groups.)

Parent Commodity Group Number: Number of the superior department.

Parent Commodity Group Name: Name of the superior department.

Parent Commodity Group Key:  Reference number to product import

Supplier

Supplier number: Number of the supplier (no order number)

Supplier Name: Name of the supplier

Company Name: Sets the company name of the supplier / if different from the Supplier Name.

Contact Person First Name: First name of your supplier representative

Contact Person Last Name: Last name of your supplier representative

Contact Person Telephone Number: Phone number of your supplier representative

Contact Person Email: Email address of your supplier representative

Contact Address 1: First address or primary address of your supplier representative

Contact Address 2: Second part or secondary address of your supplier representative

Contact Zip/Postal Code: Zip Code / Postal Code for your supplier representative

Contact City: City where the supplier is located

Contact State: State where the supplier is located

Contact Country: Country where the supplier is located

Price List

Price Group Number: Number of the price list for which a product price is to be imported. If no number or name of a price list is specified, the product is assigned to price list 1. If several price lists are to be imported, a line with the respective price must be inserted for each price list.

Price Group Name: Name of the price list for which a product price is to be imported.

Sector

Sector Number: Number for the sector that is to be imported

Sector Name: Name of the sector that is to be imported

Alternative Sector

Alternative Sector Number: Number for the alternative sector that is to be imported

Alternative Sector Name: Name of the alternative sector that is to be imported 

Tag

Product Tag: Importing any tag the product would be under
*Note: you can only do 1 tag at a time. Multiple tags would need subsequent imports

Customer Information

Number: Number of a customer. Customers can be created or searched at the checkout. With the help of customers, documents can be assigned to a customer.

Last Name: Customer Last Name

First Name: Customer First Name

E-Mail: Customer E-Mail address

Address 1: First Address line for the customer

Address 2: Second Address line for the customer (if available)

Postal code: Customer Zipcode

City: Customer’s City

Country: Customer’s Country

Telephone: Customer’s Telephone number

Gender: Customer’s Gender

State: Customer’s State

Birthday: Customer’s day of birth

Information: Additional information about the customer

Customer Company: Company the customer works for/owns

Accepted Privacy Policy: Any policy the customer has accepted

Permission to contact for marketing: Yes or no to contact for marketing purposes

Customer Group

Group Name: Name of a customer group. With the help of customer groups, price rules can be applied, or evaluations about the turnover of different customer groups can be made. The customer group must be set at the cash desk for each document. Example: Customer group “Tutor” receives a 20% discount on standard prices.

Group Number: Number of the Customer Group

Cashier Information

First name: First name of the cashier

Last name: Here, you can transfer cashiers to the system with the surname. Since the cashier also appears on the receipt, this is often anonymized with a letter.

Number: Number of the cashier

Login: PIN code for registering at checkout or key number. Use of a waiter’s lock.

Email: Cashier’s Email

Role Number: The role number assigned to the cashier

Deactivated: If the cashier has been deactivated/no longer works for the company.

Gender: The gender of the cashier

Password:  Any password set for the cashier to use for login

Alias: What you wish to be displayed for the cashier’s name on the receipt other than their full name.

Exporting Data File from KORONA POS

To export a file, you will need to click on the export button in the file type you wish to create. Once you have clicked on that button, you have the option to select what data you would like to have exported. After you have made your selection in the drop-down menu, click continue. Your browser will then download the file containing the data.