Bass Pro Shops - DoorDash benchmark, day-0 inventory (fishing + camping) - 2026-09-03
=====================================================================================

Files (column names as in DoorDash's Catalog / Inventory example sheets; extra columns at the end)
  basspro_stores.csv      156 stores (145 US + 11 CA; Bass Pro Shops + Cabela's banners), store_id zero-padded
  basspro_catalog.csv     75,885 sellable SKUs in Fishing + Camping (one row per variant; variant_id groups
                          variants under the parent Web ID); l1-l4 = merchant taxonomy (Department / Sub
                          Department / Class / Sub Class); attr_* = the variant's defining attributes;
                          carried_store_count = stores whose assortment lists the SKU (merchant presence flag)
  basspro_inventory.csv   4,722,210 (store, SKU) rows for the 75,885 SKUs x 156 stores that the store
                          inventory service answered for; in_stock_rate: Many in stock (qty > 2),
                          Low in stock (1-2), Out of stock (0); ats = quantity; carried = Y/N presence flag
                          (an "Out of stock" row with carried = N is an item the store does not stock)

Field fill (catalog): upc 100%, product_description 99%, photo_url 98%, auxiliary_photo_url 59%
(items with a single image have none), brand 99%, listing_url 0% (the product page URL is not in
the merchant's data service; a sitemap join by name is the follow-up).

Runtime and requests (what you asked us to report)
  store list          1 request, < 1 s
  catalog (full, 217,420 SKUs, exclusions applied)   24,819 requests, 37 min
  inventory day 0 (fishing + camping, all stores)      29,070 requests, 2 h 10 min wall on the final run
  images (main + alternates)                           14,434 requests, 13 min
  Exclusions applied in the catalog: Small Boats, Shooting, Hunting > Archery, Hunting > Knives & Tools;
  firearm/ammo-flagged rows dropped.

Caveats on this first pull
  - crawl_date / crawl_time are the run's start (UTC); rows were captured over the following 2 h 10 min.
  - 2.2% of requested (store, SKU) pairs returned no record from the merchant's inventory service
    (likely unpublished SKUs); those pairs are absent from the inventory file.
  - Inventory covers Fishing + Camping (the priority). The remaining categories in the catalog
    (Men, Women, Hunting, Boating, Home, Kids, Outdoor Rec, Bargain Cave) follow in the next pull.
  - The first (cold) pull of a SKU set is slow on the merchant side; repeat pulls are fast.
