StoreHarmony API
  1. Data Sources & Reports
StoreHarmony API
  • Storeharmony API
  • Mobile Apps
    • Apps Registration
      • Authentication
        • Verify User Registration from a Website
        • Verify User Registration
        • Reset User Password
        • Register a new store
        • User Login For Apps
        • Authenticate User
    • Stock Inventory
      • Stock Categories
        • getStoreCategories
        • updateStoreCategory
        • createStoreCategory
        • createStoreSubCategory
        • deleteStoreCategory
        • Upload Category Picture
        • createBulkStoreCategory
      • Create Bulk Products
      • Create Product with Variants
      • Add Variants to Product
      • Upload Product Picture
      • Update Product Prices
      • Add New Quantity to Product
      • Deduct Quantity from Product
      • Creates a simple product in the inventory
      • Get Product by Item ID
      • getProductTransfers
      • acceptTransferIntoStore
      • listProductsPricesForRecentChanges
      • listProductsPrices
      • Get Inventory Stock Items
      • getProductAudit
      • findBySKU
      • Update Product
      • Removes provided variants from provided Existing Product
      • Add Variants to Existing Product
      • getProductsWithComplexQuery
      • Removes Product by Item ID
      • Add Variants to Existing Product
    • Store Admin Operations
      • Get Store User
      • Edit Store User
      • Delete a Store User
      • Get Bank Account List for the Store
      • Update Bank Account Details
      • Create Bank Account
      • Delete Bank Account
      • Add a User to Store
      • Set Default Bank
      • List all users for a Store User
      • Get Bank Account Details
      • Delete Bank Account
    • Invoicing Operations
      • createPDFInvoiceLink
  • CRM
    • Customer Registration
      • Register a new customer
      • Log in a customer
      • Verify Customer Email
      • Verify Customer Mobile
      • Reset Customer Password
  • Online Store
    • Restuarant Order Menus AppCalls
      • Place an Order
      • Submit Store Review
      • getServiceName
      • Load a Restro Store Detail
      • Restro Product Order
      • Track Order Status
      • Restro Store Tables
      • List Auto Categories
      • Restro Product Details
      • Fetch Related Products or Recommended Pairs for a Product
      • Fetch All Categories
      • Fetch All Products Belonging to a Particular Category
      • Fetch All Products by Store ID Based on Categories and Subcategories
      • Fetch All Categories and Subcategories by Store ID
    • updatesOrder
      PUT
    • cancelOrder
      DELETE
    • postCustomerReview
      POST
    • getCustomerProfile
      GET
    • updateProfile
      POST
    • updateProfileShippingAddress
      POST
    • submitIssues
      POST
    • placeOrderToStore
      POST
    • contactStore
      POST
    • calculateOrderShipping
      POST
    • passResetting
      POST
    • getStoreInfo
      GET
    • getCustomerWalletReport
      GET
    • getRegularPurchase
      GET
    • getRecentPurchase
      GET
    • getCustomerReceipts
      GET
    • getReceiptDetails_1
      GET
    • getCustomerProfileDetails
      GET
    • getCustomerOrders
      GET
    • getOrderDetails
      GET
    • getCustomerLoyaltyReport
      GET
    • getCustomerInvoices
      GET
    • trackPayment
      GET
    • trackOrder_1
      GET
    • loadDeliverypolicy
      GET
    • listAutoCategories_1
      GET
    • getShippingRates
      GET
    • shippingInformation
      GET
    • searchProducts
      GET
    • sendReceipt
      GET
    • listStoreProductsForHome
      GET
    • loadProductByItemId_1
      GET
    • getCustomerReview
      GET
    • loadProducRecommendationsByItemId
      GET
    • loadProductBySlug
      GET
    • loadRelatedProductsByItemId
      GET
    • loadPrivacypolicy
      GET
    • searchPagedProducts
      GET
    • searchPagedProductsByPages
      GET
    • getStoreLocations
      GET
    • getGeocode
      GET
    • loadHomeBanners
      GET
    • getCountries_1
      GET
    • getCountryStates_1
      GET
    • getCountryStatesLGARegion_1
      GET
    • loadStoreCategories_1
      GET
    • loadStoreSubCategories_1
      GET
    • loadStoreAllCategoriesAndSubCategories_1
      GET
    • loadStoreBanners
      GET
    • verifyMobile_1
      GET
    • verifyEmail
      GET
    • loadAboutUs
      GET
    • Log in a customer with token
      POST
    • Log in a customer
      POST
    • Register a new customer
      POST
  • User Operations
    • Get User Information
    • Update User Information
    • Set Default Wallet Bank Account
    • Set VAT, VAT Type and currency etc used for business activities in this location
    • Set a particular location as the default store used for business activities
    • Retrieve Profile Image
    • Upload Profile Image
    • Log a User Complaint
    • createNewStoreLocation
    • Change User Password
    • Get the details, settings and important parameters for a store location
    • Get Bank Account Details
    • Switch account to another store location
    • Get User Store Locations
  • Data Sources & Reports
    • getSalesReportsDetails
      GET
    • getSalesReports
      GET
    • Sales Report with products sold
      GET
    • Sales Report by Criteria
      GET
    • Track Sales By Receipt
      GET
    • getCustomerDataSet
      GET
  • Utility Operations
    • Create PDF Invoice Link
    • Load Store Credentials By ID
    • Verify Mobile Number
    • Verify Email Address
    • Retrieve Store Profiles
    • Retrieve List of Roles
    • Retrieve Registered Nigerian Banks. Only Supports Nigerian Banks
    • Lookup Bank Account Details
    • Retrieve List of Countries
    • Retrieve States in a Country
    • Retrieve Regions within a State
  • Payments & Webhooks
    • reversalMerchantPOSTerminal_1
    • payViaMerchantPOSTerminal_1
    • Creates a bank transfer account
  • Webhooks & Operations
    • reversalMerchantPOSTerminal
    • payViaMerchantPOSTerminal
  1. Data Sources & Reports

