Product customisation. Help?????

Hi I'm trying to make a seperate field that will be displayed on screen as 'Bottle Size' ('Product Size').

So far I have managed to create a text field in the admin system and created a new field in the database named 'products_size'.

I've created the text entry field in collect_info.php by adding the following code

This displays the new field but now I need to make sure that the information entered into the new text box is also entered into the database and displayed on screen when a product is displayed.

I think by the looks of things I'm about halfway there but I need help with ensuring the information is entered into the database once the product is saved and then I need to know which file I need to edit in order to get it to display.

Please Please can somebody give me some pointers??????? As I'm really tearing my hair out. This field is essential to my site.

I'm using V.2.0 by the way.

Many Thanks

Nick

I'm using V.2.0 by the way.
Where did you get that???
To my knowledge this has not been released yet??

As to the size issue:

I think that you are making this much more complicated and messing with the DB adding things when it is a builtin function and called "attributes"
https://www.zen-cart.com/tutorials/index.php?article=57

Hi Kobra, sorry its 1.3.8 I think not v2.0.

I've attached a document showing what I'm trying to do.

I've had a look at the link you sent. I don't want this to be something that people select. This will be text only and purely for information on the product. So can I do this by using attributes?

Many Thanks

Nick

Couldn't actually read the screen shot but this is the admin area...
So I probably do not comprehend why, or what it is you are attempting??

Ok, I want to have an extra text entry field that appears on all products in the admin system. This will be 'Bottle Size' and will allow me to enter 75cl 90cl, 120cl or whatever size. Once the information has been entered and submitted it will be displayed under 'Product Information' on the site and will be for nothing other than display and information purposes. It won't be something that is entered into the cart.

I've been in to product attributes but am struggling to understand how this works, however have noticed that its possible to create new attributes which I assume get added into the admin area of all products and then an admin user can enter that information in the product which will be displayed on the site. Is that correct?

If so I'm having trouble with this.

I'm getting this error

Attribute Option and Option Value Do NOT Match - Attribute was not added - Bottle Size : TEXT

So what do I do?

Thank You

This will be 'Bottle Size' and will allow me to enter 75cl 90cl, 120cl or whatever size.
If I understand this and it is similar to other types of issues.
You have a bottle product that is available in several sizes, Now one can create separate products for each OR one product with optional size selection ability.

If this is the case then attributes created for size and added to these products from the admin so that the customer is provided and sees the options to select from is what you need.

To do this correctly the tutorial outlines this for size as an example. Just follow closely the steps

Or, if you really don't have the same product available in different sizes (which is what attributes can do nicely), but instead you offer different products and just want to tell the customer how big the bottle is, then why not enter the bottle info into the text field where you enter the product description?

Rob

Because I want to be able to enter bottle size in a text field in the admin system. Otherwise I have to type 'Bottle Size' next to the bottle size each time I enter this information.

kobra:

If I understand this and it is similar to other types of issues.
You have a bottle product that is available in several sizes, Now one can create separate products for each OR one product with optional size selection ability.

If this is the case then attributes created for size and added to these products from the admin so that the customer is provided and sees the options to select from is what you need.

To do this correctly the tutorial outlines this for size as an example. Just follow closely the steps

No Kobra this is not what I want. I want to create a way to select a bottle size in the admin. This will then be displayed as text on the website I'm creating. I do not want a customer to be able to select bottle size as there will only be one size for each product. Most will be either 75cl or 150cl. Ideally I would like to be able to create a selection box in the admin so for example either 75cl or 150cl can be selected in order for it to show up on the site as text only.

The customer will then only see 75cl or 150cl next to the bottle size details so they know that the bottle they will buy will be the size stated. They won't be able to change bottle size from say a dropdown menu or radio buttons as there will only be one size per bottle.

This thread may be what you're looking for.

Rob

rstevenson:

This thread may be what you're looking for.

Rob

Thanks Rob, I think this is what I'm after. I could do it with product attributes but it would be a rediculous and long winded process when it would be far simpler to have the option to do this in the product information entry area. Also I need to create another section in this to enable me to enter the year of produce since the site is selling wines and any wine connoisseur will find this information essential to making a selection to buy.

I will give this a go as it looks like it might work. If not can I come back to you?

Sure. I may not be very helpful if that thread doesn't do it for you, but you can ask. :laugh:

Rob

rstevenson:

Sure. I may not be very helpful if that thread doesn't do it for you, but you can ask. :laugh:

Rob

Hi, I follwed the instructions from the thread and everything works great apart from I cannot get the information that is being entered into the database to display on my site. I suspect I'm missing something really simple but I have followed the instructions very carefully.

These final two bits are definately in place (see below)

7. edit 'main_template_vars.php' (in /includes/modules/pages/product_info/)
around line 46 you find the variable $sql set. like in step 3.2 add the new rows with a 'p.' in front just before the 'from'
select ......., p.products_guarantee, p.products_color from ....
.
   8. last step: display the new infos
edit 'tpl_product_info_display.php' (in /includes/templates/template_default/templates/)
now, wherever you want, you can add to the html:
<?php echo $product_info->fields['products_guarantee']; ?> and <?php echo $product_info->fields['products_color']; ?>

So not sure where I might be going wrong. If you can help that would be great.

Many Thanks

Nick