Sidebar buttons
All 263 buttons of the Google Sheets add-on, by tab and panel.
Sellers › sales (6)
| Button | 中文 | What it does |
|---|---|---|
| Sync Orders | 同步订单 | Syncs new and changed orders into the Orders sheet, continuing where the last run stopped, then keeps itself running about every 2 hours. Only the spreadsheet's owner syncs. |
| Re-sync | 重新同步 | Clears this tab and reads the ticked stores again from scratch, as far back as First sync reads. |
| Update Order | 更新订单 | Click the Amazon Order ID cell of an order first, then this refreshes that row from Amazon. |
| Clear Orders | 清空订单 | Clears ALL data rows from the Orders sheet (headers kept). Ctrl+Z to undo right after. |
| Order Details | 获取订单明细 | Fetches line items of the selected order from Amazon. |
| Create Invoices | 生成发票 | On the Invoices sheet: generates a PDF invoice in Drive for every row with Store + Order ID and no link yet (order must be Shipped; company info from Store Info sheet). |
Vendors › vendors (7)
| Button | 中文 | What it does |
|---|---|---|
| Sync Vendor Orders | 同步供应商订单 | Fetch vendor POs from Amazon using the row-4 filters; defaults to the last 7 days. |
| Load PO Items | 加载 PO 商品 | Loads the clicked PO row's line items into the Vendor PO Items sheet and auto-fills product images (thumbnails in column A, URL in the last column). |
| Clear Table | 清空表格 | Clear data rows; headers, filters and dropdowns stay. Ctrl+Z to undo. |
| Acknowledge PO | 确认接单（PO） | Submit PO acknowledgements to Amazon — every row needs Ack Code 1; Backordered needs a Ship Date, Rejected needs a Reason. |
| Clear Table | 清空表格 | Clear data rows; image formula, headers and dropdowns stay. Ctrl+Z to undo. |
| Refresh PO Status | 刷新 PO 状态 | Refresh item-level PO status using the row-4 filters (defaults to the last 7 days) and auto-fill product images for new rows. |
| Clear Table | 清空表格 | Clear data rows; image formula, headers and filters stay. Ctrl+Z to undo. |
Sellers › catalogs (26)
| Button | 中文 | What it does |
|---|---|---|
| Sync Catalog | 同步商品目录 | Pulls every SKU of the ONE store typed in A4 (e.g. myStore-US) from the SellerSheet warehouse into the Catalog tab, with thumbnails. Filter afterwards with the row-5 column filter. |
| Fetch by SKU | 按 SKU 获取 | Fetches your own listing (what you submitted) for rows with Store + SKU and an empty JSON cell; fills the ASIN too. Clear a row's JSON cell to re-fetch it. A row that fails shows the reason in its Image cell. |
| Fetch by ASIN | 按 ASIN 获取 | Fetches Amazon's catalog page (what shoppers see) for rows with Store + ASIN, NO SKU and an empty JSON cell — yours or a competitor's. Put the same product on a SKU row and an ASIN row to compare the copy. |
| Fetch Catalog Data | 获取目录数据 | Fills every competitor row with Store + ASIN (rows 5+) from the Amazon catalog: content, BSR, Buy Box, FBA/MFC offers, fee estimate, margin, and your own SKU if already listed. The winner row (4) is never overwritten. |
| Discover by Keyword | 按关键词发现 | Searches Amazon by keyword and appends up to 10 new competitor ASINs as fully filled rows. |
| Set as Winner | 设为最佳 | Copies the clicked competitor row into the winner row (row 4) as your listing starting point. |
| Copy Winner to Drafts | 将最佳复制到草稿 | Sends the winner row (row 4) — identity, image and combined listing copy — to Listing Drafts for AI optimization. |
| Send to Restriction Check | 发送至限制检查 | Adds the selected rows' Store + ASIN to the Restriction Check sheet to verify you can list them. |
| Fetch by ASIN | 按 ASIN 获取 | Fills draft rows from the reference ASIN's catalog data (rows with Store + ASIN and an empty Image). |
| Fetch by SKU | 按 SKU 获取 | Fills draft rows from YOUR OWN live listing by SKU — refurbish an existing listing (rows with Store + SKU and an empty Image). |
| Image → Listing (AI) | 图片 → Listing（AI） | Sends the row's Image photo(s) + Instructions + Draft Keywords (each queued keyword MUST appear in the copy) to AI, which writes a complete listing into the AI columns: Item Name, Item Highlight, 5 Bullet Points, Description, backend Generic Keywords (fills Amazon's 250-byte budget) and PPC keyword ideas, plus A+ / image ideas. Lengths follow Settings → AI Length Preferences. |
| Optimize Listing (AI) | 优化 Listing（AI） | Sends the row's Image + Instructions + Draft Listing + Draft Keywords to AI, which rewrites everything into the AI columns: Item Name, Item Highlight, Bullets, Description, backend Generic Keywords (fills Amazon's 250-byte budget) and PPC ideas, plus A+ / image ideas — facts are kept, only the copy improves. Lengths follow Settings → AI Length Preferences. |
| Optimize Title (AI) | 优化标题（AI） | Sends Instructions + the row's copy (the AI columns, or Draft Listing when they are empty) + Draft Keywords + Image; AI rewrites ONLY the AI Item Name (kept under 75 characters so Amazon shows the Highlight) and the AI Item Highlight — bullets, description and keywords stay untouched. |
| Translate Listing (AI) | 翻译 Listing（AI） | Target languages are set in the 'Listing Drafts · Translations' tab: add one row per language — same store NAME + SKU (the country code may differ: draft myStore-US matches translation row myStore-DE) + Locale (e.g. de_DE), Status left empty. One click sends the row's AI columns (fallback: Draft Listing) and translates ALL pending locales in a single AI call, marking each row OK. To redo one language, clear its Status. |
| Send to Publish Queue | 发送至发布队列 | Copies the clicked draft row's SKU, Product Type and AI copy into the first empty Publish Queue row (ASIN → Merchant Suggested ASIN) and marks the draft SENT. On the Translations tab it sends the translated copy; the row's Locale must match the Publish Queue Listing Locale (B3). Needs SKU + Product Type + Item Name, and the Store must match Publish Queue A3. Run Get Template for that product type FIRST — only columns already on the Publish Queue receive copy. Choose the Operation Type there. |
| Fetch ASIN Info | 获取 ASIN 信息 | One click fetches listing info (image, brand) plus buy box price, rank and offer counts for rows with Store + ASIN; rows whose Image is already filled are skipped — clear Image to refresh. |
| Get Restrictions | 获取限制 | Check selling restrictions for every row with Store + ASIN. |
| Get Template | 获取模板 | Builds attribute columns (F+) with guides from Amazon's schema, for the product types in D7:D. Rows 1-3 and columns A-E are kept — safe to re-run. |
| Fetch by ASIN | 按 ASIN 获取 | Rewrites each row from the Amazon catalog (what shoppers see) for the ASIN in the Merchant Suggested ASIN column: every attribute column is refilled and a column the catalog lacks is cleared, so no stale value survives. Only rows whose Item Name is empty run — clear the title to re-fetch. A failed ASIN keeps its values and gets ⚠ in Brand; new attributes append at the right. |
| Fetch by SKU | 按 SKU 获取 | Rewrites each row from YOUR submitted listing (SKU in column B): every attribute column is refilled and a column the listing lacks is cleared, so no stale value survives. Only rows whose Item Name (row 6) is empty run — a filled title means done; clear it to re-fetch. A row Amazon fails keeps its values and gets ⚠ in Brand. Also step 1 of PATCH-DELETE: fetch, keep only the cells to delete. |
| Fill from JSON | 从 JSON 填充 | Rewrites each row from the JSON pasted in Attributes JSON (col E, e.g. from Listing Snapshot): every attribute column is refilled from it and a column the JSON lacks is cleared (the summary counts them), so no stale value survives. Only rows whose Item Name is empty run — clear the title to re-fill; the blob and columns A-E stay. Invalid JSON or a failed parse leaves the row untouched and is listed. Fill productType (col D) first. |
| Validate (Preview) | 校验（预览） | Step 1 for every change: checks rows against Amazon WITHOUT publishing (max 20; DELETE has no preview and is skipped here). Issues land in Submission Log — fix, then publish with Create/Replace/Delete (≤20, instant) or Submit Feed (bulk). |
| Create/Replace/Del. | 创建/替换/删除 | Create / Replace / Delete — LIVE, runs each row by its operationType, instant per-SKU results (max 20): UPDATE creates or fully replaces the SKU; PARTIAL_UPDATE / PATCH-DELETE change or delete only the listed attributes; DELETE removes the SKU from Amazon — irreversible, no preview exists. |
| Submit Feed | 提交 Feed | LIVE — publishes ALL rows (any operationType) as one bulk feed, up to 25,000 rows; results appear in Submission Log. |
| Backup | 备份 | Snapshots this tab into your Listing Log spreadsheet (named by SKU + timestamp) and records the link. |
| Refresh Status | 刷新状态 | Asks Amazon about every Submit Feed row that is not finished yet and fills Feed Status, Result and Issues. |
Sellers › FBA (26)
| Button | 中文 | What it does |
|---|---|---|
| Refresh Data | 刷新数据 | Refresh the hidden data layer from the SellerSheet database — stores picked in the Stores filter (A4); the live table re-queries instantly. No Amazon call. Runs on the Inventory Health sheet — clicked elsewhere it jumps there (creating the tab if needed) so you can run it again. |
| Create STA SS | 创建 STA 表格 | Create an STA spreadsheet for the active row’s shipment. |
| Refresh Shipment | 刷新货件 | Refresh status for every non-terminal shipment on this sheet from Amazon. |
| Initiate Plan | 创建入库计划 | Creates the inbound plan from row 9 and the box lines (row 14+) and lists Amazon's packing options; a single packing group is confirmed with its box info at once (1a–1c DONE). Several groups mean the items cannot ship together: the error lists each group's SKUs below the items — cancel, keep one group's SKUs and run again. |
| Confirm Pack | 确认装箱 | Re-confirms the packing option ID in the stepper's 1b cell (1b DONE); Initiate Plan normally does this for you. |
| Set Box Info | 填写箱子信息 | Re-sends every box line's dimensions and weight (row 14+, units in H9/I9) for the packing group in the stepper's 1c cell — after you edit the box lines (1c DONE); refused once the shipment is confirmed. |
| Gen Placement Opts. | 生成分仓方案 | Fetches Amazon's placement options and fees; each shipment's warehouse, weight and volume land in STA-Options, where Rate/kg ✎ or Rate/m³ ✎ prices your own carrier. Pick one in the stepper's 2 cell. Click again to refresh from Amazon (rates carry over by warehouse). |
| Gen Trans. Opts. | 生成运输方案 | Fetches carrier options (cost, mode, partnered or own) for every placement's shipments into the STA-Options Transportation dropdowns and rebuilds STA-PL; pick per shipment there (3 DONE). |
| Match Carriers | 匹配承运商 | Run on the STA-Options tab: for every placement with 2+ shipments, shipment 1's picked Transportation Option fills the rest with the same carrier (SPD / LTL partnered rules). |
| Gen Delivery Window | 生成送达时间窗 | Own-carrier shipments only: fetches delivery windows for the picked placement's shipments (every placement when none is picked) into the STA-Options Delivery Window dropdowns (3b DONE). |
| Confirm Shipment | 确认货件 | Confirms the placement picked in the stepper's 2 cell and each shipment's Transportation + Delivery Window from STA-Options — books on Amazon. FBA ID, Reference ID and warehouse land in row 12, STA-Options (the FBA ID becomes the label link when Amazon returns labels) and Manage Shipments (2 and 4 DONE). |
| Get Ref. ID | 获取参考 ID | Re-reads each confirmed shipment from Amazon: status, Reference ID and warehouse refresh in STA-Options and row 12; the Reference ID is mirrored to Manage Shipments. |
| Get FBA Box Labels | 获取 FBA 箱标 | Fetches Amazon box labels for the picked placement's shipments whose FBA ID in STA-Options is not a link yet (page count from that row; cut to the FBA Box Label Size you chose in row 9 — required: 100x150 as is, 100x100 top square). Saves the PDF to the plan folder, turns the FBA ID into its link and mirrors it to Manage Shipments. Remove a link to fetch again. |
| Get FNSKU Labels | 获取 FNSKU 标签 | Builds FNSKU item labels from the items table — one per unit (Qty/Box × Boxes), at the FNSKU Label Size you chose in row 9 (required) — and opens them in a print dialog; nothing is written to the sheet. |
| Cancel Plan | 取消计划 | Cancels the inbound plan on Amazon; every stepper step and the Status cell become CANCELLED. |
| Initiate Plan | 创建入库计划 | Creates the inbound plan from row 9 and the item lines (row 14+) and lists Amazon's placement options in STA-Options and the stepper's 2 dropdown (1 DONE). |
| Confirm Placement | 确认分仓 | Confirms the placement picked in the stepper's 2 cell with Amazon and builds STA-Pack, one box block per shipment (2 DONE). |
| Set Box Info | 填写箱子信息 | Sends STA-Pack's box rows (dimensions + weight per shipment, units in H9/I9) to Amazon as packing information; needs 2 DONE (3 DONE). |
| Gen Trans. Opts. | 生成运输方案 | Fetches carrier options (cost, mode, partnered or own) for the confirmed placement's shipments into the STA-Options Transportation dropdowns; needs Ship Date and 3 DONE (4 DONE). |
| Gen Delivery Window | 生成送达时间窗 | Own-carrier shipments only: fetches delivery windows for the confirmed placement's shipments into the STA-Options Delivery Window dropdowns (5 DONE). |
| Confirm Shipment | 确认货件 | Confirms each shipment's Transportation + Delivery Window from STA-Options — books on Amazon. FBA ID, Reference ID and warehouse land in row 12, STA-Options (the FBA ID becomes the label link when Amazon returns labels) and Manage Shipments (6 DONE). |
| Get FBA Box Labels | 获取 FBA 箱标 | Fetches Amazon box labels for the picked placement's shipments whose FBA ID in STA-Options is not a link yet (page count from that row; cut to the FBA Box Label Size you chose in row 9 — required: 100x150 as is, 100x100 top square). Saves the PDF to the plan folder, turns the FBA ID into its link and mirrors it to Manage Shipments. Remove a link to fetch again. |
| Get FNSKU Labels | 获取 FNSKU 标签 | Builds FNSKU item labels from the items table — one per unit (Qty/Box × Boxes), at the FNSKU Label Size you chose in row 9 (required) — and opens them in a print dialog; nothing is written to the sheet. |
| Cancel Plan | 取消计划 | Cancels the inbound plan on Amazon; every stepper step and the Status cell become CANCELLED. |
| List Inbound Plans | 列出入库计划 | List your inbound plans (last 365 days) using the row-4 filters; newest first. |
| Setup Sheet | 设置表格 | Create or reset the Search Inbound Plans sheet header block. |
Sellers › store-reports (5)
| Button | 中文 | What it does |
|---|---|---|
| Create Reports | 创建报告 | Request Amazon reports from rows 4+ (Store, Report Type, dates); the Report ID fills in automatically. |
| Get Reports | 获取报告 | Poll pending reports; finished ones download to Drive and link in the row. |
| Clear Table | 清空表格 | Clear data rows; headers and dropdowns stay. Ctrl+Z to undo. |
| Search Reports | 搜索报告 | Search past Amazon reports using the row-4 filters. |
| Clear Table | 清空表格 | Clear result rows; headers and filters stay. Ctrl+Z to undo. |
Sellers › A+ (8)
| Button | 中文 | What it does |
|---|---|---|
| Load Hints | 加载提示 | Sets up / refreshes the sheet: headers, dropdowns, per-module color hints and the Example column. Run after picking module types. |
| Load Images (Drive) | 加载图片（Drive） | Fill image URLs from the Drive folder set in E4. |
| Create & Submit | 创建并提交 | LIVE: creates a NEW A+ document on Amazon (Content Document JSON if present, else the module rows), applies the ASINs (G4) and submits for approval. Amazon-hosted images are reused directly; Drive/other image URLs are uploaded. |
| Load A+ | 加载 A+ | Loads the existing A+ document whose key is in the Content Reference Key config cell (H4): modules into rows, module JSON into Content Document, ASINs into G4 — edit it, or change name/store to copy it. |
| Update A+ | 更新 A+ | LIVE: full-replace update of the EXISTING document whose key is in Content Reference Key (H4) — load it with Load A+, edit, then update; ASINs re-applied and approval resubmitted. |
| Revise A+ ASINs | 修订 ASIN | Replace the ASIN set on an existing A+ document and resubmit for approval. |
| List A+ | 列出 A+ | List all A+ documents for the store in A3; details fill 25 rows per click. |
| Load A+ | 加载 A+ | Loads the clicked result row's A+ document into the Create A+ sheet as an editable copy (JSON saved in its Content Document cell). |
Sellers › images (9)
| Button | 中文 | What it does |
|---|---|---|
| Fetch Images | 获取图片 | Reads Store (A4) and SKU / parent SKU (B4) from the Image Library sheet and rebuilds the grid: one column per image slot, s0-s8 first (the Publish Queue block), A+/other slots appended. Each child SKU gets two rows — plain CDN URLs, then an =IMAGE() preview row to confirm, delete, and paste the rest into Publish Queue. |
| Fetch by SKU | 按 SKU 获取 | Your OWN listed product: AI-summarized title+bullets → Product Context, main image → Sample 1, every listing image URL → the SKU cell's note. |
| Fetch by ASIN | 按 ASIN 获取 | Reads the Ref ASIN in column D (competitor / reference listing) and writes its images into each S-slot's Ref cell BY POSITION (main→S0, PT01→S1 …) as STYLE references only. A+ block refs: paste manually. |
| Preview Images | 预览图片 | Slideshow modal of the images on the current selection (the Useful-Tools previewer). |
| Reverse Prompt | 反推提示词 | Click a REFERENCE image first (a block's Ref cell, or Ref A-C) — a vision model reverses it into a structured prompt, written to the block's Reversed Prompt (Ref A-C target the Scope slots above). |
| Optimize Prompt | 优化提示词 | Adapts each Scope slot's Reversed Prompt to YOUR product: keeps the reference's style/composition, swaps the product for the Scope-selected Sample(s) + Product Context → slot Prompt (previous kept in the cell note). Prefer the reversed prompt as-is? Just copy it into the Prompt cell. |
| Generate | 生成 | Runs the Scope-selected slots from each slot's Prompt. A slot's own Ref attaches as a STYLE anchor only when it has NO Reversed Prompt — an optimized Prompt already carries the ref's style as text. Samples selected → EDIT (product identical to samples) · neither samples nor ref → text-to-image. To keep a Ref's exact scene, use Swap Product In. Files are saved as SKU_S0 / SKU_S0_V2 / SKU_A1 … in Images/<store>/<sku>. Edit jobs finish in the background and save automatically (~5 min — keep the sidebar open). |
| Swap Product In | ⇄ 场景换品 | Keeps each Scope slot's Ref image as the EXACT scene and replaces only the product with the Scope-selected Sample(s) — one edit call per slot, Ref goes first, no Prompt cell needed. Slots without a Ref are skipped (BLOCKED). The optional Instruction is appended to the swap prompt. Results queue and save automatically like Generate. |
| Score Results | 评分 | Queued jobs save automatically (~5 min, keep the sidebar open). This button AI-rates each Scope slot's V1-V3 against its prompt + Amazon main-image compliance → Scores column. |
Sellers › data-kiosk (5)
| Button | 中文 | What it does |
|---|---|---|
| Create Queries | 创建查询 | Sheet: Data Kiosk. Submit a query per ready row (rows 4+, empty Query ID) — pick report type, aggregate and dates, or paste custom GraphQL. |
| Get Results | 获取结果 | Poll pending queries; finished ones download to a Drive sheet linked in the Report Sheet column. |
| Clear Table | 清空表格 | Clear data rows; headers and dropdowns stay. Ctrl+Z to undo. |
| Search Queries | 搜索查询 | Search past Data Kiosk queries using the row-4 filters (Store required); all pages load in one click. |
| Clear Table | 清空表格 | Clear result rows; headers and filters stay. Ctrl+Z to undo. |
Sellers › dropbox (2)
| Button | 中文 | What it does |
|---|---|---|
| Fetch Image URLs | 获取图片链接 | Fetch image URLs for the rows on this sheet. |
| Refresh Access | 刷新授权 | Refresh access token. |
Sellers › shipments (4)
| Button | 中文 | What it does |
|---|---|---|
| Create B2B Order | 创建 B2B 订单 | Creates a B2B shipping order for the clicked Shipment row. |
| Get Tracking Status | 获取追踪状态 | Refreshes tracking status for the shipments on this sheet. |
| Create PL SS | 创建装箱单表格 | Creates the packing list from this sheet's rows. |
| Fill PL | 填写装箱单 | Active spreadsheet. Fill packing list. |
Ads › ads-sp (56)
| Button | 中文 | What it does |
|---|---|---|
| Setup Tabs | 1 · 初始化标签页 | Create the 5 Campaign Builder tabs (Campaigns / Targets / Bidding Adjustment / Negatives / Bulk Sheet). |
| Get Suggestions | 获取建议 | Amazon ranked keyword recommendations with suggested bids for every manual ad group's products — written to Builder · Suggestions for review. |
| Add Selected to Targets | 3 · 将所选加入投放 | Append the ticked suggestion rows to Builder · Targets with their suggested bids. |
| Validate All | 4 · 全部校验 | Validate the whole Builder workbook — joins, enums, budgets, naming, and live name-collision check. Problems land in the Status columns and the Bulk Sheet tab. |
| Launch | 5 · 启动 | Validate, then create the whole structure on Amazon (campaigns → ad groups → ads → targets → negatives); IDs and per-row statuses are written back. Rows that already have IDs are skipped. |
| List SP campaigns | 列出 | Fetch SP campaigns using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ad Groups | 加载广告组 | Drill down: click a campaign row first — this filters the SP Ad Groups sheet to that campaign and lists them. |
| Load Targets | 加载投放 | Drill down: click a campaign row first — this filters the SP Targets sheet to that campaign and lists them. |
| Create SP campaigns | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SP campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SP campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SP campaigns Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SP ad groups | 列出 | Fetch SP ad groups using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ads | 加载广告 | Drill down: click a ad group row first — this filters the SP Ads sheet to that ad group and lists them. |
| Load Targets | 加载投放 | Drill down: click a ad group row first — this filters the SP Targets sheet to that ad group and lists them. |
| Create SP ad groups | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SP ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SP ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SP ad groups Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SP ads | 列出 | Fetch SP ads using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Create SP ads | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SP ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SP ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SP ads Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SP targets | 列出 | Fetch SP BIDDING targets using the row-4 filters (positives only — negatives are on SP Negatives). Default shows active (ENABLED+PAUSED). |
| Create SP targets | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SP targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SP targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SP targets Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SP negatives | 列出 | Pull ALL negatives (keyword · product · brand, both levels) for the store, filtered by the row-4 Campaign / State. Names resolved from Ads Names. |
| Create SP negatives | 创建 | Create from rows with NO Target ID. Per-type gate runs first (⚠️ reasons). KEYWORD→keyword+match; PRODUCT→ASIN; BRAND→brand id; Level CAMPAIGN omits the ad group. |
| Resolve Brand IDs | 解析品牌 ID | For ticked BRAND rows whose Brand cell is a plain name, look the brand up via Amazon's brand search and rewrite it as 'Name (id)'. |
| Edit SP negatives | 编辑所选 | Push State (ENABLED/PAUSED) changes to Amazon for ticked rows (negatives have no bid). |
| Delete SP negatives | 删除所选 | PERMANENTLY archive the ticked negatives — v1 delete = archive, cannot be undone. |
| Setup SP Negatives Sheet | 设置表格 | Create or reset the SP Negatives tab (data rows untouched). |
| Get Suggestions | 获取建议 | Fetch suggestions per the row-4 controls (Source, ASINs / Campaign+Ad Group names, Suggestion Type). Keyword bids are already decimal currency. NOTE: negative-KEYWORD suggestions have no Amazon endpoint — mine the SP Search Terms report instead. |
| Search-Term Negatives | 搜索词否定 | NOT an Amazon suggestion — Amazon has no negative-keyword recommendation endpoint. Mines YOUR SP Search Terms report (rpt_sp_search_terms) for search terms with ≥ Min Clicks (J4) and ZERO orders over the Window (K4), writing MINED rows into the grid. Campaign (C4) scopes it; blank = whole account. Tick rows and Send Selected as Negatives. |
| Send Selected to SP Targets | 将所选发送 → SP 投放 | Stage the ticked suggestions into SP Targets (PAUSED, empty ID, Select ticked) — review there, then Create. Duplicates already on SP Targets are SKIPPED. |
| Send Selected as Negatives | 将所选发送为否定投放 | Stage the ticked rows into SP Targets with Negative=TRUE (keyword negatives; brand rows stage as PRODUCT_CATEGORY brand refinements). |
| Setup SP Suggestions Sheet | 初始化表格 | Create or reset the SP Suggestions tab (data rows untouched). |
| Analyze Campaign | 分析广告活动 | Read-only: pull the campaign's targets, bid recs per ad group, suggested budget (with the missed-opportunity WINDOW dates — they can be years old) and Amazon's campaign recommendations. Ad groups without servable ads show 'not delivering' (Amazon 422 — normal). |
| Apply Selected Bids | 应用所选竞价 | MUTATES Amazon: bulk-update the ticked targets' bids per the Apply Mode (MEDIAN / HIGH / CUSTOM New Bid). |
| Apply Suggested Budget | 应用建议预算 | MUTATES Amazon: set the campaign's daily budget to the analyzed Suggested Budget (D4). |
| Setup Bid Optimizer Sheet | 初始化表格 | Create or reset the Bid Optimizer tab. |
| List Portfolios | 列出 | Fetch all portfolios with budgets into the Portfolios sheet. |
| Create Portfolios | 创建 | Create portfolios from rows with a name and NO Portfolio ID; new IDs are written back. |
| Edit Selected | 编辑所选 | Push changes to Amazon — ONLY for Select-ticked rows. Portfolios cannot be archived via the API. |
| Setup Sheet | 设置表格 | Create or reset the Portfolios sheet header block. |
| Setup Sheet | 设置表格 | Create or reset the Ads Export sheet. |
| Submit Export | 提交导出 | Submit ads entity export requests. |
| Get Export Result | 获取导出结果 | Poll pending exports and download completed files. |
| Setup Sheet | 设置表格 | Create or reset the Ads History sheet. |
| Get History | 获取历史 | Fetch ads change history for a date range and entity type. |
| Setup Sheet | 设置表格 | Create or reset the Ads Recommendations sheet. |
| List Recommendations | 列出 | Fetch Amazon’s automated ads recommendations. |
| Apply Recommendations | 应用所选 | Apply the selected recommendations to your account. |
Ads › ads-sb (36)
| Button | 中文 | What it does |
|---|---|---|
| List SB campaigns | 列出 | Fetch SB campaigns using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ad Groups | 加载广告组 | Drill down: click a campaign row first — this filters the SB Ad Groups sheet to that campaign and lists them. |
| Load Targets | 加载投放 | Drill down: click a campaign row first — this filters the SB Targets sheet to that campaign and lists them. |
| Create SB campaigns | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SB campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SB campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SB campaigns Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SB ad groups | 列出 | Fetch SB ad groups using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ads | 加载广告 | Drill down: click a ad group row first — this filters the SB Ads sheet to that ad group and lists them. |
| Load Targets | 加载投放 | Drill down: click a ad group row first — this filters the SB Targets sheet to that ad group and lists them. |
| Create SB ad groups | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SB ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SB ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SB ad groups Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SB ads | 列出 | Fetch SB ads using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ad Associations | 加载广告关联 | Drill down: click a ad row first — this filters the SB Ad Associations sheet to that ad and lists them. |
| Create SB ads | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SB ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SB ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SB ads Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SB targets | 列出 | Fetch SB targets using the row-4 filters. Default shows active only (ENABLED+PAUSED). Use the Negative filter (TRUE/FALSE/ALL) to split negatives from bidding targets. |
| Create SB targets | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SB targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SB targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SB targets Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SB negatives | 列出 | Pull ALL SB negatives (keyword · product · brand, ad-group level) for the store, filtered by row-4 Campaign / State. Names from Ads Names. |
| Create SB negatives | 创建 | Create from rows with NO Target ID. Per-type gate first; SB is ad-group level only (Level=AD_GROUP + an Ad Group required). |
| Resolve Brand IDs | 解析品牌 ID | For ticked BRAND rows with a plain name, look up the brand via Amazon and rewrite as 'Name (id)'. |
| Edit SB negatives | 编辑所选 | Push State (ENABLED/PAUSED) changes for ticked rows. |
| Delete SB negatives | 删除所选 | PERMANENTLY archive ticked negatives — v1 delete = archive. |
| Setup SB Negatives Sheet | 设置表格 | Create or reset the SB Negatives tab. |
| List SB ad associations | 列出 | Fetch SB ad associations using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Create SB ad associations | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SB ad associations | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SB ad associations | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SB Associations Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
Ads › ads-sd (30)
| Button | 中文 | What it does |
|---|---|---|
| List SD campaigns | 列出 | Fetch SD campaigns using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ad Groups | 加载广告组 | Drill down: click a campaign row first — this filters the SD Ad Groups sheet to that campaign and lists them. |
| Load Targets | 加载投放 | Drill down: click a campaign row first — this filters the SD Targets sheet to that campaign and lists them. |
| Create SD campaigns | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SD campaigns | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SD campaigns | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SD campaigns Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SD ad groups | 列出 | Fetch SD ad groups using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Load Ads | 加载广告 | Drill down: click a ad group row first — this filters the SD Ads sheet to that ad group and lists them. |
| Load Targets | 加载投放 | Drill down: click a ad group row first — this filters the SD Targets sheet to that ad group and lists them. |
| Create SD ad groups | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SD ad groups | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SD ad groups | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SD ad groups Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SD ads | 列出 | Fetch SD ads using the row-4 filters. Default shows active only (ENABLED+PAUSED). |
| Create SD ads | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SD ads | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SD ads | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SD ads Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SD targets | 列出 | Fetch SD targets using the row-4 filters. Default shows active only (ENABLED+PAUSED). Use the Negative filter (TRUE/FALSE/ALL) to split negatives from bidding targets. |
| Create SD targets | 创建 | Create from rows with the required ✎ fields filled and an EMPTY ID column; new IDs are written back. |
| Edit SD targets | 编辑所选 | Push your changes to Amazon — ONLY for rows whose Select box is ticked. |
| Delete SD targets | 删除所选 | PERMANENTLY archive the ticked rows on Amazon — v1 delete = archive, it cannot be undone. |
| Setup SD targets Sheet | 设置表格 | Create or reset the sheet header block (data rows untouched). |
| List SD negatives | 列出 | Pull ALL SD negatives (product · brand, ad-group level) for the store, filtered by row-4 Campaign / State. |
| Create SD negatives | 创建 | Create from rows with NO Target ID. SD is PRODUCT/BRAND only, ad-group level only (keyword is not offered). |
| Resolve Brand IDs | 解析品牌 ID | For ticked BRAND rows with a plain name, look up the brand via Amazon and rewrite as 'Name (id)'. |
| Edit SD negatives | 编辑所选 | Push State (ENABLED/PAUSED) changes for ticked rows. |
| Delete SD negatives | 删除所选 | PERMANENTLY archive ticked negatives — v1 delete = archive. |
| Setup SD Negatives Sheet | 设置表格 | Create or reset the SD Negatives tab. |
Ads › ads-reports (3)
| Button | 中文 | What it does |
|---|---|---|
| Create Reports | 创建报告 | Submit ads report requests from the sheet rows. |
| Get Reports | 获取报告 | Poll pending report rows and download completed reports. |
| Refresh Report Types | 刷新报告类型 | Regenerate the Ads Report Type catalog tab from the latest report definitions. |
noon › noon-listings (24)
| Button | 中文 | What it does |
|---|---|---|
| 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. |
| 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. |
| 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. |
| 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. |
| Fetch by SKU | 按 SKU 获取 | Rows with Store+SKU Parent set, Fetched At empty. Clear Fetched At to redo. |
| Fetch by SKU | 按 SKU 获取 | Rows with Store+SKU Parent set, Draft Listing empty. |
| Image → Listing (AI) | 图片 → Listing（AI） | Writes bilingual AI copy from the row's image + Instructions. |
| Optimize Listing (AI) | 优化 Listing（AI） | AI rewrites the row's bilingual copy — facts kept. AI |
| Send to Publish Queue | 发送至发布队列 | Copies the row into the noon Publish Queue (existing columns only) and marks it SENT. |
| 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. |
| Delete SKUs | 删除 SKU ⚠ | DESTRUCTIVE: delete ticked child/parent SKUs on noon. Parent deletes cascade to every variant. |
| Get Pricing | 获取定价 | Read price / msrp / is_active per partner_sku. |
| Update Pricing | 更新定价 | Push price / msrp / is_active to noon. |
| Get Transfer Price | 获取调拨价 | Read USD cross-border transfer prices per partner_sku. |
| Update Transfer Price | 更新调拨价 | Push USD transfer_price / msrp / is_active to noon. |
| Get Offers | 获取报价 | Look up noon sku / title / brand / per-country offers for each partner_sku. |
| Get Stock | 获取库存 | Read current available qty for each (warehouse_code, partner_sku) row. |
| Update Stock | 更新库存 | Push the qty column to noon for each row. |
| Map Barcodes | 映射条码 | Connect each partner_sku to its barcode (UPC/EAN/ISBN) on noon. |
| Create Import | 创建导入 | Submit the barcode rows as an async import; writes an import reference. |
| Refresh Status | 刷新状态 | Poll the import status/report for the saved reference. |
| List Warehouses | 列出仓库 | Load the partner warehouses for the Store in A4. |
| List Categories | 列出类目 | List noon catalog categories (codes used by noon Publish Queue). |
| Lookup Returns | 查询退货 | List noon return items + barcode references matching a barcode. |
noon › noon-fbn (14)
| Button | 中文 | What it does |
|---|---|---|
| List Eligible Items | 列出可入库商品 | Load FBN-eligible SKUs (with images) into the FBN Product tab, then copy the ones to ship into the items table. |
| Create Shipment | 创建货件 | Create an ASN from Store (A9) + Ext Ref (B9); the ASN number lands in C9. |
| Update Items | 更新商品 | Push the items table (partner_sku, qty, storage_type) to the ASN. |
| Load existing items | 加载现有商品 | Pull the current ASN items back into the table to review or edit. |
| Seal Shipment | 封箱发运 | Lock the ASN (SEAL) so it can be scheduled — items can no longer change. |
| Get Slot Availability | 获取时段可用性 | List destination warehouses + delivery slots for the SEALED ASN into the slots table. |
| Schedule Shipment | 预约送仓 | Tick ONE slot row in the table, then book it for the ASN. |
| Refresh Status | 刷新状态 | Re-fetch the ASN header + status from noon. |
| Reschedule Shipment | 重新预约送仓 | Release the booked slot of a SCHEDULED ASN (back to SEALED), then Get Slot Availability and Schedule again. |
| Delete selected item(s) | 删除所选条目 | Remove the ticked item rows from the ASN (before Seal). |
| Cancel Shipment | 取消货件 | Cancel the whole ASN on noon. |
| Clear Data (new ASN) | 清空数据（新 ASN） | Wipe this ASN data and reset the sheet to a blank template for the next shipment — keeps the Store. Nothing is sent to noon. |
| List Shipments | 列出货件 | Enter Store in A4, then list all ASNs for the Store into the noon Shipments tab. |
| List Shipment Items | 列出货件商品 | Loads the clicked ASN row's items (with images) into the noon Shipment Items tab. |
noon › noon-reports (2)
| Button | 中文 | What it does |
|---|---|---|
| Create Reports | 创建报告 | Request noon exports from rows 4+ (Report Type + params); the Export Code fills in automatically. |
| Get Reports | 获取报告 | Poll pending exports; finished ones download to Drive (SellerSheet/NoonReports) and link in the row. |