Guest Posted July 8, 2006 Posted July 8, 2006 Please bear with me, I'm a shop owner, not a coder! I have been trying to figure out how to change my Froogle feed output from the Easy Populate module. My store's product database is created from a datafeed upload from my dropshipper, so the descriptions are already pre-set. However, I would like to revise the Froogle datafeed to include extra text in the description. Description is it is now: "Launched by the design house of Gucci in 1995, ......" Changed to: "FREE SHIPPING with $75 order! Launched by the design house...." I have been manually changing my store.txt file in Wordpad using Replace All after generating the Froogle feed .txt file before uploading it to Froogle. However, my store is very large and it usually takes several hours for this to complete. Is there a way to change the Easy Populate file to do this automatically? This is strictly for Froogle, so I don't want to change the product descriptions on the website itself. Thanks! Quote
susitha7000 Posted September 14, 2010 Posted September 14, 2010 Please bear with me, I'm a shop owner, not a coder! I have been trying to figure out how to change my Froogle feed output from the Easy Populate module. My store's product database is created from a datafeed upload from my dropshipper, so the descriptions are already pre-set. However, I would like to revise the Froogle datafeed to include extra text in the description. Description is it is now: "Launched by the design house of Gucci in 1995, ......" Changed to: "FREE SHIPPING with $75 order! Launched by the design house...." I have been manually changing my store.txt file in Wordpad using Replace All after generating the Froogle feed .txt file before uploading it to Froogle. However, my store is very large and it usually takes several hours for this to complete. Is there a way to change the Easy Populate file to do this automatically? This is strictly for Froogle, so I don't want to change the product descriptions on the website itself. Thanks! HI Can you help me. I need to modify my Froogle input/output file format. I need my Attributes in it too... If you know pls help me or just give me one sampls line of code to work with :( Right now i am geting only "link title description price image_link id quantity product_type expiration_date currency EOREOR" My Attributes (Product Options) are Size 2 Color 3 Clarity 4 Cut Quote
susitha7000 Posted September 14, 2010 Posted September 14, 2010 Please bear with me, I'm a shop owner, not a coder! I have been trying to figure out how to change my Froogle feed output from the Easy Populate module. My store's product database is created from a datafeed upload from my dropshipper, so the descriptions are already pre-set. However, I would like to revise the Froogle datafeed to include extra text in the description. Description is it is now: "Launched by the design house of Gucci in 1995, ......" Changed to: "FREE SHIPPING with $75 order! Launched by the design house...." I have been manually changing my store.txt file in Wordpad using Replace All after generating the Froogle feed .txt file before uploading it to Froogle. However, my store is very large and it usually takes several hours for this to complete. Is there a way to change the Easy Populate file to do this automatically? This is strictly for Froogle, so I don't want to change the product descriptions on the website itself. Thanks! Hi can you help me to modify my froogle out (ADD-on: Easy Populate & Products Attributes) put colums... I would like to get my product attributes like "Product Options" on each colum. They are 1 Size 2 Color 3 Clarity 4 Cut Pls HELP! I think the edit must be done some where here but don't know what to look for :( case 'froogle': // this is going to be a little interesting because we need // a way to map from internal names to external names // // Before it didn't matter, but with froogle needing particular headers, // The file layout is dynamically made depending on the number of languages $iii = 0; $filelayout = array(); $filelayout['v_froogle_products_url_1'] = $iii ; $filelayout['v_froogle_products_name_'.EP_DEFAULT_LANGUAGE_ID] = $iii ; $filelayout['v_froogle_products_description_'.EP_DEFAULT_LANGUAGE_ID] = $iii ; $filelayout['v_products_price'] = $iii ; $filelayout['v_products_fullpath_image'] = $iii ; $filelayout['v_froogle_product_id'] = $iii ; $filelayout['v_froogle_quantitylevel'] = $iii ; $filelayout['v_category_fullpath'] = $iii ; $filelayout['v_froogle_exp_date'] = $iii ; $filelayout['v_froogle_currency'] = $iii ; $iii=0; $fileheaders = array(); // EP Support mapping new names to the export headers. // use the $fileheaders[''] vars to do that. $fileheaders['link'] = $iii ; $fileheaders['title'] = $iii ; $fileheaders['description'] = $iii ; $fileheaders['price'] = $iii ; $fileheaders['image_link'] = $iii ; $fileheaders['id'] = $iii ; $fileheaders['quantity'] = $iii ; $fileheaders['product_type'] = $iii ; $fileheaders['expiration_date'] = $iii ; $fileheaders['currency'] = $iii ; $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_added, p.products_date_available as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM ".TABLE_PRODUCTS." as p, ".TABLE_CATEGORIES." as subc, ".TABLE_PRODUCTS_TO_CATEGORIES." as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id " . $sql_filter; break; // VJ product attributes begin case 'attrib': $iii = 0; $filelayout = array(); $filelayout['v_products_model'] = $iii ; $attribute_options_count = 1; foreach ($attribute_options_array as $tkey1 => $attribute_options_values) { $filelayout['v_attribute_options_id_'.$attribute_options_count] = $iii ; foreach ($languages as $tkey => $lang ) { $filelayout['v_attribute_options_name_'.$attribute_options_count.'_'.$lang['id']] = $iii ; } $attribute_values_query = "select products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$attribute_options_values['products_options_id'] . "' order by products_options_values_id"; $attribute_values_values = tep_db_query($attribute_values_query); $attribute_values_count = 1; while ($attribute_values = tep_db_fetch_array($attribute_values_values)) { $filelayout['v_attribute_values_id_'.$attribute_options_count.'_'.$attribute_values_count] = $iii ; foreach ($languages as $tkey2 => $lang ) { $filelayout['v_attribute_values_name_'.$attribute_options_count.'_'.$attribute_values_count.'_'.$lang['id']] = $iii ; } $filelayout['v_attribute_values_price_'.$attribute_options_count.'_'.$attribute_values_count] = $iii ; //// attributes stock add start if ( EP_PRODUCTS_ATTRIBUTES_STOCK == true ) { $header_array['v_attribute_values_stock_'.$attribute_options_count.'_'.$attribute_values_count] = $iii ; } //// attributes stock add end $attribute_values_count ; } $attribute_options_count ; } $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model FROM ".TABLE_PRODUCTS." as p "; break; // VJ product attributes end } $filelayout_count = count($filelayout); return array($filelayout, $filelayout_count, $filelayout_sql, $fileheaders);} Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.