Hello, I am using Zen 1.5.0 and when I enable the UPC/ISBN/EAN in the configuration to TRUE and try to "confirm" I get this error: (
Google Merchant Center Feeder v started 2013/02/18 16:42:36
Feed file - /home8/wwrepair/public_html/parts/feed/google/wwrepair_products_en.xml
Processing: Feed - Yes, Upload - No
WARNING: An Error occurred, please refresh the page and try again
If I change the UPC/ISBN/EAN back to false, it will upload only some of my products. I do use the UPC field but not ISBN (Numinix Product Fields Module). The last upload had 3017 and after trying to get the UPC to work it only uploads 1645 (again I have to disable the UPC filed in admin or I get an error). Any help is greatly appreciated. Thank you!
I checked my debug log and this is what is says:
[18-Feb-2013 17:12:59] PHP Warning: fopen(/home8/wwrepair/public_html/parts/module_version/google_merchant_center_feeder.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 81
[18-Feb-2013 17:12:59] PHP Warning: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /home8/wwrepair/public_html/parts/module_version/google_merchant_center_feeder.txt in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 82
[18-Feb-2013 17:12:59] PHP Warning: fread(): supplied argument is not a valid stream resource in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 82
[18-Feb-2013 17:12:59] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home8/wwrepair/public_html/parts/includes/classes/google_base.php on line 83
[18-Feb-2013 17:12:59] PHP Fatal error: 1054:Unknown column 'p.products_ean' in 'field list' :: SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_upc, p.products_isbn, p.products_ean
FROM znc_products p
LEFT JOIN znc_manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN znc_products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN znc_product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = 1
AND (
p.products_image IS NOT NULL
OR p.products_image != ''
OR p.products_image != 'no_picture.gif'
)
GROUP BY pd.products_name
ORDER BY p.products_id ASC; in /home8/wwrepair/public_html/parts/includes/classes/db/mysql/query_factory.php on line 101


Reply With Quote
