No. Units Sold for Stats Forecast Category Distribution table v1.0

Adds the number of units sold to the Stats Forecast Category Distribution table.

#
#----------[ OPEN ]----------
#
modules/statsforecast/statsforecast.php

#
#----------[ FIND ]----------
#
    <tr><th style="width:50px">'.$this->l('Category').'</th><th>'.$this->l('Count').'</th><th>'.$this->l('Sales').'</th><th>'.$this->l('% Count').'</th><th>'.$this->l('% Sales').'</th><th>'.$this->l('Avg price').'</th></tr>';

#
#----------[ REPLACE WITH ]----------
#
    <tr><th style="width:50px">'.$this->l('Category').'</th><th>'.$this->l('Count').'</th><th>'.$this->l('Units').'</th><th>'.$this->l('Sales').'</th><th>'.$this->l('% Count').'</th><th>'.$this->l('% Sales').'</th><th>'.$this->l('Avg price').'</th></tr>';

#
#----------[ FIND ]----------
#
     <td align="right">'.$catrow['orderQty'].'</td>

#
#----------[ AFTER, ADD ]----------
#
     <td align="right">'.$catrow['unitsSold'].'</td>

#
#----------[ FIND ]----------
#
COUNT(*) AS orderQty, 

#
#----------[ AFTER, ADD ]----------
#
SUM(od.`product_quantity`) AS unitsSold,

Back Link & Date for Stock Movement Tab v1.0

Add a "Back to list" link & date column to BO stock movement tab.

#
#----------[ OPEN ]----------
#
admin/tabs/AdminStockMvt.php

#
#----------[ FIND ]----------
#
'employee' => array('title' => $this->l('Employee'), 'width' => 100, 'havingFilter' => true),

#
#----------[ AFTER, ADD ]----------
#
'date_add' => array('title' => $this->l('Date'), 'width' => 60, 'type' => 'datetime', 'align' => 'right'),

#
#----------[ FIND ]----------
#
public function viewstock_mvt()
 {
  global $cookie;

#
#----------[ REPLACE WITH ]----------
#
public function viewstock_mvt()
 {
  global $currentIndex, $cookie;

#
#----------[ FIND ]----------
#
echo '</table>';
 }
 
 public function display()

#
#----------[ REPLACE WITH ]----------
#
echo '</table>';
   echo '<div class="clear" style="height:20px;">&nbsp;</div>
   <br /><br /><a href="'.$currentIndex.'&token='.$this->token.'"><img src="../img/admin/arrow2.gif" /> '.$this->l('Back to list').'</a><br />';
 }
 
 public function display()

Back Link for Carts Tab v1.0

Add a "Back to list" link on the bottom of the cart detail page.

#
#----------[ OPEN ]----------
#
admin/tabs/AdminCarts.php

#
#----------[ FIND ]----------
#
    // Cancel product
    echo '
   </fieldset>
  <div class="clear" style="height:20px;">&nbsp;</div>';

#
#----------[ AFTER, ADD ]----------
#
  echo '<br /><br /><a href="'.$currentIndex.'&token='.$this->token.'"><img src="../img/admin/arrow2.gif" alt="" /> '.$this->l('Back to cart list').'</a><br />';

Enhanced Product Details Statistics Module v1.0

Adds a table of sold attributes grouped by quantity to the BO product details statistics module.

#  
#----------[ OPEN ]----------  
#  
modules\statsproduct\statsproduct.php  
   
#  
#----------[ FIND ]----------  
#  
      public function hookAdminStatsModules($params)  
   
