Database Types

The following table compares the pros and cons of each database types, please read carefully and choose according to your needs: 

  JavaScript Microsoft Access SQLite MySQL
Server OS Any Windows only Linux/Windows Linux/Windows
PHP and its extension Not required

PHP 5 (The Windows version of PHP has built-in support for COM functions.)

PHP 5 and PDO_SQLITE extension PHP 5 and MySQL extension
Database server Not required Not required Not required Requires MySQL 4.1 or later
Output database Output to a JavaScript file named ewcartdata.js. You need to upload the file to your server together with other generated files.

Output to a sub folder named download\db_<random> (where <random> is a random string for your project) under the destination folder during generation. You need to upload the database to your server together with the generated scripts.

IMPORTANT NOTE: You need to enable write permission for the download folder on your server. See Introduction to PHP on how to configure write permissions.

Output .sql script only, you need to create the MySQL database on the server using the .sql script yourself. Click the [...] (or click [Tools] in the top menu and select [Connection Properties]) button to open the Connection Properties form and enter the database connection properties.

Update database on the server by PayPal Shop Maker Not supported. You need to update manually (see below).

If you update your product info later, you can update the database on the server with PayPal Shop Maker:

  1. If you use item count to track your inventory level, download the counts from the server first, click the button [Synchronize]->[From Server],
  2. Update product info and the counts,
  3. Click the button [Synchronize]->[To Server] to upload the updated data to the database on your server.

Also see the section Synchronizing Product Information with Database on Server in Product Settings for more information.

Update database on the server manually Upload the re-generated ewcartdata.js to your server again.

Methods:

  1. Download database from the server (by FTP) to your project folder, open PayPal Shop Maker to update and then upload the database back to your server.

  2. Download database from the server (by FTP) to your project folder, open the database directly with Microsoft Access to update product info and then upload the database back to your server.

Methods:

  1. Download database from the server, open the database with your own SQLite manager, update product info and then upload the database back to your server.

  2. Use your favorite web based SQLite admin scripts on the server to update the database directly.

Methods:

  1. Use [Synchronize]->[From Server] to download data from server, update and output .sql script with PayPal Shop Maker. Then use the script to update the database on the server with your favorite MySQL manager.

  2. Use your favorite web based MySQL admin scripts on the server to update data in the database directly.

  3. If the MYSQL server supports remote connection, use your favorite MySQL manager installed on your PC to update the remote data directly.
Supported features

The following features requiring PHP and/or database are NOT supported:

  • Check item count before adding to cart
  • Skipping PayPal
  • IPN
  • PDT
  • Digital Good Download
  • Discount code
  • Transaction log

 

All features are supported. All features are supported. All features are supported.
Expected database size Small Small to medium Small to medium Small to large

 

 

 

 

 

 ©2008-2011 e.World Technology Limited. All rights reserved.