JangoF

Thanks again. I think I found another weird issue. When I try to export using the following url, it exports only inactive products. Any idea why? easypopulate.php?download=tempfile&dltype=custom&epcust_status_filter=active&epcust_name=show&epcust_description=show&epcust_image=show&epcust_category=show&epcust_price=show&epcust_quantity=show&epcust_status=show

You could always use this excellent contribution: http://www.oscommerce.com/community/contributions,5273

Thanks for the help surfalot, I guess I was half-way sleeping! :blush: One more question: How can I export only products that have 2 or more quantity? Would this require some modification in the code? If so, where?

I almost got it now! For anyone looking for a partial solution: Find at line 1653: case 'full', and one some lines below comment out: $filelayout['v_products_url_'.$lang['id']] = $iii++; $filelayout['v_products_weight'] = $iii++; $filelayout['v_date_avail'] = $iii++; $filelayout['v_date_added'] = $iii++; $filelayout['v_categories_image_' . $i] = $iii++; $filelayout['v_manufacturers_name'] = $iii++; However, I am unsure how to only include the categories v_categories_name_1_1 and v_categories_name_2_1, and how to only include active products. Any solution?

Got a question related to the export function: I am using Easy Populate 2.76h-MS2 (with attributes) surfalot 13 Feb 2009, works excellent out of the box with all functions. What I am trying to do is make a cron job that exports the products automatically at certain intervals to a tab-separated file. I don't think "Export EP or Froogle Products File" can do this, as the information is passed through a form, but "Create Complete .txt file in temp dir" can be run from cron because it passes it through an URL. Here's my problem though: I don't want all fields included, so does anyone know where in easypopulate.php I can modify this? The fields I would like to use is only: v_products_model v_products_name_1 v_products_description_1 v_products_image v_products_price v_products_quantity v_categories_name_1_1 v_categories_name_2_1 v_status (only Active products)

I thought this was supposed to be a single page checkout, for instance: page #1: enter details, press confirm page #2: checkout success ...but it really isn't. Fast Easy Checkout does this already and it does it well.

I'm using FEC 3.2 with Paypal Express and CC as payment methods, and I'm trying to limit the methods available depending on what users do. For instance, I have the Paypal Express button placed at the login- and shoppingcart-pages. When the user returns from paypal to checkout_shipping, the paypal method is automatically set. If the user does this, cc should be hidden. If the user chooses to go straight to the normal checkout, paypal express should be hidden. But, when I try to add an if-clause in checkout_shipping.php the page loads until it times out: I replace this: require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment; With this: if ($payment == "ppec")) { require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment("ppec"); } else { require(DIR_WS_CLASSES . 'payment.php'); $payment_modules = new payment("cc"); } Anyone know why this does not work?

I just installed this on a testsite before transferring over to live, but doesn't it seem strange to anyone that the stock update is commented out? When I go through with test orders, the stock is in fact not depleted by 1 for the item. Just a FYI, someone should check this, because it could cause some serious problems in your store. Edit: Easy to fix though, just uncomment the stock code in ppeb.php

This worked for me, thanks a lot! Before adding this fix, all I got was a blank screen when trying to edit orders.

I never expected to see my little contribution getting so many post fixes/releases, that's nice to see. I realize that when I first added the initial release, a lot of things were missing and/or could cause problems for vanilla users, because I use such a heavily modded store. I don't even use the left admin menu, but a horizontal top menu. But I just wanted to drop in and say thanks to everyone for keeping it alive. Especially Sam/spooks here. Btw, I am also a huge fan of Blade Runner! B)

While I haven't seen your work yet, I don't think it's sloppy. I think it sounds like a much needed improvement ;) The language definition files isn't so hard to do: require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AUCTONS); (must be in includes\filenames.php) Then instead of the actual text you use ' . TEXT_WHATEVER . ' in the files. In includes\languages\english\auctions.php, add definition for each text: define('TEXT_WHATEVER', 'Auctions Whatever'); That's basically it.

Well I don't know exactly what kind of changes you made Dan, but they sound extensive. From my standpoint I would suggest you call it version 2.0, and instead of listing all the changes and improvements you have done, list; - Current Features - Comparison of Before and After - Known/Remaining Bugs - (To-Do (for any future updates you might have planned after release, if any)) EDIT: As for installation, I wouldn't mind helping documenting changes and/or testing it. Just a suggestion :)

That's very great work psylencer! I hope to see this contribution functional in the soon-future. ;)

Nevermind, I figured I would leave it at just featured on/off and just not use the javascript calendar. :)

