Froogle Merchant Center merged into GoogleBase

[kbalona]

I have a problem. I'm trying to do the DB upgrade via PHPMyAdmin. But I get this error message:

SQL query: Documentation

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\'),'
);

MySQL said: Documentation
#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 ' configuration_value, configuration_description, configuration_group_id, sort_or' at line 1

Here's the mysql I'm trying to execute:

DELETE FROM zen_configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';

DELETE FROM zen_configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE zen_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 zen_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\'),');

[mydanilo]

Hi kbalona,

You are not alone. Same kind of error on my end. I posted it a few days ago but nobody seems to have insight.

I wonder, did nobody else have these #1064 - You have an error in your SQL syntax; errors?

Why is there a syntax error if the SQL patch is supposed to be sound? Any help or pointers is highly appreciated....

[kbalona]

OK I found out the problem with the #1064 error, there's an extra comma here: (extra comma in red)

INSERT INTO zen_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\'),');

That fixes that problem. Unfortunately, it's now giving the error (for me at least):

#1136 - Column count doesn't match value count at row 1

[kbalona]

Ok, it appears that there are two ways I got it to patch:
Either insert the column "configuration_key" between those 2 commas, or delete the comma, then delete the "NULL," before 'Condition',
problem is, I don't know which is supposed to be done, also the feed is still not generating a "condition" tag, so I still must be doing something wrong.
Idea, anyone?

[kbalona]

Ok, so now I have the "New, Refurbished or Used" options available in configuration in Admin>GoogleFroogle Configuration.
I set it to New. But still, the only tags that are being generated are:
title
description
link
price
image_link
expiration_date
label
id
currency

But no condition tag!! Why not?
btw, here's the modified SQL patch that works (added "configuration_key"):

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_key, 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 need to get this working!

[kbalona]

WOOOOOOOHOOOOOOO!!!!!
Yes! It's working! Apparently I hadn't uploaded the new googlefroogle.php to the store's root. (Actually, I believe what happened is that I forgot to check "overwrite old file", and I uploaded but it did not overwrite the old file).

Just make sure you upload all the new files correctly, and use this SQL code (I wonder if someone could change it in the download section?)

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_key, 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\'),');

[abecvar0627]

I have an issue with this mod. I've recently gotten a rejection from google base that the prices are not matching up. I am currently running a sale and they are complaining that the sale price is not matching with the price set in the froogle feed. I took a look and sure enough, the base price is being populated. I don't know if I got a froogle rep that was just having a bad day or not, but is this an issue for anyone else?

Thanks,
Anthony
http://www.mybabiesblanket.com

[JLA]

I have an issue with this mod. I've recently gotten a rejection from google base that the prices are not matching up. I am currently running a sale and they are complaining that the sale price is not matching with the price set in the froogle feed. I took a look and sure enough, the base price is being populated. I don't know if I got a froogle rep that was just having a bad day or not, but is this an issue for anyone else?

Thanks,
Anthony
http://www.mybabiesblanket.com

We have noticed the same thing. We started a sale and generated a new feed. The feed reflects the pre-sale prices only.

[Woodymon]

use this SQL code...

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_key, 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\'),');

Thank you for the fix in update_1_3_3.sql. Yes, the INSERT statement was missing the configuration_key parameter.

Note this SQL issue applies to upgraders only. It does NOT apply to fresh installs of this mod version.

Woody

[Woodymon]

1. Regards to Google now requiring the product "condition" within the Froogle feed, the current/latest Google Froogle for Zen Cart mod from Andrew (1.3.3) supports one of the following conditions for ALL of your products in your shop.

Choose your Product's Condition:
- new
- used
- refurbished

Since there is no "condition" field provided within default Zen Cart Product Types you cannot apply a condition to each individual product, thus the mod does the only thing it can do, applies a condition to ALL products.

2. Also note that support for manufacturer field in the feed is now gone.

3. I am unsure but Google may not support within their schema the ability to assign more than one price (regular price and sale price) for each product. But if someone wants to check with Google to see if they support multiple prices, maybe the needed logic can be coded into the mod, using existing code as an example.

4. Again I can understand why Andrew is ridding himself of the pain of supporting this mod. Attempting to match the schema of Zen Cart products to Google's constantly changing feed requirements is near impossible.

I hope it will become easier to support such endeavours when Product Types obtain an overhaul in future Zen Cart upgrades. Or maybe Zen Cart team will integrate this mod into Zen Cart and take over support

But in the mean time, if Google changes their requirements again, without a developer to take over support of this mod, Zen Cart shop keepers may be out of luck in getting their feeds accepted by Google.

Or as I mentioned before maybe Google will supply a developer/team to take over or assist with mod support.

Anyone know anybody at Google?

Woody