Difference between revisions of "VbzCart"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(checkout now has its own page; some reorg)
(updates; reorg)
Line 11: Line 11:
 
--[[User:Woozle|Woozle]] 21:42, 1 July 2007 (EDT)
 
--[[User:Woozle|Woozle]] 21:42, 1 July 2007 (EDT)
  
==Status==
+
==Status / History==
VbzCart is very much in a pre-alpha state of development. I'm slowly porting chunks of it from its former platform, which was a combination of [[MS Access 97]] and clumsily-written [[Perl]]. The stock data is now entirely in MySQL, and most of the catalog data is available in MySQL but still maintained in MS Access.
+
VbzCart is very much in a pre-alpha state of development, although it is nonetheless being used in a production environment (i.e. vbz.net). The original, working version began with some clumsily-written [[Perl]] in approximately 1996 and added order management functions using [[MS Access 97]] in approximately 1999. The data was moved over to [[MySQL]] over a couple of years, starting with the stock data and finishing sometime in 2010. The management functions were recoded in a [[PHP]]-based web interface from approximately 2009-2010 (still in progress as of November, 2010).
 
==Documents==
 
==Documents==
* <s>VbzCart uses [[htwiki:HyperAdmin|HyperAdmin]] for administration of privileged users</s> (may end up using this, or may end up using MediaWiki to mediate log-in privileges)
 
 
* '''Data design''':
 
* '''Data design''':
 
** [[/tables]]: all tables used by VbzCart
 
** [[/tables]]: all tables used by VbzCart
 
** [[/procs]]: stored procedures
 
** [[/procs]]: stored procedures
*** [[VbzCart stored procedures]]: old procs which are probably abandonable
 
 
** [[/queries]]
 
** [[/queries]]
** <s>[[VbzCart SQL]]: for building schema; automatically generated from above pages</s> '''needs to be rewritten'''
 
 
* '''Code''':
 
* '''Code''':
 
** [[/code]]
 
** [[/code]]
Line 31: Line 28:
 
** [[/checkout]]: notes on the checkout subsystem
 
** [[/checkout]]: notes on the checkout subsystem
 
** [[vbzwiki:VbzCart ordering|ordering]]: how ordering works (carts, orders, etc.)
 
** [[vbzwiki:VbzCart ordering|ordering]]: how ordering works (carts, orders, etc.)
* '''Other notes''':
+
* '''Archival notes''':
 +
** [[/obsolete]]: large chunks of documentation which have become obsolete
 +
*** [[/obsolete/stored procedures]]: ended up not using these because they can't report back in detail
 
** [[vbzwiki:VbzCart tables in MS Access|VbzCart tables in MS Access]]: the data schema in the MS Access version (2006)
 
** [[vbzwiki:VbzCart tables in MS Access|VbzCart tables in MS Access]]: the data schema in the MS Access version (2006)
 
** [[vbzwiki:VbzCart wikified topics|VbzCart wikified topics]]: using MediaWiki to manage store topics
 
** [[vbzwiki:VbzCart wikified topics|VbzCart wikified topics]]: using MediaWiki to manage store topics
 
** [[vbzwiki:VbzCart shelved ideas|VbzCart shelved ideas]]: concepts and code which might be useful later but aren't worth it right now
 
** [[vbzwiki:VbzCart shelved ideas|VbzCart shelved ideas]]: concepts and code which might be useful later but aren't worth it right now
 
+
** <s>VbzCart uses [[htwiki:HyperAdmin|HyperAdmin]] for administration of privileged users</s> The admin code uses [[MediaWiki]] for user access control, but could be ported to other environments. The standalone store does have its own security system, which is partly documented here.
Pages still on VbzWiki will eventually be ported here, except for vbz.net-specific items.
+
** <s>[[VbzCart SQL]]: for building schema; automatically generated from above pages</s> '''needs to be rewritten'''
 +
** Pages still on VbzWiki will eventually be ported here, except for vbz.net-specific items.
 
==Links==
 
==Links==
 
* [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries
 
* [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries

Revision as of 18:14, 15 November 2010

Navigation

computing: software: web: shopping carts: VbzCart

Introduction

Having evaluated osCommerce (and, later, ZenCart) and found that, although it had many features I would like to have on vbz.net, it also lacked some crucial features currently needed (many of which are provided by the existing shopping cart system, and some of which would be needed in order to effectively manage porting the data from the existing system).

So I'm writing a new system, in PHP (originally started in Perl, but needed PHP for interfacing with MediaWiki) and MySQL, based on the data design of the existing VBZ cart system and adding new pieces as needed.

I will be taking notes on this page and gradually refining them into something resembling documentation, with the ultimate goal of producing a system which could be released under an open source license.

--Woozle 21:42, 1 July 2007 (EDT)

Status / History

VbzCart is very much in a pre-alpha state of development, although it is nonetheless being used in a production environment (i.e. vbz.net). The original, working version began with some clumsily-written Perl in approximately 1996 and added order management functions using MS Access 97 in approximately 1999. The data was moved over to MySQL over a couple of years, starting with the stock data and finishing sometime in 2010. The management functions were recoded in a PHP-based web interface from approximately 2009-2010 (still in progress as of November, 2010).

Documents

  • Data design:
  • Code:
  • Data concepts:
  • Subsystems:
    • /catalog/building: how the catalog is built from stock and supplier catalogs
    • /checkout: notes on the checkout subsystem
    • ordering: how ordering works (carts, orders, etc.)
  • Archival notes:
    • /obsolete: large chunks of documentation which have become obsolete
    • VbzCart tables in MS Access: the data schema in the MS Access version (2006)
    • VbzCart wikified topics: using MediaWiki to manage store topics
    • VbzCart shelved ideas: concepts and code which might be useful later but aren't worth it right now
    • VbzCart uses HyperAdmin for administration of privileged users The admin code uses MediaWiki for user access control, but could be ported to other environments. The standalone store does have its own security system, which is partly documented here.
    • VbzCart SQL: for building schema; automatically generated from above pages needs to be rewritten
    • Pages still on VbzWiki will eventually be ported here, except for vbz.net-specific items.

Links