News:

Support the VirtueMart project and become a member

Main Menu

Maxed out custom field - color list

Started by fritschle, August 30, 2013, 07:10:23 AM

Previous topic - Next topic

fritschle

I have an issue and can't seem to find an answer to it on here.  I have a list of colors for a product.  When I went in to add a few more colors to my cart variant list, I clicked in the default box and went to add my few more colors.  I hit a limit.  I still have a few more to add. Is this a character limit, a max option limit?  How do I get around this?

Thanks.

Maxim Pishnyak

Could you post here a screen shot of your issue?
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

fritschle

Here you go.  Hopefully this will clear up what I was talking about.

The full list of items in the box is:
Select;Black;Brown;Burgundy;Carolina Blue;Cherry;Clear Coat;Crimson;Dark Mahogany;Ebony;Flame Tempered;Gold;Gray;Green;Hunter Green;Mahogany;Navy;Natural (Unfinished);Neon Green;Neon Orange;Neon Yellow;Orange;Pink;Purple;Red;Royal;Silver;White Wash;Yellow

[attachment cleanup by admin]

Maxim Pishnyak

Are you sure that this is the only method to work with cart variants? Check video tutorials in my signature.

Also you could check Product Options Custom Field Dropbox Plugin (from moderator of 3rd party forum section). This free plugin has much higher list limit.
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

fritschle

First off.  Why are you asking me a question related to your videos?  I don't have time to watch every video in your list.  If there is one that would help, let me know what it is and I'll gladly watch it.

Secondly.  I didn't know there was a limit.  I have a number of products already in that use this color list and I'd prefer not to have to completely change each product to the extent of removing and adding back 30+ custom fields. 

I would think that there should be a way to just change the limit on this field.

balai

Hi

The answer is yes there a limit that field has limit of 255 characters

You have 2 options:
1) Go to your database through your phpmyadmin and find the table 'virtuemart_customs ' there go to the table's structure and change the 'custom_value' field from char to varchar and its length from 255 to something higher e.g. 1024

2) To use this plugin: http://breakdesigns.net/extensions/customfields-for-all
It has no limit to the the number of values that can be used and also is suitable for color customfields
Afaik. this is going to be released the next days

Maxim Pishnyak

Quote from: balai on August 30, 2013, 11:22:20 AM
1) Go to your database through your phpmyadmin and find the table 'virtuemart_customs ' there go to the table's structure and change the 'custom_value' field from char to varchar and its length from 255 to something higher e.g. 1024
Next VM update could 'restore' original custom field limit.
You can support Community by voting for Project on the JED
https://extensions.joomla.org/extension/virtuemart/#reviews
Join us at
https://twitter.com/virtuemart

Kintaro Oe

is there a reason to limit this field to only 255 chars? :(

GJC Web Design

probably not - it is just a figure - the smaller the figure the less usage of mysql resources -- 255 is a common figure chosen
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation