Resolved VM import successful but product not in list

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?

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,

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.

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,

I tried filtering as you suggested, unfortunately only one row is shown: the duplicate entry i manually inserted, i think

Just to confirm again if you have duplicates, If you know how to do, can you go to phpmyadmin, look for table `#__virtuemart_products` and on the SQL tab, paste the below query and click Go? Dont forget to replace #_ with your table prefix before running the query.

Select * from #__virtuemart_products where product_sku ='04779663'

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.

VirtueMart uses Joomla default language to display its products from language tables. I think in your Joomla admin >> Extensions >> Languages, you would have set default to be Italian but then CSVI import is done with English tables. Try to change your Joomla default language to English and see if you see your test product?

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.

I think your issue has nothing to do with migration, it is just the language settings in VirtueMart which has to be sorted out.

Here's the result of the query, duplicate confirmed
[IMG size=400]http://i64.tinypic.com/33omx6b.jpg[/IMG]

I tried switching the administrator language to English, both as default or just switch, and tried to upload the test product. Same result, nothing showing in VM product listening. But running a query in phpmyadmin shows that the product was added to VM db table.

I want to thank you Tharuna for the effort you are showing for my case, amazing support!

Hello,

Here's the result of the query, duplicate confirmed

You need to remove one so you dont see the duplicate error any more.

I tried switching the administrator language to English, both as default or just switch, and tried to upload the test product. Same result, nothing showing in VM product listening. But running a query in phpmyadmin shows that the product was added to VM db table.

I am so sorry that i forgot to mention to switch the language of Site and not administrator. Please try it and let me know.

I want to thank you Tharuna for the effort you are showing for my case, amazing support!

Thank you so much. if you liked our service and our product please write us a review on Joomla extension directory.

switch the language of Site

That was it! This solved the problem, i tried several test imports and it is working like a charm.

Thank you so much you totally deserve a good review on JED!

Glad to know that your issues are solved. Thank you so much

It seems i rushed to the point, problem is still pending.
Import is working fine, but now CSVI is creating new VM categories with same name but different aliases, resulting in the site template not working as expected in several sections for both languages.

This happens when my language is ENG as default.

Hello,
Can you post the debug log of this import to check? The debug log attached in your previous post says that category exists and product category relation has been inserted and no new categories are created as per the log.

Hello again
I deleted any additional unwanted category and tried a similiar import, resulting again in added duplicate categories.

here is the log

Hello,
I see what you are saying in your debug log with categories. Can you send a private message with your category table mysql dump and also your import file? I will test in my local server and see what is going wrong. You can also send it as email to tharuna@csvimproved.com.

Ok, just sent you a PM

Thank you for sending the mysql dump, can you also please send your virtuemart_categories_en_gb table mysql dump where the actual data is stored?

Hello,
I tried your import file with the template attached in your previous post and did import thrice and dont see any duplicates with categories. So i guess there are some entries for these categories already with different slug and while you import new entries are inserted. I can check more if you can provide me with your category language table mysql dump.

Hello,

Where do you see the duplicate categories? Can you post a screenshot to clarify what you see?

Hi Roland

sure, here it is. The duplicate category is "T3"
site language default is now en-gb

[IMG size=400]http://i67.tinypic.com/2zdq245.jpg[/IMG]

Hello,
Thank you for the screenshot, that really helped. I think i figured out the cause for your issue. The issue could be because that each category is linked to its parent in #_virtuemart_category_categories table and CSVI query for category already available check runs including this table and probably it is empty for your old categories. Since the query returns null, CSVI is inserting a new category with new slug. You mentioned that your data has been migrated from old version, please check if this #_virtuemart_category_categories table data has been migrated.

I see, that's probably the cause. I don't know how to really figure out if the table has been migrated, i'm sending you an export via PM.

Thanks