Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

I've encountered an error with the feed not running completely. There are a total of 853 products in the store. I'm having to run the feed in two batches with 800 products in one go with a further 53 products in the 2nd go. The error message shown is - WARNING: An Error occurred, please refresh the page and try again. Checking the debug files I see the following message:

[11-Feb-2015 16:02:21 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: SELECT master_categories_id FROM products WHERE products_id = 2529 LIMIT 1;

[11-Feb-2015 16:02:21 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total from sessions where sesskey = 'hllll7cj3169a9hbkfjoi3jo02'

A couple of points:

1. The feed was working fine up until two weeks when the site was upgraded to php version 5.4.35
2. If the shipping options is not set within the Google Merchant Center Feeder Configuration then the feed runs fully without any issue.
3. Removing some extra data such as additional image or payment type usually helps add 2 or 3 products to the number it will run successfully.

Server Settings
max_execution_time: 60
max_file_uploads: 256M
max_input_nesting_level: 64
max_input_time: 1024
max_input_vars: 8000
memory_limit: 1000M
Zen Cart Version: 1.5.1
Host: 1&1

Any advice would be appreciated.

Quote:

---

Originally Posted by jxl1

I've encountered an error with the feed not running completely. There are a total of 853 products in the store. I'm having to run the feed in two batches with 800 products in one go with a further 53 products in the 2nd go. The error message shown is - WARNING: An Error occurred, please refresh the page and try again. Checking the debug files I see the following message:

[11-Feb-2015 16:02:21 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: SELECT master_categories_id FROM products WHERE products_id = 2529 LIMIT 1;

[11-Feb-2015 16:02:21 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total from sessions where sesskey = 'hllll7cj3169a9hbkfjoi3jo02'

A couple of points:

1. The feed was working fine up until two weeks when the site was upgraded to php version 5.4.35
2. If the shipping options is not set within the Google Merchant Center Feeder Configuration then the feed runs fully without any issue.
3. Removing some extra data such as additional image or payment type usually helps add 2 or 3 products to the number it will run successfully.

Server Settings
max_execution_time: 60
max_file_uploads: 256M
max_input_nesting_level: 64
max_input_time: 1024
max_input_vars: 8000
memory_limit: 1000M
Zen Cart Version: 1.5.1
Host: 1&1

Any advice would be appreciated.

---

• Speak to your host.. (the memory issues are SERVER related)
• Upgrade to the commercial version of this plugin which is better suited to manage larger uploads.. (I think it is one of the few mods offered by Numinix with THANKFULLY doesn't REQUIRE the CSS/JS Loader to WORK)

hello? my post above?

One problem is if the image file name has a double space. Only one %20 is put instead of two of them.

actual url

Code:

---

.....15E-5%20%20-251005.jpg

---

reported to google

Code:

---

.....15E-5%20-251005.jpg

---

The other problem is if there is an & symbol, in the filename, no image url is uploaded at all.

I can only assume the image url is being encoded twice, or being pre processed at some stage and the & symbol is messing things up.

perhaps & at some stage become & then the rawurlencode doesn't know what to do with that...

Setting

Code:

---

Image Handler --> false

---

fixes the image output problem.

So it would be safe to presume Image Handler is causing the issue...

and now I know why you don't see this as an issue... Image Handler Readme

Quote:

---

Make sure that your main product image files names DO NOT contain any special characters (non-alphanumeric characters such as / \ : ! @ # $ % ^ < > , [ ] { } & * ( ) + = ). Always use proper filenaming practices when naming your images

---

Will move my problems to image handler thread...

Just a quick follow up on my issue:

The issue was hosting related & unfortunately we are using the highest specification hosting package with 1&1 so there was no possibility of increasing the memory limit.

The solution we found was to remove 'out of stock' products from the feed. By 'out of stock' I mean products that have 0 quantity but I do want visible on the website. This reduced the products generated by around 150 & so the feed runs in one go once again.

Thanks for your reply DivaVocals, it's much appreciated. I had previously spoken to 1&1 support but back then I assumed the error was due to the script timing out & so the discussion we had revolved around extending the 60 second max execution time.

Hello, I am trying to add the Numnix product fields for product dimensions to my product feed. I am using Google merchant center feeder 1.14.3.

The fields seem to be installed correctly, I can save and view them in the admin product page. How ever the fields are not showing up in my product feed. How do I tell the product feed to include the new dimension fields?

Thank you,
Jacob

My feed is no longer working correctly, and I am not sure where to start to troubleshoot. I get the following:

Google Merchant Center Feeder v started 2015/03/15 12:44:32

Feed file - /home/motori5/public_html/catalog/feed/google/domain_products_en.xml

Processing: Feed - Yes, Upload - No

id: 1, price: 169.99, description length: 1451 - including - success

id: 3, price: 169.99, description length: 1356 - including - success

id: 4, price: 179.99, description length: 1578 - including - success

id: 6, price: 19.99, description length: 407 - including

WARNING: An Error occurred, please refresh the page and try again.


Item 6 has not been changed in well over a year. I have tried excluding the category that the product is in and the feed still fails. Can someone provide direction on how to start troubleshooting this?

Start by looking in your /logs directory (Zen Cart v1.5.1 and later) or /cache directory for earlier versions. You'll see a file named myDEBUG-adm-???.log that contains details of the issue.

Make sure to xxx-out your admin folder's name if you post a myDEBUG-adm- file's contents for help!