VirtueMart

WooCommerce

Others

Docs

Support

Demo

Blog

About

Forum
Welcome, Guest
Username: Password: Remember me

TOPIC: Virtuemart 2 Auto Product Categories Plug In

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

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
The administrator has disabled public write access.

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...
The administrator has disabled public write access.

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

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.
The administrator has disabled public write access.

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

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.
The administrator has disabled public write access.

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
The administrator has disabled public write access.

VM - Shopping cart

 x 

Cart empty

Login Formular