Familiarise yourself with the purpose of the existing order CSV Spreadsheet fields to understand which information is mandatory to fill in and which one can be skipped:

General Order Information

Order Number: If left blank the system will generate one or you can assign your own, but it must be unique. If a duplicate order number is found the system will attempt to update that existing order.

Invoice Number - Optional. You can assign your own, or leave it blank and the system will generate one.

Marketplace Name - This field is used during export to show which marketplace the exported order belongs to. All imported orders are assigned to the local marketplace regardless of the marketplace name given, thus you can leave it blank.

Marketplace Credential ID - Optional. This is the marketplace integration identification number which can be found on the Integrations page under Connected sales channel integrations:

During CSV order import, you can use your existing inventory to map new orders to those items, which results in stock deduction as if the orders were synced from the marketplace.

The mapping of ordered items to your inventory is done via SKU. If you have two separate inventory items with the same SKU (which happens when you sell the same product in several marketplaces) the system will not be able to know which one to map the order to and would not create it at all.

Therefore, for the system to understand to which product SKU the order should be mapped, you can specify the Marketplace Credential ID. Let's say I have a product with SKU 1234 which I sell on Wix and Etsy and I want the order to be mapped to the product sold on Wix, I have to specify the Wix marketplace credential id and the order will be mapped to this item.

If you have a duplicate SKU on the same marketplace you would not be able to map these items and the order would not create. Items that are merged are considered as a single item and merged items SKU will be used for mapping.

Order Created Date: This is used to assign a date to your imported order. The date format cannot be changed and must be YYYY/MM/DD.

Item Name: The name of the ordered item. If the ordered item is successfully mapped, the name will be changed to the name as it is in your inventory, if the item does not map to anything the name will remain grey as written.

Item SKU: The ordered item SKU is used to map ordered items to your inventory.

SKU value is case sensitive - if you make a mistake and import an order with the wrong SKU, your order will be imported but inside it, instead of an actual product, there will be a greyed-out text item.

Item Image: Leave Blank. It is not possible to import product images via order CSV import but you will do a CSV export, the image URL will appear in this field.

Tags: Optional, used in case you want to tag orders for further filtering.

Reference No: Optional. The reference number field allows attaching any additional information specific to that order.

Notes: Optional. Text added here will appear as an internal note left by the staff member inside the order.

Comments: Optional. Text added here will appear as a customer note inside the order.

Category: This field is used for order export only to show the assigned category for the ordered item. When importing, you can leave it blank.

Supplier: This field is used for order export only to show the assigned supplier for the ordered item. When importing, you can leave it blank.

Brand: This field is used for order export only to show the assigned brand for the ordered item. When importing, you can leave it blank.

Handling Time: This field is used for export only to show the assigned handling time for the ordered item. When importing, you can leave it blank.

Item Quantity: Used to determine how many units of this specific item are in the order.

Item Price: Used to determine the price of a single unit of the ordered item. Decimal numbers must be separated with a dot, for example, 12.45.

Order Discount: Used to determine the total discount for the order applied before tax. Leave at 0 if no discount is used. Decimal numbers must be separated with a dot, for example, 12.45.

Order Tax: The total order tax. There is no individual order item tax. Decimal numbers must be separated with a dot, for example, 12.45.

Order Total: Total order sum which must be added when importing. Order total = Subtotal + Discount + Shipping cost + Taxes. Decimal numbers must be separated with a dot, for example, 12.45.

Payment Status: One of the two values must be written here: paid or un-paid, in exact same spelling.

Payment Method: Optional, you are free to write here anything that's needed.

Currency: A three-letter combination for currency must be written here, for example, USD, GBP, EUR. No symbols or full names.

Ship By Date: Optional. You can set the desired Ship By Date for the created order. The date format cannot be changed and must be YYYY/MM/DD.

Deliver By Date: Optional. You can set the desired Deliver By Date for the created order. The date format cannot be changed and must be YYYY/MM/DD.


Shipping Information

Shipping Date: Optional. If Carrier and Order Status changes are made to make the order Shipped, the system will use the current date of upload and assign that as Shipping Date. Or you can choose your own date, but it must only be used when creating Shipped orders or when updating a New or In-Progress order to Shipped. The date format cannot be changed and must be YYYY/MM/DD.

Shipping Carrier: Assigns a carrier name for the shipped order. Must only be used when creating Shipped orders or when updating a New or In-Progress order to Shipped.

Tracking Code: Optional. The tracking code for the said carrier (make sure it is not a tracking link but an actual number).

Shipping Service: Used to display the shipping service chosen by the customer. Can be used when creating New, In-Progress, or Shipped orders. This field is especially important if you plan the order to be fulfilled automatically via Amazon MCF.

Shipping Charge: Optional. Here you can add the cost of shipment. The field is not publicly visible yet and will be used in future updates.

Order Status: Available statuses are New, In-Progress, Dispatched (shipped) - they should be used exactly as written here. Please remember that to create a shipped order or to update a new order to shipped all shipping-related information must be provided.

Customer Address Details

Buyer Firstname: Must be used for contact information.

Buyer Lastname: Must be used for contact information.

Buyer Email: Must be used for carriers to send updates or contact them or used for sending invoices and notes from Multiorders to the customer.

Buyer Phone: Used as a means for carriers to send updates or contact them, depending on the carrier service chosen.

Buyer Address Line1: Key shipping address information.

Buyer Address Line2: Optional. Most carriers can are fine with only knowing the first line of address, but we recommend you provide as much information as possible.

Buyer City: Key shipping address information.

Buyer State: Key shipping address information. When creating US-based addresses always use short-form state names like “TX, LA, NY”.

Buyer Country: Key shipping address information. Can use short from “US, GB” or full country names.

Buyer Postcode: Key shipping address information.

Buyer Country ISO: A two-letter country code must be used, for example, US, GB.

The same rules apply to the Recipient (shipping) address details.

Did this answer your question?