#  
#----------[ BEFORE, ADD ]----------  
#  
      private function getBestAttributes($id_product)  
      {  
           return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('  
           SELECT od.product_name, SUM(od.product_quantity) as pqty  
           FROM `'._DB_PREFIX_.'orders` o  
           LEFT JOIN `'._DB_PREFIX_.'order_detail` od ON o.id_order = od.id_order  
           WHERE o.date_add BETWEEN '.$this->getDate().'   
           AND o.valid = 1  
           AND od.product_id = '.(int)($id_product).'  
           GROUP BY od.product_attribute_id  
           ORDER BY pqty DESC');  
      }  
   
#  
#----------[ FIND ]----------  
#  
                     $this->_html .= '<h3 class="space">'.$this->l('Attribute sales distribution').'</h3><center>'.ModuleGraph::engine(array('type' => 'pie', 'option' => '3-'.$id_product)).'</center><br />  
                <p><a href="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'&export=1&exportType=2"><img src="../img/admin/asterisk.gif" />'.$this->l('CSV Export').'</a></p><br />';  
   
#  
#----------[ REPLACE WITH ]----------  
#  
                {  
                     $this->_html .= '<h3 class="space">'.$this->l('Attribute sales distribution').'</h3><center>'.ModuleGraph::engine(array('type' => 'pie', 'option' => '3-'.$id_product)).'</center><br />  
                    <p><a href="'.Tools::safeOutput($_SERVER['REQUEST_URI']).'&export=1&exportType=2"><img src="../img/admin/asterisk.gif" />'.$this->l('CSV Export').'</a></p><br />';  
                     $top_attributes = $this->getBestAttributes($id_product);  
                     $this->_html .= '<br class="clear" />  
                     <h3>'.$this->l('Best attribute sales').'</h3>  
                     <div style="overflow-y: scroll; height: '.min(200, (count($top_attributes)+1)*32).'px;">  
                     <table class="table" border="0" cellspacing="0" cellspacing="0">  
                     <thead>  
                          <tr>  
                               <th>'.$this->l('Attribute').'</th>  
                               <th>'.$this->l('Qty').'</th>  
                          </tr>  
                     </thead><tbody>';       
                     foreach ($top_attributes as $attribute)  
                          $this->_html .= '  
                          <tr>  
                               <td>'.$attribute['product_name'].'</td>  
                               <td align="right">'.(int)($attribute['pqty']).'</td>  
                          </tr>';                                     
                     $this->_html .= '</tbody></table></div>';  
                }

Link Product Accessories to Product Page v1.0

Slight improvement to link a product accessory to it's product page in BO. Very useful to check if the accessory is linked back to the main product.

#  
#----------[ OPEN ]----------  
#  
admin/tabs/AdminProduct.php

#  
#----------[ FIND ]----------  
#  
echo htmlentities($accessory['name'], ENT_COMPAT, 'UTF-8').(!empty($accessory['reference']) ? ' ('.$accessory['reference'].')' : '').' <span onclick="delAccessory('.$accessory['id_product'].');" style="cursor: pointer;"><img src="../img/admin/delete.gif" class="middle" alt="" /></span><br />';

#  
#----------[ REPLACE WITH ]----------  
#  
echo '<a href="index.php?tab=AdminCatalog&id_product='.$accessory['id_product'].'&updateproduct&token='.$this->token.'">'.htmlentities($accessory['name'], ENT_COMPAT, 'UTF-8').(!empty($accessory['reference']) ? ' ('.$accessory['reference'].')' : '').'</a> <span onclick="delAccessory('.$accessory['id_product'].');" style="cursor: pointer;"><img src="../img/admin/delete.gif" class="middle" alt="" /></span><br />';

RRP (Recommended Retail Price) v1.6a

Adds a RRP feature that shows on the product and product list pages. Includes BO import feature.

CHANGELOG:
v1.6a (2011-09-18)
[*] Fixed you save & percentage not showing if tax disabled.
v1.6 (2011-09-18)
[*] Fixed typo in installation instructions.
[*] Fixed missing language in BO import feature.
[*] Fixed positioning of RRP on category page.
v1.5 (2011-07-23)
[+] Added support for multiple currencies.
v1.4 (2011-07-22)
[+] Added tax (if applicable).
v1.3 (2011-03-19)
[*] Updated for currency->format changes.
v1.2 (2011-03-08)
[*] Updated for PrestaShop 1.4 code
[+] Added You Save value & percentage.
[+] RRP is hidden if attribute is selected (Thanks to AngelofHaovc).
v1.1 (2011-01-28)
[+] Added BO import feature.
v1.0 (2009-12-08)
[+] First release to the PrestaShop community.

Feedback v2.0b

Allow customers/visitors to post feedback. Includes a BO tab, FO module and complete configuration.
CHANGELOG:
v2.0b (2011-06-01)
[*] Repackaged to fix new install table fields.
v2.0 (2011-06-01)
[+] First release of re-written module to the PrestaShop community.

Altering Year Buttons For Financial Year Dates (Australian Stores) v1.0

Instead of the year being from 01-01 to 31-12 this will alter it to 01-07 to 30-06 (Australian financial year).

#
#----------[ OPEN ]----------
#
admin/tabs/AdminStatsTab.php

#
#----------[ FIND ]----------
#
            $from = date('Y-01-01');
            $to = date('Y-12-31');
        }
        if (Tools::isSubmit('submitDateYearPrev'))
        {
            $from = (date('Y') - 1).date('-01-01');
            $to = (date('Y') - 1).date('-12-31');

#
#----------[ REPLACE WITH ]----------
#
            $from = date('Y-07-01');
            $to = (date('Y') + 1).date('-06-30');
        }
        if (Tools::isSubmit('submitDateYearPrev'))
        {
            $from = (date('Y') - 1).date('-07-01');
            $to = date('Y-06-30');

#
#----------[ OPEN ]----------
#
classes/ModuleGraph.php

#
#----------[ FIND ]----------
#
                $employee->stats_date_from = date('Y').'-01-01';
            if (empty($employee->stats_date_to)  OR $employee->stats_date_to == '0000-00-00')
                $employee->stats_date_to = date('Y').'-12-31';

#
#----------[ REPLACE WITH ]----------
#
           $employee->stats_date_from = date('Y').'-07-01';
            if (empty($employee->stats_date_to)  OR $employee->stats_date_to == '0000-00-00')
                $employee->stats_date_to = (date('Y') + 1).'-06-30';

Next / Previous Links for Carts Tab v1.0

Adds Next / Previous images to the cart page to allow easy navigation between carts.

#
#----------[ OPEN ]----------
#
admin/tabs/AdminCarts.php

#
#----------[ FIND ]----------
#
// display cart header
  echo '<h2>'.(($customer->id) ? $customer->firstname.' '.$customer->lastname : $this->l('Guest')).' - '.$this->l('Cart #').sprintf('%06d', $cart->id).' '.$this->l('from').' '.$cart->date_upd.'</h2>';

#
#----------[ REPLACE WITH ]----------
#
if ($prevCart = Db::getInstance()->getValue('SELECT `id_cart` FROM `'._DB_PREFIX_.'cart` WHERE `id_cart` < '.(int)$cart->id.' ORDER BY `id_cart` DESC'))
   $prevCart = '<a href="'.$currentIndex.'&id_cart='.$prevCart.'&viewcart&token='.Tools::getValue('token').'"><img style="width: 24px; height: 24px" src="../img/admin/arrow-left.png" /></a>';
  if ($nextCart = Db::getInstance()->getValue('SELECT `id_cart` FROM `'._DB_PREFIX_.'cart` WHERE `id_cart` > '.(int)$cart->id.' ORDER BY `id_cart` ASC'))
   $nextCart = '<a href="'.$currentIndex.'&id_cart='.$nextCart.'&viewcart&token='.Tools::getValue('token').'"><img style="width: 24px; height: 24px" src="../img/admin/arrow-right.png" /></a>';

  // display cart header
  echo '<h2>'.$prevCart.' '.(($customer->id) ? $customer->firstname.' '.$customer->lastname : $this->l('Guest')).' - '.$this->l('Cart #').sprintf('%06d', $cart->id).' '.$this->l('from').' '.$cart->date_upd.' '.$nextCart.'</h2>';

Enhanced Stats On BO Index v2.2

Adds number of carts and visitors on the BO index page and makes all links clickable.CHANGELOG:
v2.2 (2011-03-17)
[*] Fixed language strings in install files.
v2.1 (2011-03-10)
[*] Updated for new 1.4 AdminHome file.
v2.0 (2011-01-30)
[*] Updated for PrestaShop 1.4 code.
v1.1 (2010-07-20)
[+] Include clickable links, adjusted width.
v1.0 (2009-10-22)
[+] First release to the PrestaShop community.

Tracking Number In Transit E-mail v1.0

Adds the courier tracking number to the "In Transit" e-mail sent to the customer.

#
#----------[ OPEN ]----------
#
admin/tabs/AdminOrders.pp

#
#----------[ FIND ]----------
#
'{followup}' => str_replace('@', $order->shipping_number, $carrier->url),

#
#----------[ AFTER, ADD ]----------
#
'{shippingnumber}' => $order->shipping_number,

#
#----------[ OPEN ]----------
#
mails/(your language)/in_transit.html
mails/(your language)/in_transit.txt

#
#----------[ ADD, WHERE YOU WANT ]----------
#
{shippingnumber}

Admin Customer Ranks Tab v1.1

Adds a BO tab showing the best ranked customers, how much they have spent and how many orders they have made.CHANGELOG:
v1.1 (2011-03-10)
[+] Added customer last login in days "xx days ago".
[*] Fixed customer name on Delete popup.
v1.0 (2011-02-05)
[+] First release to the PrestaShop community.