xmkt_pricing_compare
Compare Amazon and Walmart prices on matched products to find arbitrage opportunities. Check price deltas, profitability, and fulfillment details.
Instructions
Cross-marketplace (Amazon vs Walmart) pricing comparison. Returns matched pairs from mv_product_identity with current Amazon price, current Walmart price, delta %, and a coarse Amazon-FBA profitability check. Each pair also carries the Amazon ASIN's product brand, title and catalog price (or price range) plus fulfillment (FBA/FBM/Amazon). Use for arbitrage / sourcing questions ('cheaper on Walmart?'). Single-ASIN or by-brand.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| asin | No | ||
| brand | No | ||
| marketplace_id | No | Amazon-side marketplace for the comparison (Walmart US is always the other side). 1 = Amazon UK, 2 = Amazon US (default) | |
| min_match_confidence | No | Only matched pairs with Amazon<->Walmart match confidence >= this. | |
| max_match_confidence | No | ||
| min_amazon_price | No | ||
| max_amazon_price | No | ||
| min_walmart_price | No | ||
| max_walmart_price | No | ||
| min_delta_pct_amz_vs_wmt | No | Only pairs whose Amazon-vs-Walmart price delta percentage is >= this. | |
| max_delta_pct_amz_vs_wmt | No | ||
| min_est_arbitrage_profit | No | ||
| max_est_arbitrage_profit | No | ||
| product_title_contains | No | ||
| fulfillment_in | No | Comma-separated FBA/FBM/AMZ to keep. |