Skip to content
syntaqx

Commerce, chapter 29 of 66

Walmart, eBay, Etsy, TikTok Shop & Others

Walmart, eBay, Etsy, TikTok Shop, Target Plus, Best Buy, Mercado Libre, Temu and Shein compared: who can sell, fees, fulfillment, standards and payouts.

19 min readUpdated

Amazon is the marketplace every brand starts with, and rarely the only one. A brand that sells on Amazon usually adds Walmart Marketplace next, then eBay for refurbished and open-box units, TikTok Shop for products that sell on video, and a retailer's curated marketplace (Target Plus, Best Buy) where it can get in; a maker sells on Etsy; a brand selling in Latin America sells on Mercado Libre. Each marketplace has the same parts (an application, a fee schedule, a fulfillment program, performance standards, a return policy, a payout schedule and an API) and each sets them differently. The work for the software is to hold all of them as data, so that adding a channel is configuration and a fee change is a new row, not a release.

This chapter compares the product marketplaces other than Amazon, as of October 2026: who may sell, what they charge, how fulfillment works, what they measure and when they pay, plus the marketplaces that buy the goods instead (Temu's managed model, Wayfair's supplier model). It extends listings and sales_channels from The Core Data Model. Amazon is Selling on Amazon; the fulfillment networks (WFS, MCF) are Warehouses, 3PLs & Fulfillment Networks; TikTok Shop's creator, affiliate and live-selling side is the User-Generated Platforms volume's Social Commerce & Live Shopping; marketplaces of people and services (rentals, services, resale between individuals) are that volume's peer-to-peer part, from Services Marketplaces; building a marketplace of your own is Running Your Own Marketplace.

How the Platforms Do It#

As of October 2026, from each marketplace's seller pages, help centers and filings:

Marketplace Who may sell Commission Other fees Fulfillment Scale
Walmart Marketplace Approved businesses with a US business tax ID and a record of e-commerce success 15% most categories; 8% consumer electronics; 6% personal computers "zero setup, monthly, or hidden fees" Seller-fulfilled from a US warehouse, or Walmart Fulfillment Services (WFS) Walmart's global advertising nearly $6.4 billion in fiscal 2026; marketplace growth cited, not quantified
eBay Anyone, individual or business Final value fee 13.6% of the sale up to $7,500 in most categories, 2.35% above $0.30 or $0.40 per order; 250 free listings a month, then $0.35; Store subscriptions $4.95 to $2,999.95 a month Seller-fulfilled $79.6 billion GMV and 135 million active buyers in 2025
Etsy Sellers of items they make or design, vintage, and craft supplies 6.5% transaction fee $0.20 per listing; 3% + $0.25 US payment processing; Offsite Ads 12% to 15% on attributed orders Seller-fulfilled $10.5 billion marketplace GMS, 86.5 million active buyers and 5.6 million active sellers in 2025
TikTok Shop (US) US residents and entities 18 or older, and cross-border sellers based in Japan 6% in most categories Affiliate commissions the seller sets, 1% to 80% Seller-fulfilled, or Fulfilled by TikTok (FBT) Not disclosed in US filings
Target Plus By invitation Not published Not published Seller-fulfilled to Target's standards "more than 1,200 partners"; about $1 billion of third-party digital sales in 2024, targeted above $5 billion by 2030
Best Buy Marketplace (US) Approved sellers Not published Not published Seller-fulfilled; returns accepted in Best Buy stores Launched August 19, 2025, "powered by Mirakl"
Mercado Libre Sellers in 18 Latin American countries By listing type and category Fixed per-unit cost on low-priced items Mercado Envios and fulfillment centers handling "more than half of shipments" $65.0 billion GMV and 121 million unique active buyers in 2025
Temu Manufacturers and, since 2024, local sellers Not published; in the managed model Temu sets the price Not published Temu's logistics, or the local seller's Parent PDD's 2025 revenue $61.8 billion, Temu not broken out
Shein Marketplace Third-party fashion and lifestyle sellers alongside Shein's own goods Not published Launch incentives with "no platform fees" for a period Seller-fulfilled or Shein's Not disclosed

