November 11, 2022 at 10:26 PM
Selling Australia shopping order data. MM accepted @Pom,direct payment also accepted
Dm on Telegram @KParrot
Data include not limited to: First name, Surname, Email,Mobile, ABN, Fax, Ip address,
DBS TABLE:
cartreport 110710
member 1660
orders 13780
TOTAL RECORDS
126,150
Sample :
{"_index":"member","_type":"_doc","_id":"11247","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11247,"Status":"1","Created":"2020-09-07 23:47:27","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Jim","Surname":"Moll","Mobile":"","Fax":"","ABN":"69800918474","ACN":"","BusinessName":"Outback Antics","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"www.outbackantics.com.au","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10786,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"DeliveryAddress":{"ID":10786,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"BusinessAddress":{"ID":10785,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":false}}
{"_index":"member","_type":"_doc","_id":"11261","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11261,"Status":"1","Created":"2020-09-09 14:57:54","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Growers","Surname":"Supplies","Mobile":"","Fax":"08 8280 3777","ABN":"36 055 252 009","ACN":"","BusinessName":"Growers Supplies (SA) Pty Ltd","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"Charmaine Librandi","ReferenceEmail":"","ReferencePhone":"08 8280 3666","Reference2Name":"Jenny Jobson","Reference2Email":"","Reference2Phone":"08 8280 3666 ","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":11006,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"DeliveryAddress":{"ID":11006,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"BusinessAddress":{"ID":11005,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":false}}
{"_index":"member","_type":"_doc","_id":"11237","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11237,"Status":"1","Created":"2020-09-06 22:57:10","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"RICHARD","Surname":"COOLE","Mobile":"0427566221","Fax":"","ABN":"14842378844","ACN":"","BusinessName":"QUANTA PTY LTD","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10658,"FullAddress":", Australia","UnitNumber":"","Address":" ","StreetNumber":"","StreetName":"","StreetSuffix":"","Suburb":"","State":"","PostalCode":"","Country":"Australia","Coordinates":{"lat":-25.274398,"lon":133.775136}},"DeliveryAddress":{"ID":10657,"FullAddress":"1164 Bokerup Road, Frankland River, WA 6396, Australia","UnitNumber":"","Address":" 1164 Bokerup Road ","StreetNumber":"","StreetName":"1164 Bokerup Road","StreetSuffix":"","Suburb":"Frankland River","State":"WA","PostalCode":"6396","Country":"Australia","Coordinates":{"lat":-34.2887884,"lon":116.8285221}},"BusinessAddress":{"ID":10656,"FullAddress":"1164 Bokerup Road, Frankland River, WA 6396, Australia","UnitNumber":"","Address":" 1164 Bokerup Road ","StreetNumber":"","StreetName":"1164 Bokerup Road","StreetSuffix":"","Suburb":"Frankland River","State":"WA","PostalCode":"6396","Country":"Australia","Coordinates":{"lat":-34.2887884,"lon":116.8285221}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":true}}
{"_index":"member","_type":"_doc","_id":"11186","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11186,"Status":"1","Created":"2020-08-31 16:23:06","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Beau","Surname":"Harvey","Mobile":"0429847228","Fax":"","ABN":"68503707001","ACN":"","BusinessName":"WO Harvey and Son","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10141,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"DeliveryAddress":{"ID":11057,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"BusinessAddress":{"ID":10140,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":true}}
sample
{"_index":"orders","_type":"_doc","_id":"131722","_score":1,"_ignored":["OrderInvoice.PaidDate","Shipped","Voided","ReceiptSent"],"_source":{"ID":131722,"Status":"Dispatched","ShippingStatus":"Packed","InternalItemID":"AUO-131722","Placed":"2021-05-10 13:09:08","Paid":"2021-05-11 10:36:08","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Australia Post","FirstName":"Everything","Surname":"ID","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.143","DiscountTotal":1.965,"ShippingTotal":11.6509,"TaxTotal":6.8404,"SubTotal":39.3,"Total":53.8845,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":false,"ContainItemTypes":"RP","ResellerID":10982,"ResellerName":"Everything ID","RegionTitle":"TAS","RegionCountry":"Australia","BillingLat":"-42.3002879","BillingLong":"-42.3002879","CustomerName":"Everything ID","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"Everything ID Promo","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"Australia Post","BoxPackerParcelCount":1,"PostmenTrackingInfo":"YXA500806701000931501","Manifesting":false,"Manifested":true,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":43.0335,"BusinessName":"Everything ID","Items":[{"ID":106204,"Title":"Woolbale Hook Single Prong","InternalItemID":"WBALE1017","DisplayImage":"/assets/ProcessedImages/WBALE1017__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":3,"TotalPackageItems":0,"TotalItems":3,"UnitPrice":13.1,"UnitTax":1.31,"TotalUnitPrice":43.230000000000004,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":3.7335,"TotalPriceWithoutTax":37.334999999999994,"TotalPrice":41.06849999999999,"IsTaxable":true,"CategoryTitle":"Wool Handling Products","CalculatedUnitCOGS":5.57,"CalculatedTotalCOGS":16.71}],"Member":{"ID":10982,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":0,"Email":"","SingularName":"Member"},"BillingAddress":{"ID":50651,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3002879,"lon":147.3707947}},"ShippingAddress":{"ID":50648,"FullAddress":"2099 Murringo Road, Murringo, NSW 2586, Australia","UnitNumber":"","Address":" 2099 Murringo Road ","StreetNumber":"","StreetName":"2099 Murringo Road","StreetSuffix":"","Suburb":"Murringo","State":"NSW","PostalCode":"2586","Country":"Australia","Coordinates":{"lat":-34.319277,"lon":148.5231541}},"OrderInvoice":{"ID":14959,"Created":"2021-05-12 15:11:06","InternalItemID":"AUI-14959","Status":"Unpaid","Pending":53.88,"Paid":0,"TotalDue":53.88,"Currency":"AUD","PaidDate":"","DueDate":"2021-05-10 13:06:07"},"NestedItems":[{"ID":106204,"Title":"Woolbale Hook Single Prong","InternalItemID":"WBALE1017","TotalItems":3,"TotalPrice":41.06849999999999,"CategoryTitle":"Wool Handling Products","CalculatedTotalDiscount":1.965}],"AppliedDiscountCoupon":{"ID":83,"InternalItemID":"CAU1093983","Title":"Everything ID Promo","Usage":"Multiple","OwnedByID":10939,"ReferrerID":0},"MemberPriceListItems":[{"ID":763036,"SubTotal":39.3,"TotalDiscount":0,"TaxTotal":3.7335,"Total":43.0335,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Everything ID","SupplierName":"Leader Products Pty Ltd"},{"ID":763037,"SubTotal":16.71,"TotalDiscount":0,"TaxTotal":0,"Total":16.71,"MarginSubTotal":20.625,"MarginTaxTotal":0,"MarginTotal":20.625,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"130249","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":130249,"Status":"Production Complete","ShippingStatus":"None","InternalItemID":"AUO-130249","Placed":"2021-04-28 18:07:15","Paid":"2021-04-29 12:58:45","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Chris","Surname":"Vanzetti","Email":"[[email protected]][email protected][/email]","Notes":"BP","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":34,"SubTotal":340,"Total":374,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11330,"ResellerName":"Elders Moora","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-30.6396656","BillingLong":"-30.6396656","CustomerName":"Chris Vanzetti","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":374,"BusinessName":"Elders Moora","Items":[{"ID":101171,"Title":"Leadertag Yellow","InternalItemID":"LT7","DisplayImage":"/assets/ProcessedImages/LT7-NEW2-WCI-24062020_NM__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":154.00000000000003,"PackagePrice":0.14,"PackageTax":0.014,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":30},{"ID":101172,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":2000,"TotalPackageItems":0,"TotalItems":2000,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":220,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":20,"TotalPriceWithoutTax":200,"TotalPrice":220,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":260}],"Member":{"ID":11330,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":48456,"FullAddress":"59 Padbury Street, Moora, WA 6510, Australia","UnitNumber":"","Address":" 59 Padbury Street ","StreetNumber":"","StreetName":"59 Padbury Street","StreetSuffix":"","Suburb":"Moora","State":"WA","PostalCode":"6510","Country":"Australia","Coordinates":{"lat":-30.6396656,"lon":116.0077359}},"ShippingAddress":{"ID":47525,"FullAddress":"59 Padbury Street, Moora, WA 6510, Australia","UnitNumber":"","Address":" 59 Padbury Street ","StreetNumber":"","StreetName":"59 Padbury Street","StreetSuffix":"","Suburb":"Moora","State":"WA","PostalCode":"6510","Country":"Australia","Coordinates":{"lat":-30.6396656,"lon":116.0077359}},"OrderInvoice":null,"NestedItems":[{"ID":101171,"Title":"Leadertag Yellow","InternalItemID":"LT7","TotalItems":1000,"TotalPrice":154,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":101172,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":2000,"TotalPrice":220,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":761040,"SubTotal":340,"TotalDiscount":0,"TaxTotal":34,"Total":374,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Elders Moora","SupplierName":"Leader Products Pty Ltd"},{"ID":761041,"SubTotal":300,"TotalDiscount":0,"TaxTotal":0,"Total":300,"MarginSubTotal":40,"MarginTaxTotal":0,"MarginTotal":40,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"116667","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"ID":116667,"Status":"Awaiting Upstream Approval","ShippingStatus":"None","InternalItemID":"AUO-116667","Placed":"2021-05-11 16:07:24","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Mieke","Surname":"Bohlen","Email":"[[email protected]][email protected][/email]","Notes":"TG & RC SUTHERLAND
PERTH
FM","IPAddress":"10.137.194.46","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":39,"SubTotal":390,"Total":429,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11533,"ResellerName":"Nutrien Badgingarra Retail Store","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-30.3919643","BillingLong":"-30.3919643","CustomerName":"Mieke Bohlen","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":429,"BusinessName":"Nutrien Badgingarra Retail Store","Items":[{"ID":107716,"Title":"Multitag Yellow","InternalItemID":"MT7","DisplayImage":"/assets/ProcessedImages/MT7-YELLOW-F-RS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":154.00000000000003,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":30},{"ID":107717,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.25,"UnitTax":0.025,"TotalUnitPrice":275,"PackagePrice":0.25,"PackageTax":0.025,"TotalPackagePrice":0,"TotalTax":25,"TotalPriceWithoutTax":250,"TotalPrice":275,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":130}],"Member":{"ID":11533,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51166,"FullAddress":"20 Meagher Drive, Badgingarra, WA 6521, Australia","UnitNumber":"","Address":" 20 Meagher Drive ","StreetNumber":"","StreetName":"20 Meagher Drive","StreetSuffix":"","Suburb":"Badgingarra","State":"WA","PostalCode":"6521","Country":"Australia","Coordinates":{"lat":-30.3919643,"lon":115.501419}},"ShippingAddress":{"ID":51513,"FullAddress":"20 Meagher Drive, Badgingarra, WA 6521, Australia","UnitNumber":"","Address":" 20 Meagher Drive ","StreetNumber":"","StreetName":"20 Meagher Drive","StreetSuffix":"","Suburb":"Badgingarra","State":"WA","PostalCode":"6521","Country":"Australia","Coordinates":{"lat":-30.3919643,"lon":115.501419}},"OrderInvoice":null,"NestedItems":[{"ID":107716,"Title":"Multitag Yellow","InternalItemID":"MT7","TotalItems":1000,"TotalPrice":154,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":107717,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":1000,"TotalPrice":275,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763761,"SubTotal":390,"TotalDiscount":0,"TaxTotal":39,"Total":429,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Nutrien Badgingarra Retail Store","SupplierName":"Leader Products Pty Ltd"},{"ID":763762,"SubTotal":170,"TotalDiscount":0,"TaxTotal":0,"Total":170,"MarginSubTotal":220,"MarginTaxTotal":0,"MarginTotal":220,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"131978","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":131978,"Status":"Dispatched","ShippingStatus":"Packed","InternalItemID":"AUO-131978","Placed":"2021-05-12 10:40:53","Paid":"2021-05-12 12:00:47","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"RUTH","Surname":"OVERDIJK","Email":"[[email protected]][email protected][/email]","Notes":"SH - URGENT
SEND FROM DALBY AUS POST","IPAddress":"10.137.194.46","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":14,"SubTotal":140,"Total":154,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11398,"ResellerName":"Norco Rural (Lismore)","RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-28.8104015","BillingLong":"-28.8104015","CustomerName":"RUTH OVERDIJK","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":154,"BusinessName":"Norco Rural (Lismore)","Items":[{"ID":107460,"Title":"Enviro / Button Male White","InternalItemID":"EENCMB8","DisplayImage":"/assets/ProcessedImages/EENCMB8-WHITE-NLIS-1S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":70,"TotalPackageItems":0,"TotalItems":70,"UnitPrice":2,"UnitTax":0.2,"TotalUnitPrice":154,"PackagePrice":2,"PackageTax":0.2,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Electronic Identification","CalculatedUnitCOGS":0.82,"CalculatedTotalCOGS":57.4}],"Member":{"ID":11398,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51341,"FullAddress":"105 Wilson Street, South Lismore, NSW 2480, Australia","UnitNumber":"","Address":" 105 Wilson Street ","StreetNumber":"","StreetName":"105 Wilson Street","StreetSuffix":"","Suburb":"South Lismore","State":"NSW","PostalCode":"2480","Country":"Australia","Coordinates":{"lat":-28.8104015,"lon":153.2602422}},"ShippingAddress":{"ID":51344,"FullAddress":"105 Wilson Street, South Lismore, NSW 2480, Australia","UnitNumber":"","Address":" 105 Wilson Street ","StreetNumber":"","StreetName":"105 Wilson Street","StreetSuffix":"","Suburb":"South Lismore","State":"NSW","PostalCode":"2480","Country":"Australia","Coordinates":{"lat":-28.8104015,"lon":153.2602422}},"OrderInvoice":null,"NestedItems":[{"ID":107460,"Title":"Enviro / Button Male White","InternalItemID":"EENCMB8","TotalItems":70,"TotalPrice":154,"CategoryTitle":"Electronic Identification","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763626,"SubTotal":140,"TotalDiscount":0,"TaxTotal":14,"Total":154,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Norco Rural (Lismore)","SupplierName":"Leader Products Pty Ltd"},{"ID":763627,"SubTotal":74.2,"TotalDiscount":0,"TaxTotal":0,"Total":74.2,"MarginSubTotal":65.8,"MarginTaxTotal":0,"MarginTotal":65.8,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"130866","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":130866,"Status":"Production Complete","ShippingStatus":"None","InternalItemID":"AUO-130866","Placed":"2021-05-11 13:07:16","Paid":"2021-05-11 13:17:14","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Ashley","Surname":"Wilkins","Email":"[[email protected]][email protected][/email]","Notes":"EAGLE VISION
PERTH
FM","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":3.9,"SubTotal":39,"Total":42.9,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":10995,"ResellerName":"FarmWorks Narrogin","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-32.9301691","BillingLong":"-32.9301691","CustomerName":"Ashley Wilkins","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":42.9,"BusinessName":"FarmWorks Narrogin","Items":[{"ID":106874,"Title":"Leadertag Yellow","InternalItemID":"LT7","DisplayImage":"/assets/ProcessedImages/LT7-NEW2-WCI-24062020_NM__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":15.400000000000002,"PackagePrice":0.14,"PackageTax":0.014,"TotalPackagePrice":0,"TotalTax":1.4,"TotalPriceWithoutTax":14,"TotalPrice":15.4,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":3},{"ID":106875,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.25,"UnitTax":0.025,"TotalUnitPrice":27.500000000000004,"PackagePrice":0.25,"PackageTax":0.025,"TotalPackagePrice":0,"TotalTax":2.5,"TotalPriceWithoutTax":25,"TotalPrice":27.5,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":13}],"Member":{"ID":10995,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51034,"FullAddress":"55 - 59 Earl Street, Narrogin, WA 6312, Australia","UnitNumber":"","Address":" 55 - 59 Earl Street ","StreetNumber":"","StreetName":"55 - 59 Earl Street","StreetSuffix":"","Suburb":"Narrogin","State":"WA","PostalCode":"6312","Country":"Australia","Coordinates":{"lat":-32.9301691,"lon":117.1769808}},"ShippingAddress":{"ID":48841,"FullAddress":"55 - 59 Earl Street, Narrogin, WA 6312, Australia","UnitNumber":"","Address":" 55 - 59 Earl Street ","StreetNumber":"","StreetName":"55 - 59 Earl Street","StreetSuffix":"","Suburb":"Narrogin","State":"WA","PostalCode":"6312","Country":"Australia","Coordinates":{"lat":-32.9301691,"lon":117.1769808}},"OrderInvoice":null,"NestedItems":[{"ID":106874,"Title":"Leadertag Yellow","InternalItemID":"LT7","TotalItems":100,"TotalPrice":15.4,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":106875,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":100,"TotalPrice":27.5,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763355,"SubTotal":39,"TotalDiscount":0,"TaxTotal":3.9,"Total":42.9,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"FarmWorks Narrogin","SupplierName":"Leader Products Pty Ltd"},{"ID":763356,"SubTotal":17,"TotalDiscount":0,"TaxTotal":0,"Total":17,"MarginSubTotal":22,"MarginTaxTotal":0,"MarginTotal":22,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"cartreport","_type":"_doc","_id":"166077","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119727,"LogFor":"Status","Status":"Awaiting Fulfilment","Created":"2020-12-11 09:17:47","LastEdited":"2020-12-11 09:17:47","ShippingStatus":"None","InternalItemID":"AUO-119727","Placed":"2020-12-10 18:38:58","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Charlie","Surname":"Meaburn","Email":"[[email protected]][email protected][/email]","Notes":"URGENT - Please process urgently with StarTrack
dalby","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":37.056,"SubTotal":370.56,"Total":407.616,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Everything ID","ResellerID":10982,"RegionTitle":"TAS","RegionCountry":"Australia","BillingLat":"-42.3","BillingLong":"-42.3","CustomerName":"Charlie Meaburn","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"19:33:54","CumulativeDurationTimeStamp":70434,"Items":[{"ID":43610,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":41.470000000000006,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":3.77,"TotalPriceWithoutTax":37.7,"TotalPrice":41.470000000000006,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43611,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":41.470000000000006,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":3.77,"TotalPriceWithoutTax":37.7,"TotalPrice":41.470000000000006,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43612,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":27.885,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.535,"TotalPriceWithoutTax":25.35,"TotalPrice":27.885,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43613,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":27.885,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.535,"TotalPriceWithoutTax":25.35,"TotalPrice":27.885,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43614,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":25.025000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.275,"TotalPriceWithoutTax":22.75,"TotalPrice":25.025,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43615,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":25.025000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.275,"TotalPriceWithoutTax":22.75,"TotalPrice":25.025,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43616,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":20.020000000000003,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":1.82,"TotalPriceWithoutTax":18.2,"TotalPrice":20.02,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43617,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":20.020000000000003,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":1.82,"TotalPriceWithoutTax":18.2,"TotalPrice":20.02,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43618,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":24.310000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.21,"TotalPriceWithoutTax":22.1,"TotalPrice":24.310000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43619,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":24.310000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.21,"TotalPriceWithoutTax":22.1,"TotalPrice":24.310000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43620,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":6,"TotalPackageItems":0,"TotalItems":6,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":4.290000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":0.39,"TotalPriceWithoutTax":3.9,"TotalPrice":4.29,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43621,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":21.054,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.914,"TotalPriceWithoutTax":19.14,"TotalPrice":21.054000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43622,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":21.054,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.914,"TotalPriceWithoutTax":19.14,"TotalPrice":21.054000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43623,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":14.157,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.287,"TotalPriceWithoutTax":12.870000000000001,"TotalPrice":14.157,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43624,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":14.157,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.287,"TotalPriceWithoutTax":12.870000000000001,"TotalPrice":14.157,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43625,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":10.010000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.91,"TotalPriceWithoutTax":9.1,"TotalPrice":10.01,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43626,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":10.010000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.91,"TotalPriceWithoutTax":9.1,"TotalPrice":10.01,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43627,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":8.008000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.728,"TotalPriceWithoutTax":7.280000000000001,"TotalPrice":8.008000000000001,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43628,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":8.008000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.728,"TotalPriceWithoutTax":7.280000000000001,"TotalPrice":8.008000000000001,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43629,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":9.724,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.884,"TotalPriceWithoutTax":8.84,"TotalPrice":9.724,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43630,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":9.724,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.884,"TotalPriceWithoutTax":8.84,"TotalPrice":9.724,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"}],"Member":{"ID":10982,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24478,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3,"lon":147.370556}},"ShippingAddress":{"ID":24478,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3,"lon":147.370556}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166065","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119729,"LogFor":"Status","Status":"Awaiting Fulfilment","Created":"2020-12-11 09:09:57","LastEdited":"2020-12-11 09:09:57","ShippingStatus":"None","InternalItemID":"AUO-119729","Placed":"2020-12-10 16:46:41","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Sally","Surname":"Packham","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":22.9309,"TaxTotal":13.1149,"SubTotal":70,"Total":102.224,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Eartags Warehouse","ResellerID":10987,"RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-32.2315018","BillingLong":"-32.2315018","CustomerName":"Sally Packham","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"19:01:24","CumulativeDurationTimeStamp":68484,"Items":[{"ID":43515,"Title":"Jumbo Leadertag Blue","InternalItemID":"JLT11","DisplayImage":"/assets/ProcessedImages/JLT11-BLUE-F-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.15,"UnitTax":0.015,"TotalUnitPrice":16.499999999999996,"CalculatedTotalDiscount":0,"PackagePrice":0.15,"PackageTax":0.015,"TotalPackagePrice":0,"TotalTax":1.5,"TotalPriceWithoutTax":15,"TotalPrice":16.5,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43516,"Title":"1 Line Laser Marking Sheep","InternalItemID":"1LS","DisplayImage":"/assets/ProcessedImages/1LS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":200,"TotalPackageItems":0,"TotalItems":200,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":22,"CalculatedTotalDiscount":0,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":2,"TotalPriceWithoutTax":20,"TotalPrice":22,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep"},{"ID":43517,"Title":"Jumbo Leadertag Red","InternalItemID":"JLT10","DisplayImage":"/assets/ProcessedImages/JLT10-RED-F-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.15,"UnitTax":0.015,"TotalUnitPrice":16.499999999999996,"CalculatedTotalDiscount":0,"PackagePrice":0.15,"PackageTax":0.015,"TotalPackagePrice":0,"TotalTax":1.5,"TotalPriceWithoutTax":15,"TotalPrice":16.5,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43518,"Title":"1 Line Laser Marking Sheep","InternalItemID":"1LS","DisplayImage":"/assets/ProcessedImages/1LS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":200,"TotalPackageItems":0,"TotalItems":200,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":22,"CalculatedTotalDiscount":0,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":2,"TotalPriceWithoutTax":20,"TotalPrice":22,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep"}],"Member":{"ID":10987,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24471,"FullAddress":"PO Box 6049, Dubbo, NSW 2830, Australia","UnitNumber":"","Address":" PO Box 6049 ","StreetNumber":"","StreetName":"PO Box 6049","StreetSuffix":"","Suburb":"Dubbo","State":"NSW","PostalCode":"2830","Country":"Australia","Coordinates":{"lat":-32.2315018,"lon":148.6329645}},"ShippingAddress":{"ID":24471,"FullAddress":"PO Box 6049, Dubbo, NSW 2830, Australia","UnitNumber":"","Address":" PO Box 6049 ","StreetNumber":"","StreetName":"PO Box 6049","StreetSuffix":"","Suburb":"Dubbo","State":"NSW","PostalCode":"2830","Country":"Australia","Coordinates":{"lat":-32.2315018,"lon":148.6329645}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166066","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119123,"LogFor":"Status","Status":"Dispatched","Created":"2020-12-11 09:10:18","LastEdited":"2020-12-11 09:10:18","ShippingStatus":"Packed","InternalItemID":"AUO-119123","Placed":"2020-12-10 15:20:28","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Felicity","Surname":"Simpson","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":9.7963,"TaxTotal":36.6124,"SubTotal":40,"Total":84.776,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Nutrien Strathalbyn Retail Store","ResellerID":11256,"RegionTitle":"VIC","RegionCountry":"Australia","BillingLat":"-37.8202276","BillingLong":"-37.8202276","CustomerName":"Felicity Simpson","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"214:33:15","CumulativeDurationTimeStamp":772395,"Items":[{"ID":43400,"Title":"Enviro / Button Male Orange","InternalItemID":"EENCMB6","DisplayImage":"/assets/ProcessedImages/EENCMB6-ORANGE-NLIS-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":20,"TotalPackageItems":0,"TotalItems":20,"UnitPrice":2,"UnitTax":1.7,"TotalUnitPrice":74,"CalculatedTotalDiscount":0,"PackagePrice":2,"PackageTax":1.7,"TotalPackagePrice":0,"TotalTax":34,"TotalPriceWithoutTax":40,"TotalPrice":74,"COGS":0,"IsTaxable":true,"CategoryTitle":"Electronic Identification"}],"Member":{"ID":11256,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24456,"FullAddress":"PO Box 4562, DOCKLANDS, VIC 3008, Australia","UnitNumber":"","Address":" PO Box 4562 ","StreetNumber":"","StreetName":"PO Box 4562","StreetSuffix":"","Suburb":"DOCKLANDS","State":"VIC","PostalCode":"3008","Country":"Australia","Coordinates":{"lat":-37.8202276,"lon":144.943006}},"ShippingAddress":{"ID":24456,"FullAddress":"PO Box 4562, DOCKLANDS, VIC 3008, Australia","UnitNumber":"","Address":" PO Box 4562 ","StreetNumber":"","StreetName":"PO Box 4562","StreetSuffix":"","Suburb":"DOCKLANDS","State":"VIC","PostalCode":"3008","Country":"Australia","Coordinates":{"lat":-37.8202276,"lon":144.943006}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166063","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119720,"LogFor":"Status","Status":"Dispatched","Created":"2020-12-11 09:05:53","LastEdited":"2020-12-11 09:05:53","ShippingStatus":"Packed","InternalItemID":"AUO-119720","Placed":"2020-12-10 13:23:58","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Sally","Surname":"Packham","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":9.7963,"TaxTotal":5.8524,"SubTotal":32.4,"Total":46.416,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Eartags Warehouse","ResellerID":10987,"RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-32.2315018","BillingLong":"-32.2315018","CustomerName":"Sally Packham","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"20:04:53","
Dm on Telegram @KParrot
Data include not limited to: First name, Surname, Email,Mobile, ABN, Fax, Ip address,
DBS TABLE:
cartreport 110710
member 1660
orders 13780
TOTAL RECORDS
126,150
Sample :
{"_index":"member","_type":"_doc","_id":"11247","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11247,"Status":"1","Created":"2020-09-07 23:47:27","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Jim","Surname":"Moll","Mobile":"","Fax":"","ABN":"69800918474","ACN":"","BusinessName":"Outback Antics","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"www.outbackantics.com.au","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10786,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"DeliveryAddress":{"ID":10786,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"BusinessAddress":{"ID":10785,"FullAddress":"1694 Benalla-Tatong Road, Tatong, VIC 3673, Australia","UnitNumber":"","Address":" 1694 Benalla-Tatong Road ","StreetNumber":"","StreetName":"1694 Benalla-Tatong Road","StreetSuffix":"","Suburb":"Tatong","State":"VIC","PostalCode":"3673","Country":"Australia","Coordinates":{"lat":-36.6588841,"lon":146.077559}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":false}}
{"_index":"member","_type":"_doc","_id":"11261","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11261,"Status":"1","Created":"2020-09-09 14:57:54","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Growers","Surname":"Supplies","Mobile":"","Fax":"08 8280 3777","ABN":"36 055 252 009","ACN":"","BusinessName":"Growers Supplies (SA) Pty Ltd","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"Charmaine Librandi","ReferenceEmail":"","ReferencePhone":"08 8280 3666","Reference2Name":"Jenny Jobson","Reference2Email":"","Reference2Phone":"08 8280 3666 ","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":11006,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"DeliveryAddress":{"ID":11006,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"BusinessAddress":{"ID":11005,"FullAddress":"48 Hawker Road, Burton, SA 5110, Australia","UnitNumber":"","Address":" 48 Hawker Road ","StreetNumber":"","StreetName":"48 Hawker Road","StreetSuffix":"","Suburb":"Burton","State":"SA","PostalCode":"5110","Country":"Australia","Coordinates":{"lat":-34.7277532,"lon":138.603815}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":false}}
{"_index":"member","_type":"_doc","_id":"11237","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11237,"Status":"1","Created":"2020-09-06 22:57:10","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"RICHARD","Surname":"COOLE","Mobile":"0427566221","Fax":"","ABN":"14842378844","ACN":"","BusinessName":"QUANTA PTY LTD","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10658,"FullAddress":", Australia","UnitNumber":"","Address":" ","StreetNumber":"","StreetName":"","StreetSuffix":"","Suburb":"","State":"","PostalCode":"","Country":"Australia","Coordinates":{"lat":-25.274398,"lon":133.775136}},"DeliveryAddress":{"ID":10657,"FullAddress":"1164 Bokerup Road, Frankland River, WA 6396, Australia","UnitNumber":"","Address":" 1164 Bokerup Road ","StreetNumber":"","StreetName":"1164 Bokerup Road","StreetSuffix":"","Suburb":"Frankland River","State":"WA","PostalCode":"6396","Country":"Australia","Coordinates":{"lat":-34.2887884,"lon":116.8285221}},"BusinessAddress":{"ID":10656,"FullAddress":"1164 Bokerup Road, Frankland River, WA 6396, Australia","UnitNumber":"","Address":" 1164 Bokerup Road ","StreetNumber":"","StreetName":"1164 Bokerup Road","StreetSuffix":"","Suburb":"Frankland River","State":"WA","PostalCode":"6396","Country":"Australia","Coordinates":{"lat":-34.2887884,"lon":116.8285221}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":true}}
{"_index":"member","_type":"_doc","_id":"11186","_score":1,"_ignored":["EstablishedDate"],"_source":{"ID":11186,"Status":"1","Created":"2020-08-31 16:23:06","ExternalItemID":"","Email":"[[email protected]][email protected][/email]","FirstName":"Beau","Surname":"Harvey","Mobile":"0429847228","Fax":"","ABN":"68503707001","ACN":"","BusinessName":"WO Harvey and Son","TradingName":"","EstablishedDate":"","NLISPropertyName":"","Website":"","BSB":"","BankAccountName":"","BankAccountNumber":"","BankSwiftCode":"","ReferenceName":"","ReferenceEmail":"","ReferencePhone":"","Reference2Name":"","Reference2Email":"","Reference2Phone":"","Reference3Name":"","Reference3Email":"","Reference3Phone":"","Reference4Name":"","Reference4Email":"","Reference4Phone":"","Reference5Name":"","Reference5Email":"","Reference5Phone":"","Parent":{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""},"Suppliers":[{"ID":10939,"Title":"Products, Leader","Email":"[[email protected]][email protected][/email]","FirstName":"Leader","Surname":"Products","ExternalItemID":""}],"Groups":[{"ID":5,"Title":"Reseller","Code":"reseller"}],"BillingAddress":{"ID":10141,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"DeliveryAddress":{"ID":11057,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"BusinessAddress":{"ID":10140,"FullAddress":"Tone Road, Mobrup, WA 6395, Australia","UnitNumber":"","Address":" Tone Road ","StreetNumber":"","StreetName":"Tone Road","StreetSuffix":"","Suburb":"Mobrup","State":"WA","PostalCode":"6395","Country":"Australia","Coordinates":{"lat":-34.0738662,"lon":116.8552152}},"DeliveryRadius":0,"SingularName":"Reseller","ApprovedBySupplier":true,"SelectedRegionID":3,"Hidden":true}}
sample
{"_index":"orders","_type":"_doc","_id":"131722","_score":1,"_ignored":["OrderInvoice.PaidDate","Shipped","Voided","ReceiptSent"],"_source":{"ID":131722,"Status":"Dispatched","ShippingStatus":"Packed","InternalItemID":"AUO-131722","Placed":"2021-05-10 13:09:08","Paid":"2021-05-11 10:36:08","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Australia Post","FirstName":"Everything","Surname":"ID","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.143","DiscountTotal":1.965,"ShippingTotal":11.6509,"TaxTotal":6.8404,"SubTotal":39.3,"Total":53.8845,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":false,"ContainItemTypes":"RP","ResellerID":10982,"ResellerName":"Everything ID","RegionTitle":"TAS","RegionCountry":"Australia","BillingLat":"-42.3002879","BillingLong":"-42.3002879","CustomerName":"Everything ID","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"Everything ID Promo","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"Australia Post","BoxPackerParcelCount":1,"PostmenTrackingInfo":"YXA500806701000931501","Manifesting":false,"Manifested":true,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":43.0335,"BusinessName":"Everything ID","Items":[{"ID":106204,"Title":"Woolbale Hook Single Prong","InternalItemID":"WBALE1017","DisplayImage":"/assets/ProcessedImages/WBALE1017__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":3,"TotalPackageItems":0,"TotalItems":3,"UnitPrice":13.1,"UnitTax":1.31,"TotalUnitPrice":43.230000000000004,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":3.7335,"TotalPriceWithoutTax":37.334999999999994,"TotalPrice":41.06849999999999,"IsTaxable":true,"CategoryTitle":"Wool Handling Products","CalculatedUnitCOGS":5.57,"CalculatedTotalCOGS":16.71}],"Member":{"ID":10982,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":0,"Email":"","SingularName":"Member"},"BillingAddress":{"ID":50651,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3002879,"lon":147.3707947}},"ShippingAddress":{"ID":50648,"FullAddress":"2099 Murringo Road, Murringo, NSW 2586, Australia","UnitNumber":"","Address":" 2099 Murringo Road ","StreetNumber":"","StreetName":"2099 Murringo Road","StreetSuffix":"","Suburb":"Murringo","State":"NSW","PostalCode":"2586","Country":"Australia","Coordinates":{"lat":-34.319277,"lon":148.5231541}},"OrderInvoice":{"ID":14959,"Created":"2021-05-12 15:11:06","InternalItemID":"AUI-14959","Status":"Unpaid","Pending":53.88,"Paid":0,"TotalDue":53.88,"Currency":"AUD","PaidDate":"","DueDate":"2021-05-10 13:06:07"},"NestedItems":[{"ID":106204,"Title":"Woolbale Hook Single Prong","InternalItemID":"WBALE1017","TotalItems":3,"TotalPrice":41.06849999999999,"CategoryTitle":"Wool Handling Products","CalculatedTotalDiscount":1.965}],"AppliedDiscountCoupon":{"ID":83,"InternalItemID":"CAU1093983","Title":"Everything ID Promo","Usage":"Multiple","OwnedByID":10939,"ReferrerID":0},"MemberPriceListItems":[{"ID":763036,"SubTotal":39.3,"TotalDiscount":0,"TaxTotal":3.7335,"Total":43.0335,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Everything ID","SupplierName":"Leader Products Pty Ltd"},{"ID":763037,"SubTotal":16.71,"TotalDiscount":0,"TaxTotal":0,"Total":16.71,"MarginSubTotal":20.625,"MarginTaxTotal":0,"MarginTotal":20.625,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"130249","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":130249,"Status":"Production Complete","ShippingStatus":"None","InternalItemID":"AUO-130249","Placed":"2021-04-28 18:07:15","Paid":"2021-04-29 12:58:45","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Chris","Surname":"Vanzetti","Email":"[[email protected]][email protected][/email]","Notes":"BP","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":34,"SubTotal":340,"Total":374,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11330,"ResellerName":"Elders Moora","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-30.6396656","BillingLong":"-30.6396656","CustomerName":"Chris Vanzetti","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":374,"BusinessName":"Elders Moora","Items":[{"ID":101171,"Title":"Leadertag Yellow","InternalItemID":"LT7","DisplayImage":"/assets/ProcessedImages/LT7-NEW2-WCI-24062020_NM__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":154.00000000000003,"PackagePrice":0.14,"PackageTax":0.014,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":30},{"ID":101172,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":2000,"TotalPackageItems":0,"TotalItems":2000,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":220,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":20,"TotalPriceWithoutTax":200,"TotalPrice":220,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":260}],"Member":{"ID":11330,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":48456,"FullAddress":"59 Padbury Street, Moora, WA 6510, Australia","UnitNumber":"","Address":" 59 Padbury Street ","StreetNumber":"","StreetName":"59 Padbury Street","StreetSuffix":"","Suburb":"Moora","State":"WA","PostalCode":"6510","Country":"Australia","Coordinates":{"lat":-30.6396656,"lon":116.0077359}},"ShippingAddress":{"ID":47525,"FullAddress":"59 Padbury Street, Moora, WA 6510, Australia","UnitNumber":"","Address":" 59 Padbury Street ","StreetNumber":"","StreetName":"59 Padbury Street","StreetSuffix":"","Suburb":"Moora","State":"WA","PostalCode":"6510","Country":"Australia","Coordinates":{"lat":-30.6396656,"lon":116.0077359}},"OrderInvoice":null,"NestedItems":[{"ID":101171,"Title":"Leadertag Yellow","InternalItemID":"LT7","TotalItems":1000,"TotalPrice":154,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":101172,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":2000,"TotalPrice":220,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":761040,"SubTotal":340,"TotalDiscount":0,"TaxTotal":34,"Total":374,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Elders Moora","SupplierName":"Leader Products Pty Ltd"},{"ID":761041,"SubTotal":300,"TotalDiscount":0,"TaxTotal":0,"Total":300,"MarginSubTotal":40,"MarginTaxTotal":0,"MarginTotal":40,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"116667","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"ID":116667,"Status":"Awaiting Upstream Approval","ShippingStatus":"None","InternalItemID":"AUO-116667","Placed":"2021-05-11 16:07:24","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Mieke","Surname":"Bohlen","Email":"[[email protected]][email protected][/email]","Notes":"TG & RC SUTHERLAND
PERTH
FM","IPAddress":"10.137.194.46","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":39,"SubTotal":390,"Total":429,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11533,"ResellerName":"Nutrien Badgingarra Retail Store","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-30.3919643","BillingLong":"-30.3919643","CustomerName":"Mieke Bohlen","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":429,"BusinessName":"Nutrien Badgingarra Retail Store","Items":[{"ID":107716,"Title":"Multitag Yellow","InternalItemID":"MT7","DisplayImage":"/assets/ProcessedImages/MT7-YELLOW-F-RS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":154.00000000000003,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":30},{"ID":107717,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":1000,"TotalPackageItems":0,"TotalItems":1000,"UnitPrice":0.25,"UnitTax":0.025,"TotalUnitPrice":275,"PackagePrice":0.25,"PackageTax":0.025,"TotalPackagePrice":0,"TotalTax":25,"TotalPriceWithoutTax":250,"TotalPrice":275,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":130}],"Member":{"ID":11533,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51166,"FullAddress":"20 Meagher Drive, Badgingarra, WA 6521, Australia","UnitNumber":"","Address":" 20 Meagher Drive ","StreetNumber":"","StreetName":"20 Meagher Drive","StreetSuffix":"","Suburb":"Badgingarra","State":"WA","PostalCode":"6521","Country":"Australia","Coordinates":{"lat":-30.3919643,"lon":115.501419}},"ShippingAddress":{"ID":51513,"FullAddress":"20 Meagher Drive, Badgingarra, WA 6521, Australia","UnitNumber":"","Address":" 20 Meagher Drive ","StreetNumber":"","StreetName":"20 Meagher Drive","StreetSuffix":"","Suburb":"Badgingarra","State":"WA","PostalCode":"6521","Country":"Australia","Coordinates":{"lat":-30.3919643,"lon":115.501419}},"OrderInvoice":null,"NestedItems":[{"ID":107716,"Title":"Multitag Yellow","InternalItemID":"MT7","TotalItems":1000,"TotalPrice":154,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":107717,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":1000,"TotalPrice":275,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763761,"SubTotal":390,"TotalDiscount":0,"TaxTotal":39,"Total":429,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Nutrien Badgingarra Retail Store","SupplierName":"Leader Products Pty Ltd"},{"ID":763762,"SubTotal":170,"TotalDiscount":0,"TaxTotal":0,"Total":170,"MarginSubTotal":220,"MarginTaxTotal":0,"MarginTotal":220,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"131978","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":131978,"Status":"Dispatched","ShippingStatus":"Packed","InternalItemID":"AUO-131978","Placed":"2021-05-12 10:40:53","Paid":"2021-05-12 12:00:47","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"RUTH","Surname":"OVERDIJK","Email":"[[email protected]][email protected][/email]","Notes":"SH - URGENT
SEND FROM DALBY AUS POST","IPAddress":"10.137.194.46","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":14,"SubTotal":140,"Total":154,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":11398,"ResellerName":"Norco Rural (Lismore)","RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-28.8104015","BillingLong":"-28.8104015","CustomerName":"RUTH OVERDIJK","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":154,"BusinessName":"Norco Rural (Lismore)","Items":[{"ID":107460,"Title":"Enviro / Button Male White","InternalItemID":"EENCMB8","DisplayImage":"/assets/ProcessedImages/EENCMB8-WHITE-NLIS-1S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":70,"TotalPackageItems":0,"TotalItems":70,"UnitPrice":2,"UnitTax":0.2,"TotalUnitPrice":154,"PackagePrice":2,"PackageTax":0.2,"TotalPackagePrice":0,"TotalTax":14,"TotalPriceWithoutTax":140,"TotalPrice":154,"IsTaxable":true,"CategoryTitle":"Electronic Identification","CalculatedUnitCOGS":0.82,"CalculatedTotalCOGS":57.4}],"Member":{"ID":11398,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51341,"FullAddress":"105 Wilson Street, South Lismore, NSW 2480, Australia","UnitNumber":"","Address":" 105 Wilson Street ","StreetNumber":"","StreetName":"105 Wilson Street","StreetSuffix":"","Suburb":"South Lismore","State":"NSW","PostalCode":"2480","Country":"Australia","Coordinates":{"lat":-28.8104015,"lon":153.2602422}},"ShippingAddress":{"ID":51344,"FullAddress":"105 Wilson Street, South Lismore, NSW 2480, Australia","UnitNumber":"","Address":" 105 Wilson Street ","StreetNumber":"","StreetName":"105 Wilson Street","StreetSuffix":"","Suburb":"South Lismore","State":"NSW","PostalCode":"2480","Country":"Australia","Coordinates":{"lat":-28.8104015,"lon":153.2602422}},"OrderInvoice":null,"NestedItems":[{"ID":107460,"Title":"Enviro / Button Male White","InternalItemID":"EENCMB8","TotalItems":70,"TotalPrice":154,"CategoryTitle":"Electronic Identification","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763626,"SubTotal":140,"TotalDiscount":0,"TaxTotal":14,"Total":154,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"Norco Rural (Lismore)","SupplierName":"Leader Products Pty Ltd"},{"ID":763627,"SubTotal":74.2,"TotalDiscount":0,"TaxTotal":0,"Total":74.2,"MarginSubTotal":65.8,"MarginTaxTotal":0,"MarginTotal":65.8,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"orders","_type":"_doc","_id":"130866","_score":1,"_ignored":["Shipped","Voided","ReceiptSent"],"_source":{"ID":130866,"Status":"Production Complete","ShippingStatus":"None","InternalItemID":"AUO-130866","Placed":"2021-05-11 13:07:16","Paid":"2021-05-11 13:17:14","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","ShippingMethod":"Arrange Own Freight/Pickup","FirstName":"Ashley","Surname":"Wilkins","Email":"[[email protected]][email protected][/email]","Notes":"EAGLE VISION
PERTH
FM","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":3.9,"SubTotal":39,"Total":42.9,"RRPSubTotal":0,"RRPDiscountTotal":0,"COGSTotal":0,"Currency":"AUD","CurrencyFormat":"0,0.00","CurrencyDisplayCode":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerID":10995,"ResellerName":"FarmWorks Narrogin","RegionTitle":"WA","RegionCountry":"Australia","BillingLat":"-32.9301691","BillingLong":"-32.9301691","CustomerName":"Ashley Wilkins","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerID":0,"ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","PostmenSelectedShipperTitle":"","BoxPackerParcelCount":1,"PostmenTrackingInfo":"","Manifesting":false,"Manifested":false,"ResellerClipPaid":0,"ResellerProfit":0,"WholesalerProfit":42.9,"BusinessName":"FarmWorks Narrogin","Items":[{"ID":106874,"Title":"Leadertag Yellow","InternalItemID":"LT7","DisplayImage":"/assets/ProcessedImages/LT7-NEW2-WCI-24062020_NM__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.14,"UnitTax":0.014,"TotalUnitPrice":15.400000000000002,"PackagePrice":0.14,"PackageTax":0.014,"TotalPackagePrice":0,"TotalTax":1.4,"TotalPriceWithoutTax":14,"TotalPrice":15.4,"IsTaxable":true,"CategoryTitle":"Visual Identification","CalculatedUnitCOGS":0.03,"CalculatedTotalCOGS":3},{"ID":106875,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","DisplayImage":"/assets/Uploads/CLS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.25,"UnitTax":0.025,"TotalUnitPrice":27.500000000000004,"PackagePrice":0.25,"PackageTax":0.025,"TotalPackagePrice":0,"TotalTax":2.5,"TotalPriceWithoutTax":25,"TotalPrice":27.5,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep","CalculatedUnitCOGS":0.13,"CalculatedTotalCOGS":13}],"Member":{"ID":10995,"Email":"[[email protected]][email protected][/email]","SingularName":"Reseller"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"ParentReseller":{"ID":0,"Email":"","SingularName":"Member"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"PlacedOnBehalfBy":{"ID":10939,"Email":"[[email protected]][email protected][/email]","SingularName":"Wholesaler"},"BillingAddress":{"ID":51034,"FullAddress":"55 - 59 Earl Street, Narrogin, WA 6312, Australia","UnitNumber":"","Address":" 55 - 59 Earl Street ","StreetNumber":"","StreetName":"55 - 59 Earl Street","StreetSuffix":"","Suburb":"Narrogin","State":"WA","PostalCode":"6312","Country":"Australia","Coordinates":{"lat":-32.9301691,"lon":117.1769808}},"ShippingAddress":{"ID":48841,"FullAddress":"55 - 59 Earl Street, Narrogin, WA 6312, Australia","UnitNumber":"","Address":" 55 - 59 Earl Street ","StreetNumber":"","StreetName":"55 - 59 Earl Street","StreetSuffix":"","Suburb":"Narrogin","State":"WA","PostalCode":"6312","Country":"Australia","Coordinates":{"lat":-32.9301691,"lon":117.1769808}},"OrderInvoice":null,"NestedItems":[{"ID":106874,"Title":"Leadertag Yellow","InternalItemID":"LT7","TotalItems":100,"TotalPrice":15.4,"CategoryTitle":"Visual Identification","CalculatedTotalDiscount":0},{"ID":106875,"Title":"Customised Laser Marking Sheep","InternalItemID":"CLS","TotalItems":100,"TotalPrice":27.5,"CategoryTitle":"Laser Marking - Sheep","CalculatedTotalDiscount":0}],"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0},"MemberPriceListItems":[{"ID":763355,"SubTotal":39,"TotalDiscount":0,"TaxTotal":3.9,"Total":42.9,"MarginSubTotal":0,"MarginTaxTotal":0,"MarginTotal":0,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"[[email protected]][email protected][/email]","MemberName":"FarmWorks Narrogin","SupplierName":"Leader Products Pty Ltd"},{"ID":763356,"SubTotal":17,"TotalDiscount":0,"TaxTotal":0,"Total":17,"MarginSubTotal":22,"MarginTaxTotal":0,"MarginTotal":22,"ReferralSubTotal":0,"ReferralTaxTotal":0,"ReferralTotal":0,"Clipable":false,"ClipPaid":false,"MemberEmail":"[[email protected]][email protected][/email]","SupplierEmail":"globaladminau","MemberName":"Leader Products Pty Ltd","SupplierName":""}]}}
{"_index":"cartreport","_type":"_doc","_id":"166077","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119727,"LogFor":"Status","Status":"Awaiting Fulfilment","Created":"2020-12-11 09:17:47","LastEdited":"2020-12-11 09:17:47","ShippingStatus":"None","InternalItemID":"AUO-119727","Placed":"2020-12-10 18:38:58","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Charlie","Surname":"Meaburn","Email":"[[email protected]][email protected][/email]","Notes":"URGENT - Please process urgently with StarTrack
dalby","IPAddress":"10.137.194.143","DiscountTotal":0,"ShippingTotal":0,"TaxTotal":37.056,"SubTotal":370.56,"Total":407.616,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Everything ID","ResellerID":10982,"RegionTitle":"TAS","RegionCountry":"Australia","BillingLat":"-42.3","BillingLong":"-42.3","CustomerName":"Charlie Meaburn","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"19:33:54","CumulativeDurationTimeStamp":70434,"Items":[{"ID":43610,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":41.470000000000006,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":3.77,"TotalPriceWithoutTax":37.7,"TotalPrice":41.470000000000006,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43611,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":41.470000000000006,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":3.77,"TotalPriceWithoutTax":37.7,"TotalPrice":41.470000000000006,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43612,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":27.885,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.535,"TotalPriceWithoutTax":25.35,"TotalPrice":27.885,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43613,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":27.885,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.535,"TotalPriceWithoutTax":25.35,"TotalPrice":27.885,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43614,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":25.025000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.275,"TotalPriceWithoutTax":22.75,"TotalPrice":25.025,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43615,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":25.025000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.275,"TotalPriceWithoutTax":22.75,"TotalPrice":25.025,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43616,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":20.020000000000003,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":1.82,"TotalPriceWithoutTax":18.2,"TotalPrice":20.02,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43617,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":20.020000000000003,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":1.82,"TotalPriceWithoutTax":18.2,"TotalPrice":20.02,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43618,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":24.310000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.21,"TotalPriceWithoutTax":22.1,"TotalPrice":24.310000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43619,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":24.310000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":2.21,"TotalPriceWithoutTax":22.1,"TotalPrice":24.310000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43620,"Title":"Maxi Female Yellow","InternalItemID":"2PMX7","DisplayImage":"/assets/ProcessedImages/2PMX7-NEW2-WCI-23062020__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":6,"TotalPackageItems":0,"TotalItems":6,"UnitPrice":0.65,"UnitTax":0.065,"TotalUnitPrice":4.290000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.65,"PackageTax":0.065,"TotalPackagePrice":0,"TotalTax":0.39,"TotalPriceWithoutTax":3.9,"TotalPrice":4.29,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43621,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":21.054,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.914,"TotalPriceWithoutTax":19.14,"TotalPrice":21.054000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43622,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":58,"TotalPackageItems":0,"TotalItems":58,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":21.054,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.914,"TotalPriceWithoutTax":19.14,"TotalPrice":21.054000000000002,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43623,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":14.157,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.287,"TotalPriceWithoutTax":12.870000000000001,"TotalPrice":14.157,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43624,"Title":"3 Line Laser Marking","InternalItemID":"3L","DisplayImage":"/assets/ProcessedImages/3L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":39,"TotalPackageItems":0,"TotalItems":39,"UnitPrice":0.33,"UnitTax":0.033,"TotalUnitPrice":14.157,"CalculatedTotalDiscount":0,"PackagePrice":0.33,"PackageTax":0.033,"TotalPackagePrice":0,"TotalTax":1.287,"TotalPriceWithoutTax":12.870000000000001,"TotalPrice":14.157,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43625,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":10.010000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.91,"TotalPriceWithoutTax":9.1,"TotalPrice":10.01,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43626,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":35,"TotalPackageItems":0,"TotalItems":35,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":10.010000000000002,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.91,"TotalPriceWithoutTax":9.1,"TotalPrice":10.01,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43627,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":8.008000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.728,"TotalPriceWithoutTax":7.280000000000001,"TotalPrice":8.008000000000001,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43628,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":28,"TotalPackageItems":0,"TotalItems":28,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":8.008000000000001,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.728,"TotalPriceWithoutTax":7.280000000000001,"TotalPrice":8.008000000000001,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43629,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":9.724,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.884,"TotalPriceWithoutTax":8.84,"TotalPrice":9.724,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"},{"ID":43630,"Title":"2 Line Laser Marking","InternalItemID":"2L","DisplayImage":"/assets/ProcessedImages/2L__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":34,"TotalPackageItems":0,"TotalItems":34,"UnitPrice":0.26,"UnitTax":0.026,"TotalUnitPrice":9.724,"CalculatedTotalDiscount":0,"PackagePrice":0.26,"PackageTax":0.026,"TotalPackagePrice":0,"TotalTax":0.884,"TotalPriceWithoutTax":8.84,"TotalPrice":9.724,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Cattle"}],"Member":{"ID":10982,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24478,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3,"lon":147.370556}},"ShippingAddress":{"ID":24478,"FullAddress":"PO Box 46, Oatlands, TAS 7120, Australia","UnitNumber":"","Address":" PO Box 46 ","StreetNumber":"","StreetName":"PO Box 46","StreetSuffix":"","Suburb":"Oatlands","State":"TAS","PostalCode":"7120","Country":"Australia","Coordinates":{"lat":-42.3,"lon":147.370556}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166065","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119729,"LogFor":"Status","Status":"Awaiting Fulfilment","Created":"2020-12-11 09:09:57","LastEdited":"2020-12-11 09:09:57","ShippingStatus":"None","InternalItemID":"AUO-119729","Placed":"2020-12-10 16:46:41","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Sally","Surname":"Packham","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":22.9309,"TaxTotal":13.1149,"SubTotal":70,"Total":102.224,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Eartags Warehouse","ResellerID":10987,"RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-32.2315018","BillingLong":"-32.2315018","CustomerName":"Sally Packham","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"19:01:24","CumulativeDurationTimeStamp":68484,"Items":[{"ID":43515,"Title":"Jumbo Leadertag Blue","InternalItemID":"JLT11","DisplayImage":"/assets/ProcessedImages/JLT11-BLUE-F-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.15,"UnitTax":0.015,"TotalUnitPrice":16.499999999999996,"CalculatedTotalDiscount":0,"PackagePrice":0.15,"PackageTax":0.015,"TotalPackagePrice":0,"TotalTax":1.5,"TotalPriceWithoutTax":15,"TotalPrice":16.5,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43516,"Title":"1 Line Laser Marking Sheep","InternalItemID":"1LS","DisplayImage":"/assets/ProcessedImages/1LS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":200,"TotalPackageItems":0,"TotalItems":200,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":22,"CalculatedTotalDiscount":0,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":2,"TotalPriceWithoutTax":20,"TotalPrice":22,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep"},{"ID":43517,"Title":"Jumbo Leadertag Red","InternalItemID":"JLT10","DisplayImage":"/assets/ProcessedImages/JLT10-RED-F-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":100,"TotalPackageItems":0,"TotalItems":100,"UnitPrice":0.15,"UnitTax":0.015,"TotalUnitPrice":16.499999999999996,"CalculatedTotalDiscount":0,"PackagePrice":0.15,"PackageTax":0.015,"TotalPackagePrice":0,"TotalTax":1.5,"TotalPriceWithoutTax":15,"TotalPrice":16.5,"COGS":0,"IsTaxable":true,"CategoryTitle":"Visual Identification"},{"ID":43518,"Title":"1 Line Laser Marking Sheep","InternalItemID":"1LS","DisplayImage":"/assets/ProcessedImages/1LS__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":200,"TotalPackageItems":0,"TotalItems":200,"UnitPrice":0.1,"UnitTax":0.01,"TotalUnitPrice":22,"CalculatedTotalDiscount":0,"PackagePrice":0,"PackageTax":0,"TotalPackagePrice":0,"TotalTax":2,"TotalPriceWithoutTax":20,"TotalPrice":22,"COGS":0,"IsTaxable":true,"CategoryTitle":"Laser Marking - Sheep"}],"Member":{"ID":10987,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24471,"FullAddress":"PO Box 6049, Dubbo, NSW 2830, Australia","UnitNumber":"","Address":" PO Box 6049 ","StreetNumber":"","StreetName":"PO Box 6049","StreetSuffix":"","Suburb":"Dubbo","State":"NSW","PostalCode":"2830","Country":"Australia","Coordinates":{"lat":-32.2315018,"lon":148.6329645}},"ShippingAddress":{"ID":24471,"FullAddress":"PO Box 6049, Dubbo, NSW 2830, Australia","UnitNumber":"","Address":" PO Box 6049 ","StreetNumber":"","StreetName":"PO Box 6049","StreetSuffix":"","Suburb":"Dubbo","State":"NSW","PostalCode":"2830","Country":"Australia","Coordinates":{"lat":-32.2315018,"lon":148.6329645}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166066","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119123,"LogFor":"Status","Status":"Dispatched","Created":"2020-12-11 09:10:18","LastEdited":"2020-12-11 09:10:18","ShippingStatus":"Packed","InternalItemID":"AUO-119123","Placed":"2020-12-10 15:20:28","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Felicity","Surname":"Simpson","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":9.7963,"TaxTotal":36.6124,"SubTotal":40,"Total":84.776,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Nutrien Strathalbyn Retail Store","ResellerID":11256,"RegionTitle":"VIC","RegionCountry":"Australia","BillingLat":"-37.8202276","BillingLong":"-37.8202276","CustomerName":"Felicity Simpson","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"214:33:15","CumulativeDurationTimeStamp":772395,"Items":[{"ID":43400,"Title":"Enviro / Button Male Orange","InternalItemID":"EENCMB6","DisplayImage":"/assets/ProcessedImages/EENCMB6-ORANGE-NLIS-S__PadWzE1MCwxNTAsIkZGRkZGRiIsMTAwXQ.png","TotalUnitItems":20,"TotalPackageItems":0,"TotalItems":20,"UnitPrice":2,"UnitTax":1.7,"TotalUnitPrice":74,"CalculatedTotalDiscount":0,"PackagePrice":2,"PackageTax":1.7,"TotalPackagePrice":0,"TotalTax":34,"TotalPriceWithoutTax":40,"TotalPrice":74,"COGS":0,"IsTaxable":true,"CategoryTitle":"Electronic Identification"}],"Member":{"ID":11256,"Email":"[[email protected]][email protected][/email]"},"ParentMember":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"Supplier":{"ID":10939,"Email":"[[email protected]][email protected][/email]"},"PlacedOnBehalfBy":{"ID":0,"Email":""},"BillingAddress":{"ID":24456,"FullAddress":"PO Box 4562, DOCKLANDS, VIC 3008, Australia","UnitNumber":"","Address":" PO Box 4562 ","StreetNumber":"","StreetName":"PO Box 4562","StreetSuffix":"","Suburb":"DOCKLANDS","State":"VIC","PostalCode":"3008","Country":"Australia","Coordinates":{"lat":-37.8202276,"lon":144.943006}},"ShippingAddress":{"ID":24456,"FullAddress":"PO Box 4562, DOCKLANDS, VIC 3008, Australia","UnitNumber":"","Address":" PO Box 4562 ","StreetNumber":"","StreetName":"PO Box 4562","StreetSuffix":"","Suburb":"DOCKLANDS","State":"VIC","PostalCode":"3008","Country":"Australia","Coordinates":{"lat":-37.8202276,"lon":144.943006}},"AppliedDiscountCoupon":{"ID":0,"InternalItemID":"","Title":"","Usage":"","OwnedByID":0,"ReferrerID":0}}}
{"_index":"cartreport","_type":"_doc","_id":"166063","_score":1,"_ignored":["Paid","Shipped","Voided","ReceiptSent"],"_source":{"CartOrderID":119720,"LogFor":"Status","Status":"Dispatched","Created":"2020-12-11 09:05:53","LastEdited":"2020-12-11 09:05:53","ShippingStatus":"Packed","InternalItemID":"AUO-119720","Placed":"2020-12-10 13:23:58","Paid":"","ReceiptSent":"","Shipped":"","Voided":"","PaymentMethod":"order-account","Manifested":false,"RegionID":0,"FirstName":"Sally","Surname":"Packham","Email":"[[email protected]][email protected][/email]","Notes":"","IPAddress":"10.137.194.36","DiscountTotal":0,"ShippingTotal":9.7963,"TaxTotal":5.8524,"SubTotal":32.4,"Total":46.416,"RRPSubTotal":0,"RRPDiscountTotal":0,"Currency":"AUD","HasTags":true,"ContainItemTypes":"ID","ResellerName":"Eartags Warehouse","ResellerID":10987,"RegionTitle":"NSW","RegionCountry":"Australia","BillingLat":"-32.2315018","BillingLong":"-32.2315018","CustomerName":"Sally Packham","CustomerEmail":"[[email protected]][email protected][/email]","ParentResellerName":"","ParentResellerEmail":"","WholesalerName":"Leader Products Pty Ltd","WholesalerEmail":"[[email protected]][email protected][/email]","GlobalMemberName":"","GlobalMemberEmail":"","HasAppliedDiscount":true,"AppliedDiscountTitle":"","AppliedDiscountType":"Coupon","CumulativeDuration":"20:04:53","