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.
   
   
2. Select the Import CSV File Option.
   
   
3. Choose the store where you want the orders to be created and upload your CSV File with all the required data. 
   
   
   
   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. 
   
   
   
   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.
   

Important: CSV files must not contain empty mandatory fields. If any required column is left blank, the file will return an error during import.

Example of a file that will cause an error:

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
• Artwork URL:
  
  • Description: The Artwork URL is used to provide a print file for products that do not already include an image in the SKU.
  • If you are providing SKU without -PIC or -APO, you must provide an Artwork URL. These SKUs do not contain artwork by default, so a print file is required for fulfillment.
  • If the SKU includes -PIC or -APO, it means the product was created via the configurator and already has an image attached to it. In this case, you do not need to provide an Artwork URL, as the artwork is embedded in the SKU.
  • If both a -PIC / -APO SKU and an Artwork URL are provided, the system will use the artwork attached to the SKU. The Artwork URL will be ignored.
  • If a standard SKU (without -PIC / -APO) is submitted without an Artwork URL, the order cannot be fulfilled and will fail validation.
  • Example
     https://example.com/artwork.jpg

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.