Micki's Database Interface Guide

This document describes how dealers can easily interface to Micki's catalog database from their web site. Pictures, product descriptions, sizes, and prices may be easily incorporated into any web site.

This is the initial release of this interface. We anticipate that additional features will be requested, and will make a reasonable effort to accommodate everyone.  Click here to contact Dennis Hevener, the project manager.

Data may also be downloaded in a tab-delimited text file for importation into your shopping cart database. Click here for details.

System requirements

System requirements are minimal.  All that is required is that the browser being used to view the site support Javascript. There are no special requirements for the web site or web server.

Functional overview

The MEI Interface system generates a custom JavaScript file of the requested catalog items. It is called by placing a script tag similar to this in your web page:

<script language="javascript" 
src="http://interface.mickisonline.com/JavaScriptCatalog.aspx?Account=1234&StoreID=1&CatID=2&SubCategoryID=2&Columns=5">

Place the tag where you want the product listing to appear. It may be in a cell of a table on your web page, for instance.

Note that your account number must be passed to the interface.  Obtain your account number by calling 770-307-1511, or go here and email us. You may use account# 1234 for testing purposes.

Click here to see a working  example of the interface. Click View Source in your browser to see the implementation.


Optional Parameters

You may limit the display to certain product lines, categories, and subcategories. Additionally, you may specify other options.

Columns Number of columns used to display the product information.  The default is 1.

Selection criteria

The following parameters permit you to select product lines (stores), categories, and subcategories. To see a list of valid values for each parameter, clck here. If a parameter is omitted, all entities are selected.

StoreID

CatID

SubCategoryID

 

Generation of data for importing

You may download the data for imporation into your own shopping cart database.  Data is extracted from the database in real-time, so your download will always be up-to-date. Data is in tab-delimited format with column headers.

The URL to generate the data is:

http://interface.mickisonline.com/CatalogDumpTab.aspx?Account=1234

Selection criteria parameters may be passed as described above for the Javascript Interface to download only selected records.  Here is an example:

http://interface.mickisonline.com/CatalogDumpTab.aspx?Account=1234&StoreID=1&CatID=2&SubCategoryID=2

Be sure to pass your proper account number. If  use the test account# of 1234, only few records will be generated for test purposes.

Your generated data will be available indefinately  for later download. This feature will allow you to, for instance, write your own program that generates, downloads, and imports the data, without concern that your download will be deleted from our server before this process completes.  However, it is important that you always run CatalogDumpTab.aspx before downloading. Otherwise, new products, or changes to existing products, will not be available to you.

Sept 14, 2007