Resolved VM import successful but product not in list

I'll take a look for what i missed. Thanks.

Hello,
The problem is you have used the category_name from your virtuemart_categories_it_it table to do import in virtuemart_categories_en_gb table. The category_name 'B - Immunochimica' exists in your virtuemart_categories_it_it table but it is different in your virtuemart_categories_en_gb table. To do multi language import in VirtueMart you need to follow the tutorial Setting up multi language in VirtueMart and use translation language file. That should solve your issue.

Ok, changed "immunochimica" (it) to "immunochemistry" (en) in the csv and the import worked.
So if i change both site language and the CSV base language to en-gb this can be done. I will try to use this solution to solve the issue, hoping the base csv catalog can be agreed to be modified such way with my client.

What is strange is that both the ita csv file and site language setting were working fine, before and after the migration, for a period of time. I did several test imports before the problem arised. Any thoughts what could have caused this issue?

Thanks

Hello,
Yes, there are migrated data but the cause for the whole issue is the wrong category_name in category_path. For example for category_path 'B - Immunochimica/ADVIA® CENTAUR/Reagenti/Funzionalità Tiroidea (metodi in chemiluminescenza)/T3', the actual parent for 'ADVIA® CENTAUR' as per the old database records is 'B - Immunochemistry' and since the name is different, CSVI has created a new category structure for the given path. As i said already, CSVI checks if the given category_name is available by including its parent category name and with parent category ids, if not found it would insert a new record else it would update. This is the cause for the new categories entries. Kindly check and let me know.

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

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.

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,

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

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.

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?

Ok, just sent you a PM

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.

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

here is the log

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.

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.

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

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!

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.

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,

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.