Froogle Merchant Center merged into GoogleBase

Google Froogle Feeder v1.3.4
available for testing at: http://www.numinix.com/zen-cart/goog...eder_1.3.4.zip

Updates:
added manufacturer's product number
cleaned up the product_type/label issue

Notes:

If there are any problems with the mpn, I will be happy to give support as well as help to add any further attributes which are ALREADY defined in the SQL database. I don't think there is anything else to add without creating additional fields in the product listing.

Product_types still only displays the categories (i.e. category sub-category sub-sub-category; the more sub categories you have the longer the product_type will be) and not a custom Google product_type which would require an additional field in the admin - categories/products. All I've actually done here is completely removed the "label", which Google no longer uses, and setup product_type to display what label used to display.

In terms of support, I cannot offer any support other than for the two changes I've made, which are very minor. Anything prior to these changes is beyond my capacity and should be directed to the original author a_berezin.

I will upload this release to the downloads sections once enough people have verified my changes are acceptable. The issue for special prices, as stated by the above poster, is still a concern and will hopefully be addressed in the future. I don't have enough understanding to take this on myself and don't even know where in the db special prices are stored.

Quote:

---

Originally Posted by mfreund

Also when it creates the file it creates as user and group "nobody"

---

IIRC, you need to upload an empty feed file (set it to '777' permissions and rename to your feed file name, of course) using FTP when you install the mod - then your server user/group will be assigned to the feed file instead of 'nobody'.

I assume that's why the empty feed file is included in the mod (or used to be).

Quote:

---

Originally Posted by mfreund

I posted something today about the prices not changing when you use the salemaker module. When you make a sale and generate the feed the price in the feed still stays as your base price. Also when it creates the file it creates as user and group "nobody"



What happened to this module.....I really need it to work as many others also do I am sure. Any ideas?

---

I've taken a look at how specials are stored in the database and it probably wouldn't be too hard to do a conditional statement that if a special price exists, display special price instead of price. The only problem is that zen-cart doesn't delete the special prices from the database. It simply deactivates them by checking to see if the expiry date has been reached. Thus it would require more conditional statements for the expiry as well.

Google Froogle Feeder v1.3.5

Updates:

Now includes specials. I did this by comparing the expiry date to today's date. I'm new to PHP but it's my understanding that the date function is based on the server time?

The update can be downloaded from:

http://www.numinix.com/zen-cart/google_froogle_feeder_1.3.5.zip

When I run the feed it says that all my products are in the file but when I view it there is nothing in there other then the file header information. Any ideas?

Thanks

The tabbed headings aren't stored in the db which means that it's not pulling the values out of ur database.

Note: I've setup a new support thread for any new issues not previously covered in this thread which is getting too large to read:

http://www.zen-cart.com/forum/showthread.php?t=67850

Post any bugs with the specials prices in that thread please.

Here is what it says when I run the file :

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/06/08 20:22:16
Feed file - /home/wccomput/public_html/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 0.297386 Seconds 1647 Records

So where would I start to troubleshoot why it says its pulling the data but really isn't?

Thanks

Quote:

---

Originally Posted by wccomp

Here is what it says when I run the file :

Froogle Data Feeder v.1.3.3 07.02.2007 20:45 started 2007/06/08 20:22:16
Feed file - /home/wccomput/public_html/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 0.297386 Seconds 1647 Records

So where would I start to troubleshoot why it says its pulling the data but really isn't?

Thanks

---

After testing we found that the problem was Zen Manager which stores products differently than the default Zen Cart. See my thread for the latest version v1.3.6 to further test the timeout issue.

[FONT=Times New Roman]Hi[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I did install it and keep getting errors [/FONT]
[FONT=Times New Roman]1062 Duplicate entry 'GOOGLE_BASE_CATEGORIES' for key 2
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Included Categories', 'GOOGLE_BASE_CATEGORIES', '', 'Enter category names separated by commas
(i.e. computers,software,televisions)
Leave blank to allow all categories', @configuration_group_id, 30, NOW(), NULL, NULL);]
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.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]What am I doing wrong , I did run the sql and the update sql, I change permeation to 777[/FONT]
[FONT=Times New Roman]For the feed folder and for the 3 files in it[/FONT]
[FONT=Times New Roman]It is all done on my store demo, after I figure it out, I will install it on my site[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Please advice[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]

It looks like I have previously installed Froogle module and also Google Froogle module. Do these two modules still work? Or should I switch to this new Google Base Feeder module?