Resolved Some Product Fields are Missing

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.

Thank you for the reply.
Have tried the above method and it doesn't seem to work because when I run the Update Available Fields, I am taken to the frontend/homepage and an Error Message is displayed
An error occured processing the records. The error occured is shown below if available. Additionally check your server log for any errors or warnings.

Thank You

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

Thanks.. that works..
appreciate it.