installed the latest but when i go to create feed i get this error
Attachment 2627
any idea's
Printable View
installed the latest but when i go to create feed i get this error
Attachment 2627
any idea's
Firstly, you are missing some admin definitions which is why the CONSTANT name is displaying rather than your feed name.
Secondly, the language you have entered in the Google configuration was not found and that is why you had the SQL error. If you're site is English, make sure this is left as English, etc.
I had some trouble with this module in that after the upgrade ( I think I skipped about 10 versions ) everytime I tried to create the xml file it would run but say 0 records were processed. I had no constraints at all.
I finally traced the problem down to mismatching file names. I was originally using a custome filename of cycle.xml and after the uninstall/reinstall it defaulted the name in the configuration to something else. I figured that it wasn't a big deal and just created the new file and tried to run the process. Unfortunately the process tried to use the old file (which still existed by the way) and reported that it had process 0 records. After I changed the filename in the configuration back to my custom name of cycle.xml it worked fine.
I just thought I would post this in case anyone else has had this problem and posted a solution. I tried reading the entire thread but got about half-way through and was wondering if it would ever end. So I skipped to the end and read the last three pages.
As to the actual upgrade itself there were no issues at all, I received a couple of permission errors, but those were my own fault; I was very impressed.
v1.60 GOOGLE BASE FEEDER
1. Added new paramters (type=products or downloads or documents);
2. Code optimization;
3. Bug fix;
This is a more major update with some code optimization and a minor bug fix for those who don't have ASA installed.
The new parameters are passed just like the feed=yes&upload=yes (type=products etc).
So far, downloads and documents are treated exactly the same and use the Google Reference Article as their template. Therefore, when uploading "downloads" or "documents" choose REFERENCE ARTICLES as your ITEM TYPE.
This version will become the prototype for the RSS 2.0 FEED GENERATOR which I hope to have in development shortly.
Hi, I plan to install and use the mod for the first time. I'm reading the README file and it says the following files are affected:
----------
admin/includes/languages/english/product.php
admin/includes/modules/product/collect_info.php
admin/includes/modules/update_product.php
----------
However, I was checking the contents of zip file I just downloaded and I don't see any of these files included in it.
Does this mean the mod has now been modified so that it doesn't touch any original files and the README file needs updating or am I missing something else?
Thanks.
Hi Jeff
I got version Google Base Feeder v.1.5.0 05.08. , which SQL or SQL’S so I need to run?
And do I need to run the googlefroogle.sql also?
Thank you
Motti,
Write down all the important information from your Google Base Configuration and then run the googlefroogle.sql from the version you want to install. I would run either 1.5.3a or 1.6.0 as there have been bug fixes since 1.5.0.
Or, you can run all of the sql updates between your current version and the version you are upgrading to. These can be found in the sql updates folder.
That section should be removed from the readme.txt as those files are no longer affected by the Google Base Feeder and are now included with Auction Site Attributes. I will update the readme.txt.Quote:
Originally Posted by tj1
I am using 1.5.3.
Everything is ok except google shows no images.
The latest "thought" from one of their techies is as follows:
"Hello Marvin,
Thank you for your email. I checked your image_links again and noticed
that you're content-type header is incorrect. Currently, your header line
is setting the value as "text/html;" however, an acceptable content-type
would be "image/jpeg" or "image/gif," depending on the format of your
image.
Please make sure that the header information is correct for your images;
otherwise, our image processor will be unable to cache a copy of your
image.
If you have any further questions or concerns, please feel free to respond
to this email."
Does this make sense? Does'nt the contribution have the correct header?
The read me file does not say anything about any changes to the header file.
Help, anyone?
Thanks for the confirmation.Quote:
Originally Posted by numinix
One more thing, the readme file says Register your bulk upload .xml file using the same name in your Google Froogle Configuration at base.google.com
I noticed Google Base Feeder appends "_products", "_documents" or "_downloads" to the file name you specify in the output file name specified in the configuration.
For this reason, so that noobs like me don't get confused and can't understand why the file is not working, I think you should add to the readme file that one should also append this to the file registered in Google Base.
For example, if one has my_gbase_file in the output file name field, the file you registered with GoogleBase should be named my_gbase_file_products.xml
I just was at Google Base browsing the FAQ and noticed they have a little desktop program called Google Base Store Connector. It allows you to publish your products from eBay stores, Yahoo stores and OSC stores, pretty neat! Here's the link: http://www.google.com/base/storeconnector
Too bad it doesn't support ZenCart yet. I just submitted my suggestion. I think support for ZenCart will be added in due time, after all ZC is superior to OSC and has a very large user base, just wished Google would realize this and give priority support to ZC. :)
Anyone who wants to submit a suggestion telling them you want support for ZenCart can do it here: http://base.google.com/support/bin/request.py?contact=1
well, Dumbo reporting in here. I had a previous version of FG feeder and just installed 1.5.3 and am getting this error.
Warning: chmod() [function.chmod]: Operation not permitted in /home2/shabecom/public_html/googlefroogle.php on line 67
Error opening google base output file "/home2/shabecom/public_html/feed/shabbychiccottagefeed.txt"
I have permissions set at 777.
I don't know what I need to do to fix this............any help appreciated.:dontgetit
Delete your feed file and then run the script again, let it generate the file for you. Also, the file should be named .xml in all 1.5.x versions.Quote:
Originally Posted by tolefairy
In 1.6.0, the feed file is just a word like shabbychiccottagefeed. It will automatically add _products.xml (for a product feed), _documents.xml (for a documents feed), and _downloads.xml (for a downloads feed).
I will be modifying the downloads feed to be similar to the products feed to support prices etc. I will also be looking to add the product-music and product-free shipping to have more unique attributes in upcoming 1.6.x versions.
Still need help with this image problem??????????????Quote:
Originally Posted by marvin
I'm not an expert on XML so I don't know why this wouldn't work for you, but would work for everyone else.
Furthermore, there is no header in the file for text/html:
PHP Code:<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
<channel>
.
.
.
</channel>
</rss>
ok, I deleted the shabbychiccottage.txt file on my server. Then ran the script again. It created a shabbychiccottage.txt file again but it's empty.Quote:
Delete your feed file and then run the script again, let it generate the file for you. Also, the file should be named .xml in all 1.5.x versions.
This is what it said:
Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/09/19 19:50:00
Feed file - /home2/shabecom/public_html/feed/shabbychiccottagefeed.txt
Processing: Feed - Yes, Upload - No
Google Base File Complete In 0.107445 Seconds 0 Records
so........it's not creating any records? Ftp is working fine BTW
I remaned the new file on my server with a .xml extension and ran the script again. same response. No records.
I've messed up somewhere.
Also I might add, in admin>configuration I now have TWO of these:
Google Base Feeder Configuration
Under admin>tools I only have one Google Base Feeder
Also after I run the script and get the above result and then click to view product feed file, I get a screen about LiveBookmarks and under that the title Shabby Chic Cottage and the rest of the page is blank.
Should I uninstall 1.5.3? What about the previous version I had? I copied and pasted all of the sql updates that were in the download for 1.5.3. There were 4 in a folder and then the one for 1.5.3.
TIA for any assistance..........:smile:
The sql for 1.4.9 should have changed the name to Google Base Feeder Configuration.
Use this to uninstall it:
See if that fixes it.PHP Code:SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
ok I used that to uninstall. Ran it as a sql patch.
I still have two, repeat two, "Google Base Feeder Configuration" in my drop down menu of admin>configuration
One asks id and such and the other asks for my domain name and store description. They are completely different configs but have the same name in the drop down. Is this correct? Should there be two?
Ran the script again and same thing.............0 records
Maybe if I uninstalled everything related to froogel/google feeder?
Oops, I thought you had one installation called Google Froogle Feeder Configuration
Run the same patch but replace the name with
Google Base Feeder Configuration
Run it twice and then run the SQL of the version you want to install.
If installing 1.6.1, you'll need to re-register your file name as it now appends the feed content type in the title to distinguish different feeds from each other _products _documents _downloads and eventuallly _music
Hmm...just installed 1.61 (an upgrade from 1.53) and all seems to work but get this repeating stuff in the admin? Just copied the zip files up to my host, no SQL changes...
ok...did what you said......and then installed 1.5.3 patch again
where b4 I had two Google Base Feeder Configuration in admin>configuration, now I have none. No configuration at all for Google Base Feeder Configuration.
I ran the script anyway to see what would happen and this is what I got:
Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/09/20 00:24:30
Feed file - /home2/shabecom/public_html/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.products_id DESC' at line 11
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, 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 FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN 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 = ORDER BY p.products_id DESC]
TIA for all your help...............:smile:
update:
while waiting for more answers I re-uploaded all the files for the 1.5.3 version.
Maybe I missed a file the first go round because it works now. I have the right config file now.
I apologize if this is what was causing the problem, but since we did several "fixes" I don't know which one worked.
HOWEVER..........as beautiful as it is and as impressed as I am, there are no images showing when I view before uploading. Am I supposed to be seeing images on the "view before upload" page?
If so, I don't.
What can I do to fix this?
again, TIA, u r a very patient and helpful person!
The XML will not show the images in your browser. You'll need to view it with an XML editor to see the attributes. You would need to write an XSL or CSS file for the XML feed which you can't do or your feed will not validate with Google Base.
I plan to eventually write an RSS generator...
Thanks again so much. I just did a "page source" view and could see that the image link is indeed there.
I went ahead and uploaded to google and everything uploaded. But I didn't set the expiration date correctly in the config, I guess because it shows as expiring today.
So I created a new upload, with a different file name after setting in the config to 31 days. Made a new file and uploaded that. Is that what I should have done?
Am waiting to see if the new file will show the correct expiration date.
I'm almost there and this is such a good mod. It's refreshing to have an author that continues to assist newbs like me.
many thanks!
The script is set to expire the feed after 365 days, so it would be the same day/month, but 2008 as someone else in this feed also mistakenly missed. Anyways, the expiry is not important because you should be uploading your new feed EVERY time there is a change in your products. Google Base will actually reject feeds if there are discrepancies between your site and the feed details. Setting a cron job to run at the same pace as your changes, daily, weekly, etc. will avoid this.Quote:
Originally Posted by tolefairy
Hi,
I have just updated to 1.5.3.
Says my feed.txt was created but there is nothing in the feed/ dir.
also when I choose to upload it says login is incorrect. Login is right tho.
to update I replaced all .php files and ran the 1.5.3 update patch.
all seems to be successful other than it doesnt work.
any ideas?
Thank you,
John
Please upgrade to 1.6.1, available on my website.
Your username and password for your FTP are different than for you Google account. This is one of the most common questions asked and it is stated right in the readme.txt file. I'll upload 1.5.3a (less bugs than 1.5.3) to the downloads section today, but I am now hosting all of my updates on my site only and therefore is the only place to get 1.6.1.
Numinix, sorry to re-post, but didn't get an answer to the below from my post back a page here: #402. Just wondering what could be a corrective measure.
Quote:
Originally Posted by tcustomgolf
I just installed and run Google Base Feeder. Some of my products did not get written to the XML file.
I compared the data of the ones that worked and ones that did not and found that as soon as I enter a value into PRODUCTS table PRODUCTS_PRICE_SORTER the product gets written to the file and the value from PRODUCTS_PRICE_SORTER goes into <g:price>12345.00</g:price> tag.
The reason I do not have anything in PRODUCTS_PRICE_SORTER is because i am using product price attributes where product's price is structured as follows:
Product 1: 30
60
90
Product's attribute price is stored on PRODUCTS_ATTRIBUTES table. Is there a way to get the feeder program to recognize the attributes and read the correct table?
Each line is the new product type, I'll make it look nicer but if you read carefuly you'll notice the differences...Quote:
Originally Posted by tcustomgolf
The script is getting a little more complicated in 1.6.1 but under the case "products" section, you can add to extract the product attributes from TABLE_PRODUCTS_ATTRIBUTES and then if that exists, replace $price with the attributes price.Quote:
Originally Posted by ericny
However, if you have three products with everything the same but the price, Google will need a unique ID for each one which won't be product id, model, etc... I would set one as the default price and then it's option will be +0.00 and the other options +30 +60 that won't appear in the feed but will still be noticed as most people would never click on the two more expensive items as all other things are equal. Is this making sense?
Samsung 19" LCD MONITOR
OPTIONS:
BLACK -> +0
SILVER -> +30
METALLIC BLUE -> +60
You'd then need to feed the option name as a separate attribute, change the price, and then somehow come up with a unique id that can be derived from the database for each separate product.
Do you use this script: http://www.zen-cart.com/index.php?ma...roducts_id=310
Does it assign a product_id to each attribute? If that were the case we could simply extract the attribute price and either add it to or replace the product price.
Okay, 1.6.1 worked great for me at stompaudio.com
Im working on another site for a friend and have never had any luck there with the feeder. any version.
I see the config for 1.6.1 in admin config now but nothing under tools.
have uninstalled and reinstalled 3 times now. even tried deleting the files before uploading new ones and overwriting. still no luck.
What is wrong when feeder doesnt show up under the admin-tools?
Thanks,
John
Do you have admin profiles installed? Have you checked your permissions there?
Not sure what admin profiles are. Just made a new profile under tools and admin settings tho. Says nothing about restrictions or access to anything tho.
Not quite sure whats going on here but user tracking isnt showing up either.
.sql executes fine. all files are in place. no config with UT tho.
wonder if im just doing something wrong and im not catching my mistake.
John
A couple of questions:
- Is it necessary to have the feed folder chmodded to 777 ? I currently have it to 755 and it seems to work just fine.
- I just noticed there's v1.61 already, I currently have v1.60. It says there was a bug fix, however I've done a full comparison of both releases using WinMerge and the only different files appear to be the README files. Were there really any bug fixes?
Thanks.
yes there were a bunch but they aren't very significant and will only appear if youQuote:
Originally Posted by tj1
1) don't have ASA installed (or the UPC/ISBN mods)
2) are using a non-english site as was brought to my attention much earlier on in the thread.
I'll have to take a look and make sure I included the correct file sometime tonight.
Yes, please do check as I really did complete comparison of both releases (1.60 and 1.61) using WinMerge and the only difference is in the README file, not a single difference in any other files.
And about having the feed folder, I guess it's not necessary to have chmodded to 777, correct? I have set to 755 and it works just fine.
Another issue I'm having. The file is being generated and uploads just fine, but Google gives the following error:
============
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: Sep 21, 2007 8:34pm PDT
Processed at: Sep 21, 2007 8:31pm PDT
Errors:
Error Bad data Line #4
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
=============
I'm using v1.61. I opened the file and what I have for line four is the following:
<title>S&A</title>
Do you what could be causing the error? is it the & ampersand?
That is the only special character in the title. That is a bug and will be dealt with. Your other items should process though...Quote:
Originally Posted by tj1
I just check the googlefroogle.php file in the root of the .zip and it contains the bug fixes not present in 1.6.0. At the very least you would have found a discrepancy in the version numbers.
To fix the bug, try adding this to ln 503 at the end of the zen_xml_sanitizer function:
That should convert all special characters to their html entities.PHP Code:$str = htmlspecialchars($str);
Please post back if that solves your issue! I will then release a patch for the Windows Live Product Search Feeder and the Google Base Feeder which both are in XML.
I redownloaded 1.61 and compared to 1.60, this time the changes did show up, not sure why they didn't show the first time.
Anyway, I added the line of code to the function just like you indicated:
However, this didn't work. I created the file again and reuploaded and I still get the same error from Google and line 4 still says:PHP Code:function zen_xml_sanitizer ($str) {
$_strip_search = array("![\t ]+$|^[\t ]+!m",'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array('',' ');
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", " " => "");
$str = html_entity_decode($str);
$str = strtr($str, $_cleaner_array);
$str = preg_replace($_strip_search, $_strip_replace, $str);
$str = strip_tags($str);
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
$str = htmlentities($str);
$str = htmlspecialchars($str);
//$partial_entity_array = array("quot;", "lt;", "gt;", "amp;", "apos;", "nbsp;", "deg;", "plusmn;", "ordm;", "sect;", "up2;", "circ;", "up3;", "uml;", "acute;", "ordf;", "frac12;");
//$full_entity_array = array(""", "<", ">", "&", "'", " ", "deg", "+/-", "", "", "^2", "^", "^3", "", "", "", "1/2");
//$str = str_replace($partial_entity_array, $full_entity_array, $str);
return $str;
}
<title>S&A</title>
Any other ideas?
In the meantime, I've manually edited the xml file and changed that line to
<title>S&A</title>
What exactly does the 'Compress feed file' setting do? Is it supposed to create .zip/.gz file?
I actually end up with a bigger file if I set this to true.
If this setting is turned on, file size is 20.08MB. If turned off file size is 18.18MB.
I keep getting this Connection failed: uploads.google.com . can anyone tell me whats wrong?
Take that line out, it will actually create more bugs than it'll fix. Let's try this instead:Quote:
However, this didn't work. I created the file again and reuploaded and I still get the same error from Google and line 4 still says:
<title>S&A</title>
Any other ideas?
In the meantime, I've manually edited the xml file and changed that line to
<title>S&A</title>
PHP Code:function zen_xml_sanitizer ($str) {
$_strip_search = array("![\t ]+$|^[\t ]+!m",'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array('',' ');
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "\t" => "", " " => "");
$str = html_entity_decode($str);
$str = strtr($str, $_cleaner_array);
$str = preg_replace($_strip_search, $_strip_replace, $str);
$str = strip_tags($str);
$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);
$str = str_replace('&', '&', $str); // changes & to &
$str = htmlentities($str);
$str = str_replace('&amp;', '&', $str); // replaces occurences of &amp; with &
}
did you create the ftp account on google base?
(you have to create it, even if you have a google base account already)
Quote:
Originally Posted by rxalex
Quote:
Originally Posted by numinix
Unfortunately, that didn't work either, still getting this on line 4:
<title>S&A</title>
Also, with a different file feed from another website I get this error from Google:
Error Bad data Line #6
We found a mismatched XML tag. - help
This is what line 6 has for this file:Any ideas on this other one?Code:<description>Sells fine solid gold jewelry.</description>r-jewelry.com/images/large/gld/r3248_LRG.jpg</g:image_link>
Thanks.
Could it be possible that your title is too short??? I think the XML editor is displaying it as &. Try opening with a text editor like notepad and see if it really is & or &
Yes I did create the ftp account but get this error :( any idea?Quote:
Originally Posted by yellow1912
The ftp account takes a while to be ready to use. Make sure you can login directly to that ftp server first,
Thanks I am able to login though but tried again with adding ftp:// in config still not doing it :(Quote:
Originally Posted by yellow1912
Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/09/24 15:44:54
Feed file - /home/fae/public_html/sun/feed/1800_google_base.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: ftp://uploads.google.com
Warning: ftp_connect() [function.ftp-connect]: php_network_getaddresses: getaddrinfo failed: Name or service not known
Upload failed...
I use this in my setting: uploads.google.com (without the ftp://)
yep had this aswell uploads.google.com but upload failed :(
I use Google Base Feeder v.1.6.0 16.09.2007 (downloaded from numinix's site)
Thanks I will upgrade what do I do with the sql file uninstall or updates how would I do this?
Oh no I upgraded but have double of:
INSTRUCTIONS:
STEP 1: Click [HERE] to create / update your products feed.
NOTE: You may view your product feed file before proceeding to step 2.
STEP 1: Click [HERE] to create / update your documents feed.
NOTE: You may view your product feed file before proceeding to step 2.
STEP 1: Click [HERE] to create / update your downloads feed.
NOTE: You may view your product feed file before proceeding to step 2.
STEP 2: Click [HERE] to upload products feed to Google Base.
STEP 2: Click [HERE] to upload documents feed to Google Base.
STEP 2: Click [HERE] to upload downloads feed to Google Base.
NOTE: You may view Google Base FTP content.
Can someone help please?
Google Base Feeder v.1.6.1 19.09.2007 16:37:59 started 2007/09/24 17:00:38
Feed file - /home/fae/public_html/sun/feed/1800_google_base_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com
Upload failed...
still no progress, any ideas what can be wrong?
Isn't that the same old version you were using? :)
updated.. to 1.6.1 but issues :(
I really don't think it has anything to do with the title being too short. I've only opened the file with the text editor UltraEdit and it shows just like I mentioned before <title>S&A</title>Quote:
Originally Posted by numinix
Anyway, my php knowledge is very limited, but I think I found the reason. In line 79, the title line is not being sanitized (not sure if that's what you call it).
Shouldn't it be like below?PHP Code:$content["title"] = '<title>' . STORE_NAME . '</title>';
I tried that, and it results in:PHP Code:$content["title"] = '<title>' . zen_xml_sanitizer(STORE_NAME) . '</title>';
<title>SA</title>
While this is good and eliminates the error reported by Google, how can I get it to work properly and output <title>S&A
Read carefully. Each one is different. One is for products, one for downloads and the other for documents.Quote:
Originally Posted by rxalex
Check that your google base ftp account is already activated and working. Using Internet Explorer or Firefox type ftp://uploads.google.com on the address bar.Quote:
Originally Posted by rxalex
Enter your username and password. If you can connect then your ftp account is working properly, if not, you have to wait until it becomes activated or contact Google if doesn't become active after a couple of days.
Check that you have entered your username and password correctly and in the correct fields in ZC Admin > Configuration > Google Base Feeder Configuration.
Note that the field for password comes first, then the username. We're used to entering username first, so check to make sure they're not switched.
Thanks Tj I guess overlooked that sawwwy:oops: eventhough put in the correct ftp username and password but still
Google Base Feeder v.1.6.1 19.09.2007 16:37:59 started 2007/09/24 21:49:56
Feed file - /home/fae/public_html/sun/feed/1800_google_base_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com
Upload failed...
any other ideas why this may not be working or am i stuck doing it manually :(
Are you able to connect to Google's ftp using an FTP program or Internet Explorer or Firefox?
You might also want to contact your host to make sure all the required ports for PHP FTP functions are open.
I am having a strange problem.
Looking at my google feed I noticed that most of my products are there
But not all of them! Sections by manufacturer are missing.
I have tried and tried again and it keeps doing the same thing.
My live feed has everything. How ever that is in xml and I dont know how to work with that.
Thanks Tj yes it was the host, the only way for ftp uploads is to make it a dedicated ip :( ... I guess I have to upload the file manually... Appreciate your help Tj.
Hey, Im using 1.6.1 in zen 1.3.7. Google is having a fit with me as of late.
I guess I need to know how to get my sale prices to list in the feed along with non sale prices.
Also need to know how to control my product types. Feeder produces a very long product type name and I got a letter from google about it.
I guess I would like to have Feeder use the products top category as the "Type".
How can I do this? I dont see any way to change this in config.
Does anyone eles have these problems too?
Thanks ,
John
The script stores the categories in a array called product_type and then converts it into a string (implode) with commas separating each category. You can use a function called array_pop() to remove the first element in the array (the top level category) and store it into a variable that you can use as the product_type.Quote:
I guess I would like to have Feeder use the products top category as the "Type".
For example, before turning product_type into a string, do this:
$product_type = array_pop($product_type);
and then comment out the other lines of code concerning product_type.
To have these functions permanently added to the Google Base Feeder, or to make other configurable changes, please contact Numinix Technology directly and I can make these changes to be admin configurable by donation.
Numinix,
Thnx for the quick reply!
With the hard hit of feeder not function properly for me lately (hope thats why) I really cant afford a donation right now. Im gonna have to do this myself.
Can you please tell me which .php am I editing with the pop stuff ?
Also, How do i deal with the sale price not being used?
Thank you,
John
It supports special pricing. You would have to make conditional statements to define $price as the sales price as I had done for specials pricing. Otherwise, use products_price. This will involve linking the tables as shown in the products_query and extracting the relevent fields from the db. You can do it all by mimicking what I've done already and also by using PHPADMIN to see which fields in the database store the sales price. If there are expiry dates you'll also need to create conditional statements for that. The script has already defined the current date at the top.
Just got things working some what... until I try to run feed for products. This is the error that I get.. When I look at the "domain" file all of the products are there but when I try to view the file in zen admin I get nothing.
Google Base Feeder v.1.6.1 19.09.2007 16:37:59 started 2007/09/27 00:30:41
Feed file - /home/scrapboo/public_html/store/feed/sbdd_products.xml
Processing: Feed - Yes, Upload - No
1054 Unknown column 'p.products_condition' 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, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_condition, p.products_category 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.products_type = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_last_modified DESC]
running zen cart 1.3.7. Any suggestions?
Thanks
I am not exactly sure what's causing the problem but we are experiencing two issues after upgrading to 1.6.1
1. The script is appending products.xml to the output file name which end up rendering the output file name to not match the filename registered with Google.
2. Since upgrading to version 1.6.1 it's only generating about 70% of our product in the feed. I am not sure if this is related to the new parameter for figuring out what a product is versus download, document, etc. Reverting back to 1.5.3 solves the problem and all 10,583 products are included in the feed.
Both Yahoo product submit and Live product feed works fine and generate all active products.
I have temporarily downgraded to 1.5.3 so we can at least upload all products.
Thanks!
The documentation for 1.6.1 needs to be updated. But, you basically create three cron jobs for each product type and register each file with Google with the new name. You won't have any downtime since your old feed will still be active until you delete it.
help please,
I am getting this error after copying the all the sql patches to the sql and can't figure it out
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL default NULL after products_model' at line 1
in:
[) NULL default NULL after products_model;]
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.
I did not upload I did a cut and paste any help?????
Numinix, is you post addressing my issues of the script not generating all the products in the feed? I don't see how a cron job will solve my problem. The cron job will still upload only the file generated which is what I am having issues right.Quote:
Originally Posted by numinix
All the other script works far as far as generating the right amount of products but the google base is not working unless I revert back to 1.5.3 which is what I've done until such a time when my issue is resolved.
Thanks!
BlessIsaacola
You mentioned some other feed places.
I have looked at yahoo and at msn and cant find product feed info.Quote:
Both Yahoo product submit and Live product feed works fine and generate all active products.
Where can I find this and are there any fees associated?
Do you use the same feed generated for google base for the other two?
Thanks,
John
John,Quote:
Originally Posted by bumba000
All of my scripts are available for download in the Numinix Technology Zen Cart Downloads section.
You can view the readme.txt file to find out more information about the service or simply do a search for Windows Live Product Search.
Numinix,
Hey - Just installed Live Feed. Thanks. Got the config done after creating an account for Search Live. Over to tools and Live Product Search Feeder!
Get this error.
Can you tell me whats wrong here? It says the feed was created (and it was) so I tried to upload and that gave an error too.Quote:
Live Product Search Feeder v.1.02 19.08.2007 17:02 started 2007/09/28 23:13:39
Feed file - /home/john724/public_html/feed/lps.xml
Processing: Feed - Yes, Upload - No
Warning: chmod() [function.chmod]: Operation not permitted in /home/john724/public_html/lps.php on line 69
Warning: chmod() [function.chmod]: Operation not permitted in /home/john724/public_html/lps.php on line 177
Live Product Search File Complete In 1.021822 Seconds 628 Records
Headed over to productupload.live and uploaded it myself. . .
http error 500
Soooo Any Ideas?
Thanks, John
Delete your feed file and allow the script to create it. This goes for all of the feeders/exporters.
Okay, That took care of the that. Upload still gives me the [quote]
Live Product Search Feeder v.1.02 19.08.2007 17:02 started 2007/09/28 23:55:02
Feed file - /home/john724/public_html/Mfeed/lps.xml
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: ftp.productupload.live.com
Warning: ftp_connect() [function.ftp-connect]: php_network_getaddresses: getaddrinfo failed: Name or service not known
Upload failed...[/quote}
Visiting productupload.live and manually uploading give an error as well.
Says " Upload error!
HTTP Error, 500 occurred."
Thanks In Advance,
John
This seems to be a common error with the Windows Live Product Seach FTP, those who are having this issue can copy and paste all of the Google Base functions and rename them to match the WLPS Feeder.
Okay, I was still getting the same error doing this all by hand. Heres what I came up with.
First you have to create a catalog and set it up for FTP uploading. Have to give the Exact file name being used n all.
Have to make sure that the .xml file is registered and set up with Live before uploading via Admin or FTP.
Also. I stopped having my FTP access via Admin denied when I put "ftp.productupload.live.com" up as the LSP Server.
Think its the same as what is default for the mod but somehow replacing it made the problems and bold red letters go away. . . .
. . . Now those same angry screens are using words like " Successful " !:clap:
Thanks for the help,
John
It appears that in all the feeder generator (yahoo, msn and google), the script is trying to sanitize and clean up & to form an xhtml compliant & The conversion of & to & is actually creating a problem because the script is not smart enough to ignore situations where there is already a properly formed & instead of leaving it alone it turns and & into & amp; which not correct.
A good example of this situation is with categories where it's erroring because all our categories have been creating in Zen Cart admin properly using correct xhtml syntax for example Kids & Family is what we entered when creating that category which Zen Cart smartly formats and displays as Kids & Family on the shop side.
However, when the generator is creating the feed file, this becomes a problem because it converts the & in way that mess things up instead of just leaving that alone.
Any ideas on how to fix this short of changing everything that we already nicely formatted back to & so the script can convert it to & ?
Thanks!
Hi
How can i tell what version i have now?
Thank you
When you run the script it will say, or simply open googlefroogle.php in the root and check the version number at the beginning of the file.
Hi
Which of the file do I upload to google
I try the domain_products.xml and I got this error
domain_products
Processing bulk upload file
Bulk upload failure. 0 errors. None of these items are active.
I also have tiledepot.xml_products.xml and few new ones
I upgrade to 1.61 from 1.5.0 I run the sql 1.5.2 1.5.3 and googlefroogle.sql, no errors and all look ok.
Thank you[FONT=Times New Roman][/FONT]
Help.
I have downloaded the latest version . when I create the xml file and upload to Google base uk . I get the following error when it trys to process.
I am uploading the xml from the bulk uploade page rather than through FTP
"We did not understand the header (first) row of your file. Please make sure that you are using valid attribute names - <?xml version="1.0" encoding="UTF-8" ?>:
1
I have checked the settings on the file upload so it is looking for UTF-8 rather than Latin-1.
Any help appreciated
Jimbo
http://kiddykool.com
My new zen cart site is due to go live this weekend
Motti,Quote:
Originally Posted by motti
In the configuration rename your file to "tiledepot"
Login to Google Base and register a bulk file as tiledepot_products.xml. The feed file will append _products.xml to whatever name you choose. The other options for downloads and documents are only relevent if you have these product types on your site.
Hi all,
I´ve got a problem with my german store using Zen Cart 1.3.7 and Google Base Feeder 1.6.1 (update from 1.3.x). Google Base needs localized attributes, so "currency" needs to be "währung" for the german Google Base.
The new Feeder doesen´t create the correct special char "ä" and makes it
unreadeble and i get this "währung".
The special chars inside the description are complete lost and i get instead of
"Qualitätsprodukt" this "Qualittsprodukt" .
Any help appreciated
Stefan
Apologize my bad english
If anyone figure out the solution to the problem I described in post #482 above, please post your solution. Thanks!
Isaac,
you can add the following to the santizer function:
$str = str_replace('&amp', '&', $str);
This was discussed in an earlier post for another issue, but it would be relevent here as well.
V1.6.2 GOOGLE BASE FEEDER
1. Reverted back to zen_get_products_actual_price to support both specials and sale pricing;
2. Added ability to select top-level, bottom-level or full-path for product_type attribute;
3. Removed downloads and added music, downloads, free-shipping product types to _product.xml feed;
- feed=products and feed=documents;
This addresses both issues brought forward by BlessIsaacola which were the missing products that didn't fall into any of the feed types (music, free downloads) and the &amp; issue.
It also solves the issues of bumba000 and now allows you to select the product_type category level as well as use the sales price/specials price/regular price for each product.
Finally, this update also includes the ability to set a starting and stopping point for the feed. For example, if you set the feed to start at 50, it will start at the 50th acceptable product. What this means is, if you've set restrictions, it will start at the 50th product had there been no starting point set. So if you want one feed with 1000 products starting from the beginning, set starting point to default (0) and max-products to 1000. To create another feed with the next 1000 products, set the starting point to 1001 and leave max-products at 1000.
Other Numinix Technology News:
I've added a link to the top of the downloads section so that Zen Cart members can subscribe to updates to the downloads section. Now you'll never miss a new module or bug fix! Simply click on the large RSS icon in the category description, or use the link from the footer.
Numinix,Quote:
Originally Posted by numinix
I have not tested this but I wanted to thank you for this release especially for all the fixes and the new features introduced. I guess it's time for those of us who haven't contribute to start making contribution because this takes a lot of time.
I will report back after testing this release if I run into any issues.
Isaac,
You are very welcome :smile:
I just upgraded to 1.6.2 and the file being generated is much smaller than what was generated before.
The older file had 381689 lines and was 20MB.
The file generated now has only 121776 lines and is 6.3MB. It's missing a lot of items. Is this normal, perhaps a bug?
Another question, I only started using this mod starting with version 1.6, reading some of the previous posts, I think I deduct the mod use to generate a tab delimited text file before, is this correct? If so, what was the last version to use the tab delimited text files?
I couldn't get this mod generate a valid file for one of my sites so I've done a few minor edits to easypopulate to correspond with Google Base new attribute names and it works just fine.
I kind of like tab delimited files better, smaller size and easy to manipulate using a spreadsheet program.
Anything before v1.5 (1.3 to 1.4) uses tab delimited, v1.5 uses XML, and v1.6 creates multiple files based on product_type.
I'm not sure why your products are missing, I would need more details about why that product would be left out? How is it different from the ones that were included?
I have three websites, this mod worked on two of them, but on one of them Google gave the following error.
Error Bad data Line #6
We found a mismatched XML tag. - help
This is what line 6 has for this file:There are obviously broken tags on this line. I wasn't able to figure out why this happened. This was with v1.6.0 and 1.6.1.Code:<description>Sells fine solid gold jewelry.</description>r-jewelry.com/images/large/gld/r3248_LRG.jpg</g:image_link>
I just tried v1.6.2 and I no longer have the problem reported above; however, now the file generated is missing more than half the items.
I'll wait and see if anyone else has this issue or if it could be an issue on my server.
BTW, do you have a link where I can download the last version that created tab delimited files. Old links in this thread don't seem to work. I'd like to take a look at it and see if I can integrate some of its features to EasyPopulate.
You can find older versions in the Zen Cart Downloads section of this website.
You still haven't said what is different about the missing products. Perhaps they were inactive, some custom product type, etc.
The Google Base Feeder only supports the 5 product types found in Zen Cart by default. To add additional customized product types, you would add the following line to the SQL query for your feed type:
Where # is the product_type id.PHP Code:OR p.products_type = #
Thanks, I found and downloaded the older versions.
There's is nothing different about the missing products. They're all general products.
Actually, after opening the file generated I'm seeing it's missing the the closing tags as well, so this might indicate a time out, correct?
Yes, it's timing out then.
Some of our product names include a percent sign -- e.g., "100% Kona Coffee (1 Pound Bag)". That percent sign is important to our "branding" ... no blend of beans grown other than on the Kona Coast of the Big Island of Hawaii may use the "100% Kona Coffee" appellation.
But the percent sign (which shows up just fine on our Zen Cart pages) disappears from the XML file which we send to Google Base. BTW, the same "disappearing act" is true of the Windows Live Product Search file. We aren't using the Yahoo feeder, but I would guess that similar code is used there as well.
I tried to look at the code but I must admit that my eyes glazed over when I got to the "sanitizer" function.
Numinix, is there a chance that you could look at the Google / Live (and Yahoo!) code to see if the percent signs could be preserved in the output? Or, perhaps, is there a workaround that I should use in the original ZC product entries?
We really need those little percent sign devils to show up in the product search results.
TIA