Start a new topic

Sales by product from Dear API

Hi,


We need to export our sales for each product to a spreadsheet for forecasting and order calculation.


I would like to replicate the 'Sales By Product Details Report' with the API. 


The difficulty is that we have to get the sale list and then loop through for each sale and download the invoice lines, however I have not managed to extract the invoice lines from the JSON in excel.


Does anyone know a more direct way of accessing invoice lines or how to get the invoice lines from the Sale JSON?


Many thanks


1 person has this question
1 Comment

Im supprised that such a powerful software is missing a "sales per" day/week/month/year feature. Ive come from MYOB retail manager and that 20 year old software had it in a very easy tab of the product window. We also use this information as a tool to help us set min&reorder and place a puchase order. It helps us to order product bas3d on data not a gut feel. It helps answer: Do i order item a or item b?
Login or Signup to post a comment