SKU Data Search
{{api_url}}/shop/products/sku_data/search?sku_search_type=all&sku&data_name_search_type=multiple&data_name=costco_sku,thehomedepot_sku&data_name_value&date_modified_afterSearches SKU Data across SKUs and data names and returns the result pivoted: one row per SKU, with one column per data name requested. This is the API form of the Download SKU Data tool in the OMS and takes the same choices: which SKUs (all, one, or a list) and which data names (all, one, or a list), plus a value filter when a single data name is chosen. Use SKU Data Get instead to read every entry on one SKU as a flat list.
SKU Data is the per-SKU key/value store that connections read when they interact with a SKU, for example thehomedepot_sku for Home Depot or costco_sku for Costco, plus any custom names the account has stored. The full list of reserved names is on SKU Data Get.
Two questions this answers that nothing else does:
- "What is the Home Depot SKU for each of these ten SKUs":
sku_search_type=multiple, the ten SKUs insku,data_name_search_type=single,data_name=thehomedepot_sku. - "Home Depot sent 1004567890, which of my SKUs is that":
sku_search_type=all,data_name_search_type=single,data_name=thehomedepot_sku,data_name_value=1004567890.
Parameters
| Parameter | Type | Description |
|---|---|---|
sku_search_type | string | all, single, or multiple. Which SKUs to include. |
sku | string | With single, one SKU. With multiple, a comma separated list. Leave blank with all. |
data_name_search_type | string | all, single, or multiple. Which data names to return as columns. |
data_name | string | With single, one data name. With multiple, a comma separated list. Leave blank with all. |
data_name_value | string | Only used with data_name_search_type=single. Returns only SKUs whose value for that one data name matches this value. |
date_modified_after | string | Only entries saved after this datetime. Format: 2026-10-01 12:00:00 AM |
Examples
Costco and Home Depot SKUs for every SKU on the account:
{{api_url}}/shop/products/sku_data/search?sku_search_type=all&data_name_search_type=multiple&data_name=costco_sku,thehomedepot_sku
Home Depot SKU for three SKUs:
{{api_url}}/shop/products/sku_data/search?sku_search_type=multiple&sku=abc,AC045USBCPD,PORT10000&data_name_search_type=single&data_name=thehomedepot_sku
Which SKU has Home Depot SKU 1004567890:
{{api_url}}/shop/products/sku_data/search?sku_search_type=all&data_name_search_type=single&data_name=thehomedepot_sku&data_name_value=1004567890
Everything stored on one SKU, pivoted:
{{api_url}}/shop/products/sku_data/search?sku_search_type=single&sku=abc&data_name_search_type=all
Anything changed since this morning:
{{api_url}}/shop/products/sku_data/search?sku_search_type=all&data_name_search_type=all&date_modified_after=2026-10-07 12:00:00 AM
Response
A JSON array, one object per SKU. Every object carries sku plus one key per data name returned; a name the SKU has no value for comes back as an empty string, so every row has the same keys:
[
{
"sku": "abc",
"costco_sku": "",
"thehomedepot_sku": "1004567890"
},
{
"sku": "AC045USBCPD",
"costco_sku": "",
"thehomedepot_sku": ""
},
{
"sku": "PORT10000",
"costco_sku": "8834120",
"thehomedepot_sku": ""
}
]
| Field | Type | Description |
|---|---|---|
sku | string | The SKU. |
<data_name> | string | One key per data name returned, holding the stored value as a string. Empty string when the SKU has no value for that name. A value that holds JSON is returned as that JSON string. |
With sku_search_type=all every SKU on the account is a row, including SKUs with no SKU Data at all, so expect one row per SKU rather than one row per stored entry.
Authorization
Bearer token, sent in the Authorization header. Inherited from the collection.
Query Parameters
| Key | Value | Description |
|---|---|---|
sku_search_type | all | all, single, or multiple. Which SKUs to include. |
sku | With sku_search_type single, one SKU. With multiple, a comma separated list. Leave blank with all. | |
data_name_search_type | multiple | all, single, or multiple. Which data names to return as columns |
data_name | costco_sku,thehomedepot_sku | With data_name_search_type single, one data name. With multiple, a comma separated list, for example costco_sku,thehomedepot_sku. Leave blank with all |
data_name_value | Only used with data_name_search_type single. Returns only SKUs whose value for that one data name matches this value. Use it to find which SKU a channel's SKU belongs to. | |
date_modified_after | Only entries saved after this datetime. Format: 2026-10-01 12:00:00 AM |
Example Request
curl --location --request GET '{{api_url}}/shop/products/sku_data/search?sku_search_type=all&sku&data_name_search_type=multiple&data_name=costco_sku,thehomedepot_sku&data_name_value&date_modified_after' \
--header 'Authorization: Bearer {{auth_token}}'Example Responses
SKU Data Search
Request
curl --location --request GET '{{api_url}}/shop/products/sku_data/search?data_name_search_type=multiple&date_name=costco_sku,thehomedepot_sku&sku_search_type=all' \
--header 'Authorization: Bearer YOUR_API_KEY'Response 200 OK
[
{
"sku": "abc",
"costco_sku": "",
"thehomedepot_sku": "hhhooome depot 2"
},
{
"sku": "AC045USBCPD",
"costco_sku": "",
"thehomedepot_sku": ""
},
{
"sku": "AC065USBCPD",
"costco_sku": "",
"thehomedepot_sku": ""
},
{
"sku": "BRTTZE2412PK",
"costco_sku": "",
"thehomedepot_sku": ""
},
{
"sku": "GOJ910612CT",
"costco_sku": "",
"thehomedepot_sku": ""
},
{
"sku": "PORT10000",
"costco_sku": "",
"thehomedepot_sku": ""
}
]