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.
NOTE: This post was created on 2023-05-26 on the Kryptronic eCommerce Community facebook page, which has been replaced with this forum. All facebook support content was migrated into this forum in April 2024.
Laura:
Is there a way to get a report of a discount code used in orders?
Kryptronic:
Laura, yes you can get a report. The easiest way would be to use the raw database admin's export function on the ecom_orders table. Use "disccode IS NOT NULL AND TRIM(disccode)" as your SQL statement. If you want to narrow it down to a specific month and year just add the corresponding SQL
Laura:
Thank you for directing me! I need a little more help. When I run the SQL statement from above it returns "There are no rows available to export to a CSV file based on the criteria you selected." I then ran the report without any criteria so that all orders would export and I found that even though the orders were discounted based on a code, no discount code is reported in the "disccode" field. I'm running version 9.2.0. Please guide me further.
Laura:
Ignore this particular comment, mainly because it's on a staging site, not on a live one and it can be worked out later.
Laura:
Ignore this particular comment, mainly because it's on a staging site, not on a live one and it can be worked out later.
Laura:
Is this the correct format to pull the discount code and also narrow it down by month and year?
"datemonth='5' AND dateyear='2023' AND disccode IS NOT NULL AND TRIM(disccode)"
Offline