Google Base Feeder Support Thread [OLD]

[chenfire]

I discovered the reason.
execute the code of googlefroogle.sql will update some records in table configuration, so our web page can not display properley.
but I do not know how to solve it. anybody can help me?

[chenfire]

I do not know what is the reason.
my zencart is v1.3.7 I have integrated with ultimate seo module.
after I installed GFF1.6.7
the webpage error. the infromation is below:

Warning: Variable passed to each() is not an array or object in /home/public_html/includes/classes/db/mysql/query_factory.php on line 121

Warning: Division by zero in /home/mallmain/public_html/includes/classes/split_page_results.php on line 76

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '136' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]

anybody can help me?

[Ryk]

I have found the answer to our CRON problem which may just help others, even though it may just be something to do with our server.

The instructions for the CRON command show:

GET http://domain/googlefroogle.php?feed=yes&upload=yes&type=products

which failed consistently for us; however, simply adding single quotes

GET 'http://domain/googlefroogle.php?feed=yes&upload=yes&type=products'

finally brought success.

I think the requirement for the quotes is due to the multiple instructions within the command.

[keylesslocks]

So, I completely removed all files and and uninstalled and then reuploaded all files and reinstalled sql and then it said:

1062 Duplicate entry 'GOOGLE_BASE_ZERO_QUANTITY' for key 2
in......

thanks,

Eric

[SuperDak]

I'm experiencing some problems with the feeder. I recently tried to upload a new feed but the feed was rejected because it was missing the UPC field. I turned on the auction feilds and now I get the following error:

Google Base Feeder v.1.6.8 02.08.2008 22:33:59 started 2008/02/26 18:14:29
Feed file - /home/moesperf/public_html/feed/prommotion_moesperformance_com_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.products_type = 1 OR p.products_type = 4 OR p.products_type = 2 OR p.products_type = 5 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC] 

I tried a upgrade to 1.6.8, but still get the error. Any idea what I need to do to get things working agian??

[CyberCIO]

For those whom employ Google Checkout I have heard a rumour that a future update to the GC mod will integrate Google Base feed functionality.

Woody

I just wnated to see if there was an update or mod for this? I have GCO and still have to go in and modify each item to turn on GCO as a payment option to get the checkout badge to appear. When the feeder uploads to Google, it overwrites the configuration and I have to do it again. I'm sure that I am either overlooking something, or have not configured something right. Any help would be appreciated.

this is according to google:
If you'd like to use Google Base-hosted item pages and accept Google Checkout for items in a data feed, simply add "GoogleCheckout" as a payment option under the payment_accepted attribute. Don't include the link attribute. If you do, your listing will direct buyers to your website, instead of a Google Base-hosted page that displays the Google Checkout Buy button.


If you're already using Google Checkout on your website, include "Google Checkout" as a payment option under the payment_notes attribute. In this case, you should include the link attribute, as users will be directed to your Google Checkout-integrated website.


I am using the Level 2 Zen Google Checkout module. So the second statement should apply.

[kitcorsa]

still getting this error please help

upload not working through my fireplace site. bathroom site works fine.

Warning: ftp_put() [function.ftp-put]: Transfer complete. in /home2/public_html/googlefroogle.php on line 547
Second attempt (passive mode on): Upload Failed

[SuperDak]

Still having issues with the feeder... This time I tried v1.6.10 on a FRESH install with no mods, same error:

Google Base Feeder v.1.6.10 02.28.2008 12:13:59 started 2008/03/01 04:02:37
Feed file - /home/pmlcover/public_html/feed/pmlcovers_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN specials s ON (s.products_id = p.products_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 ORDER BY p.products_last_modified DESC] 

Can someone please tell me whats going on?? I never knew how much froogle adds to our sales untill this

[numinix]

Install AUCTION SITE ATTRIBUTES to add the UPC and ISBN fields to your products admin page.

[tolefairy]

I have installed the newest version of google base feeder and configured it.

When I try to create the feed I get this error

Warning:  array_pop() [function.array-pop on line ]: The argument should be an array in /home2/shabecom/public_html/craft-patterns-online.com/googlefroogle.php158

can you tell me where I went wrong?

many thanks