products

Where am I supposed to store all the product information? Please don't just give me a link. I have read the online manual and it doesn't say. unless I missed something. And if so, what page is it on?

Where do you want to store the product information? Are you talking about pre-purchase or post-purchase? The answer is probably in a mysql database or on the page in the add to cart server behavior depending on your catalog and how you want to manage the product information.

Originally Said By: Ray Borduin

  Where do you want to store the product information? Are you talking about pre-purchase or post-purchase? The answer is probably in a mysql database or on the page in the add to cart server behavior depending on your catalog and how you want to manage the product information.  

I wanna know if there is an eCart function that can mess with the database table. Because if someone buys a product, I want the amount in stock to be subtracted by the amount that was bought. What is the easiest way to do this?

Usually I would suggest to log the purchase in a separate table and use a query to subtract the amount sold since the inventory was last recorded from the original amount without actually updating the inventory in the product database itself. It is a cleaner way to handle returns and doesn't have you constantly updating the product database.

This is what we do in Powerstore, and in general what I have found to be the cleanest method to do inventory control.

Originally Said By: Ray Borduin

  Usually I would suggest to log the purchase in a separate table and use a query to subtract the amount sold since the inventory was last recorded from the original amount without actually updating the inventory in the product database itself. It is a cleaner way to handle returns and doesn't have you constantly updating the product database.

This is what we do in Powerstore, and in general what I have found to be the cleanest method to do inventory control.  

There is an unknown error when i try to connect to a database. What am I supposed to put into the fields? I put the username password and the host IP address including the database name which i have already set up. does the connection name have to be something specific? I've tried my database name which is "test" and I have tried "my username"_test. and it still won't connect. What could be wrong?

It could be a problem with your site settings in general and not a problem with the database settings themselves. Have you gone throught the free Webassist database starter kit? It walks you through all of the gritty details in much more detail than I could here.