CSV import

Orders that are not in a connected cart system or OMS can be imported into Recustomer by uploading CSV files.

The column names in the CSVs are Japanese system values. Keep them as they are; this page shows each column name followed by an English description.

1. Roles of the order CSV and shipment CSV

Returns and exchanges are only available for shipped orders, so import the shipment CSV after the order CSV.

2. How to upload a CSV

1. Prepare the CSV to import. Fill it in following Order CSV column reference and Shipment CSV column reference, using the sample CSVs as a reference

2. Click Import at the top right of Order management

3. Under Type, choose Order or Shipment, select the CSV file, and click Import

4. Check the result in Settings > External service integrations > Import > Import history. If there were errors, the history details show the row number and the error for each one

Before you import

• Save the file in Shift-JIS. UTF-8 files (including Excel's "CSV UTF-8") cause an error
• Columns are read by their order, not by their header names. Do not reorder or delete the template's columns
• If even one row has an error, nothing in the file is imported. Fix the errors and upload the whole file again
• Each file can be up to 10 MB and 10,000 lines (including the header line)
• If you open and re-save the file in Excel, dates may change to a format such as 2026/1/9 23:00 and cause an error, and long numbers (such as tracking numbers) or leading zeros (such as in SKUs) may change. Edit the file in a text editor, or set the columns to the Text format if you use Excel

3. Downloading the sample CSVs

These samples contain two orders (one of them with two products) and their shipment details, as an example of how to fill in the files.

4. Order CSV column reference

Enter one row per product. If an order contains several products, add as many rows as there are products, all with the same order ID (注文 ID). The order details, shipping address, billing address, and transaction details are taken only from the topmost row of each order, so you can leave them blank in the other rows (see 6. Data structure).

Besides YYYY-MM-DD HH:MM:SS (treated as Japan time), dates and times can also be entered as 2026-01-09T23:00:00+09:00.

Order details

Shipping address

Billing address

Transaction details

Conditionally required: when the payment status is paid or partially_paid, 取引 ID, 取引金額, 取引通貨単位, 取引ステータス, and 支払い方法 are required. Only one transaction can be imported per order.

Line items (one row per product in the order)

Note: if your store has order or product metafields, metafield columns are added (order metafields between the transaction details and the line items, product metafields at the end). In that case, use the template downloaded from Settings > External service integrations > Import > Import template.

List-type metafields: enter the values of a list-type metafield in one cell, separated by commas (e.g. A,B,C). If a value contains a comma or a double quote, enclose that value in double quotes and double any double quote inside it (e.g. A,"""B",C gives the three values A, "B, and C).

Importing the same order ID again: the order's amounts and status and the shipping and billing addresses are overwritten. For line items that were already imported, only the quantity and the product image are updated; the price, product name, SKU, and other columns are not. Transactions that were already imported are not updated either. Any line items that are not in the CSV are removed from the order.

5. Shipment CSV column reference

※When you add or update shipments for an order, include the rows for every 発送情報 ID already imported for that order. Leaving them out causes an error

6. Data structure

In the order CSV, each order has one transaction and one or more line items. Enter one row per line item.

Order (注文ID)
├─ Order details (amounts, dates, status, and so on)
├─ Shipping and billing address
├─ Transaction (取引ID)　※one per order
└─ Line item (商品明細ID)　※an order can have several → one row per product
    ├─ Product (商品ID, 商品名, SKU, and so on)
    ├─ Price (販売価格, 定価, tax, and so on)
    └─ Quantity (商品数量)

When an order contains several products

Write one row per product. Enter the order information, such as the order number and amounts, only in the first row of the order. From the second row, fill in only 注文 ID and the product columns.

Example: a shoulder bag and a T-shirt bought in one order

※The order information is taken only from the topmost row with the same 注文 ID. If you leave the upper row blank and fill in a lower row, the order number and amounts are treated as missing and an error occurs

In the shipment CSV, each order can have several shipments (parcels), and each shipment can have several shipment lines. Enter one row per shipment line.

Order (発送注文ID)
└─ Shipment (発送情報ID)　※an order can have several (split shipments)
    └─ Shipment line (発送明細ID)　※a shipment can have several
        ├─ Which product (発送ラインアイテムID)
        └─ Quantity (発送数量)

The shipment CSV works the same way: for rows with the same 発送情報 ID, enter 発送注文 ID, the carrier, the tracking number, and the ship date in the topmost row.

7. Corresponding columns between the CSVs

The following three pairs of columns must correspond between the order CSV and the shipment CSV.

8. Values that must not be duplicated

The following values cause an import error if they repeat within the given scope.

For 発送情報 ID, use the same value for every row in the same parcel and a different value for each other parcel. If different orders use the same 発送情報 ID, they are imported together as a single parcel, so use a different value for each order.