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

Revision as of 02:05, 20 July 2007

This is being revised yet again for the 2007 VbzCart-MySQL migration project; the previous version is here: VbzCart catalog building 2006.

This is only a draft, as the process is still being worked out.

Update the list of all catalog-based items ([calc Items Updates saved])
- Generate a list of all the items currently available from suppliers (query)
- Add any new items to [calc Items Updates saved]
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]
Update all data in cat_items from data stored in [calc Items Updates saved]
In cat_items, clear all isForSale flags except for items either in stock or found in [calc Items Updates saved]

@@ Line 1: / Line 1: @@
-#REDIRECT [[VbzCart catalog building 2006]]
+==Version==
+This is being revised yet again for the 2007 VbzCart-MySQL migration project; the previous version is here: [[VbzCart catalog building 2006]].
+==Process==
+This is only a draft, as the process is still being worked out.
+# Update the list of all catalog-based items ([calc Items Updates saved])
+#* Generate a list of all the items currently available from suppliers (query)
+#* Add any new items to [calc Items Updates saved]
+# 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]
+# Update all data in cat_items from data stored in [calc Items Updates saved]
+# In cat_items, clear all isForSale flags ''except'' for items either in stock or found in [calc Items Updates saved]