Order User Guides
- Overview
- Order Management
- Order Fulfillment Logic
- Activity Log
- Settings
Inventory User Guides
- Overview
- Inventory
- Locations
- Networks
- Activity Log
Orders API Endpoints
- Orders (3.0.0)
- Developer Guide
- Orders FAQ
- Shopping Lists
- Shipping Methods
- Imports
- Exports
- Orders
- Frauds
- Notifications
- Backorders Preorders
- Cancellations
- Allocations
- Shipments
- Inventory Transfers
- Tracking
- Invoices
- Payments
- Credits
- Appeasements
- Returns
Inventory API Endpoints
- Inventory (3.0.0)
- Inventory FAQ
- Imports
- Counters
- Inventory
- Locations
- Networks
Search for invoices
Search for invoices by matching filter criteria.
curl --request POST \
--url https://api.fabric.inc/v3/invoices/search \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'x-fabric-channel-id: <x-fabric-channel-id>' \
--header 'x-fabric-tenant-id: <x-fabric-tenant-id>' \
--data '{
"filters": [
{
"condition": "EQ",
"field": "invoice.orders.orderNumber",
"value": "30490384"
},
{
"condition": "IN",
"field": "invoice.invoiceType",
"values": [
"RETURN",
"SHIPMENT"
]
}
],
"sort": "-invoice.invoicedAt"
}'
{
"data": [
{
"acknowledgedAt": "2022-08-01T20:03:28.483Z",
"auditLogs": [
{
"amount": 2.4,
"auditId": "a05b72dc-78d8-4ea4-90fc-2fe6a1fe1111",
"auditType": "CANCEL",
"auditedAt": "2023-03-12T09:24:54.804Z",
"employeeId": "6227",
"isSuccess": true,
"lineItemId": "b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569",
"lineItemNumber": 1,
"note": "Note",
"paymentToken": {
"paymentType": "VISA",
"token": "pi_34tr6787rt"
},
"policyCode": "POS",
"quantity": 1,
"reasonCode": "Scratched item",
"sku": "SKU0023",
"source": "POS",
"subReasonCode": "Scratched item",
"updatedFields": [
{
"fieldName": "UOM",
"fieldOriginalValue": "PK"
}
]
}
],
"channelId": "10",
"createdAt": "2022-08-01T20:03:28.483Z",
"currency": "USD",
"customer": {
"accountId": "62272e917b12209e68751d94",
"address": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"company": "Demo Inc",
"email": "test@example.com",
"employeeId": "62272e917b12209e68751d94",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"userId": "62272e917b12209e68751d94"
},
"invoiceId": "62ff5c0bec0aed3c86202c32",
"invoiceNumber": "23940791",
"invoiceStatus": "CAPTURED",
"invoiceTotal": 245.7,
"invoiceType": "SHIPPING",
"invoicedAt": "2022-08-01T20:03:28.483Z",
"location": {
"address": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"contacts": [
{
"email": "test@example.com",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
}
}
],
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"locationNumber": "3235"
},
"locationNumber": "3235",
"orders": [
{
"adjustments": [
{
"adjustmentCounter": 1,
"attributes": {},
"notes": "Any additional info",
"quantity": 1,
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping",
"value": 34.56
}
],
"appeasements": [
{
"amount": 34.56,
"appeasementCounter": 1,
"invoicedAmount": 34.56,
"payments": [
{
"paymentCounter": 1,
"refundAmount": 34.56
}
],
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping"
}
],
"discounts": [
{
"amount": 2,
"promotionCode": "HNY2022",
"promotionId": "HNY2022",
"promotionName": "Happy New Year",
"quantity": 2,
"type": "promotion"
}
],
"fees": [
{
"amount": 34.56,
"quantity": 1,
"refundAmount": 345.56,
"type": "tax"
}
],
"invoiceOrderTotal": 245.7,
"items": [
{
"adjustmentTotal": 123.45,
"adjustments": [
{
"adjustmentCounter": 1,
"attributes": {},
"notes": "Any additional info",
"quantity": 1,
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping",
"value": 34.56
}
],
"appeasements": [
{
"amount": 34.56,
"appeasementCounter": 1,
"invoicedAmount": 34.56,
"payments": [
{
"paymentCounter": 1,
"refundAmount": 34.56
}
],
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping"
}
],
"currency": "USD",
"discounts": [
{
"amount": 2,
"promotionCode": "HNY2022",
"promotionId": "HNY2022",
"promotionName": "Happy New Year",
"quantity": 2,
"type": "promotion"
}
],
"fees": [
{
"amount": 34.56,
"quantity": 1,
"refundAmount": 345.56,
"type": "tax"
}
],
"invoiceLineNumber": 3,
"invoiceLineTotal": 600,
"invoiceQuantity": 10,
"itemAppeasementTotal": 344.455,
"itemDiscountsTotal": 3.45,
"itemFeeTotal": 33.4,
"itemId": 1234455322,
"itemTaxTotal": 2.4,
"itemUnitPrice": 33.4,
"lineItemCreatedAt": "2022-11-22T10:26:38Z",
"lineItemId": "1adfrghhh2346aaaf",
"lineItemNumber": 1,
"locationStoreId": "4512345",
"orderId": "33adfrghhh2346aaaffff",
"returnExpirationDays": "21",
"returns": [
{
"exchangeLineItemId": "62f3dfc438bcab1951be0a19",
"fees": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"invoicedAmount": 11.29,
"isExchangeItemReturned": true,
"reasonCode": "Incorrect item",
"refundAmount": 11.29,
"refunds": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"returnRequestCounter": 1,
"returnsReceivedAt": "2022-09-14T14:07:36.861Z",
"shipmentId": "62b37697c67b204dd18a7465",
"shipmentInvoice": {
"invoiceId": "62ff5c0bec0aed3c86202c32",
"invoiceNumber": "23940791",
"invoicedAt": "2022-08-01T20:03:28.483971941Z"
},
"shipmentLineItemId": "234",
"shipmentQuantity": 1
}
],
"shipToId": "5349b4ddd2781d08c09890f4",
"shipmentLineItemId": "2adfrghhh2346aaaffff",
"sku": "P1234",
"taxDetails": [
{
"amount": 34.56,
"type": "tax"
}
],
"type": "WEB_PICKUP",
"uom": "EA"
}
],
"orderId": "62ff5c0bec0aed3c86202c32",
"orderNumber": "217088603",
"orderSubtype": "INTERNATIONAL",
"orderType": "WEB",
"orderedAt": "2022-05-12T09:30:31.198Z",
"payments": [
{
"attributes": {},
"authorizedAmount": 256.1,
"billToAddress": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"conversion": 1,
"currency": "USD",
"paidAt": "2022-01-27T16:15:58.000-05:00",
"paymentCounter": 1,
"paymentIdentifier": {
"cardIdentifier": "***********3456"
},
"paymentMethod": "CREDIT_CARD",
"paymentProvider": "stripe",
"paymentStatus": "PAID",
"paymentToken": {
"token": "pi_34tr6787rt"
},
"paymentType": "VISA",
"settlement": {
"settledAt": "2022-01-27T21:15:58Z",
"settlementAmount": 10.3,
"settlementStatusCode": "SETTLED"
}
}
],
"returns": [
{
"fees": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"invoicedAmount": 11.29,
"paymentCounterRefundDetails": [
{
"amount": 34.56,
"paymentCounter": 1
}
],
"refunds": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"returnCounter": 1,
"totalRefundAmount": 11.29
}
],
"taxDetails": [
{
"amount": 34.56,
"type": "tax"
}
]
}
],
"postedAt": "2022-08-01T20:03:28.483971941Z",
"retail": {
"cashierId": "CE-321",
"locationNumber": 334
},
"shipInfo": {
"discounts": [
{
"amount": 2.99,
"promotionCode": "SHIPFREE",
"promotionId": "SHIPFREE",
"promotionName": "Free Shipping",
"quantity": 1,
"unit": "AMOUNT_OFF",
"value": 10
}
],
"estimatedDeliveryDate": "2022-05-12T09:30:31.198Z",
"estimatedShipDate": "2022-05-12T09:30:31.198Z",
"isInvoiced": true,
"locationNumber": "123",
"pickups": [
{
"email": "test@example.com",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"pickupType": "PRIMARY"
}
],
"shipMethod": "Parcel post delivery",
"shipToAddress": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"shipToDiscount": 12.6,
"shipToId": "b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569",
"shipToPrice": 20,
"shipToTaxTotal": 12.6,
"shipToType": "SHIP_TO_ADDRESS",
"shipToUnitPrice": 20,
"shipmentInstructions": "Handle with care",
"taxCode": "FR01",
"taxDetails": [
{
"amount": 34.56,
"attributes": {},
"currency": "USD",
"name": "STATE",
"rate": 10,
"rateType": "PERCENTAGE",
"taxCode": "FR01"
}
]
},
"shipmentId": "62ff5c0bec0aed3c86202c32",
"shipmentNumber": "217088603",
"shippedAt": "2022-08-01T20:03:28.483Z",
"statusCode": "CREATED",
"totalTaxAmount": 245.7,
"updatedAt": "2022-08-01T20:03:28.483971941Z",
"version": 2
}
],
"pagination": {
"count": 1000,
"limit": 10,
"offset": 1
}
}
Authorizations
Bearer authentication header of the form Bearer <token>
, where <token>
is your auth token.
Headers
A header used by fabric to identify the tenant making the request. You must include tenant id in the authentication header for an API request to access any of fabric’s endpoints. You can retrieve the tenant id , which is also called account id, from Copilot. This header is required.
x-fabric-channel-id identifies the sales channel where the API request is being made; primarily for multichannel use cases. The channel ids are 12 corresponding to US and 13 corresponding to Canada. The default channel id is 12. This field is required.
Unique request ID
Query Parameters
Number of records to skip before returning all records. Default is 0
if no value is specified.
0
Maximum number of records returned per page. Default is 10
if no value is specified.
1 <= x <= 100
10
Body
Sort and filter criteria for invoice search
Criteria to find invoice by a single value. Condition between field
and value
is anything except IN and NIN when valueSearchFilter
is used.
Filter conditions. EQ (Equal to): Searches for exact match. NEQ (Not equal to): Searches by excluding the specified value. IN: Search for multiple values. NIN (Not IN): Excludes the specified values in the search. LT (Less than): Searches for values that are less than the specified value. GT (Greater than): Search for values that are greater than the specified value. LTE (Less than or equal to): Searches for values that are less than or equal to the specified value. GTE (Greater than or equal to): Searches for values that are greater than or equal to the specified value.
EQ
, NEQ
, IN
, NIN
, LT
, GT
, LTE
, GTE
"EQ"
Field name
"invoice.invoiceType"
The group name.
"GroupA"
A single value for field
using which data is searched
"ORDER_CREATE"
Property by which data is sorted. Note: -
refers to descending and +
refers to ascending order
"+invoice.invoicedAt"
Response
Invoice search response
Invoice response
Sales channel ID
"10"
Currency type in which amount is invoiced
"USD"
System-generated unique invoice ID
"62ff5c0bec0aed3c86202c32"
Total invoiced amount captured for the order
245.7
24-character system-generated shipment ID for which invoice is generated
"62ff5c0bec0aed3c86202c32"
Current invoice status. CREATED: Initially, the status is set as CREATED when invoice is generated automatically by fabric POSTED: When Invoice service sends an event notification to webhook service, status gets updated to POSTED. ACKNOWLEDGED: When retailers successfully acknowledge an invoice, status is changed to ACKNOWLEDGED.
CREATED
, POSTED
, ACKNOWLEDGED
"CREATED"
Total tax amount invoiced
245.7
The current version of invoice document. The integer indicates the number of times the invoice has been updated by any operation.
2
Invoice acknowledgement time by merchant
"2022-08-01T20:03:28.483Z"
Audit log
Audit log to capture change history
Amount for which audit's done
2.4
System-generated audit ID (UUID format)
"a05b72dc-78d8-4ea4-90fc-2fe6a1fe1111"
Audit type such as cancel, return, etc.
"CANCEL"
Audit time (UTC)
"2023-03-12T09:24:54.804Z"
Employee (ID or name) who made the last update
"6227"
true: Update operation (any update to the service) is successful false: Update operation has failed
true
Merchant-defined unique identifier for each item in an order. When omitted, fabric will generate it during order creation, in UUID format.
"b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569"
Item identifier
1
Additional info, if any
"Note"
Configurable in Copilot as per requirement. If omitted, default policy is used.
"POS"
Ordered quantity of given item
1
Merchant-defined reason code, varies from merchant to merchant
"Scratched item"
Stock keeping unit (SKU), unique item identifier
"SKU0023"
Merchant-defined source from where the update was initiated. There are no predefined values; possible values could be Customer Service Representative (CSR), Point-of-Sale (POS), etc.
"POS"
Merchant-defined sub reason code; provides more clarity to audit reason
"Scratched item"
Time invoice was created
"2022-08-01T20:03:28.483Z"
Customer details for the generated invoice
Customer's loyalty account ID or external identifier that's used to track their loyalty program activity and rewards earned.
"62272e917b12209e68751d94"
Address details
Address line 1
"123 Main St."
City name
"Seattle"
ISO 3166-1 alpha-2 based country code
"US"
Address latitude, used with longitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -90 and 90, both inclusive.
47.6205
Address longitude, used with latitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -180 and 180, both inclusive.
-122.3493
Postal or ZIP code
"98121"
Region or state
"WA"
Address type
"Home"
Address line 2
"Suite 100"
Address line 3
"Seventh floor"
Address line 4
"Attention: Pat E. Kake"
Contact person's email
"test@example.com"
Shopper's company name. This may be used for company discounts.
"Demo Inc"
Contact person's email
"test@example.com"
Employee (ID or name) who initiated an update request
"62272e917b12209e68751d94"
Identifier of the logged in user who initiated the request. This could be from either fabric Identity service or an external Identity service.
"62272e917b12209e68751d94"
Merchant-defined unique invoice number. If omitted, this is generated by fabric’s sequence generator using Configuration service.
"23940791"
System-generated invoice status. CAPTURED: authorizedAmount
is successfully captured. SETTLED: authorizedAmount
is successfully settled with the customer, meaning the authorized amount is fully paid by the shopper or is returned to the shopper in case of return of the item. SETTLED_FAILED: Settlement for the authorizedAmount
fails for a reason. PARTIAL_SETTLED: authorizedAmount
is partially settled. For example, the shopper might have paid some amount of the total authorized amount.
CAPTURED
, SETTLED
, SETTLE_FAILED
, PARTIAL_SETTLED
"CAPTURED"
System-updated invoice type. RETURN: Return invoices are generated in the event of order returns. SHIPPING: Shipping invoices are generated during standard invoice creation when an item is shipped. APPEASEMENT: These invoices are created when customers are provided appeasements to fulfill their needs. ORDER_DONATION: These invoices are created when order isn't purchased by customer, but is donated. ORDER_CARRY: These invoices are generated when it's a Cash N Carry order. EXCHANGE: Exchange invoices are generated in the event of order exchanges.
RETURN
, SHIPPING
, APPEASEMENT
, ORDER_DONATION
, ORDER_CARRY
, EXCHANGE
"SHIPPING"
System-generated invoice creation time (UTC)
"2022-08-01T20:03:28.483Z"
Contains location details regarding shipment if invoiceType= SHIPPING
Address with contact details
Address line 1
"123 Main St."
City name
"Seattle"
ISO 3166-1 alpha-2 based country code
"US"
Address latitude, used with longitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -90 and 90, both inclusive.
47.6205
Address longitude, used with latitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -180 and 180, both inclusive.
-122.3493
Postal or ZIP code
"98121"
Region or state
"WA"
Address type
"Home"
Address line 2
"Suite 100"
Address line 3
"Seventh floor"
Address line 4
"Attention: Pat E. Kake"
Contact person's email
"test@example.com"
If invoiceType= SHIPPING
, location number refers to the inventory location from where the order is fulfilled.
"3235"
Unique value to identify ship-from location. This must be the locationNumber
stored in the fabric Location service.
"3235"
Invoice order details
Invoice order details
Total amount charged for the order
245.7
24-character system-generated unique order ID (UUID) for which invoice is created
"62ff5c0bec0aed3c86202c32"
Invoice adjustment details
Represents number of times adjustment has happened to the order
1
Custom attributes specific to tenant
Custom attributes specific to tenant
An optional free text field and is saved as a metadata
"Any additional info"
Adjustment quantity
1
Merchant-defined reason code for order adjustment, varies from merchant to merchant
"Incorrect Item"
Merchant-defined sub reason code
"Late shipping"
Amount
34.56
Invoice appeasement details
Appeasement details
Merchant-defined appeasement amount, which shouldn't exceed (charged amount - already refunded amount)
34.56
Sequential or incremental counter for appeasement. Used for keeping track of duplicates in the request. If omitted in the request, it's automatically generated and won't be used to check duplicates. Multiple appeasement calls for the same order can cause repetition of appeasement counter and may cause the request to be rejected completely.
1
System-generated amount from Invoice service based on requested amount
34.56
Merchant-defined appeasement reason code; varies from merchant to merchant
"Incorrect Item"
Subreason code for appeasement, for another layer of classification
"Late shipping"
Invoicing discount list
Invoice discount details
Unique promotion ID either from fabric Offers service or external Offers service. When fabric Offers service is used, this is the 24-character system-generated promotion ID returned in the response of Create promotion endpoint.
"HNY2022"
Discounted amount for the given quantity
2
Promotion code used by shoppers to take advantage of an ongoing promotion and avail discounts
"HNY2022"
Promotion title or name
"Happy New Year"
Number of discounted items in an order; example- buy 2 get 2 free
2
Promotion type
"promotion"
Invoice fee details
Invoice fee details
Amount charged for an item in the invoice
34.56
Quantity of items to which amount is charged
1
Refund amount for the invoice
345.56
Item fee type
"tax"
Invoicing item list
Invoice item sample
System-specified sequential number iterated for each item in the array of the invoice
3
The total number of price adjustments made for all items in this order.
123.45
Invoice adjustment details
Represents number of times adjustment has happened to the order
1
Custom attributes specific to tenant
An optional free text field and is saved as a metadata
"Any additional info"
Adjustment quantity
1
Merchant-defined reason code for order adjustment, varies from merchant to merchant
"Incorrect Item"
Merchant-defined sub reason code
"Late shipping"
Amount
34.56
Appeasements information, if invoiceType= APPEASEMENT
Appeasement details
Merchant-defined appeasement amount, which shouldn't exceed (charged amount - already refunded amount)
34.56
Sequential or incremental counter for appeasement. Used for keeping track of duplicates in the request. If omitted in the request, it's automatically generated and won't be used to check duplicates. Multiple appeasement calls for the same order can cause repetition of appeasement counter and may cause the request to be rejected completely.
1
System-generated amount from Invoice service based on requested amount
34.56
Order appeasement payment info
Merchant-defined appeasement reason code; varies from merchant to merchant
"Incorrect Item"
Subreason code for appeasement, for another layer of classification
"Late shipping"
Invoiced amount currency
"USD"
Discount applicable for Item
Invoice discount details
Unique promotion ID either from fabric Offers service or external Offers service. When fabric Offers service is used, this is the 24-character system-generated promotion ID returned in the response of Create promotion endpoint.
"HNY2022"
Discounted amount for the given quantity
2
Promotion code used by shoppers to take advantage of an ongoing promotion and avail discounts
"HNY2022"
Promotion title or name
"Happy New Year"
Number of discounted items in an order; example- buy 2 get 2 free
2
Promotion type
"promotion"
Fees charged for individual items of an invoice
Invoice fee details
Amount charged for an item in the invoice
34.56
Quantity of items to which amount is charged
1
Refund amount for the invoice
345.56
Item fee type
"tax"
Total invoiced amount per line item
600
Total quantity invoiced. If a customer placed an order for 10 quantities of an item and only 2 got shipped, then 2 is the invoiceQuantity
.
10
Total invoiced appeasement amount per line item
344.455
Total invoiced discount amount per line item
3.45
Total invoiced fee per line item. For fee, refer to amount
in invoiceFeeDetail
.
33.4
Unique identifier of item from fabric Products (previously called PIM) service
1234455322
Total invoiced tax amount per line item
2.4
Item's unit price
33.4
Time order line item was created
"2022-11-22T10:26:38Z"
Merchant-defined unique identifier for each item. When omitted, fabric will generate it during order creation, in UUID format.
"1adfrghhh2346aaaf"
Merchant-defined line item number to identify each item in an order
1
ID of the store from where the item is picked for shipment
"4512345"
24-character system-generated unique order ID (UUID) to which the item belongs
"33adfrghhh2346aaaffff"
Return expiration in days
"21"
If invoiceType= RETURN
, the details of the returned items will be included in the invoice.
Order return details
Exchange line item ID
"62f3dfc438bcab1951be0a19"
Return fee details
System-generated amount from Invoice service based on requested amount
11.29
true: Item received for exchange is returned false: Item received for exchange isn't returned
true
Merchant-defined reason code for return
"Incorrect item"
Refund amount
11.29
Return fee details
Unique, sequential, or incremental counter for return request
1
System-generated time of returned item that has come back to the facility (UTC)
"2022-09-14T14:07:36.861Z"
24-character system-generated shipment ID
"62b37697c67b204dd18a7465"
The shipment invoice resource object.
Unique identifier for each item in the shipment
"234"
Shipped quantity of given item
1
If invoiceType= SHIPPING
, the Ship-to ID corresponds to the shipment for which the invoice was generated.
"5349b4ddd2781d08c09890f4"
Unique identifier for shipment of the line item. This attribute is inherited from fabric shipment service.
"2adfrghhh2346aaaffff"
Stock Keeping Unit (SKU), unique identifier of item
"P1234"
Order item type
"WEB_PICKUP"
Item's unit of measurement. For example, for each quantity (EA), or GAL (Gallon), DZ (Dozens), etc.
"EA"
Merchant-specified order number for which invoice is created. Note: Order number can either be merchant-defined during Order creation request or it can be generated by fabric’s sequence generator feature in the Configuration service.
"217088603"
Order subtype for further order classification
IOS
, ANDROID
, INTERNATIONAL
"INTERNATIONAL"
Order type. Critical in order life cycle as it indicates the workflow that varies with the type. For example, Storefront orders have a different workflow than a Call Center order. fabric Orders service offers default configurations for Storefront, Call Center, Point of Sale, iOS, Android, and International
WEB
, CSC
, MOBILE_APP
, POS
"WEB"
System-generated order creation time
"2022-05-12T09:30:31.198Z"
Invoicing payment list
Payment resource details for the invoice
Merchant-defined custom attributes. This is a placeholder for additional info (in key: value pairs)
Merchant-defined custom attributes. This is a placeholder for additional info (in key: value pairs)
Amount authorized to be debited from the given paymentMethod
256.1
Address details
Address line 1
"123 Main St."
City name
"Seattle"
ISO 3166-1 alpha-2 based country code
"US"
Address latitude, used with longitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -90 and 90, both inclusive.
47.6205
Address longitude, used with latitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -180 and 180, both inclusive.
-122.3493
Postal or ZIP code
"98121"
Region or state
"WA"
Address type
"Home"
Address line 2
"Suite 100"
Address line 3
"Seventh floor"
Address line 4
"Attention: Pat E. Kake"
Contact person's email
"test@example.com"
Contact person's name
Contact person's phone details
Conversion required for currency
1
Three-letter currency code as defined by ISO-4217
"USD"
System-generated time (UTC) when payment was captured. In case of payment captured at checkout, this is a merchant-defined value given during order creation (UTC).
"2022-01-27T16:15:58.000-05:00"
Unique incremented number for this payment object
1
Invoice payment identifier
Card number
"***********3456"
Payment method such as PayPal or Credit Card
"CREDIT_CARD"
Name of the payment provider
"stripe"
Payment status. There are no predefined values; possible values are Paid, Partially Paid, Authorized, and Error.
"PAID"
Invoice payment token
Payment token number
"pi_34tr6787rt"
Payment type such as VISA or Mastercard
"VISA"
Invoice settlement details
System-generated invoice settlement time
"2022-01-27T21:15:58Z"
Amount that needs to be collected from or refunded to the shopper. It's invoicedAmount - chargedAmount
.
10.3
Invoice settlement status code SETTLED: Amount is captured successfully from the payment service PARTIAL_SETTLED: Amount is partially captured from the payment service SETTLEMENT_FAILED: Amount isn't captured from the payment service
SETTLED
, PARTIAL_SETTLED
, SETTLEMENT_FAILED
"SETTLED"
Order returns info
Return fee details
Merchant-defined return amount
34.56
Fee name
"RETURN_FEE"
Merchant-defined return reason
"Return fee"
Return fee type
TAX
, DISCOUNT
, FEE
, ITEM
, ADJUSTMENT
"FEE"
System-generated invoiced amount for the return request
11.29
Return fee details
Merchant-defined return amount
34.56
Fee name
"RETURN_FEE"
Merchant-defined return reason
"Return fee"
Return fee type
TAX
, DISCOUNT
, FEE
, ITEM
, ADJUSTMENT
"FEE"
Unique, sequential or incremental counter for return request
1
Merchant-defined total refund amount for the return request
11.29
Time invoice was emitted to third-party system for financial processing
"2022-08-01T20:03:28.483971941Z"
Order shipment details
System-generated UUID associated with shipInfo
, generated from CnC service. Note: An order can have multiple ship-to (delivery) locations and items going to the same location have one shipToId
.
"b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569"
Details of shipping discount
Discounted amount for the given quantity
2.99
Promotion code used by shoppers to take advantage of an ongoing promotion.
"SHIPFREE"
Unique promotion ID either from fabric Offers service or external Offers service. When fabric Offers service is used, this is the 24-character system-generated promotion ID returned in the response of create promotion endpoint.
"SHIPFREE"
Promotion name
"Free Shipping"
Number of discounted items in an order such as buy 2 get 1 free
. In this case 1
is the discounted quantity.
1
Indicates whether the discount is in amount or percentage
"AMOUNT_OFF"
Value corresponding to unit
10
Estimated delivery time (UTC) provided by carrier
"2022-05-12T09:30:31.198Z"
Estimated shipping time (UTC) provided by merchant
"2022-05-12T09:30:31.198Z"
true: At least one captured invoice is created by Invoice service false: Captured invoice isn't created
true
Unique value to identify ship-from or Buy Online Pickup from Store location. This must be the locationNumber
stored in the fabric Location service.
"123"
Order pickup details
Order pickup details
Contact person's email
"test@example.com"
Order pickup type
PRIMARY
, ALTERNATE
"PRIMARY"
Shipping method
"Parcel post delivery"
Address details
Address line 1
"123 Main St."
City name
"Seattle"
ISO 3166-1 alpha-2 based country code
"US"
Address latitude, used with longitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -90 and 90, both inclusive.
47.6205
Address longitude, used with latitude
to specify the address location. Decimal degrees format; negative is degrees South. **Note:**Value must be between -180 and 180, both inclusive.
-122.3493
Postal or ZIP code
"98121"
Region or state
"WA"
Address type
"Home"
Address line 2
"Suite 100"
Address line 3
"Seventh floor"
Address line 4
"Attention: Pat E. Kake"
Contact person's email
"test@example.com"
Merchant-defined shipping discount amount
12.6
Merchant-defined shipping cost
20
Total shipping tax
12.6
Type of shipping address. There are no pre-defined values; the possible values are SDD (Same Day Delivery), Point-of-Sale (POS), etc.
"SHIP_TO_ADDRESS"
Merchant-defined shipping cost
20
Shipment instructions
"Handle with care"
Applicable tax code, varies from state to state
"FR01"
Tax details
Tax amount
34.56
Merchant-defined custom attributes. This is a placeholder for additional info (in key: value pairs).
Merchant-defined custom attributes. This is a placeholder for additional info (in key: value pairs).
Three-letter currency code as defined by ISO-4217
"USD"
Applied tax name
"STATE"
Rate
10
Rate type
"PERCENTAGE"
Tax code applied
"FR01"
Merchant-specified shipment number for which invoice is generated
"217088603"
Order shipment time (UTC)
"2022-08-01T20:03:28.483Z"
Time invoice was updated
"2022-08-01T20:03:28.483971941Z"
Pagination response
Total number of search results
1000
Maximum number of records per page
1 <= x <= 100
10
Number of records to skip before returning all records. For example, offset=20, limit=10
returns records 21-30.
x >= 0
1
Was this page helpful?
curl --request POST \
--url https://api.fabric.inc/v3/invoices/search \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--header 'x-fabric-channel-id: <x-fabric-channel-id>' \
--header 'x-fabric-tenant-id: <x-fabric-tenant-id>' \
--data '{
"filters": [
{
"condition": "EQ",
"field": "invoice.orders.orderNumber",
"value": "30490384"
},
{
"condition": "IN",
"field": "invoice.invoiceType",
"values": [
"RETURN",
"SHIPMENT"
]
}
],
"sort": "-invoice.invoicedAt"
}'
{
"data": [
{
"acknowledgedAt": "2022-08-01T20:03:28.483Z",
"auditLogs": [
{
"amount": 2.4,
"auditId": "a05b72dc-78d8-4ea4-90fc-2fe6a1fe1111",
"auditType": "CANCEL",
"auditedAt": "2023-03-12T09:24:54.804Z",
"employeeId": "6227",
"isSuccess": true,
"lineItemId": "b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569",
"lineItemNumber": 1,
"note": "Note",
"paymentToken": {
"paymentType": "VISA",
"token": "pi_34tr6787rt"
},
"policyCode": "POS",
"quantity": 1,
"reasonCode": "Scratched item",
"sku": "SKU0023",
"source": "POS",
"subReasonCode": "Scratched item",
"updatedFields": [
{
"fieldName": "UOM",
"fieldOriginalValue": "PK"
}
]
}
],
"channelId": "10",
"createdAt": "2022-08-01T20:03:28.483Z",
"currency": "USD",
"customer": {
"accountId": "62272e917b12209e68751d94",
"address": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"company": "Demo Inc",
"email": "test@example.com",
"employeeId": "62272e917b12209e68751d94",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"userId": "62272e917b12209e68751d94"
},
"invoiceId": "62ff5c0bec0aed3c86202c32",
"invoiceNumber": "23940791",
"invoiceStatus": "CAPTURED",
"invoiceTotal": 245.7,
"invoiceType": "SHIPPING",
"invoicedAt": "2022-08-01T20:03:28.483Z",
"location": {
"address": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"contacts": [
{
"email": "test@example.com",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
}
}
],
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"locationNumber": "3235"
},
"locationNumber": "3235",
"orders": [
{
"adjustments": [
{
"adjustmentCounter": 1,
"attributes": {},
"notes": "Any additional info",
"quantity": 1,
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping",
"value": 34.56
}
],
"appeasements": [
{
"amount": 34.56,
"appeasementCounter": 1,
"invoicedAmount": 34.56,
"payments": [
{
"paymentCounter": 1,
"refundAmount": 34.56
}
],
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping"
}
],
"discounts": [
{
"amount": 2,
"promotionCode": "HNY2022",
"promotionId": "HNY2022",
"promotionName": "Happy New Year",
"quantity": 2,
"type": "promotion"
}
],
"fees": [
{
"amount": 34.56,
"quantity": 1,
"refundAmount": 345.56,
"type": "tax"
}
],
"invoiceOrderTotal": 245.7,
"items": [
{
"adjustmentTotal": 123.45,
"adjustments": [
{
"adjustmentCounter": 1,
"attributes": {},
"notes": "Any additional info",
"quantity": 1,
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping",
"value": 34.56
}
],
"appeasements": [
{
"amount": 34.56,
"appeasementCounter": 1,
"invoicedAmount": 34.56,
"payments": [
{
"paymentCounter": 1,
"refundAmount": 34.56
}
],
"reasonCode": "Incorrect Item",
"subReasonCode": "Late shipping"
}
],
"currency": "USD",
"discounts": [
{
"amount": 2,
"promotionCode": "HNY2022",
"promotionId": "HNY2022",
"promotionName": "Happy New Year",
"quantity": 2,
"type": "promotion"
}
],
"fees": [
{
"amount": 34.56,
"quantity": 1,
"refundAmount": 345.56,
"type": "tax"
}
],
"invoiceLineNumber": 3,
"invoiceLineTotal": 600,
"invoiceQuantity": 10,
"itemAppeasementTotal": 344.455,
"itemDiscountsTotal": 3.45,
"itemFeeTotal": 33.4,
"itemId": 1234455322,
"itemTaxTotal": 2.4,
"itemUnitPrice": 33.4,
"lineItemCreatedAt": "2022-11-22T10:26:38Z",
"lineItemId": "1adfrghhh2346aaaf",
"lineItemNumber": 1,
"locationStoreId": "4512345",
"orderId": "33adfrghhh2346aaaffff",
"returnExpirationDays": "21",
"returns": [
{
"exchangeLineItemId": "62f3dfc438bcab1951be0a19",
"fees": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"invoicedAmount": 11.29,
"isExchangeItemReturned": true,
"reasonCode": "Incorrect item",
"refundAmount": 11.29,
"refunds": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"returnRequestCounter": 1,
"returnsReceivedAt": "2022-09-14T14:07:36.861Z",
"shipmentId": "62b37697c67b204dd18a7465",
"shipmentInvoice": {
"invoiceId": "62ff5c0bec0aed3c86202c32",
"invoiceNumber": "23940791",
"invoicedAt": "2022-08-01T20:03:28.483971941Z"
},
"shipmentLineItemId": "234",
"shipmentQuantity": 1
}
],
"shipToId": "5349b4ddd2781d08c09890f4",
"shipmentLineItemId": "2adfrghhh2346aaaffff",
"sku": "P1234",
"taxDetails": [
{
"amount": 34.56,
"type": "tax"
}
],
"type": "WEB_PICKUP",
"uom": "EA"
}
],
"orderId": "62ff5c0bec0aed3c86202c32",
"orderNumber": "217088603",
"orderSubtype": "INTERNATIONAL",
"orderType": "WEB",
"orderedAt": "2022-05-12T09:30:31.198Z",
"payments": [
{
"attributes": {},
"authorizedAmount": 256.1,
"billToAddress": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"conversion": 1,
"currency": "USD",
"paidAt": "2022-01-27T16:15:58.000-05:00",
"paymentCounter": 1,
"paymentIdentifier": {
"cardIdentifier": "***********3456"
},
"paymentMethod": "CREDIT_CARD",
"paymentProvider": "stripe",
"paymentStatus": "PAID",
"paymentToken": {
"token": "pi_34tr6787rt"
},
"paymentType": "VISA",
"settlement": {
"settledAt": "2022-01-27T21:15:58Z",
"settlementAmount": 10.3,
"settlementStatusCode": "SETTLED"
}
}
],
"returns": [
{
"fees": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"invoicedAmount": 11.29,
"paymentCounterRefundDetails": [
{
"amount": 34.56,
"paymentCounter": 1
}
],
"refunds": [
{
"amount": 34.56,
"name": "RETURN_FEE",
"reason": "Return fee",
"type": "FEE"
}
],
"returnCounter": 1,
"totalRefundAmount": 11.29
}
],
"taxDetails": [
{
"amount": 34.56,
"type": "tax"
}
]
}
],
"postedAt": "2022-08-01T20:03:28.483971941Z",
"retail": {
"cashierId": "CE-321",
"locationNumber": 334
},
"shipInfo": {
"discounts": [
{
"amount": 2.99,
"promotionCode": "SHIPFREE",
"promotionId": "SHIPFREE",
"promotionName": "Free Shipping",
"quantity": 1,
"unit": "AMOUNT_OFF",
"value": 10
}
],
"estimatedDeliveryDate": "2022-05-12T09:30:31.198Z",
"estimatedShipDate": "2022-05-12T09:30:31.198Z",
"isInvoiced": true,
"locationNumber": "123",
"pickups": [
{
"email": "test@example.com",
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"pickupType": "PRIMARY"
}
],
"shipMethod": "Parcel post delivery",
"shipToAddress": {
"addressLine1": "123 Main St.",
"addressLine2": "Suite 100",
"addressLine3": "Seventh floor",
"addressLine4": "Attention: Pat E. Kake",
"city": "Seattle",
"countryCode": "US",
"email": "test@example.com",
"latitude": 47.6205,
"longitude": -122.3493,
"name": {
"firstName": "Alex",
"lastName": "Doe",
"middleName": "E"
},
"phone": {
"number": "123-456-7890",
"type": "MOBILE"
},
"postalCode": "98121",
"region": "WA",
"type": "Home"
},
"shipToDiscount": 12.6,
"shipToId": "b03b72dc-78d8-4ea4-90fc-2fe6a1fe6569",
"shipToPrice": 20,
"shipToTaxTotal": 12.6,
"shipToType": "SHIP_TO_ADDRESS",
"shipToUnitPrice": 20,
"shipmentInstructions": "Handle with care",
"taxCode": "FR01",
"taxDetails": [
{
"amount": 34.56,
"attributes": {},
"currency": "USD",
"name": "STATE",
"rate": 10,
"rateType": "PERCENTAGE",
"taxCode": "FR01"
}
]
},
"shipmentId": "62ff5c0bec0aed3c86202c32",
"shipmentNumber": "217088603",
"shippedAt": "2022-08-01T20:03:28.483Z",
"statusCode": "CREATED",
"totalTaxAmount": 245.7,
"updatedAt": "2022-08-01T20:03:28.483971941Z",
"version": 2
}
],
"pagination": {
"count": 1000,
"limit": 10,
"offset": 1
}
}