|  | Database in MS Access 2000 - 3000 products?!
|
| 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!
|
|
| | 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?.....
|
|
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.
|
|
|
|
uShop English (U.S.) for 179!
uStorekeeper English (U.S.) for 149!
Products