The feed to our affiliate includes:
a URL to the product page on our site
A url to an image on our site
A whole lot of other info (price, sku, ...)
A flag for "IN STOCK"
The hottest items will sell out first, so items in this table change often.
Our affiliate (AOL):
Displays our products like
http://shopping.search.aol.com/aolc/search?aps_terms=shoes&aps_referrer=TB&a
ps_category=ALL
When link to buy is followed, the product page
from our site is framed by AOL
They update once a day, but it can take up to
24 hours once a feed reaches them to "go live" on their site.
Unfortunately, AOL can not update as fast as our Finishline.com site, so AOL
will have dead links. We want to be able to track the number of dead links
to find out if we have a major or minor problem.
What would be the most efficient way to do this?
-----Original Message-----
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 10:57 AM
To: CF-Talk
Subject: Re: Looping 600 CFHTTP requests - Performance
Paul
I don't think I understand what you are doing... unless you are
dealing with one-of-a-kind items.
As I understand it:
You send the affiliate a "feed" of all all your in stock items...
what's a feed SKU & qty?
Some time passes and the affiliate updates their site
Now the affiliate wants to synchronize!
Couldn't it be done as follows:
1) record: the time when the affiliate feed was created.
2) When an item for an SKU is sold, returned, etc. then update "Last
Activity Date/time for that SKU with the current time.
3) To Synchronize, just Query the db for all SKUs with an activity
after the time when the affiliate feed was created.
4) Send this to the affiliate & record the time
This could be done multiple times or on a scheduled basis
This could be automated at both ends (especially easy if both hav CF)
You could probably approach up-to-the-minute synchronization.
Another way would be to allow the affiliate to access your db through
a program on your site (your program with any necessary security).
In effect, the affiliate, queries your db and gets live quantities.
I routinely do this when developing systems for a clients on a different
host.
HTH
Dick
At 7:29 AM -0500 5/22/01, Paul Sizemore wrote:
>We are supplying an affiliate with a feed of all our "in stock" items that
>are live on our e-commerce site, and there is a time lag between when we
>supply the file and when the affiliate updates their site. Many items are
>bought during this lag, and are out of stock by the time the affiliate gets
>the file live. I have built an application that will generate a report of
>dead links (items that are on the affiliates site, but no longer on our
site
>because of stock levels).
>
>The application reads the text feed, and then loops CFHTTP to validate the
>URLs. This process takes about two hours. Is there any faster way to do
this
>(e-commerce development is outsourced, and we don't want to pay for a
>trickle report of web purchaces)? Should I be doing this (will it cause
>problems for my server)?
>
>Thanks for any help.
>
>Paul Sizemore
>
>Finish Line
>3308 N Mitthoeffer Rd
>Indianapolis, IN 46235
>W: 317-899-1022 ext 3516
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
