Selling clothes

[bigberge]

Hi.

 

I'm currently selling clothes on my oscommerce 2.2rca shopzone.

 

Actually, i have to make one product entry for each color. Because if i have White model L XL and XXL and Black model S M L XXL for example i cannot do a single product.

 

Thanks for your help

 

EDIT: :) my question is, is there a way to link COLOR and SIZE together ?

Edited April 10, 2009 by bigberge

[♥geoffreywalton]

Use product attributes

 

Colour and size as attributes.

 

The are contributions to sort the order that attributes appear in the drop down boxes.

 

Other useful contributions:

 

Stock by attributes

 

ajax product attribute manager

[bigberge]

Thanks alot, ill look for these!

[bigberge]

instsalling stock by attributes

 

I have a problem installing the code in the products_attributes.php ... i can't find some code lines... maybe someone can help ?

 

--Find--

<td align="right"><br><form name="option_order_by" action="<?php echo FILENAME_PRODUCTS_ATTRIBUTES; ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td>

 

--Change With--

<td align="right"><br><form name="option_order_by" action="<?php echo FILENAME_PRODUCTS_ATTRIBUTES; ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name" selected<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option>

</select></form></td>

--Find--

Edited April 11, 2009 by bigberge

[bigberge]

since it wasnt working, i put the original files back in the place of the modified ones... and now when i try adding a attribute it says:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values (null, '115', '3', '16', '0', '+')

 

[TEP STOP]

[bigberge]

1054 - Unknown column 'options_quantity' in 'field list'

 

select sum(options_quantity) as total_quantity from products_attributes where products_id='148'

 

[TEP STOP]

 

and this to.

[bigberge]

btw i also installed the ajax at manager. and its working from there...

 

maybe its that mod that is the problem... but i tried to just reinstall the whole shop with the same db... and the errors still come.

Edited April 11, 2009 by bigberge