Google Answers Logo
View Question
 
Q: Create a database driven inventory ( No Answer,   3 Comments )
Question  
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.
Answer  
There is no answer at this time.

Comments  
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 =-

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy