Categories
View Replies (24)

Resolved VM import successful but product not in list

  1. SERVIZI2016
    SERVIZI2016
  2. RO CSVI
  3. Tuesday, 27 September 2016
  4.  Subscribe via email
Hi!

I managed to setup a template and did several successful test imports before running into this problem.
I removed a column from the template and the csv (product price) and removed the product from VM list. Product SKU is the same.
Suddently when i try an import it says "Success" and "Product updated" but no new product is added to the list in VM product browser. Maybe CSVI updates the trashed product? But how do i find out?

Joomla 3.6.2
VM 3.0.18
CSVI Pro 6.6.4

thanks
0
Responses (24)
tharuna
tharuna
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
SERVIZI2016
SERVIZI2016
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 22
tharuna
tharuna
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 23
SERVIZI2016
SERVIZI2016
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 24
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!