VbzCart - Revision history

Woozle at 22:43, 17 August 2019

2019-08-17T22:43:05Z

← Older revision		Revision as of 22:43, 17 August 2019
Line 8:		Line 8:
	[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation.		[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation.

			* '''[[/install]]''' has deployment instructions
	* '''[[/status]]''' critical pieces still need to be (re)written, though most of it is working well (2017-06-25)		* '''[[/status]]''' critical pieces still need to be (re)written, though most of it is working well (2017-06-25)
	==Purpose==		==Purpose==

Woozle: /status

2017-06-26T00:16:47Z

/status

← Older revision		Revision as of 00:16, 26 June 2017
Line 8:		Line 8:
	[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation.		[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation.

	* '''~~Status~~''' (~~2015~~-12-25) ~~Getting closer to going back online, but there's still some work to do.~~		* '''[[/status]]''' critical pieces still need to be (re)written, though most of it is working well (2017-06-25)
	==Purpose==		==Purpose==
	The immediate purpose is to handle the more data-intensive aspects of managing a small online retail operation that offers a wide variety of products in a wide variety of choices. This [[/pieces\|includes]] tracking orders, tracking packages sent to fill those orders, stock and inventory, which items need to be reordered from suppliers, what is currently expected from suppliers, what suppliers have sent in the past, etc.		The immediate purpose is to handle the more data-intensive aspects of managing a small online retail operation that offers a wide variety of products in a wide variety of choices. This [[/pieces\|includes]] tracking orders, tracking packages sent to fill those orders, stock and inventory, which items need to be reordered from suppliers, what is currently expected from suppliers, what suppliers have sent in the past, etc.

Woozle: /* Pages */ meta

2016-03-02T22:24:19Z

Pages: meta

← Older revision		Revision as of 22:24, 2 March 2016
Line 25:		Line 25:
	* [[/history]]: how we got here		* [[/history]]: how we got here
	* [[/archive]]: obsolete pages		* [[/archive]]: obsolete pages
			* [[/meta]]: how to document
	\|}		\|}

Woozle: /* Pages */ removed redundant links

2016-01-09T20:57:48Z

Pages: removed redundant links

← Older revision		Revision as of 20:57, 9 January 2016
Line 19:		Line 19:
	\|-		\|-
	\|		\|
			* [[/ui]]: help pages
	* [[/pieces]]: features and concepts		* [[/pieces]]: features and concepts
	* [[/coding]]		* [[/coding]]: technical documentation
	* '''Data design''':
	** [[/tables]]: all tables used by VbzCart
	** [[/procs]]: stored procedures
	** [[/queries]]
	* '''Data concepts''':
	** [[/order]]
	** [[/session]]
	\|		\|
	* '''Subsystems''':		* [[/history]]: how we got here
	** [[/checkout]]: notes on the checkout subsystem		* [[/archive]]: obsolete pages
	** [[/packages]]: how package records work
	** [[/security/customer]]: keeping customer data secure
	* '''Other''':
	** [[/history]]: how we got here
	** [[/archive]]: obsolete ~~documentation~~
	\|}		\|}

Woozle: removed unnecessary/outdated sentence

2015-12-26T15:51:23Z

removed unnecessary/outdated sentence

← Older revision		Revision as of 15:51, 26 December 2015
Line 6:		Line 6:
	</hide>		</hide>
	==About==		==About==
	[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation~~. The author is in the process of documenting it and publishing the source code~~.		[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation.

	* '''Status''' (2015-12-25) Getting closer to going back online, but there's still some work to do.		* '''Status''' (2015-12-25) Getting closer to going back online, but there's still some work to do.

Woozle: moved history summary to /history subpage; updated status, wrote "purpose" section that actually talks about purpose

2015-12-25T21:59:10Z

moved history summary to /history subpage; updated status, wrote "purpose" section that actually talks about purpose

← Older revision		Revision as of 21:59, 25 December 2015
Line 7:		Line 7:
	==About==		==About==
	[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation. The author is in the process of documenting it and publishing the source code.		[[VbzCart]] is [[free/open-source]] software for running an [[online retail]] operation. The author is in the process of documenting it and publishing the source code.

			* '''Status''' (2015-12-25) Getting closer to going back online, but there's still some work to do.
	==Purpose==		==Purpose==
	~~VbzCart [[/history\|started life]] as a nameless shopping-cart application written specifically for [[vbz.net]], mostly coded in [[Visual Basic for Applications\|VBA]] on [[MS Access 97]]. By 2003 at~~ the ~~latest, I had already decided that it would be better for vbz.net's administration functions to be web~~-~~based, but I didn't see any way forward with this~~ that ~~didn't require~~ a ~~massive amount~~ of ~~up-front time investment before being able to gain any actual functionality.~~		The immediate purpose is to handle the more data-intensive aspects of managing a small online retail operation that offers a wide variety of products in a wide variety of choices. This [[/pieces\|includes]] tracking orders, tracking packages sent to fill those orders, stock and inventory, which items need to be reordered from suppliers, what is currently expected from suppliers, what suppliers have sent in the past, etc.

	I evaluated [[osCommerce]] and [[ZenCart]] as alternatives and found that although they both had many features I would like to have on vbz.net, they also lacked some key features I would need (some of which VbzCart already had, and some of which would be needed to migrate VbzCart's data from Access).

	~~Eventually (after a false start~~ in ~~[[Perl]]), around 2007 I came up with the idea of writing VbzCart's admin functions as~~ a ~~[[MediaWiki]] extension, saving the trouble~~ of ~~writing a user management/login system and gaining some additional interface functionality into the bargain~~.

	~~Development and migration has continued since then in fits and starts, with interruptions due largely to family obligations (especially~~ [[~~htwiki:Josh~~\|~~this~~]]), ~~but as of August 2011 I consider the migration essentially complete; there are no order-processing functions that still need~~ to ~~be done in VB (the last "piece" of this~~, ~~completed in July~~, was working out a system to produce "[[database/report\|report]]s" so I could print packing slips formatted as nicely as the ones in Access), and there are no admin functions that aren't at the stage of being at least written if not yet debugged.

	* '''Status''' (2014-12-18) What seemed like a relatively small feature -- the need to ~~let users access their pre-existing address records -- resulted in rewriting the entire admin interface to work without MediaWiki~~, ~~which in turn resulted in creating an application framework to manage everything. The app framework~~ is ~~working adequately~~, ~~and now I'm just tidying up~~ the ~~checkout process and doing other cleanup prior to moving the whole thing from Rizzo to a commercial web server~~.

			Once that is up and running, I'll begin work on additional functionality:
			* "marketplace" ability -- 3rd parties can sell their items through the same site, and VbzCart will provide most of the same functionality to them
			* distributed catalog search and other {{l/ig\|federated retail}} functionality
	==Pages==		==Pages==
	{\|		{\|
Line 37:		Line 34:
	** [[/security/customer]]: keeping customer data secure		** [[/security/customer]]: keeping customer data secure
	* '''Other''':		* '''Other''':
			** [[/history]]: how we got here
	** [[/archive]]: obsolete documentation		** [[/archive]]: obsolete documentation
	\|}		\|}

Woozle: slowly moving concepts and features off this page

2015-01-25T19:18:35Z

slowly moving concepts and features off this page

← Older revision		Revision as of 19:18, 25 January 2015
Line 18:		Line 18:
	* '''Status''' (2014-12-18) What seemed like a relatively small feature -- the need to let users access their pre-existing address records -- resulted in rewriting the entire admin interface to work without MediaWiki, which in turn resulted in creating an application framework to manage everything. The app framework is working adequately, and now I'm just tidying up the checkout process and doing other cleanup prior to moving the whole thing from Rizzo to a commercial web server.		* '''Status''' (2014-12-18) What seemed like a relatively small feature -- the need to let users access their pre-existing address records -- resulted in rewriting the entire admin interface to work without MediaWiki, which in turn resulted in creating an application framework to manage everything. The app framework is working adequately, and now I'm just tidying up the checkout process and doing other cleanup prior to moving the whole thing from Rizzo to a commercial web server.

	==~~Documents~~==		==Pages==
	{\|		{\|
	\|-		\|-
	\|		\|
	* [[/~~features~~]]		* [[/pieces]]: features and concepts
	* [[/coding]]		* [[/coding]]
	* '''Data design''':		* '''Data design''':
Line 29:		Line 29:
	** [[/queries]]		** [[/queries]]
	* '''Data concepts''':		* '''Data concepts''':
	** [[/cart]]
	** [[/order]]		** [[/order]]
	** [[/session]]		** [[/session]]
	\|		\|
	* '''Subsystems''':		* '''Subsystems''':
	** [[/catalog/building]]: how the catalog is built from stock and supplier catalogs
	** [[/checkout]]: notes on the checkout subsystem		** [[/checkout]]: notes on the checkout subsystem
	** [[/packages]]: how package records work		** [[/packages]]: how package records work

Woozle: removed link to one vbzwiki page that doesn't exist, moved other vbzwiki link to /archive

2015-01-25T18:54:44Z

removed link to one vbzwiki page that doesn't exist, moved other vbzwiki link to /archive

← Older revision		Revision as of 18:54, 25 January 2015
Line 38:		Line 38:
	** [[/packages]]: how package records work		** [[/packages]]: how package records work
	** [[/security/customer]]: keeping customer data secure		** [[/security/customer]]: keeping customer data secure
	** [[vbzwiki:VbzCart ordering\|ordering]]: how ordering works (carts, orders, etc.)		* '''Other''':
	* '''~~Archival notes~~''':
	** [[/archive]]: obsolete documentation		** [[/archive]]: obsolete documentation
	** [[vbzwiki:VbzCart wikified topics\|VbzCart wikified topics]] (on VbzWiki): using MediaWiki to manage store topics
	\|}		\|}

Woozle: archived /code pages; table for subpages; renamed /obsolete -> /archive; link to newish Redmine project; status update

2014-12-19T02:39:30Z

archived /code pages; table for subpages; renamed /obsolete -> /archive; link to newish Redmine project; status update

← Older revision		Revision as of 02:39, 19 December 2014
Line 16:		Line 16:
	Development and migration has continued since then in fits and starts, with interruptions due largely to family obligations (especially [[htwiki:Josh\|this]]), but as of August 2011 I consider the migration essentially complete; there are no order-processing functions that still need to be done in VB (the last "piece" of this, completed in July, was working out a system to produce "[[database/report\|report]]s" so I could print packing slips formatted as nicely as the ones in Access), and there are no admin functions that aren't at the stage of being at least written if not yet debugged.		Development and migration has continued since then in fits and starts, with interruptions due largely to family obligations (especially [[htwiki:Josh\|this]]), but as of August 2011 I consider the migration essentially complete; there are no order-processing functions that still need to be done in VB (the last "piece" of this, completed in July, was working out a system to produce "[[database/report\|report]]s" so I could print packing slips formatted as nicely as the ones in Access), and there are no admin functions that aren't at the stage of being at least written if not yet debugged.

	* '''Status''' (~~2011~~-08-03)~~: working, with lots of developer~~-~~level rough edges~~ to work ~~out~~. ~~We're a long way from having an install script~~, and I ~~need~~ to ~~post~~ the ~~code on~~ a ~~more appropriate venue such as [[GitHub]]~~.		* '''Status''' (2014-12-18) What seemed like a relatively small feature -- the need to let users access their pre-existing address records -- resulted in rewriting the entire admin interface to work without MediaWiki, which in turn resulted in creating an application framework to manage everything. The app framework is working adequately, and now I'm just tidying up the checkout process and doing other cleanup prior to moving the whole thing from Rizzo to a commercial web server.

	==Documents==		==Documents==
			{\|
			\|-
			\|
	* [[/features]]		* [[/features]]
			* [[/coding]]
	* '''Data design''':		* '''Data design''':
	** [[/tables]]: all tables used by VbzCart		** [[/tables]]: all tables used by VbzCart
	** [[/procs]]: stored procedures		** [[/procs]]: stored procedures
	** [[/queries]]		** [[/queries]]
	* '''Code''':
	** [[/code]]
	* '''Data concepts''':		* '''Data concepts''':
	** [[/cart]]		** [[/cart]]
	** [[/order]]		** [[/order]]
	** [[/session]]		** [[/session]]
			\|
	* '''Subsystems''':		* '''Subsystems''':
	** [[/catalog/building]]: how the catalog is built from stock and supplier catalogs		** [[/catalog/building]]: how the catalog is built from stock and supplier catalogs
Line 37:		Line 40:
	** [[vbzwiki:VbzCart ordering\|ordering]]: how ordering works (carts, orders, etc.)		** [[vbzwiki:VbzCart ordering\|ordering]]: how ordering works (carts, orders, etc.)
	* '''Archival notes''':		* '''Archival notes''':
	** [[/~~obsolete~~]]: ~~large chunks of~~ documentation ~~which have become obsolete~~		** [[/archive]]: obsolete documentation
	** [[vbzwiki:VbzCart wikified topics\|VbzCart wikified topics]]: using MediaWiki to manage store topics		** [[vbzwiki:VbzCart wikified topics\|VbzCart wikified topics]] (on VbzWiki): using MediaWiki to manage store topics
			\|}
	~~==Links==~~
	* [https://github.com/woozalia/VbzCart VbzCart] on [[GitHub]]
	* [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries
	~~==Notes==~~
	The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form _X_). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary.

Woozle: /* Links */ notes: bot permissions

2014-07-25T20:47:46Z

Links: notes: bot permissions

← Older revision		Revision as of 20:47, 25 July 2014
Line 43:		Line 43:
	* [https://github.com/woozalia/VbzCart VbzCart] on [[GitHub]]		* [https://github.com/woozalia/VbzCart VbzCart] on [[GitHub]]
	* [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
			==Notes==
			The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form _X_). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary.