Froogle Merchant Center merged into GoogleBase

getyourgameshere.com:

try it in this format:

US:Priority:7.99,CA:Global-Priority:9.99

Country:Type(nospaces):Price,Country:Type:Price,etc

My problem is I don't have set or flat shipping rates. My shipping rates depend entirely on weight and quantity so advertising a single shipping rate for my entire catalog through the admin is not accurate and therefore deceptive.

mafiasam:

My problem is I don't have set or flat shipping rates. My shipping rates depend entirely on weight and quantity so advertising a single shipping rate for my entire catalog through the admin is not accurate and therefore deceptive.

I think you can advertise it without price - not positive.. so it would look something like this:

US:Priority, CA:Global-Express

something like that. I put mine as the prices above but those are a little bit higher than what most people normally get charged.. reason was the same thing as yours. Didn't want to be deceptive so I figured if I put extra on Froogle and someone came to the site to purchase, they would be happy to see shipping prices were a little lower :)

Plus, a lot of people don't see the actual page for it - they click the link and it leads straight to the site

getyourgameshere.com:

bluehost may have phpftp functions disabled.. may want to ask them about it

Yep that's the problem. In fact, bluehost doesn't support phpftp. sigh...what to do?

Does anyone know if there is a limitation to how many products googlefroogle can process. The mod is now timing our because we have more than 10k products. I looked in the error log and it bailed because is exceeded 60 seconds. I changed that to 120 seconds, it still did not complete the process but no error.

Any ideas?

Thanks!

Isaacola!
I add @set_time_limit(0); and do some optimization. Try this version.

v 1.2.13 25.11.2006 17:51

a_berezin:

Isaacola!
I add @set_time_limit(0); and do some optimization. Try this version.

v 1.2.13 25.11.2006 17:51

Thanks for the update. It did not fix my problem. The error message I received is pasted below: [Sat Nov 25 12:05:23 2006] [error] PHP Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 20972449 bytes) in /****/googlefroogle.php on line 131. I am going to change php.ini to memory_limit = 30M and see if that works.

Geez, I used to have this set at 8M, then changed it to 20M for this mod when I first got the error and now is looking for more. This thing is memory hungry :)

How come this needs so much memory and Easy Populate generates the googlebase file just fine?

Thanks!

Andrew, I have exhausted my limited knowledge and I still cannot get this complete the process. The file hangs everytime before completing the creation of the frogle text file. The only thing that changed today is our product offering went from 5525 to 11,117. Any ideas?

Thanks!

BlessIsaacola!
I add some statistic to googlefroogle.php. You can see something interesting:

Execution time:
Function			Execution time	Percent
zen_froogle_fwrite		0.023367	0.52%
zen_froogle_sanita		0.061071	1.35%
zen_froogle_category_tree	0.128599	2.85%
$products->mySQL		0.082445	1.83%
zen_get_tax_rate(cached)	0.023425	0.48%
zen_get_products_actual_price	3.128807	69.35%
zen_add_tax			0.009057	0.2%
$currencies->value		0.007719	0.17%
zen_get_info_page		0.598652	11.84%
zen_href_link			0.026346	0.52%
main_product_image.php		0.366336	8.12%
zen_froogle_expiration_date	0.006011	0.13%
zen_froogle_get_category	0.019781	0.44%
Other				0.077633	1.72%
Total				4.511542	100%
Froogle File Complete In 4.511542 Seconds 116 Records

The basic time is spent by the following standard zen functions:
zen_get_products_actual_price - 69.35% (!!!)
zen_get_info_page - 11.84%
main_product_image.php - 8.12%

BlessIsaacola!

a_berezin:

The basic time is spent by the following standard zen functions:
zen_get_products_actual_price - 69.35% (!!!)
zen_get_info_page - 11.84%
main_product_image.php - 8.12%

1. Use products_price_sorter field instead of function zen_get_products_actual_price;
2. Use selected type_handler field instead of function zen_get_info_page;
   Test this one.

a_berezin:

BlessIsaacola!

1. Use products_price_sorter field instead of function zen_get_products_actual_price;
2. Use selected type_handler field instead of function zen_get_info_page;
   Test this one.

It did not work. I got the following error:

1054 Unknown column 'databaseDELETED.m.products_id' in 'on clause'
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, 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 products p LEFT JOIN manufacturers m USING (manufacturers_id) LEFT JOIN products_description pd USING (products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_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]

Please note that for security reasons, I have deleted the database name from the first line of the error.

Thanks!

OK! I replace USING by ON in sql. Test this one.
P.S. May be we goto e-mail talking?

a_berezin:

OK! I replace USING by ON in sql. Test this one.
P.S. May be we goto e-mail talking?

I tried it again and there was no error on my screen but this error was generated in the server log: [Mon Nov 27 10:26:32 2006] [error] PHP Fatal error: Allowed memory size of 31457280 bytes exhausted (tried to allocate 20972893 bytes) in /folderNAME/googlefroogle.php on line 227 I used to have max memory limit for script set to 10MB and I have adjusted to 30MB for this mod and it is still not enough.

Thanks!

Change @define('GOOGLE_FROOGLE_OUTPUT_BUFFER_MAXSIZE', 510241024); at line 45.

a_berezin:

Change @define('GOOGLE_FROOGLE_OUTPUT_BUFFER_MAXSIZE', 510241024); at line 45.

What should I change line 45 to?

Thanks!

!!!!!!!!!!!
Ok, I understand you :-(, use this file

a_berezin:

!!!!!!!!!!!
Ok, I understand you :-(, use this file

Great Job Andrew!!!

This version worked like a charm. Pasted below are the statistics:
Execution time:
Function Execution time Percent
zen_froogle_fwrite 3.548495 4.7%
zen_froogle_sanita 14.533300 19.24%
zen_froogle_category_tree 0.537313 0.71%
$products->mySQL 18.365177 24.31%
zen_get_tax_rate(cached) 0.323506 0.43%
zen_get_products_actual_price 0.539358 0.71%
zen_add_tax 1.002850 1.33%
$currencies->value 1.418785 1.88%
zen_get_info_page 0.310684 0.41%
zen_href_link 3.543491 4.69%
zen_froogle_image_url 14.736084 19.51%
zen_froogle_expiration_date 1.161325 1.54%
zen_froogle_get_category 5.183879 6.86%
Other 10.340200 13.69%
Total 75.544448 100%
Froogle File Complete In 75.544448 Seconds 11110 Records

Andrew, if I want to use the model as "id" instead of the product id do I changephp @define('GOOGLE_FROOGLE_OFFER_ID', 'id'); // id/model/false to ```php
@define('GOOGLE_FROOGLE_OFFER_ID', 'model'); // id/model/false

Thanks!

Wow! We have won!!! "We are the Champion"!!! Zen-cart is a magic! :clap:

If you install update_1_2_9.sql, then you can select OFFER_ID id/model/false in admin GoogleFroogle Configuration menu.

Okay! I hate to spoil our party :( There is a problem with the .txt that is generated. Although the completed file is about 8.3MB which will lead you to believe that everything is there. There is only one row of record. Instead of each product being on a separate, everything is on one row. It's like there's no tab to go to the next or something.

We just need the file generated to be on separate row (each row representing a record and we will be good).

I don't know what's causing this problem.

Thanks!

It not a problem! I know about that.

Download last version from my site.