Hi surfalot, I installed your contribution and it works simply marvelous ;) I am working on a very small tool that let's you search for a product, then you can go to the next page to quickly edit it. Although I haven't really started on the update-product part, it works great. Only small problem I have is to insert the calendar for 'featured until date available' (I get a small javascript error), and was wondering if you could take a quick look? Here is the code (it can easily be tested by putting it in /admin and entering ?pID=x after the url - x being a product id): <?php require('includes/application_top.php'); require('includes/languages/product_list.php'); require('includes/languages/english/categories.php'); if (isset($HTTP_GET_VARS['pID'])) $HTTP_GET_VARS['pID'] = $pID; $product_query = tep_db_query("select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_briefdesc, p.products_condition, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_featured, p.products_featured_until from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $pID . "' and p.products_id = pd.products_id"); if ($product['products_status'] = '0') $pInfo->products_status = '1'; switch ($pInfo->products_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } if (empty($pInfo->products_featured)) $pInfo->products_featured = '0'; switch ($pInfo->products_featured) { case '0': $in_f_status = false; $out_f_status = true; break; case '1': default: $in_f_status = true; $out_f_status = false; } if($_REQUEST['update']=="update") { while($product1 = tep_db_fetch_array($product_query)) { $str=tep_db_query("update products set products_price='".$_REQUEST['price_'.$product1['products_id']]."',products_weight='".$_REQUEST['weight_'.$product1['products_id']]."', products_quantity='".$_REQUEST['qty_'.$product1['products_id']]."' where products_id='".$product1[products_id]."'"); } header("location:product_list.php?Update=Success&prod_search=".$_REQUEST['prod_search']); } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <link rel="stylesheet" type="text/css" href="includes/javascript/spiffyCal/spiffyCal_v2_1.css"> <script language="JavaScript" src="includes/javascript/spiffyCal/spiffyCal_v2_1.js"></script> <script language="JavaScript"><!-- var ProductsFeaturedUntil = new ctlSpiffyCalendarBox("ProductsFeaturedUntil", "new_product", "products_featured_until","btnDate1","<?php echo $pInfo->products_featured_until; ?>", scBTNMODE_CUSTOMBLUE); //--></script> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();"> <div id="spiffycalendar" class="text"></div> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <?php while($product = tep_db_fetch_array($product_query)) { ?> <td valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading">Edit Product (<?php echo $pID;?>)</td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main">Products Status:</td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_radio_field('products_status', '1', $in_status) . ' ' . TEXT_PRODUCT_AVAILABLE . ' ' . tep_draw_radio_field('products_status', '0', $out_status) . ' ' . TEXT_PRODUCT_NOT_AVAILABLE; ?></td> </tr> <tr> <td class="main">Featured Product:</td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_radio_field('products_featured', '1', $in_f_status) . ' ' . TEXT_PRODUCT_YES . ' ' . tep_draw_radio_field('products_featured', '0', $out_f_status) . ' ' . TEXT_PRODUCT_NO; ?></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Featured Until Date Available:<br><small>(YYYY-MM-DD)</small></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' '; ?><script language="javascript">ProductsFeaturedUntil.writeControl(); ProductsFeaturedUntil.dateFormat="yyyy-MM-dd";</script></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Products Name:</td> <td class="main"><input type="text" name="name_<?php echo $product['products_id'];?>" id="name" value="<?php echo $product['products_name'];?>" size="100"></td> </tr> <tr bgcolor="#ebebff"> <td class="main">Products Price:</td> <td class="main" align="left"><input type="text" name="price_<?php echo $product['products_id'];?>" id="price" value="<?php echo $product['products_price'];?>" size="10"></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main" valign="top">Products Description:</td> <td><table border="0" cellspacing="0" cellpadding="0"> <tr> <td class="main"><textarea name="description_<?php echo $product['products_id'];?>" rows="60" cols="150" id="description"><?php echo $product['products_description'];?></textarea></td> </tr> </table></td> </tr> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Products Quantity:</td> <td class="main"><input type="text" name="qty_<?php echo $product['products_id'];?>" id="qty" value="<?php echo $product['products_quantity'];?>" size="10"></td> </tr> <tr> <td class="main">Products Brief Description:</td> <td class="main"><input type="text" name="briefdesc_<?php echo $product['products_id'];?>" id="briefdesc" value="<?php echo $product['products_briefdesc'];?>" size="100"></td> </tr> <tr> <td class="main">Products Condition:</td> <td class="main"><input type="text" name="condition_<?php echo $product['products_id'];?>" id="condition" value="<?php echo $product['products_condition'];?>" size="10"></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Products Model:</td> <td class="main"><input type="text" name="model_<?php echo $product['products_id'];?>" id="model" value="<?php echo $product['products_model'];?>" size="30"></td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="main">Change Products Image (Without Uploading):</td> <td class="main"><input type="text" name="image_<?php echo $product['products_id'];?>" id="image" value="<?php echo $product['products_image'];?>" size="30"></td> </td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> </table></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <?php } ?> <!-- body_text //--> <?php if($_REQUEST['Update']=="Success") { ?> <tr><td><font color="#FF3333">Record has been updated successfully</font></td></tr> <?php } ?> <tr> <td class="dataTableContent"> <input type="hidden" name="prod_search" value="<?php echo $_REQUEST['prod_search']; ?>"><input type="submit" name="update" value="update"> </td> </tr> </table> </form> </td> </tr> </table> </td> </tr> </table> <!-- body_text_eof //--> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>