Mar 20 2021
 ShopOrdersOrder Import

InfiPlex Manual Order Import

Last Updated: Mar 20, 2021

The Order Import/Export tool allows you to manually upload a .csv file to insert orders into the InfiPlex Inventory & Order Management System (OMS).

Importing Orders into InfiPlex

  • Access the tools by going to Orders > Import/Export from the main OMS menu.

     
  • Download the example .csv file to prepare your orders.
  • Recommended and Required Fields:
    The upload file must be a .csv and allows you to include orders with up-to 50 line items.
    You only need to fill in product order data for the first item and then use the additiona item info fields based on the number of line items on the order.
    * Required field
    date*: Format: 3/17/2021 2:34:00 PM
    order_id: This is your internal order id for reference
    order_source: Enter a name for the order source
    email: Enter the email associated with the order
    phone: Enter the phone associated with the order
    shipping_first_name: Enter the first name of the Ship To address
    shipping_last_name: Enter the last name of the Ship To address
    shipping_company: Enter the company name of the Ship To address if shipping to a company
    shipping_street1*: Enter the address of the Ship To address
    shipping_street2: Enter the address 2 field of the Ship To address
    shipping_city: Enter the city of the Ship To address
    shipping_state*: Enter the 2 letter State abbreviation of the Ship To address
    shipping_zip*: Enter the zip code of the Ship To address
    shipping_country*: Enter the 2 letter Country code of the Ship To address
    item_1_product_name: Enter the product title
    item_1_sku*: Enter the product SKU number
    item_1_price*: Enter the product price or 0
    item_1_quantity*: Enter the product quantity ordered
    item_1_ship_weight: Enter the each ship weight in ounces. Weights are required to get shipping rates.
    total*: Enter the order total or 0