Difference between revisions of "VbzCart/pieces/catalog/supplier"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | pieces‎ | catalog
Jump to navigation Jump to search
(more details)
(more explanation)
 
Line 1: Line 1:
'''Supplier Catalogs''' are collections of items that {{l/vc/piece|supplier}}s have made available for us to purchase at wholesale prices for a given span of time (usually specified by year and sometimes season; specific ending dates are rarely given).
+
'''Supplier Catalogs''' are collections of items that {{l/vc/piece|supplier}}s have made available for us to purchase at wholesale prices for a given span of time (usually specified by year and sometimes season; specific ending dates are rarely given).  
  
Since they are typically not provided in a data-oriented format that could be imported into VbzCart but rather in a print-oriented format (either a PDF of their print catalog or a hard copy thereof), I developed the "Supplier Catalog" (SC) subsystem to make it easier to manually enter print-catalog information.
+
Since they are typically not provided in a data-oriented format that could be imported into VbzCart but rather in a print-oriented format (either a PDF of their print catalog or a hard copy thereof), I developed the Supplier Catalog Management (SC or SCM) subsystem to make it easier to manually enter print-catalog information, which is then used to update the [[../local|Local Catalog (LC)]] data.
  
 
The basic idea is that there tend to be clusters of options and corresponding prices in any given catalog &ndash; so rather than having to key in every item type, item option (e.g. size), and corresponding prices, the SC subsystem lets you make a note of these groups and record which group or groups apply to each title in the catalog.
 
The basic idea is that there tend to be clusters of options and corresponding prices in any given catalog &ndash; so rather than having to key in every item type, item option (e.g. size), and corresponding prices, the SC subsystem lets you make a note of these groups and record which group or groups apply to each title in the catalog.
  
The {{l/same|local|Local Catalog (LC)}} data is then generated by combining the following:
+
{{l/same|local|Local Catalog (LC)}} data is then generated or updated by combining the following:
  
* LC Supplier -- only some LC Suppliers provide catalogs
+
* '''SC Supplier''' &mdash; only some LC Suppliers provide catalogs
* LC Source -- Titles will only be included if they're connected to an active Source
+
** There used to be a separate table, but now we just filter for LC Suppliers that have a Price Function.
* LC Title -- the name for each set of Items
+
** Eventually, we might switch to a separate flag, or LC Suppliers having one or more SC Sources.
* LC Item -- (short for LC Group Item) a particular item-type / item-option / price
+
* '''SC Source''' &mdash; Titles will only be included if they're connected to an active Source
* LC Group -- a group of item-types / item-options / prices that appears in the Source
+
* '''SC Title''' &mdash; the name for each set of Items; corresponds to an LC Title, which might or might not already exist
 +
* '''SC Item''' &mdash; (short for SC Group Item) a particular item-type / item-option / price
 +
* '''SC Group''' &mdash; a group of item-types / item-options / prices that appears in the Source

Latest revision as of 21:00, 1 February 2016

Supplier Catalogs are collections of items that suppliers have made available for us to purchase at wholesale prices for a given span of time (usually specified by year and sometimes season; specific ending dates are rarely given).

Since they are typically not provided in a data-oriented format that could be imported into VbzCart but rather in a print-oriented format (either a PDF of their print catalog or a hard copy thereof), I developed the Supplier Catalog Management (SC or SCM) subsystem to make it easier to manually enter print-catalog information, which is then used to update the Local Catalog (LC) data.

The basic idea is that there tend to be clusters of options and corresponding prices in any given catalog – so rather than having to key in every item type, item option (e.g. size), and corresponding prices, the SC subsystem lets you make a note of these groups and record which group or groups apply to each title in the catalog.

local data is then generated or updated by combining the following:

  • SC Supplier — only some LC Suppliers provide catalogs
    • There used to be a separate table, but now we just filter for LC Suppliers that have a Price Function.
    • Eventually, we might switch to a separate flag, or LC Suppliers having one or more SC Sources.
  • SC Source — Titles will only be included if they're connected to an active Source
  • SC Title — the name for each set of Items; corresponds to an LC Title, which might or might not already exist
  • SC Item — (short for SC Group Item) a particular item-type / item-option / price
  • SC Group — a group of item-types / item-options / prices that appears in the Source