Jump to content


Member Since 07 Jan 2010
OFFLINE Last Active Today, 01:44

#1755117 Amazon Juggernaut

Posted by greasemonkey on Yesterday, 13:06


product_info has a (quite basic) modular reviews module, ready to go...


Yep...part of this tread I think has  been about "learning" from the 800 lb gorilla.... looking how seamlessly and professionally Amazon displays the reviews (now that I have so many) I/we need to step it up....


Maybe as simple as adding avg review stars with color to the "review" button?


But also adding avg review stars to the product listing (a little more tricky.... until the product listing is modularized).


So.... so start just grabbing.... from product reviews...

$average_query = tep_db_query("select AVG(r.reviews_rating) as average, COUNT(r.reviews_rating) as count from " . TABLE_REVIEWS . " r where r.products_id = '" . (int)$product_info['products_id'] . "' and r.reviews_status = 1");
$average = tep_db_fetch_array($average_query);
echo '<div class="col-sm-8 text-center alert alert-success" itemprop="AggregateRating" itemscope itemtype="http://schema.org/AggregateRating"><meta itemprop="ratingValue" content="' . max(1, (int)round($average['average'])) . '" /><meta itemprop="bestRating" content="5" />' . sprintf(REVIEWS_TEXT_AVERAGE, tep_output_string_protected($average['count']), tep_draw_stars(tep_output_string_protected(round($average['average'])))) . '</div>';

and this from product info

    $reviews_query = tep_db_query("select count(*) as count, avg(reviews_rating) as avgrating from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$_GET['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and reviews_status = 1");
    $reviews = tep_db_fetch_array($reviews_query);

    if ($reviews['count'] > 0) {
      echo '<span itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating"><meta itemprop="ratingValue" content="' . $reviews['avgrating'] . '" /><meta itemprop="ratingCount" content="' . $reviews['count'] . '" /></span>';

  <div class="buttonSet row">
  <div class="col-xs-12 text-right"><?php if ($reviews['count'] > 0) {  
    echo tep_draw_button(IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : ''), 'fa fa-heart', tep_href_link('product_reviews.php', tep_get_all_get_params()), 'default', NULL, 'btn-default'); 
    echo tep_draw_button(IMAGE_BUTTON_WRITE_REVIEW, 'fa fa-heart', tep_href_link('product_reviews_write.php', tep_get_all_get_params()), 'default', NULL, 'btn-default'); }?></div>

  <div class="row">
    <?php echo $oscTemplate->getContent('product_info'); ?>

And combine into a product info content mod???

#1755090 Amazon Juggernaut

Posted by greasemonkey on 25 March 2017 - 22:06

Interesting article - more about the value of reviews then amazon... but amazon is the 800 lb gorilla in reviews.


We're doing MUCH better in this regard since implementing @burt key module... now to spend more time to display these results to potential new customers in product listing and product info....

#1754934 PayPal App v5.010 for v2.3.4BS

Posted by greasemonkey on 21 March 2017 - 21:47

@Harald Ponce de Leon using the file you attached...... you are looking good....

With Instant Update ON and in-context checkout enabled it worked PERFECT (selected shipping method at checkout_shipping carried forward to checkout_confirmation)!

With Instant Update ON and classic checkout enabled it worked as well (despite not being mobile friendly) - the selected shipping method selected at checkout_shipping was "pre-selected" in the PayPal dropdown.

With Instant Update OFF and in-context checkout enabled it worked PERFECT as well (selected shipping method at checkout_shipping carried forward to checkout_confirmation)!!!!!

:thumbsup: :thumbsup: Sleep well Harald!!!! Great Job!

Hey Harald, finally upgraded my live EDGE store... upgrade went perfect!

#1754851 Security question

Posted by greasemonkey on 20 March 2017 - 00:42

Thanks for the reply @greasemonkey

I found this article which does suggest changing the directory name.

Changing the name is the easy part. Isn't there files that have to be edited after that? I can't find any reference to it though.

The basic instructions would be... create a new directory... move all the admin files to that directory and then edit the admin and catalog (includes/configure.php) files to point to the new directory.

#1754360 Devious Trick or Super Smart

Posted by greasemonkey on 07 March 2017 - 12:59

And probably illegal in most 1st world countries.

#1752549 Silly Question I think.....or Hope !

Posted by greasemonkey on 23 January 2017 - 16:06

Here is the thread.... http://forums.oscomm...p-a-234bs-gold/

#1752352 QTPro BS

Posted by greasemonkey on 19 January 2017 - 18:13

@raiwa Hi Rainer, I'm going to start testing this shortly.


#1752195 ULTIMATE Seo Urls 5 - by FWR Media

Posted by greasemonkey on 14 January 2017 - 23:13

@piernas well done... and over due.

Of course it comes just days after I updated my install... removing all the constants for EDGE.

#1752048 Customers IP and Geo Country info with order_confirmation email

Posted by greasemonkey on 12 January 2017 - 00:23

Ok.... I get (got it) it.....


  osCommerce, Open Source E-Commerce Solutions

  Copyright (c) 2014 osCommerce

  Released under the GNU General Public License

  class hook_admin_orders_location {

    function listen_orderTab() {
	    global $order;
	      $customers_ip = $order->customer['customers_ip'];
          $tab_title = Location;
          $tab_link = substr(tep_href_link('orders.php', tep_get_all_get_params()), strlen($base_url)) . '#section_location_content';

          $output = <<<EOD
$(function() {
  $('#orderTabs ul').append('<li><a href="{$tab_link}">{$tab_title}</a></li>');

<div id="section_location_content" style="padding: 10px;">

 <p><strong>Customers Location: </strong>{$customers_ip}</p>	

      return $output;

#1751725 Dashboards

Posted by greasemonkey on 31 December 2016 - 17:01

@Dan Cole  I can't seem to upload a screen cap....


I'll try and PM it to you....... I have even built this into a stand alone admin page that refreshes ever couple seconds that I display at our shipping desk - so they can see how they are doing (if they are getting behind) live.....



#1751559 markup in transactional emails

Posted by greasemonkey on 23 December 2016 - 22:29

Very interesting... I see this:

You need to have a history of sending a few hundred emails a day to Gmail addresses.

As being a large roadblock for many stores however.

#1751428 SEO and Website Themes the big companies are doing now.

Posted by greasemonkey on 21 December 2016 - 13:47


As I browse around the internet looking at websites of the major players, I notice a few things they all have in common. I haven't done anything with OSCommerce in a while but I thought about the SEO discussions and decided to post.

One is how their headers are set up. Search in the middle, logo to the left and something administrative or special to the right. I know that's not too exciting for some of you. And they all have a very special deal at the very top. Seems like that's where they "set the tone" if you will. From what I'm seeing, not much investment goes into rest of these multi-million dollar websites. Headers are dazzling but the rest is not so.

Another is they invest much in banners and pictures. All I see are large banners that capture theme or an ongoing special. Also, themed images for categories also. Click on the categories and see a lot of product pictures and prices. That's it. With those images they are X-selling and upselling. And yes a huge banner at the top of every category.

Finally, I notice a network of internal linking and ratings stars.

I do realize everything I mentioned been important for on-page seo but there's more emphasis on them now than ever. So I guess that's the trending content structure for large e-commerce sites. There's nothing major when it comes to the literature side of content but there's a lot going into the visual aspects.

What do you guys think?

I have just completed a similar "redo" of our BS store - removing all side boxes, adding category images index content mod, spending MUCH more time on banners/images, working on nav for all devices.

My 2 cents... the thought of content has changed. It's not just textual...it's visual. Although google (etc) scrape our sites for text, they also monitor VERY closely how our customers interact (how long they stay, how many pages etc etc) with our sites.

"Pretty" sites with easy navigation keep our customers engaged.

Engaged customers buy more.... and therefore keep you ranking high..... which gives you more customers.

#1751268 [Contribution] Ship In Cart

Posted by greasemonkey on 17 December 2016 - 11:36

Hi, thanks for the quick help!

The sort order is indeed correct with the default values of 400 and 1000 for the shipping and total modules respectively.

Here's the Canada Post module I use: http://addons.oscommerce.com/info/7900

The shipping quote is very simple, we charge the rates we get from the Canada Post server, with no handling fees. The rest is done on the CanadaPost server. We also use two other shipping modules: store pickup (as seen in screen grab) and snail mail when the product size allows (doesn't apply here).

Here's the screen shot with example data. Thanks!


You may want to test with the newer REST Canada Post module - their sellonline service is slated to be discontinued (not sure when).

I have this working with http://addons.oscommerce.com/info/8887

#1751048 Addons

Posted by greasemonkey on 11 December 2016 - 18:23

@burt and anyone else reading this - The key system addon has to be the slickest addon I've ever installed.

I was considering hacking core code to get one of the "request a review" addons to work with the community Supported / 2.3.4BS. Glad I didn't... the best 20GBP I ever spent.

Can't wait to try it live and see the reviews pour in

#1750522 Horizontal Categories Menu BS for 2.4 series - please test

Posted by greasemonkey on 29 November 2016 - 13:14

Nice too see coders are already working on upgrading addons for 2.4.x.