Hey Guys,
Was hoping for a bit of help. My client sells tickets for events and they require to export the sales report to manage the e-tickets when the customer brings their print-off to their event/product they have bought a ticket for.
http://www.mygigticket.com
Unfortunately cubecart doesn't provide the product name in the sales report, only the order id, which then has to be cross referenced to find the event. This isn't very convenient and have been trying to figure out how to add product name to the report.
I can see that the report in the admin is using the CubeCart_order_summary table,
But I need the table in the cubecart CubeCart_order_inventory which associates the order number with the product.
Can anyone help with a potential solution?
Thanks in advance.