[Closed] Does not show products on category page

Hi,

thanks for contacting us.

Please increase the WP Memory Limit. See https://wpml.org/it/faq/checklist-before-opening-a-ticket-in-wpml-support/#how-can-i-increase-my-sites-memory-limit
This is one of WPML minimum requirement so it might not work properly if you don't fix it.

Then, please set products in WPML > Settings > Post Type Translation as "show only if translated" and see if this fixes the issue

Hello,

Thank you for the updates. Please upgrade to the latest version of WooCommerce(8.7.0) and WooCommerce Multilingual(5.3.6) after a full site backup{mandatory}. Then clear all types of caches and make sure the problems remains or not.

--
Thanks!

Bigul

Hello!

I have a few questions for you:

1) How are you retrieving this content? it doesn't seem like you're using a page builder and you seem to be using a custom theme, are you doing something particular to retrieve this content?

2) Did this start happening after an update or after a certain moment in time?

3) Can you give me permission to disable plugins and the theme if needed? it seems this is a staging site, but please take a backup of the same all the same before i can do anything just to be on the safe side.

Let me know so i can understand how to continue.

Ok, i ran a few tests which can be seen here: hidden link

The problem is with the products per sé, they seem to be missing something in the database.

I saw that you have the translation editor enabled for all the products, yet they don't seem to be translated using our translation editor, but manually. i suspect they were maybe uploaded and linked via a plugin or something like that since it looks like there's something missing in the database.

My next question is: using the "calming cat" product as a reference. how did you create this product? did you create it in the back-end, imported it, linked it with a plugin, uploaded them with a plugin or via code?

This info will help me understand what i can do next, since if i just unlink the product and translate it again, the product then appears.

By the way, i enabled the debug log and i see this warning popping up quite often:

Warning: is_readable(): open_basedir restriction in effect. File(/var/www/vhosts/comadev.lv/gamestore.comadev.lv/wp-content/db.php) is not within the allowed path(s): (/var/www/vhosts/comadev.lv/:/tmp/) in /var/www/vhosts/comadev.lv/gamestore.comadev.lv/wp-admin/includes/plugin.php on line 464

I'm not sure if this could be pertinent to our problem but it's worth checking why it's happening, just to at least remove another variable from this problem.

Ok, i remember that you had mentioned the all import plugin. did you use our WPML ALL Import plugin? something went wrong there, not in the linking of the product but in the actual upload to the database and that's what created the entire issue because even if i unlink it, it doesn't appear UNLESS i search for it, which tells me that there are things that WP All Import left out.

WP All Import requires an add-on for WooCommerce, if i recall correctly and then an add on our end. i could see the products linked correctly so i take it you used our add-on but did you use the WC add on for wp all import?

I think i found the issue and it's a particular one!

It seems that you have a writing restriction on your site, which i actually thought was not important. however this restriction is preventing some files to actually work correctly on import/export workflows.

I suspect that it went through partially but not entirely.

I tried to download a copy of your site so i could send it to our devs and turns out that i couldn't even do that because of the restriction. can you please talk to your hosting and remove the restriction + allow me to try again so i can see how we can fix this problem?

I'm leaving the plugins installed on your site, but you can disable them in the meantime, if you want.

Regards.