I am creating a website that has items customers can purchase, cart manager is the program I use to collect the information, which is then retrieved from a secure server and manually processed.
What I am hoping to do is create a MS Access Database with all my part numbers and prices in the following format
Database File-Table:Category-Item Number & Price
I would like my website to access the DB file and pull the current pricing from it, then display that price in the proper location as well as inserting it into the code for cart manager.
For reference the cart manager code is in the following format:
Code: Select all
<form method=POST action="https://www.cartmanager.net/cgi-bin/cart.cgi">
<input type=hidden name=additem value="cartid|itemname|itemcost|itemquantity
|itemno|itemhandling|itemshipmethod|itemweight|itemexempt|itemdiscount
|itemsilentpost|itemdropshipzip|itemESD|itemRecurring">
<input type=submit value="Add To Cart">
</form>
The itemcost is the only part that needs to be dynamically changed, though if the implementation of this is fairly simple I may extend it to the description as well.
Then if pricing ever changed a simple change in the database would be reflected wherever the instance occurred on the site.
Thank you for any help you can provide!