Community Add-Ons

Add file to this package
Top » Features

QTpro for osc 2.3
for osCommerce Online Merchant v2.3

QTpro for OsCommerce 2.3.1
Track and manage attribute stock.
You need this if you sell 1 items with various attributes, and you want to control stock on attribute level.

I have uploaded the package here for it to appear in add-on section for 2.3 version.
This is just a re-post, so all credits go to original poster.

2.2 version here:
http://addons.oscommerce.com/info/888

And support thread for it here:
http://forums.oscommerce.com/topic/31484-contribution-qtpro-quantity-tracking-professional/page__hl__qtpro

The uploaded file and instructions was installed on a almost clean 2.3.1 install (only a handfull other mods installed).
The install is quite long - but end result is really nice.

REMEMBER; You must active attribute tracking here:
admin->catalog->product attributes->
when adding/editing an attribute, you must check the Track Stock? checkbox.

Regards

Legend:  Download   Report

Expand All / Collapse All

Error quotes fix from qtpro_functions.php file 25 May 2016  

There is an error/missing quotes in admin/includes/functions/qtpro_functions.php file that causes an error type when you try to delete a category (and maybe a product) from categories menu (categories.php?action=delete_category_confirm&cPath=) :

1064 - Erreur de syntaxe près de '' à la ligne 1

DELETE FROM products_stock WHERE products_id =

[TEP STOP]

To fix it, edit the "qtpro_functions.php" file, go to line 286 and found :

//This function will delete all option stock entries from the product.
function qtpro_doctor_amputate_all_from_product($products_id){
tep_db_query("DELETE FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id =". $products_id);

and replace by :

//This function will delete all option stock entries from the product.
function qtpro_doctor_amputate_all_from_product($products_id){
tep_db_query("DELETE FROM " . TABLE_PRODUCTS_STOCK . " WHERE products_id = '" . $products_id . "'");
}

That's all !

Note: The qtpro_functions.php file "quote fixed" is available in download (1 file).

Stock.php sorting alphabetically 16 Oct 2013  
Extra Bracket Problem Resolved 26 Feb 2013  
corrected products_attributes.php 21 Aug 2012  
QTPro 4.6.1 for v2.3 - Updates 22 Jul 2012  
paypal_standard.php FIX to decrement stock levels 12 Dec 2011  
Fix error on deleting empty categories 11 Oct 2011  
QTpro for osc 2.3- Revised Manual 4 Jul 2011  
QTpro for osc 2.3 21 Jan 2011