How-to

Import orders from a spreadsheet

Upload a CSV file to add orders to Omnikyo — for historical orders you recorded manually, sales from other channels, or orders migrated from another platform.

বাংলায়: একটি CSV ফাইল আপলোড করে তুমি অনেক সারি অর্ডার একসাথে Omnikyo-তে যোগ করতে পারো। এটি পুরনো অর্ডার, অন্য প্ল্যাটফর্ম থেকে আমদানি করা অর্ডার বা হাতে লেখা রেজিস্টার থেকে ডিজিটাল করা বিক্রয়ের জন্য দরকার। প্রতিটি অর্ডার Delivered স্ট্যাটাসে যোগ হয় এবং স্টক তাৎক্ষণিক কমে যায়।

Where to find it: Sidebar › Settings › Sales channels › Import orders link

Before you start

Prepare a CSV file with one order per row. Column names are flexible — you'll map them to the required fields during import.
Every product you list must exist in your shop and have a SKU.
You need the orders.bulk_import permission ("Bulk Import").

Step 1: Upload the CSV file

Open Settings › Sales channels › Import orders.
Drag and drop a .csv file onto the upload box, or click to browse.
The file must have:
- A header row (column names)
- At least one data row

If the file is invalid, you see Invalid CSV — CSV file must have a header row and at least one data row.

Step 2: Map the columns

You must match each CSV column to a database field. The mapping screen shows:

Database Field — the field Omnikyo needs (the required ones are marked with *)
Your CSV Column — a dropdown listing every column in your CSV
Example — a sample value

The required fields are:

Order Date (format: 2023-10-26)
Customer Name (e.g., John Doe)
Customer Phone (e.g., 01712345678)
Customer Address (e.g., 123 Main St)
Customer City (e.g., Dhaka)
Product SKUs (comma-separated) (e.g., SKU001,SKU002)
Quantities (comma-separated) (e.g., 1,2)
Prices per item (comma-separated) (e.g., 1200,1500)
Total Order Amount (e.g., 4200)

Optional fields:

Shipping Fee (e.g., 100)
Discount Amount (e.g., 0)

The Review Data button stays disabled until all required fields are mapped. Once every required field has a column selected, click Review Data.

Step 3: Review a sample

The review screen shows the first 5 rows of data, formatted as they will be imported. Check that:

Dates parse correctly
Customer details look right
Product SKUs are spelled exactly as they exist in your shop
Quantities and prices match

If something looks wrong, click Back to Mapping to adjust the column mapping.

Step 4: Start the import

Click Start Import. The file is processed:

All rows are validated in memory before any order is created — if 10 rows fail validation, all 10 are skipped and none are written.
Customers are created if they don't exist (matched by phone number).
Orders are inserted with status New, then immediately moved to Delivered. This triggers the stock-decrement trigger, so inventory is reduced for every item.
If stock is insufficient for any item, that entire row fails with "Insufficient stock."

Step 5: Results

When the import finishes, you see:

N orders imported successfully — the count of successful rows.
M rows failed to import — if any rows had errors, they list here (e.g., Row 3: Product with SKU "BADSKU" not found.).

Click Start New Import to upload another file.

Important: What the import does and doesn't do

Does:

Creates or updates customer records (by phone number)
Creates new orders with status Delivered
Decrements inventory for every item (stock goes down immediately)
Assigns a tracking code to each order automatically

Does not:

Set payment method or record payment
Record advance payments or cash collected
Populate any other order metadata

If you need to track which orders were imported, you can add a note to each one manually later, or filter for orders created on the import date.

Common errors

"Missing customer phone number." — The phone column is empty or unmapped.
"Mismatch in number of SKUs, quantities, and prices." — The comma-separated lists have different lengths (e.g., 3 SKUs but 2 quantities).
Product with SKU "X" not found — The SKU does not exist in your shop, or is spelled differently.
"Insufficient stock." — The row's quantity exceeds available stock for that product at that location.
"No data to import." — The CSV has no data rows (only a header).

Other ways people ask this

bulk import orders csv
csv upload order
order spreadsheet import kivabe
excel theke order import
previous orders add kore debo
batch order upload
migrate orders to omnikyo
import historical sales
csv order list paste
বাল্ক অর্ডার ইম্পোর্ট
পুরাতন অর্ডার যুক্ত করব কীভাবে
csv file upload korbo

Orders overview — navigate and manage all orders
Create an order manually — how to add orders one at a time

Related guides

Create an order manually

Checked against the product on 2026-10-02.