1. atrus
  2. RO CSVI
  3. Wednesday, 15 February 2017
  4.  Subscribe via email
Hello to all,

Trying to import some related categories in VM3, but for some reason, CSVI instead of updating the related categories, updates the related products with some random products.

See attached relevant files/logs for your advice.

Rgrds,
Chris
Accepted Answer Pending Moderation
Hello Chris,
Can you send your #__virtuemart_custom table mysql dump in private message? I will run the import here with your table to check.
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
Accepted Answer Pending Moderation
Thanks Roland,

I checked virtuemart_customs:

Related products have field_type R
Related categories have field_type Z

Above our unique, i.e there is no other entry in the table with R or Z.

Rgrds,
Chris
  1. more than a month ago
  2. RO CSVI
  3. # 22
Accepted Answer Pending Moderation
Hello Chris,

CSVI doesn't actually force the ID of these fields but looks for them in the database based on their field_type. So I ran your import file you posted and the categories were assigned to the product.

Can you check in your database table virtuemart_customs which entry has a field_type of Z? Is there just one or are there multiple? The related products should be type R and the products type Z. I have the idea that your related products also has type Z.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Thanks tharuna, indeed is 1 for rel products and 2 for rel cats. rel1.jpg rel_products_cf.jpg rel_cats_cf.jpg

see attached also pics from cf menu

rgrds,
chris
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Hello,
In your phpmyadmin, what do you see in #__virtuemart_customs table for id 1 and id 2? As per VirtueMart id 1 should be for related products and id 2 for related categories. Your debug log says that processing has happened with id 1 which is for related products. So i would like to know what is actually stored in that table. Can you also post the screenshot of your VirtueMart custom fields page?
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. # 25
  • Page :
  • 1
  • 2


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