Creative Shop Talk Support Forum For Website Owners
News:
 
  Home Help Login Register  

Recent Post

Members Banners

Support, Resources And Promotions For Online Business Sites.



Welcome To Creative Shop Talk Forum

Creative Shop Talk is a small community forum for website owners who get together in here to bounce ideas, share support and make friends in the process. No serious experts, just online business owners with a desire to share experiences.

Featured Store Of The Month (Voted On By CST Members)

http://taogem.com/taogemst_myzencart http://www.anitasarts.com http://www.chainmanbooks.com http://www.apennyforluck.com http://vintagerosecollectibles.chshops.com http://www.birdsnyarn.com http://gypsyrosalie.com http://dewittco.com http://www.kcbeaddesigns.com


Add to Google Add to My Yahoo! Add to My AOL
Pages: 1 [2]   Go Down
  Print  
Author Topic: Google Base & Zen Cart  (Read 675 times)
0 Members and 1 Guest are viewing this topic.
chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #15 on: November 21, 2008, 08:45:58 PM »

From chain_man:

These may be silly questions, but do you have the file called googlefroogle.php in your zen cart root?

And did you run the googlefroogle.sql?
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #16 on: November 21, 2008, 08:54:53 PM »

From gypsyrosalie:

Yes, I have the googlefroogle.php in my root.

When I ran the googlefroogle.sql, I got this error (so I thought maybe I already ran it before the other .sql update):

1062 Duplicate entry 'GOOGLE_BASE_DEFAULT_QUANTITY' for key 2
in:
[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, '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, 'Auction Site Attributes', 'GOOGLE_BASE_ASA', 'false', 'Activate Auction Site Attributes?', @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', '365', '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/', '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, 'Show Tax Region', 'GOOGLE_FROOGLE_TAX_DISPLAY', 'false', 'Display Tax Region?', @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, '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\\'),');]
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.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #17 on: November 21, 2008, 08:55:37 PM »

From gypsyrosalie:

Also, everytime I try to re-run that .sql update, it wipes out all my Google Base settings in admin.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #18 on: November 21, 2008, 08:56:22 PM »

From chain_man:

Sorry about the delay... I had to be bothered with my day job...

Since yours is a fresh install, I don't believe you need to run any of the sql update files, just the main one: googlefroogle.sql

Maybe you could run the uninstall.sql to clear your database entries for Google Base, then install just the googlefroogle.sql.

If you've already done this then ignore my guesses.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #19 on: November 21, 2008, 08:57:18 PM »

From gypsyrosalie:


Sorry about the delay... I had to be bothered with my day job...

Since yours is a fresh install, I don't believe you need to run any of the sql update files, just the main one: googlefroogle.sql

Maybe you could run the uninstall.sql to clear your database entries for Google Base, then install just the googlefroogle.sql.

If you've already done this then ignore my guesses.



Yep, already tried that, too.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #20 on: November 21, 2008, 08:57:54 PM »

From TaoGem:

Just curious..

I did a search, but did not see anything. Is there a thread someplace for getting Google Base set up. Preferably with ZC?
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #21 on: November 21, 2008, 08:58:45 PM »

From chain_man:



Yep, already tried that, too. 


Gypsy -

Numinix just released a new version today. It has some bug fixes and a few new features. If you haven't got yours working yet, you might want to try the new version.

You can find it here.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #22 on: November 21, 2008, 08:59:32 PM »

From gypsyrosalie:

Thanks! I've downloaded it and will give it a try tomorrow. I'll come back here with an update after I'm done.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #23 on: November 21, 2008, 09:00:46 PM »

From TaoGem:




Yep, already tried that, too. 


Gypsy -

Numinix just released a new version today. It has some bug fixes and a few new features. If you haven't got yours working yet, you might want to try the new version.

You can find it here.


Too funny...

I just came back to let Gypsy know the same thing.

I would add that you may want to follow along in the Numinix forum. It picks up with the new version 1.7.0 here..

I think will give this a whirl...
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #24 on: November 21, 2008, 09:01:31 PM »

From chain_man:

OK George!

Let's take this to the "mod fest" topic.
Logged

Doug

chain_man
June Featured Store
Administrator
Hero Member
*****
Offline Offline

Location: Sacramento, CA
Posts: 1563



WWW
« Reply #25 on: November 21, 2008, 09:02:09 PM »

From gypsyrosalie:

I mentioned in the other thread that I installed this newer version of this mod and got the same exact results as I did before. I give up.
Logged

Doug

Pages: 1 [2]   Go Up
  Print  
 
Jump to:  

TinyPortal v1.0 beta 3 © Bloc
  Home Help Login Register  
Powered by MySQL Powered by PHP Powered by SMF 1.1.9 | SMF © 2006-2009, Simple Machines LLC
| TP Meadows Designed by RebelRose Design Team
Valid XHTML 1.0! Valid CSS!