Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

The Feedmachine Solution


241 replies to this topic

#221 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 10 October 2011, 13:22

View PostDawnG, on 10 October 2011, 11:08, said:

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

#222 DawnG

  • Community Member
  • 178 posts
  • Real Name:Dawn Gribble

Posted 11 October 2011, 07:18

Thank-you very very much :D

#223 mcbsolutions

  • Community Member
  • 164 posts
  • Real Name:Steve Walker
  • Gender:Male

Posted 28 November 2011, 19:07

Is this compatible with 2.3? This is a must have for me if i upgrade to 2.3. Thanks!

#224 simonhornby

  • Community Member
  • 15 posts
  • Real Name:Simon Hornby

Posted 07 December 2011, 20:18

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, 07 December 2011, 20:20.


#225 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 08 December 2011, 10:23

View Postsimonhornby, on 07 December 2011, 20:18, said:

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

#226 simonhornby

  • Community Member
  • 15 posts
  • Real Name:Simon Hornby

Posted 08 December 2011, 22:49

Hi Rainer,

Thank you very much, that worked a treat.

How can I now get the price to show to only 2 decimal places? Some of the calculated prices are showing upto 6 decimal places at the moment - does this actually matter?

And one more thing... I entered the ftp server as "uploads.google.com" and my username and password from my merchant account but it doesn't work (can't connect to server error) - any ideas?

Cheers

Simon

#227 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 09 December 2011, 10:57

View Postsimonhornby, on 08 December 2011, 22:49, said:

Hi Rainer,

Thank you very much, that worked a treat.

How can I now get the price to show to only 2 decimal places? Some of the calculated prices are showing upto 6 decimal places at the moment - does this actually matter?

And one more thing... I entered the ftp server as "uploads.google.com" and my username and password from my merchant account but it doesn't work (can't connect to server error) - any ideas?

Cheers

Simon

Hello again,

The decimals doesn't matter because they will be rounded to 2 decimals in google shopping.

About the ftp upload , I have the same problem and didn't get it to work neither.
I use the "Sheduled Upload" feature in the Google Merchant Center - Data Feeds, just where you define your feeds.

regards
Rainer

#228 ptrau

  • Community Member
  • 400 posts
  • Real Name:Paul Trau
  • Gender:Male
  • Location:Atlanta, GA USA

Posted 07 February 2012, 15:00

Whenever we try and "Generate and Upload Feeds Now" this is what we receive:

Google Product Search
------------
update status: feed updated as part of a force update
upload trigger status: feed upload triggered due to update
upload status:Could not connect to ftp server: uploads.google.com

Has anyone found a solution to this problem? Feedmachine is an awesome contribution. I would just like to get it to upload via ftp whenever changes are made to the product category like it is supposed to. I have Google uploading the file on a weekly basis but we still have to regenerate the file manually first. I know that is not a huge issue, but it is much more convenient if it does it automatically on update.

Again, thank you for an awesome contribution.

Any help is always greatly appreciated.
"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

#229 fourmat

  • Community Member
  • 69 posts
  • Real Name:Matt Hartman
  • Gender:Male
  • Location:US

Posted 07 February 2012, 16:04

Love the feedmachine, but I have a configuration issue.

I have another URL parameter that I have been using to track what particular item is being clicked to produce the click conversion.
I have been using another feed generator and had coded it to return the additional URL parameter of &utm_term="model number" where model number is pulled from the $products['products_model'] in the database. How can I structure or modify FM to return that parameter?

I have tried adding it to various locations in feedmachine.php where PRODUCTS_URL is generated, but it doesn't seem to be picking it up. I also tried creating a separate function in the configuration file, but it's not picking up the url parameters spec'd in the admin. Any help would be appreciated.

#230 simonhornby

  • Community Member
  • 15 posts
  • Real Name:Simon Hornby

Posted 18 February 2012, 10:38

Google-base Shipping Attribute

Hi Rainer,

As Google now require the "shipping" attribute to be included in the feed do you have any plans for an update?

The problem is that we have numerous products with different weights and Google requires than shipping is shown for each country for each product in the feed.

I have only covered the UK at present which at least stops the error messages but for international orders it seem like it is going to be very long-winded to fix this properly.

I have added the following to google-product-search-us-en.php

'shipping' => array('output' => 'UK::Free Shipping:0 GBP,UK::Recorded Delivery: 0.89 GBP',
'type' => 'VALUE',
),

Can you suggest anything better?

Cheers

Simon

Edited by simonhornby, 18 February 2012, 10:40.


#231 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 15 March 2012, 20:23

View Postsimonhornby, on 18 February 2012, 10:38, said:

Google-base Shipping Attribute

Hi Rainer,

As Google now require the "shipping" attribute to be included in the feed do you have any plans for an update?

The problem is that we have numerous products with different weights and Google requires than shipping is shown for each country for each product in the feed.

I have only covered the UK at present which at least stops the error messages but for international orders it seem like it is going to be very long-winded to fix this properly.

