schedule order download

[anqi]

I recently extended stock control to be more "real" time. I wrote a script (in php and outside actinic) and schedule it to run every 10 minutes to check if stockonhand changes. If changes, log the change, and update the stock level at the live server, and if any products go out of stock, hide add to cart button and show out of stock message.

My script does not restrict people adding an out-of-stock product into cart as actinc perl does, because I know nothing about fil file generated by actinic. It only hides the button, and so far so good - no one seems to be interested in hacking the code and ordering something explicitly out of stock.

However, actinic stock level changes only when some staff clicks download in actinic. My question is

Is there a way to download orders automatically? Something like command line download would be perfect. Basically I am looking for a solution which can sit in scheduler.

Am I asking for something impossible? Any helps are highly appreciated.

anqi

[leehack]

Mole End do an upload and download scheduler and rmorrow has a real time stock plug in. V10 will have real time stock too, choices choices lol.

[pinbrook]

mole end sell an app that includes this - so yes it is possible.

[TraceyHand]

mole end sell an app that includes this

"there's an app for that"

[pinbrook]

"there's an app for that"

LOL i got iphone on the brain gonna give up my blackberry

[anqi]

I'm sorry but really I'm look for a diy solution.

Actinic site has big limitations we can't overcome, so the company stopped investing in it just for patching it. (If we follow the road of patching, sooner or later we will need another patch...) As an old user of Actinic, I just want to do something I can to extend life of the old site.

[anqi]

Just for anyone wants similar automation -

After 101 times search, I found this thread

http://community.actinic.com/showthread.php?t=38019

I'll give it a try and post back.

[anqi]

Command line {pathToActinic}\catalog /d works very well.

Just for anyone interested in my realtime stock control, here is my approach:

1. setup a local database (can be on the same machine where actinic is installed, mysql or sqlite would be the easiest way to implement, it is to avoid causing loads of unnecessary traffic to the live site)

2. setup a remote database at live site (mysql or sqlite)

3. schedule download happens every 10 minutes using {pathToActinic}\catalog /d in windows scheduled tasks.

4. write a script to read fields nStockOnHand and bStockEnabled of Product table from dsn or mdb, compare with the fields in local database. if changes are found, update the remote database. my script is in php, scheduled to run every 10 minutes.

5. change actinic template, move the stock control logic from offline to online.