Printable View
Well I doubt if thats the issue. I onl have about 400 products loaded currently. The test box is on a very slow system but the actual froogle file that is uploaded never gets created if you look in the FEED folder. The pop up window is just blank. I am using IE7 as well, could there be an issue there?Quote:
Originally Posted by Pixxi
Just a thought .. try creating the (empty) feed file - with the same name as you've set in the mod's config in admin - and set it to 777.
There used to be an error message with earlier versions of the mod if the feed file didn't exist - maybe (just maybe) that error is missing.
Put another way, the (empty) feed file needs to exist with the correct name (IIRC) before you try to generate the feed (that's why an empty feed file is included in the mod) ... and (of course) try it with FireFox to see if the pop-up is still blank :smile:
Bummer, that didn't work either. The file as write permissions on it as well as the folder (Remember its a windoze box). I can see the page running but it returns nothing. (file is blank after the run also)Quote:
Originally Posted by Pixxi
Also tried in FireFox as well. No luck.
Most likely problem in
Quote:
Originally Posted by CBO
I am using a subtable in mysql and I keep getting a error
Error
SQL query:
SELECT (
@t4 := configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title = 'Google Froogle Configuration';
MySQL said:
#1146 - Table 'chelsea_testing.configuration_group' doesn't exist
my tables are named like chelsea_testingconfiguration_group without the dot. Can anyone help please.
Use sql patches in the admin
Hello,
I am having same problem as mole 69.
the update sql will not load either. ( 1.2.9 sql works..but the other two and the googlefroogle.sql do not work)
I am guess that the @t4 statement is a php 5 thing.
I am using PHP Version 4.4.3 and none of the sql files in any of your contributions that have the @t4 statements work.
;-(
It has been several months since I have been able to do any coding, so I am a bit rusty.
Please help.
Thanks
Herbals
@t4 statement is a SQL thing.
Hello
So I am Guessing that @T4 is for mysql 5+ ??
My hosting service is using MySQL 4.1.21-standard.
If others have this contribution working with 4.1+ mysql, then I am doing something wrong.
I am asking for help.
Please help me.
Thank You
Herbals
Ok I figured it out.
In the googlefroogle.sql there are two reference:
they should be:Code:SELECT (@t4:=configuration_group_id) as t4
Code:SELECT @t4:=(configuration_group_id) as t4
When I tried to upload the corrected file through admin sql patches, it did not work.
Copying and pasting the code into the admin sql patches worked like a charm.
Fixed googlefroogle.sql to be copied and pasted into admin>tools>Install SQL Patches
This is a great contribution, thank you for sharing this with the community.Code:SET @t4=0;
SELECT @t4:=(configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group VALUES (NULL, 'Google Froogle Configuration', 'Set Froogle Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT @t4:=(configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration';
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, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @t4, 1, NOW(), NULL, NULL),
(NULL, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @t4, 2, NOW(), NULL, NULL),
(NULL, 'Froogle Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @t4, 3, NOW(), NULL, NULL),
(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @t4, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @t4, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('),
(NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'true', 'A unique alphanumeric identifier for the item - products_id code. ', @t4, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'false\'),'),
(NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @t4, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'The shipping options available for an item', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @t4, 8, NOW(), NULL, NULL),
(NULL, 'Show Manufacturer', 'GOOGLE_FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Show Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type', @t4, 11, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type', @t4, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'book\', \'music\', \'video\', \'other\'),'),
(NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @t4, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?<br />default = en', @t4, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('),
(NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @t4, 19, NOW(), NULL, NULL),
(NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @t4, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @t4, 21, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @t4, 20, NOW(), NULL, NULL),
(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @t4, 2, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @t4, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
With much gratitude,
Herbals
Thanks!
What version mySQL you use?
Can you test this construction:
http://dev.mysql.com/doc/refman/5.1/...variables.htmlCode:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;
I'm using the newest version 1.3.1. I uploaded and ran the required sql file. However, when I go to admin/configuration/ Google Froogle Configuration there is nothing there to conifgure.
You "using the newest version 1.3.1" of what?
What sql file you run? How you run it?
I am having a problem.
I installed everything successfully (i hope).
I configured it first in Admin->Configuration.
When I go to Tools->Google Froogle Feeder,
and then click on "STEP 1: Click [HERE] to create / update your product feed."
it just takes me to the main page of my store, and does not create anything.
(I checked the file froogle.txt and it is blank)
What am I doing wrong?
Thanks.
You use any SEFU?
I use the SEO addon, but I figured it out. There was something wrong with my .htaccess file, as I have some shared domains on it, and using a 301 redirect.
It was just redirecting to the front page.
Thanks for giving me a place to look :)
works perfectly!!!
I am not using the SEO mod by the way.
thank you so much!!
I am having trouble with this contribution. Downloaded the requisite files from Andrew's site yesterday (with 1_2_6, 1_2_9 and 1_3_ 1 updates). When I hit the Google Froogle Feeder button I get the following messge:
Froogle Data Feeder started 2007/01/29 12:37:39
Feed file - /home/sites/mysite.com/public_html/feed/my_file_name.txt
Nothing happens. The address is http://www.mysite.com/admin/googlefroogle.php
I am using ZenCart version 1.3.6 MySQL 5.0.26-standard Apache/2.0.55 (Red Hat)
I have created and uploaded my_file_name.txt to the feed/ directory and it and the directory are set 777 chmod.
There is no .htaccess file in my root.
I have used the Froogle model successfully in the past on the same server set-up so I do not believe it is a server issue.
Can anyone shed any light please?
Look an error log. May be some error here?
v 1.3.2 30.01.2007 7:05
1. Fix bug with currency value;
2. Add IH support (Thanks to Dan);
3. Don't use module FILENAME_MAIN_PRODUCT_IMAGE;
4. Use medium image (Comments from Dan - "medium should be enough, it is 150 x 120 while Google needs 90 x 90");
5. Fix bug with price = 0;
V1.3.2---so is this available yet? I do not see it on your site.Quote:
Originally Posted by a_berezin
For some reason when I try and use this I get a message saying that the feed/froogle.txt comes up no and no. Any thoughts on what may have happened?
Hi Andrew,
The new v 1.3.2 *only* uses the medium image even where a large image exists?
Some shops don't use medium images - only large and small (ie. they don't have a product info page, only the product listing page - with the 'Click for larger image' on that page).
Could the code maybe default to use the large image if no medium image exists?
I just got the e-mail below from Google:
Quote:
Froogle Merchant Announcement
New product upload requirements Google
Hello,
As you know, we're always looking for new ways to improve our product search experience, both for our users and for content providers. We've found that one of the most effective ways to help users conduct faster and more effective searches is to describe products with relevant attributes - ideally those assigned by the people who best understand their own products, meaning you.
That's why we're asking all Froogle merchants to send us bulk uploads in the Google Base format, with five additional attributes (along with the basic ones you've submitted in the past). Because we think it's important to provide a consistent user experience, we will no longer list items that don't meet a minimal number of attributes by the end of February 2007. Please review the following bulk uploads - they do not currently meet the minimum attribute requirement:
myfile_gmail_com.txt
For further explanation please visit our FAQ section
You can review this attribute requirement page to learn about these new guidelines for general product attributes and specific attributes per product type. You can also learn how to submit your feed using Google Base here. We recommend that you include as many attributes as possible; the more information you provide, the better chance you'll have of matching users' "refinement" queries.
We hope you'll continue enjoying the benefits of listing your products on Google, and even increase your potential customer base using the new Google Base format.
Thanks,
The Google Base Team
Required new attributes / per product type:
http://base.google.com/base/help/products.html#specific
So will a new update be needed to make our files acceptable or will this be something we will have to change ourselves?
I downloaded the add on and got it all installed but when i ran the SQL patch I got the following error
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 'true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD',' at line 1
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Froogle Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'true', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('id', 'model', 'false'),'), (NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'The shipping options available for an item', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Show Manufacturer', 'GOOGLE_FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type', @configuration_group_id, 11, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('book', 'music', 'video', 'other'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:
I am running the following on my server - Database: MySQL 4.1.21-standard
PHP Version: 4.4.4 (Zend: 1.3.0)
Zen Cart 1.3.6
Database Patch Level: 1.3.6
What do I need to do to correct this?
Okay so i have it all appears and configured but when I go to run the feed under Tools and I click on the STEP 1: Click [HERE] to create / update your product feed. It loads me to a pace that says it no longer exsists what do I do to correc this?
Okay so i have it all appears and configured but when I go to run the feed under Tools and I click on the STEP 1: Click [HERE] to create / update your product feed. It loadsme right back the main page of our site. What have I done? and how can I fix it
Has anyone else received this e-mail from Google? Looks like we need to add 5 additional attributes to the old Froogle file generator in order to be in compliance with Google new requirements. Is anyone working on an upgraded Google Base file generator?
Froogle Merchant Announcement
New product upload requirements
Hello,
As you know, we're always looking for new ways to improve our product search experience, both for our users and for content providers. We've found that one of the most effective ways to help users conduct faster and more effective searches is to describe products with relevant attributes - ideally those assigned by the people who best understand their own products, meaning you.
That's why we're asking all Froogle merchants to send us bulk uploads in the Google Base format, with five additional attributes (along with the basic ones you've submitted in the past). Because we think it's important to provide a consistent user experience, we will no longer list items that don't meet a minimal number of attributes by the end of February 2007. Please review the following bulk uploads - they do not currently meet the minimum attribute requirement:
froogle.txt
For further explanation please visit our FAQ section
You can review this attribute requirement page to learn about these new guidelines for general product attributes and specific attributes per product type. You can also learn how to submit your feed using Google Base here. We recommend that you include as many attributes as possible; the more information you provide, the better chance you'll have of matching users' "refinement" queries.
We hope you'll continue enjoying the benefits of listing your products on Google, and even increase your potential customer base using the new Google Base format.
Thanks,
The Google Base Team
I just got that same e-mail from google todayQuote:
Originally Posted by bhuntsman
I know about new attributes / per product type, but I do not have time now.
Ok! I have returned products_image_large. DownloadQuote:
Originally Posted by Pixxi
I have just installed the froogle google data feeder but I have an error in the ftp part
Froogle Data Feeder v.1.3.2 30.01.2007 7:05 started 2007/02/01 07:20:06
Feed file - /hsphere/local/home/jgarabot/health.shopdidoo.com/feed/health_shopdidoo.txt
Processing: Feed - No, Upload - Yes
Upload started...
Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/jgarabot/health.shopdidoo.com/googlefroogle.php on line 416
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110)
Upload failed...
Can somebody tell me how to fix this?
Hello,
We have been testing your Google Froogle Feeder for Zen Cart.
The other day we received an e-mail from Google Base about required attributes for the feed
From what we have been able to determine that there is a missing REQUIRED attribute in the Google/Froogle feed generated by your code.
Required Attributes
Attributes for all products
You are required to include these attributes for all of the items in your bulk upload file.
brand
condition
description
expiration_date
id
image_link
link
price
product_type
title
It appears that the condition attribute is not provided by your feed.
Google has advised that if feeds do not contain ALL of these REQUIRED attributes, the feeds will not be able to be uploaded starting at the end of February
Please let us know your thoughts and advise on this
Thanks
I have the Andrew Berezin version of this feeder
I think it has all the atributes that google required
We have the newest version from Andrew and it DOES NOT have all the Google Base required attributes.
Google has stated that if the feeds they receive DO NOT have these REQUIRED attributes, the feeds will be rejected - period
Reread error message:
Quote:
Originally Posted by jgarabot
Thanks Andrew :smile:Quote:
Originally Posted by a_berezin
But doesn't this section need to be commented out now?
PHP Code:// check for a medium image else use small
if (!file_exists(DIR_WS_IMAGES . 'medium/' . $products_image_medium)) {
$products_image_medium = DIR_WS_IMAGES . $products_image;
} else {
$products_image_medium = DIR_WS_IMAGES . 'medium/' . $products_image_medium;
}
They've also stated that if you're unable to provide all of the attributes they now require in the feed, they will work with you to find an acceptable solution.Quote:
Originally Posted by JLA
I think the potential problem is likely to be that Zen doesn't store some of the newly-required Froogle attributes in a standard format (ie field in a table) - for example, 'colour' and 'size' will likely be stored in Zen as *Zen* attributes, although some shops may use the 'model' field instead.
I just received this email as well, doesn't look like a big deal, just a few extra fields.
What we currently have:
The default set:
* product_url (link)
* name (title)
* description
* price
* image_url (image_link)
* category
Configurable extended set:
* offer_id
* instock
* shipping
* brand
* product_type
* language
* ship_to
* ship_from
What we will be required to have:
* brand
* condition
* description
* expiration_date
* id
* image_link
* link
* price
* product_type
* title
What we need to add:
* condition
* expiration_date
* id
We have until the end of Feb to implement these changes, lets all make sure we're talking about the same file, then we can implement the changes appropriately.
Btw, I'm looking at file version:
// $Id: froogle.php 12-02-2005 [email protected]
Quote:
Originally Posted by Pixxi
I believe that will work with you on OPTIONAL attributes and perhaps before on REQUIRED attributes - but I think they have changed their tune now on the REQUIRED ATTRIBUTES
From an e-mail we received yesterday
Froogle Merchant Announcement
New product upload requirements
Hello,
As you know, we're always looking for new ways to improve our product search experience, both for our users and for content providers. We've found that one of the most effective ways to help users conduct faster and more effective searches is to describe products with relevant attributes - ideally those assigned by the people who best understand their own products, meaning you.
That's why we're asking all Froogle merchants to send us bulk uploads in the Google Base format, with five additional attributes (along with the basic ones you've submitted in the past). Because we think it's important to provide a consistent user experience, we will no longer list items that don't meet a minimal number of attributes by the end of February 2007. Please review the following bulk uploads - they do not currently meet the minimum attribute requirement:
xxxxxxx
For further explanation please visit our FAQ section
You can review this attribute requirement page to learn about these new guidelines for general product attributes and specific attributes per product type. You can also learn how to submit your feed using Google Base here. We recommend that you include as many attributes as possible; the more information you provide, the better chance you'll have of matching users' "refinement" queries.
We hope you'll continue enjoying the benefits of listing your products on Google, and even increase your potential customer base using the new Google Base format.
Thanks,
The Google Base Team
The REQUIRED product attributes now are
Required Attributes
Attributes for all products
You are required to include these attributes for all of the items in your bulk upload file.
brand
condition
description
expiration_date
id
image_link
link
price
product_type
title
Quote:
Originally Posted by Pixxi
The newest version available from Andrew has Expiration data and ID but DOES NOT have CONDITION.Quote:
Originally Posted by j0ney3
Awesome!
Condition as spec'd by Google:
condition
The condition of the product.
Format:
Text. Appropriate values include: new, used, and refurbished.
Tab-delimited example:
refurbished
XML example:
<g:condition>refurbished</g:condition>
Well, this will be especially easy for those of us who only sell "new" products as we can just hardcode "new" into every field. Does zencart have supporting database structure for this?
Also, I'm going to d/l Andrew's version now so we're all on the same page.
The required attributes vary depending on the type of item you're selling - see the link in my earlier post above.
BTW, the feed already has offer_id and expiration_date.
Here's what Google say about *required* attributes:
http://base.google.com/support/bin/a...01&topic=10610Quote:
What if I don't have the information for all the required attributes?
Please reply to the email we sent you with your provider account login and the reason you don't have all the information. We'll do our best to help you submit your information.
Hrm...Quote:
Originally Posted by Pixxi
http://base.google.com/base/products.html
Are we reading the same info? It appears to me that the only items that are REQUIRED are listed up top, the other's (by product) only help, but won't invalidate your upload if not present. Please correct me if I'm reading wrong.
Yes, it can be hard coded but it seems it should be pretty easy to duplicate what Andrew did for the product type field
There are two approaches that one can use
Since ZEN does not have the ability currently to specify whether a product is new, used or refurbished, perhaps just as Andrew did for product type, we can specify for all products "see description" for the condition field.
It says on Google
Appropriate values include which to means does not mean LIMITED TO so the "see description" should be appropriate
Regardless, the FAQ about required attributes is no longer valid at least according to our contact at Google. All feeds MUST have these fields period.
Quote:
Originally Posted by j0ney3
Required Attributes
Attributes for all products
You are required to include these attributes for all of the items in your bulk upload file.
brand
condition
description
expiration_date
id
image_link
link
price
product_type
title
Yes, every time I tried is a conection time out. It has to be some thing else. I will like to to have this fix by the time the problem with google is fix.
JLA,
Ok, I've just installed this mod, works very similar to the one I've got. To add in a static condition value you can find the following around line 85 in <catalogdirectory>/googlefroogle.php:
And add in the following:Code:$output["title"] = "title";
$output["description"] = "description";
$output["link"] = "link";
$output["price"] = "price";
$output["image_link"] = "image_link";
$output["expiration_date"] = "expiration_date";
$output["label"] = "label";
$output["id"] = "id";
Then, around line 150 find the following:Code:$output["title"] = "title";
$output["description"] = "description";
$output["link"] = "link";
$output["price"] = "price";
$output["image_link"] = "image_link";
$output["expiration_date"] = "expiration_date";
$output["label"] = "label";
$output["id"] = "id";
$output["condition"] = "condition"; // Added for March required update
And add in this line at the end:Code:$output = array();
$output["title"] = zen_froogle_sanita($products->fields['products_name'], true);
$output["description"] = zen_froogle_sanita($products->fields['products_description']);
$output["price"] = number_format($price, 2, '.', '');
$output["image_link"] = zen_froogle_image_url($products->fields['products_image']);
$output["expiration_date"] = zen_froogle_expiration_date($products->fields['base_date']);
Of course you can change "new" to whatever you'd like, JLA suggested "see description"Code:$output = array();
$output["title"] = zen_froogle_sanita($products->fields['products_name'], true);
$output["description"] = zen_froogle_sanita($products->fields['products_description']);
$output["price"] = number_format($price, 2, '.', '');
$output["image_link"] = zen_froogle_image_url($products->fields['products_image']);
$output["expiration_date"] = zen_froogle_expiration_date($products->fields['base_date']);
$output["condition"] = "new"; // Added for Google's required March update
If anyone has any questions, suggestions, please post. I realize this is just a quick hack to tide us over for a bit, if I've missed anything please let me know.
can you link the file to replace the old one, for the one of us who does not have editing skills?
Yea who can just send us the files that we need to change already changed so we can just upload them.. Not everyone understands all this editing on these files...
All,
I've PM'd a_berezin, the creator of this file and am going to wait until I get the ok from him to post a link to my modified version of his file. Keep in mind, my quick hack only puts one value in the condition field, only "new". Please don't stress about it, I will do my best to see that everyone is sorted out WELL before this new cutoff, I just don't want to mod/link a_berezin's file w/o permission.
Thanks!
thats understandable
I was looking at the export file.txt, and it does not create the id, only id header
jgarabot,Quote:
Originally Posted by jgarabot
That is a configuration option
go to Configuration->Google Froogle Configuration, then there is an option called "Show Offer ID", u must set it to either "id" or "model" for it to show in the file.
Ok,
I spoke w/ a_berezin and he was totally cool w/ me posting a mod, actually, he wanted me to do some real work, not just throw up an ugly hack, but I'm too lazy, sorry LOL! ;)
So, here it is, a quick patch for those of you whom already have a_berezin's wonderful GoogleFroogle Add-On.
Steps:
1) Download the files http://www.lethalperformance.com/GoogleFroogleMod.zip
2) Unzip
3) Upload as usual
4) Run the sql patch as normal
5) Configure the "condition" option that will now be available
Seeing as the condition is soon to be required, I set it to always be there, so if you don't want condition set to something, stay away from this mod!
CAVEAT: I've tested this of course, however, my upload file still hasn't been processed by google base so USE AT YOUR OWN RISK!
If this breaks your stuff, sorry. To revert this, just re-upload the original googlefroogle.php from a_berezin.
Thanks,
Jonas
Thanks j0ney3
I still have the problem with the ftp part keeps giving me a time out error maybe some setting in my server, I don't know. I have it install in two shoping cart with two diferente froogle account and it is the same error in both.
Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/jgarabot/shopdidoo.com/googlefroogle.php on line 418
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110)
Nice work j0ney3! Thank's! I add it later to mod.Quote:
Originally Posted by j0ney3
jgarabot,Quote:
Originally Posted by jgarabot
I have a lot of the php ftp functions on lockdown on my box, could you have something similar? Maybe check out "disable_functions" in your php.ini. Also, have you tried connecting via terminal from your server?
As a workaround, you could generate the file, save it and upload it to your base account yourself, I know, not the best way, but just a workaround
a,Quote:
Originally Posted by a_berezin
Thank you for the mod. I'm sure someone can come up w/ a more elegant solution for this, but hopefully this will work for now.
How would we add Attributes such as color, size, etc.
And how would we factor in multiple attributes?
Thanks j0ney3!
Sorry if I am being dense - but I can't get a feed.
I installed the latest Google Froogle Feeder with the mod to add "new" and when I go to Admin-Tools-Google Gfroogle Feeder and click "STEP 1: Click [HERE] to create / update your product feed." I get an "Internet Explorer cannot display the webpage." I have double checked my installation and re-read the read me files to see if I missed anything and I do not think I did. I tried scanning this thread and either did not see a mention of it or I looked over it.
Kelli
I managed to fix it but I don't know how. I uninstalled and reinstalled on the assumption that I must have done something wrong the first time. Sorry I can't say what it was to help anyone out.
Kelli
good job, anyone figure out a way to have the feeder export the Colors, Sizes, etc.?
v 1.3.3 07.02.2007 20:45
1. Code clean;
2. Add "condition" attribute (Thanks to j0ney3);
This is my last version - I stopped to developing and support this module.
Download from zen-cart DL area.
That's too bad. It's a very useful mod used by many. Where in the DL section? I can't seem to find it.
can't find it ether. Tried the quick fix posted above. Downloaded and tried to run
the patch. Oh boy, lots of errors. Could not get it to work.
Readme says:
3. Go to Admin->Configuration->Google Froogle Configuration and setup the "condition" parameter
I can't see a condition parameter, then again I am not surprised as the sql did not work. Restored my DB and hope for some solution?
Hi j0ney3,
I followed your instructions and when I do the sql update I get a lot of errors starting with something like this:
1064 You have an error in your SQL syntax
It goes on and on. Something wrong with the code? Does it only work with certain sql version?
I use ZEN 1.3.6 btw.
Agreed. Andrew has done an excellent service in updating and supporting this mod over the last several years. Thanks Andrew!Quote:
Originally Posted by jeking
Google very often changes their requirements so often, therefore this mod is a moving target and difficult to keep updated. Hopefully others with required programming knowledge can keep it updated. Or maybe Google can provide support on updating the mod (like with Google Checkout mod).
Yes I don't see the file is yet available in ZC downloads area yet. May take several days to get approved?
Version I just downloaded from Andrew's site is dated Feb 1, 2007, and appears to NOT be the v 1.3.3 07.02.2007 20:45, the latest version he just announced.
v 1.3.3 is up on Andrew's site now.
Thanks for all of your time creating and supporting this mod Andrew :yes:
How does one identify the version? I went here to fetch the latest:Quote:
Originally Posted by Pixxi
http://zen-cart.spb.ru/freedownload....gleFroogle.zip
Archive is dated Feb 01, 2007. Readme shows: v 1.3.2 30.01.2007 7:05
Yes.Quote:
Originally Posted by Woodymon
Upload last version to my site.Quote:
Originally Posted by Woodymon
Use zen-cart download area for downloading this mod -Quote:
A contribution that you submitted recently has been activated, and will now be available to download. Details of the contribution are as follows:
Title : Google Froogle Feeder
Author : Andrew Berezin
Version : 1.3.3
Description : Google Froogle Feeder
Category : Marketing Tools
Zen Cart Version : v1.3.7
Download
I just see that your current version of the mod is for 1.3.7. Will this work for my 1.3.6?
Maybe thats why I get all the errors when I apply the sql?
I have just installed the last version of this and when I press step 1 I get a window popup with a web site from my host (This domain name has been registered with Easyspace.com) and a web sie advertising - Sedo is the leading marketplace for buying and selling domain names and websites. Any Ideas ?
When I run the froogle freed everything pulls great but I am having a problem with Prices. They are not coming out as what is listed on the site, for instance if the item is 74.99 froolge feed pulls it as 73.44 how do I correct this? Froogle won't let me upload because it says the prices are diffrent from what is in the file as to what is on my site. Please help.:lamo:
I have a problem. I'm trying to do the DB upgrade via PHPMyAdmin. But I get this error message:
Here's the mysql I'm trying to execute:Code: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
Code: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\'),');
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....
OK I found out the problem with the #1064 error, there's an extra comma here: (extra comma in red)
That fixes that problem. Unfortunately, it's now giving the error (for me at least):Quote:
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\'),');
Quote:
#1136 - Column count doesn't match value count at row 1
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?
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!!:down: Why not?
btw, here's the modified SQL patch that works (added "configuration_key"):
I need to get this working!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\'),');
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?)
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\'),');
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.Quote:
Originally Posted by abecvar0627
Thank you for the fix in update_1_3_3.sql. Yes, the INSERT statement was missing the configuration_key parameter.Quote:
Originally Posted by kbalona
Note this SQL issue applies to upgraders only. It does NOT apply to fresh installs of this mod version.
Woody
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.
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.Quote:
Choose your Product's Condition:
- new
- used
- refurbished
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 :wink2:
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
Just visited http://base.google.com/base/products.html#price and confirmed GoogleBase/Froogle does not currently support a sale price attribute.Quote:
Originally Posted by Woodymon
I suspect the Google Froogle mod could be hacked to test for the existence of a sale price for each of your products, and if that condition exists then replace the regular unit price for each of your products with the sale price in an array, before writing the feed file. Or something like that. IANAP.
Woody
Woody,
Is not present. Ok, I should explain the reason.Quote:
Originally Posted by Woodymon
I have stopped support of this module because i don't use it - this service is not accessible for me. And to spend my time and my money for its support it is too prodigal.
I'm still getting the same 1064 error. I tried uninstalling and reinstalling and still get the same error.Quote:
Originally Posted by mydanilo
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 'true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD',' at line 1
I don't understand why.
I know we should not be pushy and post the same question over and over, but....I can't believe that nobody can give a quick pointer to why or where the 1064 errors come from. How come the SQL patch seem to work for some an not for others? I personally have no SQL syntax experience. PHP a lttle, HTML ok and I am willing to help the community where I can. Here with this I am on my wits end. Do I sound like I am begging for help? Hmm.....Quote:
Originally Posted by jeking
I hope some of us will pick up where a_berezin leaves off. This mod is very important to many of us and it should be continued. Right?
Also have you attempted to run in phpmyadmin? If that does not work for you attach the complete SQL patch file and so we can take a look.Quote:
Originally Posted by mydanilo
Woody
Woody,
Thanks for the offer to help. I had not tried from phpmyadmin, but just did and got a different error. This is the script I ran:
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Froogle Configuration', 'Set Froogle Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
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, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Froogle Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('),
(NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'true', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'false\'),'),
(NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'The shipping options available for an item', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL),
(NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'Choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'book\', \'music\', \'video\', \'other\'),'),
(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\'),'),
(NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?<br />default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('),
(NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL),
(NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL),
(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
and the error I got:
SQL query:
SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google Froogle Configuration'
LIMIT 1 ;
MySQL said:
#1146 - Table 'dog_zc1.configuration_group' doesn't exist
So this last error report came from phpmyadmin?Quote:
Originally Posted by jeking
I just have basic SQL knowledge but I suspect a db table prefix issue. However usually you will see an error like that from within Zen Cart's built-in SQL Executor (which will attempt to add the prefix your shop database is set up with), but not from phpmyadmin.
In phpmyadmin when you select your database do all the tables listed in the left column show a prefix of "dog_zc1." ? That is do you observe a table named "configuration_group" or is it named "dog_zc1.configuration_group"?
If the table is named "configuration_group" (without a prefix) then you should be able to run the SQL in phpmyadmin without that error. If you have a prefix on each table then you will need to either edit the SQL, or patch your database from within Zen Cart "Tools > Install SQL Patches" (do not upload, just paste in and the proper prefix should be auto applied).
Woody
Woody, you rock!! My tables do have the prefix. I pasted the sql script into the box in box and it worked! I have been using the file upload option on that page. I installed the rest of the files and the whole thing is working.
I'd bet others with the 1064 error are also uploading. I'd be curious to heard if this works for mydanilo now too.
Thanks again Woody.
What could be causing this? When I try to start the feed I get:
I set Admin Session Time Out in Seconds to 7200 and Admin Set max_execution_time for processes to 300 and I stillgetting the same response. This wasn't happening before I upgraded to the newwst version and disabled dhl shipping mod.Quote:
Froogle Data Feeder v.GOOGLE_FROOGLE_VERSION started 2007/02/16 12:39:45 Feed file - /home/cooltechcentral.txt
Fatal error: Maximum execution time of 30 seconds exceeded in /home/wwwcool/public_html/includes/functions/functions_lookups.php on line 522
Anyone? Anyone? Bueller?