RE: completed orders database

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 13548
interpreted = N
texte = Richard ->IS there any way I can write completed orders, which have a text file in>the completed orders folder, to one database file?>I want to be able to search this combined database as needed to see what>products have been purchased, when, etc.>At what point does webcatalog create this completed order file?>Can I get into the steps somewhere and have the completed order appended>into this database i want to create?>I certainly can manually combine these files into one, but I would>prefer the process to be automatic, so that when a purchase is made,>that line is written into this file without my intervention.As Grant suggested, you can have all your orders written to a separate pending orders database using an embedded [append] command on your ThankYou.tmpl page - this is more or less what we will be doing with the StarNine store.You can then have a set of administration templates that you manually go and load (once a day, once a week, whatever) that use [listfiles] to check both the Completed Orders and Problems folders and set the status of orders in the pending orders database to successful or failed. This way you can search that orders database for your complete order history and display any kind of reports you like.I hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

RE: completed orders database (Marc Eagle 1997)
Re: completed orders database (Grant Hulbert 1997)

Richard ->IS there any way I can write completed orders, which have a text file in>the completed orders folder, to one database file?>I want to be able to search this combined database as needed to see what>products have been purchased, when, etc.>At what point does webcatalog create this completed order file?>Can I get into the steps somewhere and have the completed order appended>into this database i want to create?>I certainly can manually combine these files into one, but I would>prefer the process to be automatic, so that when a purchase is made,>that line is written into this file without my intervention.As Grant suggested, you can have all your orders written to a separate pending orders database using an embedded [append] command on your ThankYou.tmpl page - this is more or less what we will be doing with the StarNine store.You can then have a set of administration templates that you manually go and load (once a day, once a week, whatever) that use [listfiles] to check both the Completed Orders and Problems folders and set the status of orders in the pending orders database to successful or failed. This way you can search that orders database for your complete order history and display any kind of reports you like.I hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/ Marc Eagle

DOWNLOAD WEBDNA NOW!

RE: completed orders database

1997

Top Articles:

Related Readings: