VbzCart/docs/pieces/catalog/building: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | pieces‎ | catalog
Jump to navigation Jump to search
imported>Woozle
m (2 revision(s))
m (Woozle moved page VbzCart/VbzCart/pieces/catalog/building to VbzCart/docs/pieces/catalog/building without leaving a redirect: correct naming (was no way to import directly to this name))
 
(73 intermediate revisions by one other user not shown)
Line 1: Line 1:
==Version==
==Version==
This is being revised yet again for the 2007 VbzCart-MySQL migration project; the previous version is here: [[VbzCart catalog building 2006]].
This is a tricky process which has been revised multiple times.
==Process==
 
This is only a draft, as the process is still being worked out.
* {{l/sub|2017}} version - 2016 code apparently never really got finished, and the Items table needs some flag changes
# Update the list of all catalog-based items ([calc Items Updates saved])
* {{l/sub|2016}} version - webified version of 2010, with rules finally documented
#* Generate a list of all the items currently available from suppliers (query)
* '''2010''' version: see {{l/vbzcart/code|maint/build-cat.php}}
#* Add any new items to [calc Items Updates saved]
* {{l/sub|2009}} version - SQL statements executed directly from PHP code
# For all items in [calc Items Updates saved] where ID_Item IS NULL, create new records in cat_items and update the corresponding records in [calc Items Updates saved]
* {{l/sub|2008}} version - started in 2007 - a set of stored queries called from a stored procedure
# Update all data in cat_items from data stored in [calc Items Updates saved]
* {{l/sub|2006}} version
# In cat_items, clear all isForSale flags ''except'' for items either in stock or found in [calc Items Updates saved]
 
It's interesting to note that I originally thought of SCM Groups as groups ''of Titles'' -- an explanation from the [[VbzCart/tables]] page on 2008-02-17 (and only removed on 2016-02-01) says:
<blockquote>The key concept here is "catalog title groups" (CTGs). A CTG is a set of titles which are all available with the same set of options (e.g. sizes) at the same prices (e.g. $10 S, $11 M-XL, $12 2XL). The final vbz catalog (cat_items) is the result of a sort of vector multiplication of Titles (cat_titles) and CTGs plus any items in stock.
</blockquote>
This conceptualization no longer works, as a SCM Title may have one or more SCM Groups -- e.g. if it has a set of standard sizes (like S-3X) but is also available in super-large sizes (4X+).

Latest revision as of 01:53, 25 February 2024

Version

This is a tricky process which has been revised multiple times.

  • 2017 version - 2016 code apparently never really got finished, and the Items table needs some flag changes
  • 2016 version - webified version of 2010, with rules finally documented
  • 2010 version: see Template:L/vbzcart/code
  • 2009 version - SQL statements executed directly from PHP code
  • 2008 version - started in 2007 - a set of stored queries called from a stored procedure
  • 2006 version

It's interesting to note that I originally thought of SCM Groups as groups of Titles -- an explanation from the VbzCart/tables page on 2008-02-17 (and only removed on 2016-02-01) says:

The key concept here is "catalog title groups" (CTGs). A CTG is a set of titles which are all available with the same set of options (e.g. sizes) at the same prices (e.g. $10 S, $11 M-XL, $12 2XL). The final vbz catalog (cat_items) is the result of a sort of vector multiplication of Titles (cat_titles) and CTGs plus any items in stock.

This conceptualization no longer works, as a SCM Title may have one or more SCM Groups -- e.g. if it has a set of standard sizes (like S-3X) but is also available in super-large sizes (4X+).

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/pieces/catalog/building&oldid=6665"