Jump to content
Latest News: (loading..)

stu2000

Members
  • Content count

    460
  • Joined

  • Last visited

2 Followers

About stu2000

  • Birthday 01/02/1974

Profile Information

  1. a sneaky bump :rolleyes:
  2. Hi all, I have a customer, who has over 20 different category main headers and would like it displayed over 2 or 3 columns instead of the default one long one. Is this an easy task or is there a contrib available to do this. Thanx
  3. Hi Surfalot, if I upload the sample file in the contrib it works 100%, but if I make the smallest change (i.e change th price or something) then upload it, it adds products all over the place. Now it must be the way I am saving the file. I am using Excel 2003, then when I save file, I choose CSV (MS-DOS), then I am prompted with the following: Sample_Output_file.csv may contain features that are not compatible with CSV (MS-DOS). Do you want to keep the workbook in this format? To keep this format, which leaves out any incompatible features, click yes, or to Preserve the features, click NO. Now no matter what I choose yes or no, the file always uploads fine but the products are not in the correct category, but If I upload the unmodified sample file it works fine. I have tried this with openoffice and the same thing, so it must be something I am doing wrong. Can someone please help? I have entered the products in manually also and then download the "complete" file and changed the price and when I upload it , again it gives me duplicate products. It has to be the way I am doing it. When I upload the below 10 product .csv file, it places 10 products into "Heartsbox" Category, 4 products into 2009 Valetines Collections Category (Bustier, g-string and stockings with skull print. / Lace bra top and matching booty shorts / Bustier, g-string and stockings with skull print. & Lycra strappy teddy with O rings. ) 2 products into Beyond Dark Category (Bustier, g-string and stockings with skull print - Queen Size / Cami set, with skull print.) ============= CSV File : here EP vers: 2.76g osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.24.7 HTTP: Apache DB: MySQL 5.0.45-log PHP: 4.4.7 (Zend: 1.3.0) Temp Directory: /hermes/web01/b1438/pow.kbleyth/htdocs/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 30 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 3 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false File uploaded. Temporary filename: /tmp/phpvtCjRg User filename: EP-HeartsBox Collection-test.csv Size: 3493 | EM7766 | Long sleev | Long sleev | | 7766.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | 12 | Red | 0 | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7762 | Long sleev | Long sleev | | 7762.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | 12 | Red | 0 | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7760 | Off the sh | Off the sh | | 7760.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | 12 | Red | 0 | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7760Q | Off the sh | Off the sh | | 7760Q.jpg | 28.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 5 | Queen | 0 | Taxable Go | Active !New Product! | EM7759 | Lace bra t | Lace bra t | | 7759.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7756 | Lace thong | Lace thong | | 7756.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7775 | Lycra stra | Lycra stra | | 7775.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7804 | Bustier, g | Bustier, g | | 7804.jpg | 27.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! | EM7804Q | Bustier, g | Bustier, g | | 7804Q.jpg | 28.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 5 | Queen | 0 | Taxable Go | Active !New Product! | EM7805 | Cami set, | Cami top, | | 7805.jpg | 26.99 | 25 | 1.5 | 01/11/2009 | 01/11/2009 | | HeartsBox | | For Her | | | | 1 | Color | 11 | Black | 0 | | | | 2 | Size | 25 | One Size | 0 | Taxable Go | Active !New Product! Have tried with define ('EP_EXCEL_SAFE_OUTPUT_ALT_PARCE', true); // default is: false and also set to false, but makes no diffence. http://bytesnkisz.com/
  4. Need some advice, I am trying to add 10 test products, but whenever I upload them using EP, it seems to add 17 products instead. The 10 test products have attributes and the 3 of them have a comma in the title and description, will this cause problems?, I am using MS Excel 2003. I have created a "complete" template, editted it and then saved it as a ms-dos csv and also as a csv file format, but still it always gives me 17 products. I have also manually added the 10 products into the store, then created the template to compare, its the same, when I upload the manual entered products csv, this then gives me the same 17 products, the out come of the below csv can be seen at my customers website site here: http://www.bytesnkisz.com/index.php Here are my details: CSV File : here EP vers: 2.76g osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.24.7 HTTP: Apache DB: MySQL 5.0.45-log PHP: 4.4.7 (Zend: 1.3.0) Temp Directory: /hermes/web01/b1438/pow.kbleyth/htdocs/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 30 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 3 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false Any help is appreciated.
  5. The newer version 3.00+ are the same as 2.76g but with better install instructions, so if you have tried it with your version and it does not work, the neewer ones unfortunately won't make any difference. Hope this helps.
  6. Version 3.0.0 is just version 2.76d converted into html document wise and added a new easypopulate_help.php file. Hope this helps
  7. Added a new release of EP to the contribs section, its the same coding as Surfalots contribs but added a new file to the admin section that includes an online help section, basically, converted the support documentation into php and made viewable from the admin section, also combined all the documentation into one html file for easier viewing etc. Any problems let me know.
  8. Hi Jim, I won't steal your thunder, its all your work, the onloy thing I would do different with my code above is make it langauge independant, its set for english only, but a few changes to the defines, then it could be completely language universal, the script above is for a customers store of mine and they only sell in the UK, so english is all thats required. If I have time, will change it to be universal.
  9. If anyone is interested, here is my change_password.php file with a few cosmetic changes and the ability now to automatically email the customer with the new password (please note I have removed (commented out) the auto password generation) <?php /* $Id: change_password.php,v 3.0 11/23/2007 kymstion osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2007 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // Include the password functions require(DIR_WS_FUNCTIONS . 'password_funcs.php'); // Include the language definitions require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHANGE_PASSWORD); // // POST target -- the POST form has been sent to change a password // If a password change has been submitted, check the results for errors $pass = 0; if ($_POST['customer_id'] != '') { $customer_id = (int)$_POST['customer_id']; if ($_POST['new_password'] == '' && $_POST['repeat_password'] == '') { // Use generated password $pass = 1; $new_password = $_POST['auto_password']; } elseif ($_POST['new_password'] == $_POST['repeat_password']) { // Use custom password $pass = 1; $new_password = $_POST['new_password']; } elseif (empty($_POST['new_password'])) { // Missing password $pass = 2; } elseif (empty($_POST['repeat_password'])) { // Missing repeat password $pass = 2; } elseif ($_POST['new_password'] != $_POST['repeat_password']) { // Mismatched passwords $pass = 3; } // If all is well, make the changes to the database if ($pass == 1) { mysql_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_password='" . tep_encrypt_password ($new_password) . "' WHERE customers_id='" . $customer_id . "'"); // Get the customer's information for the success message $customer_name_query = mysql_query("SELECT customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id='" . $customer_id . "'"); $customer_name = mysql_fetch_array ($customer_name_query); define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password Generated'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is: ' . '%s' . "\n\n" . 'If you did not authorise this, please contact us immediately.' . "\n\n" . STORE_OWNER . "\n" . STORE_OWNER_EMAIL_ADDRESS ); tep_mail($customer_name['customers_firstname'] . " " . $customer_name['customers_lastname'], $customer_name['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $new_password)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } // End POST section // // GET target -- a GET form has been sent // Build a SQL string from the Search or Customer variables $search_string = ''; if (isset ($HTTP_GET_VARS['search']) && strlen ($HTTP_GET_VARS['search']) > 1) { $keywords = tep_db_input (tep_db_prepare_input ($HTTP_GET_VARS['search'])); $search_string = "where customers_lastname like '%" . $keywords . "%' or customers_firstname like '%" . $keywords . "%' or customers_email_address like '%" . $keywords . "%'"; } elseif (isset ($HTTP_GET_VARS['customer'])) { $customer_id = (int)$HTTP_GET_VARS['customer']; $search_string = "WHERE customers_id='" . $customer_id . "'"; } // End GET section // // Variable fields to insert into the page // Build an array of customers for the select pulldown $customer_data_query = mysql_query("SELECT customers_id, customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " " . $search_string . " ORDER BY customers_lastname, customers_firstname "); $customers_array = array(); while ($customer_data = mysql_fetch_array ($customer_data_query) ) { $customers_array[] = array('id' => $customer_data['customers_id'], 'text' => $customer_data['customers_firstname'] . ' ' . $customer_data['customers_lastname'] . ' (' . $customer_data['customers_email_address'] . ')' ); } // Set the correct message to display for password change or errors $message = ''; switch ($pass) { case 1: $message = '<b><font color=#009900>'; $message .= CUSTOMER_PASSWORD . $customer_name['customers_firstname'] . ' ' . $customer_name['customers_lastname']; $message .= PASSWORD_UPDATED . ' <font color=red>' . $new_password . '</font><br>An Email has been sent to ' . $customer_name['customers_firstname'] . ' ' . $customer_name['customers_lastname'] . ' to verify this change.<br>'; $message .= '</b></font><br>' . tep_black_line(); break; case 2: $message = '<b><font color=#ff0000>'. PLEASE_NEW_PASSWORD . PLEASE_REPEAT . '</b></font>'; break; case 3: $message = '<b><font color=#ff0000>'. ERROR_NEW_PASSWORD . PLEASE_REPEAT . '</b></font>'; break; case 0: default: $message = ' '; break; } // Set up the search form $search_form = tep_draw_input_field ('search'); $search_form .= tep_draw_hidden_field ('selected_box', 'customers'); $search_form .= tep_hide_session_id(); // Generate a random password and add it to the form $auto_password = tep_create_random_value (ENTRY_PASSWORD_MIN_LENGTH); $auto_form = tep_draw_hidden_field ('auto_password', $auto_password) . $auto_password; ?> <!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"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <?php if ($message != ' ') { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo $message; ?></td> </tr> </table></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php echo tep_draw_form ('search', FILENAME_CHANGE_PASSWORD, '', 'get'); ?> <table border="0" width="600px" cellspacing="0" cellpadding="2"> <tr> <td width="170"><?php echo tep_draw_separator('pixel_trans.gif', '170', '1'); ?></td> <td width="150"><?php echo tep_draw_separator('pixel_trans.gif', '150', '1'); ?></td> <td width="280"><?php echo tep_draw_separator('pixel_trans.gif', '280', '1'); ?></td> </tr> <tr> <td class="main" colspan="3"><?php echo TEXT_SEARCH_INSTRUCTION; ?><br></td> </tr> <tr> <td width="170" class="main"><b><?php echo SEARCH; ?></b></td> <td width="150" class="main"><?php echo $search_form; ?></td> <td width="280" class="main"><?php echo tep_image_submit ('button_search.gif', IMAGE_SEARCH); ?></td> </tr> </form></table></td> </tr> <tr> <td><?php echo tep_draw_form ('password', FILENAME_CHANGE_PASSWORD, 'selected_box=customers', 'POST'); ?> <table border=0 width="600px" cellspacing="0" cellpadding="2"> <tr> <td width="170" class="main"><b><font color=red>OR</font><br><br><?php echo SELECT_CUSTOMER; ?></b><br><br></td> <td width="450" class="main"><br><br><?php echo tep_draw_pull_down_menu('customer_id', $customers_array);; ?><br><br></td> </tr> <tr> <td class="main"><b><?php echo NEW_PASSWORD; ?></b></td> <td class="main"><?php echo tep_draw_password_field('new_password'); ?></td> </tr> <tr> <td class="main"><b><?php echo REPEAT_NEW_PASSWORD; ?></b></td> <td class="main"><?php echo tep_draw_password_field('repeat_password'); ?></td> </tr> <!-- <tr> <td class="main"><b><?php echo AUTO_PASSWORD; ?></b></td> <td class="main"><?php echo $auto_form; ?></td> </tr> --> <tr> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '170', '1'); ?></td> <td><?php echo tep_image_submit ('button_change_password.gif', IMAGE_CHANGE_PASSWORD); ?></td> </tr> </form></table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> A big thank you to Jim Keebaugh, for his help in completing this modification :)
  10. Thank you, it works now, using the following code: // If all is well, make the changes to the database if ($pass == 1) { mysql_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_password='" . tep_encrypt_password ($new_password) . "' WHERE customers_id='" . $customer_id . "' "); // Get the customer's information for the success message $customer_name_query = mysql_query("SELECT customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " WHERE customers_id='" . $customer_id . "' "); $customer_name = mysql_fetch_array ($customer_name_query); define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is:' . "\n\n" . ' %s' . "\n\n"); tep_mail($customer_name['customers_firstname'] . " " . $customer_name['customers_lastname'], $customer_name['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $new_password)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } Email received: A new password was requested for your account at Company Name. Your new password to 'Company Name' is: 12345 Just need to do a few cosmetic changes etc and should be perfect.
  11. Trying for the last 30 minutes to insert the above code, I think it should go in change_password.php after lines 100 but it don't work, can anyone see anything obciously wrong. // Set the correct message to display for password change or errors $message = ''; switch ($pass) { case 1: $message = '<b><font color=#009900>'; $message .= CUSTOMER_PASSWORD . $customer_name['customers_firstname'] . ' ' . $customer_name['customers_lastname']; $message .= PASSWORD_UPDATED . ' ' . $new_password . '<br>' . PASSWORD_UPDATED_REMINDER; $message .= '</b></font><br>' . tep_black_line(); define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is:' . "\n\n" . ' %s' . "\n\n"); tep_mail($customer_data['customers_firstname'] . " " . $customer_data['customers_lastname'], $customer_data['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $newpass)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); break; also tried after line 57 // If all is well, make the changes to the database if ($pass == 1) { mysql_query("UPDATE " . TABLE_CUSTOMERS . " SET customers_password='" . tep_encrypt_password ($new_password) . "' WHERE customers_id='" . $customer_id . "' "); // Get the customer's information for the success message $customer_name_query = mysql_query("SELECT customers_firstname, customers_lastname FROM " . TABLE_CUSTOMERS . " WHERE customers_id='" . $customer_id . "' "); $customer_name = mysql_fetch_array ($customer_name_query); define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is:' . "\n\n" . ' %s' . "\n\n"); tep_mail($customer_data['customers_firstname'] . " " . $customer_data['customers_lastname'], $customer_data['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $newpass)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } } no emails ever received.
  12. Is there anyway, that the code can be changed to automatically email the new password to the user (as a confirmation), this will alert the customer to any unauthroised attempts to change passwords etc. i.e. define('EMAIL_PASSWORD_REMINDER_SUBJECT', STORE_NAME . ' - New Password'); define('EMAIL_PASSWORD_REMINDER_BODY', 'A new password was requested for your account at ' . STORE_NAME . '.' . "\n\n" . 'Your new password to \'' . STORE_NAME . '\' is:' . "\n\n" . ' %s' . "\n\n"); define('TEXT_PASSWORD_SENT_TO_CUST', 'New Password Sent To The Customers E-Mail Address'); tep_mail($customer_data['customers_firstname'] . " " . $customer_data['customers_lastname'], $customer_data['customers_email_address'], EMAIL_PASSWORD_REMINDER_SUBJECT, nl2br(sprintf(EMAIL_PASSWORD_REMINDER_BODY, $newpass)), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
  13. Has anyone got this too work with RCA2, if so can they post there admin/categories.php file and catimagessetup.php files please. Getting no pictures added, warning file location does not exist
  14. Thx will give it a shot
  15. Hi all, just out on the web I came across this site: http://www.auctionpax.co.uk/packaging/mail...s-c-74_123.html Can OSC do this, which contrib would allow different sizes on one info page and allow checkout.
×