usedCoupons | Array of objects (Used coupons)Used coupons |
Array id | integer | code | string | value | string | order | | coupon | |
|
uspsShipment | Array of objects (USPS Shipments)USPS Shipments |
Array id | integer | transactionId | string | order | | requestData | Array | responseData | Array | printDate | integer | price | string | shipmentId | string | trackingNumber | string | trackingData | Array | labelURL | string | labelContent | Array |
|
capostParcels | Array of objects (Canada Post parcels (reference to the Canada Post parcels model))Canada Post parcels (reference to the Canada Post parcels model) |
Array id | integer | number | integer | status | string | quoteType | string | order | | items | Array | shipment | | boxWeight | string | boxWidth | string | boxLength | string | boxHeight | string | isDocument | boolean | isUnpackaged | boolean | isMailingTube | boolean | isOversized | boolean | notifyOnShipment | boolean | notifyOnException | boolean | notifyOnDelivery | boolean | optSignature | boolean | optCoverage | string | optAgeProof | string | optWayToDeliver | string | optNonDelivery | string |
|
capostReturns | Array of objects (Reference to the Canada Post returns model)Reference to the Canada Post returns model |
Array id | integer | items | Array | links | Array | order | | status | string | date | integer | lastRenewDate | integer | notes | string | adminNotes | string | trackingPin | string |
|
capostOffice | object |
id | integerUnique ID | order | | officeId | stringThe internal Canada Post assigned unique ID for a Post Office
(Field pattern: "\d{10}", has leading zeros) | name | stringThe name assigned to the Post Office
(Max length: 40) | location | stringThe location of a Post Office. This is used to distinguish among various Post Offices that have similar names.
(Max length: 40) | distance | stringThe distance (in KM) to the Post Office from the location specified in the query
(min: 0, max: 99999.99, fraction: 2) | bilingualDesignation | booleanTrue indicates that the Post Office provides bilingual services (English and French) | city | stringMunicipality in which the Post Office is located
(Max length: 40) | latitude | stringThe latitude of the Post Office
(min: 40, max: 90, fraction: 5) | longitude | stringThe longitude of the Post Office
(min: -150, max: -50, fraction: 5) | postalCode | stringThe Postal Code of the Post Office | province | stringThe province where the Post Office is located | officeAddress | stringStreet number and name for a Post Office
(Max length: 64) | workingHours | ArrayWorking hours list |
|
giftWrapping | boolean |
greetingMessage | string |
mailchimpStoreId | stringMailchimp store id |
mandrill_mails | Array of objects (Mandrill e-mail messages)Mandrill e-mail messages |
Array mail_id | string | opened | boolean | clicked | boolean | ip | string | country_short | string | mobile | boolean | os_family | string | ua_family | string | order | |
|
not_finished_order | object |
usedCoupons | ArrayUsed coupons | uspsShipment | ArrayUSPS Shipments | capostParcels | ArrayCanada Post parcels (reference to the Canada Post parcels model) | capostReturns | ArrayReference to the Canada Post returns model | capostOffice | | giftWrapping | boolean | greetingMessage | string | mailchimpStoreId | stringMailchimp store id | mandrill_mails | ArrayMandrill e-mail messages | not_finished_order | | pbOrder | | conversation | | order_id | integerOrder unique id | profile | | orig_profile | | shipping_id | integerShipping method unique id | shipping_method_name | stringShipping method name | payment_method_name | stringPayment method name | tracking | stringShipping tracking code | date | integerOrder creation timestamp | lastRenewDate | integerLast order renew date | paymentStatus | object | id | integerID | code | stringStatus code | position | integerPosition |
| shippingStatus | object | id | integerID | code | stringStatus code | position | integerPosition |
| notes | stringCustomer notes | adminNotes | stringAdmin notes | details | ArrayOrder details | trackingNumbers | ArrayOrder tracking numbers | events | ArrayOrder events queue | items | ArrayOrder items | surcharges | ArrayOrder surcharges | payment_transactions | ArrayPayment transactions | currency | | orderNumber | stringUnique order identificator (it is working for orders only, not for cart entities) | recent | booleanRecent flag: true if order's statuses were not changed manually by an administrator, otherwise - false | xcPendingExport | booleanFlag to exporting entities | total | stringTotal | subtotal | stringSubtotal |
|
pbOrder | object |
id | integerID | ormus | stringOrder ID returned by PB | transactionId | stringTransaction ID | order | | parcels | ArrayParcels association | createOrderResponse | object | |
|
conversation | object |
id | integerUnique ID | messages | ArrayMessages | order | | members | ArrayConversation members |
|
order_id | integerOrder unique id |
profile | object |
gaClientId | stringGoogle analytics cid | socialLoginProvider | stringAuth provider (facebook, google, etc.) | socialLoginId | stringAuth provider-unique user id (for ex. facebook user id) | pictureUrl | stringProfile picture url | mail_chimp_lists | ArrayMailChimp lists | mail_chimp_interests | ArrayMailChimp lists | mail_chimp_segments | ArrayMailChimp segments | auth_phone_number | stringAuthentication phone number | auth_phone_code | stringAuthentication phone country code | authy_id | integerID in Authy | conversations | ArrayCoupons | profile_id | integerProfile unique ID | login | stringLogin (e-mail) | password | stringPassword | password_hint | stringPassword hint | password_hint_answer | stringPassword hint answer | passwordResetKey | stringPassword reset key (for 'Forgot password') | passwordResetKeyDate | integerTimestamp of reset key creation date | access_level | integerAccess level | cms_profile_id | integerCMS profile Id | cms_name | stringCMS name | added | integerTimestamp of profile creation date | first_login | integerTimestamp of first login event | last_login | integerTimestamp of last login event | status | stringProfile status | statusComment | stringStatus comment (reason) | referer | stringReferer | order | | event | ArrayRelation to an event | language | stringLanguage code | last_shipping_id | integerLast selected shipping id | last_payment_id | integerLast selected payment id | membership | object (Membership: many-to-one relation with memberships table)Membership: many-to-one relation with memberships table | | pending_membership | object (Pending membership: many-to-one relation with memberships table)Pending membership: many-to-one relation with memberships table | | addresses | ArrayAddress book: one-to-many relation with address book entity | roles | ArrayRoles | anonymous | booleanFlag of anonymous profile (used for checkout process only) | forceChangePassword | booleanFlag if the user needs to change the password.
The customers only | dateOfLoginAttempt | integerDate of last login attempt | countOfLoginAttempts | integerCount of login attempt | searchFakeField | stringFake field for search | xcPendingExport | booleanFlag to exporting entities |
|
orig_profile | object |
gaClientId | stringGoogle analytics cid | socialLoginProvider | stringAuth provider (facebook, google, etc.) | socialLoginId | stringAuth provider-unique user id (for ex. facebook user id) | pictureUrl | stringProfile picture url | mail_chimp_lists | ArrayMailChimp lists | mail_chimp_interests | ArrayMailChimp lists | mail_chimp_segments | ArrayMailChimp segments | auth_phone_number | stringAuthentication phone number | auth_phone_code | stringAuthentication phone country code | authy_id | integerID in Authy | conversations | ArrayCoupons | profile_id | integerProfile unique ID | login | stringLogin (e-mail) | password | stringPassword | password_hint | stringPassword hint | password_hint_answer | stringPassword hint answer | passwordResetKey | stringPassword reset key (for 'Forgot password') | passwordResetKeyDate | integerTimestamp of reset key creation date | access_level | integerAccess level | cms_profile_id | integerCMS profile Id | cms_name | stringCMS name | added | integerTimestamp of profile creation date | first_login | integerTimestamp of first login event | last_login | integerTimestamp of last login event | status | stringProfile status | statusComment | stringStatus comment (reason) | referer | stringReferer | order | | event | ArrayRelation to an event | language | stringLanguage code | last_shipping_id | integerLast selected shipping id | last_payment_id | integerLast selected payment id | membership | object (Membership: many-to-one relation with memberships table)Membership: many-to-one relation with memberships table | | pending_membership | object (Pending membership: many-to-one relation with memberships table)Pending membership: many-to-one relation with memberships table | | addresses | ArrayAddress book: one-to-many relation with address book entity | roles | ArrayRoles | anonymous | booleanFlag of anonymous profile (used for checkout process only) | forceChangePassword | booleanFlag if the user needs to change the password.
The customers only | dateOfLoginAttempt | integerDate of last login attempt | countOfLoginAttempts | integerCount of login attempt | searchFakeField | stringFake field for search | xcPendingExport | booleanFlag to exporting entities |
|
shipping_id | integerShipping method unique id |
shipping_method_name | stringShipping method name |
payment_method_name | stringPayment method name |
tracking | stringShipping tracking code |
date | integerOrder creation timestamp |
lastRenewDate | integerLast order renew date |
paymentStatus | object |
id | integerID | code | stringStatus code | position | integerPosition |
|
shippingStatus | object |
id | integerID | code | stringStatus code | position | integerPosition |
|
notes | stringCustomer notes |
adminNotes | stringAdmin notes |
details | Array of objects (Order details)Order details |
Array detail_id | integer | name | string | label | string | value | string | order | |
|
trackingNumbers | Array of objects (Order tracking numbers)Order tracking numbers |
Array tracking_id | integer | value | string | order | |
|
events | Array of objects (Order events queue)Order events queue |
Array event_id | integer | date | integer | code | string | description | string | data | Array | comment | string | details | Array | order | | author | |
|
items | Array of objects (Order items)Order items |
Array privateAttachments | Array | categoryAdded | string | pinCodes | Array | vatRate | string | capostParcelItems | Array | capostReturnItems | Array | customerAttachments | Array | parcelItems | Array | variant | | item_id | integer | object | | name | string | sku | string | price | string | itemNetPrice | string | discountedSubtotal | string | amount | integer | order | | surcharges | Array | attributeValues | Array | total | string | subtotal | string |
|
surcharges | Array of objects (Order surcharges)Order surcharges |
Array owner | | id | integer | type | string | code | string | class | string | include | boolean | available | boolean | value | string | name | string | weight | integer |
|
payment_transactions | Array of objects (Payment transactions)Payment transactions |
Array transaction_id | integer | date | integer | publicTxnId | string | method_name | string | method_local_name | string | status | string | value | string | note | string | type | string | public_id | string | order | | payment_method | object | method_id | integerPayment method unique id | service_name | stringMethod service name (gateway or API name) | class | stringProcess class name | moduleName | stringSpecific module family name | orderby | integerPosition | adminOrderby | integerPosition in popup | enabled | booleanEnabled status | moduleEnabled | booleanModule enabled status | added | booleanAdded status | type | stringType | settings | ArraySettings | fromMarketplace | booleanFlag:
1 - method has been got from marketplace,
0 - method has been added after distr or module installation | iconURL | stringPayment method icon URL (used for methods from marketplace) | countries | ArrayCountries of merchant (merchants from these countries can sign up and use this method) | exCountries | ArrayExcluded countries (merchants from these countries cannot sign up for payment account) |
| data | Array | backend_transactions | Array | currency | |
|
currency | object |
currency_id | integerCurrency unique id (ISO 4217 number) | code | stringCurrency code (ISO 4217 alpha-3) | symbol | stringSymbol | prefix | stringPrefix | suffix | stringSuffix | e | stringNumber of digits after the decimal separator. | decimalDelimiter | stringDecimal part delimiter | thousandDelimiter | stringThousand delimier | orders | ArrayOrders | countries | ArrayCountries |
|
orderNumber | stringUnique order identificator (it is working for orders only, not for cart entities) |
recent | booleanRecent flag: true if order's statuses were not changed manually by an administrator, otherwise - false |
xcPendingExport | booleanFlag to exporting entities |
total | stringTotal |
subtotal | stringSubtotal |