1 Data Import
dlawler489 edited this page 2026-06-20 07:29:33 +10:00

Data Import

Most data now comes from the Etsy Integration. The Data Import page remains for the one source the Etsy API can't provide and for legacy/manual imports.

Australia Post (CSV) — the one remaining manual import

Postage bought directly from Australia Post (MyPost Business) is only in your AusPost account, not Etsy — so it's imported via CSV on the Data Import page. It creates Shipping & Postage expenses (vendor "Australia Post", keyed by tracking number).

There is no usable API for this: MyPost Business has no public transaction-history API, and Etsy's API only knows about labels bought through Etsy (those early ones are in the ledger as Shipping & Postage). So the CSV stays.

Etsy statement CSV (legacy — superseded)

Before the API, fees came from the Etsy statement CSV. That's now replaced by the ledger sync. Stop importing the statement CSV to avoid double-counting; use Settings → Remove Old Fees once to clear any previously imported ones.

PDF packing slips (legacy)

The original cost path parsed packing-slip PDFs to match items and capture printing costs. Superseded by API order sync + catalogue matching. Still present but not needed.

Notes

  • Expense imports dedupe on {reference, vendor, amount, date}.
  • Orders import via bulk upsert by order number, so re-imports update rather than duplicate.