Three patterns run through the table:

  • Open, approved and invited. eBay and Etsy let anyone list; Walmart and Best Buy approve each seller against published criteria; Target Plus invites. The tighter the door, the more the marketplace behaves like a retailer's buyer, choosing which brands and assortments it wants, and the more its standards read like a vendor agreement.
  • Commission is the headline, not the cost. Etsy's 6.5% becomes 9.5% plus $0.25 with US processing and up to 15% more on an Offsite Ads order; eBay's 13.6% comes with a per-order fee, optional Store subscriptions and Promoted Listings. The comparable number is the fee as a share of the order's total, computed per order from all the lines (Fee Models).
  • Every marketplace has a fulfillment arm or wants one. WFS, FBT, Mercado Libre's fulfillment centers and Amazon's FBA all trade lower fulfillment cost and a better badge for the seller's inventory in the marketplace's building. Walmart and Amazon now ship each other's orders from those buildings (Marketplace networks are now 3PLs).

Walmart Marketplace#

Walmart's marketplace sells third-party goods on Walmart.com beside Walmart's own inventory, and it approves every seller. Its minimum qualifications, updated September 2, 2026, are a "Business Tax ID(s) or Business License Number (SSN is not accepted)," a personal ID, documents that verify the business's name and address, a "History of Marketplace or eCommerce success," and "A B2C U.S. warehouse with returns capability and ability to adhere to our Seller Performance Standards, or use Walmart Fulfillment Services (WFS)." There is no monthly fee; the referral fee is 15% in most categories, 8% for consumer electronics and 6% for personal computers.

Pricing rules. Walmart's marketplace polices prices directly. Its pricing rules "will automatically unpublish offers from Walmart Marketplace that are priced egregiously higher" than prices elsewhere, with the reason code "Reasonable Price Not Satisfied"; offers "priced substantially higher than prices currently or recently offered on Walmart.com" lose Buy Box eligibility; and an "Egregious Shipping Cost" rule can unpublish an offer or make it ineligible for the Buy Box. A seller's price change on another channel can therefore unpublish its Walmart offer, so the pricing engine has to know each channel's rules before it moves a price (Selling on Amazon shows why price-parity rules are also an antitrust question).

Returns. Sellers must offer a "minimum return window of 30 days, which begins seven days after an item's ship date"; they "may not apply restocking fees to customers except for eligible items set up with return exemptions" (up to 20% for exempt items returned not in sellable condition) and "may not apply return shipping charges to customers"; and "Walmart will accept eligible Marketplace items returned to Walmart stores on your behalf," oversized and freight items excepted. A store return of a marketplace item is a return the seller learns about from Walmart, received at a location it doesn't run (Returns in Store).

Fulfillment. WFS stores the seller's inventory and ships Walmart orders in "two days or less," with the fees and storage rates in Walmart Fulfillment Services; Walmart says WFS rates "cost 15% less than other marketplace fulfillment providers." Its Multichannel Solutions ship other channels' orders from the same stock.

Pro Seller. Walmart's badge program has three tiers (Rising, Advanced, Pro), open to sellers with "More than 100 orders in the past 90 days," "Active for at least 90 days" and in compliance with its policies. Pro requires on-time delivery of 95% or more, cancellations of 1.5% or less, responsiveness of 95%, a shipping speed score of 50%, a content quality score of 75% and a price competitiveness score of 75%; Advanced and Rising relax on-time delivery to 92.5% and 90% and cancellations to 2.0% and 2.5%.

Money and APIs. "Settlement cycles occur bi-weekly on alternate Fridays," and "All Marketplace orders are eligible for payment holds seven or more days after the order has been shipped or delivered." The Marketplace APIs cover "items, inventory, orders, pricing, promotions, reporting, and other operational workflows," authenticated with OAuth 2.0 client credentials whose tokens last 15 minutes; item setup is by feed against Walmart's item spec (Multichannel Listing & Feeds).

eBay#

eBay is an open marketplace of individuals and businesses, new and used, auction and fixed price, where 51% of 2025's "nearly $80 billion in GMV" was generated outside the United States. Its 10-K names its focus categories as "motor vehicles parts and accessories, collectibles, refurbished items, apparel," which is why brands use it for refurbished, open-box and returned stock that can't be sold as new on other channels.

Fees. The final value fee in most categories is "13.6% on total amount of the sale up to $7,500 calculated per item" plus "2.35% on the portion of the sale over $7,500," and a per-order fee of $0.30 on orders of $10.00 or less and $0.40 above. Categories differ: 15.3% for books, movies and music; 15% up to $2,000 then 9% for women's bags and handbags; 15% up to $5,000 then 9% for jewelry and watches; 13.25% for trading cards and coins; 8% with no per-order fee for athletic shoes at $150 or more. The first 250 listings a month are free, then $0.35 each.

