Use this API to retrieve product SKU details from your organisation. You can fetch SKUs in bulk, search SKUs by SKU code, or retrieve specific SKUs using SKU IDs or codes. The API supports pagination, sorting, and filtering, and can optionally return related data such as product attributes, brand, and category.

You can use this API to:

Fetch all product SKUs in the organisation.
Search SKUs by SKU code prefix.
Retrieve specific SKUs using SKU IDs or SKU codes.
Filter SKUs by organisation unit (OU) when OU support is enabled.
Retrieve additional related data (attributes, brand, category) for a single SKU.

The response includes SKU details, pricing and return information, optional related entities, attribution metadata, and pagination details.

Example request

curl --location 'https://{Host}/v2/product/skus' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic bmVlcmFqa3Jpc2huYTpkY2VhNmU1ODlhM2U0M2JhODdkMTFkMTM2ODI2NmMxOQ==' \
--header 'Cookie: _cfuvid=adIdLElC8oafEHX277Vu_kA.mTpq2xD18k-1762750332464-0.0.1.1-604800000; _cfuvid=r8CYFCntpo7UzJkjqfesBBFBReI85rG87hY54Q9wOVU-1768196006476-0.0.1.1-604800000'

curl --location 'https://nightly.intouch.capillarytech.com/v2/product/skus' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic bmVlcmFqa3Jpc2huYTpkY2VhNmM2U0M2JhODdkMTFkMTM2ODI2NmMxOQ==' \
--header 'Cookie: _cfuvid=adIdLElC8EHX277Vu_kA.mTpq2xD18k-1762750332464-0.0.1.1-604800000; _cfuvid=r8CYFCntpo7UzJkjqfesBBFBReI85rG87hY54Q9wOVU-1768196006476-0.0.1.1-604800000'

curl --location 'https://nightly.intouch.capillarytech.com/v2/product/skus?include=attributes%20%2C%20brand%2C%20category&entityIds=32510888' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic bmVlcmFqa3Jpc2huYTpkY2VhNmU1ODlhM2U0M2JhODdkMTFkMTM2ODI2NmMxOQ=='

Prerequisites

Basic/OAuth authentication

Resource information


Pagination support	Yes
Batch support	Yes

Query parameters

Field	Type	Required	Description
q	string	Optional	Search product SKUs by their SKU code (also called item code). This returns product SKUs whose codes start with the specified query string. This field is case-insensitive and supports UTF-8 characters. The maximum number of characters supported is 30. This parameter overides `entityCodes` and `entityIds`. If provided along with those filters, a warning is returned, and the other filters are ignored.
entityCodes	string	Optional	A single or comma-separated list of product SKU codes. Use the value of the `code` parameter from the response of the Add Product SKU API.Used when `q` parameter is not provided. Format: Case-insensitive; supports UTF-8 characters. Limits: Maximum 30 codes; 50 characters per code. This parameter is ignored if query parameter `q` is provided. Example: code1, 10001
entityIds	string	Optional	A single or comma-separated list of product SKU `id`. Use the value of the `id` parameter from the response of the Add Product SKU API. Limits: Maximum 30 ID's. This parameter is ignored if the query parameter `q` or `entityCodes` are provided. Example: 1999, 2000
include	string	Optional	Comma-separated list of optional related data to include. Supported values: `category`, `brand`, `attributes`.Only applied when retrieving a single entity (specific SKU `code`or`id`).
limit	integer	Optional	Maximum number of product categories to retrieve. The default value is 10, and the maximum allowed value is 100.
offset	integer	Optional	Number of product categories to skip from the beginning of the response.
sortBy	string	Optional	Allows you to sort the response based on specific fields. Supported values are `id` and `code`. Defaults to `id`.
sortOrder	string	Optional	Sort direction. Supported values: `ASC`, `DESC`. Default: `DESC`
ouCode	string	Optional	Filters product SKUs by the Organization's concept code. This parameter is only applicable when OU support is enabled.
fetchType	string	Optional	Scope of product categories to fetch. Supported Values: ALL (master org and OU), ORG (master org only), SCOPE (OU only).

