Sql Query Behind Sold Stock Between Dates (by Source) : Support Center

Discussions Customisation / Scripting Forums General Queries

Sql Query Behind Sold Stock Between Dates (by Source)

Sebastian Karam

started a topic over 6 years ago

Hi all

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

Seb

Matt Bartol

said over 6 years ago

Hi Seb,

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.

Nick Wilson

said over 6 years ago

Hi,

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?

Thanks!

Jen of CalmingBreath

Jonathan Bloor

said about 6 years ago

I'm just getting to grips with Linnworks but would the sample code here not be the basis

http://www.linnworks.com/support/dashboards-sales-reporting/query-data/custom-script/further-sample-queries

The "Order Life History for Processed Orders Across A Date Range" would be modified so line:

SET @FromDate = GETDATE()-30

becomes

SET @FromDate = GETDATE()-7

Let me know if that helps or if you need a hand writing the SQL.

Jon

Hyper Commerce

said over 3 years ago

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 ethan@hypercommerce.co.uk

Kind regards.