CSV Columns

Generic CSV

(note, sequence of fields do not matter, any columns in the CSV not matching the below names will be ignored)

  • OrderId - unique id of the order, must be unique in a particular Teapplix account. If the same order id has already been imported, even if the order is later cancelled, you can not import the same order id again
  • OrderDate - yyyy/mm/dd hh:mm:ss format
  • OrderItemId - optional, the item_number for the line item
  • ItemName - name or SKU of the order item. This may be the Teapplix SKU or mapped to the TeapplixSKU
  • ItemDescription - optional, item description
  • Qty - quantity
  • ProductRevenue - subtotal of the order line
  • ShippingCost - shipping paid by customer (for multiple line orders,  specify ShippingCost on first line and keep the other lines blank)
  • TaxCost - tax paid by customer
  • Commission - marketplace fee
  • Phone - phone number
  • Discount - discount
  • Email - buyer's email
  • ShipToName - recipient's name
  • ShipToCompany - buyer's company name
  • ShipToStreet1 - buyer's street address
  • ShipToStreet2 - buyer's street address2
  • ShipToCity - buyer's city
  • ShipToState - buyer's state
  • ShipToZipCode - buyer's zip code
  • ShipToCountry - buyer's country
  • ShippingClass - shipping class
  • QueueID - queue id of order