Categories
View Replies (6)

Resolved Loading related categories incorrect

  1. ptrouw
    ptrouw
  2. RO CSVI
  3. Thursday, 13 April 2017
  4.  Subscribe via email
I am loading a file with 2 fields: SKU and related_categories.
SKU^related_categories
ALF145MV^"Alfa Romeo[145 | 1994-2000"

SCVI gets the right category-id, but inserting this in the custom field table results in Related Products instead of Related Categories.
It shows the related product with the category id, instead of showing the related category with this id.
So
Categories:
Alfa Romeo=38
145 | 1994-2000=2974

But instead showing the product with this id
productid=2974

I saw this 1 month old post, but can not find the solution?
https://csvimproved.com/forum?view=topic&defaultmenu=1054&catid=44&id=33727&limitstart=0
0
Responses (6)
ptrouw
ptrouw
Accepted Answer Pending Moderation
Ok I did the suggestion from this other post, and changed the reseller id from 1 to 0, and now it works!
But same remark as in the other post, all my other entries are with reseller_id 1. Also the only reseller I have, has id = 1.
So what are the consequences of this change?
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The vendor_id as per VirtueMart installation files for related categories and related products in VirtueMart custom table is 0 and not 1. You can cross check this with VirtueMart installation files. The possibility could be that these rows were not updated while updating your VirtueMart previously.
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. # 2
ptrouw
ptrouw
Accepted Answer Pending Moderation
Hi Tharuna, Thank you for the explanation. I know this is more VM question, but should I change all vendor ids to 0? And what about the main vendor_id in the vendors table?
  1. more than a month ago
  2. RO CSVI
  3. # 3
ptrouw
ptrouw
Accepted Answer Pending Moderation
Just one more remark, I just had a look at the VM website site, it states: "A single vendor store just works always with virtuemart_vendor_id = 1."
So although the main virtuemart_vendor_id = 1 the id in the custom fields table should have 0?
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So although the main virtuemart_vendor_id = 1 the id in the custom fields table should have 0?

Yes, virtuemart_vendor_id for these two rows, related categories and related products in virtuemart_custom table should be 0 though main vendor id is always 1.
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
ptrouw
ptrouw
Accepted Answer Pending Moderation
thx have nice day
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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