What is CSV file?
CSV (Comma Separated Value) file is a simple text file that contains comma-separated values and can be used to import products to Aronium.
You can use any CSV file to import products by simply matching your CSV headers to Aronium product field names.
Product fields in CSV (Excel) file
Before you begin, make sure you understand what product fields will be used. You can find the list of columns used in CSV below.
| Column name | Description | Type | Required |
|---|---|---|---|
| Name | A product name | Text | Yes |
| Product group | Group name or group path (e.g Drinks/Hot drinks) | Text | No |
| SKU | SKU (Stock Keeping Unit) as your internal product code | Text | No |
| Barcode | Product barcode, if any. In case of multiple barcodes use pipe | as separator. | Text | No |
| Measurement Unit | Descriptive measurement unit, e.g. "pcs" | Text | No |
| Cost | A product supply price. Default value is 0 | Numeric | Yes |
| Markup | Product cost markup, in percentage. Default value is 0 | Numeric | Yes |
| Price | Sell price. Default value is 0 | Numeric | Yes |
| Tax |
Tax value, in percentage (e.g. 15). If you do not use tax, you can leave this field empty. Example: Tax1:10|Tax2:10
In the example above "Tax1" and "Tax2" are the tax names and both of them have a 10% tax rate. Fixed tax if you are using fixed taxes (not percentage), you can add a prefix "F" to the tax value, and it will be imported as a fixed tax. For example, for fixed tax of 20.00, you can enter the following value in the "Tax" cell: F20
|
Numeric | No |
| Tax Inclusive Price | Indicates whether price includes tax. Use "1" if price includes tax, otherwise use "0" | True/False | Yes |
| Price Change Allowed | Indicates whether price can be changed on POS before product sale. Use "1" if price can be changed, otherwise use "0" | True/False | Yes |
| Using Default Quantity | Indicates whether product is using default quantity. Use "1" if product is using default quantity, otherwise use "0" | True/False | Yes |
| Service | Indicates whether product is a service. | True/False | No |
| Enabled | Indicates whether product is enabled. Use "1" if product is enabled, otherwise use "0" | True/False | Yes |
| Description | Product description | Text | No |
| Quantity | Stock quantities to add to inventory | Numeric | No |
Important!
For numeric values, the decimal symbol must be set as a period (.)!For example, if your price (or any other numeric value) is $12.34, it must be set as 12.34
Column header
The first line of your CSV file must contain column names, as in the example attached in this article.CSV (Excel) template
We suggest you download a template used for product import. You can find a template attached at the end of this article.
Next, open downloaded CSV file in Microsoft Excel or use some of the online tools like Google Docs.
Fill your products details using your spreadsheet tool to match the template, export it as a CSV file and follow the instructions below.
Importing products
To import products from the prepared CSV file, open management, go to "Products" section and click "Import" button at the top of the screen, as shown in the image below.
We strongly recommend you read the formatting CSV file before you start the import process.
Column headers
Make sure your CSV file contains headers, as the first line in a file is used to display column names to map to Aronium product properties.To import your CSV file, click "Select file" button at the top of the screen.
A file dialog will appear, allowing you to select a CSV file from your computer containing products for import.
Once you have selected the CSV file, match the content to corresponding product properties.
For example, if your CSV file contains a column named "Item name" which represents product name, select "Item name" from the drop-down list right to the "Name" field. Do the same for other product properties.
Required fields
Product name is the only required field for the basic set of the data. Additional plugins may add more required fields.
Required fields are marked with an asterisk.
What happens if duplicates are found
In case products contains duplicate code or name, import will be aborted. For this reason, there are two options you can choose from.
- Skip duplicates - In case duplicate product is found, it is skipped
- Merge duplicates - In case duplicate product is found, barcodes, if any, will be added to existing product
Preview content before import
You can see preview of matched result by clicking "Preview" button at the bottom of page.
Results will be shown in table below.
Import products
Once you are ready for import, click "Import" button.
Progress dialog will appear until import is complete. Depending on number of items, import can take a while.
Once import is complete, a confirmation screen will appear, displaying the number of created or updated records.
Matching tax rates
Importing products will check for existing tax rates in your database by a tax rate value. If match is found, matching tax rate will be used, otherwise, new tax rate will be created automatically.You can always edit auto-created tax rates. Read more about tax rates here.