Customer email address.

Payment status.

Fulfilment status.

Payment Method.

Order total cost.

Order tax $.

Order comments.

Shipping rate.

Shipping Person Name.

Shipping Method Name.

Shipping Person Company Name.

Shipping Person Street.

Shipping Person City.

Shipping Person Country Code.

Shipping Person Postal Code.

Shipping Person State or Province Code.

Shipping Person Phone.

Full name.

Company name.

Address.

Billing Person City.

Two-letter country code.

Postal/ZIP code.

State code, e.g. NY.

Phone number.

Order subtotal. Includes the sum of all products’ cost in the order (item’s price x quantity)

Payment processor name

Discount applied to order using a coupon

URL of the page when order was placed (without hash (#) part)

Sum of discounts based on subtotal. Is included into the "discount" field

Unique customer internal ID (if the order is placed by a registered user)

Determines if the order is hidden (removed from the list). Applies to unfinished orders only.

Sum of discounts based on customer group. Is included into the "discount" field

The sum of discount based on subtotal AND customer group. Is included into the "discount" field

The sum of all applied discounts except for the coupon discount.

URL that the customer came to the store from

The date/time of order placement, e.g 2014-06-06 18:57:19 +0000

The name of group (membership) the customer belongs to

Shipping tracking code

Message from the payment processor if any. It is present and visible in order details only if order status is not paid. When order becomes paid, "paymentMessage" is cleared

Transaction ID / invoice number of the order in the payment system (e.g. PayPal transaction ID)

Private note about the order from store owner. Ignored when creating orders with public token

Order pickup time in the store date format, e.g.: "2017-10-17 05:00:00 +0000"

"true" if customer has accepted email marketing and you can use their email for promotions. If value is "false", you can’t use this email for promotions

"true" if no email notifications are sent to customer. If "false" or empty, then email notifications are sent to customer according to store mail notification settings. This field does not influence admin email notifications

Set "true" if order is fulfilled in an external system; Ecwid will hide fulfillment status change feature and ability to set tracking number within Ecwid Control Panel in order details. Set "false" to manage order fulfillment within Ecwid Control Panel

Corresponding order number in an external system where order is fulfilled. Use together with the "externalFulfillment" field

Amount of product items in stock.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Base product price.

Product’s sale price displayed strike-out in the customer frontend

Product weight in the units defined in store settings. Leave empty for intangible products

"true" to make product enabled, "false" otherwise. Disabled products are not displayed in the storefront.

Product description in HTML

Customer search term. Used to search in customer name and email only. If your keywords contain special characters, it may make sense to URL encode them before making a request

Customer's email.

Customer register date/time (lower bound). Supported formats: UNIX timestamp. Examples: 1447804800

Customer register date/time (upper bound). Supported formats: UNIX timestamp

Customer last update date/time (lower bound). Supported formats: UNIX timestamp

Customer last update date/time (upper bound). Supported formats: UNIX timestamp

Customer's password.

Product SKU.

Amount of product items in stock.

Product weight in the units defined in store settings.

True to make product enabled, false otherwise. Disabled products are not displayed in the store front.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Product’s sale price displayed strike-out in the customer frontend

"true" if product requires shipping, "false" otherwise

The minimum 'warning’ amount of the product items in stock, if set. When the product quantity reaches this level, the store administrator gets an email notification.

Customer search term. Used to search in customer name and email only. If your keywords contain special characters, it may make sense to URL encode them before making a request

Customer register date/time (lower bound). Supported formats: UNIX timestamp. Examples: 1447804800

Customer register date/time (upper bound). Supported formats: UNIX timestamp

Customer last update date/time (lower bound). Supported formats: UNIX timestamp

Customer last update date/time (upper bound). Supported formats: UNIX timestamp

Search term. Use quotes to search for exact match. Ecwid searches products over multiple fields: title, description, SKU, product options, category name, gallery image descriptions, attribute values (except for hidden attributes).

Product SKU.

Internal Ecwid product ID or multiple productIds separated by a comma. If this field is specified, other search parameters are ignored.

True to make product enabled, false otherwise. Disabled products are not displayed in the store front.

Amount of product items in stock.

Product weight in the units defined in store settings.

Set as "true" to make Unlimited stock for the product and to not track product inventory.

Product’s sale price displayed strike-out in the customer frontend

"true" if product requires shipping, "false" otherwise

The minimum 'warning’ amount of the product items in stock, if set. When the product quantity reaches this level, the store administrator gets an email notification.