InvoicePlane is a self-hosted open source application for managing your quotes, invoices, clients and payments. Installed more than 30.000 times in 180 countries.

By default Invoice plane sorts all of its products in list view by product name. There is no option to change the sorting type during viewing or in settings.

In order to change the sorting by any property (say SKU), follow these steps

  • Using FTP or SFTP or any preferred method with write access, navigate to the following path of your invoice plane installation.
invoice plane root directory/application/modules/products/models
  • Edit the file named  mdl_products.php 
  • Find the following code
public function default_order_by()
 {
 $this->db->order_by('ip_families.family_name, ip_products.product_id');
 }
  • Replace with the following code.
public function default_order_by()
 {
 $this->db->order_by('ip_families.family_name, ip_products.product_sku');
 }
  • The above replacement will sort the product list by SKU.
  • That’s it.
The following two tabs change content below.
Specific Thinking in Science & Technology

Latest posts by Think Specific (see all)


Think Specific

Specific Thinking in Science & Technology

Leave your comments..