Screen: ShopSite > Orders > Security > Remote Database > Wizard

Remote Database Wizard Steps

The Remote Database Wizard guides you through the steps of configuring ShopSite to store sensitive order information in a PostgreSQL database on a remote server. This makes it possible for merchants who store credit card information to comply with PCI Security Guidelines requiring credit card information to be stored behind a firewall.

ShopSite only stores order information in the remote database. The other databases (products, pages, etc.) are not put in the remote database.

In order to use a remote database, ShopSite requires a PostgreSQL database server accepting port connections and using username/password authentication. PCI guidelines require the database be located behind a firewall on a separate server from your ShopSite store. PCI guidelines also require that the password for the database conform to PCI standards (at least seven alphaumeric characters in length, using both letters and numbers). Contact your system administrator or hosting provider to learn how to set up your remote PostgreSQL database server.

You will need to know the following information about your remote database to configure ShopSite to communicate with it:

• Hostname - the domain name or IP address of the server hosting your PostgreSQL database.
• Port number - the port number on which your PostgreSQL database is listening for remote connections.
• Login name - the user ID to use when connecting to your database.
• Login password - the password to use when connecting to your database.
• Database name - the name of the database ShopSite should use to store order information in.

Before you begin configuring ShopSite to use a remote database, you should prepare your store by doing the following:

• View your orders - When you go to the Orders screen, ShopSite checks for new orders or updates to the status of existing orders, and updates the information in your order database. You should make sure your database has the most recent status for your orders before transferring orders to the new database.
• Delete old orders - The time it takes to transfer your orders to the new database depends on how many orders are in the current database. If you have a large number of processed orders that you don't need to keep, deleting them will save you time during the transfer.
• Backup your existing database - Before you do any major changes to your databases, you should create a backup in case anything goes wrong.

Once you are ready to configure ShopSite to use a remote PostgreSQL database, click Next.

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

ShopSite Shopping Cart Software