The Scenario
You joined a luxury goods resale operation three weeks ago. The previous analyst left a ProductSearch workbook with 20 Rolex and Patek Philippe reference numbers in column A of the ProductSearch worksheet and a note that says "get the Retailed IDs and platform names for these." No further context.
Columns B, C, and D are empty.
The bad version:
- Try to figure out what "Retailed IDs" means, look up the API docs, realize you need a search endpoint call with the reference as a query
- Make the first call manually, get back a JSON blob, find the product_id field, paste it into column B, not know which of the three platform names to use
- Get through four rows before booking time with a developer
The institutional knowledge walked out the door. You're not there to reverse-engineer undocumented workflows.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the references in your worksheet and, through its Retailed integration, searches the product database and returns the structured metadata.
Read column A of my Excel ProductSearch tab (brand and model names), search the Retailed database for each via the search products tool, and paste the matched product's ID, brand, and SKU into columns B, C, and D
What You Get
- Column B: Retailed product ID for the matched item
- Column C: brand name as returned by the database
- Column D: matched SKU
- Rows where no strong match is found get a note in column E — you know immediately which references need manual review
What If the Data Is Not Quite Ready
References are mixed with descriptive text, not clean query strings
For each value in column A of the ProductSearch tab, extract the reference number, search Retailed for a match, and write product ID, brand, and SKU into columns B, C, and D
You need platform names alongside the product ID
For each value in column A of the ProductSearch tab, search Retailed and write the top result's product ID into column B, brand into column C, and matched platform names as a comma-separated list into column D
Some references appear twice with slightly different formatting
Deduplicate column A of the ProductSearch tab by normalizing spacing and case, search Retailed for each unique reference, write product ID, brand, and SKU into columns B, C, and D, and note any merged duplicates in column E
Full catalog enrichment: search, flag no-platform matches before they go downstream
Search Retailed for each reference in column A of the ProductSearch tab, write product ID into column B, brand into column C, SKU into column D, then flag in column E any row where no platform names were returned — those need manual verification before entering the catalog
Clean reference list, enriched metadata, clear flags on what needs review.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with a column of brand references or model codes, then ask SheetXAI to search the Retailed database and populate IDs and metadata inline. Related: Enrich inventory with full StockX variant data and the Retailed integration hub.