Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Repeat Order - Cant Find Mod

Mort-lemur

By Mort-lemur
in General Support

Recommended Posts

Mort-lemur

Mort-lemur

Posted
Posted

Hi,

 

I seem to remember some time ago coming across a mod that allowed a customer to place repeat orders at the push of a button - but I cant seem to find anything about it now - does anyone use this? if so could you post a link to the mod?

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites
discxpress

discxpress

Posted
Posted

@@Mort-lemur

 

That is a mod that should be core. I did a quick Google Search for "oscommerce repeat order". It was a sought after feature about 11 years ago but I don't know what came of it.

 

I never needed it as not many of my orders are repeat. Maybe @@burt could come up with something quick and easy. Some proposed when the customer logged in they would see checkboxes next to recently ordered products. All they have to do check the boxes of the products they want to reorder and they would return to the shopping cart page where they could update quantities and go through the checkout.

 

That could be a good checkout_process mod.

 

Hope that helps

Link to comment
Share on other sites
burt

burt

Posted
Posted

come up with something quick and easy

 

http://www.clubosc.com/reorder-the-same.html

 

That evolved into a more complete system, where logged in customers get a new page which;

 

1.  shows a list of all products previously ordered, for each of these:

 

image - name (and options) - quantity input box

 

2.  add to cart button

 

which adds all the products to the cart if their quanity input > 0

 

Looking at the codebase, it would need a overhaul:

 

a/  for core code changes, which can be reduced a bit

b/  for bootstrap output rather than 960grid output

 

 

I belive @@bruyndoncx uses the full system I built (or did on the KL site?)

Link to comment
Share on other sites
bruyndoncx

♥bruyndoncx

Posted
Posted

@@burt, yes it is on the KL site, specifically setup for a reseller but it can be used by any one

 

I have a custom field for the availability of products, so if you want to use this, you need to remove any reference to it.

 

Also I added brand(merk) filters to have a shorter list and sort options.

 

HTH

 

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2012 osCommerce
  Copyright (c) 2012 Club osCommerce www.clubosc.com

  Released under the GNU General Public License
*/
  define('FILENAME_ACCOUNT_REORDER', 'account_reorder.php');
  require('includes/application_top.php');

  if (!tep_session_is_registered('customer_id')) {
    $navigation->set_snapshot();
    tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
  }

 // require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT_REORDER);

  $breadcrumb->add('Account Reorder', tep_href_link(FILENAME_ACCOUNT_REORDER, '', 'SSL'));

  require(DIR_WS_INCLUDES . 'template_top.php');
?>

<h1>Account Reorder</h1>

<br>Sort by <a href="account_reorder.php?sort=modified">last modified first</a> | <a href="account_reorder.php?sort=merkmodel">Merk + model</a> | <a href="account_reorder.php?sort=merknaam">Merk + naam</a>
<br><br>Toon enkel <a href="account_reorder.php?avail=2">beperkt</a>|<a href="account_reorder.php?avail=4">soldout</a> | <a href="account_reorder.php">Standaard alles behalve Soldout.</a>

<?php
  $merk_query = tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p, manufacturers m
  where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = op.orders_id and op.products_id = p.products_id
    and p.manufacturers_id = m.manufacturers_id
    order by m.manufacturers_name ");
  if (tep_db_num_rows($merk_query)) {
  echo '<br><br>Toon enkel Merk: ';
   while ($merk = tep_db_fetch_array($merk_query)) {
     echo '<a href="account_reorder.php?merk='.$merk['manufacturers_id'] .'">'.$merk['manufacturers_name'].'</a> | ';
   }
  }
?>

<?php
$sortorder = 'm.manufacturers_name, p.products_model ';
if ($_GET['sort'] == 'modified') {
  $sortorder = 'p.products_last_modified desc ';
} elseif ($_GET['sort'] == 'merknaam') {
  $sortorder = 'm.manufacturers_name, pd.products_name ';
}
if ($_GET['avail'] > 0) {
  $avail = ' and p.products_availability_id = '. (int) $_GET['avail'];
} else $avail = ' and p.products_availability_id <> 4';
if ($_GET['merk'] > 0) {
  $merkfilter = ' and p.manufacturers_id = '. (int) $_GET['merk'];
} else $merkfilter = '';

  $orders_query = tep_db_query("select distinct op.products_id, op.products_id as products_true_id, o.orders_id, op.orders_products_id,
    p.products_image, p.products_model, p.products_status, p.products_quantity, p.products_availability_id, p.products_last_modified,
    pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price
    from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_PRODUCTS . " p, manufacturers m , products_description pd
    left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id
  where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = op.orders_id and op.products_id = p.products_id
    and p.manufacturers_id = m.manufacturers_id
    and p.products_id = pd.products_id and pd.language_id = $languages_id
    $avail
    $merkfilter
  group by products_true_id
  order by $sortorder ");

  if (tep_db_num_rows($orders_query)) {
    $customer_orders_string = tep_draw_form('re_order', tep_href_link(FILENAME_SHOPPING_CART, 'action=send'), 'post', '', true);

    $customer_orders_string .= '<table border="0" width="100%" cellspacing="0" cellpadding="1" class="ui-widget-content infoBoxContents productListTable">
    <th><td>Product</td><td>Status</td><td>Last modified</td><td>Qty</td></th>';
    

    while ($orders = tep_db_fetch_array($orders_query)) {
      $customer_orders_string .= '  <tr>';
      $customer_orders_string .= '    <td align="center" valign="top" width="' . (SMALL_IMAGE_WIDTH + 30) . '">' . tep_image(DIR_WS_IMAGES . $orders['products_image'], $orders['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</td>' .
                                 '    <td valign="top"><strong><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $orders['products_true_id']) . '">' . $orders['products_name'] . '</a><br>['.$orders['products_model'].']';
      $customer_orders_string .= '</strong>';
      if (!ctype_digit($orders['products_true_id'])) {
        $attributes_query = tep_db_query("select products_options, products_options_values from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_products_id = '" . $orders['orders_products_id'] . "' and orders_id = '" . $orders['orders_id'] . "' order by orders_products_attributes_id");
        while ($attributes = tep_db_fetch_array($attributes_query)) {
          $customer_orders_string .= '<br><small><i>- ' . $attributes['products_options'] . ': ' . $attributes['products_options_values'] . '</i></small>';
        }
      }

      $customer_orders_string .= '</td><td valign="top"><strong>';
      if ($orders['products_status'] == 0) $customer_orders_string .= 'OUT OF STOCK';
      if ($orders['products_availability_id'] > 0) $customer_orders_string .= '<br>Availability: '.$orders['products_availability_id'];
      if ($orders['products_availability_id'] == 2) $customer_orders_string .= '<br>Only '.$orders['products_quantity'] .' left in stock, you cannot order more';
      if ($orders['products_availability_id'] == 4) $customer_orders_string .= '<br>SOLD OUT';
      $customer_orders_string .= '</strong>';
      $customer_orders_string .= '    </td><td>'. $orders['products_last_modified'].'</td>';
      
      //global $currencies, $debug, $trate;
      $_tax_id = $orders['products_tax_class_id'];
      $_price = $orders['products_price'];
      $_special = $orders['specials_new_products_price'];
      if (!isset($trate[$_tax_id])) $trate[$_tax_id] = tep_get_tax_rate($_tax_id);
    
      if ($_special) {
        $percent = - (number_format(100 - (($_special / $_price) * 100))) . ' %';
        $lc_text2 = '<span class="productPrice"><s>' .  $currencies->display_price($_price, $trate[$_tax_id]) . '</s></span><span class="productSpecialPrice">' . $currencies->display_price($_special, $trate[$_tax_id]) . '<br />' . $percent.'</span>';
      } else {
        $lc_text2 = '<span class="productPrice">'.$currencies->display_price($_price, $trate[$_tax_id]).'</span>';
      }
      $customer_orders_string .= '<td valign="top">' . $lc_text2 . '</td>';
      if ($orders['products_availability_id'] !== 4) {
        $customer_orders_string .= '<td align="right" valign="top">' . tep_draw_input_field('quantity[' . $orders['products_true_id'] . ']', 0, 'maxlength="4" size="4"') . '</td>';
      } else {
          $customer_orders_string .= '<td></td>';
      }
      $customer_orders_string .= '  </tr>';
    }
    $customer_orders_string .= '</table>';
    $customer_orders_string .= '<div style="text-align:center; background: transparent;">' . tep_draw_button('Add to shopping cart', 'transferthick-e-w', null, 'primary') . '</div>';

    $customer_orders_string .= '</form>';
  }
        
  echo $customer_orders_string;

  ?>

<?php
  require(DIR_WS_INCLUDES . 'template_bottom.php');
  require(DIR_WS_INCLUDES . 'application_bottom.php');
?>

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites
clustersolutions

clustersolutions

Posted
Posted

@@discxpress, what?! Let's not start this :) ...I help launched a Magento site in June...its intrinsic SEO capabilities are awesome...I found myself to reference what they are doing an then implementing it into my BS shops...it gets done at the end but I am just deviating further from the core. Yikes!

 

That is a mod that should be core.

Link to comment
Share on other sites
clustersolutions

clustersolutions

Posted
Posted

@@discxpress, stop it! I'm just kidding...I agree with you. I have put more than 10 yrs of my life in developing/pushing OSC...even at time is not the best for my business interest. Ah...the writing is on the wall...must hedge my bets...

 

@@clustersolutions

 

Anything to make OSCommerce a premier cart. Out the box its a great start and can be transformed into something fantastic. Re-order and Pre-order should be no brainer additions

Link to comment
Share on other sites
Mort-lemur

Mort-lemur

Posted
  • Author
Posted

Thanks everyone.

 

Why is it whenever I ask a question the thread seems to always revert to what should or shouldnt be in core? I'll get a complex............ (w00t)

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites
Hotclutch

Hotclutch

Posted
Posted

No, no interesting discussions. I have had too many of those, someone lock this thread quick!

 

Well I am going to put it to you that Magento has nothing superior SEO wise over the latest version of osCommerce. Only newbies will fall into that trap of thinking one cart is better than another for SEO, when in fact the script at the end of the day has very little to do with the success of the store's SEO.

Link to comment
Share on other sites
Mort-lemur

Mort-lemur

Posted
  • Author
Posted

@@burt Nothing to do with me this one Gary....

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites
bruyndoncx

♥bruyndoncx

Posted
Posted

No, no coke. It has been linked to type II. I say if you wanna watch a show, try Seinfeld. A real funny show about nothing. :)

No coke for type I either, and if you really want to talk about shows you should watch 'The Big Bang Theory' to be with the 'in-crowd' :D

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites
burt

burt

Posted
Posted

@@discxpress, what?! Let's not start this :) ...I help launched a Magento site in June...its intrinsic SEO capabilities are awesome...I found myself to reference what they are doing an then implementing it into my BS shops...it gets done at the end but I am just deviating further from the core. Yikes!

 

 

 

 

What SEO does Magento have that is more awesome ?

 

 

 

 

Edit:  if this conversation turns out to be valuable I will split into its own thread.

Link to comment
Share on other sites
clustersolutions

clustersolutions

Posted
Posted

burt, if you read my message i didn't challenge what osc with hacks/addons ultimately can do or i wouldn't stick my neck so far out thus far (i know one day my customer may say i pay you how much and how come i didn't get the other cart--its a popularity contest). we don't need to pick on any particular cart...out of the box users want the url seoed, ready to go and current...this is just a point i m trying to make and not just the seourl...

 

i don't question the default osc url is good and I have seen some sites rank really high just using the default url. yes, a lot of factors come into play and good back links is still the most important factor to me...but i do know a good url still counts and a bad url will demote a page as i am in the process of getting a site re-indexed.

 

perhaps you see what i see the community edition has a chance to do what the official osc's not doing...i run a business for a long time and i think you have to know your competitors and keep changing whatever's not working until you can find something that sticks...

 

gotta go...i hope i am making sense...

 

What SEO does Magento have that is more awesome ?

 

 

 

 

Edit:  if this conversation turns out to be valuable I will split into its own thread.

Link to comment
Share on other sites
Hotclutch

Hotclutch

Posted
Posted

...

i don't question the default osc url is good and I have seen some sites rank really high just using the default url. yes, a lot of factors come into play and good back links is still the most important factor to me...

 

It's cliche, but content is king. It's your content that will cause your site to rank or not, and if you have good content then back links automatically follow. People will link to your site from forums and social media sites. osCommerce is not the only package that chooses not to include SEO URLs as core. The MyBB forum software that i am busy with currently for example, also has a SEO URL plugin (not core). I don't quite like it compared to what we have here as an addon. So I choose to run my forum URLs without SEO URLs, and it's not a problem at all. Searchers don't see the URL in results anymore the way they used to. They now see the page title and the breadcrumb trail. 

Link to comment
Share on other sites
Hotclutch

Hotclutch

Posted
Posted

 and a bad url will demote a page as i am in the process of getting a site re-indexed.

 

 

 

By bad I assume you mean non SEO'd URL. I have to disagree with you that a bad URL will demote a page. It's more likely duplicate content issues and incorrect setup with eg. the canonical tag, that's killing such a site.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...