3176 replies to this topic

[FlyingMonkey]

That's a really nice site. where's your froogle data stored? and do you have several examples of missing products?

[Marg]

Thanks... I must be going crazy.....
I was sure I was looking through product numbers where the product was showing up and not in the froogle list, now I can't find a single one. The skipped numbers have no product....
Ignore me....... please....
Marg
Sorry for the trouble..
thank for helping, FM

[FlyingMonkey]

Quick Note: For All Users. By default the file generated is froogle.txt, this needs to be changed to generally your username(from froogle).txt

For instance, if your username was applestore then your txt file would be applestore.txt This change applies to both $OutFile and $destination_file

[lparks]

Can I use this on a Windows box? I see the cron is used to FTP to the froogle server. Should I just setup a scheduled task to perform this function? Or do you already have that built in?

[FlyingMonkey]

lparks, on Apr 6 2004, 05:49 PM, said:

Can I use this on a Windows box? I see the cron is used to FTP to the froogle server. Should I just setup a scheduled task to perform this function? Or do you already have that built in?

The cron entry, is only used to automate the monthly upload and is not required. you can set up a scheduled task if you prefer on a windows server.

[asasson]

I was wondering about the cron entry,
my webhosting allows me to schedual a cron entry but I don't understand what do I need to change in the froogle.php file?
I don't get a number for the cron job or anything like that...
what should come instead of the line:
0 4 * * 3 /usr/bin/php -q /home/<unix route to your file>/admin/froogle.php?
what do they mean by unix route?
what is the 0 4 * * 3?

Thanks in advance...
Ami

[stoopies]

asasson, on Apr 6 2004, 11:12 PM, said:

0 4 * * 3 /usr/bin/php -q /home/<unix route to your file>/admin/froogle.php?
what do they mean by unix route?
what is the 0 4 * * 3?

I am totally clueless about cron jobs. After spending hours of trial and error, I had to email my webhost provider for the answer to this. Here is what I put into my cron job, and it works perfectly! All that I needed to do was drop off the numbers at the beginning. Of course your <unix route> will be different, so just put yours in.

/usr/local/bin/php -q /home/<unix route>/admin/froogle.php

Good luck!
James

Edited by stoopies, 06 April 2004, 23:28.

[FlyingMonkey]

The numbers are used to schedule when and how often the ftp upload should occur. Glad to hear you guys got it to work.

[asasson]

James,
Thank you very much for your help.
I contacted my webhost just as you did and they first need to approve the cron job.
my other question though what do the number 0 4 * * 3 mean specifically?
does it mean feed the file every 4 days or every 3 weeks?
also, do I need to specify the cron job number? if so are those the numbers?
thank you again,
Amitai

[FlyingMonkey]

asasson, on Apr 7 2004, 04:07 AM, said:

James,
Thank you very much for your help.
I contacted my webhost just as you did and they first need to approve the cron job.
my other question though what do the number 0 4 * * 3 mean specifically?
does it mean feed the file every 4 days or every 3 weeks?
also, do I need to specify the cron job number? if so are those the numbers?
thank you again,
Amitai

hmm.... i didn't write the original cron entry. but i believe it actually uploads weekly on wednesday at 4am.

[Proetorian]

The cron job is setup as follows:

Minute Hour Day Month Weekday Command

e.g.

0 4 * * 3 /usr/bin/php -q /home/<unix route to your file>/admin/froogle.php

where,

The cron command is: /usr/bin/php -q /home/<unix route to your file>/admin/froogle.php

and the cron is scheduled to run at 04:00 (4:00 am) every third weekday (weekly).

[jmoore04]

Has anyone got this to work with the SaleMaker contrib?

It would be great to be able to use it with SaleMaker, since I am running full category to full store sales everyday. Several days a month I offer 50% discounts on mostly everything in the store. Setting individual sale prices is out of the question with the vast amount of products I offer.

[jcall]

I would think that it would work - - what problems, if any, have you seen?

[jmoore04]

Basically, it's only getting the retail price instead of the sales prices. The SaleMaker contribute uses a different table other than the one predefined in froggle.php. I am going to play around with it and see what needs to be changed in order for it to work.

[MAKAVELI1980]

jmoore04, on Apr 13 2004, 01:09 PM, said:

Basically, it's only getting the retail price instead of the sales prices. The SaleMaker contribute uses a different table other than the one predefined in froggle.php. I am going to play around with it and see what needs to be changed in order for it to work.

I'm looking for a fix for this as well...anyone know how we can fix this so the feed send to froogle has the salemaker mark down prices and not the retail prices??

Thank you

[jmoore04]

Ok, I have a little problem. I went a head and manually set up all my specials through OSC Specials page. I turned off SaleMaker, and yet when I run Froggle.php, it still doesn't replace my retail prices with my special prices. Any ideas?

Edited by jmoore04, 14 April 2004, 17:20.

[jmoore04]

That solved my Specials problem with the manual special entries that I made with OSC's built in Special's feature. Now if we could figure out how to get it to do the SaleMaker specials. Unless there is another easy way to change the specials price for over 500 products that works directly with OSC.

[jmoore04]

Another quick question, would it be better to use your product's large or thumbnail images with froogle?

[jmoore04]

I have another quick question, what is the normal waiting period for Froogle to send your new account information to you?

[FlyingMonkey]

edtiger, on Apr 15 2004, 02:25 AM, said:

update: if I alter all instances of

Quote

$already_sent[$row->name] = 1;

to

$already_sent[$row->name] == 1;

It appears to fix the problem and all rows are listed including the second row.

edtiger: I had it take out the second row, because when i wrote it. It was duplicating my second row which was really weird. This was a problem probably with only my database. I'll check it on the stores I've installed for clients.

jmoore04: In terms of the Sale Maker, I don't have that one installed. But if someone tells me where it pulls the special price from, I'll try to make a hack.

There are two minor bugs, I noticed. Nothing that will really affect anyone, so I won't post a fix until I release an updated version.