Store_Products
PortalID
ProductID
CategoryID – drop field – should be in ProductCategories
Manufacturer
ModelNumber - change to SKU (Stock Keeping Unit) – see below
ModelName - change to Name or ProductName - see below
ProductImage – enahanced - see Store_ProductImages below
UnitCost - change to Price - see below
Summary
Description
Featured - drop field – should be a Category called Featured Products
Archived
CreatedByUser
CreatedDate
Store_Categories
CategoryID
PortalID
CategoryName
CategoryDescription
Message
Archived
ViewOrder (new – solves alphabetical/rearrangement issues)
CreatedByUser
CreatedDate
ModifiedByUser (optional)
ModifiedDate (optional)
Store_ProductCategories
CategoryID
PortalID
ProductID
ViewOrder
Store_ProductImages
ProductID
ProductImage
AltText
ViewOrder
Notes
You should be able to add a product to one or more Categories, not select a single Category for a single Product.
ProductIDs should be added to ProductCategories to allow mutliple Products per Category, Products in multiple Categories.
A module can always be added to a page for Featured Products, or specialized Product Categories such as Featured, Popular, Special, Promotional, Clearance and Seasonal (Fall/Winter).
Modules settings work the same way using Category, although the query would be from ProductCategories and Categories not Products and Categories.
Store_ProductImages would be a separate control and token (Images) to display multiple images of a Product. May or may not be used.
A new field called ViewOrder will resolve most Category listings and arrangements.
These will rear their ugly heads down the road and be quite confusing if not changed upfront....
1) ModelNumber should be SKU (Stock Keeping Unit) or ProductSKU
2) ModelName should be Name or ProductName
3) UnitCost should be Price or UnitPrice if Units will be supported.
Any comments or suggestions?