Jump to content


Member Since 07 Jan 2010
OFFLINE Last Active Today, 00:48

#1755905 Paypal Express or Standard opinions wanted

Posted by greasemonkey on 18 April 2017 - 21:04

@John W no question - Express. All the issues of days gone by seem to be fixed, with Express Enabled you can 1) you can take advantage of PayPal Checkout, 2)

you can take advantage of Login with PayPal and 3) if required, you can now use PayPal Pro.


You can refer to this link for more details on how I have it set up; http://forums.oscomm...gold/?p=1755266


Note: if you need to use a Discount Module this one works with Express.... http://addons.oscommerce.com/info/9460

#1755266 PayPal App and 2.3.4BS Gold

Posted by greasemonkey on 29 March 2017 - 22:04

@Mikepo there is no need to have standard enables as well.


There are many ways to set up/configure... I have mine with in-context enabled and instant update disabled.


If a customer is logged into there account (or logged in with Login With PayPal which you can now use if you have Express enabled) when on checkout_payment they will have the option to select PayPal as their payment option and works similar to standard if instant update is disabled.


If instant update is enabled; 1) in-context for "checkout with PayPal is not available 2) you must have a SSL 3) shipping is "selectable" on/during PayPal and if works transfers customer directly to checkout_success 4) is NOT mobile friendly (game changer IMO... and hence why I have it off).


Log story short...


1) Checkout with PayPal (now called PayPal Checkout I think) is super slick with in-context enabled - only downside is the customer does not see, and is not able to select, a shipping method during checkout (they land back on checkout_confirmation and can always go back and change their shipping method... PITA.... but possible)... the logic is simple however, it is suppose to be super quick and therefore pre-selects the cheapest shipping method.


2) having express enabled allows you to also use Log in with PayPal and or PayPal Pro if you require a Credit Card processing module.


3) With instant updated disabled works similar enough to standard...

#1755117 Amazon Juggernaut

Posted by greasemonkey on 26 March 2017 - 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