Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

GotTeamProductions

Members
  • Content count

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    Scottie Wilcoxson
  • Website
  1. GotTeamProductions

    Supertracker Development

    You're welcome! Supertracker is an awesome contribution, an essential for all OSC stores. You could add a field that would calculate the $$$/lead. Google has a web service, you could possibly interface with it and do that way as well.
  2. GotTeamProductions

    Supertracker Development

    Conversion Rates: Below is my code to figure out the conversion rates for v3.2. Please let me know what you think and if it's accurate. Look for this line in /admin/supertracker.php (Around line 528): echo '<tr><td>' . $keyword_friendly_name . ' : ' . $ppc_key_refs . TABLE_TEXT_REFERRALS_AVERAGE_TIME . $ppc_row['ave_time'] . TABLE_TEXT_MINS_AVERAGE_CLICKS . $ppc_row['ave_clicks'] . '</td></tr>'; BEFORE that line ADD: // conversion data $ppc_key_p_sql = "SELECT COUNT(*) as conversions FROM supertracker where landing_page like '%ref=" . $ref_code . "&keyw=" . $keyword_code . "%' and completed_purchase='true'"; $ppc_key_p_array = tep_db_fetch_array(tep_db_query($ppc_key_p_sql)); if ($ppc_key_p_array['conversions'] == 0) $conversion_rate = 0; else $conversion_rate = ($ppc_key_p_array['conversions']/$ppc_key_refs)*100; Now, Change the line: echo '<tr><td>' . $keyword_friendly_name . ' : ' . $ppc_key_refs . TABLE_TEXT_REFERRALS_AVERAGE_TIME . $ppc_row['ave_time'] . TABLE_TEXT_MINS_AVERAGE_CLICKS . $ppc_row['ave_clicks'] . '</td></tr>'; To: echo '<tr><td>' . $keyword_friendly_name . ' : ' . $ppc_key_refs . TABLE_TEXT_REFERRALS_AVERAGE_TIME . $ppc_row['ave_time'] . TABLE_TEXT_MINS_AVERAGE_CLICKS . $ppc_row['ave_clicks'] . ', #Purchased: ' . $ppc_key_p_array['conversions'] . ', Conversion Rate: ' . number_format($conversion_rate,2) . '%</td></tr>';
  3. GotTeamProductions

    Store Pick Up

    Wow this is an old post... Maybe the answer will help someone else... You probably put the spu.php file that belongs in the includes/modules/shipping in the languages/modules/shipping thus redeclare. Make sure you differentiate them and place them in the correct directories.
  4. GotTeamProductions

    New UPS XML Shipping Module available

    I had that problem too. I'm not using the dimensions module. The problem was I had "Unknown Packaging" selected in the UPS XML Shipping Modules in the admin section. When I changed it to "Customer Packaging" it worked. Hope that helps!
×