Re: Google Base Feeder Support Thread
Sorry for not being specific.. I meant the googlefroogle.php at the store root. Not enough sleep the past few days! :(
Was this what you were referring to??
PHP Code:
$products_query = "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 " . TABLE_PRODUCTS . " WHERE "p.map_enabled != 1 ."p
Re: Google Base Feeder Support Thread
That is one of the areas. You would need to add it to the correct sql query that would be used depending on your google base feeder configuration settings.
The code you wrote though is wrong:
PHP Code:
AND p.map_enabled != 1
you also need to add p.map_enabled to the SELECT line.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
numinix
in the sql query you would want to put a WHERE clause when map_enabled != 1. //If it equals 1, it won't be included.
I entered the code you mentioned, still included the map_enabled products:
PHP Code:
if (GOOGLE_BASE_ASA == 'true') {
$products_query = "SELECT p.products_id, p.map_enabled, 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 " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
LEFT JOIN " . TABLE_SPECIALS . " s ON (s.products_id = p.products_id)
WHERE p.products_status = 1
AND p.products_type = 1
OR p.products_type = 4
OR p.products_type = 2
OR p.products_type = 5
AND p.product_is_call = 0
AND p.product_is_free = 0
AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
AND p.map_enabled != 1
ORDER BY p.products_last_modified DESC";
} else {
$products_query = "SELECT p.products_id, p.map_enabled, 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, 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
FROM " . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
LEFT JOIN " . TABLE_SPECIALS . " s ON (s.products_id = p.products_id)
WHERE p.products_status = 1
AND p.products_type = 1
OR p.products_type = 4
OR p.products_type = 2
OR p.products_type = 5
AND p.product_is_call = 0
AND p.product_is_free = 0
AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
AND p.map_enabled != 1
ORDER BY p.products_last_modified DESC";
For example, all of our Magnaflow products have the MAP pricing enabled, but your feeder is still including them:
Products: http://moesperformance.com/index.php...acturers_id=26
XML Feed: http://moesperformance.com/feed/domain_products.xml
I thank you for your help so far, hopefully it's just something simple. ;)
Re: Google Base Feeder Support Thread
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
numinix
try "= 0"
No Dice. :(
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
bekinky
Hi all - can someone tell me why I get the following message from the cron email:
Processing: Feed - Yes, Upload - No
I am assuming it is not being uploaded to Google and have no idea why. Can anyone shed any light on it? The ftp username and password are set the same as shown in the googlebase account.
Thanks
Paul
It did not upload the file. If you will separate the crons for create and then have one about 15 minutes later to upload it should work. Have one cron for create only and another for upload only.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
SuperDak
No Dice. :(
You need to set all your products that are not map_enabled to 0.
Then if map_enabled = 0, it will be included, otherwise it won't.
Or try <> 1
There isn't != for SQL
Re: Google Base Feeder Support Thread
Please can anyone help me with an install problem I'm having? I've searched and searched and searched for this with many different keywords but found nothing.
- I've uploaded all the files to my store directory as per instructions and checked that they are all in the proper locations.
- I set the permissions on the feed directory to 777
- I opened the file googlefroogle.sql in my text editor and copied the code to the clipboard.
- I went to Admin->Tools->Install SQL Patches and pasted the code into the Enter the query to be executed box and clicked send.
- I got the following error message in my browser:
Quote:
406 Not Acceptable
An appropriate representation of the requested resource /admin/sqlpatch.php could not be found on this server.
- I checked on my server and the file exists in the admin directory and...
- I've tried changing its permissions to 777
- I've tried re-uploading the file and again switching it to 777
But all I get is the 406 error message quoted above and I've run out of ideas.
I'm using Google Base Feeder v1.6.7 with Zen Cart 1.3.7 and Database Patch Level: 1.3.7
Database: MySQL 4.1.21-standard-log
HTTP Server: Apache/1.3.37 (Unix)
PHP Version: 4.4.4 (Zend: 1.3.0)
Server Host: green.sashbox.net
Server OS: Linux 2.4.21-37.0.1.ELsmp
Any help would be much appreciated,
Regards to all,
Michael.
Re: Google Base Feeder Support Thread
Hmm, do you get this error with all SQL patches? Perhaps you should make a new thread as this thread is for issues specific to the Google Base Feeder.
Re: Google Base Feeder Support Thread
hi,
this is specific to the google base feeder install.
the configuration entry shows up, but the entry to run the feed is not there.
this guy had the same issue
"7. Go to Admin->Tools>Google Froogle Feeder
This is not their to do? Its missing from the menu.
5. Go to Admin->Configuration->Google Froogle Configuration and setup all parameters;
This one is their tho? Didn't see any errors when I ran the SQL installation... ? What should i check"
he said he didnt have the files installed in the correct directories, what are the correct directories?
thanks
