uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
Database in MS Access 2000 - 3000 products?!

Knowledge Base Lobby : uShop Support Conference : Programmer Tips
Nov-22-17 03:29 PM EST
Original Message
Database in MS Access 2000 - 3000 products?!
Author kachurak on 06-04-2000 at 19:56 (EST)
One question that is similar to one in a previous post. I am hosted on an ASP capable server. I was wondering if anyone could tell me HOW they use the database to use conjunctively with UShop? I'm a little confused as to how this would work. You can obviously see WHY I'd like to use it with that many products. FYI; I have the full version UShop and will probably need to get the Authorize.net addin. Thanks in advance!
E-MAIL AUTHOR | TABLE OF CONTENTS

Table Of Contents
  RE: Database in MS Access 2000 - 3000 products?! Bill Weiner, 2000-06-05 05:40:36 (1)
  db driven ushop Charlie Edmunds, 2000-06-05 18:33:44 (2)

Messages In This Discussion
         1. RE: Database in MS Access 2000 - 3000 products?!
        Author Bill Weiner on 06-05-2000 at 05:40 (EST)
I know some people have ended up developing their own CGI or ASP interface to their own database. This basically involved making a script that queries the database and then dynamically generates the product pages with the uShop applets on them.

I personally, am not familiar with interfacing ASP to MS Access, but perhaps anyone else using this forum may have some tips on that. Suggestions anyone?.....
TABLE OF CONTENTS
         2. db driven ushop
        Author Charlie Edmunds on 06-05-2000 at 18:33 (EST)
Kachurak,

Instead of hard coding your product information via html into your pages you start by entering all your product info into the database. Typical fields might include:

ItemID
ItemName
ItemDesciption
ItemSKU
ItemPrice
Item Size
ItemCategory

The ItemCategory field is important so you can organize your items.

Having your items in a database allows for extensive searching and flexible presentation possibilities. For instance: You could perform a query that would search for items that had a category of xxx and price less than xxx.

Typically the output of the query loops a data structure which includes the applet parameters being populated by the query results. Each application server (PHP, ASP, Cold Fusion) has a different syntax but the principle is the same. If you experiment with ASP you'll quickly see that it's easy to populate the applet parameters with the results of a query. Database driven web apps allow you to update your site via the web. In other words, no page editing required when you change your inventory.

If you pursue a db driven ushop, start simple, work your way into more sophisticated applications.

Good luck,
Charlie Edmunds
Micrburst Technologies, Inc.
TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.