Webshop / Product Category / Product Specification

Author Message

Nicolas Ottavi

Monday 15 May 2006 5:02:30 am

Hi there,

For a future webshop I have to implement a kind of matrix for each product. This matrix will contain product features/specifications. Each product is member of a product category (ie TV > LCD TV). All the products within this category will have the same kind of specifications (with different values).

The specificity is that:
- Each product in a given category have the same specifications
- The category page will display a kind of comparative table which will display products as rows, and as columns we will have product prices, and 3 or 4 specifications selected by the client. (This can be changed). You can see an example of what is expected here:
http://www.darty.com/webapp/wcs/stores/servlet/DartyVerticalComparatorView?storeId=10001&u=2&r=12458&f=1115&drct=1&fsel=1

At the beginning of the project I was planning to use the matrix datatype. But this will need to be customized to fit the following needs:
- Some specifications can be added to a product category/family.
- Some could be deleted
- Some products can have an empty value for a given specifications
- The specifications can be reordered.
- The specifications that will be used on the category page can be selected by the site admin and can be changed.
- The specifications list should be managed on the category level, and in case of change should update all products of this category.

In a perfect world, the product specifications should be managed while creating/editing a product. So object relation is not the best solution.

As we will have a lot of product categories (about 50), having one class per product family is not, to my point of view, a good solution, as It could be hard to manage (even if we could group this into a class group).

If you have any idea on how to implement this the best and effortless way, your help is highly welcome !

Thanks for your time and your help,

Nicolas
Internethic.com

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 31 2025 03:42:13
Script start
Timing: Jan 31 2025 03:42:13
Module start 'layout'
Timing: Jan 31 2025 03:42:13
Module start 'content'
Timing: Jan 31 2025 03:42:14
Module end 'content'
Timing: Jan 31 2025 03:42:14
Script end

Main resources:

Total runtime1.0665 sec
Peak memory usage8,192.0000 KB
Database Queries46

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0048 588.2656151.2266
Module start 'layout' 0.00480.0034 739.4922220.7188
Module start 'content' 0.00811.0574 960.21094,149.7969
Module end 'content' 1.06560.0009 5,110.00787.8125
Script end 1.0665  5,117.8203 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00330.3061160.0002
Check MTime0.00120.1093160.0001
Mysql Total
Database connection0.00080.073910.0008
Mysqli_queries0.997193.4888460.0217
Looping result0.00040.0372440.0000
Template Total1.021995.820.5110
Template load0.00180.169220.0009
Template processing1.020195.647020.5100
Template load and register function0.00130.117510.0013
states
state_id_array0.00180.165710.0018
state_identifier_array0.00150.137320.0007
Override
Cache load0.00140.1295220.0001
Sytem overhead
Fetch class attribute can translate value0.00180.167510.0018
Fetch class attribute name0.00160.149410.0016
XML
Image XML parsing0.00010.009610.0001
class_abstraction
Instantiating content class attribute0.00000.000410.0000
General
dbfile0.00150.1405100.0001
String conversion0.00000.000540.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 10
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs