Lightspeed Analytics Report to show Multi Store Sales and Inventory

I am looking to create a daily report to allow us to balance inventory between two shops. One shop is temporarily closed so we are using it like a "Warehouse" and want to move inventory from it to the "Main" store as items sell through at the main store.

The columns I would like to see are

Description and quantity sold of items sold at main store

Current On Hand for the Main store and the Warehouse store.

So far, I can get a report that shows everything for the Main store, but I cannot figure out how to get a column showing the inventory at the Warehouse for each item in the sold at the Main store.

Any insights or tips are welcome.

BTW - currently I am doing this in two reports and then using Excel to combine them. My hope is to have Analytics do the work and email out the single report daily.

Thanks

Sign In or Register to comment.