What is an unknown SKU?
It is a SKU that arrives from a sales channel on an order or feed and matches no product in your catalog. It usually means a listing was created with a SKU your system has not been told about.
Custom Report · Operations
Unknown SKU Report: every SKU a channel sent that your catalog does not recognize
An unknown SKU report lists the SKUs that arrived on an order, price feed, or inventory feed from a sales channel and matched no product in your catalog. InfiPlex records each one with the channel it came from, the title and price sent with it, and whether a product was created for it, so an AI agent connected to the MCP server can show exactly which listings need a product or a mapping.
- By channelWhich marketplace sent each SKU
- With title and priceAs the channel described the item
- Status includedAlert sent, product created or not
The prompt
Which marketplace SKUs do not match a product in my catalog?
Ask for the list. The agent returns each unknown SKU with its source and whether it still needs a product.
List unknown SKUs that still have no product, grouped by channel, with the title and price each channel sent.
Used InfiPlex OMS integration
14 unknown SKUs still have no product. By channel: Walmart 6, Amazon.com 4, Shopify 3, eBay 1. The most recent:
| SKU | Channel | Title sent | Price | Alert sent | Product |
|---|---|---|---|---|---|
| KT-118-2PK | Walmart | Kitchen Timer 2 Pack | $32.00 | Yes | None |
| HX2040 | Amazon.com | Hex Driver Set 40 Piece | $49.00 | Yes | None |
| BL-7702-BLK | Shopify | Blender 7702 Black | $129.00 | Yes | None |
| PM-55B | eBay | Phone Mount 55 Bulk | $35.00 | No | None |
HX2040 looks like a listing for HX-2040 without the dash, and KT-118-2PK looks like a two pack of KT-118. Both can be resolved with a mapping instead of a new product.
Each row is a listing that can take an order your warehouse cannot pick cleanly. Clearing the list keeps orders flowing. InfiPlex can also create new SKUs from marketplace orders automatically.
What is in the report
What the InfiPlex unknown SKU report shows
The record keeps what the channel sent, which is usually enough to identify the product.
| Column | What it tells you |
|---|---|
| SKU | The SKU exactly as the channel sent it |
| Channel | The order source or feed it arrived from |
| Title sent | The item title the channel included |
| Price | The price the channel included |
| Alert sent | Whether the unknown SKU alert email went out |
| Product | Whether InfiPlex created a product for it |
Make it yours
Follow-up prompts that reshape the unknown SKU report
The first answer is a starting point. Each follow-up below is one more sentence in the same conversation, and the AI agent rebuilds the report from InfiPlex data each time.
- “Suggest the existing SKU each unknown SKU most likely matches.”Compares each one to your catalog by SKU pattern and title.
- “Which unknown SKUs appeared on orders this week?”Narrows to items that have already taken an order.
- “Create products for the four with no likely match.”A write the agent previews before it runs, on a key that allows it.
- “Which channel has sent the most unknown SKUs this quarter?”Counts by source to find the listing process that needs attention.
Where the numbers come from
The InfiPlex data behind the unknown SKU report
One read for the list, plus catalog reads when you ask for matches.
unknown_sku_searchUnknown SKUs with channel, dates, title, price, alert status, and product statuspim_sku_getThe product record for a SKU, used to compare a likely matchsku_map_searchExisting SKU maps that may already cover the itemshop_setting_searchThe settings that control unknown SKU alerts and automatic product creation
Every tool and its inputs are listed in the MCP tools reference. The same data is available as JSON through the InfiPlex REST API for teams that prefer a script.
Run it on a schedule
Schedule the unknown SKU report daily or weekly
A daily run keeps the list near zero and catches a new listing the day it goes live. A scheduled AI agent or a short script runs the same prompt from cron and delivers the result by email, Slack, or shared folder. The scheduled custom reports guide covers both routes, and the daily inventory by warehouse report agent is a worked example to copy.
Frequently asked
Unknown SKU Report questions, answered
What sellers ask before they build this report on InfiPlex.
Why do unknown SKUs matter?
An order for an unknown SKU has no product behind it for inventory and fulfillment until the SKU is known. Resolving them early keeps orders shipping on time.
How do I fix an unknown SKU?
Create the product, or map the channel SKU to an existing one. The SKU groups, bundles, and SKU maps guide covers which tool fits a variant, a multipack, or a partner SKU.
Can InfiPlex create the product automatically?
Yes. A setting lets InfiPlex create a product from the order data when an unknown SKU arrives, and the report shows which were created that way.
Does InfiPlex send an alert for unknown SKUs?
Yes. An unknown SKU alert email can be sent to an address you set, and the report shows whether it went out for each SKU. See alert set-up.
Resources
Related InfiPlex pages and guides
More custom reports
- All custom eCommerce reports
- Profit by Sales Channel Report
- SKU Profitability Report
- Multichannel Sales by Channel Report
- Top Selling SKUs Report
- Daily Sales Report
- Late Shipment Report
- Marketplace Fulfillment Error Report
- 3PL Inventory Reconciliation Report
- Inventory Sent to Marketplace Report
- Orders by Warehouse Report
- Shipping Method Report
- Inventory Change Audit Report
AI agents and the MCP server
- InfiPlex MCP server
- MCP server set-up guide
- MCP tools reference
- Scheduled custom reports with MCP and the API
- AI agent prompts for order management
- Is it secure? A plain-English overview
InfiPlex features behind this report
Clear unknown SKUs before they hold up an order
Connect an AI agent to InfiPlex, ask for the report in plain English, and put it on a schedule. No spreadsheet exports, no report builder to learn.
Want the unknown SKU report on your own data?
Tell us which channels, warehouses, and systems you run and we will build this report with you on a live InfiPlex instance. Contact us, email info@infiplex.com, or call 888‑770‑0857.
InfiPlex™ is a trademark of InfiPlex. Marketplace, retailer, carrier, and software names are trademarks of their respective owners. InfiPlex is an independent integration provider and is not endorsed by or affiliated with any of them. Report output on this page is sample data shown in the format the InfiPlex MCP server returns. ©2026 InfiPlex. All rights reserved.
