Resolved Not able to import/export VM products: Unknown column 'c.category_parent_id' in 'field list'

Hello,

I downloaded your last version but can not work with VM producs, even running the example export products template I get this error: Unknown column 'c.category_parent_id' in 'field list'
I've read a similar post but the recomendation was to install ro csvi last version, what I already have. Any tips?

The problem is with your VirtueMart version. Starting from 3.6.11 version VirtueMart has a new field category_parent_id in #__virtuemart_categories table. Your version is one less than this version and these is no field in the table. Go to file plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php and on line 796 remove 'c.' from 'c.category_parent_id' so it is just 'category_parent_id', save the file and run the export. See if you still get the error. Other option is to update your VirtueMart version.

I also couldn'r find the way to import all the product's custom field values (by the way, not all of them are available as templates fields). This is important because I'm working with many custom fields inside each product!
Using Joomla 3.9.18 and VM 3.6.10

Please update your available fields and then check if you see the custom fields after that.

Hi Tharuna,
Thanks for your answer.
Ok with the VirtueMart version, I will probably update it instead of changing your code.
But with the Custom Fields I have updated available fields already several times and there are some of them that are still not showing.

Hello,

Ok with the VirtueMart version, I will probably update it instead of changing your code.

You can apply the attached patch file so the error is gone with your VirtueMart 3.6.10 version . This fix will work for VirtueMart versions less than 3.6 and for versions above 3.6 as well. Let me know on how the export goes with the fix.

But with the Custom Fields I have updated available fields already several times and there are some of them that are still not showing.

You need to tell us the custom field type which are not showing. You can also send us screenshots of custom fields from VirtueMart Custom fields page.