Walmart Product API

{
  "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
        }
      ]
    }
  }
}