Example response

{
    "data": [
        {
            "id": 27353463,
            "orgId": 50583,
            "ouId": -1,
            "code": "Red1",
            "ean": "Red1",
            "price": 7000.0,
            "description": "adding sample product",
            "longDescription": "Sample description",
            "imageUrl": "https://nightly.capillary.in/productManagement/Colors/img.jpg",
            "attribution": {
                "modifiedDate": "2021-03-16T11:53:22+05:30"
            }
        },
        {
            "id": 27353464,
            "orgId": 50583,
            "ouId": -1,
            "code": "White1",
            "ean": "White1",
            "price": 1000.0,
            "description": "soap",
            "imageUrl": "",
            "attribution": {
                "modifiedDate": "2019-11-29T13:29:09+05:30"
            }
        },
        {
            "id": 27407685,
            "orgId": 50583,
            "ouId": -1,
            "code": "uforall",
            "ean": "uforall",
            "price": 450.0,
            "description": "for all",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-03-04T12:28:10+05:30"
            }
        },
        {
            "id": 27407686,
            "orgId": 50583,
            "ouId": -1,
            "code": "3872295",
            "ean": "3872295",
            "price": 7000.0,
            "description": "adding sample product",
            "longDescription": "Sample description",
            "imageUrl": "https://nightly.capillary.in/productManagement/Colors/img.jpg",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2021-03-16T11:54:18+05:30"
            }
        },
        {
            "id": 27451903,
            "orgId": 50583,
            "ouId": -1,
            "code": "",
            "ean": "",
            "price": 20000.0,
            "description": "Android Tablet",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-05-28T17:50:31+05:30"
            }
        },
        {
            "id": 27469435,
            "orgId": 50583,
            "ouId": -1,
            "code": "132453",
            "ean": "132453",
            "price": 500.0,
            "description": "for all",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-07-07T13:04:57+05:30"
            }
        },
        {
            "id": 27478784,
            "orgId": 50583,
            "ouId": -1,
            "code": "PHONE",
            "ean": "PHONE",
            "price": 20000.0,
            "description": "Basic Android Phone",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-07-15T11:17:58+05:30"
            }
        },
        {
            "id": 27478785,
            "orgId": 50583,
            "ouId": -1,
            "code": "TAB",
            "ean": "TAB",
            "price": 20000.0,
            "description": "Android Tablet",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-07-15T11:17:58+05:30"
            }
        },
        {
            "id": 27480360,
            "orgId": 50583,
            "ouId": -1,
            "code": "item-001",
            "ean": "item-001",
            "price": 500.0,
            "description": "soap",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-07-16T10:47:38+05:30"
            }
        },
        {
            "id": 27501047,
            "orgId": 50583,
            "ouId": -1,
            "code": "sku-18-001",
            "ean": "sku-18-001",
            "price": 500.0,
            "description": "soap",
            "imageUrl": "",
            "returnable": true,
            "returnableDays": -1,
            "attribution": {
                "modifiedDate": "2020-08-11T21:29:13+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 10,
        "offset": 0,
        "total": 423970
    }
}

