Feature Request: Google Products Generation

Hi,

In the latest version of HikaShop that we released last week, you can now configure the plugin to generate the xml file on the server automatically with the cron task.
That way, you would just have to change the google_products.php to set the timeout to 0 and you would retrieve the XML where the plugin stores it without having to change the apache configuration.
We'll also add an option to set to timeout to 0 in the options of the plugin in next version.

Of course that you still get the error when you do it via the browser. It's not meant to do that for such an amount of products and that's why I recommended you to use the new options to generate the XML files automatically so that you can just have a download link for the xml file.
It's not really a matter of HikaShop. No matter what you do, having a process loading 50 000 elements with all their information (prices, discounts, variants, images etc) on one single PHP process requires a lot of resources.
On a normal products listing on your website, you display 20 products at once with a pagination to see the rest so 50K products is not a problem. But here, the system has to load everything on the page, and that's why you get that resources issue. Normally, with so much products, you wouldn't generate the XML dynamically each time someone request it. Instead, you would have it generated automatically once every day and then provide the link to the file (the same method I recommended in my previous message).

Yes, HikaShop is first designed for small shops even though it works better than a lot of mainstream solutions when you have a lot of products. Now, if you already have 30 secs of processing in Java (which is a hell faster than PHP) with your own queries (which are made for your specific case), it's no wonder that our script has a hard time doing the same thing. In such cases, not using PHP at all is better for the task
Don't hesitate to share your java script if you want. I'm sure it could help someone else in the future with the same need.

Hi,

Maybe the problem is not with the max execution time, but with the memory limit.
If you double the amount of products, the system will require twice the amount of memory in order to store all the product data coming from the database and twice the processing time.
So both limits should be increased. Then the trigger should work fine.
Even if you automatically upload it into google, you'll have the same problem as it will still require loading all the product data into memory. So really, increasing the limits of time and memory is the solution here.