Multi Store Reporting & Analytics | API? Other reporting tools?
I'm new to the forum but hoping for some help.
We're using lightspeed retail as our POS with 2 retail stores and one head office location (where out customer service team also process orders.
We hold stock in these 3 locations and often, our staff are forced to jump in & out of registers to transact and fulfil stock from another location. This obviously presents challenges with reporting on sales for a location.
For example, lightspeed will report sales based on registers, so one customer may have purchased two units at store A, that were fulfilled from two locations (eg. Store A & Store B.), lightspeed attributes the sales to two locations. Not the one sale from Store A. (which they were).
A few questions...
- How do people manage multi stores reporting retrospectively? Is anyone using a unique identifier like mac address, IP, physical device ID to track sales that sales from a device rather than the 'store location and register'?
- How do people manage sales reports that show a sales date when the order is placed, not fulfilled?
Would love to hear from anyone wrestling similar business challenges
Thanks in advance!