OsCommerce

This article is a stub. You can help HypertWiki by expanding it.

Editing is currently in progress on this article. Although editing is incomplete, the author or editor has saved their work to prevent loss. Please check back later by reloading the page, and do not edit while this message is still showing. Thank you.

Techniques: osCommerce

osCommerce is open source software for managing an online store. It is written in PHP and uses the MySQL database engine.

The following documentation is from notes I took while evaluating osCommerce for use at vbz.net. I ended up deciding that it would not be suitable, but could provide useful examples for how to do things using PHP and MySQL.

Tables

• address_book
• address_format
• banners
• banners_history
• categories
• categories_description
• configuration
• configuration_group
• counter
• counter_history
• countries
• currencies
• customers
• customers_basket
• customers_basket_attributes
• customers_info
• geo_zones
• languages
• manufacturers
• manufacturers_info
• newsletters
• orders
• orders_products_info
• orders_products_attributes
• orders_products_download
• orders_status
• orders_status_history
• orders_total
• products
• products_attributes
• products_attributes_download
• products_description
• products_notifications
• products_options
• products_options_values
• products_options_values_to_products_options
• products_to_categories
• reviews
  • reviews_id# -- integer - not null, auto inc
  • products_id -- integer - not null, default 0
  • customers_id -- integer
  • customers_name -- varchar(64) - not null
  • reviews_rating -- int(1)
  • date_added -- datetime
  • last_modified -- datetime
  • reviews_read -- int(5) - not null, default 0
• reviews_description
  • reviews_id# -- integer - not null, default 0
  • languages_id# -- integer - not null, default 0
  • reviews_text -- text - not null
• sessions
  • sesskey# -- varchar(32) - not null
  • expiry -- integer unsigned - not null, default 0
  • value -- text - not null
• specials
  • specials_id# -- integer - not null, auto inc
  • products_id -- integer - not null, default 0
  • specials_new_products_price - decimal(15,4) - not null, default 0.0000
  • specials_date_added -- datetime
  • specials_last_modified -- datetime
  • expires_date -- datetime
  • date_status_change -- datetime
  • status -- int(1) - not null
• tax_class
  • tax_class_id# -- integer - not null, auto inc
  • tax_class_title -- varchar(32) - not null
  • tax_class_description -- varchar(255) - not null
  • last_modified -- datetime
  • date_added -- datetime - not null, default 0000-00-00 00:00:00
• tax_rates
  • tax_rates_id# -- integer - not null, auto inc
  • tax_zone_id -- integer - not null, default 0
  • tax_class_id -- integer - not null, default 0
  • tax_priority -- int(5) - default 1
  • tax_rate -- decimal(7,4) - not null, default 0.0000
  • tax_description -- varchar(255) - not null
  • last_modified -- datetime
  • date_added -- datetime - not null, default 0000-00-00 00:00:00
• whos_online
  • customer_id -- integer
  • full_name -- varchar(34) - not null
  • session_id -- varchar(128) - not null
  • ip_address -- varchar(15) - not null
  • time_entry -- varchar(14) - not null
  • time_last_click -- varchar(14) - not null
  • last_page_url -- varchar(34) - not null
• zones
  • zone_id# -- integer - not null, autoinc
  • zone_country_id -- integer - not null, default 0
  • zone_code -- varchar(32) - not null
  • zone_name -- varchar(32) - not null
• zones_to_geo_zones
  • association_id# - integer - not null, autoinc
  • zone_country_id - integer - not null
  • zone_id - integer
  • geo_zone_id - integer
  • last_modified - datetime
  • date_added - datetime - not null