{"id":990071,"date":"2015-07-24T11:57:17","date_gmt":"2015-07-24T18:57:17","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/"},"modified":"2015-08-11T07:05:04","modified_gmt":"2015-08-11T14:05:04","slug":"unclaimed-tickets-custom-report-sales-vs-redemption","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/","title":{"rendered":"Unclaimed Tickets Custom Report (SALES vs REDEMPTION)"},"content":{"rendered":"<p>We use the ticket system to sell online tickets. We sell bunch of tickets everyday. In the reporting we can see ticket sales, but is there a way to build a report that shows the tickets that have not been redeemed. The perfect reporting would be instead of Sales by Product in woocommerce reporting, we have a Unused Tickets &#8211; or vise versa &#8211; &#8216;Tickets Claimed&#8217; that shows the exact same figures of the sales by product data, but either excluding tickets that have been redeemed or only including tickets that have been redeemed. Either figure will allow us to know the difference in SALES and REDEMPTION.<br \/>\nits a matter of running the same query as \/includes\/admin\/reports\/sales_by_redeemed.php but filtering out WHERE meta_key = &#8216;_tribe_wooticket_checkedin&#8217;<\/p>\n<p>Any assistance would be much appreciated, even if a 3rd party can code this for a fee. Thanks<\/p>\n","protected":false},"template":"","class_list":["post-990071","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -\" \/>\n<meta property=\"og:description\" content=\"We use the ticket system to sell online tickets. We sell bunch of tickets everyday. In the reporting we can see ticket sales, but is there a way to build a report that shows the tickets that have not been redeemed. The perfect reporting would be instead of Sales by Product in woocommerce reporting, we [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/\" \/>\n<meta property=\"article:modified_time\" content=\"2015-08-11T14:05:04+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/\",\"name\":\"Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2015-07-24T18:57:17+00:00\",\"dateModified\":\"2015-08-11T14:05:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Welcome!\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Pre-Sales Questions\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Unclaimed Tickets Custom Report (SALES vs REDEMPTION)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/","og_locale":"en_US","og_type":"article","og_title":"Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -","og_description":"We use the ticket system to sell online tickets. We sell bunch of tickets everyday. In the reporting we can see ticket sales, but is there a way to build a report that shows the tickets that have not been redeemed. The perfect reporting would be instead of Sales by Product in woocommerce reporting, we [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/","article_modified_time":"2015-08-11T14:05:04+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/","name":"Unclaimed Tickets Custom Report (SALES vs REDEMPTION) -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2015-07-24T18:57:17+00:00","dateModified":"2015-08-11T14:05:04+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unclaimed-tickets-custom-report-sales-vs-redemption\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Welcome!","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/"},{"@type":"ListItem","position":4,"name":"Pre-Sales Questions","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/_welcome\/pre-sales-questions\/"},{"@type":"ListItem","position":5,"name":"Unclaimed Tickets Custom Report (SALES vs REDEMPTION)"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/990071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/990071\/revisions"}],"predecessor-version":[{"id":990429,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/990071\/revisions\/990429"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=990071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}