I need better reporting/data
does anyone know the tables that have the line items and modifiers etc in them?
Basically I need a daily dump of each order and its sold for price, This is needed both for detailed stock control and or recharging customers who have accounts and need detailed consolidated monthly invoices
Better… Maybe if you explain your problem with the reporting in samba - maybe your just missing something.
Orders have their own table, and simply opening database in SQL manager would have shown you that which is slightly worrying that you haven’t even looked.
However you aren’t going to need just orders and tags.
You mention customers so are going to need tickets etc to like entity to order via ticket.
Depending on your setup you may need tables related to tax rates and mapping.
I have looked and have over 30 year sql DBA skills… better to ask before spending time.
Ive paid for a profesdional sambapos reseller but he never completed the work and never replies to messages.
Look at reports section