Latest News: (loading..)

toughmama

Members
  • Content count

    44
  • Joined

  • Last visited

1 Follower

About toughmama

Profile Information

  1. Worked like a dream. Thanks.
  2. OK... I got this code to work... $this->output[] = array('title' => TEXT_DISCOUNT . (!empty($order_info) ? ' (' . $sess_discount_code . ' - ' . $check['discount_values'] . ')' : '') . ':', Output is: Discount (bf2014 - 25%): -$16.98 NOW Trying to get it to look like this: 25% Discount (bf2014): -$16.25 How do I re-arrange the code ?
  3. I love this contrribution I was wondering if there is a way to add the ACTUAL Discount PERCENT given. Right now, I have the Discount Code... but would also like to have the discount % added too Discount (bf2014): to this Discount (bf2014 - 25%): Sub-Total: $67.90 Discount (bf2014): -$16.98 USPS Slow Mail (via FedEx SmartPost): $15.00 Total: $65.93 Cheers, Todd
  4. Dom, Awesome Contribution... kudo's to you. I had before the upgrade 1 year ago and missed it. It will help bring more business back for sure. Thanks for all the extra help in adding in the star rating. Cheers, Todd http://www.theskylantern.com/TnT/customer_testimonials.php
  5. Re. Duplicate products because some some product are listed/linked to different categories Here is a fix for the margin_report.php to have single product listing. -------------------------------------- Line 142 if (strpos($this->sql_query, 'distinct') || strpos($this->sql_query, 'group by')) { //$count_string = 'distinct ' . tep_db_input($count_key); $count_string = tep_db_input($count_key); } else { $count_string = tep_db_input($count_key); } ============= Line 405 - change to: $listing_sql = "select p.products_id, p.products_price as products_price, p.products_cost, pd.products_name, IF(s.status, s.specials_new_products_price, NULL) as specials_price, if(s.status, s.specials_new_products_price-p.products_cost, p.products_price-p.products_cost) as margin_dollars, if(s.status, (s.specials_new_products_price-p.products_cost)/s.specials_new_products_price*100, (p.products_price-p.products_cost)/p.products_price*100) as margin_percentage from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.language_id = '" . (int)$languages_id . "' and p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "'"; ============= Line 416 - change to: $listing_sql = "select distinct p.products_id, p.products_price as products_price, p.products_cost, pd.products_name, IF(s.status, s.specials_new_products_price, NULL) as specials_price, if(s.status, s.specials_new_products_price-p.products_cost, p.products_price-p.products_cost) as margin_dollars, if(s.status, (s.specials_new_products_price-p.products_cost)/s.specials_new_products_price*100, (p.products_price-p.products_cost)/p.products_price*100) as margin_percentage from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.language_id = '" . (int)$languages_id . "' and p.products_id = pd.products_id";
  6. Problem solved... running 2.3.4 - - need to change query in margin_report2.php mysql_query to ==> tep_db_query mysql_fetch_array to ==> tep_db_fetch_array Thanks to George @ Mini Template System for solving this problem.
  7. Hi, Anyone ever get this error... happens when I click on drop down bar. (daily, yesterday, etc) Warning: mysql_query() [function.mysql-query]: Access denied for user 'tntsale3'@'localhost' (using password: NO) in /home/tntsale3/public_html/shop/office/margin_report2.php on line 34 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/tntsale3/public_html/shop/office/margin_report2.php on line 34 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tntsale3/public_html/shop/office/margin_report2.php on line 35 and more.... OScom 2.3.4 with QPBPP for SPPC
  8. Re. Add Quantity and new total Price shows up in 2 places. Would like to have it so NEW individual price shows up instead when qnty is added. Is this possible ? Where would we change the code ? Refer attached Picture. Thanks, Todd Snap shot of picture taken from this link. http://www.theskylantern.com/TnT/product_info.php/white-sky-lantern-string-p-192
  9. Fix works great... all good now. Thanks George. FYI - Running 2.2 oscommerce for 6yrs..., Now using Mini Template System, and has been the best upgrade. Great support too.
  10. Re. QPBPP with SPPC / Prices under $1 not working I found that products under $1 do not calculate properly. If an item is listed for $0.45, and distributor pricing is @ $0.25 – Pricing is listed as 45 cents in the Shopping cart, NOT 25 cents as it should be, (when logged in as a Distributor) The pricing is also the same when on the products listing page... (refer pic below) Examples tried and tested... I changed pricing to $2, and Dist price to $0.80 - it shows $2 I changed pricing to $2, and Dist price to $1.00 - it shows $1 I changed pricing to $2, and Dist price to $1.20 - it shows $1.20 I changed pricing to $2, and Dist price to $0.99 - it shows $2 Any idea where to fix the code ? Thanks, Todd
  11. I spent few hours trying many different ways, rewording, moving code to different places, etc... nothing seems to works. I just keep getting the ID field numbers. I'm no programmer... but I am persistant in trying new ways... and I must say, I just can't get t it to work. Worse case scenario, i just remember which number corresponds to the referrer. Any other ideas... please let me know. Cheers & Thx, Todd - Sky Lanterns
  12. add referer column to Customer Admin page, change table # to table text want to show Referred By. Well, I'm 90% there in showing it... However, I'm running into a problem trying to get the referred by as the text name. Somehow it is pulling up the table ID it has instead. Any ideas on how to fix? Picture of what it currently looks like. ------------------ Code to where refer was added... $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country, c.customers_newsletter, ci.customers_info_source_id as entry_referral, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id = ci.customers_info_id left join " . TABLE_COUNTRIES . " ctry on a.entry_country_id = ctry.countries_id left join " . TABLE_ZONES . " z on a.entry_zone_id = z.zone_id " . $search . " order by " . $db_orderby . " " . $sort; <td class="dataTableContent" align="center"><?php echo htmlspecialchars($customers['entry_referral']); // old referral start code that I had in my old customer.php // $source_query = tep_db_query("select customers_info_source_id from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customers['customers_id'] . "'"); // $source = tep_db_fetch_array($source_query); // $entry_referral = tep_get_sources_name($source['customers_info_source_id'], $customers['customers_id']); // old referral end ?></td> http://addons.oscommerce.com/info/3463
  13. Hello there... Is there any new updates with all the fixes. I see last update was 3 Dec 2007, but there looks like many little fixes have been added since. MVS V1.0 Thanks in advance, Todd Schlosser Visit My Website - Sky Lanterns