I encounterd problems about price data.

Problem 1
Created a field style view and added fields:

    (field_amazon_item_asin) Amazon: List price (formatted)
    (field_amazon_item_asin) Amazon: Amazon price (formatted)
    (field_amazon_item_asin) Amazon: Lowest price (formatted)

the List price and Lowest price display expectedly. But all Amazon prices do not show up, looks like this field is always empty.

Problem 2
Sometimes I found some prices on my view page/block are different from the prices on the product detail page from the Amazon Store module. I SUPOSE the prices on my view page come from the Drupal database, but Amazon Store access data directly from the Amazon database. Is this true? If so, how to synchronize them?

CommentFileSizeAuthor
#20 amazon.amazon_price_outside_us_879830.patch2.45 KBrfay
#18 amazonprices.jpg142.49 KBcarpenoctem414
#16 amazonprices.zip4.38 KBcarpenoctem414

Comments

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Active » Postponed (maintainer needs more info)

Hi astra!

Please provide an example ASIN whenever reporting a problem of this type.

Problem 1: Is it possible that the ASIN you're using is not sold by Amazon, but only by merchants or sellers? Please check.

Problem 2: Please make sure that you have the refresh rate on admin/settings/amazon/storage set to what you want it to be set to (smaller is better if you want to keep in sync with Amazon) and also make sure you're running cron often enough to make that work.

Thanks,
-Randy

astra’s picture

astra commented

Hi Randy, thanks for you help!

For Problem 2, I will change Amazon refresh schedule and set running cron properly and see what happen.

For Problem 1, here give an axample, which is sold by Amazon but can't show up the Amazon price on my site:

ASIB from Amazon.co.uk: 780200456X
It's sold in £10.95 by Amazon.co.uk: http://www.amazon.co.uk/gp/offer-listing/780200456X/ref=dp_olp_new?ie=UT...

I had a test for this ASIB on admin/settings/amazon/test and got the output below with no Amazon price. Something wrong for the module?

