News:

Support the VirtueMart project and become a member

Main Menu

Random products lost categories

Started by anonunder, September 11, 2019, 08:37:05 AM

Previous topic - Next topic

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
Raincreatives - Virtuemart & Mobile Commerce Experts

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.
Regards
A

Joomla 3.10.11
php 8.0

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

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!
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.