miva masochists guild

home
Merchant
FAQ
Links
News
Rants
Info
 


These are mainly guesses (i.e. these are NOT documented or official formats!) about how some of the files Merchant uses are laid out. Some were just opened in Access or dBase and looked at, others were determined through blandly staring at the CONFIG.MV, UTIL.MV, and DB.MV code until something looked reasonable.

DO NOT TAKE THESE FILE FORMATS AS GOSPEL.
All were originally for Merchant v1.25 but
were modified for the v2.0 versions.
The formats for v3.0 will be available after it is released.

They are better than nothing, but not much. I started them a long time ago and some might have changed. I keep planning to expand and define all the files at a later date, and it never comes. Maybe for v3.0. For now this is all we got:

 

ADMSESS.DBF - administrative session cookie reference
Field Name Has What Is Type Size
SESSION_ID Cookie/Session ID Character 40
USER_ID Admin user ID Numeric 19
LASTUPDATE Last session time (dBase date form) Character 10

 

AGPXCAT.DBF - cross-references the availability group categories
Field Name Has What Is Type Size
AGRP_ ID Availability group # Number 19
PRODUCT_ID Product ID Number 19

 

AGPXCST.DBF - cross-references the availability group customers
Field Name Has What Is Type Size
AGRP_ ID Availability group # Number 19
CUST_ID Customer ID key Number 19

 

AGPXPROD.DBF - cross-references the product availability groups
Field Name Has What Is Type Size
AGRP_ID Availability group # Number 19
PRODUCT_ID Product ID Number 19

 

