Login
Register

VirtueMart

WooCommerce

Others

Docs

Support

Blog

About

Auto Parent Categories for VirtueMart

Open ToolsOpenTools LogoText 100px 

IMPORTANT ANNOUNCEMENT: Plugin development ceased, all plugins made available freely (GPL)

With great sadness we have to announce that we are ceasing development of all our VirtueMart, WooCommerce and Joomla plugins. Effective immediately, all our plugins -- even those that were paid downloads -- are made available for free from our homepage (GPL license still applies), but we cannot and will not provide any support anymore.

It has been a great pleasure to be part of the thriving development communities of VirtueMart as well as WooCommerce. However, during the last year it became painstakingly clear that in addition to a full-time job, a young family and several other time-consuming hobbies at professional level (like being a professional singer) the plugin development and the support that it requires is not sustainable and is taking its toll. It has been an honor, but it is now time to say good bye!

×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC:

Virtuemart 2 Auto Product Categories Plug In 23 Jan 2014 23:31 #1

  • Gherasim
  • Gherasim's Avatar Topic Author
Hello

(Edited on February the 2nd to clarify the problem)

I have a website based in Joomla and VM for administrating the products. My product catalogue contains almost 4 millions of products and when I run your plug-in to extend products categories to all parent categories the run ends up with an Internal Server Error.
By investigating the causes of this error it seems that it is caused by the plugin exhausting the memory available on the server due to the number of products to be managed in this case (the plugin was indeed working perfectly at the beginning when the number of products was only of few hundreds of thousands).

I'm quite new to php and sql but I think it could be possible this error it is caused by how the plugin is coded in terms of managing the data in processing product after product.
I would really appreciate if you could give a look at this, in the meanwhile I will try to put my hands on your code.

Many thanks!

Regards

Virtuemart 2 Auto Product Categories Plug In 10 Feb 2014 21:02 #2

It's quite possible that a huge number of products causes memory exhaustion. In particular, the plugin loads all products in memory and then loops over them:
		$products=$this->getAllProducts();
		[..]
		foreach ($products as $p) {
		  [..]
		}

To solve your problems, this part of the code would need to be changed to load one product after the other...

Virtuemart 2 Auto Product Categories Plug In 04 Jul 2014 09:10 #3

  • whoaloic
  • whoaloic's Avatar
I get the same problem although I have around 5000 products.
The changes seem to be done but I'm not sure all products have been assigned into parent category.

Virtuemart 2 Auto Product Categories Plug In 04 Jul 2014 09:11 #4

  • whoaloic
  • whoaloic's Avatar
I get the same problem although I have around 5000 products.
The changes seem to be done but I'm not sure all products have been assigned into parent category.

Where is the code to change?
IS there any chance to be fixed in a future update to avoid page breaks?

Best regards.

Virtuemart 2 Auto Product Categories Plug In 07 Jul 2014 21:56 #5

The code that would need to be changed is in the file vmAutoParentCategories.php in the function updateCategories.

Unfortunately, I don't have the time in the foreseeable future to change/fix this problem.

Sorry,
Reinhold
  • Page:
  • 1