Products | Scripts | Services | Tutorials | Books | Links | Contact | Bulletin Board

The CITY Shop

Overview | Concept | Licensing | Demo/Download | Installation | Gallery | Last Updates | FAQ

Templates | Views | Engines | Libraries | Main Setup | Shop Setup | Database | Session | Shipping

Demo / Download

This page was last updated on: 20. December 2002

We have demo links, on both major platforms (Unix/MS), that use a sample database. Most of the features implemented in the shop are present in the demo. We will list a couple of them, and where to find them:

The CITY Shop - The Shop Manager

The user id and the password for the shop manager is "admin". Please don't mess up the database too much, now that you have access :).

Before you start downloading, please note that:

Upselling products is set up currently as follows:

  • Every category and subcategory upsells all its items (I might have missed entering a couple though)
  • The main page, the cart and the search result page upsell all the items in the database
  • The selection of the items to be upsold is made on the following principle:
    - no item displayed in the actual page display, cart item, or search result, will appear in the upsell list
    - the number of upsell items shown at the same time can be set in the upsell database

The user database(s) can be accessed under "My Account", where the users can create/edit/delete their billing/shipping records, as well as the credit card records on file. Currently the card numbers are being saved unencrypted in the "usercreditcard.db", so make sure your server security is tight enough. The user password is saved in clear text, it could be encrypted on request.
The shop offers as well an overview over the orders placed, and the online delivery contents.

The tax is being calculated either for the US/Canada states, or for the other countries, using the "states.db" and the "countries.db"

There is a table in the database that offers extensive support for tax models.

Product options are supported throughout the shop. You can apply discounts or markups for every value of the option, either as a fix amount, or as a percent, how you feel like it.
The language content of the options is contained in the same file, although it could be implemented separately, if need be. At this moment, only English and German is implemented, you can add more languages as you need. The procedure will be explained in the description of the shop views and templates.

The orders are saved in two different ways. For one, every order is saved as a text file, with the name of the order number. These files can be found in the folder: shops/city/Logs/orders.
Every order is then saved in the file "orders.db". With the order, we save the billing and shipping addresses, the total, the payment and shipment mode, as well as the list of the items and options ordered.
Since we want to save the products with all the options as well as the prices at the time of purchase, and the number of items and options is variable, we choosed to save the order content in a separate table, "orderdata.db" one item at a time.
Additionally, the orders can be mailed to both the user and the admin.

The payment options are multiple. Along with this shop, we developed a common payment gateway, named "EPI" (E-Payment Interface). We distribute the shop with plugins for a host of gateways, please check here for a complete list.

If somebody can provide documentation for other gateways, we could develop plugins for those gateways as well.

We implemented a bare-bones advertising mechanism, which is represented by the promotional links that we display on the main page. You can, if you wish, define for every major shop area, a different set of links you want to display. Later on, we will eventually build an ad manager for the shop, as a plugin.

Shipping is being calculated only for the UPS shipping carrier, and some simple mapper schemes. We did not invest any time yet to implement shipping tables for USPS and/or FedEx, but we have that in our plan. From certain sources we heard that the online gateway for FedEx is returning erroneous rates, so we are not in a hurry to implement something that could be broken from the get-go.

The search is performed against the main product database. We did not implement (yet) a search for the html static content, as we do not have static content in the first place. As soon we will come up with the support for the static product pages, the search for those pages will be as well available.
Also, the search is being performed against the active language content. That means, if a visitor opts for the German content, only the fields with German language content will be searched, along with the other generic fields.

DOWNLOADS:

Please remember that the advertising information should remain on the pages where it is, if you want to use this shop for free. For pricing information for the unrestricted version, please check the main page.

You can download the script at the following locations:

Please read the updated info on the last updates page BEFORE you download!

Download the NT zipped version here

Download the tar/gzip version here

If you cannot find the tar/gzip file, that means that the zip file has been updated, and no tar was made yet. You can use the zip file, and make the changes to accommodate your system, as described in the "Install" section.

Here is a download link for the development release. Note that this zip is the latest code in work, and might not be 100% functional.