products_pricesFlat

The products_pricesFlat view should be used when you want to look at individual prices for each product in your data set in a CSV format. It will split each price for a product into its own row. All other fields will repeat in each row.

Included Fields

Field	Included Sub-fields
`asins`	N/A
`brand`	N/A
`categories`	N/A
`colors`	N/A
`count`	N/A
`dateAdded`	N/A
`dateUpdated`	N/A
`descriptions`	`dateSeen` `sourceURLs` `value`
`dimension`	N/A
`ean`	N/A
`features`	`key` `value`
`flavors`	N/A
`imageURLs`	N/A
`isbn`	N/A
`keys`	N/A
`manufacturer`	N/A
`manufacturerNumber`	N/A
`merchants`	`address` `availability` `city` `country` `dateSeen` `name` `phone` `postalCode` `province`
`name`	N/A
`prices`	`amountMin` `amountMax` `availability` `color` `condition` `count` `currency` `dateAdded` `dateSeen` `flavor` `isSale` `merchant` `offer` `returnPolicy` `shipping` `size` `source` `sourceURLs` `warranty`
`reviews`	`date` `dateAdded` `dateSeen` `didPurchase` `doRecommend` `numHelpful` `rating` `sourceURLs` `text` `title` `userCity` `username` `userProvince`
`sizes`	N/A
`skus`	`sourceURLs` `value`
`sourceURLs`	N/A
`upc`	N/A
`vin`	N/A
`websiteID`	N/A
`weight`	N/A

Sample CSV Output

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

