close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

products

Thread began 1/05/2011 6:44 pm by kleinermitzen420599 | Last modified 1/06/2011 9:58 am by Ray Borduin | 1102 views | 5 replies |

kleinermitzen420599

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

kleinermitzen420599

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

kleinermitzen420599

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?

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...