Unknown SKU Search

GET{{api_url}}/shop/products/unknown_sku/search

Lists the Unknown SKUs InfiPlex has recorded. An unknown SKU is a SKU that arrived in an order, a price feed, or an inventory feed from a connected channel and did not match any product on the account. Each row records where it came from, whether the unknown-SKU alert email was sent and to whom, and whether InfiPlex went on to create a product for it automatically.

Related settings, under Settings > Base Settings:

Setting	Effect
`unknown_skus_found_email_send_enabled`	Send an email when unknown SKUs are found during order, price, or inventory processing.
`unknown_skus_found_email_to`	Where that email goes. Recorded on each row as `emailed_to`.
`unknown_skus_found_email_subject`	Subject line of that email.
`oms_order_create_unknown_sku_enabled`	When an order contains an unknown SKU, automatically create a product for it from the order's title and price.
`oms_order_create_unknown_sku_warehouse`	The warehouse the auto-created product is associated to.
`oms_order_create_unknown_sku_default_inventory`	The inventory quantity the auto-created product starts with.

Parameters

All parameters are optional.

Parameter	Type	Description
`search_term`	string	Partial match against the SKU or the email address it was reported to.
`is_emailed`	integer	`1` only SKUs the alert email was sent for, `0` only SKUs it was not sent for, `-1` either.
`just_count`	integer	Set to `1` to return only a count of matching unknown SKUs instead of the rows themselves.
`limit`	integer	Maximum number of rows to return.
`limit_start`	integer	Number of leading results to skip, for paging. With `limit` 100 and `limit_start` 100 you get rows 101 through 200.

Examples

All unknown SKUs:

{{api_url}}/shop/products/unknown_sku/search

One SKU:

{{api_url}}/shop/products/unknown_sku/search?search_term=abc123

Unknown SKUs nobody was emailed about:

{{api_url}}/shop/products/unknown_sku/search?is_emailed=0

How many unknown SKUs are on record:

{{api_url}}/shop/products/unknown_sku/search?just_count=1

Response

A JSON array, one object per unknown SKU:

[
    {
        "shop_unknown_sku_id": "2241",
        "shop_unknown_sku_siteareaid": "16",
        "sku": "abc123",
        "date_inserted": "2026-09-29 11:22:33",
        "is_emailed": "1",
        "date_emailed": "2026-09-29 11:22:33",
        "emailed_to": "user@example.com",
        "unknown_sku_source": "Amazon.com",
        "created_product_id": "0",
        "created_product_date": null,
        "created_product": "0",
        "sku_title": "Some SKU",
        "sku_price": null
    }
]

Field	Type	Description
`shop_unknown_sku_id`	string	Id of this record.
`shop_unknown_sku_siteareaid`	string	The InfiPlex site area the record belongs to.
`sku`	string	The SKU as it arrived from the channel.
`date_inserted`	string	When the SKU was first recorded, in the account time zone.
`is_emailed`	string	`1` if the unknown-SKU alert email was sent for this SKU, `0` if not.
`date_emailed`	string or null	When the alert email was sent. `null` when it was not.
`emailed_to`	string or null	The address the alert went to, from `unknown_skus_found_email_to`.
`unknown_sku_source`	string	The channel the SKU arrived from, as stored on orders in `order_source`, for example `Amazon.com`.
`created_product`	string	`1` if InfiPlex auto-created a product for this SKU under `oms_order_create_unknown_sku_enabled`, `0` if not.
`created_product_id`	string	The `shop_productid` of the auto-created product. `0` when none was created.
`created_product_date`	string or null	When the product was created. `null` when none was created.
`sku_title`	string or null	The item title that came with the SKU, used as the product title when one is auto-created.
`sku_price`	string or null	The item price that came with the SKU, if any.

An unknown SKU with created_product 0 still has no product on the account. Once a matching product exists, by auto-create, Products Create, or the OMS, the next order for that SKU imports normally; the record here is history and is not removed.

Authorization

Bearer token, sent in the Authorization header. Inherited from the collection.

Query Parameters

Key	Value	Description
`just_count` optional		Set to 1 to return only a count of matching unknown skus instead of the unknown skus themselves.
`limit` optional		Maximum number of unknown skus to return
`limit_start` optional		Number of leading results to skip, for paging. With limit 100 and limit_start 100 you get unknown skus 101 through 200
`search_term` optional	`sku123`	Partial match against the SKU, or the email address the alert was sent to
`is_emailed` optional	`1`	1 = has been emailed, 0 = has not been emailed, -1 = either

Example Request

curl --location --request GET '{{api_url}}/shop/products/unknown_sku/search' \
--header 'Authorization: Bearer {{auth_token}}'

Example Responses