Google Base Feeder Support Thread [OLD]

Printable View

Show 100 post(s) from this thread on one page

7 Jun 2010, 03:12 AM
kevinmc3

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by davewest

normally, 12-24 hours is for the feed to go live after approval... Is you feed name the same as what you told Google? Did you create the feed in Google first? I have mine placed into a feed folder on my site. I downloaded that file and then did a manual up load to Google when I first started. That way I could test my format and make sure the file name was right. I didn't trust that it would auto insert the feed, so I did it myself, which could be your problem if you didn't create the feed yet in Google.

Now its done through the mod and it still takes 12-24 for the feed to go live, but my feed now is over 5000 products.

Another good reason for doing a small manual upload... you'll need to clam the feed using the Google instructions.

Sorry if this sounds dumb, but this is a bit confusing.

1)." Is you feed name the same as what you told Google? Did you create the feed in Google first?
No, I thought the Mod did that ??

2). " I have mine placed into a feed folder on my site. I downloaded that file and then did a manual up load to Google when I first started. " -> You mean the Feed file you created manually ? I am confused exactly what you did? You created a Feed file, then downloaded it , then uploaded it?

3). "I didn't trust that it would auto insert the feed, so I did it myself, which could be your problem if you didn't create the feed yet in Google.". I am still unclear what you did here. Sorry if I am a bit slow.

The Zen Feed Mod created this:
Google Base Feeder v1.7.4 started 2010/06/07 01:57:56
Feed file - /home/cvtreasu/public_html/feed/domain_products.xml
Processing: Feed - Yes, Upload - No
Google Base File Complete In 9.522361 Seconds 1116 Records

So the file domain_products.xml. Is this what you named your MANUAL Feed file?

Then the Zen Feed uploaded this:
Google Base Feeder v1.7.4 started 2010/06/07 02:01:33
Feed file - /home/cvtreasu/public_html/feed/domain_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 1913209 Jun 6 19:01 domain_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 1913209 Jun 6 19:01 domain_products.xml

Telling me it uploaded the XML file. However, it is NOT in the Merchant Center Feeds or the FTP account location > FTP root at uploads.google.com
7 Jun 2010, 07:08 AM
davewest

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by kevinmc3

Sorry if this sounds dumb, but this is a bit confusing.

Not dumb, just confusing.... especially when working with two different systems, your cart and Google.

Quote:

Originally Posted by kevinmc3

1)." Is you feed name the same as what you told Google? Did you create the feed in Google first?
No, I thought the Mod did that ??

Not sure if it does... There is two steps in creating a data feed in Google before uploading one, Create it, Register, then upload it, this the mod wont do.

Quote:

Originally Posted by kevinmc3

2). " I have mine placed into a feed folder on my site. I downloaded that file and then did a manual up load to Google when I first started. " -> You mean the Feed file you created manually ? I am confused exactly what you did? You created a Feed file, then downloaded it , then uploaded it?

The feed folder should have been in the mod instructions and uploaded when installing the mod. Also you can set it in admin.

Quote:

Originally Posted by kevinmc3

3). "I didn't trust that it would auto insert the feed, so I did it myself, which could be your problem if you didn't create the feed yet in Google.". I am still unclear what you did here. Sorry if I am a bit slow.

I've always created feeds myself and have feed writers for doing it with non-zen cart sites. I downloaded the feed and look at it to see if it was correct, then went through the process in Google to create the feed and upload. Once the feed is created in Google, then the Zencart mod will have no problems uploading.... it simply has to replace what's there already.

Quote:

Originally Posted by kevinmc3

So the file domain_products.xml. Is this what you named your MANUAL Feed file?

You can set the 'Output File Name' in admin. The '_products.xml' is added by the mod and needs to be there for product feeds. I use a shorten name for my feeds... 'whty_products.xml'

Quote:

Originally Posted by kevinmc3

/feed/domain_products.xml

This is where your feed should be. I also use this folder for my rss\atom feeds.

So.... This is what I did.
1) installed and setup the mod, created a 10 product feed.
2) used my ftp program to download the xml file, check it.
3) went to Google and Created the feed by clicking on the 'New Data Feed' button.
4) Entered the feed country, feed type, and file name.
5) click on the manual upload, upload your file and then clam the feed.

That's about it.... if you have time, really look over the Google help.... some good info on editing feeds and getting the best listings.
7 Jun 2010, 06:31 PM
kevinmc3

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by davewest

Not dumb, just confusing.... especially when working with two different systems, your cart and Google.

