Resolved VM import successful but product not in list

Do you have these multiple languages saved in VirtueMart >> Configuration >> Language settings?

Yup
[IMG size=400]http://i63.tinypic.com/2r2unu9.jpg[/IMG]

I tried filtering as you suggested, unfortunately only one row is shown: the duplicate entry i manually inserted, i think
[IMG size=400]http://i67.tinypic.com/mt5yfs.jpg[/IMG]

additionally i tried adding another test product with CSVI, with an unique SKU, this too is not showing in VM product list nor in site frontend (i used published=1 as a default in the template). Adding the log.

Maybe i should have mentioned i migrated the entire site from joom 2.5 and VM/CSVI old versions to new ones. I followed the migration istructions for CSVI and things were working before this particular issue.

Hello,

You are right, i have a multilanguage VM setup. Question is, if i delete a product from VM admin control panel, shouldnt it delete the entry from both tables? I can't seem to access the product now in VM menus, it doesn't shows up.

Yes, VM deletes the product from both the tables if there is an entry. But not sure why the product is still in your en_GB table. Do you have these multiple languages saved in VirtueMart >> Configuration >> Language settings?

As a test i manually added a product with same SKU, name and subcategory. Published, it correctly shows up in the site frontend, in both languages i have. But trying to update it with CSVI returns the following error:
An error has occured during the import. Below the information received from the server.
Duplicate entry '2764' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='2764',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2016-09-27 15:09:56',`created_by`='46',`modified_on`='2016-09-28 10:33:16',`modified_by`='46',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='04779663'

Probably i could just reset VM products database and proceed for a full fresh import. But i'm worried my client could run into this kind of problems if he decides to hand-tune some of the products :unsure:

The duplicate error says that there are two records in your VirtueMart product table with same product_sku value. In VirtueMart products page, try filtering with '04779663' value, you should be seeing multiple rows. You need to delete one so you wont see this error.

You are right, i have a multilanguage VM setup. Question is, if i delete a product from VM admin control panel, shouldnt it delete the entry from both tables? I can't seem to access the product now in VM menus, it doesn't shows up.

[IMG size=400]http://i66.tinypic.com/2ktg3.jpg[/IMG]

As a test i manually added a product with same SKU, name and subcategory. Published, it correctly shows up in the site frontend, in both languages i have. But trying to update it with CSVI returns the following error:

An error has occured during the import. Below the information received from the server.

Duplicate entry '2764' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='2764',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2016-09-27 15:09:56',`created_by`='46',`modified_on`='2016-09-28 10:33:16',`modified_by`='46',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='04779663'

Probably i could just reset VM products database and proceed for a full fresh import. But i'm worried my client could run into this kind of problems if he decides to hand-tune some of the products :unsure:

Hello,
Your debug log says that your product is still in the VirtueMart product table and so it is updating. The language table of VirtueMart used in the import as per your debug log is English(en-GB). Once the product is deleted in VirtueMart it will be completely erased from VirtueMart tables too and are not kept in trash.Probably you must be having a multi language installed in your VirtueMart and would have deleted this product from a different language table?