Walmart Product Result API

When SerpApi encounters a product result, we add them to our JSON output as the product_result object.

API Examples

Product result overview

Product result overview

JSON Example

{
  ...
  "product_result": {
    "us_item_id": "147423982",
    "product_id": "34Y0BVR8X5ZD",
    "variants": [
      "actual_color-navy",
      "clothing_size-m"
    ],
    "upc": "696777889575",
    "title": "Men's Henley 3-Button Pullover Cotton T-Shirt Long Sleeve Crew Neck",
    "short_description_html": "Men's Long Sleeve Henley 3 Button Pullover Cotton T-Shirt Crew Neck",
    "detailed_description_html": "<ul>  <li>Long Sleeves</li>  <li>Lightweight</li>  <li>100% Cotton</li> </ul>",
    "categories": [
      {
        "name": "Clothing",
        "url": "https://www.walmart.com/cp/5438"
      },
      {
        "name": "Mens Clothing",
        "url": "https://www.walmart.com/cp/133197"
      },
      {
        "name": "Mens T-Shirts & Tank Tops",
        "url": "https://www.walmart.com/cp/4237948"
      },
      ...
    ],
    "seller_id": "B450DDF0F0E543BCA24F386B6CA384D1",
    "seller_name": "Blended",
    "specification_highlights": [
      {
        "key": "Clothing Size",
        "value": "M",
        "display_name": "Clothing Size"
      },
      {
        "key": "Sleeve Length Style",
        "value": "Long Sleeve",
        "display_name": "Sleeve Length Style"
      },
      {
        "key": "Fabric Content",
        "value": "100% Cotton",
        "display_name": "Fabric Content"
      },
      ...
    ],
    "product_type_id": "891",
    "product_type": "T-Shirts",
    "manufacturer": "Blended",
    "product_page_url": "https://www.walmart.com/ip/Men-s-Henley-3-Button-Pullover-Cotton-T-Shirt-Long-Sleeve-Crew-Neck/147423982",
    "price_map": {
      "price": 15.98,
      "was_price": {
        "price": 19.99,
        "priceString": "$19.99",
        "variantPriceString": null,
        "priceType": "BASE",
        "currencyUnit": "USD"
      },
      "currency": "USD"
    },
    "min_quantity": 1,
    "max_quantity": 12,
    "in_stock": true,
    "images": [
      "https://i5.walmartimages.com/asr/caee8569-17c4-477d-b993-74f6e8f1ca03.a24edd08ad59ce67f44712dd2d6b5a99.jpeg",
      "https://i5.walmartimages.com/asr/0f601fd9-4c3d-4681-9943-796f8c9dddcd.d3a7e13b15009e778a760ff31ad24d15.jpeg"
    ],
    "reviews": 27,
    "rating": 4.0741,
    "offer_id": "90623A01F87340ED9C0B789ABC968ABD",
    "offer_type": "ONLINE_ONLY",
    "offers": [
      {
        "seller_id": "B450DDF0F0E543BCA24F386B6CA384D1",
        "catalog_seller_id": 4085,
        "seller_name": "Valley Holdings LLC",
        "seller_display_name": "Blended",
        "price": 15.98
      }
    ],
    "shipping_price": 0,
    "delivery_option": {
      "ship_method": "THREE_TO_FIVE_DAY",
      "arrival_date": 1637006400000,
      "display_arrival_date": "2021-11-15T20:00:00.000Z"
    },
    "shipping_options": [
      {
        "ship_method": "DELIVERY_ADDRESS"
      }
    ],
    "variant_swatches": [
      {
        "name": "Color",
        "available_selections": [
          {
            "id": "actual_color-black",
            "name": "Black",
            "swatch_image_url": "https://i5.walmartimages.com/asr/ea95427d-86eb-41c0-bf9f-9abbacbb4303.1e7130204da3d4dc6de339c4b4f395f5.jpeg",
            "products": [
              {
                "product_id": "7F3I09QOGAEE",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=7F3I09QOGAEE",
                "variants": [
                  "actual_color-black",
                  "clothing_size-l"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "3P607DL0IWDK",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3P607DL0IWDK",
                "variants": [
                  "actual_color-black",
                  "clothing_size-2x"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 17.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "72GHMGNOTX50",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=72GHMGNOTX50",
                "variants": [
                  "actual_color-black",
                  "clothing_size-m"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              ...
            ]
          },
          {
            "id": "actual_color-heathergrey",
            "name": "Heather Grey",
            "swatch_image_url": "https://i5.walmartimages.com/asr/4314936c-c916-4ab8-a623-8f806efa75a3.f212dfaefd347384d886c237fe73f2d3.jpeg",
            "products": [
              {
                "product_id": "7KVV82PLSGBK",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=7KVV82PLSGBK",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-l"
                ],
                "in_stock": false,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "4778TJI9UW7K",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=4778TJI9UW7K",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-s"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 16.48,
                  "currency": "USD",
                  "was_price": {
                    "price": 19.99,
                    "price_string": "$19.99",
                    "currency_unit": "USD"
                  }
                }
              },
              {
                "product_id": "6YSW50J2OU4J",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=6YSW50J2OU4J",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-xl"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              ...
            ]
          },
          {
            "id": "actual_color-navy",
            "name": "Navy",
            "swatch_image_url": "https://i5.walmartimages.com/asr/166c47b2-6634-48da-8fdf-02f1999720dd.9424daf2eb1476946fe7b82a54e1289a.jpeg",
            "products": [
              {
                "product_id": "3RS36T2O9IVO",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3RS36T2O9IVO",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-2x"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 17.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "3RQ40PVH74VM",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3RQ40PVH74VM",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-xl"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "58AQ1KFN5NHG",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=58AQ1KFN5NHG",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-s"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 16.48,
                  "currency": "USD"
                }
              },
              ...
            ]
          },
          ...
        ]
      },
      {
        "name": "Clothing Size",
        "available_selections": [
          {
            "id": "clothing_size-s",
            "name": "S",
            "products": [
              {
                "product_id": "4778TJI9UW7K",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=4778TJI9UW7K",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-s"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 16.48,
                  "currency": "USD",
                  "was_price": {
                    "price": 19.99,
                    "price_string": "$19.99",
                    "currency_unit": "USD"
                  }
                }
              },
              {
                "product_id": "52B1FAX7DS6U",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=52B1FAX7DS6U",
                "variants": [
                  "actual_color-white",
                  "clothing_size-s"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 16.48,
                  "currency": "USD",
                  "was_price": {
                    "price": 19.99,
                    "price_string": "$19.99",
                    "currency_unit": "USD"
                  }
                }
              },
              ...
            ]
          },
          {
            "id": "clothing_size-m",
            "name": "M",
            "products": [
              {
                "product_id": "6ID2I9HH36P1",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=6ID2I9HH36P1",
                "variants": [
                  "actual_color-white",
                  "clothing_size-m"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "72GHMGNOTX50",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=72GHMGNOTX50",
                "variants": [
                  "actual_color-black",
                  "clothing_size-m"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "34Y0BVR8X5ZD",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=34Y0BVR8X5ZD",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-m"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              }
            ]
          },
          {
            "id": "clothing_size-l",
            "name": "L",
            "products": [
              {
                "product_id": "7KVV82PLSGBK",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=7KVV82PLSGBK",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-l"
                ],
                "in_stock": false,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "7F3I09QOGAEE",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=7F3I09QOGAEE",
                "variants": [
                  "actual_color-black",
                  "clothing_size-l"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "5JVMUM2OF66E",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=5JVMUM2OF66E",
                "variants": [
                  "actual_color-white",
                  "clothing_size-l"
                ],
                "in_stock": false,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              ...
            ]
          },
          {
            "id": "clothing_size-xl",
            "name": "XL",
            "products": [
              {
                "product_id": "6YSW50J2OU4J",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=6YSW50J2OU4J",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-xl"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "281WFEHKQZB4",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=281WFEHKQZB4",
                "variants": [
                  "actual_color-white",
                  "clothing_size-xl"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "3RQ40PVH74VM",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3RQ40PVH74VM",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-xl"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 15.98,
                  "currency": "USD"
                }
              }
            ]
          },
          {
            "id": "clothing_size-2x",
            "name": "2X",
            "products": [
              {
                "product_id": "3RS36T2O9IVO",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3RS36T2O9IVO",
                "variants": [
                  "actual_color-navy",
                  "clothing_size-2x"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 17.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "3P607DL0IWDK",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=3P607DL0IWDK",
                "variants": [
                  "actual_color-black",
                  "clothing_size-2x"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 17.98,
                  "currency": "USD"
                }
              },
              {
                "product_id": "1G7PH6HNOC6P",
                "serpapi_link": "https://serpapi.com/search.json?device=desktop&engine=walmart_product&product_id=1G7PH6HNOC6P",
                "variants": [
                  "actual_color-heathergrey",
                  "clothing_size-2x"
                ],
                "in_stock": true,
                "price_map": {
                  "price": 17.98,
                  "currency": "USD"
                }
              }
            ]
          }
        ]
      }
    ],
    "badges": [
      {
        "id": "L1700",
        "key": "REDUCED_PRICE",
        "name": "Reduced price"
      }
    ],
    "early_access_event": false,
    "annual_event": false,
    "walmart_plus_member": false
  },
  "reviews_results": {
    "ratings": [
      {
        "stars": 1,
        "count": 3
      },
      {
        "stars": 2,
        "count": 2
      },
      {
        "stars": 3,
        "count": 1
      },
      {
        "stars": 4,
        "count": 5
      },
      {
        "stars": 5,
        "count": 16
      }
    ],
    "reviews": {
      "rating": 4.1,
      "count": 27,
      "top_positive": {
        "title": "Runs small",
        "text": "For those considering this Henley shirt, I would suggest sizing up one size. Fortunately, I had ordered one larger size than I usually order, and upon trying the shirt on, I was glad that I had done so. This shirt runs one size small. Apart from that, it is a nice shirt, though it is lightweight.",
        "rating": 4,
        "positive_feedback": 0,
        "negative_feedback": 0,
        "review_submission_time": "9/28/2020"
      },
      "top_negative": {
        "title": "DON'T EVEN THINK ABOUT IT!!!! RUN AWAY QUICK!!!!",
        "text": "BUYER BEWARE THIS IS A SUBSTANDARD SHIRT!!!! RUNS WAY TO SMALL, THE QUALITY IS CRAP, AND YOU CAN SEE THRU THE MATERIAL.  THE SLEEVE CUFFS ARE ALMOST AS BIG IN DIAMETER AS THE NECK. RUN AWAY FROM THIS SELLER.",
        "rating": 1,
        "positive_feedback": 0,
        "negative_feedback": 0,
        "review_submission_time": "12/14/2020"
      },
      "customer_reviews": [
        {
          "title": "Best shirt on the market: its 100 percent cotton a",
          "text": "The only shirt design that has a low enough neck! Everyone wants to choke me to death with their crew necks!",
          "rating": 5,
          "review_submission_time": "10/14/2020",
          "user_nickname": "mraccess",
          "customer_type": [
            "VerifiedPurchaser"
          ]
        },
        {
          "title": "Quality",
          "text": "Great price for a quality Henley. Happy customer",
          "rating": 5,
          "review_submission_time": "11/17/2020",
          "user_nickname": "Nahum",
          "customer_type": [
            "VerifiedPurchaser"
          ]
        },
        {
          "text": "Christmas gift and the young man loved it.",
          "rating": 5,
          "review_submission_time": "4/9/2020",
          "user_nickname": "Ma4Grandma10",
          "customer_type": [
            "VerifiedPurchaser"
          ]
        },
        ...
      ]
    }
  }
  ...
}
%>

JSON structure overview

{
  ...
  "product_result": {
    "us_item_id": "String",
    "product_id": "String",
    "variants": "Array",
    "title": "String",
    "short_description_html": "String",
    "detailed_description_html": "String",
    "categories": [
      {
        "name": "String",
        "url": "String"
      }
    ],
    "seller_id": "String",
    "seller_name": "String",
    "product_type_id": "String",
    "product_type": "String",
    "manufacturer": "String",
    "product_page_url": "String",

    "price_map": {
      "unit_price": "Float",
      "unit_of_measure": "String",
      "price": "Float",
      "list_price": "Float",
      "was_price": "Hash",
      "currency": "String"
    },
    "min_quantity": "Integer",
    "max_quantity": "Integer",
    "in_stock": "Boolean",
    "images": "Array",

    "reviews": "Integer",
    "rating": "Float",
    "offer_id": "String",
    "offer_type": "String",
    "shipping_price": "Float",

    "delivery_option": {
      "ship_method": "String",
      "arrival_date": "Datetime",
      "display_arrival_date": "String",
    },
    "pickup_options": [
      {
        "store_id": "String",
        "store_name": "String",
        "availability": "String",
        "pickup_method": "String",
      }
    ],
    "shipping_options": [
      { "ship_method": "String" }
    ],
    "variant_swatches": [
      {
        "name": "String",
        "available_selections": [
          {
            "id": "String",
            "name": "String",
            "swatch_image_url": "String",
            "products": [
              {
                "product_id": "String",
                "serpapi_link": "String",
                "variants": "Array",
                "in_stock": "Boolean",
                "price_map": {
                  "price": "Float",
                  "currency": "String",
                  "was_price": {
                    "price": "Float",
                    "price_string": "String",
                    "currency_unit": "String"
                  }
                }
              }
            ]
          }
        ]
      }
    ]
  },
  ...
}