Not sure if it does... There is two steps in creating a data feed in Google before uploading one, Create it, Register, then upload it, this the mod wont do.

The feed folder should have been in the mod instructions and uploaded when installing the mod. Also you can set it in admin.

I've always created feeds myself and have feed writers for doing it with non-zen cart sites. I downloaded the feed and look at it to see if it was correct, then went through the process in Google to create the feed and upload. Once the feed is created in Google, then the Zencart mod will have no problems uploading.... it simply has to replace what's there already.

You can set the 'Output File Name' in admin. The '_products.xml' is added by the mod and needs to be there for product feeds. I use a shorten name for my feeds... 'whty_products.xml'

This is where your feed should be. I also use this folder for my rss\atom feeds.

So.... This is what I did.
1) installed and setup the mod, created a 10 product feed.
2) used my ftp program to download the xml file, check it.
3) went to Google and Created the feed by clicking on the 'New Data Feed' button.
4) Entered the feed country, feed type, and file name.
5) click on the manual upload, upload your file and then clam the feed.

That's about it.... if you have time, really look over the Google help.... some good info on editing feeds and getting the best listings.

Thanks. This was very helpful. What I did was ran the Zen admin Mod create and upload. Went into my FEED folder, checked that the file was there. Looked at the feed file, looked like all the required Google attributes were there. Then went into Google, created manually a data feed, than uploaed the Zen created file in the FEED folder. And it seemed to work ok. UPloaded 1500 product feeds. NO errors except for a "Warning" that my expiration was too long (i.e. beyond 30 days), but it still loaded all products.
7 Jun 2010, 10:58 PM
jdalton

Re: Google Base Feeder Support Thread

HI

