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 ActionShip 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