Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 06-16-2025 04:39:53
Sales by Product Report
Hi,
I am looking for a "Sales by Product Report" that will show me who ordered certain products and include order number/code and customer address etc.
Is there such a thing? and if not is this a difficult search string to create in the raw database?
Cheers,
Bruce
I'd rather have a full bottle in front of me, than a full frontal labotomy.
Offline
#2 06-16-2025 08:33:38
Re: Sales by Product Report
Hi, Bruce. All that data is available in the ecom_orderitems (last 13 months) and the ecom_orderitemsarchive (13 months old and older) tables, and accessible via Raw DB Admin. I suggest you pull the data you need via Raw SQL Statement with CSV export, and sort/filter/extract using Excel or Sheets.
Nick Hendler
Online