Amazon order TXT and CSV import
Import the original tab-separated TXT order report exported from Amazon Seller Central directly, without converting it to CSV. You can also use the current XERP CSV template. Inspect the import result. Order records, customization materials and recipient details require separate checks.
For Amazon TXT reports, select the original file with its tab separators and headers intact. For CSV, use the current XERP template and map the source data to its columns. Keep identifiers, postal codes and phone numbers as text so leading zeros and long values survive. Save CSV, select it from the import action and review feedback.
Keep order items separate. Do not merge all products in a multi-item order into one row.
amazon-order-id, order-item-id, asin, seller-sku, purchase-date, quantity and order-status must correspond to the actual order.
customized-url points to the actual customization material. A low-resolution snapshot does not substitute for photos, text and buyer choices.
Use recipient-name, phone, address-line1–3, city, county, district, state-or-region, postal-code and country-code as required by the current template. These may be empty at import; all-empty recipient details do not create an address record. Complete and check the required information before creating parcels.
Do not infer a shipping address from a customization ZIP, photo or message.
Resolve invalid rows, check product associations and verify one representative order. Import does not by itself configure a product scheme or authorize an Amazon seller account.
Continue with the order workflow →