Values from customer text inputs not saved to product attributes in order_items

[vigier]

Hi,

I got the first part of the customer text input working. A customer can input the width and the height of the article and select some other options.
If you look at the shopping cart, it shows the values, but without the title of the field and the values aren't separated by a space of something else. That's the first problem. All the other selections (from dropdowns) do show up as they should. When the customer places the order and I look at the order, the values from the input boxes are gone. The aren't in the description anymore. That's the second problem.

I attached an image with screencaptures of the process.


I looked in the virtuemart_order_items table and the value from product_attributes of the item shown in the picture above was:

Code Select Expand

"{""29"":""29"",""28"":""28"",""19"":"" <span>Raamsluiting : <\/span>Handgreep"",""21"":"" <span>Raamuitzetter : <\/span>Geen"",""24"":"" <span>Uitzetterpen : <\/span>Geen"",""26"":"" <span>Oplegslot : <\/span>Geen""}"

As you can see in the first part (around the red text "Selecting") of the above picture, the options from the dropdownboxes haven been saved correctly (only Raamsluiting has an other selection than "Geen", that's correct), but the values from Breedte and Hoogte haven't been saved. The weird thing is that they do show up in the shopping cart before checking out. After checking out, they are gone.
I hope you can fix this! Where this means: adding the fieldtitle to the description and the values of the customer_text_inputs to the product_attributes...

Kind regards,
Vigier

P.S. This is a better and more complete description of topic http://forum.virtuemart.net/index.php?topic=98714.0. Maybe we should close that topic.

[vigier]

In the meantime I found out something else. This is another product with 2 customer_text_inputs and one dropdown box. This generates the following product_attribute in the database:
{"15":"15","14":"14","16":" <span>Profielkeuze : <\/span>Enkel glas (38x67mm)"}

If I add another customer_text_input to my product, after the dropdown box, a saved product_attribute looks like this:
{"15":"15","14":"14","16":" <span>Profielkeuze : <\/span>Enkel glas (38x67mm)","47":"47"}

It looks to me that the product_attribute consists of pairs of options. Field 16 contains the value of dropdownbox Profielkeuze. I checked it when I looked at a product that uses more dropdownboxes.
For the customer_text_inputs, it writes the field_id (or somehting) and instead of the user value after the colon, it writes the field_id again.
So if I can find the script that creates the product_attribute, I can do two things:

• Check if it "asks" the user input from the submitted form info
• Check if the writing procedure writes the field id or the requested user input

So who knows where I can find that procedure/script? Or is this something I should leave to the VirtueMart programmers?
Edit: I've looked at the plugin-code and I think I better leave this to the programmers...

[vigier]

Nobody any idea? Did anyone get this to work on his/her own site? Any help would be appreciated.

Kind regards,
Vigier

[vigier]

Does this mean that there's no one that uses custom_text_plugin for user input for the product?

[Milbo]

Thanks for your good report, I am on it.

[osp]

Hello vigier,

try the patch attached...should work after apply...

Ondra

[attachment cleanup by admin]

[vigier]

Hi,

@Milbo: good to know! Thnx
@ondrejspilka: thnx, this is getting better, but not perfect. What happens with your patch:

• General: the fieldname is still not shown in the minicart&cart&order&order administration.
• If the product only has this inputbox and no other options, it shows the text of the input field on all necessary places, even the confirmation mail.
  The product_attribute from the database: {"2063":{"textinput":{"comment":"123456789"}}}
• If the product also has other options, for example some dropdowns, the old problem is still there, no idea why!
  Some examples of product_attributes that don't show up well in the orderadministration, cart or anywhere else:
  {"15":{"textinput":{"comment":"4444"}},"14":{"textinput":{"comment":"5555"}},"17":" <span>Profielkeuze : <\/span>Dubbel glas (54x67mm)"}
  {"29":{"textinput":{"comment":"123"}},"28":{"textinput":{"comment":"456"}},"19":" <span>Raamsluiting : <\/span>Handgreep","22":" <span>Raamuitzetter : <\/span>Vaste standen","25":" <span>Uitzetterpen : <\/span>Twee uitzetterpennen","27":" <span>Oplegslot...
• General: the good part is that in all the versions I tried, it writes the types value to the database!

Kind regards,
Vigier

[osp]

Well good to know is all values are stored in database, it was the intent of the fix..

Combo customfields and their  names are shown  correctly for me.
Are you talking about default lists or your own plugin?

[vigier]

These are standard comboboxes, Cart variant if I name them correctly. Those are shown as they should. The custom_text_input works as well, as long as I don't combine them with the comboboxes. Then only the selection of the combobox are shown, the content of the custom_text_input is not shown on the order.

[osp]

Try next release 203b, I suppose will be released soon in the forum.
Milbo already incorporated this fix and some others...

[vigier]

I see the 2.0.3 already, just downloaded it... thnx

[vigier]

Hi,

with 2.0.3b I still have my problem. The values are written to the database:
{"15":{"textinput":{"comment":"1234"}},"14":{"textinput":{"comment":"4567"}},"17":" <span>Profielkeuze : <\/span>Dubbel glas (54x67mm)"}

But still as a comment and it's not visible if I show my orders, so there's still some work to be done I guess...

[Studio 42]

Hi vigier,
I tested the text Input and have display in card and order.

Have you update the allinone, because plugin file are in all in one.

[zzsser]

Hi, I have exactly the same problem with textinput plugin. The text is displayed in cart until the confirmation. But in order (in the confirmation mail and in the backend), the input text has disappeared.

Installation of com_virtuemart.2.0.3.b_extract_first.zip doesn't resolve this problem. I use J 1.7.

[osp]

Please send us printscreens of BackEnd customfield list and Customfields page from product detail.

The only invalid configuration we resolved is when one textinput customfield is used in product twice.
Eg you define customfield Dimension of type textinput and then you add two "Dimension" customfield values to product.

This scenario will not work by design, separate customfields must be used / instead of dimension eg Width and Height...