{
    "data": [
        {
            "id": 32510888,
            "orgId": 50583,
            "ouId": -1,
            "code": "1212jo1212-q",
            "ean": "test-jo-nigh-qt",
            "price": 100.0,
            "description": "test sku",
            "longDescription": "detailed description",
            "imageUrl": "http://newimage.com/abc.png",
            "returnable": true,
            "returnableDays": 2,
            "attributes": [
                {
                    "id": 91454,
                    "code": "producttype",
                    "name": "type",
                    "value": {
                        "id": 13544478,
                        "code": "producttype",
                        "name": "Plastic2"
                    }
                }
            ],
            "attribution": {
                "modifiedDate": "2026-01-12T14:08:46+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 10,
        "offset": 0,
        "total": 1
    }
}

{
    "data": [
        {
            "id": 32510888,
            "orgId": 50583,
            "ouId": -1,
            "code": "1212jo1212-q",
            "ean": "test-jo-nigh-qt",
            "price": 100.0,
            "description": "test sku",
            "longDescription": "detailed description",
            "imageUrl": "http://newimage.com/abc.png",
            "returnable": true,
            "returnableDays": 2,
            "brand": {
                "id": 1242092,
                "code": "Airpods",
                "name": "Airpods"
            },
            "attribution": {
                "modifiedDate": "2026-01-12T14:08:46+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 10,
        "offset": 0,
        "total": 1
    }
}

{
    "data": [
        {
            "id": 32510888,
            "orgId": 50583,
            "ouId": -1,
            "code": "1212jo1212-q",
            "ean": "test-jo-nigh-qt",
            "price": 100.0,
            "description": "test sku",
            "longDescription": "detailed description",
            "imageUrl": "http://newimage.com/abc.png",
            "returnable": true,
            "returnableDays": 2,
            "category": {
                "id": 11329340,
                "code": "Apparel",
                "name": "Apparel"
            },
            "attribution": {
                "modifiedDate": "2026-01-12T14:08:46+05:30"
            }
        }
    ],
    "pagination": {
        "limit": 10,
        "offset": 0,
        "total": 1
    }
}

Response parameters

Parameter	Type	Description
id	long	Indicates the unique entity id for the SKU.
orgId	long	Specifies the organization ID to which the SKU belongs.
ouId	long	Indicates the organizational unit ID (-1 if the SKU belongs to the master organization).
code	string	Specifies the unique code for the Stock Keeping Unit (SKU).
ean	string	Specifies the European Article Number (EAN) of the product.
price	decimal	Indicates the monetary cost of the product.
description	string	Specifies a short summary or title of the product.
longDescription	string	Specifies the detailed information about the product.
imageUrl	string	Specifies the source URL of the product image.
returnable	boolean	Indicates whether the product is eligible for return.
returnableDays	integer	Specifies the number of days within which the product can be returned.
attribution	object	An object containing metadata related to the attribution.
. modifiedDate	string	Indicates the date and time when the product was last modified (ISO 8601).
attributes	array	Specifies the list of custom product attributes associated with the SKU.
. id	long	Indicates the unique identifier of the attribute definition.
. code	string	Specifies the system code identifying the attribute type (e.g., "color", "size").
. value	object	Specifies the object containing the assigned value details.
. . id	long	Indicates the unique identifier for the specific attribute value.
. . code	string	Specifies the code representing the attribute value (e.g., "na").
. . name	string	Specifies the human-readable display name of the attribute value (e.g., "Material").

Error & warning codes

Code	Type	Description
10007	Error	entityCodes cannot have more than 30 comma-separated values.
10008	Error	entityIds cannot have more than 30 comma-separated values.
10004	Error	Pagination limit cannot exceed 100.
10005	Error	Pagination limit cannot be zero or negative.
10006	Error	Pagination offset cannot be negative.
10002	Error	OU level product filtering is disabled for your organization, but an `ouCode` was provided.
10001	Error	The provided `ouCode` is invalid or does not exist.
10009	Warning	Searching by `q` parameter; `entityCodes` and `entityIds` were ignored.
10010	Warning	Searching by `entityCodes`; `entityIds` was ignored.
10014	Warning	Invalid `sortBy` parameter. Defaulting to sort by `id`.
10018	Warning	The `include` parameter is only supported for single SKU requests and will be ignored.
10019	Warning	The following include values are invalid and will be ignored: 0
10011	Warning	One or more blank values provided in `entityCodes` or `entityIds` were ignored.
10012	Warning	One or more non-numeric values provided in `entityIds` were ignored.
10013	Warning	All provided `entityIds` were invalid and ignored. The query will now fetch all entities.