Sales Report by Criteria

GET
/reports/{storeid}/sales
Data Sources & Reports
This endpoint allows you to query sales receipts based on various parameters like customer ID, staff ID, search keyword, date range, and pagination.

Request

Path Params
storeid
string 
required
ID of the store location where the sale occurred
Query Params
customer
string 
optional
Customer ID for filtering sales records by customer
Default:
staff
string 
optional
Staff ID for filtering sales records by staff
Default:
search
string 
optional
Search query to filter sales records, e.g., customer name
Default:
startdate
string <date-time>
optional
Start date for the query, formatted as yyyy-MM-dd
Example:
2024-03-01
enddate
string <date-time>
optional
End date for the query, formatted as yyyy-MM-dd
Example:
2024-03-31
per_page
integer <int32>
optional
Number of records to return per page
Default:
50
current_page
integer <int32>
optional
The current page number for pagination
Default:
0
Header Params
sessiontoken
string 
required
Session token of the logged-in user

Request samples

Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
Request Request Example
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://gateway.storeharmony.com/cloudapi/reports//sales' \
--header 'sessiontoken;'

Responses

🟢200OK
*/*
Sales receipt report successfully retrieved
Body
success
boolean 
optional
message
string 
optional
storeId
string 
optional
timeOfQuery
string <date-time>
optional
queryPeriod
object (DateDuration) 
optional
start
string <date-time>
optional
end
string <date-time>
optional
duration
integer <int64>
optional
metric
string 
optional
minutes
integer <int32>
optional
hours
integer <int32>
optional
processOnce
boolean 
optional
difference
integer <int64>
optional
staff
string 
optional
data
array [array] 
optional
object 
optional
pagination
object (DataPages) 
optional
totalPages
integer <int32>
optional
currentPage
integer <int32>
optional
perPage
integer <int32>
optional
variables
array [object] 
optional
headings
array[string]
optional
queryReference
string 
optional
records
array[object (SalesReport) {14}] 
optional
salesTime
string <date-time>
optional
salesOriginTime
string <date-time>
optional
unitsSold
integer <int32>
optional
volumeSold
number <double>
optional
receiptNo
string 
optional
customerInfo
string 
optional
customerId
string 
optional
totalPaid
integer <int64>
optional
totalSubTotalAmount
integer <int64>
optional
totalBalance
integer <int64>
optional
itemName
string 
optional
itemBarcode
string 
optional
category
string 
optional
channel
string 
optional
Example
{
  "success": true,
  "message": "string",
  "storeId": "string",
  "timeOfQuery": "2019-08-24T14:15:22Z",
  "queryPeriod": {
    "start": "2019-08-24T14:15:22Z",
    "end": "2019-08-24T14:15:22Z",
    "duration": 0,
    "metric": "string",
    "minutes": 0,
    "hours": 0,
    "processOnce": true,
    "difference": 0
  },
  "staff": "string",
  "data": [
    [
      {}
    ]
  ],
  "pagination": {
    "totalPages": 0,
    "currentPage": 0,
    "perPage": 0
  },
  "variables": [
    {}
  ],
  "headings": [
    "string"
  ],
  "queryReference": "string",
  "records": [
    {
      "salesTime": "2019-08-24T14:15:22Z",
      "salesOriginTime": "2019-08-24T14:15:22Z",
      "unitsSold": 0,
      "volumeSold": 0,
      "receiptNo": "string",
      "customerInfo": "string",
      "customerId": "string",
      "totalPaid": 0,
      "totalSubTotalAmount": 0,
      "totalBalance": 0,
      "itemName": "string",
      "itemBarcode": "string",
      "category": "string",
      "channel": "string"
    }
  ]
}
🟠400Bad Request
🟠404Record Not Found
🔴500Server Error
Modified at 2025-03-27 14:31:04
Previous
Sales Report with products sold
Next
Track Sales By Receipt
Built with