How to import orders into EMS

By E-Marketplace Services, on

EMS allows you to import your orders so that you can print shipping labels from EMS


EMS supports order importing from CSV file.  If you have your orders exported from your existing application, or shopping cart, you can import these orders into EMS.

The orders can only be imported into store type "EMS default", since this is a 'disconnected' store, thus order tracking numbers won't be synced with any channels.

The table below listed the required/optional columns.  You can also download this sample CSV file as a template to start with.

Field nameDescriptionIs requiredMax lengthDefault value
NameName of the buyerTRUE100
Company100Empty string
OrderDateTimeTimestamp in msTRUE
OrderIDChannel order IDTRUE100
AddressTRUE100
Address2100Empty string
CityTRUE100
ProvinceTRUE100
CountryTRUE50
PostalCodeTRUE25
Phone25Empty string
EmailTRUE100
ProductNameTRUE512
ProductOptionOption such as color, size512Empty string
UPC12Empty string
SKUProduct unique SKUTRUE100
WeightDecimal format1
WidthDecimal format1
LengthDecimal format1
HeightDecimal format1
SizeUnitProduct dimension unit, valid values are inch, cm4inch
WeightUnitProduct weight unit, valid values are lb, kg and oz2lb
QuantityDecimal format1
CurrencyOrder currency3USD
ShippingMetodIf the shipping method matches exactly of carrier name in EMS, this carrier will be selected by default.100Default
ProductPriceDecimal format1
Tax0
ShippingCharge0
OrderTotalDecimal formatTRUE
StatusOrder status. Valid values are: PROCESSING, PARTIAL_SHIPPED, SHIPPED, PENDING, CANCELED, EXCEPTION, CLOSED, SUSPECTED_FRAUD, HOLD, REFUNDED, UNKNOWN100PROCESSING
EAN13Empty string
ISBN13Empty string
OrderNoteOrder comments4096Empty string
OrderNoteProduct HS code15Empty string
CountryOfOriginProduct country of origin2Empty string
Note
For order with multiple products, use multiple rows with the same order number. Each row contains one product. The sample provided above is for this scenario
Version: 1.0

The columns can be in any order.  If any string field exceeds the length limitation, EMS will automatically trim them to the maximum length allowed.

If you do not want to provide values to these optional columns, you can omit these values in the CSV file, however, the headers are required.

To import orders, navigate to Orders Page, hover mouse cursor on the action menu at the top right corner of the Orders table, select the "Import orders from CSV" menu item, in the dialog, select the store you want to import the orders into, and select the CSV file, then click the Import button.



After you click the import button, an Order Import job is created.  You can go to "Job Statuses" page to check the progress of the import.  If there are any errors you can view the logs from Order Statuses page.

Once the orders are imported, you can start to print your shipping labels.


Tip:

If you would like EMS to preselect the shipping method when you print the label in EMS, set the 'ShippingMetod' value to match the carrier name in EMS, so that EMS will automatically match the carrier of your choice.




Card image cap

Introducing the fuzzy tracking - track shipment progress without tracking number

Let your customers find their shipments without knowing the tracking number

Read More
Card image cap

Ship now print label - ship orders anywhere you want

User EMS' Ship Now Print Later feature, you can have your orders 'virtually' shipped anytime anywhere

Read More

Contact us

Leave your email or phone number and we will get back to you in a couple of hours.