You are here: Importing and Exporting > Understanding Importing and Exporting > Order Column Definitions

Order Column Definitions

The table below shows the columns that you can import in a default or custom template to add or modify orders through a data exchange. Columns that can be imported can also be exported in a default or custom template. For instructions, see To add an order import template.

For detailed information about which columns are required or recommended for adding a new order or modify an existing order, see the following sections in Importing Orders Overview:

When you import to add orders, your file should include required columns along with only those optional columns that are unique to the order such as Notes. When you import to modify orders, your file should include required columns along with only those columns that you want to modify.

Column header Label in the Monsoon desktop Definition

Import value

Example entry Can you add data during an add import? Can you modify data or use the data to identify an order during an import?
MonsoonOP

An import operator tells Monsoon Marketplace how to process inventory and order imports. For inventory, you can add a new SKU, decrease a SKU's quantity, modify an existing SKU, or update a SKU. For orders, you can add a new order or modify an existing order. For more information, see Import Operators.

Orders: a, m

a Required Required
ActualPostage Actual Postage

An order's actual postage cost.

The amount entered on the first order line item only imports and displays in the Actual Postage box

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. $6.95 No Yes

Address1

Address 1 The ship to street address. An alphanumeric string with a maximum length of 255 characters. 520 NW Davis St. Required No

Address2

Address 2 The second line of the ship to street address. An alphanumeric string with a maximum length of 255 characters. Suite 300 Yes No
BuyerEmail Email The buyer's email address. An alphanumeric string with a maximum length of 255 characters. winchester@zombie.com Yes No

BuyerName

Buyer Name The buyer's complete name (first and last). An alphanumeric string with a maximum length of 255 characters. Shaun Wright Required No
BuyerPhoneNumber Buyer Phone Number The buyer's phone number. An alphanumeric string with a maximum length of 50 characters. 555-555-5555 Yes No
CarrierCode Carrier Code

The import code for an order's shipping carrier.

For a complete list of valid import codes, see Supported shipping carriers and import codes. USPS Yes Yes

City

City The ship to city. An alphanumeric string with a maximum length of 255 characters. Portland Required No
CostOfGoods Cost of goods The cost of goods value for an item at the time of the order. A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. $6.50 No No

Country

Country The ship to country. An alphanumeric string with a maximum length of 255 characters. USA Required No
IsMfnPrime When IsMfnPrime is set to True, the Amazon order item is Merchant Fulfilled Prime. When IsMfnPrime is set to False, the Amazon order item is either merchant fulfilled or Fulfilled By Amazon (FBA) True, False True No No
InternalNotes Internal Notes The Internal Notes field allows you to add notes to an order that are only visible to Monsoon users and are not visible to buyers. For example, this could be used to add customer service notes. An alphanumeric string with a maximum length of 1000 characters. This item was refunded because it was not in stock. The item sold in our brick and mortar store before it could be removed from Amazon.com. Yes

No

MarketName Market

The name of the market.

We recommend that you import MarketName when you modify an order if it's possible one or more of the markets you sell on could have the same MarketOrderId. When you import MarketName with MarketOrderId, Monsoon Marketplace can differentiate between the orders. If Monsoon Marketplace can't differentiate, order modifications in the import file will be rejected.

Valid import values are a data exchange market name or Abebooks, Alibris, AmazonMarketplaceCA, AmazonMarketplaceDE, AmazonMarketplaceFR, AmazonMarketplaceES, AmazonMarketplaceIT, AmazonMarketplaceUK, AmazonMarketplaceUS, Ebay, EbayUK, HalfDotCom, Rakuten.com, and Walmart.

An alphanumeric string with a maximum length of 25 characters. Winchester No

Yes

You can't change a market name, but you can import a market's name to differentiate between orders that have the same MarketOrderId.

MarketOrderId

Market Order Id

The unique identifier that a market assigns to an order.

An alphanumeric string with a maximum length of 63 characters. 63310007 Required Required

MarketOrderItemId

Mkt Order Item Id

The unique identifier that a market assigns to an order line item.

If an order has multiple order line items for the same SKU and MarketOrderItemId is not included in the import file, Monsoon Marketplace imports the first line item and rejects the remaining order items as duplicates.

An alphanumeric string with a maximum length of 63 characters. 38893516 Required when an order contains multiple line items for the same SKU. Required to identify the order item you want to modify when an order contains multiple line items for the same SKU.

OrderDate

Order Date The date and time an order is placed in the format Year-Month-Day Hour-Minute-Second. For time, Monsoon Marketplace use the 24-hour convention for time-keeping. YYYY-MM-DD HH:MM:SS 2014-09-30 15:13:45 Required No
OrderNote Note A note that prints on an order's packing slip. For more information, see Processing orders. An alphanumeric string with a maximum length of 255 characters. Thanks for your order. Yes No

OrderedQuantity

Ordered Qty

An item's ordered quantity.

A number between 0 and 32,767. 3 Required No

OrderStatus

Status

The status of an order.

When you import a new order using the a (add) operator, use New as the OrderStatus value. If you leave the column blank, Monsoon Marketplace automatically imports the order in New status.

For a modify file, the OrderStatus value can be Shipped or Cancelled. If you leave the OrderStatus column blank, you can only update ShippingTax, UserData, and NumericUserData.

If you import an OrderStatus of Shipped, but do not also import ShippedQuantity, Monsoon Marketplace moves the order status to Shipped and uses the Ordered Quantity number as the ShippedQuantity number.

If you import an OrderStatus of Shipped, but don't also import ShipDate, Monsoon Marketplace uses the import date.

Once the status of a data exchange order has been changed from New to Shipped or Cancelled, its status cannot be changed again.

OrderStatus values are not case sensitive.

New, Shipped, Cancelled Shipped Required

Required

The OrderStatus column is always required in a modify file. If you want to make changes to an order, but aren't ready to update its status from New to Shipped or Cancelled, use the value New in your import file.

PostalCode

Postal Code The ship to postal code. An alphanumeric string with a maximum length of 255 characters. 97209 Required No

Price

Price

A per-item price.

During import, Monsoon Marketplace multiplies the number in OrderedQuantity by the amount in Price. On the Orders tab, the calculated amount displays in Subtotal.

For example, if an order item has an OrderedQuantity of 5 and a Price of $4.50, then $22.50 displays in Subtotal.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 24.95 Required No
PromotionalPriceDiscount Market Promotional Discount

A fixed monetary amount.

During import, the amount in PromotionalPriceDiscount adds to the amount in PromotionalShippingDiscount. On the Orders tab, the total amount displays in the Market Promotional Discount box.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 5.00 Yes No
PromotionalShippingDiscount Market Promotional Discount

A fixed monetary amount.

During import, the amount in PromotionalPriceDiscount adds to the amount in PromotionalShippingDiscount. On the Orders tab, the total amount displays in the Market Promotional Discount box.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 4.95 Yes No
RefundAmount Refund Amount

The amount refunded for an order item in your home market currency.

During import, Monsoon Marketplace adds the amount entered for each order line item. On the Orders tab, the total amount displays in the Refund Amount box.

RefundAmount does not trigger a refund on the market, but is stored as an exportable value in the Monsoon Marketplace database.

If you import the RefundAmount column header, you must also import the OrderStatus header. If an order is in New status, you can import a status of Shipped or Cancelled. If an order is already in Shipped or Cancelled status, you must import the matching status: Shipped or Cancelled.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 12.95 No Yes
ReturnUnshippedQuantity Return Unshipped Quantity When ReturnUnshippedQuantity is set to True, it will return the unshipped quantity to the sku and locator. When ReturnUnshippedQuantity is set to False, it will not return quantity to the sku and locator. True, False True Yes Yes
ShipDate Ship Date

The order's ship date and time stamp in the format Year-Month-Day Hour-Minute-Second. For time, use the 24-hour convention for time-keeping.

The date and time entered on the first order line item imports and displays on the Orders tab in the Ship Date box. If you import the OrderStatus column with a value of Shipped, but do not import the ShipDate column header, Monsoon Marketplace uses the date and time of the import.

The value in ShipDate must be later than the value in OrderDate.

YYYY-MM-DD HH:MM:SS 2014-09-30 15:20:05 No Yes

ShippingFee

Shipping Fee

A per-item shipping fee.

During import, Monsoon Marketplace multiplies the number in OrderedQuantity by the monetary amount in ShippingFee. On the Orders tab, the calculated amount displays in Shipping Fee.

For example, if an order item has an OrderedQuantity of 5 and a ShippingFee of $1.25, then $6.25 displays in Shipping Fee.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 4.95 Required No

ShipMethod

Shipping Method

The order's shipping method.

Economy, Standard, Expedited, One Day, Two Day, International, Expedited International

ShipMethod values are not case sensitive.

Standard Required No
ShippedQuantity Shipped Qty

The quantity you shipped.

If you import the OrderStatus column header with a value of Shipped, but don't also import ShippedQuantity, Monsoon Marketplace moves the order status to Shipped and uses the Ordered Quantity number as the ShippedQuantity number.

If you import the OrderStatus column header with a value of Cancelled, but don't also import ShippedQuantity, Monsoon Marketplace moves the order status to Cancelled and uses 0 (zero) as the ShippedQuantity number.

ShippedQuantity can't be modified for FBA order items or be larger than OrderedQuantity.

A number between 0 and 32,767. 3 No Yes

ShipToName

Ship To Name The complete ship to name (first and last). An alphanumeric string with a maximum length of 255 characters. Shaun Wright Required No
ShipToPhoneNumber Ship To Phone Number The ship to phone number can be imported and exported, and stored when available for eBay US and eBay UK orders. An alphanumeric string with a maximum length of 50. 555-555-5555 Yes No
ShippingTax Shipping Tax

A per-item amount in your home market currency.

During import, Monsoon Marketplace multiplies the number in OrderedQuantity by the amount in ShippingTax. On the Orders tab, the total displays in the Shipping Tax box.

For example, if an order item has an OrderedQuantity of 5 and an imported ShippingTax of $1.20, then the total of $6.00 displays.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 1.20 Yes Yes

SKU

SKU

The unique identifier for an item that exists in your Monsoon Marketplace inventory.

If a SKU doesn't exist in your Monsoon Marketplace inventory, the order item can't be imported and an error file is created with the following message: Invalid column 'SKU'. Received order with unknown SKU ' '.You must process that portion of the order outside of the Monsoon Desktop.

An alphanumeric string with a maximum length of 63 characters. ABC123 Required Required
State State The state where the item is being shipped. An alphanumeric string with a maximum length of 255 characters. OR Yes No
Tax Tax

A per-item amount in your home market currency.

During import, Monsoon Marketplace multiplies the number in OrderedQuantity by the amount in Tax. On the Orders tab, the total displays in the Tax box.

For example, if an order item has an OrderedQuantity of 5 and a Tax of $1.25, then the total of $6.25 displays.

A number with a maximum of 7 digits to the left of the decimal point and 2 digits to the right. 1.25 Yes Yes
TrackingNumber Tracking Number An order's shipment tracking number. An alphanumeric string with a maximum length of 63 characters. 1Z 999 AA1 01 2345 6784 No Yes

See also

 

You are here: Importing and Exporting > Understanding Importing and Exporting > Order Column Definitions

©2016 Monsoon, Inc. All rights reserved.