xmkt_pricing_compare
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 | ||
| fulfillment_in | No | Comma-separated FBA/FBM/AMZ to keep. | |
| marketplace_id | No | Amazon-side marketplace for the comparison (Walmart US is always the other side). 1 = Amazon UK, 2 = Amazon US (default), 4 = Amazon CA, 5 = Amazon AU, 6 = Amazon DE, 7 = Amazon JP, 8 = Amazon IT, 9 = Amazon FR, 10 = Amazon ES, 11 = Amazon MX, 12 = Amazon BR | |
| max_amazon_price | No | ||
| min_amazon_price | No | ||
| max_walmart_price | No | ||
| min_walmart_price | No | ||
| max_match_confidence | No | ||
| min_match_confidence | No | Only matched pairs with Amazon<->Walmart match confidence >= this. | |
| product_title_contains | No | ||
| max_delta_pct_amz_vs_wmt | No | ||
| max_est_arbitrage_profit | No | ||
| min_delta_pct_amz_vs_wmt | No | Only pairs whose Amazon-vs-Walmart price delta percentage is >= this. | |
| min_est_arbitrage_profit | No |