search

Goodler / code

Goodler
Apache License 2.0
0 stars 2 forks source link

Price discrepancy for items added to the wishlist (Urgent) #363

Closed galinafed closed 10 years ago

galinafed commented 10 years ago

We just found out that some of the items, when pasting link from Amazon to the wish list pick the lowest price when transferred to Gooddler. Nikita told us that it would search for an average price, that should not be lower than the price of the picked item. Example: When i tried to add this item: http://www.amazon.com/Silver-Bottle-Organza-Favor-6-5x15/dp/B005A106NU/ref=pd_bxgy_ac_img_z screenshot 29

to this list: http://gooddler.com/Wishlist/Edit/5

Here is what it added: screenshot 30

An item that has $5 cost!

DeveloperRegistry commented 10 years ago

Confirmed that Item Id is parsed correctly. Te $5.00 price is in the fact the lowest price (there is a link below saying that available from several sellers for $5.00). Otherwise, the price is $9.15. Please confirm requirements: do we need to display the average between $5.00 and $9.15?

LowestNewPrice <!Amount>500 <!CurrencyCode>USD <!FormattedPrice>$5.00 <!/LowestNewPrice> <!TotalNew>5 <!TotalUsed>0 <!TotalCollectible>0 <!TotalRefurbished>0 <!/OfferSummary> <!Price> <!Amount>915 <!CurrencyCode>USD <!FormattedPrice>$9.15 <!/Price>

DeveloperRegistry commented 10 years ago

Implemented the following solution. Get a List of all Amounts from Amazon XML Response. Set the Highest price as the price.

galinafed commented 10 years ago

I think it's best to put highest possible price for right now. I am trying to add this item right now, list price $299: http://www.amazon.com/HS-65L-Compact-Reversible-Refrigerator-Freezer/dp/B0058ENUBO/ref=lh_ni_t?ie=UTF8&psc=1&smid=A6E4KVQD2C316 screenshot 31 but it is adding as $150 http://gooddler.com/Wishlist/Edit/10004 screenshot 32

galinafed commented 10 years ago

same thing if i add: http://www.amazon.com/Seventh-Generation-Natural-Liquid-Unscented/dp/B00COZ64TK/ref=lh_ni_t?ie=UTF8&psc=1&smid=A235DNGKWE88C9 screenshot 33

It adds as $3.98 http://gooddler.com/Wishlist/Edit/10004 screenshot 34

DeveloperRegistry commented 10 years ago

We will research and address ASAP.

DeveloperRegistry commented 10 years ago

Conducted complete investigation. Established that Amazon data returned by the web service may differ from data displayed on web pages. The issue is described here: http://stackoverflow.com/questions/12923080/why-is-itemlookup-not-returning-any-price-information-even-when-requesting-all-3/13871309#13871309‏ "Unfortunately, you cannot count on consistency with AWS API. I've been dealing with this problem for almost two years. The problem is: even though the price is visible on the product (HTML) page, it is not guaranteed that it is available on the repository used by AWS API. You'll have to accept that fact if you want to continue to use their API"

Discussed the issue with Tanya. Coded a Price Override for Admin Users. Admins can now change prices as needed. Added a parameter to the database to capture the fact that price was manually updated. It will be used for Price Comparison Batch job.