I have added the following to google-product-search-us-en.php

'shipping' => array('output' => 'UK::Free Shipping:0 GBP,UK::Recorded Delivery: 0.89 GBP',
'type' => 'VALUE',
),

Can you suggest anything better?

Cheers

Simon


Hello,

It seems you use the weight based shipping cost of OSCommerce, so I do the same. As far as I know there is no way to extract the shipping cost information, as OSCommerce dosn't calculate the cost until an item is added to the shopping cart, at least.
At least my programming knowledge doesn't go far enough to do this.
The solution I use is to include the shipping weight tag in the google feed and set up a weight based shipping table in Google tax and shipping config.
This assigns a weight based shipping cost to each item, even it can't calculate real shipping costs for a purchase of several items.

Actually I'm working on an update which will include a solution for the new in US-feeds required gender, age group and color tags for apparel products.

Hope it will be ready for upload in a couple of weeks.

regards
Rainer

#232 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 25 March 2012, 18:48

The new vesion: Google Product Search Feed 2.0 (Feedmachine Configuration) has been uploaded here:

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

In a standard OSCommerce instalation, there are no fields included to extract the following google feed tags:

- gender
- age_group
- color
- size
- material
- pattern

These tags are now required for apparel products in US and maybe in future in other countries too.

The fields can be individually activated in admin/configuration to show only on admin site (enough to be included in google feeds) or admin + catalog (product_info.php only).

There are alternative instructions to include fix values for all products of your shop, or category based values for the 'gender' and 'age_group' tags.


Hope this helps
Rainer

#233 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 04 April 2012, 08:38

New version uploaded here:

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

Version 2.1 added:
color tag: - function added to read color values from product options
size - function added to read size values from product options

Includes caracter stripping, for example if reference numbering like 1-black, 2-white etc. is used.

regards
Rainer

#234 Lexi

  • Community Member
  • 30 posts
  • Real Name:Lexi

Posted 04 April 2012, 16:19

If someone can please & thank you help me I would so greatly appreciate it..

I have installed this great contribution but I seem to have one issue, when I go into my google account and do a test feed everything seems ok until the end where it says * error - feed file is in a format that we don't support: HTML

I don’t get how so I contacted google and advised them that the feed format does show google-product-search-feed-us-en.txt - they replied....
Please know that you have given correct extension to your data feed, however it is in HTML format. So questions is what did I not do correctly and or how can I change this to the correct file format for google, I have looked over the instructions and did a search for an answer but I cannot seem to find a solution to as what I have done incorrectly.

Thanks,
Lexi

Edited by Lexi, 04 April 2012, 16:19.


#235 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 04 April 2012, 21:27

View PostLexi, on 04 April 2012, 16:19, said:

If someone can please & thank you help me I would so greatly appreciate it..

I have installed this great contribution but I seem to have one issue, when I go into my google account and do a test feed everything seems ok until the end where it says * error - feed file is in a format that we don't support: HTML

I don’t get how so I contacted google and advised them that the feed format does show google-product-search-feed-us-en.txt - they replied....
Please know that you have given correct extension to your data feed, however it is in HTML format. So questions is what did I not do correctly and or how can I change this to the correct file format for google, I have looked over the instructions and did a search for an answer but I cannot seem to find a solution to as what I have done incorrectly.

Thanks,
Lexi


Hello,

The feed generated by this contribution is text format as you see by the extention ..h-feed-us-en.txt
First be shure you didn't change the file extension from: ..h-feed-us-en.txt to..h-feed-us-en.htm or ..h-feed-us-en.html
in line 17 of the configuration file:
'filename' => 'google-product-search-feed-us-en.txt',

If this is ok try this:
In Google Merchant Center, go to Data Feeds, then edit the configuration of your data feed, change: file format from "automatic detection" to "text".
Some terms may be different, I translated this from spanish version.
If this doesn't help, send me your feed configuration file and your data feed, I'll see what I can do.

My mail: info@sarplataygemas.com
regards
Rainer

Edited by raiwa, 04 April 2012, 21:36.


#236 Lexi

  • Community Member
  • 30 posts
  • Real Name:Lexi

Posted 05 April 2012, 04:12

Hi Rainer,

You are a genius if I could hug you I would - you really saved me on this as I was at my wits end trying to figure out what I could have done wrong. The feed was set correctly so I did what you suggested about going into the google merchant center and I changed it from automatic detection to text and that worked. It is a shame that google's own people didn't know enough to suggest that to me. So I did the upload and it worked like a charm but now I got some Item Warnings... - Rainer do happen to know what I could do to fix these by chance?

Thank You!
Lexi

1) Missing recommended attribute: brand (2908 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available. brand

2) Missing recommended attribute: google product category (2290 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
google product category

3) Unknown 'google product category' value(618 warnings, only affecting Product Search, Search API for Shopping)
The 'google product category' value must be a recognized product category in the content language or in English.

google product category Google > Category > Tree4

