How do I import orders via spreadsheet?

How do I import orders via spreadsheet?

To import orders, follow these steps:

1. Log in to your portal
2. Navigate to Order → Order List
3. Click the “Import” button located in the top-right corner
4. Upload your file by either:
   • Dragging and dropping the spreadsheet, or
   • Selecting the file from your device
5. Click Upload to complete the process

What information is required in the spreadsheet?

Please see attached sample spreadsheet. You must prepare your data as per sample spreadsheet. Your spreadsheet must include the following fields:

• PurchaseOrderNo
  • Your unique order number (max 35 characters)
• Sku
  • Product ID for each item
  • Found under Products → Product List
• ServiceId
  • This is shipping ID. When setting up shipping methods in your spreadsheet, please use the corresponding Shipping Type IDs listed below to ensure accurate processing. 
    
    For domestic shipments:
    • UniUni (70)
    • USPS Ground Advantage (49)
    • Printed Parcel Expedited (51)
    • FedEx Ground (25)

                For international shipments:

• DHL Global Mail (36)
• FedEx International Connect (43)
   

How do I handle multiple products in one order?

• Repeat the same PurchaseOrderNo and shipping address details for each product line
• Ensure all entries for the same order have identical address details
• The system reads all product lines associated with the same order number

Which fields are optional?

The following fields are optional:

• CustomsValue, CustomsDescription, HSCode
  • Typically pre-defined in product setup, but can be overridden per order
• AdditionalPoNumber, CustomNotes
• LotNo
  • Used if managing inventory by lot numbers

Why did my file upload fail?

Here are common reasons and how to fix them:

1. File name contains invalid characters

• Avoid special characters such as dots (.) or commas (,) in the file name

2. Incorrect sheet name

• The first sheet must be named “Sheet1”
• Only data from “Sheet1” will be processed

3. Product does not exist

• Ensure all SKUs are already created in
  Product Management → Fulfillment Product

4. Duplicate order number

• PurchaseOrderNo must be unique
• Do not reuse previously uploaded order numbers

5. Postal code formatting issues

• Remove leading zero issues by:
  1. Right-clicking the ShipPostalCode column
  2. Selecting Format Cells
  3. Choosing Special → Zip Code