products_basicFields

The products_basicFields view displays a limited number of fields from our product schema. This is view is helpful when you need less information to do your analysis.

If using the csv format, the categories field will be nested into a single cell, but the sourceURLs field will be split into multiple rows.

Included Fields

Field	Included Sub-fields
`brand`	N/A
`categories`	N/A
`manufacturer`	N/A
`name`	N/A
`sourceURLs`	N/A

Sample CSV Output

Right-click and choose "Save link as..." to download this sample so you can see it in Excel: products_basicFields-CSV-example.csv

id,brand,categories,manufacturer,name,sourceURLs
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),https://www.overstock.com/Office-Supplies/Sparco-Economy-7-inch-Thermal-Fax-Paper-Box-of-6/9519127/product.html
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.walmart.com/ip/Sparco-Products-Fax-Paper-1-2-Core-H-Sensitivity-8-1-2-x98-White/22856854?action=product_interest&action_type=title&item_id=22856854&placement_id=irs-2-m3&strategy=PWBAB&visitor_id&category=&customer_id_enc&config_id=2&parent_item_id=15140199&parent_anchor_item_id=15140199&bucket_id=irsbucketdefault&beacon_version=1.0.1&findingMethod=p13n
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.walmart.com/ip/Sparco-Products-Fax-Paper-1-2-Core-H-Sensitivity-8-1-2-x98-White/22856854?action=product_interest&action_type=title&item_id=22856854&placement_id=irs-2-m3&strategy=PWBAB&visitor_id&category=&customer_id_enc&config_id=2&parent_item_id=15140199&parent_anchor_item_id=15140199&bucket_id=irsbucketdefault&beacon_version=1.0.1&findingMethod=p13n#reviews
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.walmart.com/ip/Sparco-Products-Fax-Paper-1-2-Core-H-Sensitivity-8-1-2-x98-White/22856854
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.overstock.com/Office-Supplies/Sparco-Economy-7-inch-Thermal-Fax-Paper-Box-of-6/9519127/product.html?refccid=NO6IA2AIQFDLBVKBGKDLDSUM2Q&searchidx=20
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.overstock.com/Office-Supplies/Sparco-Economy-7-inch-Thermal-Fax-Paper-Box-of-6/9519127/product.html?refccid=BVGD6PX5TEJJ22KHORB4JAVNAM&searchidx=205
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.overstock.com/Office-Supplies/Sparco-Economy-7-inch-Thermal-Fax-Paper-Box-of-6/9519127/product.html?refccid=H4N627FOI4J2L5CJAEKDFXBHJA&searchidx=195
AVpgRL7qLJeJML43LfPj,Sparco,"Envelopes,Fax Paper,Forms,Paper,Stationery,All Paper & Printable Media,Office,Paper & Printable Media,Office Supplies,Paper, Forms & Envelopes,Sparco,Paper & Stationery",Sparco Products,Sparco Economy 7-inch Thermal Fax Paper (box of 6),http://www.overstock.com/Office-Supplies/Sparco-Economy-7-inch-Thermal-Fax-Paper-Box-of-6/9519127/product.html?refccid=YUOJ5EM775OYSPKIR3J64TWWSY&searchidx=99
AVpgfD46LJeJML43Oi86,National Tree Company,"Garden,Garden Accents,Outdoor Decor,Patio,Home & Garden,Garden & Patio,Fencing,Lumber & Composites,Garden Fencing",,93 In. Garden Accents Gated Archway,https://www.overstock.com/Home-Garden/National-Tree-Company-93-inch-Metal-Arch-with-Gate/9999462/product.html
AVpgfD46LJeJML43Oi86,National Tree Company,"Garden,Garden Accents,Outdoor Decor,Patio,Home & Garden,Garden & Patio,Fencing,Lumber & Composites,Garden Fencing",,93 In. Garden Accents Gated Archway,http://www.overstock.com/Home-Garden/National-Tree-Company-93-inch-Metal-Arch-with-Gate/9999462/product.html?refccid=ONMAJEHZM3YLFKKGNKO6O6T6BQ&searchidx=4391
AVpgfD46LJeJML43Oi86,National Tree Company,"Garden,Garden Accents,Outdoor Decor,Patio,Home & Garden,Garden & Patio,Fencing,Lumber & Composites,Garden Fencing",,93 In. Garden Accents Gated Archway,http://www.overstock.com/Home-Garden/National-Tree-Company-93-inch-Metal-Arch-with-Gate/9999462/product.html?refccid=SB4VJNC44COZUT2KQSIKBDHGOE&searchidx=1830
AVpgfD46LJeJML43Oi86,National Tree Company,"Garden,Garden Accents,Outdoor Decor,Patio,Home & Garden,Garden & Patio,Fencing,Lumber & Composites,Garden Fencing",,93 In. Garden Accents Gated Archway,http://reviews.homedepot.com/1999m/206270200/reviews.htm?format=embedded
AVpgfD46LJeJML43Oi86,National Tree Company,"Garden,Garden Accents,Outdoor Decor,Patio,Home & Garden,Garden & Patio,Fencing,Lumber & Composites,Garden Fencing",,93 In. Garden Accents Gated Archway,http://www.homedepot.com/p/National-Tree-Company-93-in-Garden-Accents-Gated-Archway-GAMC30-93RB/206270200
AVpe_xo3LJeJML430Ex9,NEW,"Mobile Accessories,Cases, Covers, Skins",,Shockproof Dual Color Frame Pc+tpu Phone Case Back Cover For Iphone 6 4.7 6 Plus,http://www.ebay.com.au/itm/Shockproof-Dual-Color-Frame-PC-TPU-Phone-Case-Back-Cover-For-iPhone-6-4-7-6-Plus-/181988243122?var=&hash=item2a5f5836b2:m:mAvQVbsUMDmPILVDkLMMj4g
AVpe_xprLJeJML430Eya,ARB 4x4 Accessories,"Automotive,Body Styling,Bumpers,Exterior Accessories",,Arb 4x4 Accessories 4x4 Accessories 3420210 Front Deluxe Bull Bar Winch Mount Bumper,http://www.sears.com/content/pdp/config/products/v1/products/SPM9593083932?site=sears
AVpe_xprLJeJML430Eya,ARB 4x4 Accessories,"Automotive,Body Styling,Bumpers,Exterior Accessories",,Arb 4x4 Accessories 4x4 Accessories 3420210 Front Deluxe Bull Bar Winch Mount Bumper,http://www.sears.com/content/pdp/products/pricing/v1/get/price/display/json?pid=SPM9593083932&pidType=0&priceMatch=Y&memberStatus=G&storeId=10153
AVpe_xqUilAPnD_xSpEI,Hugo Boss,"Fragrances,Women",,Boss Woman By Hugo Boss 3.0 Oz Eau De Parfum Spray Nib Sealed For Women,http://www.ebay.com/itm/Boss-Woman-By-Hugo-Boss-3-0-Oz-Eau-de-Parfum-Spray-NIB-Sealed-For-Women-/331712278775?hash=item4d3b97b0f7:g:3S0AAOSwIwhWTfWl
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,https://www.overstock.com/Luggage-Bags/Wildkin-Munch-n-Lunch-Bag-Peace-Signs-Purple/8100331/product.html
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.overstock.com/Luggage-Bags/Wildkin-Munch-n-Lunch-Bag-Peace-Signs-Purple/8100331/product.html?refccid=RMP5I6SOZVT3REKB6VHZNU4JGQ&searchidx=152
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.overstock.com/Luggage-Bags/Wildkin-Munch-n-Lunch-Bag-Peace-Signs-Purple/8100331/product.html?refccid=QDX2KBDHXA6J4CKKL3HD2HUSZE&searchidx=232
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.overstock.com/Luggage-Bags/Wildkin-Munch-n-Lunch-Bag-Peace-Signs-Purple/8100331/product.html?refccid=GGFYAAGTSK7ZHAKOH462PNTN6I&searchidx=244
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.overstock.com/Luggage-Bags/Wildkin-Munch-n-Lunch-Bag-Peace-Signs-Purple/8100331/product.html?refccid=LDE3TEG7PLGIENCLP6XUB5OJAY&searchidx=206
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.amazon.com/Wildkin-Peace-Signs-Munch-Lunch/dp/B0084DZ7RG
AVph9Rkv1cnluZ0-IR1Q,Wildkin,"Bags,Lunch Bags,luggage & bags,Wildkin,Home,Kitchen & Dining,Kitchen Storage & Organization,Food Storage,#35181 in,#5578 in,#1464 in",Wildkin,Wildkin Peace Signs Munch 'n Lunch Bag,http://www.walmart.com/ip/Wildkin-Peace-Signs-Purple-Munch-n-Lunch-Bag/20731723