4) Missing recommended attribute: mpn(4 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

mpn

Edited by Lexi, 05 April 2012, 04:14.


#237 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 05 April 2012, 06:51

View PostLexi, on 05 April 2012, 04:12, said:

Hi Rainer,

You are a genius if I could hug you I would - you really saved me on this as I was at my wits end trying to figure out what I could have done wrong. The feed was set correctly so I did what you suggested about going into the google merchant center and I changed it from automatic detection to text and that worked. It is a shame that google's own people didn't know enough to suggest that to me. So I did the upload and it worked like a charm but now I got some Item Warnings... - Rainer do happen to know what I could do to fix these by chance?

Thank You!
Lexi

1) Missing recommended attribute: brand (2908 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available. brand

2) Missing recommended attribute: google product category (2290 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
google product category

3) Unknown 'google product category' value(618 warnings, only affecting Product Search, Search API for Shopping)
The 'google product category' value must be a recognized product category in the content language or in English.

google product category Google > Category > Tree4

4) Missing recommended attribute: mpn(4 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

mpn


Hello,

sorry but it seems you didn't adjust the configuration file for your needs.
Read the instructions for these tags where you get the errors.

regards
Rainer

#238 raiwa

  • Community Member
  • 28 posts
  • Real Name:Rainer Schmied

Posted 05 April 2012, 09:38

View Postraiwa, on 05 April 2012, 06:51, said:

Hello,

sorry but it seems you didn't adjust the configuration file for your needs.
Read the instructions for these tags where you get the errors.

regards
Rainer

Hello again, I got a while to add some more concrete recomendations:

1.- for the brand tag:

It seems you don't use manufacturers in your shop.
See Step 4 in the instructions and use a fix brand for all products:

									   'brand'			=>   array('output' => 'My Own Brand', //Put here your proper Brand
																	 'type' => 'VALUE',
																	),

2.- for the google category tag, Missing recommended attribute: google product category:

It seems you didn't link ALL your shop categories to google categories.

See Step 6 in the instructions and add the links for the missing categories:

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) ? '':
		 ''))))))))))))))))))));
}


3.- for the google category tag Unknown 'google product category' value:

In the lines you don't use leave the right side blank like here:

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

4) for the mpn tag, Missing recommended attribute: mpn(4 warnings):

it seems you didn't fill out the 'model' field for 4 products.


If you still get errors, please quote the code of your configuration file,
or mail it together with your feed file.

My mail: info@sarplataygemas.com
regards
Rainer

#239 Lexi

  • Community Member
  • 30 posts
  • Real Name:Lexi

Posted 06 April 2012, 00:59

Ok will try the above, and get back to you and again thank you Rainer!!! :)

Lexi

#240 mcbsolutions

  • Community Member
  • 164 posts
  • Real Name:Steve Walker
  • Gender:Male

Posted 11 May 2012, 14:28

View PostSpongeMaximus, on 28 June 2011, 14:02, said:

Hi all,

I've set up a cron job to run feedmachine_auto.php once a night at 11:30pm, and I know the cron is working because I also set it to email me upon completion, and the e-mails are coming through. The problem is that feedmachine_auto.php isn't updating or uploading any feeds. This is the result I get, it's the same whether the cron job runs it or I run it manually from the shell:

-----------------------
Feedmachine Report
-----------------------

start time: 2011-06-28 09:53:52 EDT
end time: 2011-06-28 09:53:52 EDT
runtime: 0.024120807647705


GLOBAL UPDATE TRIGGERS
----------------------
(no global update triggers)

NOTICES
-------
(no notices)

						F   E   E   D   S

Google Product Search
------------
update status: feed not updated(0)
upload trigger status: feed upload not triggered(0)
upload status: feed was not uploaded(0)

(etc. all other feed results are the same, not updated and not uploaded)

Any idea what's going wrong? I made sure that the appropriate folders have execute and write permissions where applicable, so I don't think that's it. I even tried commenting out the part in feedmachine_auto.php that refuses to update the feeds if there's a catalog update in progress, etc.:

//check to see if the catalog is currently being updated
/*$last_updated_date = max(array($global_current_info['products_last_updated']['value'], $global_current_info['specials_last_updated']['value'], $global_current_info['categories_last_updated']['value']));
if( $last_updated_date > (time()-FM_AUTO_GRACE_PERIOD_MINUTES*60) && $last_updated_date < (time()+FM_AUTO_GRACE_PERIOD_MINUTES*60) && !$force_update ) {
  echo 'Catalog is currently being updated: not generating or sending feeds.';
tep_exit();*/
}
Still no go. I can still manually update/upload the feeds in the Feedmachine admin section of my site, just not with feedmachine_auto.php. Thoughts?

Hi, I'm having same issue running a cron job. The cron job runs but the report says
update status: feed not updated(0)
upload trigger status: feed upload not triggered(0)
upload status: feed was not uploaded(0)

I have to upload manually for time being. What am I missing here? I'm running the version for Osc 2.2 which is v 5.03 it appears. Thanks!!