Fliplist
Search…
What We Left Out
Please email [email protected] if you are looking for these fields or work arounds and the following does not answer your concerns.

Product Request API

1. Variations intentionally left out

Due to initialization issues through bubble's API. We favored Languages since "variationCSV" field returns a list of alternative ASINs anyway.

1
"variations": Object array [left out of API call]
Copied!

2. &history=0 (removes the following LONG history results and significantly speeds up the api call.

INSTEAD we include the stats object. It provides averages for 32 different fields at 30 ,90 , 180 intervals
Sales Rank drop (count of [30, 90 &180] days with at least one sale) is much better for quantifying how well a product is selling, AS opposed to sales rank which is a high variability snapshot in time & sales rank average, which is only slightly better.
1
"salesRankReference": Long,
2
"salesRanks": Object,
3
"csv": two dimensional Integer array [left out of API call]
Copied!

Included -> 32 fields that can be accessed from the following fields:

1
[included in API as alternative to history]
2
3
"current": Integer array,
4
"avg": Integer array,
5
"avg30": Integer array,
6
"avg90": Integer array,
7
"avg180": Integer array,
8
"atIntervalStart": Integer array,
Copied!

32 field names : Accessed in bubble.io through "current list" item: #

  • first item - AMAZON: Amazon price history
  • item # 2 - NEW: Marketplace New price history.
  • 3 - USED: Marketplace Used price history
  • 4 - SALES: Sales Rank history. Not every product has a Sales Rank. Variation items usually do not have individual sales ranks.
  • 5 - LISTPRICE: List Price history
  • 6 - COLLECTIBLE: Collectible price history
  • 7 - REFURBISHED: Refurbished price history
  • 8 - NEW_FBM_SHIPPING: 3rd party (not including Amazon) New price history including shipping costs, only fulfilled by merchant (FBM).
  • 9 - LIGHTNING_DEAL: Lightning Deal price history. Lightning deals are special, relevant important information below.
  • 10 - WAREHOUSE: Amazon Warehouse price history.
  • 11 - NEW_FBA: Price history of the lowest 3rd party (not including Amazon/Warehouse) New offer that is fulfilled by Amazon
  • 12 - COUNT_NEW: New offer count history (= count of marketplace merchants selling the product as new)
  • 13 - COUNT_USED: Used offer count history
  • 14 - COUNT_REFURBISHED: Refurbished offer count history
  • 15 - COUNT_COLLECTIBLE: Collectible offer count history
  • 16 - EXTRA_INFO_UPDATES: History of past updates to all offers-parameter related data: offers, buyBoxSellerIdHistory, isSNS, isRedirectASIN and the csv types NEW_FBM_SHIPPING, WAREHOUSE, NEW_FBA, RATING, COUNT_REVIEWS, BUY_BOX_SHIPPING, USED_*_SHIPPING, COLLECTIBLE_*_SHIPPING and REFURBISHED_SHIPPING. As updates to those fields are infrequent it is important to know when our system updated them. The absolute value indicates the amount of offers fetched at the given time. If the value is positive it means all available offers were fetched. It’s negative if there were more offers than fetched.
  • 17 - RATING: The product’s rating history. A rating is an integer from 0 to 50 (e.g. 45 = 4.5 stars)
  • 18 - COUNT_REVIEWS: The product’s review count history.
  • 19 - BUY_BOX_SHIPPING: The price history of the New buy box. If no offer qualified for the buy box (or if the buy box is an used offer) the price has the value -1. Including shipping costs.
  • 20 - USED_NEW_SHIPPING: “Used - Like New” price history including shipping costs.
  • 21 - USED_VERY_GOOD_SHIPPING: “Used - Very Good” price history including shipping costs.
  • 22 - USED_GOOD_SHIPPING: “Used - Good” price history including shipping costs.
  • 23 - USED_ACCEPTABLE_SHIPPING: “Used - Acceptable” price history including shipping costs.
  • 24 - COLLECTIBLE_NEW_SHIPPING: “Collectible - Like New” price history including shipping costs.
  • 25 - COLLECTIBLE_VERY_GOOD_SHIPPING: “Collectible - Very Good” price history including shipping costs.
  • 26 - COLLECTIBLE_GOOD_SHIPPING: “Collectible - Good” price history including shipping costs.
  • 27 - COLLECTIBLE_ACCEPTABLE_SHIPPING: “Collectible - Acceptable” price history including shipping costs.
  • 28 - REFURBISHED_SHIPPING: Refurbished price history including shipping costs.
  • 29 - EBAY_NEW_SHIPPING: price history of the lowest new price on the respective eBay locale, including shipping costs.
  • 30 - EBAY_USED_SHIPPING: price history of the lowest used price on the respective eBay locale, including shipping costs.
  • 31 - TRADE_IN: the trade in price history. Amazon trade-in is not available for every locale.
  • last item : - RENTAL: Rental price history. Requires use of the rental and offers parameter. Amazon Rental is only available for Amazon US.

EXAMPLE

A list is returned with 32 positions in a list :
"avg30": [ 3600, 2965, 3040, 2135, 4000, -1, -1, 3366, -1, -1, -1, 27, 7, -1, -1, -1, 48, 2504, 3600, 3521, 3281, 3692, 3527, -1, -1, -1, -1, -1, 2778, 3356, -1, -1 ]
position one = Amazon price history ( "avg30" = $36.00 )
  • (-1) represents an out of stock item.

Stats Object

1
[Left out of API]
2
3
"min": two dimensional Integer array,
4
"max": two dimensional Integer array,
5
"minInInterval": two dimensional Integer array,
6
"maxInInterval": two dimensional Integer array,
Copied!
All fields were intentionally left out due to multiple sub-lists not being interpreted by Bubble API correctly.
These are fields that may be added manually with a separate API call in the future. Please email [email protected] if these are essential data points you require.
Last modified 13h ago