product database design

[Guest]

For my product list, each one has about 10 "properties" that describe it.

These can have any values, some numerical and some are words, so they don't

fit into Product Options nicely.

 

Any ideas on the best way to incorporate this into the oscom databases?

 

Should I pack all the "properties" into the Product Description,

or should I create a new table like categories_description, but call it

categories_properties (so that it has 10 fields)?

 

Any other ideas?

 

It seems either way, I am going to require my own homebrewed php code to handle

these properties.

 

Thanks,

bob

[jeffy777]

I've used this contrib:

http://www.oscommerce.com/community/contri...arch,add+search

 

which allows you to add new fields to your existing product tables. That way it's easier to update the existing database queries instead of adding new custom queries if you made a whole new table.

[Guest]

Category Fields (which is derived from the one above) allows you to do it on a per category basis :D

 

Matti

[Guest]

Those sound exactly like what I was looking for.

 

Thanks Jeff and Matti!

:D

[Guest]

I've run into a problem with the manual install.

for the file admin/catalog.php

 

the lines:

 

foreach ($extra_fields_array as $key=>$val) {

?>

<b><? echo $extra_field_name[$key];?>:</b> <? echo $val;?><br />

<?

}

 

cause my admin/catalog.php page to disappear

(i.e. an error in the php code.) If I comment it out, then

it parses ok.

 

The problem seems to be with ?><b><? and ?> </b> <?

 

any ideas?

[Guest]

I've run into a problem with the manual install.

...

 

 

hmmm nevermind. I took the code from the original files

instead of the instructions.txt manual instructions, and

it is now working.

(although I am not sure why it is now working, cause it

looks the same. I must have had a tiny typo somewhere).

 

:huh:

 

Cheers,

bob