Stores. A Store subscription lowers fees and raises free listings:

Store Monthly (billed monthly / yearly) Free listings Final value fee, most categories
Starter $7.95 / $4.95 250 13.6% up to $7,500
Basic $27.95 / $21.95 1,000 fixed price 12.7% up to $2,500, then 2.35%
Premium $74.95 / $59.95 10,000 12.7% up to $2,500, then 2.35%
Anchor $349.95 / $299.95 25,000 12.7% up to $2,500, then 2.35%
Enterprise Yearly only, $2,999.95 100,000 12.7% up to $2,500, then 2.35%

Seller levels. eBay evaluates sellers monthly on the 20th as Top Rated, Above Standard or Below Standard, over the last three months for sellers with more than 400 transactions and twelve months otherwise. Above Standard requires a transaction defect rate of 2% or less and no more than 0.3% (or 2) cases closed without seller resolution. Top Rated adds a defect rate of 0.5% or less, late shipments of no more than 3% (or 5), tracking uploaded on 95% of transactions, 90 days of activity and 100 transactions and $1,000 of US sales over twelve months; Top Rated Plus listings (same-day or one-business-day handling and free returns for 30 days or longer) earn "10% off final value fees."

Buyer protection and APIs. The eBay Money Back Guarantee "covers your purchase price plus original shipping on eligible purchases," with eBay stepping in if the seller hasn't resolved a problem "after three business days." The Inventory API is "used to create and manage inventory item records" and to "convert these inventory items into product offers on eBay marketplaces," with separate Sell APIs for fulfillment, finances and marketing.

Etsy#

Etsy restricts what may be sold rather than who sells it. Its creativity standards allow items the seller made or designed, curated vintage and items from nature, and craft and party supplies; mass-produced resale is not allowed.

Fees. A listing costs "$0.20 USD per listing"; "Etsy charges 6.5% of the total order amount" as a transaction fee; US payment processing is 3% + $0.25 "in addition to the 6.5% transaction fee"; and Offsite Ads charge 15% (12% above $10,000 a year) on orders they're credited with, capped at $100 (Marketplace Ads Elsewhere). Etsy's 2025 take rate, revenue over GMS, was 24.2%, up from 22.3% in 2024, because services (ads, shipping labels, subscriptions) grew faster than the commission.

Star Seller. Etsy's recognition program asks sellers to "Reply to 95% of first messages in a thread within 24 hours," ship "95% of orders ship on time, with valid tracking or a shipping label purchased on Etsy (when required)," and hold a 4.8 rating or better. The floor every seller must meet is lower: 80% of messages answered within 24 to 48 hours, "At least 80% of orders ship on time," and a case rate under 1% (or three cases for shops under 300 orders).

Scale and API. The Etsy marketplace had $10,460.7 million of GMS, "86.5 million active buyers and 5.6 million active sellers" in 2025; Etsy sold Reverb on June 2, 2025 and agreed on February 15, 2026 to sell Depop to eBay "for $1.2 billion in cash." Its Open API v3 is "a REST API that extends support for inventory, sales orders, and shop management," and "Applications that access private member data must use OAuth authentication." Etsy's sellers are mostly individuals and very small businesses, which makes it a goods marketplace with the payee, tax-reporting and protection questions of the peer-to-peer platforms (Who the Payee Is).

TikTok Shop#

TikTok Shop is a marketplace inside a video feed. As a seller channel it has the usual parts, and the User-Generated Platforms volume covers what is distinctive (shoppable videos, live selling, affiliate creators and their commissions) in Social Commerce & Live Shopping. The seller-side summary, as of October 2026:

  • Who may sell. The US terms cover "residents of and entities based in the United States of America and for cross-border sellers based in Japan," sellers must be 18 or older, and registration requires a US passport, driver's license, state ID or Permanent Resident Card ("all other types of ID verification will be rejected"), the last four digits of the authorized person's SSN or ITIN, and EIN proof for a business. The seller terms name TT Commerce & Global Services as the contracting entity; TikTok's US app itself is now run by the TikTok USDS Joint Venture.
  • Fees. A referral fee of 6% in most categories (5% for fine jewelry and pre-owned goods), calculated on the customer's payment plus any platform discount, less tax, including the shipping the customer paid (Referral Fees and Commissions). Affiliate commissions are the seller's to set, from 1% to 80%.
  • Fulfillment. Fulfilled by TikTok is "in-house service that handles storage, packing, and shipping" with "60 days of free storage" and a "3-day shipping service that covers over 80% of U.S orders." Seller-shipped orders must be marked In Transit within two business days, "Starting January 26, 2026," and a late dispatch rate above 10% brings enforcement (Dispatch and Delivery Clocks).
  • Payouts. Settlement runs from delivery, 31 days for introductory sellers down to 8, 5 or 1 day by Shop Performance Score tier (Settlement Tiers and Reserves).

Retailers' Curated Marketplaces#

Big-box retailers run marketplaces to extend the assortment online without buying the inventory, and they keep them selective because the retailer's name is on every order.

Target Plus is "invite-only," a "curated and carefully selected third-party marketplace" that "since its debut in 2019" has selected and vetted "more than 1,200 partners," adds "dozens of new, hand-picked brands" at a time, and since 2024 accepts applications from Shopify merchants through Shopify's Marketplace Connect. Target has said it wants to grow third-party digital sales "from approximately $1 billion in 2024 to more than $5 billion in 2030." Target doesn't publish Target Plus fees or partner standards.

Best Buy Marketplace launched in the US on August 19, 2025, "powered by Mirakl," "more than doubling our total assortment and tripling it in some areas," in categories such as seasonal décor, automotive tech, movies and music. "Customers can return products purchased through a Marketplace seller at their local Best Buy store." Best Buy's 10-K describes "new commission and advertising revenue, without requiring inventory investment" and plans to "continue to expand our third-party seller count"; its Canadian marketplace dates from 2016, with sellers "thoroughly vetted and approved by Best Buy." Its public Marketplace Program Policies set a "Platform Fee: $29.99/month" and a commission at the category's rate on the total price, with the rates themselves in the seller portal (a summary table on the Seller Hub "is for reference only"); sellers must confirm shipment within 3 business days or the order may be cancelled, and "you may not exceed a 3% seller-initiated cancellation rate."

Mirakl's platform sits under many of these: Lowe's partnered with Mirakl for its marketplace (with returns at "any of Lowe's over 1,700 stores"), and Kroger Ship announced a Mirakl-powered marketplace in 2020. The retailer's side of that software, seller onboarding and commission rules, is Running Your Own Marketplace. For the seller, a curated marketplace often connects through Mirakl's seller API or a feed tool rather than a bespoke integration (Multichannel Listing & Feeds).

Mercado Libre#

Mercado Libre is the marketplace of Latin America: its "e-commerce platform is present in 18 countries," Brazil, Argentina and Mexico produced 95.6% of its 2025 net revenues and financial income, and its fintech arm, Mercado Pago, "processes and settles all transactions on our Marketplace" where it operates. Third-party sellers "account for most of the GMV," with first-party sales "less than 10% of GMV." In 2025 it reported $65,037 million of GMV, 121 million unique active buyers and 2,429 million items sold, and its fulfillment centers handle "more than half of shipments"; in Mexico, "fulfillment penetration reached a record high of nearly 80% in Q4'25."

Sellers choose a listing type per item (Classic and Premium in Brazil and Mexico), which sets the commission by category, with a fixed per-unit cost on low-priced items; the commission tables are on help pages I couldn't open for this edition.

For a US brand, Mercado Libre is a cross-border decision as much as a marketplace one: local tax registration or a cross-border program, local-currency pricing and import duties (Cross-Border Commerce).

Temu, Shein and the Managed Model#

Temu and Shein grew by shipping individual parcels from China under the US de minimis exemption, and both have been changing their seller models as that door closed.

  • Temu, launched "in September 2022" by PDD Holdings, "empowers merchants with value-added services." Its original model is often described as fully managed: suppliers consign goods, and Temu sets the retail price and handles logistics; in 2024 it added a semi-managed model in which sellers hold stock in the destination country and fulfill orders themselves. Those two descriptions come from secondary sources; PDD's annual report doesn't name the models. Temu's own release says it "launched its Local Seller Program in the U.S. in 2024," which "enables businesses of all sizes to sell and ship locally," with "no registration fees," and is "now active in more than 35 markets."
  • Shein launched a "global, integrated, fashion and lifestyle marketplace ("SHEIN Marketplace")" in 2023, beside its own on-demand fashion business, with incentives including "no platform fees and limited period waivers of commissions."
  • De minimis. "Effective May 2, 2025, this exemption ceased to apply for imports from China and Hong Kong," and "Effective August 29, 2025, this exemption was eliminated for imports from all countries," as PDD's 20-F records; CBP reported collecting "over $1 billion in duties" on "over 246 million low-cost shipments" by December 2025. PDD expected higher prices and "reduced order volumes." That shift is what pushes both companies toward local sellers and local stock (Customs Entry and Duties).
  • The EU. The European Commission designated Shein (April 26, 2024) and Temu (May 31, 2024) as Very Large Online Platforms under the Digital Services Act, fined Temu "€200 million" on May 28, 2026 for failing "to diligently identify, analyse, and assess the systemic risks" of illegal products, and opened formal proceedings against Shein on February 17, 2026 over "sale of illegal products," "addictive design" and the "transparency of the recommender systems."

The managed model is the inverse of a marketplace: like a 1P retailer, the platform sets the price and runs logistics, but like a marketplace it never takes the goods into a retail balance sheet in the usual way. For the brand or factory it's a wholesale relationship with a very demanding buyer; for the software it's purchase orders and inbound shipments, not listings and settlements.

Supplier Models That Look Like Marketplaces#

Some sites sell many brands' goods without being marketplaces at all. Wayfair is the clearest: a supplier's "base cost is the starting price at which you sell your products to Wayfair," Wayfair "sets the retail price on-site," "Drop-shipping is Wayfair's primary method of fulfillment" (with its CastleGate warehouses as the alternative), and Wayfair pays shipping on its own carrier accounts. To the supplier, that is drop-ship wholesale: Wayfair is the merchant of record, the supplier's order is a purchase order, and its records are a retailer's, with routing, ship notices and invoices (Business Models & Unit Economics; Retailer Drop-Ship Programs and EDI). The test for any new channel is the same: who sets the price, who is the merchant of record, and who pays whom. The answer decides whether the channel is a row in listings or in the wholesale tables.

Performance Standards Compared#

Every marketplace measures sellers on the same handful of things with different thresholds, windows and consequences. As of October 2026, for seller-fulfilled orders:

Measure Amazon Walmart eBay (Top Rated) Etsy (floor) TikTok Shop
Defects or negative feedback Order Defect Rate under 1% over 60 days Negative feedback 2% or less over 60 days Transaction defect rate 0.5% or less Case rate under 1% Shop Performance Score
Cancellations Under 2.5% over 7 days 2% or less Counted as defects 2.5% or less, seller fault
Late shipment Under 4% over 10 and 30 days 5% or less 3% or less (or 5) 80% shipped on time Late dispatch enforcement above 10%
Valid tracking Above 95% over 30 days 99% or more Tracking on 95% Valid tracking for Star Seller 95% or more
On-time delivery Tracked, no deactivation threshold 90% or more 80% or more
Response to buyers 48 hours on A-to-z claims 95% within 48 hours 80% within 24 to 48 hours
Other Return dissatisfaction under 10% Return rate 6% or less; item not received 2% or less Cases closed without resolution 0.3% or less Rating 4.8 or better for Star Seller

Walmart evaluates over "the last 30 days or 60 days," and missing its standards may lead to suppression, suspension or termination; eBay evaluates monthly; TikTok's late dispatch rule counts business days excluding weekends and federal holidays. The cells say the same thing differently, which is the modeling point: each standard is a metric definition (numerator, denominator, which date, which orders excluded), a threshold, a window and a consequence, stored per channel with a validity range, and the system computes its own estimate of each and compares it with what the channel reports (Account Health, Seller Performance Scores).

Payouts Compared#

Marketplace When the seller is paid
Amazon Settlements "every two weeks," with proceeds held until seven days after delivery
Walmart Bi-weekly "on alternate Fridays," with orders eligible for payment holds seven or more days after shipment or delivery
TikTok Shop 1 to 31 days after delivery by settlement tier, with reserves for some shops

Every one of these pays from delivery rather than from the sale, holds reserves at its discretion and nets fees, refunds and adjustments before paying, which makes them rolling reserves in the Payments volume's sense (eBay's and Etsy's payout pages weren't readable for this edition) (Payout Schedules, Holds and Reserves). The seller's cash forecast is a function of delivery dates and each channel's rule, and the settlement import is the same job everywhere: lines to orders, fees to expected fees, the total to the deposit (Settlements and the Money).

How to Build It#

Every marketplace is a sales_channels row; the seller's account on it is a connected_systems row; each item offered is a listings row. What differs per marketplace is data with dates: the fee schedule, the listing requirements and the performance standards. This chapter adds those three:

ALTER TABLE sales_channels DROP CONSTRAINT sales_channels_kind_check;
-- NOT VALID: new rows checked now; validate after any backfill, without blocking writes
ALTER TABLE sales_channels ADD CONSTRAINT sales_channels_kind_check CHECK (kind IN
  ('marketplace', 'first_party', 'pos', 'phone', 'kiosk', 'wholesale', 'drop_ship')) NOT VALID;
ALTER TABLE sales_channels
  ADD COLUMN merchant_of_record TEXT NOT NULL DEFAULT 'marketplace',  -- Wayfair is 'retailer'
  ADD COLUMN price_set_by       TEXT NOT NULL DEFAULT 'merchant',     -- Temu managed, Wayfair, 1P
  ADD COLUMN access             TEXT NOT NULL DEFAULT 'open',
  ADD COLUMN payout_rule        JSONB NOT NULL DEFAULT '{}',  -- e.g. {"from": "delivery", "days": 7}
  ADD CONSTRAINT sales_channels_merchant_of_record_check
    CHECK (merchant_of_record IN ('merchant', 'marketplace', 'retailer')) NOT VALID,
  ADD CONSTRAINT sales_channels_price_set_by_check
    CHECK (price_set_by IN ('merchant', 'channel')) NOT VALID,
  ADD CONSTRAINT sales_channels_access_check
    CHECK (access IN ('open', 'approval', 'invitation')) NOT VALID;

CREATE TABLE marketplace_fee_schedules (  -- every fee a channel charges, versioned
  id            UUID PRIMARY KEY DEFAULT uuidv7(),
  channel_id    TEXT NOT NULL REFERENCES sales_channels (id),
  fee_kind      TEXT NOT NULL CHECK (fee_kind IN ('referral', 'final_value', 'transaction',
                  'per_order', 'listing', 'processing', 'subscription', 'closing',
                  'advertising', 'fulfillment', 'storage')),
  plan          TEXT NOT NULL DEFAULT '',  -- e.g. eBay 'store_basic'; '' = no plan
  category      TEXT NOT NULL DEFAULT '',  -- the channel's fee category; '' = default
  base          TEXT[] NOT NULL,           -- line kinds in the base: '{item,shipping}'
  shape         TEXT NOT NULL CHECK (shape IN ('flat', 'whole_price', 'marginal')),
  from_amount   BIGINT NOT NULL DEFAULT 0, -- band lower bound, minor units
  rate_bp       INT,                       -- basis points
  fixed_amount  BIGINT,                    -- per item, order, listing or month
  min_amount    BIGINT,
  max_amount    BIGINT,                    -- e.g. Etsy Offsite Ads $100 cap
  currency      CHAR(3) NOT NULL,
  source_url    TEXT NOT NULL,             -- the page the row was read from
  valid_during  TSTZRANGE NOT NULL,
  EXCLUDE USING GIST (channel_id WITH =, fee_kind WITH =, plan WITH =, category WITH =,
                      from_amount WITH =, valid_during WITH &&)
);

CREATE TABLE listing_requirements (       -- what a channel needs before an item can list
  id             UUID PRIMARY KEY DEFAULT uuidv7(),
  channel_id     TEXT NOT NULL REFERENCES sales_channels (id),
  scope          TEXT NOT NULL CHECK (scope IN ('account', 'category', 'brand', 'item')),
  category       TEXT,                     -- the channel's category, for category scope
  requirement    TEXT NOT NULL,            -- 'approval', 'gtin', 'brand_authorization',
                                           -- 'safety_document', 'business_tax_id', ...
  detail         JSONB NOT NULL DEFAULT '{}',
  valid_during   TSTZRANGE NOT NULL
);

CREATE TABLE channel_approvals (          -- a requirement met, by this merchant, with evidence
  connected_system_id UUID NOT NULL REFERENCES connected_systems (id),
  requirement_id      UUID NOT NULL REFERENCES listing_requirements (id),
  status              TEXT NOT NULL CHECK (status IN ('requested', 'approved', 'rejected',
                        'revoked')),
  evidence_document_id UUID REFERENCES documents (id),  -- invoices, certificates, letters
  decided_at          TIMESTAMPTZ,
  PRIMARY KEY (connected_system_id, requirement_id)
);

