Froogle Merchant Center merged into GoogleBase

[Woodymon]

Did anyone notice the Feb 15 2007 posting of a "Google Froogle Feeder 1.33a" mod in Zen cart downloads area (uploaded by Allan Aoyama)? I did not observe a release announcement in this thread on the Contributions forum. Apparently just includes a SQL typo fix for the last version Andrew released.

I just did a compare of 1.33 vs. 1.33a and only diff was the following change in update_1_3_3.sql

Removed an extra comma and a space from the last INSERT statement. But also you you can observe the line ending semi-colon was moved from the end of the same statement to the very beginning. This is incorrect!

Previous version SQL (1.33): update_1_3_3.sql.bak

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE configuration SET configuration_description='Choose your product type' WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE';

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;

INSERT INTO configuration (configuration_id, configuration_title, , configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),');

Updated SQL (1.33a) update_1_3_3.sql

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';

DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE configuration SET configuration_description='Choose your product type' WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE';

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;

;INSERT INTO configuration (configuration_id, configuration_title, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),')

I have not run this updated patch so not sure if the moved semi-colon would have any negative effect on processing the SQL patch.

Note that this sql patch file is for upgraders only. If you're installing the mod "fresh" then only need to run googlefroogle.sql.

To bypass the upgrade patch issue altogether I would recommend that upgraders just run uninstall.sql and then run googlefroogle.sql.

(Of course do this after documenting your mod settings and after backing up your database).

Woody

[RSprinkel]

Ok I am trying to use this Mod and In the Config I specified FREE Shipping. Well apparently Google doesn't like it as it kicked it back giving me the "Shipping field was incorrectly specified - help FREE SHIPPING #Item", We do offer Free Shipping on all items and thats what I was trying to specify.

Any help would be much appreciated.

Thanks,
Ron

[samad64]

Ok I am trying to use this Mod and In the Config I specified FREE Shipping. Well apparently Google doesn't like it as it kicked it back giving me the "Shipping field was incorrectly specified - help FREE SHIPPING #Item", We do offer Free Shipping on all items and thats what I was trying to specify.

Any help would be much appreciated.

Thanks,
Ron

It requires a numeric value.. so just put 0.00 in the proper format that google requires

[RSprinkel]

Samad64,

Thanks for the info. CHanged the setting and uploaded another batch to see how it goes. Will let ya know.

Again Thanks very much for the help.

Ron

[RSprinkel]

ok I have tried 0.00 as well as 0 and still getting the same errors. Sheesh it must not like me

Ok here is the right format per their help section. Sorry should have gone there first.

Their method is - US:Ground:5.95

Again I do apologize.

Ron

[samad64]

ok I have tried 0.00 as well as 0 and still getting the same errors. Sheesh it must not like me

Ok here is the right format per their help section. Sorry should have gone there first.

Their method is - US:Ground:5.95

Again I do apologize.

Ron

NP.. i would have told you what the method was but i couldn't remember it and i was too lazy to go look it up as well .. sorry about that! glad you got it figured out though

[PhillipHarrison]

i cant get my items uploaded anymore :

Bulk upload failed. No items are live. There are too many formatting errors in your file.

is there an update or something?

thanks

[RSprinkel]

samad64 - LOL yeah me too. But hey I got it working and everything is searchable now. THANKS for the help, LOL.



PhillipHarrison - To the end of that Bulk Upload Failed there should be something that says check errors or help or something. Click that and it will tell you where the problem is. I got that message quite a few times yesterday and I clicked on some text at the end and it basically told me it didn't like my shipping structure. I am sure that is a global error message that you will get when you have ANY errors in your information. If you find out what is causing it, post it and I am sure someone can help then. That information isn't really telling us much other then there is issues with your upload.

Sorry couldn't be of more help at this time.

[PhillipHarrison]

ah ha! Any advise on this please? The price difference is probably because the normal price is 37.95 but theres a sale price on the site 34.16

Hello,

Thank you for submitting a bulk upload to Google Base. We have reviewed your bulk upload and need you to make changes. Your bulk upload has been disapproved due to the reason(s) listed below.

Issues:

1. Wrong prices
2. Unsupported "label" attribute

-----------------
1. Wrong prices: Please ensure the prices that appear in your bulk upload match the prices that appear on your item pages. For example, for your item named "MONTANE FEATHERLITE SMOCK," you included "37.95" as the price. However, the price is listed as "34.16" on the item page. Recheck your bulk upload and ensure that all prices match the prices that appear on your item pages.

2. Unsupported "label" attribute: We noticed that you included the "label" attribute in your bulk upload. Please note that we recently changed our attribute requirements and are no longer supporting labels. While including labels will not cause your file to fail, we strongly recommend that you remove this attribute from your file.

[RSprinkel]

PhillipHarrison - Did you generate your .txt file through ZenCart and then upload it?

Ok I looked in how my clients was created via ZenCart and it only added the sale price and not the Regular Price as 99.7% of my clients items has a sale price on them. I am not sure if it makes a difference or not on how you create the sale price but I did my clients via Admin/Catalog/Specials.

AS far as the Label Attribute I am not sure. Cause my clients has label in it and it lists the "Master Category, Sub Category" for each item under the "label" column.

This is all I can say for now, I am not an expert of this as I still HAVE tons to learn so I can't really say for sure on what to do other then tell you how I have set up my clients site.

Hope it helps some.