Marketplace Fee Ingestion

Why ingest fees at all

Every marketplace charges different fees—referral, FBA storage, payment processing, dispute fees, ad spend allocations, currency conversion. If you only count item revenue minus item cost, you'll think margins look great and then wonder why your bank balance disagrees. ShipWave pulls real fee data from each connected channel and assigns each fee to the specific order it relates to, so the profitability dashboard reflects actual take-home, not gross revenue.

Amazon (SP-API listFinancialEvents)

For each Amazon channel, ShipWave calls the Selling Partner API listFinancialEvents endpoint on a 12-hour cron. The endpoint returns shipment events, refund events, FBA fee adjustments, ad-spend allocations, and storage fees. Each event has an Amazon order ID, which ShipWave matches to the corresponding ShipWave order. Fees are categorized (referral, FBA fulfillment, storage, ads, other) and stored per order. Order-level fees show up immediately in profitability; channel-level fees (e.g. monthly storage) are amortized across orders in that period.

Shopify Payments

Shopify Payments fees come in via the standard Shopify Orders API webhook plus a daily reconciliation cron that pulls the transactions array for each order. Each transaction has a fee field showing the processing fee deducted by Shopify Payments. ShipWave stores this against the order. If you use a third-party processor on Shopify, you'll need to record those fees manually or via the CSV importer.

eBay (Finances API) and Walmart (settlement TSV)

eBay fees come from the eBay Finances API, polled every 12 hours. Each transaction has a fee detail breakdown (final value fee, payment processing, store-subscription allocations, ads). Walmart doesn't expose a clean API for fees, so ShipWave parses the daily settlement TSV report from Walmart's seller portal. The TSV is downloaded by the same cron, parsed, and matched to orders by Walmart order number. Settlement files appear 5-7 days after the order ships, so Walmart profitability has a lag.

Per-channel sync status and idempotency

Go to Admin → Marketplaces → [channel] → Fee sync to see the last successful run, the number of fee events ingested, and any errors. Every fee event has an idempotency key (channel-event-id) so re-running the cron never double-counts. If you backfill a date range, ShipWave skips any event it has already stored.

FAQs

What if a marketplace channel isn't connected yet?

You can manually upload a CSV of fees via Admin -> Marketplaces -> Manual fees. Use the template export to get the right columns.

How are FBA storage fees allocated?

Storage fees are monthly aggregates with no order-level granularity. ShipWave amortizes them across all FBA-shipped orders in that month, weighted by units shipped, before applying to per-order profitability.

Why is Walmart profitability lagged?

Walmart only exposes fees in the settlement file, which posts 5-7 days after the order ships. Until the settlement arrives, ShipWave shows estimated fees based on Walmart's public fee schedule.

Do refund / chargeback fees flow in?

Yes. Refunds reduce revenue and create a separate FEE_REFUND or CHARGEBACK_FEE record on the order, so dispute losses show up in the dashboard correctly. See <a href="/help/profitability-dashboard">Profitability dashboard</a>.