At 20:54 23/07/00 -0400, you wrote:
>Dear list,
>I am in the process of setting up FreeTrade and incorporating the client's
>existing perl flat file data.
>
>The first question:
>
>I need to identify the items with multiple topics and each item also needs
>to be identified with its type (video tape, book, kit, content...). I am
>wondering if the best way to do this is through departments, or to add a
>product type attribute to the item sku table.
>
>Second question:
>
>The current system allows the client to enter many more details and
>descriptors than the FreeTrade structure allows. I don't want to add these
>fields directly to either the item or the item sku tables because some of
>the details are product type specific (# of pages, book size) and some are
>only used by a records. Currently, in a table of 2300 records with 50 +
>fields, over 3/4 of the records have 10 or more empty fields...And many of
>these fields are large text fields. I am thinking of adding 2 additional
>tables.
>
>descriptions
>ID
>ItemID OR SkuID
>DescID
>Value
>
>
>desc_attributes
>DescID
>ProductID
>DescriptionLabel
>
>Then, on the item form, I can give the user a link to add additional
>details. The possible *additional details* would come from desc_attributes
>based on the product department the item belongs to...
>
>My question is, first does this sound feasible? and Second, should
>descriptions be linked to the item or the sku?
>
>Thanks!
>
>Kathleen
>
>
>
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
I am facing a similar problem
There are generic items that come in a variety of materials and sizes
I have used 'departments ' to make a path to the items. Because the prices
are not the same I cannot see how I can use 'variations'. I have put the
additional fields (37 of them) into table 'item'. Info that is specific to
a SKU (price,size,material) are in table 'sku'. The idea is that generic
items are displayed in screen 'item'.
That is as far as I have got....
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
