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]
