Wednesday 14 September 2005 6:48:00 pm
Hi again, I am yet to implement my catalogue but I have identified the general structure of the content. I would like to hear some more opinions/suggestions and/or corrections on the following ideas that I have been tossing around. I have started testing some ideas for the catalogue and trying to establish the structure to some degree, in the process it has become a more complex task than I had hoped. I'll try to illustrate the structure and the ideas I have considered to accomplish it. This is going to be hard to explain, but please try to stick with me! Basically the catalogue is a paint catalogue so there are many things that need to be taken into account. I have created a class for the product that contains a title, a description and a related object for a.) a USA image b.) an AU image etc. This class is a container as it will contain other classes/objects such as the following table: -
Series 1 Colours
|-----------------------------------------|
| | Product Code |
| |-----------------------|
| Colour Name | 40ml | 250ml | 1Litre |
|-----------------|------|-------|--------|
|[swatch] Name | 0694 | 0695 | 0696 |
|[swatch] Name | 0684 | 0685 | 0686 |
|[swatch] Name | 0674 | 0675 | 0676 |
| |
|repeat rows |
|-----------------------------------------|
For this class (Product Colour Table) I have used the matrix datatype, There are a number of sizes ranging from 40ml up to 2Litres so I have made a column for each one in the matrix, most products only come in three sizes but those sizes are different depending on the product/Series. Also the product codes don't change per region. As you can see I have used (ml) as the standard measurement, if I was to add the US equivalent (fl.oz) I would end up with possibly 50 to 60 columns in my matrix. I figure this leaves me with two choices. 1. Duplicate the Product Colour Table class for each region. The down side to this would mean I would have to do twice as much work to enter the data. 2. Use a custom translation/conversion file? to convert for example(250ml) to (8.4fl.oz) depending on site access and/or translation. This would mean I only have to enter data once, all I need to be sure of is that I have covered every possible size in the matrix and in the translation/conversion file. Option 2 is the way I would like to go but I am unsure if this is even possible, can I make a custom translation file, and if so how would I instruct my templates to use it? I hope all of that makes some sense, I'd like to hear what any of you think and any suggestions that may help to make this possible would be greatly appreciated. Cheers!
Pardon me while I burst into flames...
|