Abstract: Technology expansion has numerously contributed to marketing. The researchers built “ShopPal” to provide hassle-free shopping experiences to users. This is a mobile application displaying advertisements of individual shopping areas, not shopping malls. It also consists of billboards in shops that would display promotions in the shopping place based on age category of majority present in the area at a given time. A stored procedure was used to find preferences of given age categories. It is used to provide suggestions when consumers select product choices, when registering. Customized offers based on location, tracked using Global Positioning System (GPS), are sent to users. Customer connects to billboard via Bluetooth. Clustering is used to identify age category of majority of gathered customers and promotions are displayed accordingly. The system would be greatly beneficial to consumers and shop owners. “ShopPal” is an ideal location-based offer advertising system that gives consumers a hassle-free shopping experience.