Resolved VM3 Related Categories Issue

Thanks Tharuna,

Yeah, that is the Cloudflare firewall, i managed to get the import finished anyway, and it looks good! Will continue the testing and let u know if i see smth else, thanks for the fixes!

Rgrds,
Chris

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.

Thanks Tharuna!

I can see it is working now, we are almost there but need to check also the attached complete custom field import which gives a 500 server error.

I also checked the server log, see attached the errors.

Would appreciate your assistance!

Rgrds,
Chris

Hello Chris,
I have replaced a file on your site with some code changes and now both related categories and related products is working. Can you check and confirm? These code changes will be included in our next release.

Hello Tharuna,

Thanks for the feedback, i confirm that the import file i sent you before works ok now

However, i did some more tests with more custom fields included in the import, (including also related products) and noted that the import is broken again.

See attached another test import so that you may check if possible.

Thanks!
Chris

Hello Chris,
Can you check your site now with import? Related categories seems to work good. Check and let me know.

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

Thanks,
Chris

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

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,

Sent already, pls check and let me know!

Rgrds,
Chris

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

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.

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 Tharuna,

Pls see attached.

Rgrds,
Chris

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

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,

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.

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,
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?

Sure Roland, pls see attached.

Thanks,
Chris