Google Base New Fields

[gfool]

Does someone have a quick function to remove all the products from hiddent categories?

I'm thinking of using something similar to the google tree but for my hidden categories making it output "POTATO" or something so google will reject. Is there a nicer way?

[ridexbuilder]

Hi all , I need a little assistance. I have one site where this feed works and another where it does not.

site that works = http://www.lodgeroomstore.com/sales/catalog/fm-feeds/general-uk-product-search.txt

site that does not = http://www.masonicbookstore.co.uk/catalog/fm-feeds/general-uk-product-search.txt

I cant figure why second site will not work any ideas ?

Could it be that you have a lot of crap in the product descriptions? Example:

.ReadMsgBody{              width:100%;          }          .ExternalClass{

or that items are lacking a description. You will need to read the error messages that Google is giving you.

[Pr0ject]

Okay worked out great. i used the file "Feedmachine-admin-ej-25.3" replaced the files and deleted the config directory contents and uploaded the config contents from the "Feedmachine-admin-ej-25.3" file.

Anyone know how or POINT ME IN THE RIGHT DIRECTION for FREE SHIPPING?
so that I can add a modifier that will add a free shipping column to all products that have a 0 weight?

Also is anyone having luck with the auto upload?
I get the below when I try to do the ftp upload.

"
Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Operation now in progress (115) in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: Type set to A. in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Operation now in progress (115) in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (74,125,54,213,4,176) in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: PORT command successful. in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: Can't build data connection: Connection timed out. in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371

Warning: ftp_put() [function.ftp-put]: Entering Passive Mode (74,125,54,213,4,72) in /home/oshkosh/public_html/ADMIN6789123/feedmachine_auto.php on line 371"

[niallb]

On my sites to show FREE SHIPPING on Google Products (Im in the UK), create a 'Shipping' column and enter 'GB::Royal Mail::0.00', or US equiv.

[Pr0ject]

Do you have that in your config file in the code form??

On my sites to show FREE SHIPPING on Google Products (Im in the UK), create a 'Shipping' column and enter 'GB::Royal Mail::0.00', or US equiv.

[niallb]

Do you have that in your config file in the code form??

No I add this column manually after downloading the feed onto an excel sheet

[Pr0ject]

Here is the code I used in "google-product-search-ej-us-general.php"


" 'availability' => array('output' => 'IS_IN_STOCK',
'type' => 'KEYWORD'
),
'shipping' => array('output' => 'FM_RS_free_shipping',
'type' => 'FUNCTION'
)
),
"

and then i added the following function,

"
function FM_RS_free_shipping($product) {
$output_field_category = $product['products_weight'];
if ($output_field_category =='0.000'){
return (($output_field_category =! 0) ? 'US::ECONOMY:0.00' : '');
}
}
"

[ridexbuilder]

So now your file should be called "google-product-search-pj-us-general.php" to reflect that Pr0ject has modified it.
I don't want the blame.

[Pr0ject]

Okay so I just added the individual ship from the bug tracker, which is working great but now I want to include the individual shipping into the feed, anyone know how I can additional tables to the feedmachine?

[Pr0ject]

So this is what I did, I hope this is working but I will check back
Starting with line 322
"while( true ) {
++$counter;
$master_query = tep_db_query('SELECT ' . ( $count_run ? 'COUNT(*) as count' : 's.*, cd.*, c.*, ptc.*, mi.*, m.*, pd.*, p.*, ps.products_ship_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price' ) . '
FROM ' . TABLE_PRODUCTS . ' p
LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . ' pd ON p.products_id = pd.products_id
LEFT JOIN ' . TABLE_MANUFACTURERS . ' m ON p.manufacturers_id = m.manufacturers_id
LEFT JOIN ' . TABLE_MANUFACTURERS_INFO . ' mi ON m.manufacturers_id = mi.manufacturers_id AND pd.language_id = mi.languages_id
LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' ptc ON pd.products_id = ptc.products_id
LEFT JOIN ' . TABLE_SPECIALS . ' s ON ptc.products_id = s.products_id
LEFT JOIN ' . TABLE_CATEGORIES . ' c ON ptc.categories_id = c.categories_id
LEFT JOIN ' . TABLE_CATEGORIES_DESCRIPTION . ' cd ON c.categories_id = cd.categories_id AND pd.language_id = cd.language_id
LEFT JOIN ' . TABLE_PRODUCTS_SHIPPING . ' ps ON ps.products_id = p.products_id
WHERE pd.language_id IN(' . $languages_list . ')
AND p.products_status = 1
ORDER BY p.products_id' . ( $count > 0 ? '
LIMIT ' . (($counter-1)*$cycle_length) . ', ' . $cycle_length : '' ));"
"


ps.products_ship_price,* ABOVE is CRUCIAL,
I tried using ps.*, selecting all from the products_shipping table but
I think because the column in products and column in products_shipping
are both labeled products_id it confuses and the resulting feed only has a limited number of products.
should the table column in products_shipping be renamed something else to prevent future problems?


THEN

in
google-product-search-ej-us-general.php
I changed the function that I added above
to
"
function FM_RS_free_shipping($product) {
$output_field_category = $product['products_ship_price'];
if ($output_field_category =='0'){
return (($output_field_category =! 0) ? 'US::ECONOMY:0.00' : '');
}
}
"