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
  • StoreKey - (Optional) three characters string, can be used to record source of the order
  • OrderItemId - (Optional), a sequence number of item in the order if the order contain multiple products (also add additional lines, one for each product).
  • 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 item
  • ShippingCost - (Optional) shipping paid by customer (for multiple line orders,  specify ShippingCost on first line and keep the other lines blank)
  • TaxCost - (Optional) tax paid by customer
  • Commission - (Optional) marketplace fee
  • Discount - (Optional) discount
  • Email - (Optional) buyer's email
  • Phone - (Optional) phone number
  • 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 - Teapplix shipping class (default is Standard)
  • ShipWeight - (Optional) total weight of the order package
  • Length - (Optional) package dimension
  • Width - (Optional) package dimension
  • Depth - (Optional) package dimension
  • ShipMethod - (Optional) ship method to be used to generate the shipping label
  • QueueID - (Optional) if of the order queue to store the order
  • Memo - (Optional) note on the order