Orders
      Back to home
      1. Knowledge Base
      2. Orders

      How to import orders using the CSV file functionality?

      Our CSV (Comma-Separated Values) file upload feature enables efficient management of bulk orders, allowing the creation of multiple orders at once. Here's a simplified guide on how to use CSV file upload for order creation. 

      1. Log into your merchOne account, and under the Orders section, press the CSV Import / Export button.

        image (14)-1
      2. Select the Import CSV File Option.

        image (15)-1
      3. Choose the store where you want the orders to be created and upload your CSV File with all the required data. 

        image (16)

        Note! We recommend using our CSV template to ensure accuracy and compatibility. The template is designed to match our system requirements and helps prevent common errors during the import process. Please see below a guide on how to fill in the required fields for a successful CSV import.
      4. Click Import CSV to complete the process and import your orders. 

        image (17)

        The newly created orders can be reviewed by navigating to the Orders tab in the dashboard of the selected store. 
      5. After uploading the CSV file, you will receive a notification at your registered email address confirming that the upload was successful and that the order has been sent to production.

      Required Fields for CSV Import

      To ensure a smooth import process, your CSV file should contain the following fields, each serving a specific purpose for processing and fulfilling your orders:

      • Quantity:

        • Description: The number of units for the particular product being ordered.
        • Example: 5

      • Listing id (ITEM EXTERNAL_ID) (optional field):

        • Description: An optional identifier for the item in your external listing system.
        • Example: EXT12345

      • SKU number:

        • Description: The Stock Keeping Unit (SKU) of the product as configured in merchOne.
        • Example: CVS0200201LFF2-PIC92034130

      • Delivery Email:

        • Description: The email address of the recipient for order delivery updates.
        • Example: example@example.com

      • Delivery Firstname:

        • Description: The first name of the recipient.
        • Example: John

      • Delivery Lastname:

        • Description: The last name of the recipient.
        • Example: Doe

      • Delivery Zipcode:

        • Description: The postal code for the delivery address.
        • Example: 12345

      • Delivery Telephone:

        • Description: The phone number of the recipient.
        • Example: 123-456-7890

      • Delivery State:

        • Description: The state or region for the delivery address.
        • Example: California

      • Delivery Country (2 letter code):

        • Description: The country for the delivery address.
        • Example: US

      • Delivery City:

        • Description: The city for the delivery address.
        • Example: Los Angeles

      • Delivery Address1:

        • Description: The primary street address for delivery.
        • Example: 123 Main St

      • Delivery Address2:

        • Description: Additional address information, such as apartment or suite number.
        • Example: Apt 4B

      • Order id (ORDER EXTERNAL_ID):

        • Description: A mandatory unique identifier for the order in your external system.
        • Example: ORD12345

      • Customs shipping costs:

        • Description: The shipping costs associated with customs, if applicable.
        • Example: 15.00

      By ensuring your CSV file includes these fields, you can streamline the order import process and avoid common errors.

      Feel free to reach out to our support team at support@merchone.com if you have any questions or need further assistance with the CSV import functionality.