Resolved Misspelt 'Color' - 'Colour'

Hello Jamie,

Can't you just rename the field?

Hello Jamie,
You can correct this from VirtueMart >> Custom fields >> Click on Color, it would show you a form in editable way, correct Color to Colour and save it. That should do. The import would have saved the details with id of the multi variant field and not by name so changing this wont have any problem as the id would still be the same.

I don't have either the color or size fields turned on. Only Multi variant, see screen shot.

Hello,

Edit the one called Multi Variant, I assume that is the one you used. In there you will find the Color word to rename if I am not mistaken.

Unfortunately not, see attached.

I've changed one product manually and then downloaded the sql file (identified as 'Colourrss'). Then replaced all clabel names, however when uploading the file I get duplicate errors warnings :-(

(7226, 4182, 8, NULL, '0.000000', 0, 0, 'usecanonical=0|showlabels=0|browseajax=0|sCustomId=0|selectType=0|selectoptions=[\n {\n "voption": "clabels",\n "clabel": "Colourrss",\n "values": "Multi"\n },\n {\n "voption": "clabels",\n "clabel": "Size",\n "values": "10\\r\\n12\\r\\n14\\r\\n8"\n }\n]|clabels=0|options={\n "4182": [\n "0",\n "0"\n ],\n "4183": [\n "Multi",\n "10"\n ],\n "4184": [\n "Multi",\n "12"\n ],\n "4185": [\n "Multi",\n "14"\n ],\n "4186": [\n "Multi",\n "8"\n ]\n}|', NULL, NULL, NULL, 0, '2016-10-31 13:12:39', 16, '2016-11-07 13:19:36', 16, '0000-00-00 00:00:00', 0, 0),

Hello,
Updating in database will be difficult as you may have to edit it for all parent products. The better way would be do the import again with correct name in your import file. If you have no other custom fields values stored you can empty the #__virtuemart_product_customfields table and do a fresh import.

Yes OK will do the only problem is I've made some changes within Joomla to product and images. When I download the export file with all the fields, it doesn't include the fields 'multi_variant_title' and 'multi_variant_fields'.

Is there a way to make these download so I've got the latest version?

Thank you.

Hello,

however when uploading the file I get duplicate errors warnings

Did you empty the database table before re-importing the file?

If you are using PhpMyAdmin, this also has a find and replace option under the Search tab, that may be another way to go.

CSVI doesn't export the 'multi_variant_title' and 'multi_variant_fields'.

OK, thanks guys - I will re-import my database. It's a pitty 'multi_variant_title' and 'multi_variant_fields' are not exported....