Google Base Feeder Support Thread [OLD]

[countrycharm]

The Numinix code automatically appends
_products.xml to whatever name you have defined in the config.

So if you call it

fantastic

then you have to tell google it's called

fantastic_products.xml

The feed creation/upload popup window shows the filename clearly.

The reason it appends the _products.xml to whatever name you have defined in the configuration is to determine what kind of .xml it is.
Google base feeder will create documents.xml, and news.xml also. This just makes it easier for google to know what type of .xml it is.

returns the type of feed
    function get_type($type_parameter) {
      switch($type_parameter) {
        case 'tp':
          $type = 'products';
          break;
        case 'td':
          $type = 'documents';
          break;
        case 'tn':
          $type = 'news';
          break;
        default:
          $type = 'products';
          break;
      }
      return $type; 

[countrycharm]

Hi All,

I am getting the following error message when clicking on 'Google Base Feeder'
############################################################_
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
############################################################_

I have re checked all the files in place and set to 777.

Any ideas?

Regards,

Andy

Go back and check that all files are in the correct place and you have renamed the google base feeder admin folder to your custom folder name. Make sure you upload the main file found in the root of the package (googlefroogle.php)

[countrycharm]

Hello all.

I have come up against a problem that I can not fix despite trying repeatedly for many, many hours. I have read hundreds of posts and searched the net but I am now at my wits end and just about ready to give up.

I have zen cart 1.3.9h, hosted by dreamhost. My site has a fair amount of customisation on it and I yesterday uploaded google_base_feeder 1.8.2 taking care to follow the instructions yet no matter what I do the googlebase configuration in my admin does not show anything other than the following:

Google Base Feeder Configuration
Google Base FTP Username
Google Base FTP Password
Google Base Server

I know that there should be a great deal more in the way of configuration for the GBF (this has been confirmed in numerous threads) yet I can not figure it out.

Also in my Admin/tools I have the following:
Google Base Feeder
Feed Type:
SQL Query Limit
SQL Query Offset

For sanity sake has anyone got any ideas or suggestions so I can get this fixed.

Thanks in advance for any help that is offered.

Go back and check that all files are in the correct place and you have renamed the google base feeder admin folder to your custom folder name.
Copy and past this in your admin/tools/install_sql_patches

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) 
FROM configuration_group 
WHERE configuration_group_title= 'Google Base Feeder Configuration' 
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Base Feeder Configuration', 'Set Google Base 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;

DELETE FROM 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<br />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:<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', '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?<br />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)?<br />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 <br>(i.e. 1,2,3)<br>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 <br>(i.e. 1,2,3)<br>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?<br />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\'),'); 

After that copy and past this one.

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0; 

Copy and past the install.sql in the google base folder again. See if that puts everything in admin/configurations for you.

[katrobb]

Hello,
I am working on ZenCart 1.3.9h and I just updated to Google Merchant 1.8.3.

When I click on the Confirm button I receive the following message.

Google Merchant Center Feeder v started 2011/03/25 15:43:12
Feed file - "the normal address"/feed/kkegoogle_products.xml
Processing: Feed - Yes, Upload - No
~~~~~~~~~
Google Merchant Center File Complete In 17.790608 Seconds 945 Records

When I click on the Update link, only 22 records are uploaded, not 945.

Does anyone have any ideas?

I have went back to v1.7.4 and it still works, but I do not know what additions the v1.8.3 has made.

Katrina Robb
Katalina Klark Enterprises
KatalinaKlark.com

[kevinmc3]

ver 1.3.9h

Does this Mod address the new requirement for additional fileds for Product submissions? I believe the new Google Merchant requirement starts May 1, 2011.

[countrycharm]

ver 1.3.9h

Does this Mod address the new requirement for additional fileds for Product submissions? I believe the new Google Merchant requirement starts May 1, 2011.

If you have at least read some or the thread you would have seen this.

For all who are concern with this issue you can go to Numinix web site and download the Numinix Product Fields to add those additional fields to google base feeder.

