1. DirtyFurClothing
  2. RO CSVI
  3. Friday, 27 April 2018
  4.  Subscribe via email
Hi. Importing related categories populates related products instead of related categories with duplicates.

Joomla! 3.8.6
VirtueMart 3.0.18
PHP Version 5.6.33
CSVI Pro 7.6.1
Accepted Answer Pending Moderation
Sorry. Tested on various other SKUs and it seems to be fine.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Updated and related categories are populated. However, related products are also getting duplicates.

Thank you.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Found the issue, the value of virtuemart_vendor_id field in #__virtuemart_customs table should be 0 but in your case it is 1. This field would have not been updated when you did your VirtueMart update. CSVI checks for related_products and related_categories with virtuemart_vendor_id as 0 in query and since there is no value returned the default value 1 set for virtuemart_custom_id in #__virtuemart_product_customfields is used. You need to change virtuemart_vendor_id value to 0 for these two rows and then run the import.
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. # 3
Accepted Answer Pending Moderation
Sure thing, thank you.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Looking at the query in your debug log, the id of the related products has been inserted though you are importing related_categories. I would like to see the values stored in your #__virtuemart_customs table for related categories and related products. The first two rows in the table. Can you send a screenshot of it?
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. # 5
  • Page :
  • 1


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