id,asins,brand,categories,colors,count,dateAdded,dateUpdated,descriptions,dimension,ean,features,flavors,imageURLs,isbn,keys,manufacturer,manufacturerNumber,merchants,name,prices.amountMin,prices.amountMax,prices.availability,prices.color,prices.condition,prices.count,prices.currency,prices.dateAdded,prices.dateSeen,prices.flavor,prices.isSale,prices.merchant,prices.offer,prices.returnPolicy,prices.shipping,prices.size,prices.source,prices.sourceURLs,prices.warranty,quantities,reviews,sizes,skus,sourceURLs,upc,vin,websiteIDs,weight
"AVpfBXYtLJeJML430pLJ",,"Hansa","Toys & Hobbies,Stuffed Animals,Hansa",,,"2015-11-01T04:15:04Z","2015-11-01T04:15:04Z",,,,"[{""key"":""Year"",""value"":[""2004""]},{""key"":""Condition"",""value"":[""New""]}]",,"http://i.ebayimg.com/images/g/EBUAAOSwWnFWBHIe/s-l300.jpg",,"stuffedhansaowl9tallnewwithtag2004/231727014821",,,"[{""dateSeen"":[""2015-10-31T00:00:00Z""],""name"":""Modprims - Ebay.com""}]","Stuffed Hansa Owl 9" Tall New With Tag 2004",12.99,12.99,,,"New",,"USD","2015-11-01T04:15:04Z","2015-10-31T00:00:00Z",,"false",,"winning bid",,"USD 7.95",,,"http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe",,,,"9","[{""sourceURLs"":[""http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe""],""value"":""231727014821""}]","http://www.ebay.com/itm/Stuffed-Hansa-Owl-9-tall-new-with-tag-2004-/231727014821?hash=item35f401a3a5:g:EBUAAOSwWnFWBHIe",,,,
"AVpe8YoN1cnluZ0-aYn7","B00NW4LUMI",,"Kitchen & Bath Fixtures",,,"2015-08-22T00:20:16Z","2015-08-22T00:20:16Z",,,,"[{""key"":""Weight"",""value"":[""41 Grams""]},{""key"":""Item Package Quantity"",""value"":[""1""]}]",,"http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SX300_QL70_.jpg,http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SS40_.jpg",,"macdee114plasticdomeurinalwaste/b00nw4lumi","Macdee",,"[{""dateSeen"":[""2015-08-20T00:00:00Z""],""name"":""Esda Ltd""}]","Macdee 1 1/4" Plastic Dome Urinal Waste",1.81,1.81,,,"new",,"EUR","2015-08-22T00:20:16Z","2015-08-20T00:00:00Z",,"false","ESDA Ltd",,,"EUR 2.99",,,"http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI",,,,,,"http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI",,,,"41 g"
"AVpfFEWH1cnluZ0-dcuF",,"We R Memory Keepers","Party & Occasions,Crafts,Albums","Neon Yellow,Black,Greige,Coral,Neon Purple,Neon Pink",,"2016-02-19T21:15:05Z","2016-02-19T21:15:05Z",,"6.3 in x 5.6 in x 1.8 in","0633356601081","[{""key"":""Battery Type"",""value"":[""Does Not Contain a Battery""]},{""key"":""Primary Color"",""value"":[""Pink""]},{""key"":""Product in Inches (L x W x H)"",""value"":[""6.3 x 5.6 x 1.8""]},{""key"":""Model No."",""value"":[""WRI4X4-60108""]},{""key"":""Multi Pack Indicator"",""value"":[""No""]},{""key"":""Shipping Weight (in pounds)"",""value"":[""0.55""]},{""key"":""Walmart No."",""value"":[""555207494""]}]",,"http://i5.walmartimages.com/dfw/dce07b8c-66e6/k2-_f0329218-fda6-4af6-8c20-526bc8657c98.v1.jpg",,"wermemorykeepers/wri4x460108,633356601081,0633356601081","We R Memory Keepers","WRI4X4-60108","[{""dateSeen"":[""2016-02-19T21:15:05Z""],""name"":""Walmart.com""}]","We R Instagram Ring Album, 4" X 4"",8.54,8.54,,,"new",,"USD","2016-02-19T21:15:05Z","2016-02-18T00:00:00Z",,"false",,,,"FREE shipping on orders 50 +",,,"http://www.walmart.com/ip/We-R-Instagram-Ring-Album-4-X4-Coral/48555247",,,,,,"http://www.walmart.com/ip/We-R-Instagram-Ring-Album-4-X4-Coral/48555247","633356601081",,,"0.55 lbs"
"AVpe8YooLJeJML43y3CV","B008EBXNOC","Nabeel Perfume",,,,"2015-11-06T01:58:45Z","2016-07-21T06:09:13Z",,,,,,,,"nabeelperfume/touchme,bakhoortouchmeincense40gmbynabeelperfumes/b008ebxnoc",,"Touch Me",,"Bakhoor Touch Me Incense 40 Gm By Nabeel Perfumes",6.50,6.50,,,,,"USD","2015-11-06T01:58:45Z","2015-11-03T00:00:00Z",,"false",,,,"USD 2.20 shipping",,,"http://www.amazon.com/Bakhoor-Touch-Me-Nabeel-Perfumes/dp/B008EBXNOC",,,,,,"http://www.amazon.com/Bakhoor-Touch-Me-Nabeel-Perfumes/dp/B008EBXNOC",,,,
"AVpfBXYJ1cnluZ0-cKn3",,"Dell","Computers/Tablets & Networking,Keyboards, Mice & Pointing,Mice, Trackballs & Touchpads",,,"2015-10-19T11:57:16Z","2015-10-19T11:57:16Z",,,,"[{""key"":""Connectivity"",""value"":[""Wireless""]}]",,"http://i.ebayimg.com/images/g/GxsAAOSwWnFWCqXD/s-l300.jpg",,"newdellwirelessmousewm123/321885949955",,,"[{""dateSeen"":[""2015-10-14T00:00:00Z""],""name"":""Uffdaracing - Ebay.com""}]","New Dell Wireless Mouse Wm123",14.99,14.99,,,"New",,"USD","2015-10-19T11:57:16Z","2015-10-14T00:00:00Z",,"false",,"winning bid",,"USD 4.95",,,"http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003",,,,,"[{""sourceURLs"":[""http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003""],""value"":""321885949955""}]","http://www.ebay.com/itm/NEW-DELL-Wireless-Mouse-WM123-/321885949955?hash=item4af1e5d003",,,,
"AVpe8YozLJeJML43y3Cb",,,"Test Auctions,Seller Category 4,Everything Else",,,"2016-03-29T23:56:36Z","2016-04-20T03:00:43Z",,,,,,"http://i.ebayimg.com/images/g/F~0AAOSwrklU-o7o/s-l64.jpg,http://i.ebayimg.com/images/g/ZsMAAOSwBLlU-o7m/s-l300.jpg,http://i.ebayimg.com/images/g/ZsMAAOSwBLlU-o7m/s-l64.jpg",,"testlisting010notbuy/121933843062",,,"[{""dateSeen"":[""2016-04-19T00:00:00Z""],""name"":""Working.man - Ebay.com""}]","Test Listing #010 -- Do Not Buy",9.95,9.95,,,,,"USD","2016-03-29T23:56:36Z","2016-04-19T00:00:00Z",,"false",,,,"USD 3.00",,,"http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m",,,,,"[{""sourceURLs"":[""http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m""],""value"":""121933843062""}]","http://www.ebay.com/itm/TEST-LISTING-010-DO-NOT-BUY-/121933843062?hash=item1c63d2ca76:g:ZsMAAOSwBLlU-o7m",,,,
"AVpfBXYyilAPnD_xTNXz",,,"Appliances,Small Kitchen Appliances,Skillets & Woks,Skillets",,,"2015-10-17T03:47:41Z","2015-10-17T03:47:41Z",,,,,,"http://pisces.bbystatic.com/image2/BestBuy_US/images/mp/products/1309/1309712/1309712113/1309712113_500x500_sa.jpg;canvasHeight=105;canvasWidth=105",,"berndessignocastskillet85inch/1309712113",,"697220",,"Berndes - Signocast Skillet, 8.5-inch",49.09,49.09,,,"New",,"USD","2015-10-17T03:47:41Z","2015-10-15T00:00:00Z",,"false","Wayfair - Bestbuy.com",,,,,,"http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,,"[{""sourceURLs"":[""http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113""],""value"":""1309712113""}]","http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,
"AVpfBXYyilAPnD_xTNXz",,,"Appliances,Small Kitchen Appliances,Skillets & Woks,Skillets",,,"2015-10-17T03:47:41Z","2015-10-17T03:47:41Z",,,,,,"http://pisces.bbystatic.com/image2/BestBuy_US/images/mp/products/1309/1309712/1309712113/1309712113_500x500_sa.jpg;canvasHeight=105;canvasWidth=105",,"berndessignocastskillet85inch/1309712113",,"697220",,"Berndes - Signocast Skillet, 8.5-inch",50.08,50.08,,,"New",,"USD","2015-10-17T03:47:41Z","2015-09-08T00:00:00Z",,"false","Wayfair - Bestbuy.com",,,"Free Shipping",,,"http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,,"[{""sourceURLs"":[""http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113""],""value"":""1309712113""}]","http://www.bestbuy.com/site/berndes-signocast-skillet-8-5-inch/1309712113.p?id=mp1309712113&skuId=1309712113",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",47.99,47.99,,,,,"USD","2015-09-21T13:31:22Z","2016-03-01T00:00:00Z",,"true","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",15.12,15.12,,,,,"USD","2015-09-21T13:31:22Z","2016-03-01T00:00:00Z",,"false","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",16.80,16.80,,,,,"USD","2015-09-21T13:31:22Z","2015-09-15T00:00:00Z",,"false","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,
"AVpfAw0ailAPnD_xS_mP",,,"Jewelry & Watches,Jewelry,Stainless Steel Jewelry,Rings,Stainless Steel Rings",,,"2015-09-21T13:31:22Z","2016-03-03T05:01:32Z",,,,"[{""key"":""Gender"",""value"":[""Female""]},{""key"":""Metal"",""value"":[""Stainless Steel""]},{""key"":""Gemstone Color"",""value"":[""Silver""]},{""key"":""Country of Origin"",""value"":[""China""]},{""key"":""Model Number"",""value"":[""WCJ-SS479""]},{""key"":""Band Width"",""value"":[""2-3 mm""]},{""key"":""Stone Shape"",""value"":[""Heart""]},{""key"":""Diamond Cut"",""value"":[""Heart""]},{""key"":""Ring Style"",""value"":[""Cocktail-Cluster, Fashion, Heart"",""Cocktail-Cluster Fashion Heart""]},{""key"":""Metal Color"",""value"":[""White""]},{""key"":""material"",""value"":[""Stainless Steel""]}]",,"http://ak1.ostkcdn.com/images/products/8323493/Stainless-Steel-Heart-Center-Ring-d38a4c47-691d-421b-952f-07caf7bb2e74_80.jpg",,"stainlesssteelheartcenterring/15637248",,,,"Stainless Steel Heart Center Ring",55.99,55.99,,,,,"USD","2015-09-21T13:31:22Z","2015-09-15T00:00:00Z",,"true","Overstock.com",,,,,,"http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,,"[{""sourceURLs"":[""http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848""],""value"":""15637248""}]","http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=QRZBDQ4MQUA22JSONV3GYLWKXQ&searchidx=1848,http://www.overstock.com/Jewelry-Watches/Stainless-Steel-Heart-Center-Ring/8323493/product.html?refccid=TYKIV7LQPBPYG62F3IOUKLOQ2U&searchidx=4912",,,,

Sample Json Output

{
  "asins": [
    "B00NW4LUMI"
  ],
  "categories": [
    "Kitchen & Bath Fixtures"
  ],
  "dateAdded": "2015-08-22T00:20:16Z",
  "dateUpdated": "2015-08-22T00:20:16Z",
  "features": [
    {
      "key": "Weight",
      "value": [
        "41 Grams"
      ]
    },
    {
      "key": "Item Package Quantity",
      "value": [
        "1"
      ]
    }
  ],
  "imageURLs": [
    "http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SX300_QL70_.jpg",
    "http://ecx.images-amazon.com/images/I/31kWQk9vqdL._SS40_.jpg"
  ],
  "keys": [
    "macdee114plasticdomeurinalwaste/b00nw4lumi"
  ],
  "manufacturer": "Macdee",
  "merchants": [
    {
      "dateSeen": [
        "2015-08-20T00:00:00Z"
      ],
      "name": "Esda Ltd"
    }
  ],
  "name": "Macdee 1 1/4" Plastic Dome Urinal Waste",
  "prices": [
    {
      "amountMin": 1.81,
      "amountMax": 1.81,
      "condition": "new",
      "currency": "EUR",
      "dateAdded": "2015-08-22T00:20:16Z",
      "dateSeen": [
        "2015-08-20T00:00:00Z"
      ],
      "isSale": "false",
      "merchant": "ESDA Ltd",
      "shipping": "EUR 2.99",
      "sourceURLs": [
        "http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI"
      ]
    }
  ],
  "sourceURLs": [
    "http://www.amazon.co.uk/Macdee-Plastic-Dome-Urinal-waste/dp/B00NW4LUMI"
  ],
  "weight": "41 g",
  "id": "AVpe8YoN1cnluZ0-aYn7"
}

Was this page helpful?

Last updated 1 week ago

Built with Documentation.AI