pbxinaflash and oscommerce

[rlclemmons]

I am still a asterisk noob, so please bear with me.

I have a vision of using asterisk to connect to my cre loaded (oscommerce) shopping cart which is php based. I would like for a customer calling in to check order status to enter their order number and authenticate by zip or some other means like a phone number or something. Allison would then gently tell the order status and repeat the shipping method and tracking number(s) associated with the order.

Has this already been accomplished with pbiaf? Or is this a really really bad idea? There of course needs to be a serious level of security for obvious reasons.

Thanks

Rick

 

[wardmundy]

It's a really good idea, and we would love to partner with someone willing to invest a little to make it happen... so long as the resulting product could be distributed either at no cost or at a very modest price point. Drop me a note if you'd like to discuss it further.

 

[Phone_User]

One stumbling block that I ran into when doing something similar is you will need your asterisk box to be able to connect to your database that holds the transactions and order detail.

If your commerce site is outside of your lan or hosted on a provider you may have big hurdles to be able to connect to it and get the info needed.

With that said ... It is not impossible to do.

 

[claudiopizzillo]

No need to connect to remote database.
I used the curl command in dialplan to pass and retrive infos from web servers.

An example:
1) asterisk send (via curl: http data) the order number to a php page (on the remote web server) end receive the id of the transaction.
2) asterisk send the id to another php pages and receive the order datas.

 

[noblenull]

Allison would then gently tell the order status and repeat the shipping method and tracking number(s) associated with the order.

If shipped - you could also have her give the scheduled delivery date from UPS.

 

[Phone_User]

No need to connect to remote database.
I used the curl command in dialplan to pass and retrive infos from web servers.

An example:
1) asterisk send (via curl: http data) the order number to a php page (on the remote web server) end receive the id of the transaction.
2) asterisk send the id to another php pages and receive the order datas.

Hmm, so do you just figure out the info needed to send to a lookup page that will give you the order info or is this a special PHP page that was created for this purpose? If I follow correctly you get the info from caller, send it to the php page get results and populate some variables with it. Can you elaborate more. This is very interesting.

 

[noblenull]

Yes, you could create a page for this purpose that would take the inputted info (order number, zip code, security key for example) and return the info you needed (probably in XML).

 

[claudiopizzillo]

Yes, or xml or | separated (need a simple split)

 

[rlclemmons]

anyone have some example code to start off with?