ATTR.DBF - references the product attributes, along with OPTS.DBF
Field Name Has What Is Type Size
ID Primary attribute key Number 19
PRODUCT_ID Product code (SKU) Number 19
DEFAULT_ID Which attribute is default Number 19
ORDER Sort order number Number 19
CODE Attribute code Character 50
TYPE Attribute type (radio, drop-down, checkbox, or text-entry field Character 20
PROMPT Client-displayed prompt Memo n/a
PRICE How much $$.$$ to add (if any) Number 10.2
REQUIRED Whether it's mandatory Boolean 1

 

AVLGRPS.DBF - availability group number/name reference
Field Name Has What Is Type Size
ID Group ID number Number 19
NAME Group name Character 40

 

BASKETS.DBF - Holds the basket contents
Field Name Has What Is Type Size
ID Primary Key (Basket ID) Numeric 19?
LINE_ID Invoice line number Number 19
PRODUCT_ID Product SKU ID Number 19
CODE CatCode from products.dbf  Character 50
NAME Product Name Character 100
PRICE Cost of Item Number 13
WEIGHT Shipping Weight of Item Number 13
TAXABLE Is Item Taxable Boolean 1
UPSOLD Is This An Upsold Item Boolean 1
QUANTITY Quantity Ordered Number 13

 

BASKLIST.DBF - Holds customer info & other order-dependant stuff
Field Name Has What Is Type Size
SESSION_ID Primary Key (Cookie Name) Character 40
CUST_ID Customer ID Number 19
BASKET_ID Key from BASKETS.DBF Number 13
LAST_UPDATE Basket Time stamp (dBase format) Character 10
ORDER_ID Order ID number  Number 19
ORDER_PROC Order processed flag Boolean 1
SHIP_FNAME Ship-to First Name Character 50
SHIP_LNAME Ship-to Last Name Character 50
SHIP_EMAIL Ship-to Email Address Character 50
SHIP_COMP Ship-to Company Name Character 50
SHIP_PHONE Ship-to Phone Character 50
SHIP_FAX Ship-to Fax Number Character 50
SHIP_ADDR Ship-to Address Character 100
SHIP_CITY Ship-to City Character 50
SHIP_STATE Ship-to State Character 50
SHIP_ZIP Ship-to Zip code Character 50
SHIP_CNTRY Ship-to Country Character 50
BILL_FNAME Bill-to First Name Character 50
BILL_LNAME Bill-to Last Name Character 50
BILL_EMAIL Bill-to Email Address Character 50
BILL_COMP Bill-to Company Name Character 50
BILL_PHONE Bill-to Phone Character 50
BILL_FAX Bill-to Fax Number Character 50
BILL_ADDR Bill-to Address Character 100
BILL_CITY Bill-to City Character 50
BILL_STATE Bill-to State Character 50
BILL_ZIP Bill-to Zip code Character 50
BILL_CNTRY Bill-to Country Character 50
TAX Tax amount on order Number 13
SHIPPING Shipping cost Number 10.2
SHIP_ID Shipment Method Key# Number 13
SHIP_DATA Shipment Method Description Character 100
PAY_ID Payment Type Key# Number 13
PAY_DATA Payment Type Description Character 100
TOTAL Order $$.$$ Total  Number 10.2

 

BASKOPTS.DBF - references the basket content options.
Field Name Has What Is Type Size
LINE_ID Basket line key Numeric 19
ATTR_ID Attribute Number Numeric 19
ATTR_CODE Attribute Code Character 50
OPTION_ID Option reference Number 19
OPT_CODE Option code name Character 50
PRICE Option price Number 10.2
DATA Option description Character 254

 

BATCHES.DBF - batch control file
Field Name Has What Is Type Size
ID Batch ID # (Key) Number 19
DATE Batch date (xBase format) Character 10
NAME Batch name Character 100
CLOSED Closed yet (Y/N) Boolean 1

 

CATS.DBF - contains the product categories
Field Name Has What Is Type Size
ID Primary Category Key # Number 19
PARENT_ID ID of the parent Number 19
AGRPCOUNT Availability group key Number 19
ORDER Order number Number 19
CODE Category Code Character 50
NAME Category Name Character 100

 

CATXPROD.DBF - cross-references the products to categories
Field Name Has What Is Type Size
ID Category ID Key# Number 19
PRODUCT_ID Product ID Key# Number 19
ORDER Sort precedence order Number 19

 

COUNTRY.DBF - Mall Country name/id file
Field Name Has What Is Type Size
NAME Country Name Character 50
ALPHA Country code (2-letter code) Character 2
NUMERIC Reference number (100 to 900?) Number 19

 

CUSTEML.DBF - Customer password email file
Field Name Has What Is Type Size
FROM Who from Character 254
CC CC email address  Character 254
SUBJECT Email subject Character 254
HEADER Header (message start text) Memo N/A

 

CUSTOMER.DBF - Customer account info
Field Name Has What Is Type Size
ID User ID Number 13
PGRPCOUNT Price group membership Number 13
LOGIN Login name N/A N/A
PW_EMAIL Email address Character 50
PASSWORD Password  N/A N/A
SHIP_FNAME Ship-to First Name Character 50
SHIP_LNAME Ship-to Last Name Character 50
SHIP_EMAIL Ship-to Email Address Character 50
SHIP_COMP Ship-to Company Name Character 50
SHIP_PHONE Ship-to Phone Character 50
SHIP_FAX Ship-to Fax Number Character 50
SHIP_ADDR Ship-to Address Character 100
SHIP_CITY Ship-to City Character 50
SHIP_STATE Ship-to State Character 50
SHIP_ZIP Ship-to Zip code Character 50
SHIP_CNTRY Ship-to Country Character 50
BILL_FNAME Bill-to First Name Character 50
BILL_LNAME Bill-to Last Name Character 50
BILL_EMAIL Bill-to Email Address Character 50
BILL_COMP Bill-to Company Name Character 50
BILL_PHONE Bill-to Phone Character 50
BILL_FAX Bill-to Fax Number Character 50
BILL_ADDR Bill-to Address Character 100
BILL_CITY Bill-to City Character 50
BILL_STATE Bill-to State Character 50
BILL_ZIP Bill-to Zip code Character 50
BILL_CNTRY Bill-to Country Character 50

 

DOMAIN.DBF - Mall license and owner information
Field Name Has What Is Type Size
NAME Mall name Character 100
LICENSE License # N/A N/A
VERSION Merchant version number Character 10
OWNER Mall Owner Character 100
EMAIL Owner's email address  Character 50
COMPANY Owner's Company Name Character 100
ADDRESS Owner's Address Character 100
CITY Owner's City Character 50
STATE Owner's State Character 50
ZIP Owner's Zipcode Character 50
COUNTRY Owner's Country Character 50
PHONE Owner's Phone Number Character 50
FAX Owner's Fax Number Character 50
MM_URL Base URL to Merchant Character 254
MM_SURL Base Secure URL to Merchant Character 254
ADMIN_SURL Base URL to Secure Merchant Admin Character 254
IMAGE_ROOT Root for Merchant images Character 254
BASE_URL Base Merchant URL Character 254
BASE_SURL Base Merchant Secure URL Character 254
MOD_ROOT Module Root Character 254
MOD_SROOT Secure Module Root Character 254
ADMEXP Admin interface Expire Time (60 secs) Number 19
MAILHOST SMTP Host for Merchant to use Character 254
MAIL_ANGL Use angled e-mail brackets? (Y/N) Boolean 1
UI_ID User Interface ID number Number 19

 

GROUPS.DBF - group name to number reference
Field Name Has What Is Type Size
ID Group ID number Number 19
NAME Group name Character 40

 

GRPPRIV.DBF - group privileges
Field Name Has What Is Type Size
GROUP_ID Group ID number Numeric 19
PRIVILEGE Privilege name Character 20
VIEW View right Boolean 1
ADD Add right Boolean 1
MODIFY Modify right Boolean 1
DELETE Delete right Boolean 1

 

KEYS.DBF - cross reference for Modules, Users, & Stores keys
Field Name Has What Is Type Size
TYPE Type of key Character 50
MAXVALUE Max value of key (??) Number 19

 

MODULES.DBF - Module reference information
Field Name Has What Is Type Size
ID Module ID number Numeric 19
TYPE Module Type (log, import, tax, etc.) Character 15
CODE Module code name (i.e. mmui) Character 50
NAME Module Name Character 100
PROVIDER Module Publisher Character 100
VERSION Module Version Character 20
MODULE Module location (path) Character 100
REFCOUNT How many times used in the mall?? Number 19

 

OPTS.DBF - references the product attributes.
Field Name Has What Is Type Size
ID ID Key Number 19
ATTR_ID Attribute Number Number 19
ORDER Sort order Number 19
CODE Attribute Name Character 50
PROMPT What to Ask Memo n/a
PRICE How much $$.$$ to add (if any) Number 10.2

 

ORDERS.DBF - Order-specific reference database
Field Name Has What Is Type Size
ID Order ID Number 13
BATCH_ID Batch number Number 13
PROCESSED Order been processed? Boolean 1
DATE Order date Character 10
CUST_ID Customer ID number  Number 13
SHIP_FNAME Ship-to First Name Character 50
SHIP_LNAME Ship-to Last Name Character 50
SHIP_EMAIL Ship-to Email Address Character 50
SHIP_COMP Ship-to Company Name Character 50
SHIP_PHONE Ship-to Phone Character 50
SHIP_FAX Ship-to Fax Number Character 50
SHIP_ADDR Ship-to Address Character 100
SHIP_CITY Ship-to City Character 50
SHIP_STATE Ship-to State Character 50
SHIP_ZIP Ship-to Zip code Character 50
SHIP_CNTRY Ship-to Country Character 50
BILL_FNAME Bill-to First Name Character 50
BILL_LNAME Bill-to Last Name Character 50
BILL_EMAIL Bill-to Email Address Character 50
BILL_COMP Bill-to Company Name Character 50
BILL_PHONE Bill-to Phone Character 50
BILL_FAX Bill-to Fax Number Character 50
BILL_ADDR Bill-to Address Character 100
BILL_CITY Bill-to City Character 50
BILL_STATE Bill-to State Character 50
BILL_ZIP Bill-to Zip code Character 50
BILL_CNTRY Bill-to Country Character 50
TAX Tax amount on order Number 13
SHIPPING Shipping cost Number 13
SHIP_ID Shipment Method Key# Number 13
SHIP_DATA Shipment Method Description Character 100
PAY_ID Payment Type Key# Number 13
PAY_DATA Payment Type Description Character 100
TOTAL Order $$.$$ Total  Number 13

 

ORDITEMS.DBF - Holds the product items
Field Name Has What Is Type Size
ORDER_ID Order ID number Numeric 19
LINE_ID Order line number Number 19
PRODUCT_ID Product SKU Key# Number 19
CODE Product SKU Character 50
NAME Product Name Character 100
PRICE Cost of Item Number 10.2
WEIGHT Shipping Weight of Item Number 10.2
TAXABLE Is Item Taxable? Boolean 1
UPSOLD Is This An Upsold Item? Boolean 1
QUANTITY Quantity Ordered Number 19

 

ORDOPTS.DBF - order upsell options
Field Name Has What Is Type Size
LINE_ID Order line # Number 19
ATTR_ID Attribute Number Number 19
ATTR_CODE Attribute Code (i.e. color) Character 50
OPTION_ID Option/Upsell Key ID # Number 50
OPT_CODE Attribute Name (i.e. green) Character 50
PRICE Option added price Number 10.2
DATA ??? Character 254

 

ORPHANS.DBF - orphan basket control?
Field Name Has What Is Type Size
TYPE Orphan type Character 50
VALUE Orphan value (?) Number 19

 

PGPXCUST
Field Name Has What Is Type Size
PGRP_ID Price group ID number Number 19
CUST_ID Customer Account Number Number 19

 

PGPXPROD.DBF
Field Name Has What Is Type Size
PGRP_ID Price group ID number Number 19
PRODUCT_ID Product ID Number Number 19

 

PRCGRPS.DBF - Price group control file
Field Name Has What Is Type Size
ID Price group key # Number 19
NAME Price group name Character 40
RATE Group rate Character 1
DISCOUNT Discount amount Number 10.2
MARKUP Markup amount Number 10.2

 

PRIVS.DBF - group privilege descriptions
Field Name Has What Is Type Size
PRIVILEGE Privilege code Character 20
NAME Privilege name Character 100

 

PRODUCTS.DBF - contains the individual product info
Field Name Has What Is Type Size
ID Product ID Key Number 19
CATCOUNT 1 if assigned to a Cat/0 if not Number 19
AGRPCOUNT Availability group reference Number 19
PGRPCOUNT Price group reference Number 19
ORDER Sort order Number 19
CODE Product Code (SKU) Character 50
NAME Product Name Character 100
THUMBNAIL Thumbnail Name Character 254
IMAGE Full-size Image name Character 254
PRICE Retail Price (as ###.##) Number 10.2
COST Product cost Number 10.2
DESC Product Description Memo n/a
WEIGHT Weight (as ##.##) Number 10.2
TAXABLE Is it Taxable? Boolean 1

 

STATES.DBF - USA State file (only US states)
Field Name Has What Is Type Size
CODE State code number Character 50
NAME State name Character 100

 

STOREKEY.DBF - primary store key file
Field Name Has What Is Type Size
TYPE State code number Character 50
MAXVALUE State name Number 19

 

STORMOD.DBF - Module reference file
Field Name Has What Is Type Size
PRODUCT_ID Product  ID Key Number 19
TYPE Module type Character 15
REFCOUNT Sort number (?) Numeric 19

 

STORES.DBF - store & store owner information
Field Name Has What Is Type Size
ID Store ID number Number 19
MANAGER_ID ID Number of Store Manager Number 19
LICENSE License number N/A N/A
NAME Store Name Character 100
OWNER Store Owner Character 100
EMAIL Owner's email address  Character 50
COMPANY Owner's Company Name Character 100
ADDRESS Owner's Address Character 100
CITY Owner's City Character 50
STATE Owner's State Character 50
ZIP Owner's Zipcode Character 50
PHONE Owner's Phone Number Character 50
FAX Owner's Fax Number Character 50
COUNTRY Owner's Country Character 50
WTUNITS Unit of weight for the store Character 50
BASKEXP Basket expire time (60 mins) Number 19
PGRP_OVLP ?? (HIGHEST) Character 10
TAX_ID Default Tax ID to apply Number 19
CURRNCY_ID Default currency to use Number 19
UI_ID User Interface ID number for this Store Number 19

 

UPSELL.DBF - references the upsell attributes.
Field Name Has What Is Type Size
PRODUCT_ID Product ID Key Number 10.2
REQ_PERCNT Required % add-on (?) Number 10.2
PERCENT Is it a percent factor? Boolean 1
PRICE Upsell Price Number 13
SCORE i dunno Number 19

 

UPSLPROD.DBF - upsell product reference
Field Name Has What Is Type Size
PRODUCT_ID Product  ID (what you get) Number 19
REQ_PROD Product ID (when you buy) Number 19

 

USERS.DBF - Holds user account info
Field Name Has What Is Type Size
ID User ID number Number 19
PARENT_ID ?? Number 19
NAME User name Character 40
PASSWORD User password N/A N/A
ADMIN Is user an admin Boolean 1
CREATE May create additional users Boolean 1

 

USRXGRP.DBF - User to group cross reference
Field Name Has What Is Type Size
USER_ID User ID number Number 19
GROUP_ID Group ID number Number 19

 

USRXSTOR.DBF - User account to store cross reference
Field Name Has What Is Type Size
USER_ID User ID number Number 19
STORE_ID Which store is account for Number 19
MANAGER Are they a manager Boolean 1
GROUPCOUNT What groups their in?? Number 19
   
hosted by driftwood