Jump to content

Show Product in Sales report?


Guest
 Share

Recommended Posts

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.

Link to comment
Share on other sites

Just thought I would follow up on this incase it will help anyone else. To run a report on cubecart for everyone that has bought a specific product. You need to get yourself a MYSQL client.

You then run the following query in the client:

SELECT `title`, `first_name`, `last_name`, `line1`, `line2`, `town`, `state`, `postcode`, `phone`, `email`, `quantity`, `total`

FROM `cc_CubeCart_order_summary`

INNER JOIN `cc_CubeCart_order_inventory`

ON `cc_CubeCart_order_summary`.`cart_order_id`=`cc_CubeCart_order_inventory`.`cart_order_id`

WHERE `cc_CubeCart_order_inventory`.`name`="NAME OF PRODUCT"

Where all you need to do is change the NAMEOFPRODUCT to match the product you would like a sale report about.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...