Customer comment for each product in order

[cable]

Merry Xmas everyone!

 

I run a florist web-site, and one thing that is bugging me is how to add the option for a user to type in the message for the card on each bouquet, etc.

 

Any help gratefully received!

Thanks

Adam

[burt]

There is a contribution that can accept a text input. Search through the posted contributions.

[cable]

Thanks for that Burt... have you got the specific name for it?

 

Thanks!

Adam

[Guest]

the contribution is called

 

option type feature.

 

It was written (not by me) prior to the new checkout procedure (post Nov. 1st)

 

If you are using a later snapshot (like me) it is a pain in the backside to setup. Only started using php/mysql a few months ago and hacked at it till i got it to work.

 

There is a limit of 32 characters per text option, so for a full card you would probably need to have say 3 or four text options.

 

To see it in action visit

http://www.mainframes.co.uk/mf/catalog/default.php

 

browse categories personalised gifts/names in frames and then any product.

 

This store is not yet live although some of it is finished, so you can put through a test order if you like, just say so in the order comments.

 

cheers

barry

[burt]

There is a limit of 32 characters per text option, so for a full card you would probably need to have say 3 or four text options.

 

Change this quite easily using PHPmyAdmin, change from Varchar(32) to VarChar(255)...

[Guest]

does this not cause problems elsewhere and or require major recoding.

In the docs for this mod it states this very fact, hence why it is set at 32 and not 255.

 

cheers

barry

[Ajeh]

32 * 1000 products vs 255 * 1000 products ... I think for speed purposes and perhaps space this would be a consideration.

 

Otherwise, why not make all fields monsterously huge? :shock:

[burt]

The effect of changing a varchar from 32 to 255 will make no *discernable* difference.

 

It is still one call to the database. :shock:

[Ajeh]

Hate to sound lame ...

 

What about space issues? And, doesn't this effect performance in some manner or is that mainly when a search is done or some type of relationship issue is involved on a field that is larger?

[Guest]

being no php/sql guru i did not sway from the guidelines in that particular mods readme regarding the database fields for fear of killing my store.

 

needless to say i will now mod the database entries for this mod.

 

cheers

barry

[burt]

What about space issues?

Will only cause a slightly larger database if every order has a text input of 255 characters. For most hosts that shouldn't be an issue.

 

I regularly work on a MySQL database that holds more than a million records across just over 500 tables...

 

And, doesn't this effect performance in some manner or is that mainly when a search is done or some type of relationship issue is involved on a field that is larger?

1 call to the database is 1 call...so, whether that call is getting 1 character or 255 characters makes no *discernable* difference (we are talking milliseconds).

 

Size is not important, it's what you do with it that matters. <ahem> ;)

[burt]

being no php/sql guru i did not sway from the guidelines in that particular mods readme regarding the database fields for fear of killing my store.

 

Always backup your database before working on it. Then if it does all go wrong, you can simply re-install.

 

That Mod is one of the most difficult to install - I'm not going to bother with it again as it is so time consuming to get right...

[Ajeh]

Size is not important, it's what you do with it that matters. <ahem> ;)

 

Does your mother know where your mind goes when it drifts ... 8)