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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to