Guest Posted September 6, 2008 Posted September 6, 2008 Hi hope someone out there can give us some support or point me to the right thread, have spent hours trawling through the easy populate threads to find this. I want to modify the custom download to include more fields thatn just the product id and End of line data, having looked at the easy populate file I am not sure what I am supposed to put where. I have a list of the headers I need, some will be filled in as blanks, the others I have cross referenced with froogle and easpopulate complete downloads. headers to be as ## Your product ref Short Description Long Description Product Variation 1 Product Variation 2 Product Variation 3 Product Variation 4 Review Title Review Text Manufacturer Model Classification MainGraphicfilename ThumbnailGraphicfilename Additional Graphic 1 filename Additional Graphic 2 filename Gift Tag Gift wrap price excl. VAT KeyWords Vat Code Price Special Price Special Price Start Date Special price End Date Availability Quantity in stock Stock Control Exportable Shipping weight UK Shipping charge EU Shipping charge ROW Shipping charge Webshop category 1 ID No Webshop category 2 ID No Webshop category 3 ID No Webshop category 4 ID No Webshop category 5 ID No Lead Time Date Available WAP Short Description WAP Long Description ## Cross referenced easy populate (v_blah_blah easy pop complete, category and image_link (image_url) from froogle easy pop download, all others are auto fill with same value) ## v_products_model v_products_name_1 v_products_description_1 blank for now blank for now blank for now blank for now blank for now blank for now v_manufacturers_name blank for now blank for now image_link blank for now blank for now blank for now 0 0 category G v_products_price 0 0 0 0 0 0 1 v_products_weight blank for now blank for now blank for now blank for now blank for now blank for now blank for now blank for now blank for now blank for now blank for now blank for now ## If I can get this setup, then I can look at downloading the different attributes, and the extra prices involved if any, but one setp at a time, and having this download will save me time. If you require more information please let me know by e-mail to [email protected] Thanks Wayne
♥geoffreywalton Posted September 6, 2008 Posted September 6, 2008 I want to modify the custom download to include more fields thatn just the product id and End of line data, Did you tick the option fields to get them on the file? These are the standard fields you can have. name description url image attributes categories manufacturer price quantity weight tax class available date added status Any others and you would need to amend easypopulate.php to get the data and output it. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Guest Posted September 6, 2008 Posted September 6, 2008 Hi, Have not done anything with the custom download, just changed a few things in the froogle one to make it compatible with the new base and to stop me from having messing around so much. things can be improved but this isnt so important. there was nothing to select? I need to create a download for edirectory, having gone through the easypopulate.php file, I have managed to create the drop down lists etc for edirectory. So Now I can click on edirectory, but nothing will happen because I have not set anything in the easy populate to download for edirectory I just need to know how to setup things up to download each record in my database with the correct headings in place for Edirectory, as shown in first post, already have a list of fields that would give me the right information its knowing how to code it up to download in the correct format. Thanks
♥geoffreywalton Posted September 7, 2008 Posted September 7, 2008 You could see how it does it for another file such as product extra fields and "dulicate" the code. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Guest Posted September 7, 2008 Posted September 7, 2008 Hi, looking at code but it does not make much sense to me at the moment. Whilst on the easypopulate subject. I currently have a full category problem within my froogle download, the problem is I get Main cat > Sub cat in categories column, but then subsequent sub categories get put into the next column and move all the subsequent data on one per extra sub category:- the code thats responsible as far as I can tell is:- // for the categories, we need to keep looping until we find the root category // start with v_categories_id // Get the category description // set the appropriate variable name // if parent_id is not null, then follow it up. // we'll populate an aray first, then decide where it goes in the $thecategory_id = $row['v_categories_id']; $fullcategory = ''; // this will have the entire category stack for froogle for( $categorylevel=1; $categorylevel<$max_categories+1; $categorylevel++){ if ($thecategory_id){ $sql2 = "SELECT categories_name FROM ".TABLE_CATEGORIES_DESCRIPTION." WHERE categories_id = " . $thecategory_id . " AND language_id = " . $epdlanguage_id; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); // only set it if we found something $temprow['v_categories_name_' . $categorylevel] = $row2['categories_name']; // now get the parent ID if there was one $sql3 = "SELECT parent_id FROM ".TABLE_CATEGORIES." WHERE categories_id = " . $thecategory_id; $result3 = tep_db_query($sql3); $row3 = tep_db_fetch_array($result3); $theparent_id = $row3['parent_id']; if ($theparent_id != ''){ // there was a parent ID, lets set thecategoryid to get the next level $thecategory_id = $theparent_id; } else { // we have found the top level category for this item, $thecategory_id = false; } //$fullcategory .= " > " . $row2['categories_name']; $fullcategory = $row2['categories_name'] . " > " . $fullcategory; } else { $temprow['v_categories_name_' . $categorylevel] = ''; } } // now trim off the last ">" from the category stack $row['v_category_fullpath'] = substr($fullcategory,0,strlen($fullcategory)-3); so need to work out how to get all the main and sub categories for each product to sit in the one colun so we get main cat >subcat1 > sub cat2 >subcat3 etc etc can anyone advise?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.