ProductCart v5 requires a MS SQL DatabaseProductCart requires a MS SQL database. MS Access, MySQL or Oracle databases are not supported.
A ProductCart-powered store typically requires around 100MB of SQL storage (around 30MB upon installation, but then the figure grows as products, customers, and order data is saved to the database).
MS SQL vs. MS SQL Express
Make sure to setup the database right after moving the files to the server that will host the store, and before you attempt to activate the product. That is: do not run the ProductCart Setup Wizard unless you have setup the database. Otherwise you will get an error during the activation process.
If you are installing ProductCart locally on your desktop for testing or development purposes, see the section below about using MS SQL Express. If you are not comfortable setting up the SQL database:
- If you are buying ProductCart from NetSource Commerce, you can choose the installation service before or after you purchase the software, and the SQL database will be setup for you
- If you are buying ProductCart from a ProductCart reseller, ask them for assistance with this task
ProductCart’s SQL database has been optimized for use by small businesses. If your database contains a large number of products and other data, we recommend that you consult a database administrator (DBA) to further optimize it to achieve higher performance. As your database gets larger and larger, a good practice is to have a DBA optimize it every few months.