Skip to content

Prepare once. Import with confidence.

Your business setup kit.

Give the owner one ZIP with blank CSV templates, separate examples, field guides and installation checklists. Prepare the data before setting up the branch.

25 template sets | CSV schema 1 | 56.3 KB | Templates from Server 2.2.0

Use a Business Server build with Admin | Data Setup & Transfers. Import the completed files locally on that Server. Each Windows x64 application download is a ZIP containing its installer, requirements, setup instructions and templates. See the deployment guide for current release versions, beta/stable status and other computer architectures.

Installation and upgrade guide

What's in the pack

Business templates, fictional examples and guides are included. Production templates and examples are grouped in the production folder.

Categories

categories-v1-template.csv

  • code Required
  • name Required
  • parent_code Optional
  • description Optional
Brands

brands-v1-template.csv

  • code Required
  • name Required
  • description Optional
Units

units-v1-template.csv

  • code Required
  • name Required
  • is_base Optional
Warehouses

warehouses-v1-template.csv

  • code Required
  • name Required
  • address Optional
Products

products-v1-template.csv

  • sku Required
  • name Required
  • category_code Required
  • base_unit_code Required
  • brand_code Optional
  • purchase_unit_code Optional
  • sales_unit_code Optional
  • description Optional
  • reorder_level Optional
  • max_stock Optional
  • cost_price Optional
  • retail_price Optional
  • wholesale_price Optional
  • min_selling_price Optional
  • active Optional
  • is_non_stock Optional
Product unit conversions

product_units-v1-template.csv

  • sku Required
  • unit_code Required
  • multiplier Required
Product barcodes

product_barcodes-v1-template.csv

  • sku Required
  • barcode Required
Product prices

product_prices-v1-template.csv

  • sku Required
  • price_type Required
  • amount Required
  • currency Optional
Customers

customers-v1-template.csv

  • code Required
  • name Required
  • type Required
  • phone Optional
  • address Optional
  • credit_limit Optional
Suppliers

suppliers-v1-template.csv

  • code Required
  • name Required
  • contact_name Optional
  • contact_phone Optional
  • contact_email Optional
  • address Optional
  • payment_terms Optional
  • tax_number Optional
  • preferred Optional
Opening stock

opening_stock-v1-template.csv

  • source_id Required
  • sku Required
  • warehouse_code Required
  • unit_code Required
  • quantity Required
  • unit_cost Required
  • as_of_date Required
  • batch_number Optional
  • expiry_date Optional
  • serial_numbers Optional
Opening customer debts

opening_receivables-v1-template.csv

  • source_id Required
  • code Required
  • amount Required
  • as_of_date Required
  • reference Optional
  • due_date Optional
Opening supplier debts

opening_payables-v1-template.csv

  • source_id Required
  • code Required
  • amount Required
  • as_of_date Required
  • reference Optional
  • due_date Optional
Purchase invoice headers

purchase_headers-v1-template.csv

  • invoice_key Required
  • supplier_code Required
  • invoice_date Required
  • currency Optional
  • notes Optional
Purchase invoice lines

purchase_lines-v1-template.csv

  • invoice_key Required
  • line_id Required
  • sku Required
  • unit_code Required
  • quantity Required
  • unit_cost Required
Stock count drafts

stock_counts-v1-template.csv

  • session_code Required
  • warehouse_code Required
  • sku Required
  • unit_code Required
  • counted_quantity Required
  • note Optional
Service categories Requires the services module

service_categories-v1-template.csv

  • code Required
  • name Required
Service catalog Requires the services module

services-v1-template.csv

  • code Required
  • name Required
  • category_code Required
  • amount Required

Production: Material

Template, example and owner setup guide included.

Production: Machine

Template, example and owner setup guide included.

Production: Staff

Template, example and owner setup guide included.

Production: Recipe

Template, example and owner setup guide included.

Production: Rule

Template, example and owner setup guide included.

Production: Batch

Template, example and owner setup guide included.

Production: Expense

Template, example and owner setup guide included.

Fill, validate, review, import

  1. Start with categories, brands, units and warehouses, then products, customers and suppliers.
  2. Keep identifiers as text, use reference codes and YYYY-MM-DD dates. Replace example dates with real document dates.
  3. Upload related files together in Data Setup & Transfers. Review the preview and correct any row errors.
  4. Confirm the import. Opening stock and debts require approval and a backup. Purchase and stock-count drafts require a separate posting action.

Know the limits

  • General data setup: up to 30 files, 10,000 rows and 8 MiB combined per batch.
  • Production setup: use the Production CSV panel; up to 500 rows per preview.
  • Examples are fictional. Fill the blank templates with the owner's data.
  • Staff, bank/cash configuration and ownership imports are outside this pack?s supported import scope.
  • Adding a workstation or upgrading an installation does not require importing opening data again.
  • Keep completed owner files private and reconcile the imported totals before trading.