Product Import Spreadsheet — Complete Column Reference & Data Dictionary
When importing products in bulk using the Products_Blank_Import_Template.xlsx or Product_Import_Sample_Template.xlsx, the import system reads the spreadsheet by exact column position (Columns 1 through 88).
IMPORTANT
Strict Spreadsheet Rules:
- Do not insert, delete, or rearrange columns.
- Do not rename or remove the header row.
- Save as
.xlsx(recommended) or.xlsonly. Do not export as.csv. - No text or symbols in numeric columns. Do not put
$,kg,mm,No, orN/Ainto numeric fields.
1. Product Identification & Ownership (Columns 1 – 10)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 1 | Item Title | Text | Unlimited | Product name/title displayed in the catalogue. (Required) |
| 2 | Item Code | Text | Max 50 chars | Unique SKU/Product Code. If left blank, the system auto-generates one. |
| 3 | Category Name | Text | Max 50 chars | Product category name. If it does not exist, the system creates it. |
| 4 | CustomerCode | Text | Max 100 chars | Customer-specific part or reference code. (Optional) |
| 5 | Supplier | Text | Max 100 chars | Supplier name. Must match an existing supplier in your system. |
| 6 | SalesTaxRate | Text | Text code | Tax identifier (e.g. GST). Matches tax rates configured in your system. |
| 7 | Product Type | Text | Specific keywords | Accepted values: Editable, Non Editable, Stock item, or NonEditableStock. |
| 8 | Ownership | Text | Keyword | Self (owned by your company) or Client (owned by a customer). |
| 9 | Customer | Text | Text / Comma-separated | All, NotAllocated, or specific customer company name(s). |
| 10 | Excluded Customers | Text | Comma-separated | Customer company names who are restricted from viewing/ordering this item. |
2. Product Specifications & Production Details (Columns 11 – 21)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 11 | Description | Text | Unlimited | Primary internal specification description. |
| 12 | Date Approved | Text | Max 2,000 chars | Artwork / proof approval status (e.g. Approved., 2026-10-15). |
| 13 | Colour | Text | Max 2,000 chars | Print colour specifications (e.g. Single Sided Print: Full Colour, CMYK + White). |
| 14 | Size (W x H) | Text | Max 2,000 chars | Dimensions as displayed on specification sheets (e.g. 100 x 50 mm, A4). |
| 15 | Material | Text | Max 2,000 chars | Stock/substrate description (e.g. 1.6mm Aluminium with Class 1 Reflective). |
| 16 | Scheduling | Text | Max 2,000 chars | Delivery / lead-time details (e.g. Standard 3-5 Days). |
| 17 | Finishing | Text | Max 2,000 chars | Bindery / finishing requirements (e.g. Singles, Trim to size, Laminated). |
| 18 | Cautioned | Text | Max 500 chars | Pre-press caution / proof notes (e.g. Small text may be hard to read). |
| 19 | Pack Install | Text | Max 500 chars | Packaging or installation instructions (e.g. Packed in cartons of 50). |
| 20 | Press file | Text | Unlimited | File path or name of the master print file (e.g. PRINT_DECAL_100x50.eps). |
| 21 | INTERNAL prod. notes | Text | Unlimited | Internal instructions for machine operators. |
3. Pricing Matrix & Physical Shipping Dimensions (Columns 22 – 30)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 22 | Price Matrix Type | Text | Keyword | Price Band, Simple Matrix, or Signage Matrix. |
| 23 | FromQuantity | Decimal | Number only | Starting quantity for this price bracket (e.g. 1). |
| 24 | ToQuantity | Decimal | Number only | Ending quantity for this price bracket (e.g. 10000). |
| 25 | Price | Decimal | Number only | Unit cost price (e.g. 8.10). Do not include $. |
| 26 | Sellingprice | Decimal | Number only | Unit retail/selling price (e.g. 12.50) or Markup % if column is headered Markup. |
| 27 | Weight | Decimal | Number only | Product weight in kilograms (e.g. 0.25). Do not include kg. |
| 28 | Width | Decimal | Number only | Physical width in millimetres (e.g. 100). Do not include mm. |
| 29 | Height | Decimal | Number only | Physical height in millimetres (e.g. 50). Do not include mm. |
| 30 | Length | Decimal | Number only | Physical length / depth in millimetres (e.g. 2). |
4. Webstore Display & Customer Options (Columns 31 – 42)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 31 | ProductVisibletoStore | Yes / No | Yes or No | Controls whether the item appears in the online ordering portal. |
| 32 | ShortDescription | Text | Max 4,000 chars | Plain text keywords / summary used for search indexing and product cards. |
| 33 | ItemDescription | Text / HTML | Unlimited | Rich HTML product description shown on the product detail page. |
| 34 | Allow user to upload artwork file | Yes / No | Yes or No | Allows customers to attach custom files during checkout. |
| 35 | UserArtworkFileCount | Integer | Number only | ⚠️ Must be a number (0, 1, 2). Never enter "No" or text. |
| 36 | UserArtworkFirstRowMandatory | Yes / No | Yes or No | Requires customer to upload at least one artwork file before checkout. |
| 37 | Show Print Ready File | Yes / No | Yes or No | Makes print-ready proof link visible to customers. |
| 38 | ShowStock | Yes / No | Yes or No | Displays live available stock balance on the store. |
| 39 | ShowPriceSubTotalTax | Yes / No | Yes or No | Shows tax and subtotal breakdown on store product page. |
| 40 | ShowSoldInPacksOf | Yes / No | Yes or No | Displays pack quantity restriction notice. |
| 41 | AllowGroupRun | Yes / No | Yes or No | Allows gang/group manufacturing runs. |
| 42 | Enable Cumulative Pricing | Yes / No | Yes or No | Applies cumulative bracket calculations (only used with Simple Matrix). |
5. Custom Attributes (Columns 43 – 67)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 43 – 67 | CustomDescription1 through CustomDescription25 | Text | Unlimited | 25 custom descriptive fields for customer specs, job tracking, or cost formulas. |
6. Accounting, Cubic Freight & Inventory (Columns 68 – 81)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 68 | AccountingCode | Text / Number | Lookup Code | General Ledger / accounting code (e.g. 243) matched against tb_AccountingCode. |
| 69 | CBMHeight | Decimal | Number only | Cubic freight height (m / cm). Defaults to 0. |
| 70 | CBMWidth | Decimal | Number only | Cubic freight width (m / cm). Defaults to 0. |
| 71 | CBMLength | Decimal | Number only | Cubic freight length (m / cm). Defaults to 0. |
| 72 | CBMWeight | Decimal | Number only | Volumetric / cubic freight weight. Defaults to 0. |
| 73 | CubicMeasurement | Decimal | Number only | Total cubic volume measurement (m3m^3m3). Defaults to 0. |
| 74 | IsStockProduct | 1 / 0 | 1 or 0 | 1 = Physical stocked inventory (draws stock).0 = Print-on-demand / non-stock item. |
| 75 | StockQuantity | Integer | Number only | Starting inventory count. Enter 0 if not tracking stock. |
| 76 | CustomField1 | Text | Warehouse Name | Primary Warehouse Location (must match an active warehouse in the system). |
| 77 – 81 | CustomField2 through CustomField6 | Text | Custom Text | Warehouse bin, aisle, shelf, batch, or lot numbers. |
7. Machine Routing & Store Behaviours (Columns 82 – 88)
| Col # | Header Name | Data Type | Character Limit / Format | Description & Accepted Values |
|---|---|---|---|---|
| 82 | PressName | Text | Exact Press Name | Equipment profile (e.g. Large format UV PREMIUM, Digital Press 1). |
| 83 | Override Cubic Measurement | Text | True or False | Overrides standard cubic measurement calculation. |
| 84 | IsCustomerCode | Yes / No | Yes or No | Displays the Customer Code on the web store card. |
| 85 | IsItemCode | Yes / No | Yes or No | Displays the Item Code / SKU on the web store card. |
| 86 | isAddtoCartandStay | Yes / No | Yes or No | Keeps shopper on the current page after clicking "Add to Cart". |
| 87 | IsPriceStartFrom | Yes / No | Yes or No | Displays pricing as "Starts From $X.XX" on catalogue tiles. |
| 88 | IsShortDescription | Yes / No | Yes or No | Enables the Short Description preview on store cards. |