darinaprior/Ruby-deMure — Issue #7: Allow a product to be in more than one collection
Author: darinaprior
Created: 2012-02-05 17:00:47+00:00
State: open

Originally I envisioned collections in the fashion sense e.g. Autumn/Winter 2012. But that's unrealistic in my business and therefore I am making collections more season- or genre-based e.g. Christmas or Steampunk.

Therefore a product should be allowed to be mapped to more than one collection e.g. both "Christmas" and "Menswear"

STEPS:
1. Create new table that simply maps a product id to a collection id in an n:m relationship
2. Copy current mappings from Product table to new table
3. Update ALL php files that refer to old Product table column to:
i) use new table instead
ii) allow for a product having multiple collections
4. Drop the old column in the Product table

N.B. The main issue with this is breadcrumbs. I need to devise a new breadcrumb system since the product page won't know which collection to show in the breadcrumbs.

*NEEDS FURTHER INVESTIGATION BEFORE IMPLEMENTATION*