[PAID] Google Merchant Static Feed
Re: [PAID] Google Merchant Static Feed
Martin, any quick way to modify code so that shipping = 0 for all products, instead of calculating the shipping? Thanks, Bob
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: [PAID] Google Merchant Static Feed
Took a little longer than planned thanks to pesky customers, etc...chamster wrote:Martin, any quick way to modify code so that shipping = 0 for all products, instead of calculating the shipping? Thanks, Bob
![Wink ;)](./images/smilies/icon_e_wink.gif)
If you want to set all shipping so it's free...
Open: includes/classes/class.froogle.php
Find:
Code: Select all
if(isset($row['prodfreeshipping']) && $row['prodfreeshipping'] == 1){
Code: Select all
$row['prodfreeshipping'] = 1;
Re: [PAID] Google Merchant Static Feed
Any orders >$75 are free shipping, so I altered the code in froogle.php:
if($price_unformatted > 75)
{
$row['prodfreeshipping'] = 1;
}
Seems to work.
Now what I want to do is exclude certain categories of products from this rule, because some large items don't qualify for free shipping.
So I can identify these excluded categories by the value in isc_categories.catparentlist. Then I could compare the value from isc_categories.catparentlist with a string of characters to see determine whether the item is in the excluded category. If so, set $row['prodfreeshipping'] = 0;.
But I can't figure out how to include isc_categories.catparentlist in the query without breaking the code.
An ideas?
I hope this makes sense. It's getting really late![Wink ;-)](./images/smilies/icon_e_wink.gif)
if($price_unformatted > 75)
{
$row['prodfreeshipping'] = 1;
}
Seems to work.
Now what I want to do is exclude certain categories of products from this rule, because some large items don't qualify for free shipping.
So I can identify these excluded categories by the value in isc_categories.catparentlist. Then I could compare the value from isc_categories.catparentlist with a string of characters to see determine whether the item is in the excluded category. If so, set $row['prodfreeshipping'] = 0;.
But I can't figure out how to include isc_categories.catparentlist in the query without breaking the code.
An ideas?
I hope this makes sense. It's getting really late
![Wink ;-)](./images/smilies/icon_e_wink.gif)
Re: [PAID] Google Merchant Static Feed
Hi Martin,
A couple questions:
1. I keep getting this error:
Undefined variable: fixed_price in /home/xxx/public_html/store/includes/classes/class.froogle.php at 1144
How to fix? The store is on fixed price shipping US$9.99, which has been defined in the GM account. Do I need to set it somewhere in your set of file?
2. For those product images can I get _zoom size instead of the _std size?
Cheers,
Marc
A couple questions:
1. I keep getting this error:
Undefined variable: fixed_price in /home/xxx/public_html/store/includes/classes/class.froogle.php at 1144
How to fix? The store is on fixed price shipping US$9.99, which has been defined in the GM account. Do I need to set it somewhere in your set of file?
2. For those product images can I get _zoom size instead of the _std size?
Cheers,
Marc
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: [PAID] Google Merchant Static Feed
Not sure when this was fixed/resolved but my current version has the required key_exists check to stop that error happening... It can be safely ignored either way.Chow wrote:1. I keep getting this error:
Undefined variable: fixed_price in /home/xxx/public_html/store/includes/classes/class.froogle.php at 1144
How to fix? The store is on fixed price shipping US$9.99, which has been defined in the GM account. Do I need to set it somewhere in your set of file?
Search and replace: pi.imagefilestd with pi.imagefilezoom2. For those product images can I get _zoom size instead of the _std size?
...this will only work with ISC 5.5.4 versions or later though...
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: [PAID] Google Merchant Static Feed
1.5.3 has been released...
Snailsolutions store as per normal
- update froogle.php
- upload the new class.progressbar.php to the modules\custom directory
- turn OFF verbose mode in the Google Merchant - add-on settings
- run froogle.php as normal but with the variable ?p=bar tagged on (ie: froogle.php?p=bar )
The progress bar isn't particularly fancy but it will tell you how far along your feed is if it's incomplete and allow you to determine when you've finally finished it properly.
One are where this is particularly useful is when your google merchant dashboard is indicating that things are due to expire.. If that's the case your feed is not completing properly and you need to do a manual update. When you do, pay attention to the number of times you need to re-run the feed and over what timeframe to get it to generate properly. With that information update your CRON settings to ensure that the feed will complete properly.
Note: Always remember to check your settings if/when you significantly change the stores product volumes..
Snailsolutions store as per normal
- Version 1.5.3 : Revision 546
- ADDED File: \modules\custom\class.progressbar.php
- UPDATED File: \froogle.php
- ADDED: Progress bar display using froogle.php?p=bar to activate.
Allows easy reference to see how much is left to generate - ADDED: Test for incomplete build(tmp) file. If over 2 weeks old it will now kill the file and force a new build.
This stops feeds wasting resources to build when a fresh start would be smarter move. - ADDED: Progress bar will correctly identify amount completed in an incomplete file and display progress accordingly
- FIXED: US taxonomy may be causing some issues when being read into the DB taxonomy file reordered so new index items are imported last.
- FIXED: Screen out categories where parent cats are not accessible/visible
- FIXED: Remove Undefined index error when no shipping option return from quote system
- update froogle.php
- upload the new class.progressbar.php to the modules\custom directory
- turn OFF verbose mode in the Google Merchant - add-on settings
- run froogle.php as normal but with the variable ?p=bar tagged on (ie: froogle.php?p=bar )
The progress bar isn't particularly fancy but it will tell you how far along your feed is if it's incomplete and allow you to determine when you've finally finished it properly.
One are where this is particularly useful is when your google merchant dashboard is indicating that things are due to expire.. If that's the case your feed is not completing properly and you need to do a manual update. When you do, pay attention to the number of times you need to re-run the feed and over what timeframe to get it to generate properly. With that information update your CRON settings to ensure that the feed will complete properly.
Note: Always remember to check your settings if/when you significantly change the stores product volumes..
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: [PAID] Google Merchant Static Feed
Just to note... there is a quirk with the way the progress bar works (or doesn't) when caching or page compression is turned on so you may find you get a minute or so with nothing displayed and then the progress shows up for 5 minutes for the page times out...
Unfortunately I can't test it much further to resolve this due to a lack of test servers to play with so consider it a "feature"... Sorry..
Unfortunately I can't test it much further to resolve this due to a lack of test servers to play with so consider it a "feature"... Sorry..
Re: [PAID] Google Merchant Static Feed
I tried to download the new version from my account in your store but couldn't "This file can no longer be downloaded as it has expired" I purchased in Nov 2011.
-
- Site Admin
- Posts: 1854
- Joined: Wed Jun 17, 2009 6:30 pm
- Location: South Yorkshire UK
- Contact:
Re: [PAID] Google Merchant Static Feed
Just to note that I'm aware the taxonomy needs an update and I've downloaded the latest versions from Google Merchant with a view to getting this done in the next 10 days.
-
- Posts: 1
- Joined: Mon Aug 06, 2012 8:49 pm
Re: [PAID] Google Merchant Static Feed
Hello i have recently updated to the latest version but getting an error from google on <missing google product category> . how to fix this?