noon Listings
Create and update noon listings from the noon Publish Queue, write bilingual copy with AI, and manage content status, pricing, stock and barcodes.
The noon Listings panel does for noon what Catalogs does for Amazon: a Publish Queue that creates and updates listings, AI drafts in English and Arabic, and the sheets for content QC, pricing, stock and barcodes. A noon store is named <account>-<CC>, for example myNoon-AE.
Main steps — publish listings
Get the template
On noon Publish Queue, list the Category Codes in F7:F and click Get Template: it builds the columns (G onward) with guides for every category. A product whose Parent Group Key is a noon id (Z…) and whose Category Code is blank gets its category from noon.
Fill the products
The rows sharing a Parent Group Key are one product; its Parent row gives the details and every row gives its Partner SKU and size variant. Fetch by SKU fills the Parent row of a product that is already on noon (only when its Product Title is empty).
Create / Update Listing
Create / Update Listing sends every product to noon, one call per product, built from the sheet alone.
Next batch
Clear Row 7+ empties your product rows and keeps the template. Nothing is sent to noon.
AI drafts and the other sheets
- noon Listing Drafts: Fetch by SKU, then Image → Listing (AI) or Optimize Listing (AI) for bilingual copy (billed from your Credits balance, refunded if it fails), then Send to Publish Queue.
- noon Live Listings: Fetch by SKU loads what is live.
- noon Content QC: Get QC Status shows attribute, image and live status per parent SKU and language.
- noon Pricing and noon Stock: read with Get Pricing, Get Transfer Price, Get Offers, Get Stock; change with Update Pricing, Update Transfer Price, Update Stock; Map Barcodes and Create Import connect partner SKUs to barcodes.
- noon SKU Delete: Delete SKUs deletes the ticked SKUs on noon — a parent delete removes every variant.
- noon Reference: List Categories, List Warehouses, Lookup Returns.
Every button
| Button | 中文 | What it does | Effect |
|---|---|---|---|
| Get Template | 获取模板 | Builds the columns (G+) with guides for every category in Category Code (F7:F); a product whose Parent Group Key is a noon id (Z…) and whose Category Code is blank gets its category from noon. Starts fresh: columns G onward are rebuilt empty; rows 1-3 and columns A-F are kept. | WRITES SHEET |
| Fetch by SKU | 按 SKU 获取 | Fills the Parent row of each product whose Parent Group Key is a noon id (Z…) from noon — one call per product. Only a Parent row whose Product Title is empty runs — clear the title to fetch again; columns G onward are rewritten from noon. A column the template lacks is added at the right; a product noon cannot return keeps its row and gets ⚠ in Brand. Sizes are yours to add: a Child row per size. | WRITES SHEET |
| Create / Update Listing | 创建/更新商品 | LIVE — sends every product to noon, one call per product, built from the sheet alone: the rows sharing a Parent Group Key are one product, its Parent row gives the details and every row gives its Partner SKU and Size Variation. noon keeps any value you leave blank, and each image column is one image slot. noon answers at once: the result is final in the noon Submission Log, and a saved product gets its noon id (Z…) in Parent Group Key and is added to noon Content QC — run Get QC Status there for noon's content check (missing required attributes, QC). noon has no preview, so there is no Validate. | LIVE ON NOONWRITES SHEET |
| Clear Row 7+ | 清空第 7 行及以下 | Empties your product rows (row 7 down) from column B and keeps the template — ready for the next batch. Nothing is sent to noon. | WRITES SHEET |
| Fetch by SKU | 按 SKU 获取 | Rows with Store+SKU Parent set, Fetched At empty. Clear Fetched At to redo. | WRITES SHEET |
| Fetch by SKU | 按 SKU 获取 | Rows with Store+SKU Parent set, Draft Listing empty. | WRITES SHEET |
| Image → Listing (AI) | 图片 → Listing（AI） | Writes bilingual AI copy from the row's image + Instructions. | USES CREDITSWRITES SHEET |
| Optimize Listing (AI) | 优化 Listing（AI） | AI rewrites the row's bilingual copy — facts kept. AI | USES CREDITSWRITES SHEET |
| Send to Publish Queue | 发送至发布队列 | Copies the row into the noon Publish Queue (existing columns only) and marks it SENT. | WRITES SHEET |
| Get QC Status | 获取质检状态 | Fetch content status (attribute/image/live) per sku_parent × language. List sku_parents in column A of the noon Content QC tab first. | WRITES SHEET |
| Delete SKUs | 删除 SKU ⚠ | DESTRUCTIVE: delete ticked child/parent SKUs on noon. Parent deletes cascade to every variant. | LIVE ON NOONWRITES SHEET |
| Get Pricing | 获取定价 | Read price / msrp / is_active per partner_sku. | WRITES SHEET |
| Update Pricing | 更新定价 | Push price / msrp / is_active to noon. | LIVE ON NOONWRITES SHEET |
| Get Transfer Price | 获取调拨价 | Read USD cross-border transfer prices per partner_sku. | WRITES SHEET |
| Update Transfer Price | 更新调拨价 | Push USD transfer_price / msrp / is_active to noon. | LIVE ON NOONWRITES SHEET |
| Get Offers | 获取报价 | Look up noon sku / title / brand / per-country offers for each partner_sku. | WRITES SHEET |
| Get Stock | 获取库存 | Read current available qty for each (warehouse_code, partner_sku) row. | WRITES SHEET |
| Update Stock | 更新库存 | Push the qty column to noon for each row. | LIVE ON NOONWRITES SHEET |
| Map Barcodes | 映射条码 | Connect each partner_sku to its barcode (UPC/EAN/ISBN) on noon. | LIVE ON NOONWRITES SHEET |
| Create Import | 创建导入 | Submit the barcode rows as an async import; writes an import reference. | LIVE ON NOONWRITES SHEET |
| Refresh Status | 刷新状态 | Poll the import status/report for the saved reference. | WRITES SHEET |
| List Warehouses | 列出仓库 | Load the partner warehouses for the Store in A4. | WRITES SHEET |
| List Categories | 列出类目 | List noon catalog categories (codes used by noon Publish Queue). | WRITES SHEET |
| Lookup Returns | 查询退货 | List noon return items + barcode references matching a barcode. | WRITES SHEET |
Prefer to ask an agent?
noon_content_UpsertProduct, noon_pricing_BatchUpsertPricing and noon_stock_UpdateStock do the same over MCP. Guide: Connect noon to SellerSheet.