I am trying to install google feeder v1.82 on zencart 1.3.8a but I keep getting the following error when installing the install.sql script under tool-sql patches... I installed the patches first... would this be the problem..
I tried the uninstall script & then did the re-install again but no luck :(
Would really appreciate any ideas here.

1062 Duplicate entry 'GOOGLE_BASE_PASV' for key 2
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, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base PASV', 'GOOGLE_BASE_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Numinix Product Fields', 'GOOGLE_BASE_ASA', 'false', 'Activate Numinix Product Fields (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'UPC/ISBN', 'GOOGLE_BASE_ASA_UPC', 'false', 'If using Numinix Product Fields, include UPC/ISBN?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Description 2', 'GOOGLE_BASE_ASA_DESCRIPTION_2', 'false', 'If using Numinix Product Fields, append description 2 to description?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:
now - add Adjust to current date;
product - add Adjust to product date (max(date_added, last_modified, date_available))
', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '30', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, 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', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'false\'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default 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?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', '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/google/', 'Set the name of your froogle output directory', @configuration_group_id, 20, 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\'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Display Tax', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display tax per product?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),'), (NULL, 'Payments Accepted', 'GOOGLE_BASE_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Alternate Image URL', 'GOOGLE_BASE_ALTERNATE_IMAGE_URL', '', 'Add an alternate URL if your images are hosted offsite (i.e. http://www.domain.com/images/). Your defined image will be appended to the end of this URL.', @configuration_group_id, 36, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_FROOGLE_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 36, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Use Meta Title', 'GOOGLE_BASE_META_TITLE', 'false', 'Use meta title as the title if it exists (for products only)?', @configuration_group_id, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Select Shipping Method', 'GOOGLE_BASE_SHIPPING_METHOD', 'none', 'Select a shipping method from the drop-down list that is used in your store, or leave as none', @configuration_group_id, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'zones table rate\', \'flat rate\', \'per item\', \'per weight unit\', \'table rate\', \'zones\', \'percategory\', \'free shipping\', \'free rules shipping\', \'none\'),'), (NULL, 'Table Zone ID', 'GOOGLE_BASE_RATE_ZONE', '', 'Enter the table rate ID if using a shipping method that uses table rates:', @configuration_group_id, 51, NOW(), NULL, NULL), (NULL, 'Shipping Country', 'GOOGLE_BASE_SHIPPING_COUNTRY', '', 'Select the destination country for the shipping rates:', @configuration_group_id, 52, NOW(), NULL, 'zen_cfg_pull_down_country_list('), (NULL, 'Shipping Region', 'GOOGLE_BASE_SHIPPING_REGION', '', 'Enter the destination region within the selected country (state code, or zip with wildcard *):', @configuration_group_id, 53, NOW(), NULL, NULL), (NULL, 'Shipping Service', 'GOOGLE_BASE_SHIPPING_SERVICE', '', 'Enter the shipping service type (i.e. Ground):', @configuration_group_id, 54, NOW(), NULL, NULL), (NULL, 'Debug', 'GOOGLE_BASE_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
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.
8 Jun 2010, 03:45 AM
davewest

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by kevinmc3

UPloaded 1500 product feeds. NO errors except for a "Warning" that my expiration was too long (i.e. beyond 30 days), but it still loaded all products.

I had to set mine to 20 days... but I upload once every 14 days anyway.

Quote:

Originally Posted by jdalton

HI

I am trying to install google feeder v1.82 on zencart 1.3.8a but I keep getting the following error when installing the install.sql script under tool-sql patches... I installed the patches first... would this be the problem..
I tried the uninstall script & then did the re-install again but no luck :(

You don't need to do patches on a new install.... just the main install.sql would of been fine. If something is missing or you don't think it was all installed, run the uninsatll.sql and then just the install.sql.. Duplicate entry means it's already there so it can't be installed again.
8 Jun 2010, 10:18 AM
yorkshiregc

Re: Google Base Feeder Support Thread

Hi Guys,

I keep getting this error when i try to upload to google base?

Google Base Feeder v1.7.4 started 2010/06/08 10:15:43
Feed file - /var/www/vhosts/yorkshiregardencentre.co.uk/httpdocs/shop//feed/yorkshiregardencentre_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com

Upload failed...

Im not sure why though!! :-S Ive fiddled with just about every setting and nothing seams to help....

Any suggestions?

Thanks
8 Jun 2010, 01:14 PM
ZeeRocK

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by yorkshiregc

Hi Guys,

I keep getting this error when i try to upload to google base?

Google Base Feeder v1.7.4 started 2010/06/08 10:15:43
Feed file - /var/www/vhosts/yorkshiregardencentre.co.uk/httpdocs/shop//feed/yorkshiregardencentre_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com

Upload failed...

Im not sure why though!! :-S Ive fiddled with just about every setting and nothing seams to help....

Any suggestions?

Thanks

Make sure your feed folder is set to 777/755.
Make sure your password is the same as in your google. merchant account.
Make sure your feed file (yorkshiregardencentre_products.xml) is the same as you registered in your google account.

Cheers!
8 Jun 2010, 01:26 PM
yorkshiregc

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by ZeeRocK

Make sure your feed folder is set to 777/755.
Make sure your password is the same as in your google. merchant account.
Make sure your feed file (yorkshiregardencentre_products.xml) is the same as you registered in your google account.

Cheers!

Have checked all that and its all all it should be!

Werid thing is ive had this working before its just stopped...

Could it be something to do with the new SSL certificate we got about 3 weeks ago?
8 Jun 2010, 01:31 PM
ZeeRocK

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by yorkshiregc

Have checked all that and its all all it should be!

Werid thing is ive had this working before its just stopped...

Could it be something to do with the new SSL certificate we got about 3 weeks ago?

It might be, disable your SSL and try again. If thats the issue then you might have to configure it again. Search the thread for SSL. May be something already posted this issue.
8 Jun 2010, 01:41 PM
jdalton

Re: Google Base Feeder Support Thread

Quote:

Originally Posted by davewest

I had to set mine to 20 days... but I upload once every 14 days anyway.

You don't need to do patches on a new install.... just the main install.sql would of been fine. If something is missing or you don't think it was all installed, run the uninsatll.sql and then just the install.sql.. Duplicate entry means it's already there so it can't be installed again.

Quote:

Originally Posted by jdalton

HI

I am trying to install google feeder v1.82 on zencart 1.3.8a but I keep getting the following error when installing the install.sql script under tool-sql patches... I installed the patches first... would this be the problem..
I tried the uninstall script & then did the re-install again but no luck :(
Would really appreciate any ideas here.

1062 Duplicate entry 'GOOGLE_BASE_PASV' for key 2
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, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL), (NULL, 'Google Base PASV', 'GOOGLE_BASE_PASV', 'true', 'Turn PASV mode on or off for FTP upload?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Numinix Product Fields', 'GOOGLE_BASE_ASA', 'false', 'Activate Numinix Product Fields (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'UPC/ISBN', 'GOOGLE_BASE_ASA_UPC', 'false', 'If using Numinix Product Fields, include UPC/ISBN?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Description 2', 'GOOGLE_BASE_ASA_DESCRIPTION_2', 'false', 'If using Numinix Product Fields, append description 2 to description?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Enable Map Pricing', 'GOOGLE_BASE_MAP_PRICING', 'false', 'Enable MAP Pricing (requires separate add-on)?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:
now - add Adjust to current date;
product - add Adjust to product date (max(date_added, last_modified, date_available))
', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'), (NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '30', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 3, 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', 'id', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'UPC\', \'ISBN\', \'false\'),'), (NULL, 'Show Quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Include Zero Quantity', 'GOOGLE_BASE_ZERO_QUANTITY', 'false', 'Include products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'Shipping Options', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your default 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?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Magic SEO URLs', 'GOOGLE_BASE_MAGIC_SEO_URLS', 'false', 'Output Magic SEO URLs (separate module required)?', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'domain', '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/google/', 'Set the name of your froogle output directory', @configuration_group_id, 20, 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\'),'), (NULL, 'Tax Region', 'GOOGLE_FROOGLE_TAX_REGION', 'Tax applicable regions', 'Enter the tax region', @configuration_group_id, 22, NOW(), NULL, NULL), (NULL, 'Display Tax', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display tax per product?', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Max products', 'GOOGLE_FROOGLE_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL), (NULL, 'Pickup', 'GOOGLE_FROOGLE_PICKUP', 'do not display', 'Local pickup available?', @configuration_group_id, 25, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\', \'do not display\'),'), (NULL, 'Included Categories', 'GOOGLE_BASE_POS_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Excluded Categories', 'GOOGLE_BASE_NEG_CATEGORIES', '', 'Enter category names separated by commas
(i.e. 1,2,3)
Leave blank to deactivate', @configuration_group_id, 30, NOW(), NULL, NULL), (NULL, 'Show Weight', 'GOOGLE_BASE_WEIGHT', 'false', 'Include products weight?', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Weight Units', 'GOOGLE_BASE_UNITS', 'pounds', 'What unit of weight measure?
pounds OR kilograms', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'pounds\', \'kilograms\'),'), (NULL, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),'), (NULL, 'Payments Accepted', 'GOOGLE_BASE_PAYMENT_METHODS', 'Cash,Check,Visa,MasterCard,AmericanExpress,Discover,WireTransfer', 'What payment methods do you accept?', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, NOW(), NULL, NULL), (NULL, 'Alternate Image URL', 'GOOGLE_BASE_ALTERNATE_IMAGE_URL', '', 'Add an alternate URL if your images are hosted offsite (i.e. http://www.domain.com/images/). Your defined image will be appended to the end of this URL.', @configuration_group_id, 36, NOW(), NULL, NULL), (NULL, 'Image Handler', 'GOOGLE_FROOGLE_IMAGE_HANDLER', 'false', 'Resize images using image handler (separate module required)?', @configuration_group_id, 36, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Use Meta Title', 'GOOGLE_BASE_META_TITLE', 'false', 'Use meta title as the title if it exists (for products only)?', @configuration_group_id, 40, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'), (NULL, 'Select Shipping Method', 'GOOGLE_BASE_SHIPPING_METHOD', 'none', 'Select a shipping method from the drop-down list that is used in your store, or leave as none', @configuration_group_id, 50, NOW(), NULL, 'zen_cfg_select_option(array(\'zones table rate\', \'flat rate\', \'per item\', \'per weight unit\', \'table rate\', \'zones\', \'percategory\', \'free shipping\', \'free rules shipping\', \'none\'),'), (NULL, 'Table Zone ID', 'GOOGLE_BASE_RATE_ZONE', '', 'Enter the table rate ID if using a shipping method that uses table rates:', @configuration_group_id, 51, NOW(), NULL, NULL), (NULL, 'Shipping Country', 'GOOGLE_BASE_SHIPPING_COUNTRY', '', 'Select the destination country for the shipping rates:', @configuration_group_id, 52, NOW(), NULL, 'zen_cfg_pull_down_country_list('), (NULL, 'Shipping Region', 'GOOGLE_BASE_SHIPPING_REGION', '', 'Enter the destination region within the selected country (state code, or zip with wildcard *):', @configuration_group_id, 53, NOW(), NULL, NULL), (NULL, 'Shipping Service', 'GOOGLE_BASE_SHIPPING_SERVICE', '', 'Enter the shipping service type (i.e. Ground):', @configuration_group_id, 54, NOW(), NULL, NULL), (NULL, 'Debug', 'GOOGLE_BASE_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');]
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.

Hi Dave

I tried the uninstall.sql script & it seemed to work ok but I got the same error when install.sql again??? ANy other ideas??

Show 100 post(s) from this thread on one page