Community Add-Ons

I corrected some errors in the previous upload for best_seller.php

Specifically, the clause {p.products_quantity = 1} was restricting the best sellers list to products whose stock quantity is equal to 1, the clause {p.products_quantity < 4} was measuring total stock, not quantity ordered for a given order, et cetera.

Also, though the date range restriction was working, the quantity sold was taken as total quantity sold for all time, not the quantity sold during the date period of the date range restriction. I fixed this too.

best_sellers.php now works as intended.

I modified the script, so that only products, bought 0 to 3 times in one order, are shown

Full Package.

See post here re TO_DAYS function:

http://forums.oscommerce.com/index.php?showtopic=85375&hl=

Includes instructions on how to amend amount of months.

Instruction for bestseller box - now includes full query amendments that are required.

Want to limit your new products page to the last month or two months etc ?

Want just your bestsellers from the last month or two months etc ?

This contrib will do it - only two change required.