Per Numinix
Many optional fields are included in this package. While many have specific purposes and can be displayed on your product pages (i.e. UPC/ISBN) many others can be used for whatever purpose you can think of. Here is a list of the optional fields:

Continental Shipping - creates a field for each continent where you can define a shipping rate for the product.
Date Added - allows you to modify the date_added of any product. Useful for sorting products by date or re-releasing an old product.
Dimensions - creates fields for length, width, height, and diameter
Discontinue - creates a checkbox where you can mark a product to be discontinued. Can be useful if you modify your cart to automatically remove attributes as they sell out, etc.
MSRP - set the manufacturer's suggested retail price
Out of Stock - mark a product out of stock without making the product unavailable.
Second Description - creates a field where a second description can be stored. You decide how and where you will display this new test.
Secret Product - mark a product as secret and then make your product listing and info pages not display the product unless your conditions are met.
SKU - add a sku for your product
Stock by Attributes Link - creates a link to the product in the stock by attributes page
UPC/ISBN - adds fields for storing a product's UPC and/or ISBN
Wholesale Price - adds a field for storing a wholesale price (compatible with the Customer Wholesale module).

Note: This module replaces the Auction Site Attributes module. For customers using the free version of the Amazon Exporter (only available through the Zen-Cart.com website), Auction Site Attributes is still required.
Important Links

[PullingOutHair]

I have a question, I am using Zen v1.3.9h and the latest Google Base feeder, however, I noticed that all my products are being read as free shipping.

I use zone shipping and the shipping in taxable in my state. I know I must have the configuration off somewhere. Any help is appreciated.

My Zone rates:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Price

Tax Class
Taxable Goods

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes
CN

Zone 1 Countries
US

Zone 1 Shipping Table
48:7.95,99000:8.95

Zone 1 Handling Fee
0

Handling Per Order or Per Box Zone 1 (when by weight)
Order

Google Base Feeder Configuration for shipping

Select Shipping Method zones Info
Table Zone ID US Info
Shipping Country 223 Info
Shipping Region MO Info
Shipping Service USPS, UPS Ground

[jacky]

Go to your root feed/google/your_feed and delete the feed. Go to admin/configurations/google_base_configuration and make sure the Output File Name is correct. Make another feed and check the name in root feed/google/your_feed name to make sure it is named correctly before you upload it. If it is not name correctly click on it and rename it to whatever you have name it in google merchant center before you upload it. I would suggest you go to google merchant center to upload the file.

Hi,

I have done all as you said and tried to upload the file again, it still doesn't work. On the other hand, I downloaded the file to my computer and uploaded it to the server manually. same message show as below:

Google Base Feeder v1.8.2 started 2011/04/11 13:42:14
Feed file - /home/homedeco/public_html/n1stores/google_feed/google/all_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 403 Apr 10 22:44 all_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 403 Apr 10 22:44 all_products.xml

Upload ok!

No products upload to server. what should I do for next?

e.g. this is my uploaded page.
http://www.n1stores.com/google_feed/...l_products.xml

regards,
Jacky

[Delerius]

Hi,

I have done all as you said and tried to upload the file again, it still doesn't work. On the other hand, I downloaded the file to my computer and uploaded it to the server manually. same message show as below:

Google Base Feeder v1.8.2 started 2011/04/11 13:42:14
Feed file - /home/homedeco/public_html/n1stores/google_feed/google/all_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Uploaded Successfully
-r--r----- 1 ftp · root · 403 Apr 10 22:44 all_products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp · root · 403 Apr 10 22:44 all_products.xml

Upload ok!

No products upload to server. what should I do for next?

e.g. this is my uploaded page.
http://www.n1stores.com/google_feed/...l_products.xml

regards,
Jacky

You must create a data feed @ base.google.com . Log on to base.google.com , and look for "New Data Feeds". The info you enter here has to match the info you entered in the Zen Cart config file...

[PullingOutHair]

Anyone know why my feed shows free shipping? Please see post above.