Set up a new SKU on Shopify, Amazon and Walmart from one product sheet
Updated · By Ecomsellertool editorial team
To launch a new SKU on Shopify, Amazon and Walmart, keep one approved product record, check it against each channel's required fields before anything is sent, then create the Shopify product, the Amazon listing through the Listings Items API and the Walmart item through a setup feed. A status tracker follows each channel until the SKU is buyable everywhere and flags any failure with its reason.
- Amazon's Product Type Definitions API returns a JSON Schema of a product type's attributes, and putListingsItem's VALIDATION_PREVIEW mode validates a listing without saving it (checked October 23, 2026).
- Amazon's getListingsItem reports a listing as BUYABLE (shoppers can purchase it) or DISCOVERABLE (shoppers can see it), plus issues marked ERROR, WARNING or INFO.
- Walmart's MP_ITEM feed creates a new seller-fulfilled item; feeds are processed asynchronously and take up to 10,000 items per request (checked October 23, 2026).
- Walmart accepts GTIN, UPC, EAN and ISBN product IDs, checks them against GS1, and removes listings with invalid IDs; products without an ID can request a GTIN or UPC exemption.
- Shopify's productSet mutation creates or updates a product with its variants in one request; a Draft product is not yet ready to be sold, an Active one is.
- In this recipe fixed rules do the checks and the submissions; an AI model only drafts missing copy, and a person approves the record before any channel sees it.
The step map: who runs each step
Trigger: A product record is marked approved in the master product sheet (a spreadsheet, PIM or ERP), plus a scheduled check every few minutes on each channel's submission status until the SKU is live everywhere.
| Step | What happens | Who runs it |
|---|---|---|
| 1 | A new SKU is added to the product sheet: identifiers, brand, title, description, images, price, cost, weight, dimensions, stock and the product type for each channel. Rules list every field each channel will still need. | Rule |
| 2 | An AI model drafts any missing title, bullets or description from the approved facts, within each channel's length limits. It never invents a claim, an identifier or a price. | AI model |
| 3 | A person approves the record: the facts, the product type per channel, the identifier or exemption, the price and any safety claims. | Person |
| 4 | Rules validate the record against each channel before submission: Amazon's product type schema and a VALIDATION_PREVIEW call, Walmart's item spec for the product type, and Shopify's own field rules. | Rule |
| 5 | The workflow creates the Shopify product as a draft, submits the Amazon listing with putListingsItem, and sends the Walmart item in an MP_ITEM setup feed, logging each submission ID. | Rule |
| 6 | The status tracker polls or listens to each channel: Amazon listing status and issues, Walmart feed and item status, Shopify product status and publishing. | Rule |
| 7 | Once a channel accepts the item, the workflow sets stock on it and checks the price it shows against the record. | Rule |
| 8 | When every channel shows the SKU live, the task closes and the SKU moves to the ongoing stock sync and listing alerts. Any failure reopens the task with the channel's reason. | Rule |
6 rule steps · 1 AI model step · 1 person step. A rule follows fixed logic you approve; an AI model handles messy input and its output is checked by rules; a person makes the calls listed below.
What stays with a person
- The product record before the first submission: facts, product types, identifier or exemption, price
- Every model-drafted title, bullet and description before it is published
- Safety, battery, hazmat or regulatory attributes, which come from your supplier documents, not from a guess
- Errors the rules cannot fix, such as a GTIN that GS1 does not match or a category approval Amazon requires
- Switching the Shopify product from Draft to Active, if you launch on your store last
Which tools can run it
- Each channel's own bulk upload templates, for a few new SKUs a quarter set up by hand
- Zapier, Make or n8n reading the sheet, for the Shopify product and status alerts, with marketplace uploads still done by hand
- Custom code on your accounts, for schema checks, Amazon and Walmart submissions and a tracker that follows every channel
Systems it connects
- Master product sheet (Sheets, Excel, a PIM or the ERP)
- Shopify products, variants, inventory and sales channels
- Amazon SP-API: Product Type Definitions, Listings Items
- Walmart Marketplace API: item spec, feeds, items, stock
- Image storage with public URLs
- Slack or email for approvals and exceptions
Build size: Large
Each call is documented; the work is mapping one record to three schemas per product type and tracking three different status models until every channel is live.
A new SKU rarely fails on the big things. It fails on a missing battery attribute on Amazon, a UPC that GS1 does not recognize on Walmart, or a Shopify product left in Draft. Each channel finds the gap at a different time, and someone notices days later. This recipe launches a new SKU from one approved product record: it checks the record against what each channel needs to go live, submits it to all three, and follows every channel until the SKU can be bought everywhere.
It is a launch workflow. Once the SKU is live, it hands over to the multichannel inventory sync for stock and to listing error alerts for anything that breaks later.
What does a new SKU need before it can go live on each channel?
This is the checklist the workflow runs before it submits anything. Each row is a field or step; each cell says what that channel needs and where it is checked. Use it by hand today for your next launch.
| Field or step | Shopify | Amazon | Walmart |
|---|---|---|---|
| Product type or category | One product category per product, shared by all its variants | A product type, found with searchDefinitionsProductTypes; its JSON Schema lists every attribute and constraint | A product type; Walmart's Get spec call returns the JSON schema of required attributes |
| Identifier (GTIN, UPC) | Barcode is optional: ISBN, UPC (8 or 12 digits) or GTIN (8, 12, 13 or 14 digits) | An external product identifier, or a declared identifier exemption | GTIN, UPC, EAN or ISBN, checked against GS1; no ID means a GTIN or UPC exemption first |
| Brand | Set from the record | The brand attribute, in the product identity group | Set from the record, as the item spec for the product type asks |
| Images | Uploaded with the product | MAIN image plus up to 8 others, from URLs Amazon can reach | White background, square, 1500 px for zoom, 5 MB or less; at least four recommended |
| Price | On each variant | The purchasable offer attribute | In the item data, checked against your floor before the feed is sent |
| Inventory | Absolute quantity per location after the product exists | Fulfillment availability for seller-fulfilled stock | Set through the Inventory API once the SKU is set up |
| Shipping or fulfillment | Exact weight, used for shipping rates | The merchant shipping group, which names your shipping templates | MP_ITEM creates a seller-fulfilled item |
| Safety and regulatory attributes | None the workflow relies on | Battery, hazmat, Prop 65 and similar attributes when the product type requires them | Whatever the item spec marks required for the product type |
| Live when | Status Active and published to the sales channels you chose | Status BUYABLE with no ERROR issues | Published, lifecycle Active, with stock |
The Amazon facts come from its guide to managing product listings (checked October 23, 2026), whose example schema groups brand, the external product identifier and the identifier exemption under product identity, and lists battery, hazmat and California Proposition 65 attributes. Amazon's media guide (checked October 23, 2026) names the MAIN image attribute and up to eight others, and says images can come from publicly accessible URLs. The shipping template field is the merchant shipping group in Amazon's shipping template tutorial.
On Walmart, the product identifier policy (checked October 23, 2026) accepts GTIN, UPC, EAN and ISBN, checks them against GS1 and says listings with invalid IDs will be removed. Private label or handmade products without an ID can request an exemption. Walmart's image guidelines (checked October 23, 2026) set the white background, the 1:1 ratio, 1500 px for zoom and the 5 MB limit. Shopify's product details page guide (checked October 23, 2026) covers the barcode formats, the single category and the weight used for shipping rates.
How does one product sheet become three listings?
The record comes first. For example, a brand launching 12 new SKUs a month keeps one row per SKU with every fact the three channels need, plus the product type it maps to on each. Rules flag every empty field per channel, so the team fills gaps once instead of three times. An AI model can draft missing copy from approved facts. A person approves the whole record before any channel sees it.
Then each channel gets its own submission. On Amazon, Amazon's listings workflow guide (checked October 23, 2026) says to call searchDefinitionsProductTypes for the product type and getDefinitionsProductType for its JSON Schema. The workflow validates the record against that schema, then calls putListingsItem in VALIDATION_PREVIEW mode, which validates the data without saving it to your catalog and answers VALID or INVALID. Only a clean preview is sent for real; the response says ACCEPTED or INVALID and carries a submission ID. Amazon lists a default rate of 5 requests per second for this call (checked October 23, 2026).
On Walmart, Get spec (checked October 23, 2026) returns the item schema for up to 20 product types per request, throttled to three calls a minute per seller, so the workflow caches it. The item goes out in an MP_ITEM feed. Walmart's bulk item setup guide (checked October 23, 2026) says feeds are processed asynchronously, return a feed ID, and take up to 10,000 items per request.
On Shopify, the productSet mutation (checked October 23, 2026) creates the product with its options and variants in one request. The workflow creates it as Draft, which Shopify describes as a product whose details need completing before it can be sold. Stock goes on with inventorySetQuantities, which sets absolute quantities, and publishablePublish puts the product on the sales channels you chose.
How do you know when the SKU is live everywhere?
A submission is not a launch. Each channel reports progress in its own words, so the tracker maps them onto one set of states and acts at each one.
| State | What each channel says | What the automation does |
|---|---|---|
| Draft | Record missing fields for one or more channels | Lists the missing fields per channel and assigns them |
| Approved | A person signed off the record | Starts validation; nothing is sent yet |
| Validated | Amazon preview VALID; record passes Walmart's item spec | Submits to every channel that passed; holds the others with the reason |
| Submitted | Amazon ACCEPTED with a submission ID; Walmart feed ID; Shopify product ID as Draft | Logs every ID against the SKU and starts polling |
| Processing | Walmart feed RECEIVED or INPROGRESS; item INPROGRESS | Polls on a schedule; listens for Amazon's listing status and issue notifications |
| Error | Amazon issue with ERROR severity; Walmart item DATA_ERROR, SYSTEM_ERROR or TIMEOUT_ERROR | Reopens the task with the channel's reason; resubmits once on system or timeout errors only |
| Visible, not buyable | Amazon DISCOVERABLE without BUYABLE; Walmart published without stock | Sends stock and the offer, checks the price shown against the record |
| Live | Shopify Active and published; Amazon BUYABLE; Walmart PUBLISHED and ACTIVE with stock | Closes the task, tells the team, hands the SKU to stock sync and listing alerts |
The Amazon states come from getListingsItem (checked October 23, 2026): BUYABLE means shoppers can purchase the item, DISCOVERABLE means they can see it, and issues carry ERROR, WARNING or INFO severity. Amazon's listing status guide explains that missing offers or depleted inventory can leave a listing discoverable but not buyable. The listings workflow guide describes the status-change and issues-change notifications the tracker listens for.
Walmart's feed item status (checked October 23, 2026) gives the feed states and each item's ingestion result. All items returns the published status (such as PUBLISHED, IN_PROGRESS, UNPUBLISHED or SYSTEM_PROBLEM) and the lifecycle status (ACTIVE, ARCHIVED or RETIRED). The Inventory API overview says SKUs must be set up before their stock can be managed through the API, which is why stock goes on after acceptance.
What stays with a person?
The decisions that put your name on a fact. A person approves the record, including the product type on each channel, since a wrong one changes every required attribute. A person signs off model-drafted copy before it is published. Battery, hazmat and other regulatory answers come from supplier documents and a person who has read them. Identifier problems go to a person too: a GTIN that does not match GS1 is fixed at the source or replaced by an exemption request, never patched around.
The rules carry the rest: checking, submitting, polling, logging and nudging. Our guide to what to automate first makes the same split for any workflow: automate the work around a judgment call, never the decision itself.
Which tool should run it?
The simplest one that can see all three channels' status.
| Level | Fits when | What to watch |
|---|---|---|
| Each channel's own bulk upload templates | A few new SKUs a quarter | Three templates kept by hand; errors show up in three places |
| Zapier, Make or n8n | Shopify products from a sheet, plus status alerts | Marketplace schemas and feed polling usually outgrow a no-code step |
| Custom code on your accounts | Regular launches across all three channels | Can run on Ecomsellertool Growth OS beside your stock and order flows |
If you are weighing the workflow tools, our Zapier vs Make vs n8n comparison covers how each counts work. Amazon's side runs on the Selling Partner API, and every new Amazon listing either matches or creates an ASIN. When launches turn into keeping a large catalog consistent, our listing and catalog agent is the next step, and a new channel itself is scoped under marketplace expansion. Brands new to Walmart can start with our Walmart marketplace guide.
Who builds new SKU setup across Shopify, Amazon and Walmart?
Ecomsellertool builds workflow automation on your own accounts and systems. We have built software on Amazon's seller APIs since 2017, shipped integrations for 20+ marketplaces and 50+ tools for 100+ teams. For new SKU setup we map your product sheet to each channel's schema first, then build the checks, the submissions and the status tracker. Send a project brief below, or see how our workflow automation service works.
The building blocks are work we have shipped:
- Walmart item setup and feed status. For IVCSR we built an Amazon and Walmart system whose Walmart module creates new items and updates existing ones, including variants, prices and inventory, using the bulk item setup feed, feed status and feed item status APIs.
- Amazon, Walmart and Shopify in one workspace. For Seller7 we built one workspace across 20+ marketplaces on the Amazon SP-API, the Walmart Marketplace API and the Shopify API.
- Listing details and a product checklist. For Little Owl, a prep center, we built software where customers add listings with price and quantity, generate FNSKUs and keep a product checklist for FBA.
Get your new SKU setup built
Send us your product sheet and your channels
Describe the workflow you want automated. We reply with a written plan: scope, timeline and a fixed price.
Frequently asked questions
Can I list one product on Shopify, Amazon and Walmart at the same time?
Yes, from one approved record. The workflow checks the record against each channel's required fields first, then creates the Shopify product, submits the Amazon listing and sends the Walmart setup feed in the same run. Each channel processes on its own clock, so a status tracker follows all three until the SKU is live everywhere.
Do I need a UPC or GTIN to sell on Amazon and Walmart?
Usually, yes. Walmart requires a product ID on every item, checks it against the GS1 database and removes listings with invalid IDs. Products without one, such as private label or handmade items, can request a GTIN or UPC exemption. Amazon's listing schema has fields for an external product identifier and for declaring an identifier exemption. Shopify does not require a barcode at all.
How do I find out which attributes Amazon requires for my product?
Call the Product Type Definitions API. searchDefinitionsProductTypes suggests the product type, and getDefinitionsProductType returns a JSON Schema of every attribute, constraint and condition for that type in a given marketplace. Validate your record against it, then send the listing with putListingsItem in VALIDATION_PREVIEW mode to see Amazon's own errors before anything is saved.
How long does a new Walmart item take to go live?
Walmart does not promise a fixed time. Item setup runs through feeds that are processed asynchronously, so the workflow polls the feed status and each item's ingestion status until the item is published. A failed item comes back with a data, system or timeout error, and the tracker reopens the task with that reason.
Is this the same as a catalog agent?
No. This recipe launches one new SKU and stops when it is live on every channel. A catalog agent keeps the whole catalog consistent after launch: it checks live listings against the master record and proposes fixes. Many brands start with the launch recipe and add the agent later.
Should the AI write the listings?
It can draft them. A model writes the title, bullets and description from facts your team approved, within each channel's limits. A person approves the draft before it is published. Identifiers, prices, product types and safety attributes come from the record and your supplier documents, never from the model.
