Some Product Fields are Missing #7966

Hello,

I am trying to import Virtuemart products and some of the fields I cannot manage to find in the list of Available fields.
The product_name field is not available.
I even tried the Update Fields Process but doesn't work. Please help

This could be problem with index of csvi_availablefields table. Can you try removing the table from phpmyadmin and run the below query? You need to run the update Available fields after that.

CREATE TABLE IF NOT EXISTS #__csvi_availablefields (
csvi_availablefield_id INT(11) NOT NULL AUTO_INCREMENT,
csvi_name VARCHAR(255) NOT NULL,
component_name VARCHAR(55) NOT NULL,
component_table VARCHAR(55) NOT NULL,
component VARCHAR(55) NOT NULL,
action VARCHAR(6) NOT NULL,
isprimary TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (csvi_availablefield_id),
UNIQUE INDEX component_name_table (component_name, component_table, component, action)
) CHARSET=utf8 COMMENT='Available fields for CSVI';

P.S: Please work on the tutorials..

Yes we are working on updating our tutorials, Thank you for feedback.

Hello,
Can you please confirm if you have replaced the table prefix #__ to your database table prefix while running the query?