Resolved VM3 Related Categories Issue

Hello Chris,
I did some more fixes and now the 500 error is gone but at around 2600 lines during import, i am seeing a 524-timeout error. I tried changing import lines and wait time in product import template settings on limits tab but that did not help. I am thinking if your server is denying my request after some seconds and so i get this timeout error. Can you run the import yourself and see if it completes? The error seen is attached. Please talk to your hosting provider on this error.

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?

Thanks tharuna, indeed is 1 for rel products and 2 for rel cats.

see attached also pics from cf menu

rgrds,
chris

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.

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

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.

Sure Roland, pls see attached.

Thanks,
Chris

Hello Chris,
Found the problem, the virtuemart_vendor_id in your #__virtuemart_custom table is 1 for both related products and related categories but it has be 0. I am not sure how it has been changed but 0 is the value inserted when you install VirtueMart. Can you change this virtuemart_vendor_id value to 0 for both related products and related categories and then do the import?

Thanks Tharuna!

I'm not sure also, but vendor_id is 1 all over my installation, i.e. all relevant tables have id = 1, so changing to 0 is a bit tricky. Maybe i can change to 0, then import, then change back to 1 for this table only.

Maybe it would be better for CSVI to support multi-vendor export-import anyway? So that we may be able to select vendor at template settings?

Rgrds,
Chris

Hello Chris,

I'm not sure also, but vendor_id is 1 all over my installation, i.e. all relevant tables have id = 1, so changing to 0 is a bit tricky. Maybe i can change to 0, then import, then change back to 1 for this table only

vendor_id 1 is the default value in VirtueMart but for these two rows related product and related categories vendor_id is 0, you can cross check in VirtueMart installation files.

Maybe it would be better for CSVI to support multi-vendor export-import anyway? So that we may be able to select vendor at template settings?

CSVI has no control on the related products and related categories fields, these are core VirtueMart rows and I dont think adding the option of multi-vendor for export/import will anyway help as the virtuemart_vendor_id for these two rows are going to be 0.

Hi Tharuna,

Changed vendor_id to 0 in _customs table, run import but again same result.

Then switched back to 1 and tried also to change :

where($this->db->quoteName('virtuemart_vendor_id') . ' = 1') in adminstrator\components\com_csvi\addons\com_virtuemart\helper\com_virtuemart.php

run again, but same result!

Rgrds,
Chris

Hello Chris,
Can you again send me your #__virtuemart_customs table with the changes you made?

Hello Tharuna,

Pls see attached.

Rgrds,
Chris

Furthermore, all the other custom fields for the imported products were lost unfortunately... There is no way to append new custom field values to the products without erasing the old ones?

Rgrds,
Chris

Hello Chris,
Thank you for sending your virtuemart customs table, you changes look good and it should import correct after these changes. Can you send me your administrator and database access details to check?

Furthermore, all the other custom fields for the imported products were lost unfortunately... There is no way to append new custom field values to the products without erasing the old ones?

You can avoid losing the old custom fields by setting Delete custom field relations to No in your template settings and on options tab.

Hello Chris,
Thank you for sending your site access details. Can you also send me your database access details?

Hi Tharuna,

Sent already, pls check and let me know!

Rgrds,
Chris

Hello Chris,
It looks like CSVI has been blocked in your site. When i run the import, it takes me to front end. Can you check your .htaccess file and unblock CSVI? Can you also post your ftp access details? I see something weird happening with related categories and loading a patch file for every change is getting difficult.

Hi Tharuna,

Will send you the ftp details with PM.

Now for the block it's weird, i think it has to do with Cloudflare, need to dig further. reverting.

Rgrds,
chris

Hi Tharuna, you can do the import and your tests now, it's ok.

Thanks,
Chris