Froogle Merchant Center merged into GoogleBase

[ctcentralinfo]

Now the feed file is 4 mb.

[rcrosier]

I just noticed that I'm having a problem with the Google Froogle feed.

I HAD a "Salemaker" sale, that ended 4/15. However, the froogle feeder is STILL sending the SALE price to the TXT file.

I even DELETED all of the "Sales" I had set up, but it's still sending the sale price.

Has anybody seen this and/or fixed it? Or does anyone have a cure for it?

I also checked to be sure I don't have "specials" on the items, and don't.

Thanks.

[rcrosier]

I just noticed that I'm having a problem with the Google Froogle feed.

I HAD a "Salemaker" sale, that ended 4/15. However, the froogle feeder is STILL sending the SALE price to the TXT file.

I even DELETED all of the "Sales" I had set up, but it's still sending the sale price.

Has anybody seen this and/or fixed it? Or does anyone have a cure for it?

I also checked to be sure I don't have "specials" on the items, and don't.

Thanks.

OK, I did a little digging, and it looks like the Froogle Feeder is using 'products_price_sorter' for the data, and in my 'products' file, many of my products SALE price is in there...

how do I clean that up? What is that field for?

Thanks!

[rcrosier]

OK, I did a little digging, and it looks like the Froogle Feeder is using 'products_price_sorter' for the data, and in my 'products' file, many of my products SALE price is in there...

how do I clean that up? What is that field for?

Thanks!

SOLVED! FYI, somehow, during setup, ZenCart must have used a different currency conversion...??? I deleted all that we don't use (Euros, GB lbs, etc) and ran the 'update products price sorter' in store manager, and that fixed them all.

Anybody know what can cause those prices to be wrong? We have never KNOWINGLY used anything but USD...

[dealbyethan.com]

Hi,

I ran your sql code but received the following error. What went wrong? Please advise. Thanks.

1146 Table 'dealbyet_zc2.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

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

[Woodymon]

Hi,

I ran your sql code but received the following error. What went wrong? Please advise. Thanks.

1146 Table 'dealbyet_zc2.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Note your TABLE Names have a prefix:

dealbyet_zc2.configuration_group'

Prefix is:

dealbyet_zc2

You can edit the SQL to append your prefix (wherever a TABLE name is observed).

But if you copy the existing SQL from a text editor and then paste into Tools >Install SQL patches it should work, without first editing SQL. But do NOT upload. (Install SQL Patches is suppose to auto append you DB table prefix but some issues with different server configurations).

Much previous discussion about this common issue in this thread (and same discussion in Google Sitemap and User Tracking support threads in this forum).

Good luck,
Woody

[NamSingh]

Woody,

Google have started rejecting my feed due to now unsupported field "label" and also they are not allowing the product type to be called "other". I've had a look at the feed and the easiest way to fix is to rename the label field and call it product_type. Have you already done this or should I get hacking code?

[a_berezin]

Note your TABLE Names have a prefix:

dealbyet_zc2.configuration_group'

Prefix is:

dealbyet_zc2

It not prefix, this name of a database

[dealbyethan.com]

Hi,

This is confusing. I previously run the sql by pasting and sending it in the admin but it didn't work. Can someone please tell me the exact sql code I need to use based on the error I get in order to make the froogle module work on my website? Thanks.

[Woodymon]

Note your TABLE Names have a prefix:
dealbyet_zc2.configuration_group'
Prefix is: dealbyet_zc2

It not prefix, this name of a database

Andrew is of course correct. I'm not dyslexic but the mind was somehow registering the underscore (_) and period (.) in reverse. My apologies.

What is the name of the SQL file you are attempting to patch with and what version of the GoogleFroogle mod?

It appears the SQL patch you may be running is a version updater and not the full SQL patch.

Did you have this mod (or a previous version) installed previously and are trying to upgrade? Or is this suppose to be a fresh install?

Try running googlefroogle.sql (this is the patch for new installs as described in the readme). Then no need to run the other sql patches

Woody