Attributes & Publish Queue
Turn flat spreadsheet cells into Amazon-shaped attribute JSON and back, validate, and publish many listings at once from a Publish Queue sheet.
In short
Seed a Publish Queue sheet for one or more product types, fill flat cells (or fetch what Amazon already has), then submit. SellerSheet translates each cell to the attribute shape Amazon expects, and back again.
Step by step
Seed the sheet
"Prepare a Publish Queue template for product type LUGGAGE." listings_prepare_publish_queue_template bundles everything needed to set up a Publish Queue tab for one or several product types — columns merged across types, required ones first.
Fill it — or start from what is live
listings_fetch_attributes_by_skus fetches your own listings and flattens their attributes into cells; listings_fetch_attributes_by_asins does the same for any ASIN's catalog attributes, and listings_parse_asin_to_cells maps one ASIN onto the sheet's columns. listings_get_attribute_guide explains an attribute: its format, units and allowed values.
Check the translation
listings_build_payload turns flat values into Amazon's attribute JSON so you can see exactly what will be sent; listings_parse_payload does the reverse.
Submit
listings_submit_items builds and submits per SKU in one step; listings_submit_feed sends a whole batch through Amazon's Feeds API, and listings_poll_feed_results reads back what Amazon accepted or rejected.
Try asking
"Prepare a Publish Queue template for product type LUGGAGE."
"Fetch the current attributes for these 50 ASINs and flatten them into my sheet."
"Submit the rows I changed."
Seeding the template, both ways
The same tool and the same arguments — through your AI client, or from your own code.
MCP — you name the product types; your agent calls listings_prepare_publish_queue_template and writes the template into your sheet with the sheet tools.
In an AI client (MCP)
{
"name": "listings_prepare_publish_queue_template",
"arguments": {
"store": "myStore-US",
"productTypes": [
"LUGGAGE"
]
}
}From code (Tool API)
curl -X POST https://api.sellersheetai.com/api/v1/tools/listings_prepare_publish_queue_template \
-H "Authorization: Bearer $SELLERSHEET_API_KEY" \
-H "Content-Type: application/json" \
-d '{"store":"myStore-US","productTypes":["LUGGAGE"]}'Write access required
Submitting items or a feed changes your listings, so the store needs write access (see Stay in control). Templates, fetches, guides and payload previews work with read access. A submitted update replaces the listing's attributes with the row, so fetch first and edit from there.
Tools on this page
Pulled from the catalog at build time, each with its own access label.
| Tool | Access | What it does |
|---|---|---|
listings_poll_feed_results | write | Check the feeds behind the Submission Log's unfinished Submit Feed rows and get back the cells to write: Feed Status, Result, Issues, Raw Response. |
listings_build_payload | read | Build Amazon-shaped attribute JSON from a Publish Queue row's flat cells, per SKU, driven by the productType schema. |
listings_fetch_attributes_by_asins | read | Bulk fetch + flatten Amazon catalog attributes for N ASINs in ONE call. |
listings_fetch_attributes_by_skus | read | Bulk fetch + flatten Amazon listings attributes for N OWNED SKUs in ONE call. |
listings_get_attribute_guide | read | The row-4 guide (format, unit, allowed values, example) for each Publish Queue column of a productType — one per flat-file key, so item_weight has one for #1.value and one for #1.u |
listings_parse_asin_to_cells | read | Convenience: fetch an ASIN's catalog attributes from Amazon and return flat, operator-readable cell values. |
listings_parse_payload | read | Turn Amazon attribute JSON you already hold (from listings_getListingsItem or catalogItems_getCatalogItem) into Publish Queue cells keyed by Amazon's flat-file keys — the inverse o |
listings_prepare_publish_queue_template | read | Everything needed to seed a Publish Queue tab for N productTypes in one call: one bundle for a single productType, or ONE merged bundle keyed by the joined names ("TOWEL,HEADPHONES |
listings_submit_feed | destructive | Bulk publish through Amazon's Feeds API (JSON_LISTINGS_FEED) — the sidebar's "Submit Listing" parity, for 10+ SKUs up to ~25,000 per call; for interactive edits of ≤20 SKUs with pe |
listings_submit_items | destructive | Build Amazon-shaped payloads from Publish Queue cells AND submit them per SKU through the listings-items API in one call — the same input shape as listings_build_payload, then one |
FAQ
Can I check rows before submitting?
Yes — listings_validate_rows runs Amazon's validation preview on the rows first. See Create listings.
Can I do this in the Google Sheets add-on?
Yes — the add-on's catalog panel runs the same Publish Queue from the sidebar. See the add-on buttons.
Where do I find which listings need work?
Start with View & search listings.