|
|
Subject:
Create a database driven inventory
Category: Computers > Programming Asked by: jwswholesale-ga List Price: $10.00 |
Posted:
12 Mar 2005 09:26 PST
Expires: 11 Apr 2005 10:26 PDT Question ID: 493243 |
I would like to know if it is possible for me to create a database with all of my inventoty numbers in it, then have it linked to the respective product pages? My inventory updates daily and I would like to have an updated product page as often. Is this possible and if it is, what do I need and how can I do it? Any and all information would be great. |
|
There is no answer at this time. |
|
Subject:
Re: Create a database driven inventory
From: dreamboat-ga on 12 Mar 2005 10:00 PST |
I assume you mean on the web. First, depending on the hosting you have, the programming language used is PHP or ASP (generally). If you have PHP, then you could likely get some software like this: http://www.websitedatabases.com/ or find a PHP coder that knows how to program these things. I also found this very cool site: http://www.freewebmasterhelp.com/tutorials/phpmysql/1 Most hosting comes with the capability of having one or more databases; some charge extra for it, some don't. If you don't have hosting yet, I suggest PHP because it seems to be much more predominant and easy to get source code--lots of forums share this code. ASP seems to be another story. It's been my experience that the coders are more expensive, and so is the software. And there's really no benefit over PHP. I also like www.lunarpages.com for their consistent uptime, but they only include 1 database--tho this is enough for you. Your question may be simple, but the answer(s) depend on many things. You could either hire someone to do this work for you, and then not have to learn it; or learn how to do it yourself, which will likely take a few months of trial and error. |
Subject:
Re: Create a database driven inventory
From: jwswholesale-ga on 12 Mar 2005 10:15 PST |
Thank you for the info. I have a website (www.jwswholesale.com) and it is in .asp. I would like to learn this myself, as I have taught myself everything else I know about web design, etc. Again thank you for the help. |
Subject:
Re: Create a database driven inventory
From: homebizhosting-ga on 26 Mar 2005 07:52 PST |
It you were on a Linux platform instead of a Windows platform, I would tell you that some shopping cart software called "OSCommerce" can allow you to do this. What you would do is have a web developer download and set this software up for you (it's PHP code). Now, from here there are two ways to do this: 1) Have your developer download and install a special add-on module for OSCommerce called "Easy Populate". This would allow you to have your database on your PC in either Excel or Access format (or even a comma-separated-value file)... and then you could use Easy Populate to upload this into OSCommerce. or 2) If your webhost allows remote connections from your desktop to the MySQL database that OSCommerce runs off of... you could make an Access database of products on your PC... and then make a special kind of connection called a "ODBC connection" to the database on your website... in order to update your database. With this method, every time you updated a field on your Access database, it would go out and update the MySQL database on your website. Setting this up takes a little effort, but it should provide the real-time updates that you desire. Of course, you're on a Windows server, it seems. But even then, are your products currently stored in an SQL database on that windows server? If so, I would think you could set up Access to make a similar ODBC connection in order to make "real time" updates to your website store.... from your PC. Thanks! -= Dave =- |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |