User Guide: Importing Products via Excel
As always, please contact support@hexicomsoftware.com for assistance
Products can be entered into the system manually or imported in bulk using a specific Excel spreadsheet.
There are two steps to importing products:
- Enter the products into a specific Excel spreadsheet (attached to this article).
- Upload the Excel file into the system.
Files Attached to This Article
Products_Blank_Import_Template.xlsx(Recommended): A clean, empty spreadsheet containing all 88 column headers in the exact order required by the system. Download this file to enter and upload your new product catalogue.Product_Import_Sample_Template.xlsx: An editable sample file containing 2 pre-populated products (a stocked reflective sign and a custom print-on-demand decal kit). Use this file as a reference to see how pricing matrices, inventory quantities, and HTML descriptions should be formatted.
Important Notes:
- Do not add, delete, or rearrange columns from the spreadsheet.
- Do not edit the column labels / headers.
- Save the file with the extension
.xlsx(recommended) or.xlsformat only. (Do not convert to.csvas commas and multi-line descriptions can shift columns and cause import errors).
Step 1: Prepare Your Spreadsheet
- Open
Products_Blank_Import_Template.xlsx(or openProduct_Import_Sample_Template.xlsxto see working examples). - Enter the products to be uploaded row by row, keeping in mind the following formatting rules:
- Save the completed file with the extension
.xlsx.
Critical Formatting Rules (Avoid Import Errors)
| Column Name | Expected Format | Allowed Values & Rules |
|---|---|---|
| Item Code | Text | Max 50 characters. Must be unique for each product. If left blank, the system will auto-generate an Item Code. |
| ShortDescription | Text | Max 4,000 characters. Used for store cards and search previews. Keep it concise. |
| ItemDescription | Text / HTML | Supports full product details and standard HTML tags (<br>, <b>, <ul>, etc.). |
| UserArtworkFileCount | Number (Integer) | ⚠️ Must be a number (e.g. 0, 1, 2). Never enter words like "No" or "None", or the import will fail with a format error. |
| Quantities & Prices | Numbers only | Columns such as FromQuantity, ToQuantity, Price, Sellingprice, Weight, Width, Height, and Length must contain numeric digits only. Do not include currency symbols ($) or unit letters (kg, mm). |
| Store & Visibility Flags | Yes / No | Columns such as ProductVisibletoStore, Show Print Ready File, ShowStock, ShowPriceSubTotalTax, IsCustomerCode, and IsItemCode strictly accept Yes or No. |
| IsStockProduct | 1 / 0 | Enter 1 if you track physical inventory/stock, or 0 if produced on demand. |
| StockQuantity | Number (Integer) | Starting stock balance (e.g. 50). Required if IsStockProduct is 1. |
| CustomField1 | Text | Warehouse Location name (must match your warehouse location names in the system). |
All column input fields found here - Product Import Columns
Step 2: Upload Your File into the System
- In the main navigation, click Products, then select Import/Export.
- Under Upload File to Import, click Choose File, then attach the file that was saved in Step 1.
- Under Duplicate Records, select either
IgnoreorUpdate:Update(Recommended): If the product already exists in the system, choose Update; otherwise, existing products will not be updated.Ignore: If an Item Code already exists, the record will be skipped and will not be altered.


Notes on Item Codes:
- When completing the Excel spreadsheet, the Item Code is a unique field. If the Item Code is blank, the system will generate a new Item Code for the product and create it as a new product.
- If an Item Code is entered that already exists in the system, the system will update the record, unless you have chosen to ignore duplicate records.
- Partial Updates: If you have many products in your Product Catalogue, you don't need to update them all at once. You can import a file with a select few products that you want to update; other products not included in the file will not be altered in any way.
Step 3 (Optional): Bulk Upload Product Images
The Upload Products Thumbnail option is used to attach image files to the products being uploaded. The following guidelines apply to bulk uploading images:
- Upload Timing: Images must be uploaded at the same time the Product details file is uploaded (refer to Step 2).
- File Naming: Each image file must be named according to the Item Code of the product it belongs to (e.g.
TEST-VOLT-11KV-001.jpg).- The filename (and therefore the Product Code) must not contain special characters such as underscores, commas, or periods.
- Format: Image files must be in standard
.jpg/.jpegformat. (Currently.pngfiles cannot be imported using the bulk import function; if you are unable to bulk change your images, contact Support and we can assist you). - Dimensions: Each image should be no more than 300px in width or height, as there is no automatic resizing done during the upload process.
- Folder Structure: Images must be in the root folder of the zip archive (the top level in the folder hierarchy).
- If you are using an Apple/Mac computer, ensure that hidden operating system folders (such as
__MACOSX) are not included in the zip file.
- If you are using an Apple/Mac computer, ensure that hidden operating system folders (such as
- New Products Only: The bulk import of images will only work for products being created for the first time, not for products that have already been created and are merely being updated.
To upload, create a single .zip folder containing all images. Under Upload Products Thumbnail, click Choose File, locate the zip folder, and click Import.

Import Completion & Processing Time
- An on-screen message will appear to notify you that the import has been submitted successfully.
- The import runs as a background process and may take up to 10 minutes to complete.
- Upon completion, we will send an email confirmation summarising the total lines imported, products created, and products updated.