VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: anonunder on September 11, 2019, 08:37:05 AM

Title: Random products lost categories
Post by: anonunder on September 11, 2019, 08:37:05 AM
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
Title: Re: Random products lost categories
Post by: hellorain on September 11, 2019, 09:32:50 AM
Hello,


Are You using any custom template?

or some customization done in site.

Best Regards,
hellorain
Title: Re: Random products lost categories
Post by: AH on September 11, 2019, 09:46:19 AM
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.
Title: Re: Random products lost categories
Post by: Milbo on September 11, 2019, 14:51:24 PM
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.
Title: Re: Random products lost categories
Post by: anonunder on September 12, 2019, 11:26:19 AM
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?
Title: Re: Random products lost categories
Post by: Jörgen on September 12, 2019, 13:15:51 PM
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
Title: Re: Random products lost categories
Post by: Milbo on September 12, 2019, 14:35:40 PM
Quote from: Milbo on September 11, 2019, 14:51:24 PM
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!
Title: Re: Random products lost categories
Post by: Jörgen on September 12, 2019, 14:47:33 PM
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