Difference between revisions of "VbzCart/pieces/catalog/building"
Jump to navigation
Jump to search
(VbzCart catalog building moved to VbzCart catalog building 2006: writing new version) |
|||
| Line 1: | Line 1: | ||
| − | + | ==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] | ||
Revision as of 02:05, 20 July 2007
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]