Walmart Product API

/search?engine=walmart_product API endpoint allows you to scrape the results from the Walmart product pages via our SerpApi service. Head to the playground for a live and interactive demo.

API Parameters

Search Query

product_id

Required

Parameter defines the product to get results for. Normally found from shopping results for supported products (e.g., https://www.walmart.com/ip/{product_id}). You can pass upc, product_id and us_item_id. Better to use us_item_id. Response for product_id returns faster because of lack of redirects on Walmart.com

Serpapi Parameters

engine

Required

Set parameter to walmart_product to use the Walmart Product API engine.

device

Optional

Parameter defines the device to use to get the results. It can be set to desktop (default) to use a regular browser, tablet to use a tablet browser (currently using iPads), or mobile to use a mobile browser (currently using iPhones).

no_cache

Optional

Parameter will force SerpApi to fetch the Walmart Product results even if a cached version is already present. A cache is served only if the query and all parameters are exactly the same. Cache expires after 1h. Cached searches are free, and are not counted towards your searches per month. It can be set to false (default) to allow results from the cache, or true to disallow results from the cache. no_cache and async parameters should not be used together.

async

Optional

Parameter defines the way you want to submit your search to SerpApi. It can be set to false (default) to open an HTTP connection and keep it open until you got your search results, or true to just submit your search to SerpApi and retrieve them later. In this case, you'll need to use our Searches Archive API to retrieve your results. async and no_cache parameters should not be used together. async should not be used on accounts with Ludicrous Speed enabled.

api_key

Required

Parameter defines the SerpApi private key to use.

output

Optional

Parameter defines the final output you want. It can be set to json (default) to get a structured JSON of the results, or html to get the raw html retrieved.

API Results

JSON Results

JSON output includes structured data for product result and reviews results.

A search status is accessible through search_metadata.status. It flows this way: Processing -> Success || Error. If a search has failed, error will contain an error message. search_metadata.id is the search ID inside SerpApi.

HTML Results

HTML output is useful to debug JSON results or support features not supported yet by SerpApi.
HTML output gives you the raw HTML results from Walmart.

Example results for  product_id: 743876032

Example results for  product_id: 743876032

JSON Example

{
  "search_metadata": {
    "id": "6144a56194c6c70a61d9a3e6",
    "status": "Success",
    "json_endpoint": "https://serpapi.com/searches/b5ef7d304ecd27db/6144a56194c6c70a61d9a3e6.json",
    "created_at": "2021-09-17 14:25:37 UTC",
    "processed_at": "2021-09-17 14:25:38 UTC",
    "walmart_product_url": "https://www.walmart.com/ip/743876032?selected=true",
    "raw_html_file": "https://serpapi.com/searches/b5ef7d304ecd27db/6144a56194c6c70a61d9a3e6.html",
    "total_time_taken": 2.98
  },
  "search_parameters": {
    "product_id": "743876032",
    "engine": "walmart_product",
    "device": "desktop"
  },
  "product_result": {
    "us_item_id": "743876032",
    "product_id": "5P9P29FD1RUP",
    "title": "(2 Pack) Maxwell House Original Roast Medium Ground Coffee, Caffeinated, 42.5 oz Canister",
    "short_description_html": "Maxwell House Original Roast Ground Coffee has a consistent signature taste that is good to the last drop. This rich and classic original roast coffee is exceptionally smooth and aromatic and is the perfect start to your day. Made with 100% pure coffee, this medium roast coffee is great served black or with cream and sugar. Brew a pot of this Kosher coffee in any drip coffee maker. The 42.5 ounce resealable can of ground coffee maintains flavor in between uses. From lively light roasts to full bodied dark blends, Maxwell Houses signature taste is created through a process that isnt done the easy way, but the right way, for 125 years.",
    "detailed_description_html": "<ul>  <li>Two 42.5 oz. can of Maxwell House Original Roast Ground Coffee</li>  <li>Maxwell House Original Roast Ground Coffee has a consistently great taste</li>  <li>Medium original roast coffee has an classic, robust flavor</li>  <li>Great served black or with cream and sugar</li>  <li>Perfect for use in automatic drip brewers</li>  <li>Packaged in a resealable canister of ground coffee to lock in flavor</li>  <li>Certified Kosher ground coffee</li> </ul>",
    "categories": [
      {
        "name": "Food",
        "url": "https://www.walmart.com/cp/976759"
      },
      {
        "name": "Coffee",
        "url": "https://www.walmart.com/cp/1086446"
      },
      {
        "name": "Ground Coffee",
        "url": "https://www.walmart.com/cp/1229651"
      }
    ],
    "specification_highlights": [
      {
        "key": "Brand",
        "value": "Maxwell House",
        "display_name": "Brand"
      },
      {
        "key": "Manufacturer",
        "value": "Kraft Heinz Foods Company",
        "display_name": "Manufacturer"
      }
    ],
    "product_type_id": "ib_ground_coffee",
    "product_type": "Ground Coffee",
    "manufacturer": "Maxwell House",
    "product_page_url": "https://www.walmart.com/ip/2-Pack-Maxwell-House-Original-Roast-Medium-Ground-Coffee-Caffeinated-42-5-oz-Canister/743876032",
    "min_quantity": 1,
    "max_quantity": 12,
    "in_stock": false,
    "images": [
      "https://i5.walmartimages.com/asr/281b1114-bb8b-4d16-8bfb-b7e614658cc7_3.b905cd34151077568be3d62233b4cd2b.jpeg",
      "https://i5.walmartimages.com/asr/ba6a6adb-c497-4875-bcea-602cf8cb9c00_3.a17e9825f037e79c308dc42a85ed34b3.jpeg",
      "https://i5.walmartimages.com/asr/d329be88-4314-40df-b7e8-8f2d73c83303_2.3da17f4b2e87fea5e3e5d7e386babb7f.jpeg",
      "https://i5.walmartimages.com/asr/d9841546-1c02-4ac9-b3ee-bc6b5d9a4614_2.d6fc646af7b8bfcfe5215a242fac34c1.jpeg",
      "https://i5.walmartimages.com/asr/e21494d0-150c-49eb-ae54-32a899bfacae_2.3a6388a6298aa5cd3283aa2587ae4c8b.jpeg",
      "https://i5.walmartimages.com/asr/b8622745-b680-42f8-a469-31606db96e5a_1.44b5c44670043efacc6156b206e8c381.jpeg",
      "https://i5.walmartimages.com/asr/d5bef6d5-8f69-4581-8320-930ee7952d40_2.0960bed964e981149e2953c4babd7e71.jpeg",
      "https://i5.walmartimages.com/asr/bbd421ee-110a-4c00-910a-37d55805c8e4_2.e84d09e144334231639a7aa291ba3c20.jpeg"
    ],
    "reviews": 1157,
    "rating": 4.7986,
    "offers": [
      {}
    ]
  },
  "reviews_results": {
    "ratings": [
      {
        "stars": 1,
        "count": 20
      },
      {
        "stars": 2,
        "count": 5
      },
      {
        "stars": 3,
        "count": 22
      },
      {
        "stars": 4,
        "count": 94
      },
      {
        "stars": 5,
        "count": 1016
      }
    ],
    "reviews": {
      "rating": 4.8,
      "count": 1157,
      "top_positive": {
        "title": "awesome coffee....BEST ON EARTH",
        "text": "best ever TASTE.....QUALITY.....SELECTION....PRICE.....FLAVOR....SMELL....TEXTURE......AND MAKES THE BEST FOR GUEST.....NEVER A COMPLAINT.....BEATS THE BRANDS I HAVE BOUGHT BEFORE.....FIRST TIME ORDERING THIS AND IM A NEW MAXWELL HOUSE LOVER FOR LIFE....
DOES NOT TAKE ALOT OF GROUNDS FOR A 12 CUP POT LIKE ALL MY OTHER GROUND COFFEE BRANDS....AND IT LAST LONGER ON THE BUDGET....THE SHIPPING IS SUPER SUPER FAST....
AND I RECOMMEND TO EVERYONE ...YOU WONT GO WRONG...
AND THE REUSABLE COFFEE CONTAINER IS AWESOME.....I USE IT TO STORE MY OLD COFFEE GROUNDS ...THEN USE THEM IN PLANTS SOIL AND FOR MY PLANT FOOD ...
SO I JUST LOVE THIS PRODUCT ALL THE WAY AROUND",
        "rating": 5,
        "positive_feedback": 0,
        "negative_feedback": 0,
        "review_submission_time": "4/2/2021"
      },
      "top_negative": {
        "title": "Gets stale quickly",
        "text": "Gets stale very quickly.  Has burnt smell and taste",
        "rating": 1,
        "positive_feedback": 0,
        "negative_feedback": 0,
        "review_submission_time": "4/13/2021"
      },
      "customer_reviews": [
        {
          "title": "awesome coffee....BEST ON EARTH",
          "text": "best ever TASTE.....QUALITY.....SELECTION....PRICE.....FLAVOR....SMELL....TEXTURE......AND MAKES THE BEST FOR GUEST.....NEVER A COMPLAINT.....BEATS THE BRANDS I HAVE BOUGHT BEFORE.....FIRST TIME ORDERING THIS AND IM A NEW MAXWELL HOUSE LOVER FOR LIFE....
DOES NOT TAKE ALOT OF GROUNDS FOR A 12 CUP POT LIKE ALL MY OTHER GROUND COFFEE BRANDS....AND IT LAST LONGER ON THE BUDGET....THE SHIPPING IS SUPER SUPER FAST....
AND I RECOMMEND TO EVERYONE ...YOU WONT GO WRONG...
AND THE REUSABLE COFFEE CONTAINER IS AWESOME.....I USE IT TO STORE MY OLD COFFEE GROUNDS ...THEN USE THEM IN PLANTS SOIL AND FOR MY PLANT FOOD ...
SO I JUST LOVE THIS PRODUCT ALL THE WAY AROUND",
          "rating": 5
        },
        {
          "title": "I guess I'm just",
          "text": "I guess I'm just old school and get it from my parents. I am so loving the original roast medium Maxwell house coffee. this is what my parents always drank in the morning nad I loved waking up to the smell of it when I was little. it brings back memories when I brew a fresh pot every morning.",
          "rating": 5
        },
        {
          "title": "HAPPY customer...",
          "text": "Been with Walmart many years.. fantastic service..I don't shop anywhere else..Walmart has everything I need i am old and can't drive anymore...thanks Walmart for always being there for me..GOd bless u all..stay safe",
          "rating": 5
        },
        {
          "title": "Good to the last drop",
          "text": "This has always been my coffee of choose.  If there out I will get folgers but I always, always go back to Maxwell  House. To me it is just to best brewed coffee on shelves there is.",
          "rating": 5
        },
        {
          "title": "Good.",
          "text": "My family's favorite coffee. But getting it from Costco is most likely a better deal.  Otherwise the price here is way better than food shopping stores.",
          "rating": 5
        },
        {
          "title": "Excellent delivery  and  prices.",
          "text": "I has to let you know  that this order  has been a pleasure to review.  Everything was deliver on time.  I have many items  in this  order, everything  was well pack, no  spills.  Thank You.",
          "rating": 5
        },
        {
          "title": "Larger containers last longer.",
          "text": "What's to say? Maxwell House is my choice of coffee, and I like the larger containers. Last longer.",
          "rating": 5
        },
        {
          "title": "Favorite coffee",
          "text": "Received in perfect condition and quickly.",
          "rating": 5
        },
        {
          "text": "Good coffee for the price.  I prefer this brand over many of the ground varieties.  The only reason I gave 4 stars and not more is that I  like the grind your own coffee beans best.  I purchase the ground coffee for the convenience  this is good coffee.",
          "rating": 4
        },
        {
          "title": "They delivered it, I like it...but I didn't or i",
          "text": "I was surprised but not offended when my order for sports equipment was accompanied by 42.5 oz of Maxwell house coffee. It IS a brand I drink and they did charge me for it but I never intended to order it.",
          "rating": 4
        }
      ]
    }
  }
}