Sample JSON Output

{
  "estimated total": 2539564,
  "records": [
    {
      "brand": "International Caravan",
      "categories": [
        "Garden",
        "Outdoor Dining Sets",
        "Patio",
        "Patio Furniture",
        "Patio & Garden",
        "Patio Dining Sets",
        "Dining Sets",
        "home",
        "International Caravan",
        "Home & Garden",
        "Garden & Patio"
      ],
      "manufacturer": "International Caravan",
      "name": "International Caravan Royal Tahiti Badalona 7-piece Outdoor Dining Set",
      "sourceURLs": [
        "https://www.overstock.com/Home-Garden/International-Caravan-Royal-Tahiti-Badalona-7-Piece-Outdoor-Dining-Set/7157245/product.html",
        "https://www.walmart.com/ip/International-Caravan-Barcelona-Balau-7-Piece-Dining-Set/24402467",
        "http://www.walmart.com/ip/International-Caravan-Barcelona-Balau-7-Piece-Dining-Set/24402467",
        "http://www.walmart.com/ip/7-Pc-Modern-Patio-Dining-Set/44365228",
        "http://www.overstock.com/Home-Garden/International-Caravan-Royal-Tahiti-Badalona-7-Piece-Outdoor-Dining-Set/7157245/product.html?refccid=7NEV4NLR5J5KDVCHGKVHMWNDEY&searchidx=676",
        "http://www.overstock.com/Home-Garden/International-Caravan-Royal-Tahiti-Badalona-7-Piece-Outdoor-Dining-Set/7157245/product.html?refccid=HM4YQ2LSNA3YUK2ILYBEYOGA2I&searchidx=212",
        "http://www.overstock.com/Home-Garden/International-Caravan-Royal-Tahiti-Badalona-7-Piece-Outdoor-Dining-Set/7157245/product.html?refccid=HXVTRPL6GXR2MUCBBR63KXT44A&searchidx=137"
      ],
      "id": "AVpfNbowilAPnD_xXRD3"
    }
  ]
}