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 guideWhat'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
- Start with categories, brands, units and warehouses, then products, customers and suppliers.
- Keep identifiers as text, use reference codes and YYYY-MM-DD dates. Replace example dates with real document dates.
- Upload related files together in Data Setup & Transfers. Review the preview and correct any row errors.
- 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.