Adding a product code to attributes

[galey1981]

Hi All

 

I need to add several product attributes to my shop. To the customer visiting my site the usual Colour: Black and Size: XL is fine and is how it should be.

 

However in the backend and through the order confirmation emails that my supplier gets they need to see the attribute as a product code. All their stock and inventory is packed closed in boxes and they use unique product codes to identify the different attributes.

 

I can't call the attribute for example, Colour: Black BL100031

 

What i thought i could do was add a column to the table product_options_values and call it products_options_value_code and add it in here directly. Too much hassle to set up another column in the attributes page of admin.

 

then i'd need to call the value of this table to my backend to appear in the order summary page, and also on the order confirmation email the supplier gets. So there's an extra line in my order summary page, and on the email, showing the value of the field i created earlier. But I dont know how to do this - i assume i need to add it in to checkout_process so the value gets taken through?

 

If anybody understands what i'm saying could they help me out?

[GVinc]

Did you get any advice on this topic or resolve the issue? I too want my customers to select their options but I want the order to include the model number and price that corresponds to their options. It would be great to have this on the product attribute entry screen to make it easier to enter.

 

Please let me know

 

Gvinc