Import & Export Data
Move data into and out of Tiquo via guided wizards
Use the Import wizard to bring data from another system into Tiquo. Use the Export wizard to download data for reports, backups, or other tools.
Navigating to import & export
Open Settings, then Import & Export to find both wizards.
Import and export actions are disabled in the demo platform. The page shows the available data categories, but running a new import or export requires a live account.
Import and export use separate permissions: import_export.import controls imports and import_export.export controls exports. If neither action is available, ask an organisation administrator to update your role.
Import
What data can be imported
From Settings → Import & Export, Tiquo supports importing these data types:
| Import type | What it is used for |
|---|---|
| Customers | Customer records, contact details, marketing consent, addresses, and related customer information. |
| Products | Product catalogue data such as names, SKUs, categories, pricing, tax, stock levels, and product details. |
| Orders | Historical orders and transactions. Imported orders are treated as legacy data for reporting and audit context. |
| Companies | Company records, contact information, corporate domains, industry, status, and company profile details. |
You can bring customer records, offerings, pricing, and historical orders with you while setting up the rest of Tiquo.
Preparing your data
Check your data before importing it. Errors in the source file can affect reporting and daily operations.
Before importing:
- Check that required fields are present
- Remove duplicates where possible
- Use consistent names and categories
Customer birthdays
Tiquo can store a birthday as a full YYYY-MM-DD date or as --MM-DD when
the year is unknown or unnecessary. In the customer editor, choose No year
to retain only month and day.
When preparing a customer import, do not insert a placeholder year merely to make a birthday look complete. Use the yearless form where possible.
Import wizard steps
Follow these steps in the Import wizard:
- Choose category: pick Customers, Products, Orders, or Companies.
- Choose sublocation: for Products and Orders, select the sublocation the data belongs to.
- Upload file: upload a CSV or Excel (.xlsx) file, up to 100MB. The file is parsed and prepared for mapping.
- Map fields: match each column in the file to the corresponding field in Tiquo.
- Review options: decide how to handle conflicts, including overwrite behaviour (replace existing records or skip duplicates) and auto-enrich (let Tiquo fill in missing fields where possible from existing data or external sources).
- Confirm and run: the wizard executes the import and reports successes, skips, and errors.
Verify imported data
After the import, use Tiquo's review tools to:
- Confirm records were imported correctly
- Spot and correct any errors or omissions
- Ensure data is ready for live operations
Check imported records before going live to catch problems that could affect customers or staff.
Export
The Export wizard creates a downloadable file from the data you select.
From Settings → Import & Export, Tiquo supports these export types:
| Export type | What it includes |
|---|---|
| Customers | Customer profile, contact, consent, membership, loyalty, statistics, and date fields selected in the wizard. |
| Products | Product catalogue fields such as name, SKU, category, pricing, status, visibility, stock quantity, and variants. |
| Inventory | Product stock data, including product-level quantities or one row per stock group when stock groups are enabled. |
| Orders | Order numbers, customers, dates, statuses, totals, payment fields, order details, locations, and timestamps. |
| Bookings | Booking numbers, customers, services, dates, times, statuses, linked order details, staff, locations, and notes. |
| Companies | Company profile, contact, address, business, status, tag, statistics, notes, and date fields. |
| Memberships | Membership plan name, whether the plan is free or paid, whether the plan is active, whether the plan applies to customers, companies, or both, default membership price, billing currency, billing period, customer-visible active memberships from direct and company assignments, and other associated membership metadata. |
| Tasks | Task content, type, status, due dates, completion details, categories, location, attribution, and timestamps. |
| Enquiries | Enquiry number, contact details, subject, message, type, status, priority, assignment, source, response tracking, and financial summary fields. |
| Lists & Segments | List or segment names, descriptions, type, customer count, archived status, delivery-provider fields, attribution, and dates. |
| Accounting & Payments | Separate export actions for Default Accounting Export, End-of-day sales report, Invoices, Payments, Payouts, Disputes, and Reconciled Payouts. |
Export wizard steps:
- Choose the export type: on the Import & Export page, select Customers, Memberships, Products, Inventory, Orders, Bookings, Companies, Tasks, Enquiries, or Lists & Segments.
- Name and format: enter a descriptive export name and choose Excel (.xlsx) or CSV (.csv).
- Choose type-specific options: when prompted, select the required sublocation, task status, list or segment, membership export mode, or order layout. Products, Inventory, Orders, and Bookings require a sublocation. Orders can be one row per order or itemised as one row per sold line item.
- Choose a date range: Orders, Bookings, and Enquiries provide a date-range step. Leave it empty to export all applicable records. Bookings and Enquiries can include future dates.
- Select fields: review the preselected fields and add or remove the columns required for the file.
- Review: check the name, format, filters, field count, and estimated row count.
- Start export: Tiquo creates the export job and makes the finished CSV or XLSX file available for download.
Inventory exports
Use Export Inventory when you need a stock-level view of products rather than a standard product catalogue export.
Inventory exports include product context, such as the product name, SKU, category, sublocation, and status, together with the relevant quantity information.
How inventory rows are created:
- Products with stock groups enabled: each stock group is exported as its own row, linked back to the product it belongs to.
- Products without stock groups enabled: the product is exported as a single row with the product-level quantity.
- Products where inventory is not tracked: the product is still exported, and stock-related columns show that the quantity is not tracked.
When stock groups are enabled, the export can include stock group fields such as group name, quantity, availability, stock location, ownership, sell-by date, KDS location, and low stock threshold. Fields only contain values when that setting is enabled for the product or stock group.