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
- atrus
- RO CSVI
- Wednesday, 15 February 2017
- Subscribe via email
0
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.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Thanks tharuna, indeed is 1 for rel products and 2 for rel cats.
see attached also pics from cf menu
rgrds,
chris
see attached also pics from cf menu
rgrds,
chris
Attachments (3)
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?
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
- 2
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »