Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

The Feedmachine Solution


lech

Recommended Posts

getting an error message

Fatal error: Cannot redeclare fm_rs_product_id_us_en() (previously declared in admin\fm-feed-configs\google-product-search-us-en.php:76) in admin\fm-feed-configs\google-product-search-us-en.php~ on line 74

 

i've tried all three of the latest ones, each giving the same error message.

 

the feed is for one country

Edited by puddlec

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

Link to comment
Share on other sites

ok worked out the first error, i just had to remove the google-product-search-us-en.php~ file

now i just need to work out how to fix the in stock / out of stock, as that is saying everything is out of stock, even through it is in stock (as i don't set the stock levels everything is set to 0), and it only outputs what is set to active anyway

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

Link to comment
Share on other sites

getting an error message

Fatal error: Cannot redeclare fm_rs_product_id_us_en() (previously declared in admin\fm-feed-configs\google-product-search-us-en.php:76) in admin\fm-feed-configs\google-product-search-us-en.php~ on line 74

 

i've tried all three of the latest ones, each giving the same error message.

 

the feed is for one country

 

 

Copy only one of these files: google-product-search-us-en.php

 

Dont't copy: google-product-search-us-en.php~

 

(its a backup file shouldnt be in the package, sorry)

 

Then if you need more than one feed, follow the instructions what has to be changed in each configuration file.

 

regards

raiwa

Link to comment
Share on other sites

ok worked out the first error, i just had to remove the google-product-search-us-en.php~ file

now i just need to work out how to fix the in stock / out of stock, as that is saying everything is out of stock, even through it is in stock (as i don't set the stock levels everything is set to 0), and it only outputs what is set to active anyway

 

in google-product-search-us-en.php, Change:

 


								   'availability'		=>   array('output' => 'IS_IN_STOCK',
																 'type' => 'KEYWORD'
																)

 

To:

 

								   'availability'		=>   array('output' => 'in stock',
																 'type' => 'VALUE'
																)

 

 

like this it will show always "in stock" to google, even you declare stock=0 in your shop

 

regards

raiwa

Link to comment
Share on other sites

 

in google-product-search-us-en.php, Change:

 


								   'availability'		=>   array('output' => 'IS_IN_STOCK',
																 'type' => 'KEYWORD'
																)

 

To:

 

								   'availability'		=>   array('output' => 'in stock',
																 'type' => 'VALUE'
																)

 

 

like this it will show always "in stock" to google, even you declare stock=0 in your shop

 

regards

raiwa

made that change, but did it slightly differently i just changed

$output_field_value = $product['products_quantity'] > 0 ? 'in stock' : 'out of stock';

to

$output_field_value = 'in stock';

Phoenix support now at https://phoenixcart.org/forum/
App created for phoenix
TinyMCE editor for admin

 

Link to comment
Share on other sites

made that change, but did it slightly differently i just changed

$output_field_value = $product['products_quantity'] > 0 ? 'in stock' : 'out of stock';

to

$output_field_value = 'in stock';

 

 

This works too, the only problem is that this changes the "IS_IN_STOCK" Keyword-function and if you add the stock feature in lets say 2-3 years to your shop, maybe you will not remember that you changed this in feedmachine.php.

Not to say if someone else copys this modified file.

 

For me its cleaner and more correct to change the code in google-product-search-us-en.php.

 

regards

raiwa

Link to comment
Share on other sites

 

 

Hello,

 

I'm using this contribution with OSC2.2rc2a., but in any case this is a configuration file, not the feedmachine contribution. So if the feedmachine contribution works with OSC 2.3.x, the configuration file will too. (At least I think so)

I think that the feedmachine contribution will need a modification in the file: catalog/admin/includes/boxes/feedmachine.php to work with OSC 2.3.x

 

regards

raiwa

 

Thank you for your answer,

 

Will there be a version for 2.3.1 soon?

 

Cheers

Link to comment
Share on other sites

I'm running a 2.2 store and feedmachine with the changes as recommended for google, when i upload the feed I get errors on the whole catalog on the 'availability' which is highlighted red in the data feed (nothing shown in the box to the right). any ideas how to force 'in stock' on all items in the feed.

 

Thanks in advance

 

Link to comment
Share on other sites

I'm running a 2.2 store and feedmachine with the changes as recommended for google, when i upload the feed I get errors on the whole catalog on the 'availability' which is highlighted red in the data feed (nothing shown in the box to the right). any ideas how to force 'in stock' on all items in the feed.

 

Thanks in advance

 

 

 

Hello,

 

read my post #205 in this topic and apply the suggested change to your feed configuration.

 

regards

raiwa

Link to comment
Share on other sites

Hi Raiwa,

 

i've made the changes but it looks like the 'availability' column is not being outputted when the file is generated,

 

i get this as my first line (can't see availability as a field) :

link title description expiration_date price image_link genre id weight manufacturer mpn payment_accepted product_type currency location tax quantity brand condition age_range made_in

 

have i missed something?

Thanks

Tony

Link to comment
Share on other sites

Hi Raiwa,

 

i've made the changes but it looks like the 'availability' column is not being outputted when the file is generated,

 

i get this as my first line (can't see availability as a field) :

link title description expiration_date price image_link genre id weight manufacturer mpn payment_accepted product_type currency location tax quantity brand condition age_range made_in

 

have i missed something?

Thanks

Tony

 

Hello,

 

seems you don't use my contribution: http://addons.oscommerce.com/info/7130

 

which configuration file are you using?

 

regards

raiwa

Link to comment
Share on other sites

I've used the one from your contribution, looks like this :

 

 

<?php

 

/**

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*/

 

/*

Google Product feed configuration for The Feedmachine Solution

based on google-simple.php by: Lech Madrzyk

----------------------------

This configuration is complient with the Google-Feed specifications from 22nd of september 2011.

It has to be used together with the modified feedmachine.php file which includes the 'IS_IN_STOCK' Keyword definition.

*/

 

$feed_config = array('name' => 'Google Product Search',

'authors' => 'Musicstreet',

'filename' => 'musicstreet.txt',

'schema_version' => '2.0',

'fields' => array('id' => array('output' => 'FM_RS_product_id_us_en',

'type' => 'FUNCTION'

),

'title' => array('output' => 'products_name',

'type' => 'DB',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'price' => array('output' => 'FINAL_PRICE_WITH_TAX',

'type' => 'KEYWORD',

),

'brand' => array('output' => 'manufacturers_name',

'type' => 'DB',

'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF')

),

'mpn' => array('output' => 'products_model',

'type' => 'DB'

),

'Google product category' => array('output' => 'FM_RS_google_categories_us_en',

'type' => 'FUNCTION'

),

'product_type' => array('output' => 'CATEGORY_TREE',

'type' => 'KEYWORD',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'link' => array('output' => 'PRODUCTS_URL',

'type' => 'KEYWORD'

),

'image_link' => array('output' => 'IMAGE_URL',

'type' => 'KEYWORD'

),

'condition' => array('output' => 'new',

'type' => 'VALUE'

),

 

'description' => array('output' => 'products_description',

'type' => 'DB',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'shipping_weight' => array('output' => 'FM_RS_shipping_weight_and_unit',

'type' => 'FUNCTION',

),

'availability' => array('output' => 'in stock',

'type' => 'VALUE',

)

),

'currency_decimal_override' => false,

'currency_thousands_override' => '',

'add_field_names' => true,

'category_tree_seperator' => ' ',

'seperator' => "\t",

'text_qualifier' => '',

'newline' => "\n",

'encoding' => 'false',

'include_record_function' => ''

);

 

//FEED FUNCTIONS BEGIN

 

function FM_RS_product_id_us_en($product) {

return 'Your_shops_shortname_' . $product['products_id'] . '_us_en';

}

 

function FM_RS_google_categories_us_en($product) {

$output_field_category = ($product['parent_id'] > 0) ? $product['parent_id'] : $product['categories_id'];

return (($output_field_category == 1) ? 'Google > Category > Tree1' :

(($output_field_category == 2) ? 'Google > Category > Tree2':

(($output_field_category == 3) ? 'Google > Category > Tree3':

(($output_field_category == 4) ? 'Google > Category > Tree4':

(($output_field_category == 5) ? 'Google > Category > Tree5':

(($output_field_category == 6) ? 'Google > Category > Tree6':

(($output_field_category == 7) ? 'Google > Category > Tree7':

(($output_field_category == 8) ? 'Google > Category > Tree8':

(($output_field_category == 9) ? 'Google > Category > Tree9':

(($output_field_category == 10) ? 'Google > Category > Tree10':

(($output_field_category == 11) ? 'Google > Category > Tree11':

(($output_field_category == 12) ? 'Google > Category > Tree12':

(($output_field_category == 13) ? 'Google > Category > Tree13':

(($output_field_category == 14) ? 'Google > Category > Tree14':

(($output_field_category == 15) ? 'Google > Category > Tree15':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

''))))))))))))))))))));

}

 

//FEED FUNCTIONS END

 

?>

Link to comment
Share on other sites

I've used the one from your contribution, looks like this :

 

 

<?php

 

/**

* @license http://opensource.or...gpl-license.php GNU Public License

*/

 

/*

Google Product feed configuration for The Feedmachine Solution

based on google-simple.php by: Lech Madrzyk

----------------------------

This configuration is complient with the Google-Feed specifications from 22nd of september 2011.

It has to be used together with the modified feedmachine.php file which includes the 'IS_IN_STOCK' Keyword definition.

*/

 

$feed_config = array('name' => 'Google Product Search',

'authors' => 'Musicstreet',

'filename' => 'musicstreet.txt',

'schema_version' => '2.0',

'fields' => array('id' => array('output' => 'FM_RS_product_id_us_en',

'type' => 'FUNCTION'

),

'title' => array('output' => 'products_name',

'type' => 'DB',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'price' => array('output' => 'FINAL_PRICE_WITH_TAX',

'type' => 'KEYWORD',

),

'brand' => array('output' => 'manufacturers_name',

'type' => 'DB',

'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF')

),

'mpn' => array('output' => 'products_model',

'type' => 'DB'

),

'Google product category' => array('output' => 'FM_RS_google_categories_us_en',

'type' => 'FUNCTION'

),

'product_type' => array('output' => 'CATEGORY_TREE',

'type' => 'KEYWORD',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'link' => array('output' => 'PRODUCTS_URL',

'type' => 'KEYWORD'

),

'image_link' => array('output' => 'IMAGE_URL',

'type' => 'KEYWORD'

),

'condition' => array('output' => 'new',

'type' => 'VALUE'

),

 

'description' => array('output' => 'products_description',

'type' => 'DB',

'options' => array('STRIP_HTML', 'STRIP_CRLF')

),

'shipping_weight' => array('output' => 'FM_RS_shipping_weight_and_unit',

'type' => 'FUNCTION',

),

'availability' => array('output' => 'in stock',

'type' => 'VALUE',

)

),

'currency_decimal_override' => false,

'currency_thousands_override' => '',

'add_field_names' => true,

'category_tree_seperator' => ' ',

'seperator' => "\t",

'text_qualifier' => '',

'newline' => "\n",

'encoding' => 'false',

'include_record_function' => ''

);

 

//FEED FUNCTIONS BEGIN

 

function FM_RS_product_id_us_en($product) {

return 'Your_shops_shortname_' . $product['products_id'] . '_us_en';

}

 

function FM_RS_google_categories_us_en($product) {

$output_field_category = ($product['parent_id'] > 0) ? $product['parent_id'] : $product['categories_id'];

return (($output_field_category == 1) ? 'Google > Category > Tree1' :

(($output_field_category == 2) ? 'Google > Category > Tree2':

(($output_field_category == 3) ? 'Google > Category > Tree3':

(($output_field_category == 4) ? 'Google > Category > Tree4':

(($output_field_category == 5) ? 'Google > Category > Tree5':

(($output_field_category == 6) ? 'Google > Category > Tree6':

(($output_field_category == 7) ? 'Google > Category > Tree7':

(($output_field_category == 8) ? 'Google > Category > Tree8':

(($output_field_category == 9) ? 'Google > Category > Tree9':

(($output_field_category == 10) ? 'Google > Category > Tree10':

(($output_field_category == 11) ? 'Google > Category > Tree11':

(($output_field_category == 12) ? 'Google > Category > Tree12':

(($output_field_category == 13) ? 'Google > Category > Tree13':

(($output_field_category == 14) ? 'Google > Category > Tree14':

(($output_field_category == 15) ? 'Google > Category > Tree15':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

(($output_field_category == 10000) ? '':

''))))))))))))))))))));

}

 

//FEED FUNCTIONS END

 

?>

 

 

Hello,

 

sorry, there must be a mistake, the following tags are not included in this configuration file (google-product-search-us-en.php):

 

expiration_date genre id weight payment_accepted product_type currency location tax quantity age_range made_in

 

so its impossible that you use it to get the mentioned error.

 

The first line which my configuration file (google-product-search-us-en.php) generates looks like this:

 

id title price brand mpn Google product category product_type link image_link condition description shipping_weight availability

 

regards

raiwa

Link to comment
Share on other sites

Hi

is there something i need to add via mysql? or have i turned something off within the site which would stop it working?

 

Thanks

Tony

 

 

Hello,

 

you don't need to add anything to your database, check the installation instructions both: the original feedmachine instalation and the instructions of the google feed configuration.

 

regards

raiwa

Link to comment
Share on other sites

Is there a way to add a UPC automatically so I don't get an error from Google

 

Hello,

 

there is an addon which lets you include UPC, ISBN, EAN numbers to your shop:

 

http://addons.oscommerce.com/info/126

 

 

Once you installed this, you should have an extra field for these numbers in your database.

Then you can include it in your configuration file like this:

 

								   'gtin'			  =>   array('output' => 'name_of_your_sql_extrafield',
																 'type' => 'DB'
															    ),

 

hope this helps

raiwa

Link to comment
Share on other sites

 

Hello,

 

there is an addon which lets you include UPC, ISBN, EAN numbers to your shop:

 

http://addons.oscommerce.com/info/126

 

 

Once you installed this, you should have an extra field for these numbers in your database.

Then you can include it in your configuration file like this:

 

								   'gtin'			  =>   array('output' => 'name_of_your_sql_extrafield',
																 'type' => 'DB'
																),

 

hope this helps

raiwa

 

 

another posibility if you don't use the field "products_model", use this field for the UPC and change in the configuration file:

 

								   'mpn'			  =>   array('output' => 'products_model',
																 'type' => 'DB'
															    ),

 

to:

 

								   'gtin'			  =>   array('output' => 'products_model',
																 'type' => 'DB'
															    ),

 

regards

 

raiwa

Link to comment
Share on other sites

Hi Raiwa

 

I've got this great contrib up and running for one store, I also have another store with a very large number of categories, I'm getting the following error message:

 

Parse error: syntax error, unexpected ';' in /home/paganmag/public_html/shop/admin/fm-feed-configs/google-product-search-us-en.php on line 455

 

Here's the file - I would appreciate any help you can give me.

 

<?php
/**
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*/
/*
Google Product feed configuration for The Feedmachine Solution
based on google-simple.php by: Lech Madrzyk
----------------------------
This configuration is complient with the Google-Feed specifications from 22nd of september 2011.
It has to be used together with the modified feedmachine.php file which includes the 'IS_IN_STOCK' Keyword definition.
*/
$feed_config = array('name' => 'Google Product Search',
				 'authors' => 'raiwa',
				 'filename' => 'paganmagic1.txt',
				 'schema_version' => '2.0',
				 'fields' => array('id'			   =>   array('output' => 'FM_RS_product_id_us_en',
																 'type' => 'FUNCTION'
															    ),
								   'title'		    =>   array('output' => 'products_name',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
															    ),
								   'price'		    =>   array('output' => 'FINAL_PRICE_WITH_TAX',
																 'type' => 'KEYWORD',
															    ),
								   'brand'					  =>   array('output' => 'manufacturers_name',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF')
																  ),
								   'mpn'			  =>   array('output' => 'products_model',
																 'type' => 'DB'
															    ),
					 'Google product category'	    =>   array('output' => 'FM_RS_google_categories_us_en',
																 'type' => 'FUNCTION'
															    ),
								   'product_type'	 =>   array('output' => 'CATEGORY_TREE',
																 'type' => 'KEYWORD',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
															    ),
								   'link'			 =>   array('output' => 'PRODUCTS_URL',
																 'type' => 'KEYWORD'
															    ),
								   'image_link'	   =>   array('output' => 'IMAGE_URL',
																 'type' => 'KEYWORD'
															    ),
								   'condition'	    =>   array('output' => 'New',
																 'type' => 'VALUE'
															    ),
								   'description'	  =>   array('output' => 'products_description',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
															    ),
								   'availability'	    =>   array('output' => 'IS_IN_STOCK',
																 'type' => 'KEYWORD'
															    )
								  ),
				 'currency_decimal_override' => false,
				 'currency_thousands_override' => '',
				 'add_field_names' => true,
				 'category_tree_seperator' => ' ',
				 'seperator' => "\t",
				 'text_qualifier' => '',
				 'newline' => "\n",
				 'encoding' => 'false',
				 'include_record_function' => ''
			    );
//FEED FUNCTIONS BEGIN
function FM_RS_product_id_us_en($product) {
 return 'Retro-Brands_' . $product['products_id'] . '';
}
function FM_RS_google_categories_us_en($product) {
 $output_field_category = $product['categories_id'];
 return (($output_field_category == 670) ? 'Office Supplies > Filing & Organization > Calendars, Organizers & Planners' :
   (($output_field_category == 261) ? 'Home & Garden > Decor':
 (($output_field_category == 260) ? 'Home & Garden > Linens > Table Linens > Tablecloths':
  (($output_field_category == 263) ? 'Home & Garden > Decor':
   (($output_field_category == 262) ? 'Home & Garden > Decor':
    (($output_field_category == 264) ? 'Home & Garden > Decor':
	 (($output_field_category == 602) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	  (($output_field_category == 603) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 611) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
  (($output_field_category == 612) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
   (($output_field_category == 613) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    (($output_field_category == 605) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	 (($output_field_category == 608) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	  (($output_field_category == 604) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 606) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	    (($output_field_category == 607) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
		 (($output_field_category == 610) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
    (($output_field_category == 609) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	 (($output_field_category == 313) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	  (($output_field_category == 431) ? 'Arts & Entertainment > Artwork > Prints':
	  (($output_field_category == 324) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
	  (($output_field_category == 490) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 390) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 677) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 318) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 317) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 381) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 357) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 316) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 678) ? 'Arts & Entertainment > Artwork > Photographs':
	   (($output_field_category == 656) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
	   (($output_field_category == 601) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 314) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 72) ? 'Arts & Entertainment > Collectibles > Collectible Weapons > Collectible Knives':
	   (($output_field_category == 53) ? 'Apparel & Accessories':
	   (($output_field_category == 210) ? 'Arts & Entertainment > Crafts & Hobbies > Magnets':
	   (($output_field_category == 54) ? 'Apparel & Accessories':
	   (($output_field_category == 623) ? 'Home & Garden > Decor':
	   (($output_field_category == 84) ? 'Vehicles & Parts > Automotive Care > Automotive Decor > Automotive Decals':
	   (($output_field_category == 148) ? 'Home & Garden > Decor > Doors & Windows':
	   (($output_field_category == 268) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 265) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 267) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 266) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 304) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 300) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 302) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 651) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
	   (($output_field_category == 301) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
	   (($output_field_category == 71) ? 'Home & Garden > Household Supplies > Household Cleaning Supplies > Brooms':
	   (($output_field_category == 240) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 239) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 237) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 238) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 236) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 385) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 365) ? 'Arts & Entertainment > Crafts & Hobbies > Candle & Soap Making':
	   (($output_field_category == 222) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 495) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 224) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 219) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 223) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 225) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 229) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 492) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 226) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 227) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 228) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 485) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 269) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 509) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 359) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 272) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 273) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 274) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 275) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 271) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 675) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 276) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 278) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 279) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 280) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 277) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 270) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 74) ? 'Home & Garden > Kitchen & Dining > Cookware':
	   (($output_field_category == 101) ? 'Home & Garden > Kitchen & Dining > Tableware > Dinnerware > Bowls':
	   (($output_field_category == 102) ? 'Home & Garden > Kitchen & Dining':
	   (($output_field_category == 149) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Candy & Chocolate Molds':
	   (($output_field_category == 625) ? 'Apparel & Accessories > Handbags':
	   (($output_field_category == 336) ? 'Apparel & Accessories > Jewelry > Cufflinks':
	   (($output_field_category == 628) ? 'Apparel & Accessories > Clothing Accessories > Gloves & Mittens':
	   (($output_field_category == 626) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs':
	   (($output_field_category == 353) ? 'Apparel & Accessories > Clothing Accessories':
	   (($output_field_category == 627) ? 'Apparel & Accessories > Clothing Accessories > Scarves & Shawls':
	   (($output_field_category == 660) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 135) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 488) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 480) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 486) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 481) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 281) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 197) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 331) ? 'Apparel & Accessories > Clothing > Dresses':
	   (($output_field_category == 616) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 622) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 614) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 619) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 617) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 615) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 620) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 621) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 469) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 618) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 130) ? 'Media > Books > Non-Fiction > Education Books':
	   (($output_field_category == 469) ? 'Home & Garden > Decor > Baskets':
	   (($output_field_category == 469) ? 'Arts & Entertainment > Crafts & Hobbies > Jewelry Making > Beads':
	   (($output_field_category == 437) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 398) ? 'Arts & Entertainment > Crafts & Hobbies > Flower Arranging':
	   (($output_field_category == 662) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 377) ? 'Home & Garden > Decor':
	   (($output_field_category == 376) ? 'Home & Garden > Decor':
	   (($output_field_category == 204) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 31) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 494) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 37) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 146) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 669) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 668) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 349) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 199) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 116) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 167) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 639) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 641) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 640) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 599) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 379) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 165) ? 'Home & Garden > Decor':
	   (($output_field_category == 32) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 156) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
	   (($output_field_category == 30) ? 'Health & Beauty > Personal Care > Massagers':
	   (($output_field_category == 35) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 384) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 367) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 688) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 351) ? 'Home & Garden > Decor':
	   (($output_field_category == 350) ? 'Home & Garden > Decor':
	   (($output_field_category == 200) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 145) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 33) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 41) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 209) ? 'Media > DVDs & Videos':
	   (($output_field_category == 119) ? 'Home & Garden > Decor':
	   (($output_field_category == 86) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 374) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 659) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 40) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 118) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 201) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 87) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 363) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 667) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 205) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 382) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 157) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 482) ? 'Arts & Entertainment > Party Supplies > Confetti':
	   (($output_field_category == 469) ? 'Home & Garden > Decor':
	   (($output_field_category == 443) ? 'Home & Garden > Plants > Flowers':
	   (($output_field_category == 451) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
	   (($output_field_category == 442) ? 'Home & Garden > Decor > Artificial Plants & Flowers':
	   (($output_field_category == 326) ? 'Home & Garden > Decor > Clocks':
	   (($output_field_category == 362) ? 'Home & Garden > Kitchen & Dining > Barware > Coasters':
	   (($output_field_category == 328) ? 'Home & Garden > Kitchen & Dining':
	   (($output_field_category == 600) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 439) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 330) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 438) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 85) ? 'Arts & Entertainment > Gift Giving':
	   (($output_field_category == 144) ? 'Home & Garden > Decor':
	   (($output_field_category == 387) ? 'Electronics > Computers > Computer Accessories':
	   (($output_field_category == 325) ? 'Home & Garden > Kitchen & Dining > Tableware > Drinkware > Mugs':
	   (($output_field_category == 329) ? 'Office Supplies > General Supplies > Paper Products > Notebooks & Notepads':
	   (($output_field_category == 510) ? 'Home & Garden > Decor > Photo Storage & Display > Photo Albums':
	   (($output_field_category == 339) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 211) ? 'Home & Garden > Decor > Plaques':
	   (($output_field_category == 655) ? 'Arts & Entertainment > Party Supplies > Wedding Ceremony Supplies':
	   (($output_field_category == 282) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 283) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 489) ? 'Health & Beauty > Personal Care > Cosmetics > Perfume & Cologne':
	   (($output_field_category == 22) ? 'Health & Beauty > Personal Care > Massagers':
	   (($output_field_category == 284) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 288) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 21) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 671) ? 'Home & Garden > Smoking Accessories':
	   (($output_field_category == 120) ? 'Health & Beauty > Personal Care':
	   (($output_field_category == 68) ? 'Food, Beverages & Tobacco > Beverages > Tea & Infusions':
	   (($output_field_category == 78) ? 'Food, Beverages & Tobacco > Food Items > Seasonings & Spices > Herbs & Spices':
	   (($output_field_category == 285) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 432) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 386) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 358) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 105) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Mortars & Pestles':
	   (($output_field_category == 287) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 286) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 306) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 115) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 307) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 308) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 380) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 23) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 690) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 142) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 215) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 216) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 508) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 218) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 487) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 217) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 312) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 214) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 79) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 473) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 476) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 472) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 474) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 477) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 475) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 299) ? 'Home & Garden > Smoking Accessories > Lighters':
	   (($output_field_category == 332) ? 'Apparel & Accessories > Clothing Accessories > Hair Accessories':
	   (($output_field_category == 335) ? 'Apparel & Accessories > Clothing Accessories > Belt Buckles':
	   (($output_field_category == 344) ? 'Apparel & Accessories > Jewelry > Anklets':
	   (($output_field_category == 347) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 340) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 341) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 343) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 346) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 345) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 348) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 342) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 337) ? 'Apparel & Accessories > Jewelry > Brooches & Lapels':
	   (($output_field_category == 383) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 334) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
	   (($output_field_category == 258) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 233) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 414) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 415) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 416) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 417) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 413) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 412) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 411) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 111) ? 'Arts & Entertainment > Religious Items > Prayer Beads':
	   (($output_field_category == 259) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 221) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 256) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 232) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 243) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 422) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 423) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 424) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 664) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 663) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 425) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 426) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 245) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 428) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 427) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 429) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 247) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 254) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 250) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 248) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 242) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 436) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 257) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 249) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 253) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 48) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 147) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 251) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 255) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 55) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 252) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 117) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 393) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 434) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 419) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 360) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 446) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 450) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 444) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 445) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 447) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 448) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 449) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 408) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 338) ? 'Apparel & Accessories > Watches':
	   (($output_field_category == 213) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
	   (($output_field_category == 676) ? 'Food, Beverages & Tobacco > Food Items > Cooking & Baking Supplies':
	   (($output_field_category == 658) ? 'Media > Magazines & Newspapers':
	   (($output_field_category == 685) ? 'Media > Music':
	   (($output_field_category == 682) ? 'Media > Music':
	   (($output_field_category == 681) ? 'Media > Music':
	   (($output_field_category == 683) ? 'Media > Music':
	   (($output_field_category == 686) ? 'Media > Music':
	   (($output_field_category == 679) ? 'Media > Music':
	   (($output_field_category == 680) ? 'Media > Music':
	   (($output_field_category == 687) ? 'Media > Music':
	   (($output_field_category == 684) ? 'Media > Music':
	   (($output_field_category == 322) ? 'Arts & Entertainment > Musical Instrument Accessories':
	   (($output_field_category == 657) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 666) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 654) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 652) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 153) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 170) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 154) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 131) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 418) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 24) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 361) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 323) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 113) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 364) ? 'Media > Books > Fiction > Children\'s Books':
	   (($output_field_category == 321) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 295) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 294) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 491) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 220) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 73) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 70) ? 'Home & Garden > Decor > Mirrors':
	   (($output_field_category == 132) ? 'Arts & Entertainment > Musical Instrument Accessories':
	   (($output_field_category == 399) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 355) ? 'Home & Garden > Linens > Bedding':
	   (($output_field_category == 352) ? 'Home & Garden > Decor > Rugs':
	   (($output_field_category == 354) ? 'Home & Garden > Decor':
	   (($output_field_category == 456) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 455) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 454) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 465) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 464) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 457) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 460) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 463) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 459) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 452) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 493) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 453) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 462) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 458) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 461) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 466) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 99) ? 'Home & Garden > Kitchen & Dining > Food & Beverage Carriers':
	   (($output_field_category == 107) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 368) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 94) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 129) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 661) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
	   (($output_field_category == 468) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
	   (($output_field_category == 97) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 124) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 234) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 372) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 370) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 373) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Art Paper':
	   (($output_field_category == 369) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Drawing > Art Pens':
	   (($output_field_category == 371) ? 'Arts & Entertainment > Collectibles > Seal Stamps':
	   (($output_field_category == 511) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 421) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 76) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 689) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 378) ? 'Health & Beauty > Health Care > Mobility & Special Needs > Walking Aids':
	   (($output_field_category == 56) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 672) ? 'Health & Beauty > Personal Care > Sleeping Aids':
	   (($output_field_category == 674) ? 'Home & Garden > Decor':
	   (($output_field_category == 673) ? 'Home & Garden > Decor > Wind Chimes':
		  '')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))));
 }
//FEED FUNCTIONS END
?>

Link to comment
Share on other sites

Hi Raiwa

 

I've got this great contrib up and running for one store, I also have another store with a very large number of categories, I'm getting the following error message:

 

Parse error: syntax error, unexpected ';' in /home/paganmag/public_html/shop/admin/fm-feed-configs/google-product-search-us-en.php on line 455

 

Here's the file - I would appreciate any help you can give me.

 

<?php
/**
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*/
/*
Google Product feed configuration for The Feedmachine Solution
based on google-simple.php by: Lech Madrzyk
----------------------------
This configuration is complient with the Google-Feed specifications from 22nd of september 2011.
It has to be used together with the modified feedmachine.php file which includes the 'IS_IN_STOCK' Keyword definition.
*/
$feed_config = array('name' => 'Google Product Search',
				 'authors' => 'raiwa',
				 'filename' => 'paganmagic1.txt',
				 'schema_version' => '2.0',
				 'fields' => array('id'			   =>   array('output' => 'FM_RS_product_id_us_en',
																 'type' => 'FUNCTION'
																),
								   'title'			=>   array('output' => 'products_name',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
																),
								   'price'			=>   array('output' => 'FINAL_PRICE_WITH_TAX',
																 'type' => 'KEYWORD',
																),
								   'brand'					  =>   array('output' => 'manufacturers_name',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'HTML_ENTITIES', 'STRIP_CRLF')
																  ),
								   'mpn'			  =>   array('output' => 'products_model',
																 'type' => 'DB'
																),
					 'Google product category'		=>   array('output' => 'FM_RS_google_categories_us_en',
																 'type' => 'FUNCTION'
																),
								   'product_type'	 =>   array('output' => 'CATEGORY_TREE',
																 'type' => 'KEYWORD',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
																),
								   'link'			 =>   array('output' => 'PRODUCTS_URL',
																 'type' => 'KEYWORD'
																),
								   'image_link'	   =>   array('output' => 'IMAGE_URL',
																 'type' => 'KEYWORD'
																),
								   'condition'		=>   array('output' => 'New',
																 'type' => 'VALUE'
																),
								   'description'	  =>   array('output' => 'products_description',
																 'type' => 'DB',
																 'options' => array('STRIP_HTML', 'STRIP_CRLF')
																),
								   'availability'		=>   array('output' => 'IS_IN_STOCK',
																 'type' => 'KEYWORD'
																)
								  ),
				 'currency_decimal_override' => false,
				 'currency_thousands_override' => '',
				 'add_field_names' => true,
				 'category_tree_seperator' => ' ',
				 'seperator' => "\t",
				 'text_qualifier' => '',
				 'newline' => "\n",
				 'encoding' => 'false',
				 'include_record_function' => ''
				);
//FEED FUNCTIONS BEGIN
function FM_RS_product_id_us_en($product) {
 return 'Retro-Brands_' . $product['products_id'] . '';
}
function FM_RS_google_categories_us_en($product) {
 $output_field_category = $product['categories_id'];
 return (($output_field_category == 670) ? 'Office Supplies > Filing & Organization > Calendars, Organizers & Planners' :
(($output_field_category == 261) ? 'Home & Garden > Decor':
 (($output_field_category == 260) ? 'Home & Garden > Linens > Table Linens > Tablecloths':
  (($output_field_category == 263) ? 'Home & Garden > Decor':
   (($output_field_category == 262) ? 'Home & Garden > Decor':
	(($output_field_category == 264) ? 'Home & Garden > Decor':
	 (($output_field_category == 602) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	  (($output_field_category == 603) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 611) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
  (($output_field_category == 612) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
   (($output_field_category == 613) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	(($output_field_category == 605) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	 (($output_field_category == 608) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	  (($output_field_category == 604) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 606) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
		(($output_field_category == 607) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
		 (($output_field_category == 610) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	(($output_field_category == 609) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	 (($output_field_category == 313) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	  (($output_field_category == 431) ? 'Arts & Entertainment > Artwork > Prints':
	  (($output_field_category == 324) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
	  (($output_field_category == 490) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 390) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 677) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 318) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 317) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 381) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 357) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 316) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 678) ? 'Arts & Entertainment > Artwork > Photographs':
	   (($output_field_category == 656) ? 'Hardware > Flooring > Stone Flooring > Tile Flooring':
	   (($output_field_category == 601) ? 'Arts & Entertainment > Artwork > Prints':
	   (($output_field_category == 314) ? 'Arts & Entertainment > Artwork > Posters & Reproductions':
	   (($output_field_category == 72) ? 'Arts & Entertainment > Collectibles > Collectible Weapons > Collectible Knives':
	   (($output_field_category == 53) ? 'Apparel & Accessories':
	   (($output_field_category == 210) ? 'Arts & Entertainment > Crafts & Hobbies > Magnets':
	   (($output_field_category == 54) ? 'Apparel & Accessories':
	   (($output_field_category == 623) ? 'Home & Garden > Decor':
	   (($output_field_category == 84) ? 'Vehicles & Parts > Automotive Care > Automotive Decor > Automotive Decals':
	   (($output_field_category == 148) ? 'Home & Garden > Decor > Doors & Windows':
	   (($output_field_category == 268) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 265) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 267) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 266) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 304) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 300) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 302) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 651) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
	   (($output_field_category == 301) ? 'Apparel & Accessories > Jewelry Accessories > Jewelry Boxes':
	   (($output_field_category == 71) ? 'Home & Garden > Household Supplies > Household Cleaning Supplies > Brooms':
	   (($output_field_category == 240) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 239) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 237) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 238) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 236) ? 'Home & Garden > Decor > Candle Holders':
	   (($output_field_category == 385) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 365) ? 'Arts & Entertainment > Crafts & Hobbies > Candle & Soap Making':
	   (($output_field_category == 222) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 495) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 224) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 219) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 223) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 225) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 229) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 492) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 226) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 227) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 228) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 485) ? 'Home & Garden > Decor > Candles':
	   (($output_field_category == 269) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 509) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 359) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 272) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 273) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 274) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 275) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 271) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 675) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 276) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 278) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 279) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 280) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 277) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 270) ? 'Arts & Entertainment > Gift Giving > Greeting Cards':
	   (($output_field_category == 74) ? 'Home & Garden > Kitchen & Dining > Cookware':
	   (($output_field_category == 101) ? 'Home & Garden > Kitchen & Dining > Tableware > Dinnerware > Bowls':
	   (($output_field_category == 102) ? 'Home & Garden > Kitchen & Dining':
	   (($output_field_category == 149) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Candy & Chocolate Molds':
	   (($output_field_category == 625) ? 'Apparel & Accessories > Handbags':
	   (($output_field_category == 336) ? 'Apparel & Accessories > Jewelry > Cufflinks':
	   (($output_field_category == 628) ? 'Apparel & Accessories > Clothing Accessories > Gloves & Mittens':
	   (($output_field_category == 626) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs':
	   (($output_field_category == 353) ? 'Apparel & Accessories > Clothing Accessories':
	   (($output_field_category == 627) ? 'Apparel & Accessories > Clothing Accessories > Scarves & Shawls':
	   (($output_field_category == 660) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 135) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 488) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 480) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 486) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 481) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 281) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 197) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 331) ? 'Apparel & Accessories > Clothing > Dresses':
	   (($output_field_category == 616) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 622) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 614) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 619) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 617) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 615) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 620) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 621) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 469) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 618) ? 'Apparel & Accessories > Clothing':
	   (($output_field_category == 130) ? 'Media > Books > Non-Fiction > Education Books':
	   (($output_field_category == 469) ? 'Home & Garden > Decor > Baskets':
	   (($output_field_category == 469) ? 'Arts & Entertainment > Crafts & Hobbies > Jewelry Making > Beads':
	   (($output_field_category == 437) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 398) ? 'Arts & Entertainment > Crafts & Hobbies > Flower Arranging':
	   (($output_field_category == 662) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 377) ? 'Home & Garden > Decor':
	   (($output_field_category == 376) ? 'Home & Garden > Decor':
	   (($output_field_category == 204) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 31) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 494) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 37) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 146) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 669) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 668) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 349) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 199) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 116) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 167) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 639) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 641) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 640) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 599) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 379) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 165) ? 'Home & Garden > Decor':
	   (($output_field_category == 32) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 156) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
	   (($output_field_category == 30) ? 'Health & Beauty > Personal Care > Massagers':
	   (($output_field_category == 35) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 384) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 367) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 688) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 351) ? 'Home & Garden > Decor':
	   (($output_field_category == 350) ? 'Home & Garden > Decor':
	   (($output_field_category == 200) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 145) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 33) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 41) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 209) ? 'Media > DVDs & Videos':
	   (($output_field_category == 119) ? 'Home & Garden > Decor':
	   (($output_field_category == 86) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 374) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 659) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 40) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 118) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 201) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 87) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 363) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 667) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 205) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 382) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 157) ? 'Arts & Entertainment > Artwork > Figurines, Sculptures & Statues':
	   (($output_field_category == 482) ? 'Arts & Entertainment > Party Supplies > Confetti':
	   (($output_field_category == 469) ? 'Home & Garden > Decor':
	   (($output_field_category == 443) ? 'Home & Garden > Plants > Flowers':
	   (($output_field_category == 451) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
	   (($output_field_category == 442) ? 'Home & Garden > Decor > Artificial Plants & Flowers':
	   (($output_field_category == 326) ? 'Home & Garden > Decor > Clocks':
	   (($output_field_category == 362) ? 'Home & Garden > Kitchen & Dining > Barware > Coasters':
	   (($output_field_category == 328) ? 'Home & Garden > Kitchen & Dining':
	   (($output_field_category == 600) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 439) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 330) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 438) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping':
	   (($output_field_category == 85) ? 'Arts & Entertainment > Gift Giving':
	   (($output_field_category == 144) ? 'Home & Garden > Decor':
	   (($output_field_category == 387) ? 'Electronics > Computers > Computer Accessories':
	   (($output_field_category == 325) ? 'Home & Garden > Kitchen & Dining > Tableware > Drinkware > Mugs':
	   (($output_field_category == 329) ? 'Office Supplies > General Supplies > Paper Products > Notebooks & Notepads':
	   (($output_field_category == 510) ? 'Home & Garden > Decor > Photo Storage & Display > Photo Albums':
	   (($output_field_category == 339) ? 'Home & Garden > Household Supplies > Storage & Organization':
	   (($output_field_category == 211) ? 'Home & Garden > Decor > Plaques':
	   (($output_field_category == 655) ? 'Arts & Entertainment > Party Supplies > Wedding Ceremony Supplies':
	   (($output_field_category == 282) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 283) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 489) ? 'Health & Beauty > Personal Care > Cosmetics > Perfume & Cologne':
	   (($output_field_category == 22) ? 'Health & Beauty > Personal Care > Massagers':
	   (($output_field_category == 284) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 288) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 21) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 671) ? 'Home & Garden > Smoking Accessories':
	   (($output_field_category == 120) ? 'Health & Beauty > Personal Care':
	   (($output_field_category == 68) ? 'Food, Beverages & Tobacco > Beverages > Tea & Infusions':
	   (($output_field_category == 78) ? 'Food, Beverages & Tobacco > Food Items > Seasonings & Spices > Herbs & Spices':
	   (($output_field_category == 285) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 432) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 386) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 358) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 105) ? 'Home & Garden > Kitchen & Dining > Kitchen Tools & Utensils > Mortars & Pestles':
	   (($output_field_category == 287) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 286) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 306) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 115) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 307) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 308) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 380) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 23) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 690) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 142) ? 'Home & Garden > Decor > Home Fragrances':
	   (($output_field_category == 215) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 216) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 508) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 218) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 487) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 217) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 312) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 214) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 79) ? 'Home & Garden > Decor > Home Fragrances > Incense':
	   (($output_field_category == 473) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 476) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 472) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 474) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 477) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 475) ? 'Home & Garden > Decor > Home Fragrances > Incense Holders':
	   (($output_field_category == 299) ? 'Home & Garden > Smoking Accessories > Lighters':
	   (($output_field_category == 332) ? 'Apparel & Accessories > Clothing Accessories > Hair Accessories':
	   (($output_field_category == 335) ? 'Apparel & Accessories > Clothing Accessories > Belt Buckles':
	   (($output_field_category == 344) ? 'Apparel & Accessories > Jewelry > Anklets':
	   (($output_field_category == 347) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 340) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 341) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 343) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 346) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 345) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 348) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 342) ? 'Apparel & Accessories > Jewelry > Bracelets':
	   (($output_field_category == 337) ? 'Apparel & Accessories > Jewelry > Brooches & Lapels':
	   (($output_field_category == 383) ? 'Apparel & Accessories > Jewelry > Charms & Pendants':
	   (($output_field_category == 334) ? 'Apparel & Accessories > Clothing Accessories > Headwear & Kerchiefs > Headdresses':
	   (($output_field_category == 258) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 233) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 414) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 415) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 416) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 417) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 413) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 412) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 411) ? 'Apparel & Accessories > Jewelry > Earrings':
	   (($output_field_category == 111) ? 'Arts & Entertainment > Religious Items > Prayer Beads':
	   (($output_field_category == 259) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 221) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 256) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 232) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 243) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 422) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 423) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 424) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 664) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 663) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 425) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 426) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 245) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 428) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 427) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 429) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 247) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 254) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 250) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 248) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 242) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 436) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 257) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 249) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 253) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 48) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 147) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 251) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 255) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 55) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 252) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 117) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 393) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 434) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 419) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 360) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 446) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 450) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 444) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 445) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 447) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 448) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 449) ? 'Apparel & Accessories > Jewelry > Rings':
	   (($output_field_category == 408) ? 'Apparel & Accessories > Jewelry > Necklaces':
	   (($output_field_category == 338) ? 'Apparel & Accessories > Watches':
	   (($output_field_category == 213) ? 'Luggage & Bags > Luggage > Luggage Accessories > Keychains':
	   (($output_field_category == 676) ? 'Food, Beverages & Tobacco > Food Items > Cooking & Baking Supplies':
	   (($output_field_category == 658) ? 'Media > Magazines & Newspapers':
	   (($output_field_category == 685) ? 'Media > Music':
	   (($output_field_category == 682) ? 'Media > Music':
	   (($output_field_category == 681) ? 'Media > Music':
	   (($output_field_category == 683) ? 'Media > Music':
	   (($output_field_category == 686) ? 'Media > Music':
	   (($output_field_category == 679) ? 'Media > Music':
	   (($output_field_category == 680) ? 'Media > Music':
	   (($output_field_category == 687) ? 'Media > Music':
	   (($output_field_category == 684) ? 'Media > Music':
	   (($output_field_category == 322) ? 'Arts & Entertainment > Musical Instrument Accessories':
	   (($output_field_category == 657) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 666) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 654) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 652) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 153) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 170) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 154) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 131) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 418) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 24) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 361) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 323) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 113) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 364) ? 'Media > Books > Fiction > Children\'s Books':
	   (($output_field_category == 321) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 295) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 294) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 491) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 220) ? 'Health & Beauty > Personal Care > Cosmetics > Bath & Body':
	   (($output_field_category == 73) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 70) ? 'Home & Garden > Decor > Mirrors':
	   (($output_field_category == 132) ? 'Arts & Entertainment > Musical Instrument Accessories':
	   (($output_field_category == 399) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 355) ? 'Home & Garden > Linens > Bedding':
	   (($output_field_category == 352) ? 'Home & Garden > Decor > Rugs':
	   (($output_field_category == 354) ? 'Home & Garden > Decor':
	   (($output_field_category == 456) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 455) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 454) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 465) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 464) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 457) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 460) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 463) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 459) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 452) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 493) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 453) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 462) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 458) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 461) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 466) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 99) ? 'Home & Garden > Kitchen & Dining > Food & Beverage Carriers':
	   (($output_field_category == 107) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 368) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 94) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 129) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 661) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
	   (($output_field_category == 468) ? 'Arts & Entertainment > Gift Giving > Gift Wrapping > Bows & Ribbons':
	   (($output_field_category == 97) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 124) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 234) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 372) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 370) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 373) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Art Paper':
	   (($output_field_category == 369) ? 'Arts & Entertainment > Crafts & Hobbies > Drawing & Painting > Drawing > Art Pens':
	   (($output_field_category == 371) ? 'Arts & Entertainment > Collectibles > Seal Stamps':
	   (($output_field_category == 511) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 421) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 76) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 689) ? 'Arts & Entertainment > Collectibles':
	   (($output_field_category == 378) ? 'Health & Beauty > Health Care > Mobility & Special Needs > Walking Aids':
	   (($output_field_category == 56) ? 'Arts & Entertainment > Crafts & Hobbies':
	   (($output_field_category == 672) ? 'Health & Beauty > Personal Care > Sleeping Aids':
	   (($output_field_category == 674) ? 'Home & Garden > Decor':
	   (($output_field_category == 673) ? 'Home & Garden > Decor > Wind Chimes':
		  '')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))));
 }
//FEED FUNCTIONS END
?>

 

 

Hello,

 

There is one ")" missing in line 455 at the end with a huge amount of them.

 

regards

raiwa

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...

Hi All,

What a great contrib.

 

However, I have one problem which is driving me nuts.

 

I cannot for the life of me get the price to include VAT in the output file.

 

The store is set to display prices inc tax, I have the config file set to FINAL_PRICE_WITH_TAX.

 

I have even checked the country zones etc to make sure the store applies the correct tax regime.

 

In every other respect the tax shows correctly in the front of house and in admin.

 

What I am I doing wrong? Has anyone else had this issue?

 

Yes, I can manually adjust the prices in Excel prior to uploading to Google but that kind of defeats the object.

 

I look forward to help with this one

 

Cheers

 

Simon

Edited by simonhornby
Link to comment
Share on other sites

Hi All,

What a great contrib.

 

However, I have one problem which is driving me nuts.

 

I cannot for the life of me get the price to include VAT in the output file.

 

The store is set to display prices inc tax, I have the config file set to FINAL_PRICE_WITH_TAX.

 

I have even checked the country zones etc to make sure the store applies the correct tax regime.

 

In every other respect the tax shows correctly in the front of house and in admin.

 

What I am I doing wrong? Has anyone else had this issue?

 

Yes, I can manually adjust the prices in Excel prior to uploading to Google but that kind of defeats the object.

 

I look forward to help with this one

 

Cheers

 

Simon

 

 

Hello,

 

I had the same problem and can give you a help with a user function which calculates the price incl. tax in a diferent way than the standard functions includedd in feedmachine.

I discovered that at least in my case the problem is caused by zones which have diferent tax rates assigned in the same country. Like in Spain: Ceuta, Melilla and Canarian Islands.

 

So here the solution:

 

If you use only one configuration file,

paste this function in the function area of the configuration file

(between: //FEED FUNCTIONS BEGIN and //FEED FUNCTIONS END):

 

function FM_RS_final_price_with_tax($product) {
 return ($product['products_price']) * (1+((tep_get_tax_rate($product['products_tax_class_id'])/100)));
}

 

If you use more than one configuration file which needs to use the function,

paste it in: catalog/admin/feedmachine_loadingbay.php

 

 

Then in the configuration file

CHANGE THIS (instead of "FINAL_PRICE_WITH_TAX" you may have another keyword there):

 

								   'price'		    =>   array('output' => 'FINAL_PRICE_WITH_TAX',
																 'type' => 'KEYWORD',
															    ),

 

TO THIS:

 

								   'price'		    =>   array('output' => 'FM_RS_final_price_with_tax',
																 'type' => 'FUNCTION',
															    ),

 

That's it.

 

Here another small function to add the unit to weight if you use it:

 

function FM_RS_shipping_weight_and_unit($product) {
 return $product['products_weight'] . ' kg';
}

 

AND

 

								   'shipping_weight'  =>   array('output' => 'FM_RS_shipping_weight_and_unit',
																 'type' => 'FUNCTION',
															    ),

 

Same installation like the price with tax.

 

 

Hope this helps

regards

Rainer

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...