Ordamo
All features
Who it's for
PricingBlog
EN
Log inSign up free
Docs

Import from a store export

Ordamo imports your store's own export file rather than connecting to the store: download the order file from Shopify, Etsy, WooCommerce or Tiendanube and load it, and the columns map themselves from the header spellings those exports use. Orders, customers, products, expenses and income can each be imported this way, from a store file or from a sheet you keep by hand. Loading the same file again does not create duplicates. There is no API integration and nothing updates by itself afterwards.

How it goes

01

Export the file from your store

On Etsy it has to be the “Sold Order Items” file: “Sold Orders” carries no line items, so there is nothing to import from it.

02

Load it at Settings → Import, or hand it to the assistant

The form and the chat do the same work. The chat is the shorter road when the file is a screenshot or a photograph of something rather than a spreadsheet.

03

Check the mapping

Every column is shown against the field it was matched to, and anything unmatched is offered rather than guessed. This is the step worth reading.

04

Confirm

Customers are matched against the ones you have and created where they are new; products are matched against your catalog. Nothing is written until you confirm.

What a file can be imported as, and what each one is for.

OrdersA store's order export (Shopify, Tiendanube, Etsy, WooCommerce) or a sheet with one row per order or per line.
CustomersOne row per customer.
ProductsOne row per product or variant.
ExpensesOne row per expense; amount and date are required.
Other incomeMoney received that is not tied to an order; amount and date are required.

What it changes elsewhere

The part you cannot discover by clicking, and the reason most of these questions get asked twice.

Customers you did not have

A name that does not match an existing customer becomes one, with the phone, email and address the file carried.

Products matched against your catalog

Line items are matched to products you already sell, so an import does not quietly create a second copy of a piece you make every month.

Nothing, the second time

The same file loaded again matches what is already there instead of doubling it, which is what makes a partial import safe to repeat.

What it doesn't do

Named here, so you find out now rather than in week two.

No live sync

An import is a moment in time. A new order in your store tomorrow does not appear here; you import again, or you add it.

No API integration

There is no connection to authorise and no store to log into. The file is the interface.

Etsy has no status words

Its export says nothing about production. A “Date Paid” and a “Date Shipped” are read as the facts they are, and the rest of the pipeline is yours to set.

Questions

Which file do I export from Etsy?

“Sold Order Items”. It has one row per item with the order repeated on each, which is what an order with line items needs. Its “Buyer” column is an Etsy username rather than a person's name, so the name is read from “Ship Name” instead.

My sheet is my own, not a store export. Will it work?

Yes. The header spellings from the store exports are recognised first, and anything else is matched by what it looks like and shown to you before it is used. A sheet with a customer, a product and a price in it is importable.

Will importing twice duplicate my orders?

No. Rows that match something already imported are recognised rather than added again, so reloading a corrected file is a safe thing to do.

Team rolesNext →
Ordamo
Dashboard
Orders
Customers
Products
Batches
Income
Expenses
AI Assistant
Settings
OrdersExport CSVAdd from screenshotNew order
Search by order number or customer…All statusesNewest firstAll Time
Orders186
Active14
Pending$5,240
Avg margin40.8%
Daniel Fischer#1045Quote
14/09/2026ready 06/11/20262 items
$1,240$1,240 due
Amara Bello#1044Confirmed
02/09/2026ready 23/10/202638.6% margin5 items
$2,140$1,070 due
Théo Marchand#1043In transitTime to ask
18/08/2026ready 30/09/202636.9% margin4 items
$1,712$856 due
Isabella Rossi#1042In production
01/08/2026ready 26/09/202643.4% margin7 items
$3,585.60$1,925.60 due
Hannah Weiss#1041Delivered
12/07/2026ready 29/08/202644.1% margin3 items
$2,960paid in full
New order
Customer
Isabella Rossi
Items
Selected products
Larch Dining Table
SKU: —
Unit cost
$800
Unit price
$1,850
Quantity
1
Subtotal: $1,850 | Cost: $800 | Tax (8%): $148 | Margin: $1,050
Spindle Dining Chair
SKU: —
Unit cost
$150
Unit price
$245
Quantity
6
Subtotal: $1,470 | Cost: $900 | Tax (8%): $117.60 | Margin: $570
Dates
Order date
01/08/2026
Ready by
26/09/2026
In ~8 weeks
Payment
Deposit
$1,660

Run one order all the way through, and see it for yourself.

Try it now →

$0 today · first charge after 14 days · cancel in one click