Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

analli

Archived
  • Posts

    76
  • Joined

  • Last visited

Everything posted by analli

  1. It really is a great contribution, and a long time coming too. Do you think a comment adding/editing interface will be in the works soon? Anthony
  2. This should be a simple one. On the large Featured Products box on the main page (not the info box in the column) how do I remove the link to the Featured Products page? I want the large box and the title "Featured Products", I just want to remove the ability to click on the Featured Products title and bring up the Featured Products page. Therefore, I'm seeking the area where that link is in order to remove it. Ideas? Thanks, Anthony
  3. Thanks DJ. You're a real champion here. Anthony
  4. I tried very simply to find and replace SUBURB with STREET_ADDRESS2 so that my "Address Continued:" field shows up in the editor instead of Suburb. My assumption was that the find and replace would not only change the field names but the reference to the database as well but it didn't work out that way. How can I as simply as possible remove Suburb and add Address Continued? Thanks, Anthony
  5. Works perfectly! Thanks! Anthony
  6. Parse error: syntax error, unexpected T_STRING in /home/scidac/public_html/catalog/admin/salestracker.php on line 164
  7. Sorry mate. Exactly change WHAT to that line? Anthony
  8. That did fix the problem! One small side effect is that the total now comes out NOT rounded to two decimal places. i.e. $2334.4588. Between the two issues, I can live with this one. Thanks. Anthony
  9. I'm getting various syntax errors mainly relating to remaining or deleted ";" and ")" characters. There seems to be only two places where the string exists. Could you perhaps post line replacements? Anthony
  10. Is that to say remove any line containing that string... the entire line? A
  11. The output is accurate sales entries for the past 30 sales with all amounts reported correctly. Anthony
  12. I fixed the decimal problem but here is my output for June 1 to June 30. Total Sales = $285.34 for the period 1 June, 2007 to 30 June, 2007 Total number of orders = 16 Order Name Payment Purchased Status Referer Campaign Total 51 Sam T Visa / MasterCard (Secure) 28 June, 2007 Shipped $511.85 50 Joe F Visa / MasterCard (Secure) 26 June, 2007 Shipped $204.63 49 Bob K Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.62 48 Tom B Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.80 47 John S Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.23 46 Rick S Payment on Local Pickup. We acce 25 June, 2007 Shipped $62.58 45 Bill B Payment on Local Pickup. We acce 25 June, 2007 Shipped $190.27 44 Chad S Payment on Local Pickup. We acce 25 June, 2007 Shipped $193.80 43 Barry S Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.60 42 Jen R Payment on Local Pickup. We acce 25 June, 2007 Shipped $204.63 40 John B Visa / MasterCard (Secure) 25 June, 2007 Shipped $62.37 39 Andy M Visa / MasterCard (Secure) 24 June, 2007 Shipped $0.00 38 Norm D Visa / MasterCard (Secure) 22 June, 2007 Shipped $204.63 37 Steve E Visa / MasterCard (Secure) 20 June, 2007 Shipped $64.08 36 Paul O Visa / MasterCard (Secure) 19 June, 2007 Shipped $68.75 31 Terry S Visa / MasterCard (Secure) 1 June, 2007 Shipped $25.63 You see that the total up top does not match the sales totals. Anthony
  13. I've just installed SalesTracker and find that the info box atop the list of sales doesn't present an accurate total dollar value of the sales. For example, Total Sales = $2345 for the period 17 June, 2007 to 17 August, 2007 Total number of orders = 6 In this case the total sales should well exceed the amount shown. Anthony
  14. Man, if these two guys get together we're all in for a MAJOR treat! Good luck guys! Anthony
  15. But I'm not charging tax on shipping. What would I enter rather than zero? A
  16. Insanini, Will you be documenting the specific upgrade procedures for existing versions of Order Editor? A
  17. I am having a tax calculation problem when using KGT's Discount Coupon Codes with Order Editor. Here's how the calculations are actually happening: Discount coupon applied: -90.00 Tax: 113.40 Sub-Total: 1889.98 Total: 1913.38 This means, 1889.98 + tax - 90.00. I need the discount to be taken from the subtotal BEFORE the calculation of tax. It should therefore be 1889.98 - 90.00 + tax. The total SHOULD be $1907.98 (not 1913.38). What edits need to be made to change this? Thanks, Anthony
  18. That SHOULD be the case, and I've confirmed the changes still exist but here's how the calculations are actually happening: Discount coupon applied: -90.00 Tax: 113.40 Sub-Total: 1889.98 Total: 1913.38 This means, 1889.98 + tax - 90.00. Again, it should be 1889.98 - 90.00 + tax. The total SHOULD be $1907.98 (not 1913.38). I believe a newer version of KGT's Discount Coupon Code may have been made available since that last edit. Anthony
  19. I've just installed your great contribution and love it. I also have another contribution called FEATURED PRODUCTS and the price for my MAP protected products still appear there. Here is the code for my FEATURED_PRODUCTS.PHP file. <?php /* $Id: featured_products.php,v 1.5.8 2003/06/09 22:35:33 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_FEATURED_PRODUCTS); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_FEATURED_PRODUCTS)); ?> <!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> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- 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="0"> <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_image(DIR_WS_IMAGES . 'table_background_products_new.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php ///// To random featured products // list($usec, $sec) = explode(' ', microtime()); // srand( (float) $sec + ((float) $usec * 100000) ); // $mtm= rand(); ////// $featured_products_array = array(); $featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name"; // to random// $featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm)"; $featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_FEATURED_PRODUCTS); if (($featured_products_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?> </td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td> <!-- Featured Products Main Page Box --> <table bgcolor="ffffff" border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($featured_products_split->number_of_rows > 0) { $featured_products_query = tep_db_query($featured_products_split->sql_query); while ($featured_products = tep_db_fetch_array($featured_products_query)) { if ($new_price = tep_get_products_special_price($featured_products['products_id'])) { $products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])); } ?> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> <td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '"><b><u>' . $featured_products['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($featured_products['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $featured_products['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> </tr> <tr> <td colspüan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } } else { ?> <tr> <td class="main"><?php echo TEXT_NO_NEW_PRODUCTS; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table> </td> </tr> <?php if (($featured_products_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> </td> </tr> <?php } ?> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </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'); ?> What needs to be edited here to not show the prices for Click For Price protected items? Many thanks in advance. Anthony
  20. Sorry DJ. I think I may have updated since then and I've been looking for those steps. Thanks somuch for pointing it out. Saving this time! :-) Anthony
  21. Can you explain where and how I do that? I've only seen in the options the following: Order Editor- Display Payment Method dropdown? true Order Editor- Display Shipping Method dropdown? true Order Editor- use Separate Pricing Per Customer? false Order Editor- select a tax class for shipping fees Taxable Goods Order Editor- select your credit card payment method Anthony
  22. On a transaction yesterday I had some very unusual problems in my order editor. I'm also using KGT's Discount Coupon Codes contribution. When I look at the transaction details all the numbers are correct but when I went into the editor the discount was applied AFTER the tax rather than before the tax, therefore the tax amounts and total were different. The checkout process calculated everything correctly (subtotal - discount + tax = total). It was only in the editor that the numbers were skewed. Any ideas? Anthony
×
×
  • Create New...