VbzCart/pieces/catalog/building/2016/rules - Revision history

Woozle: field revision thought process

2016-02-10T23:50:32Z

field revision thought process

@@ Line 15: / Line 15: @@
 * (rules) &rarr; {{l/vc/table|cat_items|LCItem}}: isForSale, isInPrint, isCloseOut, isCurrent (as above)
 * {{l/vc/table|ctg_groups|SCGroup}} &rarr; {{l/vc/table|cat_items|LCItem}}: GrpCode, GrpSort, GrpDescr
-* {{l/vc/table|ctg_titles|SCTitle}} &rarr; {{l/vc/table|cat_titles|LCTitle}}: WhenDiscont
+* <s>{{l/vc/table|ctg_titles|SCTitle}} &rarr; {{l/vc/table|cat_titles|LCTitle}}: WhenDiscont</s>

Woozle: fields to set; removing isForSale

2016-02-10T14:42:30Z

fields to set; removing isForSale

← Older revision		Revision as of 14:42, 10 February 2016
Line 8:		Line 8:
	* Each activated item from a closeout catalog should be marked isForSale, out-of-print, isCurrent.		* Each activated item from a closeout catalog should be marked isForSale, out-of-print, isCurrent.
	==Deactivations==		==Deactivations==
	* Any Supplier for which no activations are generated should have all of its items marked not-current (isCurrent = FALSE) and isForSale should be TRUE only if there is stock. The isInPrint flag should be disregarded when isCurrent is FALSE.		* Any Supplier for which no activations are generated should have all of its items marked not-current (isCurrent = FALSE) and isForSale should be TRUE only if there is stock.
	** FUTURE: ~~Maybe there should be separate flags for isAvailable and isInStock so~~ gone items ~~can be~~ not-for-sale as soon as stock runs out~~? Although the Title's WhenDiscont timestamp kind of serves as isAvailable already... so maybe~~ isForSale should be eliminated, and IsForSale() should be ({qty_in_stk > 0} && {WhenDiscont > NOW or IS NULL}).		** The isInPrint flag should be disregarded when isCurrent is FALSE.
			** FUTURE: In order to ensure that gone items are considered not-for-sale as soon as stock runs out, perhaps isForSale should be eliminated, and IsForSale() should be ({item.qty_in_stk > 0} OR {Title.WhenDiscont > NOW or IS NULL}). (Title.WhenDiscont could be cached to minimize db lookups.)
	* Any Supplier for which some activations are generated should have all other items marked isCurrent, not-in-print; isForSale as above.		* Any Supplier for which some activations are generated should have all other items marked isCurrent, not-in-print; isForSale as above.
	==Fields to ~~Copy~~==		==Fields to Set==
			* (rules) → {{l/vc/table\|cat_items\|LCItem}}: isForSale, isInPrint, isCloseOut, isCurrent (as above)
	* {{l/vc/table\|ctg_groups\|SCGroup}} → {{l/vc/table\|cat_items\|LCItem}}: GrpCode, GrpSort, GrpDescr		* {{l/vc/table\|ctg_groups\|SCGroup}} → {{l/vc/table\|cat_items\|LCItem}}: GrpCode, GrpSort, GrpDescr
	* {{l/vc/table\|ctg_titles\|SCTitle}} → {{l/vc/table\|cat_titles\|LCTitle}}: WhenDiscont		* {{l/vc/table\|ctg_titles\|SCTitle}} → {{l/vc/table\|cat_titles\|LCTitle}}: WhenDiscont

Woozle: saving this here -- probably should list all fields to update

2016-02-10T14:29:04Z

saving this here -- probably should list all fields to update

New page

==Matching==
* If LCTitle has no Items, then we look across all Titles for matching CatNums. If any are found, this is a situation to resolve before proceeding.
* If LCTitle has Items, then for each proposed item we try to find matches in this order:
*: '''a)''' Look for any items across all Titles whose CatNum matches the calculated CatNum of the proposed item
*: '''b)''' Look for any items within this Title whose CatSfx matches the calculated CatSfx for the proposed item
==Activations==
* Each activated item from a regular catalog should be marked isForSale, inPrint, and isCurrent.
* Each activated item from a closeout catalog should be marked isForSale, out-of-print, isCurrent.
==Deactivations==
* Any Supplier for which no activations are generated should have all of its items marked not-current (isCurrent = FALSE) and isForSale should be TRUE only if there is stock. The isInPrint flag should be disregarded when isCurrent is FALSE.
** FUTURE: Maybe there should be separate flags for isAvailable and isInStock so gone items can be not-for-sale as soon as stock runs out? Although the Title's WhenDiscont timestamp kind of serves as isAvailable already... so maybe isForSale should be eliminated, and IsForSale() should be ({qty_in_stk > 0} && {WhenDiscont > NOW or IS NULL}).
* Any Supplier for which some activations are generated should have all *other* items marked isCurrent, not-in-print; isForSale as above.
==Fields to Copy==
* {{l/vc/table|ctg_groups|SCGroup}} → {{l/vc/table|cat_items|LCItem}}: GrpCode, GrpSort, GrpDescr
* {{l/vc/table|ctg_titles|SCTitle}} → {{l/vc/table|cat_titles|LCTitle}}: WhenDiscont