Ecommerce Templates > General Help > The Control Panel > Admin database utility

Admin database utility

The admin database utility allows you to do some "housekeeping" on the database directly from your store control panel. You will need to be using the Firefox browser and the features available differ between the ASP and PHP versions.

admin database utility

Check for broken image links

This handy feature will check all your products for broken image links. Once completed it will provide a table of products where the the image link is broken along with a link to the product in the admin making it simple to fix.

Reorder images in database

This is a streamlining / housekeeping feature to make sure the images in the database are in sequential order.

Set database collation (PHP only)

This is more of an advanced feature and it allows you to set the collation of all the database tables and columns. Normally you wouldn't need to make any changes here but if you are having problems with character encoding for example this may be the simple way of fixing it. The most common collations are latin1_swedish_ci and utf8_general_ci.

Optimize Database (PHP only)

This utility will automatically optimize all the database tables for you.

NVARCHAR to VARCHAR (ASP only)

By default the database creation script used to use NVARCHAR for text fields. Now VARCHAR is used but databases that were created with the older scripts have the tables created with NVARCHAR. Switching to VARCHAR should improve the performance of the database.
Please Note: NVARCHAR is only required for wide character sets like Japanese or Chinese