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:

  
  1. Do not insert, delete, or rearrange columns.
  2. Do not rename or remove the header row.
  3. Save as .xlsx (recommended) or .xls only. Do not export as .csv.
  4. No text or symbols in numeric columns. Do not put $, kg, mm, No, or N/A into numeric fields.

 


1. Product Identification & Ownership (Columns 1 – 10)

                                                                                                                                                                      

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
1Item TitleTextUnlimitedProduct name/title displayed in the catalogue. (Required)
2Item CodeTextMax 50 charsUnique SKU/Product Code. If left blank, the system auto-generates one.
3Category NameTextMax 50 charsProduct category name. If it does not exist, the system creates it.
4CustomerCodeTextMax 100 charsCustomer-specific part or reference code. (Optional)
5SupplierTextMax 100 charsSupplier name. Must match an existing supplier in your system.
6SalesTaxRateTextText codeTax identifier (e.g. GST). Matches tax rates configured in your system.
7Product TypeTextSpecific keywordsAccepted values: Editable, Non Editable, Stock item, or NonEditableStock.
8OwnershipTextKeywordSelf (owned by your company) or Client (owned by a customer).
9CustomerTextText / Comma-separatedAll, NotAllocated, or specific customer company name(s).
10Excluded CustomersTextComma-separatedCustomer company names who are restricted from viewing/ordering this item.

 


2. Product Specifications & Production Details (Columns 11 – 21)

                                                                                                                                                                                    

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
11DescriptionTextUnlimitedPrimary internal specification description.
12Date ApprovedTextMax 2,000 charsArtwork / proof approval status (e.g. Approved., 2026-10-15).
13ColourTextMax 2,000 charsPrint colour specifications (e.g. Single Sided Print: Full Colour, CMYK + White).
14Size (W x H)TextMax 2,000 charsDimensions as displayed on specification sheets (e.g. 100 x 50 mm, A4).
15MaterialTextMax 2,000 charsStock/substrate description (e.g. 1.6mm Aluminium with Class 1 Reflective).
16SchedulingTextMax 2,000 charsDelivery / lead-time details (e.g. Standard 3-5 Days).
17FinishingTextMax 2,000 charsBindery / finishing requirements (e.g. Singles, Trim to size, Laminated).
18CautionedTextMax 500 charsPre-press caution / proof notes (e.g. Small text may be hard to read).
19Pack InstallTextMax 500 charsPackaging or installation instructions (e.g. Packed in cartons of 50).
20Press fileTextUnlimitedFile path or name of the master print file (e.g. PRINT_DECAL_100x50.eps).
21INTERNAL prod. notesTextUnlimitedInternal instructions for machine operators.

 


3. Pricing Matrix & Physical Shipping Dimensions (Columns 22 – 30)

                                                                                                                                                        

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
22Price Matrix TypeTextKeywordPrice Band, Simple Matrix, or Signage Matrix.
23FromQuantityDecimalNumber onlyStarting quantity for this price bracket (e.g. 1).
24ToQuantityDecimalNumber onlyEnding quantity for this price bracket (e.g. 10000).
25PriceDecimalNumber onlyUnit cost price (e.g. 8.10). Do not include $.
26SellingpriceDecimalNumber onlyUnit retail/selling price (e.g. 12.50) or Markup % if column is headered Markup.
27WeightDecimalNumber onlyProduct weight in kilograms (e.g. 0.25). Do not include kg.
28WidthDecimalNumber onlyPhysical width in millimetres (e.g. 100). Do not include mm.
29HeightDecimalNumber onlyPhysical height in millimetres (e.g. 50). Do not include mm.
30LengthDecimalNumber onlyPhysical length / depth in millimetres (e.g. 2).

 


4. Webstore Display & Customer Options (Columns 31 – 42)

                                                                                                                                                                                                  

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
31ProductVisibletoStoreYes / NoYes or NoControls whether the item appears in the online ordering portal.
32ShortDescriptionTextMax 4,000 charsPlain text keywords / summary used for search indexing and product cards.
33ItemDescriptionText / HTMLUnlimitedRich HTML product description shown on the product detail page.
34Allow user to upload artwork fileYes / NoYes or NoAllows customers to attach custom files during checkout.
35UserArtworkFileCountIntegerNumber only⚠️ Must be a number (0, 1, 2). Never enter "No" or text.
36UserArtworkFirstRowMandatoryYes / NoYes or NoRequires customer to upload at least one artwork file before checkout.
37Show Print Ready FileYes / NoYes or NoMakes print-ready proof link visible to customers.
38ShowStockYes / NoYes or NoDisplays live available stock balance on the store.
39ShowPriceSubTotalTaxYes / NoYes or NoShows tax and subtotal breakdown on store product page.
40ShowSoldInPacksOfYes / NoYes or NoDisplays pack quantity restriction notice.
41AllowGroupRunYes / NoYes or NoAllows gang/group manufacturing runs.
42Enable Cumulative PricingYes / NoYes or NoApplies cumulative bracket calculations (only used with Simple Matrix).

 


5. Custom Attributes (Columns 43 – 67)

                                        

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
43 – 67CustomDescription1 through CustomDescription25TextUnlimited25 custom descriptive fields for customer specs, job tracking, or cost formulas.

 


6. Accounting, Cubic Freight & Inventory (Columns 68 – 81)

                                                                                                                                                                      

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
68AccountingCodeText / NumberLookup CodeGeneral Ledger / accounting code (e.g. 243) matched against tb_AccountingCode.
69CBMHeightDecimalNumber onlyCubic freight height (m / cm). Defaults to 0.
70CBMWidthDecimalNumber onlyCubic freight width (m / cm). Defaults to 0.
71CBMLengthDecimalNumber onlyCubic freight length (m / cm). Defaults to 0.
72CBMWeightDecimalNumber onlyVolumetric / cubic freight weight. Defaults to 0.
73CubicMeasurementDecimalNumber onlyTotal cubic volume measurement (m3m^3m3). Defaults to 0.
74IsStockProduct1 / 01 or 01 = Physical stocked inventory (draws stock).
0 = Print-on-demand / non-stock item.
75StockQuantityIntegerNumber onlyStarting inventory count. Enter 0 if not tracking stock.
76CustomField1TextWarehouse NamePrimary Warehouse Location (must match an active warehouse in the system).
77 – 81CustomField2 through CustomField6TextCustom TextWarehouse bin, aisle, shelf, batch, or lot numbers.

 


7. Machine Routing & Store Behaviours (Columns 82 – 88)

                                                                                                                            

Col #Header NameData TypeCharacter Limit / FormatDescription & Accepted Values
82PressNameTextExact Press NameEquipment profile (e.g. Large format UV PREMIUM, Digital Press 1).
83Override Cubic MeasurementTextTrue or FalseOverrides standard cubic measurement calculation.
84IsCustomerCodeYes / NoYes or NoDisplays the Customer Code on the web store card.
85IsItemCodeYes / NoYes or NoDisplays the Item Code / SKU on the web store card.
86isAddtoCartandStayYes / NoYes or NoKeeps shopper on the current page after clicking "Add to Cart".
87IsPriceStartFromYes / NoYes or NoDisplays pricing as "Starts From $X.XX" on catalogue tiles.
88IsShortDescriptionYes / NoYes or NoEnables the Short Description preview on store cards.