I am trying to access the sold data for our inventory over the past week in a script. I can see the the query type "Sold Stock Between Dates (by Source)" gives us the exact data we are after.
What is the SQL query that produces that report or where can we find the "SoldQuantity" property for each item?
Thanks in advance
We are not sharing the code behind our reports. SoldQuantity is a sum of order item quantities SUM(orderitem.nqty). It only captures orders that have been processed.
I need a script that will show both source and currency. Currently, LW only has the 4 options in the screenshot below. I need "Sold Stock Between Dates (by Source and Currency). Can you add this, please?
Jen of CalmingBreath
SET @FromDate = GETDATE()-30
SET @FromDate = GETDATE()-7
Let me know if that helps or if you need a hand writing the SQL.
Hello Sebastian and Jonathan,
This is Ethan from HyperCommerce.
I believe you have been able to customise the query as per your needs. If you still require further help or custom solutions such as Advanced SQL Queries, Custom Reports, API Solutions or Integrations, please feel free to reach me at email@example.com