Skip to content
Novus Examples

Retail · Synthetic business data

Fieldnote Supply Shop

A six-product shop with linked customers, orders, order lines, captured payments and partial refunds.

ZIP with instructions and SHA-256 checksums. Files stay in your browser.

Create from this data

Choose a starting template, then follow its table and field mapping. Studio imports add a table to your project; they do not automatically replace the template’s sample content.

Guided source import

Inspect and edit the source data

Source table: order_lines in the linked operating model.

product_id
product_id
quantity
quantity
unit_price
unit_price
line_total
line_total
  1. Open the linked operating model in the text and data editor. Find tables.order_lines.rows to inspect the records and exact field names.
  2. Keep identifiers as quoted text, retain the other tables and compare edits with the linked schema and expected results. Save a local copy before changing records.
Open text and data editorDownload source JSON

Guided source import

Order line report

Source table: order_lines in the linked operating model.

product_id
product_id
quantity
quantity
unit_price
unit_price
line_total
line_total
  1. Download operating-model.json, then open this Document Studio template. Choose Import business data, select the JSON file, choose order_lines in Business data table and click Use table.
  2. The import appends a new typed table with all source columns. Use the listed fields for your report, edit its heading and remove unrelated sample blocks. Transfer any values needed by the original template into its fields explicitly; imported records do not replace or bind its sample line items.
  3. Save editable source to preserve the document project. Use the kit workbook in a spreadsheet application when you need its existing formulas, worksheets and chart layout.
Open Document StudioDownload source JSON

Start with blank input tables

The ZIP contains a header-only CSV for every source table. Fill the fields using the kit schema, then open the CSV in the text and data editor or import it into a Studio. Open the completed operating workbook in a spreadsheet application to retain its native worksheets, formulas and chart layout.

Download blank CSV templates

Start with the expected results

Read the kit guide, follow each input’s import order, then compare your output with the reconciliation checks. Planning datasets do not imply that a platform can import them.

Platform compatibility

Example data

Generic business records

Profile 2026-09-08.1 · reviewed 2026-09-08

  1. Map fields to your application schema and retain stable relationships.

Generic records are not native imports for unnamed platforms.

Specification validated

Shopify simple products

Profile 2026-09-08.1 · reviewed 2026-09-08 · US

  1. Review the separate profile schema and current vendor mapping screen.

Price uses the store currency; confirm USD in the test store. No images, variants or inventory import are claimed.

No completed platform-account import is claimed.

Evidence: Official documentation and strict local schema checks

Shopify documentation 1

Specification validated

WooCommerce simple products

Profile 2026-09-08.1 · reviewed 2026-09-08 · US

  1. Review the separate profile schema and current vendor mapping screen.

Use the core importer and a USD test store. Extensions and account imports were not tested.

No completed platform-account import is claimed.

Evidence: Official documentation and strict local schema checks

Woocommerce documentation 1

Mapping example

Square item mapping

Profile 2026-09-08.1 · reviewed 2026-09-08 · US

  1. Review the separate profile schema and current vendor mapping screen.

Download your current account template first. Tokens and location-specific columns are not fabricated.

No completed platform-account import is claimed.

Evidence: Official template requirements reviewed; source mapping example

Square documentation 1

Inputs, templates and references

Linked operating model

Download JSON

Input · 22.1 KB · Valid

86 records across 9 linked tables; no duplicate primary keys or missing references. Gross item sales=942.00 USD; Refunded amount=80.00 USD; Orders=12.00 records.

Operating model JSON Schema

Download JSON

Schema · 21.4 KB · Reference

Draft 2020-12 schema accepts the paired operating model. Relational rules additionally require unique keys and existing foreign references.

Numeric expected results

Download JSON

Expected Results · 2.5 KB · Reference

Exact table counts, metric formulas, 12 chart points and three negative-test outcomes. Gross item sales=942.00 USD; Refunded amount=80.00 USD; Orders=12.00 records.

Operating report PDF

Download PDF

Reference · 54.9 KB · Valid

Three readable pages summarize the same model, chart, source tables and usage instructions. Gross item sales=942.00 USD; Refunded amount=80.00 USD; Orders=12.00 records.

Editable operating workbook

Download XLSX

Template · 24.1 KB · Valid

Native sheets preserve 86 source records, 3 calculated headline metrics and one editable chart. Gross item sales=942.00 USD; Refunded amount=80.00 USD; Orders=12.00 records.

Shopify profile CSV

Download CSV

Input · 474 B · Valid

6 unique records follow the documented Shopify field subset. Strict local specification checks pass; account import and stored results are not verified.

Shopify profile schema

Download JSON

Schema · 1.7 KB · Reference

6 unique records follow the documented Shopify field subset. Strict local specification checks pass; account import and stored results are not verified.

Woocommerce profile CSV

Download CSV

Input · 322 B · Valid

6 unique records follow the documented Woocommerce field subset. Strict local specification checks pass; account import and stored results are not verified.

Woocommerce profile schema

Download JSON

Schema · 1.5 KB · Reference

6 unique records follow the documented Woocommerce field subset. Strict local specification checks pass; account import and stored results are not verified.

Square profile CSV

Download CSV

Input · 546 B · Reference

6 unique records follow the documented Square field subset. Map these source fields into a current account export; this file is not a native Square import.

Square profile schema

Download JSON

Schema · 1.3 KB · Reference

6 unique records follow the documented Square field subset. Map these source fields into a current account export; this file is not a native Square import.

Deliberately invalid tests