CREATE TABLE performance_standards (      -- each channel metric as the channel defines it
  channel_id     TEXT NOT NULL REFERENCES sales_channels (id),
  metric         TEXT NOT NULL,            -- 'defect_rate', 'cancel_rate', 'late_ship_rate', ...
  definition     TEXT NOT NULL,            -- numerator, denominator, date basis, exclusions
  comparator     TEXT NOT NULL CHECK (comparator IN ('lt', 'lte', 'gt', 'gte')),
  threshold_bp   INT NOT NULL,
  window_days    SMALLINT NOT NULL,
  consequence    TEXT NOT NULL,            -- 'suppression', 'deactivation', 'badge', 'none'
  program        TEXT NOT NULL DEFAULT '', -- '' = baseline; 'pro_seller', 'top_rated', 'star_seller'
  valid_during   TSTZRANGE NOT NULL,
  PRIMARY KEY (channel_id, metric, program, valid_during)
);

A fee estimate for an order is then a query over the schedule in force when it was placed, for the order's lines:

-- Expected marketplace fees for one order line, from the schedule in force at the sale.
SELECT f.fee_kind,
       CASE f.shape
         WHEN 'flat' THEN f.fixed_amount
         WHEN 'whole_price' THEN GREATEST(COALESCE(f.min_amount, 0),
              (b.base_amount * f.rate_bp) / 10000)
         WHEN 'marginal' THEN (GREATEST(b.base_amount - f.from_amount, 0)
              * f.rate_bp) / 10000      -- summed across bands by the caller
       END AS expected_fee
FROM order_lines l
JOIN orders o ON o.id = l.order_id
CROSS JOIN LATERAL (SELECT l.amount + COALESCE((SELECT SUM(c.amount) FROM order_charges c
                     WHERE c.order_line_id = l.id AND c.kind = 'shipping_fee'
                       AND c.payer = 'customer'), 0) AS base_amount) b
JOIN marketplace_fee_schedules f
  ON f.channel_id = o.channel_partner
 AND f.valid_during @> o.placed_at
 AND f.category = :fee_category
WHERE l.id = :order_line_id;

Design notes:

  • Every rule row cites its page. source_url and the validity range are what let a person check the schedule against the marketplace's page when a settlement disagrees, and what makes a fee change a new row instead of an edit (Effective Dates and Versions).
  • Bases are line kinds. TikTok's base adds back platform discounts, eBay's and Amazon's include shipping, Whatnot's excludes it; storing the base as the list of line kinds it sums keeps one engine for all of them.
  • Requirements are checked before listing. A listing job reads listing_requirements and channel_approvals and refuses to submit an item to a gated category the account isn't approved for; the channel's rejection is a backstop, not the check.
  • Standards are definitions, not numbers. The metric's definition and window are stored with its threshold, and the system's own computation of it is recorded beside the channel's reported value (Seller Performance Scores).
  • The channel row says who sets the price and who is merchant of record. That one pair decides whether an order from the channel produces a settlement (marketplace) or an invoice and a payment on terms (retailer or managed model).

Auditing#

  • Every fee schedule version, with the page it was read from and the date it took effect, and every settlement variance it explained.
  • Every approval, for an account, category or brand, with the evidence submitted and the decision.
  • Every standard and every evaluation: the channel's reported metric with its window, the system's own computation, and any consequence (a lost badge, a suppression, a hold).
  • Every price change that crossed a channel's pricing rule, such as a Walmart unpublish for an unreasonable price, with the prices elsewhere at the time.

What This Means for the System You Build#

  • Make each marketplace a channel row with its merchant of record, price setter, access type and payout rule, so a new marketplace is configuration.
  • Store fee schedules as dated rows with their shape (flat, whole-price band, marginal band), base and source, and compute expected fees per order line.
  • Check gating and requirements before submitting a listing, and keep approvals with their evidence.
  • Model performance standards as definitions with windows and thresholds, compute them yourself and compare with each channel's number.
  • Know each channel's pricing rules before moving a price anywhere, because a price on one channel can unpublish an offer on another.
  • Treat managed and supplier models as wholesale, with purchase orders and invoices, not listings and settlements.
  • Forecast cash from delivery dates and each channel's payout rule.

References#

Walmart Marketplace

eBay

Etsy

TikTok Shop

Retailers' marketplaces

Mercado Libre, Temu and Shein