Author Topic: Random products lost categories  (Read 611 times)

anonunder

  • Beginner
  • *
  • Posts: 21
  • A beginner
Random products lost categories
« 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

hellorain

  • Jr. Member
  • **
  • Posts: 126
    • Raincreatives - Virtuemart & Mobile Commerce Experts
  • Skype Name: raincreatives
Re: Random products lost categories
« Reply #1 on: September 11, 2019, 09:32:50 am »
Hello,


Are You using any custom template?

or some customization done in site.

Best Regards,
hellorain
Raincreatives - Virtuemart & Mobile Commerce Experts

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3025
  • VirtueMart Version: 3.6.3
Re: Random products lost categories
« Reply #2 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.
regards
A

Joomla 3.9.12
php 7.2

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Random products lost categories
« Reply #3 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

anonunder

  • Beginner
  • *
  • Posts: 21
  • A beginner
Re: Random products lost categories
« Reply #4 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?

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2451
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Random products lost categories
« Reply #5 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
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Random products lost categories
« Reply #6 on: September 12, 2019, 14:35:40 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!
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2451
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Random products lost categories
« Reply #7 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
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)