Thank You! Thank You!! Thank You!!! This release fixed the duplicate problem. I am glad to know I wasn't losing my mind over nothing :)Quote:
Originally Posted by numinix
Printable View
Thank You! Thank You!! Thank You!!! This release fixed the duplicate problem. I am glad to know I wasn't losing my mind over nothing :)Quote:
Originally Posted by numinix
I've now fixed the issue in all of my feeders. I'm also releasing an eBay beta feeder right now.
P.S.
Remember to donate when you can!
Many thanks for the continued support for this great module.
And thank you again for your supporting my contributions ARRSE.
Have you had a chance to test the eBay feeder? I'm about to release another bug patch v0.9.2 in the next 30 minutes.
Hey everyone,
I un installed 1.48 and installed 1.4.10 and have he same problem. I am only getting 70 products put into my feed file and it finishes in 2seconds. What can I do to get this to capture all my products.Come on Numinix help me out. Thanks
Jack
What filters are you using?Quote:
Originally Posted by holbrja
What other scripts do you have installed (are any of them used to create/store products)?
Hi,
Found a problem while uploading; I am sure somebody else has encountered; it is not really a bug at the module nor google, but here it is:
This is my item description:
When the bulk upload file gets processed google base, google gets stuck at the quotation marks. Is there a way to filter them (and other non google-base friendly characters) out when the script generates the text file?Quote:
Satin "wedding night" pillow, Wedding leis with silver bells, "just married" antenna heart, Card with personal message, Cello bag, Sizzle paper shred
Thanks very much
This is a correction to my previous message: I think the problem is not just the quotations, but that google is thinking they are "nested" quotations because I have two sets of them.
Quote:
Originally Posted by numinix
Quote:
Originally Posted by onlyrey
I'll take a look at it tomorrow. It's easy to fix. You can save me some time by finding me the portion on Google Base that says what to do with quotations and other illegal characters. For eBay you just used double "" for ". I can also change it to "
Hi Numinix,Quote:
Originally Posted by numinix
I have these mods installed. Quick Updates, Easy Populate, Recover Carts, Image Handler2,Paypal Ipn, Paypal Express checkout. I have no filters that I set up. This is it as I am a novice and I try not to screw to many things up. I hope this helps.
Jack
I just wanna say thank you for this contribution! This is freaking awesome!
:clap::clap::clap::cheers::thumbsup:
Hi yet again,
I had another problem with this contribution as well as with the sitemap contribution.
When they are installed (don't know which one or if both), they create a problem with the required attributes loosing their "required" status even though the admin page shows them as "required".
Here is a fix grantc in another thread found:
http://www.zen-cart.com/forum/showpo...3&postcount=20
Your very welcome! I hope that this script will help your ecommerce companyQuote:
Originally Posted by sobebabies
:bigups:
Hello,
i would like to add the shipping weight and the breadcrumbs that lead to each product.
I use the google feed for 5 different product search engines
1. Google Base
2. Yahoo Shopping
3. Nextag
4. MSN Product Live
5. Bizrate / Shopzilla
They all are pretty much the same however some need a couple different attributes an I have thousands of products so to find those 2 items that I need would be very cumbersome.
How could I get those to attributes added and what file do I change?
Thank you for you help
You can edit googlefroogle.php found in the root directory.
Ok however I dont know exactly what I need to add to get the weight and the breadcrumbs. Can you help, which in turn will make a version that will work for all 5 version of shopping comparison engines that I mentioned above.Quote:
Originally Posted by numinix
avel
You would need to edit the SQL query to also pull the products_weight and then write a line to output the products_weight under the appropriate heading.Quote:
Originally Posted by batteryman
I'm not sure what the breadcrumbs are as I've never used them.
Since upgrading my google base is now throwing errors. Here are some samples:
We were unable to match the attributes in this tab-delimited bulk upload line to the correct header attributes. There are a few common reasons why you might encounter this error:
Your bulk upload contains an invalid character for the current encoding setting or contains a disallowed character.
There are fewer columns in this row than in your header (first) row. You may be missing a delimiter.
I have tried generating this with and without the upc/isbn enabled in the configuration and I still get errors.
Any ideas on what I need to do different? Thanks!
Sorry for the confusion, I am a beginner on php so I need a little more guidance. mmm now that I think about it alot more lolQuote:
Originally Posted by numinix
The breadcrumbs are the trail that lead to a product on top of the a zencart site. the link that say:
Home :: Notebooks :: Sempron :: ACER ASPIRE 3050-1270 AMD SEMPRON 3400+ 2.0 GHz 14.1" 120GB 1GB VH LAPTOP
I need this to e displayed in a column along with each product.
That was an example from your site. which I think I need to be linked to and you need to be linked to me. You offer the electronics and I offer the batteries to them. that is a side note.
There are possibly illegal characters in the description. I'll take a look at the sanitizer and see if it's possibly missing anything.Quote:
Originally Posted by BlessIsaacola
In that case, the breadcrumbs are already included in the PRODUCT_TYPE which is a list of each category starting from the top level.Quote:
Originally Posted by batteryman
If you want to exchange links, please use the webform located on my website by going to Link Partners located on the left hand side menu.
BlessIsaacola,
In the meantime, try changing the function that is used to filter the description. Scroll down to the area of the code that outputs the description stored in the SQL and replace zen_froogle_cleaner() with zen_froogle_sanita().
Let me know if that helps. I've decided that the next version will be in XML format to avoid problems with illegal characters in the description.
There's an opportunity numinix,Quote:
Originally Posted by batteryman
Develop this mod to support multiple feeds.
Considering Google Checkout mod plan to integrate GoogleBase
Woody
I would need coaxing to undertake a universal feeder.
I pretty much have to develop for myself and I do not use shopping comparison websites so their is no benefit for me. Writing them would take considerable time and I would be lucky to see donations enough to cover a single days work. I do greatly appreciate the few donations I have received and will continue to lend support to the zen cart community.
I'm currently reqriting the GBF in XML format to solve a lot of the members problems even though they currently do not affect my own feed.
Also, I requested for you to email me so that I can provide you with Andrew's RSS 2.0 module so that you can document it and release it to the public. I don't have time to do this myself and would appreciate it if you could. Once we have a documented and workable version, we can look into adding admin support in a future release.
Yes if one doesn't utilize the feed services it is difficult to keep up-to-date on the attributes and upload requirements for each.
Maybe somebody else with the skills can build an all-around feeder mod supporting various product search sites. Maybe fork off Fork off Andrew's GoogleFeeder, Sitemap XML or similar mods. Or look at mods to port from OSC.
You have the latest RSS2 mod from Andrew? What is last date change? Feel free to provide a link to it and I will download/compare with what I have. We probably should take this discussion elsewhere and not cloud this thread.
Currently the Google Base Feeder supposrt all 5 methods I mentioned before. I would just need to add the weight and breadcrumbs for each product. I believe this would be very simple to add if you could please just help with that.
Thank you
also i would like a copy of the rss feed mod as well if it is possible.
The weight can be added just like any of the other product fields. In the SQL products_query, have it pull p.products_weight. Then have an output to create the proper heading and then in the second output have it output $products->fields[products_weight];Quote:
Originally Posted by batteryman
Have the Feeder installed - working a treat on file creation after a couple of mods. I have one simple question - I can't upload via FTP at Google Base, so I'm going for the .txt file upload. Firstly, it wouldn't accept CSV files, so I converted the .txt to TSV (tab separated values) instead. Now it's saying it can't accept files with /:, characters in them - which makes URLs impossible, even if I've escaped them with a \ character. Short of rewriting the file into XML, is there a way round this?
Thanks in advance - and much love to the mod creators.
Thanks that fix reduces the amount of products rejected by google but I am still left with a significant amount of rejects. Should I apply the same zen_froogle_sanita to title as well? What's the difference between zen_froogle_cleaner and zen_froogle_sanita?Quote:
Originally Posted by numinix
Thank you!
Please ignore me - I am a moron. I was providing the web address for the 'file name' on the Base upload screen. :frusty:Quote:
Originally Posted by gaekwad
Numinix,
I got a message back from the google base people. This is regarding the payment_accepted, and payment_notes attributes. They said that neither of them are needed for bulk uploads, and if your google checkout and google base accounts are connected, and you have made a successful sale already, then the google checkout badge should appear next to the products.
I have not yet tested this since my store is not live just yet.
Thank you for this great module
Just two different functions written to make the descriptions look better. Yes you can run sanita on the title as well.Quote:
Originally Posted by BlessIsaacola
However, I've created an XML version which is complete. I'm currently waiting for Google to process my file before releasing publicly as there is an issue with bullets in the description. If the bullets were created using wingdings, they are very difficult to remove. If anyone has experience with sanitizing symbols such as a bullet (not created using <ul><li>...</li></ul>, but actual symbols cut and paste), please post your sanitization function. A simply $str = str_replace("•", "", $str); doesn't work and actually returns an error.
I even tried making the description only display letters, numbers, and spaces. The bullets still remained!
Jeff,
I am so excited about using this mod, Thank you so much.
I just installed the latest version (v1.4.10) in my store (Zen Cart version 1.3.7.1) and it appears to have installed properly. when I run the command to create the feed, it only give me 21 records of 1128 products I have available in my store. Can you help me fix this?
Matt
Are the filters off? Do you use any other scripts for posting products? A commercial script by MagicOne called Zen Manager is a POS that stores products in the zen cart database improperly and cannot be pulled using conventional methods. If you are using this script or somethign similar to create your listings, you may encounter that error.Quote:
Originally Posted by mbheald
How long does it take to process the feed file? Perhaps it is timing out.
v1.5.0 GOOGLE BASE FEEDER
1. now in XML RSS 2.0 format;
2. chmod's the file to 0655 on close;
A major update which creates an xml file that can then be uploaded to Google Base. You can also use the xml file as a valid rss feed and run a regular cron job to regenerate the xml file. I haven't written an XSL stylesheet to display images or prices etc as this would cause the feed to not validate with Google Base. However, this is a good prototype for a future RSS feed generator or possibly the same script with different parameters to also include an xsl stylesheet, etc.
The link will be back up soon. Just adding a couple of things that I don't want to have to create a new release for.
I just checked and all filters are off. I use easypopulate to update my products, does this one cause problems? The feed only takes a few seconds to create.
Download is back up.
I'll look into your issue later on tonight.
Hi
I am using version 1.4.8 which SQL update should i use, i see their 3 different ones
Thank you
How do I call on the weights of each products to be added to the txt file
avel
Use the SQL updates for the versions in between. So in this case 1.4.9b and the latest update located in the root directory.Quote:
Originally Posted by motti
You'll have to edit the product_query to include p.products_weight. Didn't you ask this question previously? I gave you a more detailed response previously. There is no advantage to adding this attribute to your Google Base feed.Quote:
How do I call on the weights of each products to be added to the txt file
btw, I made a minor change to the download file for 1.5.0 without releasing a patch.
To manually make the change to your file if you downloaded previous to this post, do the following:
in root/googlefroogle.php
replace line 140:
with:PHP Code:$content["guid"] = '<guid isPermaLink=false>' . $products->fields['products_id'] . '</guid>';
PHP Code:$content["guid"] = '<guid isPermaLink="false">' . $products->fields['products_id'] . '</guid>';
Numinix, do I have to uninstall upc/isbn mod in other to revert back to version 1.3.3 of this mod by Andrew? His version is the only one that works for me and generates all products. With your suggest update above I was able to generate more products with error but there are still more than 2,000 plus products with errors which is not good. The thing that baffles me is when using Andrew's version none of these errors are generated.Quote:
Originally Posted by numinix
Thanks!
I just installed google froogle. I had no idea what I was doing but it seems to work. The froogle.txt file generates successfully and when i open it using my ftp program the froogle.txt file is text written. but when i go to the directory using my browser it is blank.. http://www.pricepiggie.com/zencart/feed/froogle.txt Now here is my question: I uploaded the froogle.txt fiile manually into google base bulk and NOTHING. still no items listed at all and says processing but it seems dead! i did the upload to google base last night around midnight. any suggestions? I do not utilize the UPC and ISBN boxes within the products, but the boxes to input that information is there.
Any suggestions? Thanks in advance.
I just received a message back finally from google base: Bulk upload failed. No items are live. There are too many formatting errors in your file.
Error: We didn't understand the header (first) row of your file. Please make sure that there is one attribute name for each column, and that you are using valid attribute names.
Bad Data
<?xml version="1.0" encoding="UTF-8" ?>
Line #1
The errors should be fixed in version 1.5.0.Quote:
Originally Posted by BlessIsaacola
The file needs to be named .xml not .txtQuote:
Originally Posted by onetrade
NOTE:
The GBF is replacing unidentified characters with \x## with ## representing all digits 00-99. I'll try to have this fixed later this evening. Any product that has a description that contains one of these character identities will not be processed by Google Base. All other products should still validate without a problem.
Hi DAVID
I upgrade to 1.5.0 and I add the extra fix u post on Thread # 242, Installation was smooth, no errors and it all look good
When doing Step 2. my item look bit wrong Recess-It Square 14 x 14 Approx pre-finished dimension face = 13 1/4quot; x 13 1/4quot;, back = 12 3/4quot; x 12
It doesn’t use this symbol (“) this is in my description , not in title
I did not attempt to publish it yet, but I do need to , as I added more product
Thank you
This issue has been resolved.Quote:
Originally Posted by numinix
Replace line 130 with:
Motti, not sure if you are talking to me or not, but I do not understand your question. All descriptions have to be in plain text and I wouldn't worry too much about how they are displayed since Google truncates them to only a couple of sentences depending on what the user searched for.PHP Code:$content["title"] = '<title>' . zen_froogle_cleaner($products->fields['products_name']) . '</title>';
I changed the file to .xml how long does it take usually to take effect? it says about an hour, been around 4..
You should upload it manually the first time once you've registered the file name with Google Base. How long it takes varies.
v1.5.1 GOOGLE BASE FEEDER
Includes all bug fixes since the previous release.
- bug fixes;
Note:
If any of your products are not activated, please post the error message from Google Base. This is usually due to an illegal character found in your descriptions or titles which can be quickly and easily removed by updating the zen_xml_sanitizer function.
yup got an error message this morning: We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error
Bad Line: #14
I have the inch symbol ( " ) which turned into a square in the output file, so i did a find and replace all to a ( " ) and then uploaded the file and still got the error. Should I use your new upgrade to the newer version? i am using 1.5.0?
1.5.1 affects the title output. If this is appearing in your titles, then yes you need to upgrade to 1.5.1.
I tried doing this but this is the error I got.Quote:
Originally Posted by numinix
I edited the file file googlefroogle.php in the main folder. pleasse help me get this fixed.Quote:
1066 Not unique table/alias: 's'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_weight, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) LEFT JOIN TABLE_PRODUCTS_WEIGHT s ON (s.products_weight = p.products_weight) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]
I have added the file as an attachment if some wants to see what I did. I am not a php or mysql programmer so I pieced it together .
thank you
I'm going to help you out and do it for you this one time as you seem very determined. Now you'll have a better understanding of the script as well!
replace line 85 with:
You'll notice all I did was add the products_weight, found in TABLE PRODUCTS denoted with the (p.). Now you just need to create the outputs ofPHP Code:$products_query = "SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight
andPHP Code:$output["weight"] = "weight";
They will need to be placed in the same order on both the titles and the column outputs. I recommend you add this to v1.5.1 instead and have it output the weight in XML format by just copying any of the other lines and using the appropriate google base attribute name such as <g:weight> (not sure if that is correct, you'll have to check in base.google.com). If so, all you'll need to add is this:PHP Code:$output["weight"] = products->fields['products_weight'];
I would put this under line 146.PHP Code:$content["weight"] = '<g:weight>' . $products->fields['products_weight'] . '</g:weight>';
Side Note:
I am no longer going to support versions previous to the XML version 1.5.0. I have changed to this format for a reason due to future issues with google base. Older versions such as 1.3.3 are very outdated and do not include most of the required attributes unless you have heavily edited this version as woodymon did. In which case, it is no longer version 1.3.3 but some variant that he created himself. The UPC/ISBN is required and will eventually be used by Google to automatically include information about the product by using the stored attributes for that UPC/ISBN.
All illegal characters should now be removed and all of your products should validate and be accepted. Once again, if this is not the case, please post here and I will try to remedy the issue.
1.5.1 is the magic version, finally works! Thnks Numinix! i would only suggest adding a file into the feed zip directory google_base.xml for simplicity...THANKS ALOT!!!
Yes, good point. Version 1.5.1 works perfectly for myself as well and I believe it should also solve the issues that blessisaacola was facing as well.Quote:
Originally Posted by onetrade
Btw, doesn't it create the file google_base.xml automatically? I've now added it for future releases anyways, but I believe it shouldn't be an issue.
numinix,
I just upgraded to version 1.5.1, it seemed to create the xml file correctly exept I am receiving this error from google.
Outcome: Bulk upload failed. No items are live. There are too many formatting errors in your file. - help
Number of items processed: 1
Number of items succeeded: 0
Number of active items: 0
Uploaded at: Aug 7, 2007 5:26am PDT
Processed at: Aug 7, 2007 5:26am PDT
Errors:
Error Bad data Line #52
We didn't understand some of the XML formatting in your file. You may be missing a tag or have a nesting or formatting error. - help
You can view my file at:
http://hotnbottled.com/feed/froogle.xml
P.S. I had to manually add the file feed/froogle.xml as it is not included with my version of the download.
If you need to take a look at my admin, please PM me and I will get back to you.
Thanks,
Matt
There are no errors in your xml file. I would try sending it again. If you've named it froogle.xml, make sure this is also the name you've registered with Google Base.
For clarity reasons, line 52 is:
Your feed would validate if not for the <g:mpn> which is required by Google Base. So, I would suspect that you've tried sending a file before or something like that and they have denied the original file. Sending it again should remedy it. Allow a few hours for it to be accepted.PHP Code:<g:pickup>true</g:pickup>
P.S.
I like your hot sauce!
Ok, I verified the settings and the file name, but am still running into a problem. I tried to upload via the site admin and it seems to hang...
Google Base Feeder v.1.5.1 06.08.2007 23:35 started 2007/08/07 22:09:50
Feed file - /home/hotnbott/public_html/feed/froogle.xml
Processing: Feed - No, Upload - Yes
Upload started...
The browser window says done in the status bar. Does this mean the file is being processed?
Hello Numinix,
I downloaded your newest releaase because of the new features that you added (rss). I am working locally on my laptop usin XAMPP and I created a freash zencart and then load the googlefeeder 1.5.1. When I went to use it after I uploaded the sql syntax, I got this error.
I also had to create a blank xml file in the feed folder in order to get it to work up until this point because before I did I got an error saying file does not exist.Quote:
Google Base Feeder v.1.5.1 06.08.2007 23:35 started 2007/08/07 21:59:50
Feed file - C:/xampp/htdocs/biaf/feed/google_base.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_upc' in 'field list'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_upc, p.products_isbn, s.specials_new_products_price, s.expires_date, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]
I really appreciate you helping me on the shipping weight issue. Will your suggestion still work for this lastest version once we figure out what the problem is?
thank you,
avel
Taken directly from the SQL file:Quote:
Originally Posted by batteryman
Remember that many SQL patches will include comments just like in PHP.PHP Code:#REMOVE #'s BELOW TO INSTALL UPC/ISBN SUPPORT:
#ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model;
#ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;
And yes, I gave you instructions for adding it to the latest version or a pre-XML version..
[FONT=Times New Roman]Hi Numinix[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Do you know abut uploading top live .com ? do you know of a Thread abut it, it seam like it can use the froogle txt file, but I keep getting errors, I wonder if your mod could work with live.com also[/FONT]
[FONT=Times New Roman]http://productupload.live.com/Default.aspx?lc=1033[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]
Motti,
I cannot endorse the Google Base Feeder for use on any other website than base.google.com. Other feeders will be created eventually depending on the amount of interest and support in the creation of that mod. For live.com specifically, I believe they are US only and therefore are not accessible by many Zen Cart members, including myself.
That said, possible future scripts could include:
eBid.net
Yahoo! Product Submit
Shopzilla.com
Live Product Search
Shopping.com
Shopzilla.com
BizRate.com
RSS 2.0
and more...
In other words, if they support bulk uploaded files, then I can create a script to generate the feed file whether it's in tabbed, CSV, or XML format. I will be writing the eBid.net feeder as soon as they begin accepting tab delimited bulk upload files. Other than this script, and possibly an updates version of the RSS 2.0 script, I have not planned to write any other feeders.
[FONT=Times New Roman]Hi Numinix[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Yes the do support bulk upload.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I was able to upload my file [/FONT]
[FONT=Times New Roman]I only insert in the header of the feed.txt ( OfferName ActionURL RegularPrice ReferenceImageURL OfferDescription Brand CurrentPrice MerchantCategory)[/FONT]
[FONT=Times New Roman]And it work .[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Catalog file 'feed.txt' last uploaded on Aug 08, 2007 03:50:33 AM [/FONT]
[FONT=Times New Roman]Current status: Processing [/FONT]
[FONT=Times New Roman](It may take up to 36 hours for the files under processing to be published and searchable) [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]my only problem is that this feed.txt are made with your 1.4.8 version or older, and I only got abut 250 items there. I now have over 400 items, how can I update my feed again using your mod, my feed not getting update , only my froogle.txt[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]
If you are using a per-XML version, you should be using v1.4.10. Whatever file name you declare in the configuration is the file that will be written to.
Hello Numinix,
Thanks for the work on this.
I have installed 1.5.1 and created a blank google_base.xml file in feed and named that file in the configuration section.
When I do Step 1 and click Here, then View, my xml page has only the store name and no products, and the pop up window says "File Complete In 0.620673 Seconds 0 Records"
I also have Easy Populate installed, not sure if that means anything or not. I have zencart 1.3.7.
If you have any ideas about what I am doing wrong they would be much appreciated.
Thanks.
I did you modifications on the new version on a local version that i use for testing off of my laptop which worked great.Quote:
Originally Posted by numinix
then after i tested it i went live with it and my site when nuts. it through off everything and gave me errors. i fixed it quickly but here are the errors.
I am a total idiot. i read half of your first post which told me how to get the weight then i was happy and figured that it was all instruction on how to do it so I stopped reading and went on to the other post and saw that you had released another version(1.5.1). I then went to dl it and then proceeded to make a reply which asked how to set it up for the weight with out fully reading your post which already explained it. Sorry. Lessoned learned, :smartalec:Quote:
Warning: Variable passed to each() is not an array or object in /home/batte9/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /includes/classes/db/mysql/query_factory.php:114) in /includes/init_includes/init_templates.php on line 78
You were also correct in the weight attribute for Google '<g:weight>'. One thing i didn't understand is the p. and pd., what do they mean?? and why were they required?? The only thing I came up with is that they a part of a built in function a php function that is used to call upon information in a database.
Also why doesn't a product that has a upc code in the new field display it on the front page of the product, is a setting or is it just for the backend use?
No the UPC is for internal use only. You could edit the product info display to display it if you wanted to in the same way the weight or other attributes are displayed.
the p. pd. s. are the table names products, products to description, and specials. they are used to identify between product_id in specials, and product_id in products, etc.
UPDATE
Just a quick little bug fix that is not required to be changed but will help make your descriptions and titles display better:
Change lines 318-319 to:
This is a reversal of the two lines which formerly appeared like this:PHP Code:$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
$str = htmlentities($str);
PHP Code:$str = htmlentities($str);
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
Thanks to motti, I decided to take another look at Windows live Product Search and was very pleasantly surprised to see they are now available internationally. As I now have a self-interest in the script, I will be writing a contribution to create bulk feeds. I'm posting this here because the request was made in this thread.
A pre-support thread has been put up and can be accessed at the following link:
http://www.zen-cart.com/forum/showthread.php?p=415620
Your support is appreciated.
Quote:
Originally Posted by numinix
Thank you, I will look into that. But I still need to find out why I got those errors after I loaded the new version of google feeder. What do you think the errors in my last post meant?
I honestly have no clue.
I don't want to clutter this thread with personal modifications to the contribution, so, I am going to add product_weight as an optional configuration selection in the next version so that you will not have these errors. Merry Christmas :)
batteryman, are you able to use the FTP function on the Google Base Feeder?
I've been doing testing to get motti's installation to work. He has redirects to his root from /store/ which made it very confusing and that is why he had two different feed files named differently in two different folders. I installed v1.5.1 on his server and it creates the file instantly without problems.
However, when I attempt to transfer with FTP, it returns connection failed after 40 seconds. I then created a test.php file which is a simple FTP connect script and it also failed with the following error, which I do not receive with the exact same file on my site:
Warning: ftp_login() expects parameter 1 to be resource, boolean given in...
I check his PHP version and it is the same as your 4.4.6. My server has 4.4.7. Could everyone who is having problems with the FTP function please post your PHP version.
From Google Base:
File registration is temporarily unavailable.
Notice: File uploading is temporarily unavailable
Hello,
I do not use the ftp function, I usually go through it manually after it is generated and check to see if there are any illegal characters and modify the column and some of the output the way I wany it to appear and then I use Filezilla to ftp it to the google base server.
I am running PHP 4.4.7 as well. I just moved into a dedicated server for my site and I haven't updated my signature until right now.
I think that maybe there is a conflict between your mod and another I am possibly using.
I have installed:
(IH2) Image Handeler
Google XML Sitemap
Google Analytics
Google Base Feeder (however uninstalled the sql for now until I figure this out)
I also modified the right column to contain my accredidations and the search to hold the Hacker Safe Seal
I checked the files that supposedly gave the errors and I dont se anything wrong with. They appear to be the original zencart file.
Maybe its a mysql version possible?? just guessing now though.
No, the FTP function has nothing to do with MySQL. If it isn't the PHP version then I really am not sure what could be causing the FTP problems.
It's also none of the contributions that you have installed. You may want to contact your host and ask if there is anything that could be blocking the ftp function from connecting to the destination server. Perhaps blocked ports etc.
Post your results back here and if we get the FTP issues resolved I will put it in the readme.txt file.
Well I'm not having a problem with FTP portion of the module. Its when I install the sql portion of the newest version 1.5.1. My site will not display at all and I get the errors right of the batt.
I will send you a screen shot.
Just to add my thanks to numinix for the regular updates to this excellent module - I've just upgraded to 1.5.1 without any problems.
There shouldn't be any SQL errors... Are you copying and pasting? It's the exact same SQL file from previous versions...Quote:
Originally Posted by batteryman
Yes I am copy and pasting. I began to think on how I set the whole mod up and I did an upgrade to 1.4.10 from 1.33a originally which worked grreat but then I tried to upgrade to 1.5.1 and that where I started to get the problems.
So I went through all of my database removing all the old tables and then I went through my site manually to remove all the old files, after backing up of course.
Then I reinstalled the mod from a fresh start reading the instrutions carefully. I have no website display problems anymore however I cant actually use the mod either. I get BOX_GOOGLEFROOGLE under the Tools menu instead of Google Base Feeder and when I click on it i get this error:
Click on it and you will get the same error i get. So i went to the directory to see if the file is there and it is. The permissions are set to 644.Code:http://www.batteriesinaflash.com/adm...GLEFROOGLE.php
"The requested URL /admin/FILENAME_GOOGLEFROOGLE.php was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."
Doesn't make sense to me. Argg...
To uninstall all you had to do was run the uninstall.sql for that version which you are removing. You also can't just upgrade from 1.33 all the way to 1.4.10 without running a lot of sql files. It's better to run the uninstall.sql and then just overwrite your files.
This is what you should do now, run the uninstall.sql for the latest version and if there is a configuration settings profile for "Google Froogle Feeder" you will also need to run one of the older uninstall.sql files that removes "Google Froogle Feeder".
Next, reupload the entire file package except for the files that are for the UPC/ISBN module (in the next release I won't be including these files by default). Then run the googlefroogle.sql file and it should all be installed correctly. The reason you are getting BOX_GOOGLEFROOGLE is because you are missing one of the admin files which defines this constant.
Good luck.
Thank you for all your hard work on this. I have one quick questions for you:Quote:
Originally Posted by numinix
Can you please explain how to utilize the RSS Feed that is now supported. I did not see anything in the readme file that explains how to use this.
Thanks!
Hello,
I tried all of your suggestion last night and they didnt seem wot work. Even after I use the uninstall the box_googlefroogle menu option is still in the tools menu.
Whats weird is I installed the isbn and upc support because everything has a common upc but when I try to uninstall it I get an error code:
Which is probally why you are not adding in the next version as a default.. lolQuote:
1054 Unknown column 'p.products_upc' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_upc, p.products_isbn, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '1413' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Well I am going to try it again and see what happens. I will document my steps so you can see if there is an error in what I am doing.
thank you for all your help, I really do appreciate it. I know your mod works perfectly just a small problem with my setup perhaps. we will get it fixed.
Hi.
I firstly would like to say congratulations to all those that had no issues with installing this mod.
Also well done to the mod developer, its a great mod.
Unfortunatly i was very unsuccessful in installing this mod, Its 18:40 here in the UK and I have been trying to do this mod since 15:00 today!
If anyone can help me install the mod, well basically install it for me, as I have had to uninstall it and restore my backup.
I am running v1.3.7 and the mod is v1.5.1
It just did not work at all.
Nevermind spending hours trying to find the .xml file, when I had to infact create it myself, only to find it just does not work.
Please do not ask me all sorts of technical questions as I will not be able to answer them. I am a novice and even got help from a programmer and her followed the instrutions to the letter and could not get it to work.
Please I need serious help with this mod as I am not sitting here all day just uplaoding to google froogle, base, MSN live etc etc.
Thanks in advance guys and gals.
When you say it doesn't work, did you get any error messages?Quote:
Originally Posted by TJR Stores
Is the feed folder as well as the xml set to read/write/execute?
Have you use any previous version of this mod?
You upload it to Google Base just like the tabbed file. But make sure you've defined it.Quote:
Originally Posted by BlessIsaacola
You are right though, it does create an RSS feed. However, because it contains g:mpn, it doesn't validate but will still display the title and descriptions in most readers. In order to use it as an RSS feed in general, I'd have to change it to display the products in order from newest to oldest and create an XLS file to display the prices, images, etc. Rather than change this mod, I will just be updating the RSS 2.0 v1.5.7 to v1.5.8 in the next month with added Admin support. v1.5.7 is not currently publicly available and doesn't have any documentation.
Wait for v1.5.2 which will avoid the SQL errors for those not using the UPC/ISBN mod and contains all the updates that I've pasted in the thread as well.Quote:
Originally Posted by batteryman
TJR,Quote:
Originally Posted by TJR Stores
I have installed and reinstalled the new version more time than i can count so I consider myself a self proclaimed expert. I can help you however I need more details on what problems you are having and how you installed it.
Here is a really generally summary of what you should do. First of all did you upgrade or start from a fresh install?? I had tried both way. If you started fresh do not install any of the previous sql updates only the current sql for 1.5.1. So what you need to do is run the uninstall sql file and if this was your first tiime install the mod if not run the previous versions uninstall files as well
Then reinstall the googlefroogle feeder files files to your server and then go to your store admin>tools>install sql patches and copy and paste the sql install file into the big open box and then hit send. should take care of your problem
I also had to create a blamk xml file in the folder FEED and upload it to my server. be sure to name the file the same as the file name specified in your configuration in admin>configuration>Google Base Feeder Configuration
hope this helps, numinix spent hours helping me so hopefully I got it right.
OK, first of all :clap:, I did it all over again and it all worked as you suggested however i did the exact same last night and I had the problem mentioned. Which leads me to believe you have a magic touch or I really should try to work so late when Im exhausted.Quote:
Originally Posted by numinix
I then added all of the modification including the weight and the one that you mentioned above that helps your titles and descriptions and it is all working.
I will now move on to the bread crumb issue I will try to do this on my own cause I have pestered you enough, cant wait for the newest release.
Thank you so much for your time
Numinix, I am assuming this codeQuote:
Originally Posted by numinix
is the reason why it's using product_id instead of product_model as configured in on the admin configuration page.PHP Code:$content["guid"] = '<guid isPermaLink="false">' . $products->fields['products_id'] . '</guid>';
The code is not using the setting from Show Offer ID.
Thanks!
Yes this was a fresh install.Quote:
Originally Posted by batteryman
all i did was install the v1.5.1 sql file.Quote:
I had tried both way. If you started fresh do not install any of the previous sql updates only the current sql for 1.5.1.
I uploaded all the files where they should go according to the read me file contained in the download. And kept getting all sorts of errors. I cannot give you these errors as I have officially given up on this untill I have had enough coffee to put my head through all this again :laugh::laugh:Quote:
Then reinstall the googlefroogle feeder files files to your server and then go to your store admin>tools>install sql patches and copy and paste the sql install file into the big open box and then hit send. should take care of your problem
did this too.Quote:
I also had to create a blamk xml file in the folder FEED and upload it to my server. be sure to name the file the same as the file name specified in your configuration in admin>configuration>Google Base Feeder Configuration
I am stuck, I have done all you said, and it will not work.
My only hope really is for the mod developer to install it for me to see if i did anything wrong, alhough after spending over 3 1/2 hours doing it, checking and re-checking the work I feek and know i followed the read me file to the letter.
Thanks for your help though.
I will give it another go after my head has stopped swelling up. :laugh::laugh::laugh:
Cheers
Rob
I'm going to remove that SQL configuration unless someone feels strongly that it should remain.
g:id and guid are used to uniquely identify the products. Unless your products share the same product id, which they shouldn't, then this will be the most unique number as your zen cart will never reuse the product_id. This isn't something that is displayed by Google Base but is important for updating your products.
I'll bet you uploaded the UPC/ISBN files without installing their lines in the SQL... Just wait for v1.5.2 which has removed this and requires you to install that mod separately.Quote:
Originally Posted by TJR Stores
Thats where i went wrong, as i have no clue what you just said to me!Quote:
Originally Posted by numinix
What is the UPC and the ISBN?
v1.5.2 GOOGLE BASE FEEDER
- Code optimization;
- Added g:weight attribute (optional);
- Added troubleshooting to the readme.txt;
- Automatically creates the .xml file if it does not already exist;
- Removed UPC/ISBN mod as required (must now install separately);
cool.
Thanks for the update.
But can someone please tell me what the UPC/ISBN is?
Do I need it for this mod to work?
You do not need UPC/ISBN for this mod to work as Numinix has explained in previous posts and with 1.5.2 release.Quote:
Originally Posted by TJR Stores
If you're interested in finding out what UPC/ISBN mod is you can read up in that thread located here: http://www.zen-cart.com/forum/showth...upc%2Fisbn
ok thanks.
But I am looking for the google config thing. in zen admin.
Its not there.!!!
I am leaving this mod for now.
I will wait till someone can give me the help i need. it can't simply be done over a forum board.
Thanks for all your help guys and gals, but i think i will have to wait till after the weekend to get this done.