For some time, the amazon nodes, that have been created in Drupal, are redirected to the Amazon-homepage (http://www.amazon.de/gp/homepage.html/...), not to the reviewed product's page. This happens not with all nodes, and not all the time with the same node. As far as I can tell at the moment, only the most recently created amazon nodes still do link to the product page at Amazon; mostly older amazon nodes (3 day old, 3 months old...) redirect to the Amazon-homepage.

Maybe Amazon has tampered with the API, however, the operation of the Amazon associate tools at the moment ist really annoying, dissatisfying and driving users away :-(

Again, this applies to Amazon.de; I don't know if the bug does occurs on the other Amazon-sites around the globe.

Regards, -asb

CommentFileSizeAuthor
#5 amazon_4.module53.46 KBPrometheus6

Comments

Prometheus6’s picture

Sorry, I been busy. Do you still have the problem? Sometimes Amazon slips.

asb’s picture

> Do you still have the problem? Sometimes Amazon slips.

I observed this for some time, and I can't reproduce the behaviour; sometimes the nodes link to the Amazon homepage, sometimes they lead to the product page; maybe it's Amazon, maybe the script, I am unable to diagnose it further.

However, I discovered that approximately since these bizarre redirects started to occur about two months ago, Amazon stopped counting _any_ referrals. I checked this several times by buying covertly through the Amazon associate tools - none of these sales were registered. Something here is seriously broken, but also it might be Amazon.

Regards, -asb

asb’s picture

The code the amazon tools are generating seems indeed to be completely broken for months; see http://drupal.org/node/82717 and http://drupal.org/node/88759. Since he Amazon Associate ID is neither embedded in the referring URL nor in the database, this is most probably the reason why Amazon doesn't process the strings as expected.

There is a "lazy hack fix" described in node http://drupal.org/node/82717, but this does apply to newly created amazon nodes only. At my site, some 10k nodes are broken which have to be repaired manually in the database tables. Since I am not sure how the links have to be formatted correctly, this is very, very annoying :-(

Regards, -asb

Prometheus6’s picture

I posted some patched files at http://drupal.org/node/88759

10K nodes, huh?

I hate to set a precident, but give me the weekend and I'll write something to force updates.

Prometheus6’s picture

Assigned: Unassigned » Prometheus6
Status: Active » Fixed
StatusFileSize
new53.46 KB

The admin/amazon page now has a tab with controls to let you mark all Amazon items as needing a price refresh (which refreshs all data, including links), and to force that refresh.

Records are normally refreshed when they get to be a week old, and ten records at a time are updated because that's the maximum records returned per query. I let you run the Amazon cron job from the new page.

Because I have no idea how long your TTL is set for, you can try to refresh them all in one shot or pick 1-5 loops. I'm kind of rushing here, but if you take a look at it, I think it's pretty clear. And it's been committed...everyone gets it.

asb’s picture

Priority: Critical » Normal
Status: Fixed » Active

> The admin/amazon page now has a tab with controls to let you mark all Amazon items as needing a price refresh [...]

Where can I find this tab? In the last version I installed (dated 2006-10-25), I can't find it neither under /admin/settings/amazon not under the blocks configuration.

Regards, -asb

Prometheus6’s picture

/admin/amazon

It's a tab connected to the query/import page.

asb’s picture

> /admin/amazon
> It's a tab connected to the query/import page.

Import page, not settings? Where else. /admin/amazon doesn't exist at my installation, that one here is called /admin/amazon_import/. And indeed, under /admin/amazon_import/manage, there's a new tab. However, refreshing prices which are displayed wrongly anyway (as I pointed out months ago) seems not to make much sense to me.

Prometheus6’s picture

Where else. /admin/amazon doesn't exist at my installation, that one here is called /admin/amazon_import/. And indeed, under /admin/amazon_import/manage, there's a new tab.

That's what I get for typing from memory.

There's nothing I can do about the prices being in Euros.

asb’s picture

> There's nothing I can do about the prices being in Euros.

That's not the point. The point is, that the prices the Amazontools are displaying in Amazon nodes (labeled "amazon price:...") is usually *not* not the actual price Amazon is selling the product for, but the suggested retail price of the manufacturer respectively the publisher. The point is, that the "amazon price" the Amazontools are displaying usually won't be the price Amazon is selling the item for. The problem of this is, that the *real* Amazon price usually will be significantly lower than the one Amazontools is displaying. It' simply wrong. As I pointed out a few months ago, there might be a few cases when both amounts are identical, e.g. books in Germany which have a fixed price which is not allowed to be reduced by a bookseller; then, but only then, the prices displaed by Amazontools will be correct. But the normal case is, that the "amazon price" will be wrong. Sometimes Amazon displays the difference by a notice like "you save that large amount 'n' if you buy here". That's also the reason why all recently imported products have wrong price tags (at least in my installation).

All the correct data exists in the the database table 'amazonitem' if I remember correctly; Amazools is just displying the data from the wrong database field. This has nothing to do with the currency or the fact, that the data in the database might be outdated (which might be updated by the new tab which I will evaluate in a few months, when the wrong affiliate ids hopefully will be purged from my database).

This can be fixed by (a) exchanging the label of the price tag for "amazon price" by "suggested retail price", or (b) by displying the correct field from the database.

However, this applies solely data imported from for Amazon.de; Amazon.com or othe subsidaries might label or use the fields differently.

Regards, -asb

MGParisi’s picture

Status: Active » Closed (fixed)

sorry 4.7 is no longer supported!