CSV (Comma Separated Value) can be used to import products to Aronium.
Product properties
Before you begin, make sure you have product properties ready, here is the list of columns used in CSV file:
| 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 | 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 percents. Default value is 0 | Numeric | Yes |
| Price | Sell price. Default value is 0 | Numeric | Yes |
| Tax Percent | Tax value, in percents (e.g. 15). If you do not use tax, set value to 0 | Numeric | Yes |
| 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, decimal symbol must be set as a period (.)!For example, if your price price (or any other numeric value) is $12.34, it must be set as 12.34
Column header
First line of your CSV file must contain column names, as in the example attached in this article.Download a template
We suggest you to 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 prepared CSV file, open management and select "Products" section.
Right click anywhere in products area and select "Import" from context menu, or click"Import" button at the top of the screen, as show in image below.
Dialog window will open, with simple import wizard that will guide you thru products import process.
1. Select file
Select CSV file to import. Click the "Select file" button and choose a file from your computer.
2. Validate
Validates products in selected file. We use this step to prepare and validate your content, making sure there will be no issues once import is executed.
Click the "Validate" button to check and validate contents of your import file.
3. Import
Once content is validated and products are ready, click the "Import" button.
Wait until import is completed, depending on number of products, this can take a while.
Once successful, a confirmation screen will appear, with the following notes:
- Created items - number of new items being added to a product catalog
- Updated items - number of updated / changed items
- Document created - If quantities were set in CSV file, displays the number of document created during import
Click close in top-right corner of import dialog to go back to products section.
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.