Array
(
[asin] => 780200456X
[isbn] => 780200456X
[ean] => 9787802004566
[salesrank] =>
[detailpageurl] => http://www.amazon.co.uk/Chinese-Cartons-Travelers-Jing-Zhang/dp/78020045...
[listpriceamount] => 1095
[listpricecurrencycode] => GBP
[listpriceformattedprice] => £10.95
[lowestpriceamount] => 737
[lowestpricecurrencycode] => GBP
[lowestpriceformattedprice] => £7.37
[binding] => Paperback
[deweydecimalnumber] => 302
[edition] => Bilingual
[label] => Foreign Languages Press
[manufacturer] => Foreign Languages Press
[numberofpages] => 128
[productgroup] => Book
[producttypename] => ABIS_BOOK
[publicationdate] => 2008-10
[publisher] => Foreign Languages Press
[studio] => Foreign Languages Press
[title] => Chinese 101 in Cartons (for Travelers)
[author] => Array......

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

#2: Amazon does not in fact have that item for sale.

And since you find that Amazon's actual data does not return an "Amazon price", there is nothing that this module can do (that I can think of)

astra’s picture

astra commented

No. If go to the product detail page amazon_store/item/780200456X, I can see "Amazon.co.uk - £10.95" listed in the Merchant dropdown list. That's for sure, don't you?

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

What Amazon.co.uk says is this:

Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your credit card will not be charged until we ship the item.

astra’s picture

astra commented

There is another example with the same problem for ASIN 1405318635.

To open the site page amazon_store/item/1405318635, select "Amazon.co.uk - £6.99" under the Merchant, the message display:

Sold by Amazon.co.uk: Usually dispatched within 1 to 2 months

"dispatched within 1 to 2 months" looks like out of stock but can place a order. The description of the stock status is flexible. I think if only use Amazon module that doesn't matter which stock stutes Amazon prices can be available. But if use it together with Amazon Store that seems a little confusion. Would it be possible to make them consistent?

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

I *think* that if it doesn't come down in the API load of the data, then there's nothing that can be done. Open to suggestions, though. You don't mention whether you checked this and it came down in the admin/settings/amazon/test.

astra’s picture

astra commented

To test ASIN 1405318635 on the page admin/settings/amazon/test, no Amazon price data display:

    Array
    (
    [asin] => 1405318635
    [isbn] => 1405318635
    [ean] => 9781405318631
    [salesrank] => 4110
    [detailpageurl] => http://www.amazon.co.uk/Easy-Peasy-Chinese-Mandarin-Beginners/dp/1405318...
    [listpriceamount] => 899
    [listpricecurrencycode] => GBP
    [listpriceformattedprice] => £8.99
    [lowestpriceamount] => 699
    [lowestpricecurrencycode] => GBP
    [lowestpriceformattedprice] => £6.99
    [binding] => Audio CD
    [format] => Audiobook
    [label] => Dorling Kindersley
    [manufacturer] => Dorling Kindersley
    [numberofitems] => 1
    [numberofpages] => 128
    [productgroup] => Book
    [producttypename] => ABIS_BOOK
    [publicationdate] => 2007-05-03
    [publisher] => Dorling Kindersley
    [studio] => Dorling Kindersley
    [title] => Easy Peasy Chinese: Mandarin Chinese for Beginners (Book & CD)
    [author] => Array......

But linking to the item detail page amazon_store/item/1405318635, it's being sold by Amazon.co.uk with data:

    Amazon.co.uk - £6.99
    Sold by Amazon.co.uk: Usually dispatched within 1 to 2 months

I've checked all products of my site. The result is that for all products sold by Amazon.co.uk they can't display Amazon prices at admin/settings/amazon/test, of course also not show it up through Views or CCK Amazon item. That's a problem. Perhaps something wrong in the API load for amazon.co.uk. Becouse I remenber the locale amazon.com can do that with no problem.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Title: Prices display/Refresh Problems » amazon.co.uk does not provide "Amazon Price" data

That is definitely interesting - I'm not sure what we can do about it, but it's interesting. Thanks for looking at it.

Changing title accordingly.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Postponed (maintainer needs more info) » Active
rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

Apparently the same issue with amazon.de: #899668: Amazon Price not listed in amazon.de marked as duplicate

carpenoctem414’s picture

carpenoctem414 commented

It looks like Amazon does not provide this data for non-amazon.com. Marking duplicate of #879830: amazon.co.uk does not provide "Amazon Price" data.

Please make sure to make each bug report or feature request a separate issue. Thanks!

k will figure that out

in fact the paa (product advertising api) offers lowestusedprice, so why shouldn't they offer the normal amazon price?
see interestig link from the developerboard:
http://developer.amazonwebservices.com/connect/thread.jspa?messageID=181...

in fakt II: at SignedRequestHelper from amaon developers plattform (url: http://associates-amazon.s3.amazonaws.com/signed-requests/helper/index.html) i've tried some requests and the amazon price with! locale de is perfekt--i realy dont know where the problem is, but i a also stay in contact with developement of amazon api.

Reminder Problem: Using Drupal, 6 tried also with 7 , amazon module---- csv import --- !amazon price formatted/or numeric isnt displayed in amazon.de like amazon.uk

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented

@carpenoctem414: On your "reminder problem" or Fakt II - I suspect these are separate issues? If so, please create separate issues with complete how-to-recreate information so that I can understand them when I next get some time for this module (or when other people do).

carpenoctem414’s picture

carpenoctem414 commented

Okay, sorry for..
Now i just whant to inform that the amazon price is supported by the api call also for amazon.de.
With the following request call at Signed Request Helper-Page i got all prices listed from amazon.de correct:

http://ecs.amazonaws.de/onca/xml?Service=AWSECommerceService&Version=2009-03-31&Operation=ItemLookup&SearchIndex=Books&IdType=ISBN&ItemId=3437423517&MerchantId=All&ResponseGroup=OfferFull&locale=de

It seams the ResponseGroup and the MerchantId are necessary to get the prices correct.

Best Regards

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Title: amazon.co.uk does not provide "Amazon Price" data » amazon.co.uk/amazon.de does not provide "Amazon Price" data
carpenoctem414’s picture

carpenoctem414 commented
StatusFileSize
new amazonprices.zip4.38 KB

Still not showing the diffrent prices from amazon API in drupal amazon module.
I really tried a lot and added some fields changed ResponseGroup, MerchantId, etc, but still without success.
With above http request url at Signed Request Helper i got all relevant details and prices:
Here once more the request:

http://ecs.amazonaws.de/onca/xml?Service=AWSECommerceService
&Version=2009-03-31
&Operation=ItemLookup
&ResponseGroup=ItemAttributes,OfferFull,SalesRank
&SearchIndex=Books
&IdType=ISBN
&ItemId=3437423517
&MerchantId=All
&locale=de

the xml output see attached file amazoneprices.zip

So i've tried to play around changing the ResponseGroup (OfferSummary, OfferFull, Offers, ..) or MerchantId (All, Amazon,..)
i added also some other fields to try it out like "LatestUsedPrice" which is also supported by the OfferSummary and there outgiven.
But in Drupal amazon module those pricefields are empty after the call, and i really dont know why.
It is supported by the api also for amazon.de (see above call and xml response)

Ok the topic is here that the amazon price isnt shown in amazon.uk and amazon.de and thats badly true, i cant figure it out why.

thanks for a little help.

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Category: support » bug

OK - thanks for the excellent debugging. I'm hoping to spend a little time with Amazon this week, but can't guarantee it.

carpenoctem414’s picture

carpenoctem414 commented
StatusFileSize
new amazonprices.jpg142.49 KB

Ok thank you, would be nice, i will also try to help and contribute for that nice module to get perfect.
here a screenshot of output at present with new fields. Numeric prices output is "0" - formatted outputt is empty

1. altered the database

one example for adding lowestusedprice

ALTER TABLE `amazon_item` ADD `lowestusedpriceamount` FLOAT UNSIGNED NULL AFTER `listpriceformattedprice` ,
ADD `lowestusedpricecurrencycode` VARCHAR( 32 ) NULL AFTER `lowestusedpriceamount` ,
ADD `lowestusedpriceformattedprice` VARCHAR( 32 ) NULL AFTER `lowestusedpricecurrencycode`

2. added changes to relevant files

Result: no error messages but also no prices, also the field amazon price, which is topic here.

thanks

carpenoctem414’s picture

carpenoctem414 commented

it would be in interest if the "amazon price (numeric) and amazon price (formatted) is outputtet with amazon_module in amazon.us sites.
Here, with german amazon setting and drupal amazon module, it is empty. Tried alot without success.
Please see above--at amazon site direkt i get the needed dat, but not in amazon_module . Why? Curious

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Active » Needs review
StatusFileSize
new amazon.amazon_price_outside_us_879830.patch2.45 KB

OK, I think this does the job and fixes it. It turns out Amazon has a different merchant ID in each locale, and we were comparing on the US merchant ID.

Committed to D6: http://drupal.org/cvs?commit=437176
Committed to D7: http://drupal.org/cvs?commit=437178

rfay’s picture

rfay
he,him
Primary language English
Location Palisade, CO, USA
commented
Status: Needs review » Fixed

Will appreciate your testing and review.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.