ShopSite Database

Screen: ShopSite > Utilities > Database

ShopSite Database

This screen displays information about your ShopSite database and allows you to manage it.

At the top of the screen is the Database Information Table. This provides a summary of your database including the following information:

File Name - the name of your database file.
Active - the active (current) database information, including the following:
- Status - Click the Check Status button to update this field. You should avoid making changes to your database if your status is not OK. Click on the status text to see a detailed report on the database status.
- Last Change - the last time a change was made to the database. There are many features that can change the database, including changes to products or pages, orders, customer registration, coupons, reward programs, and gift certificates.
- Size - the size of the database file. The file size depends on what is in the database, and can be useful when compared with the size of the backup.
Backup - the backup of your database, including the following:
- Status - Click the Check Status button to update this field. You should not restore a database if the backup status is not OK. Click on the status text to see a detailed report on the database status.
- Completed - the date when the backup was created. To create a backup, click Backup.
- Size - the size of the backup file. You can compare the backup file size to the active database file size to see if significant changes have taken place since the backup was created.

Note:

If you have a Remote Orders Database, it will be listed below your main store database information. The remote database is managed separately from the main store database.

It is a good idea to backup your database before making any changes to it. The following buttons can be used to manage your database:

Upload	Click this button to upload Page or Product information to the active database.
Download	Click this button to download Page, Product, Order, or Associate information from the active database.
Empty	Click this button to empty the Page or Product information from the active database. This will completely remove all information from the selected section of the database.
Compact	Click this button to compact your active database. This will remove unused information and optimize the size of your database.
Backup	Click this button to create a backup of your active database. You should backup your database frequently, including before and after making major changes.
Restore	Click this button to replace your active database with the backup copy. You can restore only the Pages and Products, or the entire database. Any changes made to the database since the backup was made will be lost.
Check Status	Click this button to check the integrity of your database. This does not verify the content of the database, but does check the database structure. When you select Check Status, you will see the screen reload, and the database status will be displayed in the database information at the top of the screen. If the database status is anything other than OK, contact your service provider for technical support. You can click on the status text to see a detailed report on the database status.

When you are finished managing the ShopSite database, click Cancel to return to the Utilities screen.

ShopSite Help and Resource Center
Last updated: March 01, 2010
Give Feedback

ShopSite Shopping Cart Software