Specifically, I am looking for an API or dataset that provides me the information about the most popular/most trending/most sold items during a particular historic time period?
There is a list of several datasets containing retail data that you can find useful for your project.
Online Retail Data Set. This is a transnational data set which contains all the transactions occurring between 01/12/2010 and 09/12/2011 for a UK-based and registered non-store online retail. https://archive.ics.uci.edu/ml/datasets/Online+Retail
Walmart Store Sales. Historical sales data for 45 Walmart stores located in different regions. Each store contains a number of departments, and you are tasked with predicting the department-wide sales for each store. https://www.kaggle.com/c/walmart-recruiting-store-sales-forecasting/data
Grocery shopping datasets. A list of three datasets. http://recsyswiki.com/wiki/Grocery_shopping_datasets
Supermarket Data. This is the dataset released as a companion for the paper “Explaining the Product Range Effect in Purchase Data“, presented at the BigData 2013 conference. http://www.michelecoscia.com/?page_id=379
etsy.com 58K shops. Stats from etsy.com shops: items, followers, admirers, feedback, open date, sales. https://bigml.com/user/czuriaga/gallery/dataset/51c88569035d073805000fa5
Thanks Dimitar. I am looking for something like 1(Online Retails Data set) having information about the place (City,State) where the sales took place. In this dataset the location is provided at the country level.