Random products lost categories

[anonunder]

Hello,

i am running shop with 5000+ products, daily sales and each product has a lot of categories.

Some products in list of all products, doesn't have categories,

Image: http://prntscr.com/p4koxy

But if I click on product it appears,

Image: http://prntscr.com/p4kp5a


If I save, it will have again categories, but a lot of products have this problem, and a lot of products doesn't have any category even if I click on a product.

Is there any solution for fixing this and what is the cause?


VM: VirtueMart 3.2.14
JOOMLA: 3.8.7
PHP: 7.3

[hellorain]

Hello,


Are You using any custom template?

or some customization done in site.

Best Regards,
hellorain

[AH]

it could be the old save product before categories are loaded in ajax - bug

Solved in the latest version

Sometimes if your users are quick it was possible to save a product change before the categories were loaded

This resulted in the product belonging to no category.

Which seems to be your issue.

[Milbo]

AH that is not the case here, because he shows the same product. One time in the list without categories, the other time in the product edit and it has categories.

VM: VirtueMart 3.2.14
I really think you should update! Updates within vm3 are usually easy.

[anonunder]

Yes I am using custom template, from sparky framework.

Also, this "website" had problems with SEO, so i hard coded some stuff ( didnt change any core file ).

Updating VM can maybe fix the problem, but is there any solution to bring back categories, without backup?

[Jörgen]

The categories are lost if this happens, the entry in the database is lost forever. Without a backup there is no solution. You could make a sql script sthat "copies" categories to similar products according to for example Your SKU scheme. But this is an advanced piece of custom coding.

Jörgen @ Kreativ Fotografi

[Milbo]

AH that is not the case here, because he shows the same product. One time in the list without categories, the other time in the product edit and it has categories.

VM: VirtueMart 3.2.14
I really think you should update! Updates within vm3 are usually easy.

So the categories are still there!

[Jörgen]

Sorry Milbo I missed that he shows the same product, different view, disregard my previous post. Is there something common with the product that do not show categories in the product listing for backend ? Some special character or category name that breaks the render ?
The category is working in the front en yes ?
Do You have any overrides for the back end theme or plugin that could interfere ?

As Milbo sais the categories are there, it is the render in the product listing that dos not show them.

Jörgen @ Kreativ Fotografi