Get Sales Performance

Returns a list of sales performance figures per outlet.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Requires the Sales module or the Inventory module, and Insights Hub access for the user.

Period boundaries

net_sales and theoretical_cost are counted in whole days: start_datetime and end_datetime are truncated to dates, rather than used as the boundary timestamps that drive the inventory figures. A day on which the outlet closed a full count goes wholly to one period, and count_moment decides which:

  • after_closing (default): the count is taken after the day's last sale. The start day is left out entirely if the outlet closed a full count on it, as it belongs to the previous period. The end day is always included.
  • before_opening: the count is taken before the day's first sale. The start day is always included. The end day is left out entirely if the outlet closed a full count on it, as it belongs to the next period.

actual_cost adds waste and negative variance, which follow the inventory boundaries.

Calendar days are resolved in the library's timezone, not UTC. The offset you send on start_datetime does not change which day a moment falls on.

So with after_closing, for an outlet that counted at 14:00 on the start date, the inventory figures leave out only the movements booked before 14:00, while net_sales leaves out the entire day. With before_opening, for an outlet that counted at 08:00 on the end date, the inventory figures stop at 08:00, while net_sales leaves out the entire end day.

Query Params
date-time
required

Start of the reporting period, in ISO 8601 format.

date-time
required

End of the reporting period, in ISO 8601 format. Must not be earlier than start_datetime.

string
enum
Defaults to after_closing

When the outlets take their full counts, which decides the period a count day's sales belong to. after_closing: a full count on the start date leaves that day's sales out. before_opening: a full count on the end date leaves that day's sales out. See Period boundaries below.

Allowed:
string

Comma-separated outlet IDs to report on. Omit to report on every outlet in the library. IDs that do not exist, or that belong to another library, match nothing rather than returning an error.

string

An outlet name to query on. Matches outlets whose name contains this value.

string

Filter on outlet custom fields. Check reference guide for details.

int32

A page number within the paginated result set.

int32
≤ 200

Number of outlets to return per page. Maximum 200.

Responses

400

A filter is missing or malformed.

403

The library has neither the Sales nor the Inventory module, or the user lacks Insights Hub access.

Language
Credentials
OAuth2
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json