phpshop 1.0 for Mambo is the only shop component that is fully integrated into Mambo.
There are others that are on the way, but they are not yet at a stable release like phpshop.
It does not have all the extensive functionality of something like OSCommerce, but from the sounds of it, phpshop should meet your needs.
http://www.mambo-phpshop.net/