{"id":1150,"date":"2018-10-17T19:25:20","date_gmt":"2018-10-17T19:25:20","guid":{"rendered":"https:\/\/help.bmtmicro.com\/vendors\/?page_id=1150"},"modified":"2018-10-18T14:32:48","modified_gmt":"2018-10-18T14:32:48","slug":"sales-detail","status":"publish","type":"page","link":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/","title":{"rendered":"Sales Detail"},"content":{"rendered":"

\u27f5 Back to Reports<\/a><\/p>\n

The Sales Detail report will give you complete information on all sales. The default report displays sales for the last 7 days. This report can be generated by specific date ranges and results output in specified order and format. Formats available are HTML, CSV, XML and PDF.<\/p>\n

You can filter your results making this report a powerful search engine<\/b>! For instance, if John Smith wanted to know what registration key was sent to him back in December of 2009, you could enter the date range of 2009-12-01 to 2009-12-31, select Last Name in the filter list and type Smith in the text box to receive a report on all customers named Smith during that month.<\/p>\n

Default results include the following fields:<\/p>\n\n\n\n\n\n\n\n\n\n
Order ID<\/td>\nProduct Name<\/td>\nPayment Date<\/td>\n<\/tr>\n
Quantity<\/td>\nVendor Royalty<\/td>\nItem Comments<\/td>\n<\/tr>\n
Company<\/td>\nLast Name<\/td>\nFirst Name<\/td>\n<\/tr>\n
Address 1<\/td>\nAddress 2<\/td>\nCity<\/td>\n<\/tr>\n
State<\/td>\nZip<\/td>\nCountry<\/td>\n<\/tr>\n
Phone<\/td>\nFax<\/td>\nEmail<\/td>\n<\/tr>\n
IP Address<\/td>\nReferral<\/td>\nRegistration Keys<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You can customize the output of this report to include any of the following additional fields:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Order Number<\/td>\nOrder Date<\/td>\nCustomer ID<\/td>\n<\/tr>\n
Product ID<\/td>\nProduct Price<\/td>\nDiscount Code<\/td>\n<\/tr>\n
Product Currency<\/td>\nProduct Discount<\/td>\nProduct ID<\/td>\n<\/tr>\n
Vendor Currency<\/td>\nPayment Method<\/td>\nCredit Card Type<\/td>\n<\/tr>\n
Affiliate ID<\/td>\nPO Number<\/td>\nAlternate Email<\/td>\n<\/tr>\n
Register Name<\/td>\nOrder Date<\/td>\nOrder Parameters<\/td>\n<\/tr>\n
Order Number<\/td>\nCustomer ID<\/td>\nOrder Currency<\/td>\n<\/tr>\n
BMT Royalty<\/td>\nAffiliate Royalty<\/td>\nDownload Password<\/td>\n<\/tr>\n
CCom0<\/td>\nCCom1<\/td>\nCCom2<\/td>\n<\/tr>\n
Comments<\/td>\nHowheard<\/td>\nFile Format<\/td>\n<\/tr>\n
Download Password Status<\/td>\nItem Register Name<\/td>\nItem Email<\/td>\n<\/tr>\n
Comments<\/td>\nHowheard<\/td>\nFile Format<\/td>\n<\/tr>\n
Company (Shipping)<\/td>\nLast Name (Shipping)<\/td>\nFirst Name (Shipping)<\/td>\n<\/tr>\n
Address 1 (Shipping)<\/td>\nAddress 2 (Shipping)<\/td>\nCity (Shipping)<\/td>\n<\/tr>\n
State (Shipping)<\/td>\nZip (Shipping)<\/td>\nCountry (Shipping)<\/td>\n<\/tr>\n
Phone (Shipping)<\/td>\nFax (Shipping)<\/td>\nEmail (Shipping)<\/td>\n<\/tr>\n
Extra Reg. Info<\/td>\n<\/td>\nCredited<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

You can select which fields are displayed and what order they are displayed in by adding or removing fields in the Settings page. The Sales Details Configuration section under the Settings page will allow you to choose each column from the drop down list. Just choose the columns in the order you want them and select Submit Changes. Each time you run this report our system will remember your custom settings! We have also added a “Total” row to this report. Totals are column totals and do not take into consideration any currency. If your sales are both USD and Euro, please filter your results by currency to get proper totals.<\/p>\n

You can retrieve the Sales Detail report by posting an XML request as follows:<\/p>\n

URL to post:<\/p>\n

https:\/\/vendors.bmtmicro.com\/servlets\/Vendors.XMLRequest<\/p>\n

method=”post”<\/p>\n

XML request format:<\/p>\n

\r\n<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<request>\r\n<salesdetails>\r\n<vendorid>YourVendorID<\/vendorid>\r\n<password>********<\/password>\r\n\r\n<datefrom>2003-02-01<\/datefrom>\r\n<dateto>2003-02-28<\/dateto>\r\n<\/salesdetails>\r\n<\/request><\/pre>\n
NOTE:<\/b> The date fields must contain a value in the format of YYYY-MM-DD for this feature to work properly.<\/p><\/blockquote>\n
<\/br><\/p>\n
\u27f5 Back to Reports<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u27f5 Back to Reports The Sales Detail report will give you complete information on all sales. The default report displays sales for the last 7 days. This report can be generated by specific date ranges and results output in specified order and format. Formats available are HTML, CSV, XML and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1150","page","type-page","status-publish","hentry"],"yoast_head":"\nSales Detail - BMT Micro, Inc. Vendor FAQ\/Help<\/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:\/\/help.bmtmicro.com\/vendors\/sales-detail\/\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:locale\" content=\"en_US\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:type\" content=\"article\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:title\" content=\"Sales Detail - BMT Micro, Inc. Vendor FAQ\/Help\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:description\" content=\"\u27f5 Back to Reports The Sales Detail report will give you complete information on all sales. The default report displays sales for the last 7 days. This report can be generated by specific date ranges and results output in specified order and format. Formats available are HTML, CSV, XML and […]\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:site_name\" content=\"BMT Micro, Inc. Vendor FAQ\/Help\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bmt.micro\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-18T14:32:48+00:00\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.bmtmicro.com\/vendors\/wp-content\/uploads\/2019\/01\/bmtmicro-logo-600x315.jpg\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"twitter:site\" content=\"@BMTMicro\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" class=\"yoast-seo-meta-tag\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/\",\"url\":\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/\",\"name\":\"Sales Detail - BMT Micro, Inc. Vendor FAQ\/Help\",\"isPartOf\":{\"@id\":\"https:\/\/help.bmtmicro.com\/vendors\/#website\"},\"datePublished\":\"2018-10-17T19:25:20+00:00\",\"dateModified\":\"2018-10-18T14:32:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.bmtmicro.com\/vendors\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sales Detail\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.bmtmicro.com\/vendors\/#website\",\"url\":\"https:\/\/help.bmtmicro.com\/vendors\/\",\"name\":\"BMT Micro, Inc. Vendor FAQ\/Help\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.bmtmicro.com\/vendors\/?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":"Sales Detail - BMT Micro, Inc. Vendor FAQ\/Help","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:\/\/help.bmtmicro.com\/vendors\/sales-detail\/","og_locale":"en_US","og_type":"article","og_title":"Sales Detail - BMT Micro, Inc. Vendor FAQ\/Help","og_description":"\u27f5 Back to Reports The Sales Detail report will give you complete information on all sales. The default report displays sales for the last 7 days. This report can be generated by specific date ranges and results output in specified order and format. Formats available are HTML, CSV, XML and […]","og_url":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/","og_site_name":"BMT Micro, Inc. Vendor FAQ\/Help","article_publisher":"https:\/\/www.facebook.com\/bmt.micro","article_modified_time":"2018-10-18T14:32:48+00:00","og_image":[{"width":600,"height":315,"url":"https:\/\/help.bmtmicro.com\/vendors\/wp-content\/uploads\/2019\/01\/bmtmicro-logo-600x315.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@BMTMicro","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/","url":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/","name":"Sales Detail - BMT Micro, Inc. Vendor FAQ\/Help","isPartOf":{"@id":"https:\/\/help.bmtmicro.com\/vendors\/#website"},"datePublished":"2018-10-17T19:25:20+00:00","dateModified":"2018-10-18T14:32:48+00:00","breadcrumb":{"@id":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.bmtmicro.com\/vendors\/sales-detail\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.bmtmicro.com\/vendors\/"},{"@type":"ListItem","position":2,"name":"Sales Detail"}]},{"@type":"WebSite","@id":"https:\/\/help.bmtmicro.com\/vendors\/#website","url":"https:\/\/help.bmtmicro.com\/vendors\/","name":"BMT Micro, Inc. Vendor FAQ\/Help","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.bmtmicro.com\/vendors\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/pages\/1150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/comments?post=1150"}],"version-history":[{"count":38,"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/pages\/1150\/revisions"}],"predecessor-version":[{"id":1190,"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/pages\/1150\/revisions\/1190"}],"wp:attachment":[{"href":"https:\/\/help.bmtmicro.com\/vendors\/wp-json\/wp\/v2\/media?parent=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}