VbzCart/pieces/catalog/building

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | pieces‎ | catalog
Revision as of 02:05, 20 July 2007 by Woozle (talk | contribs)
Jump to navigation Jump to search

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.

  1. 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]
  2. 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]
  3. Update all data in cat_items from data stored in [calc Items Updates saved]
  4. In cat_items, clear all isForSale flags except for items either in stock or found in [calc Items Updates saved]