test-helper

sql = SELECT id FROM ecom_orders WHERE status='NS' AND acctsyspri !='RECORDED' 

B202607153: 
order: 
id: B202607153
epochorder: 1784123552
epochcomplete: 1
datemonth: 07
dateday: 15
dateyear: 2026
status: NS
statusinit: 1
statusenabled: 1
statusserviced: 1
statuscompleted: 0
statusinvprocessed: 1
statusreturnsproc: 0
ordreviewstatus: 0
ordreviewinfo: 
mktexported: 
paymethod: paypalcp
payterms: 
custponum: 
xmultisite: DEFAULT
ordertotal: 1058.27
recurtotal: 0.00
subtotal: 1032.51
taxsptotal: 0.00
taxspshiptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
taxcshiptotal: 0.00
taxcrefshiptotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
custsurchargetotal: 0.00
disctotal: 0.00
shipdisctotal: 0.00
giftcerttotal: 0.00
shipwtaxgiftcerttotal: 0.00
surchgiftcerttotal: 0.00
adjposgiftcerttotal: 0.00
rebatetotal: 0.00
credittotal: 0.00
shiptotal: 25.76
shiptotalactual: 0.00
shiptotalmodified: 0
ordadjustpostotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 1032.51
custpaytotal: 1058.27
orderbalance: 0.00
disccode: 
giftcert: 
credit: 
taxexemptnum: 631050415
disability: 
custsaledesc: 
custsurchargedesc: 
ordadjustpos: 
ordadjustneg: 
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
phone: 5207138990
email: carin.d.naughton.civ@army.mil
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
customone: Agree
customtwo: 
customthree: 
customfour: CN-39329
customfive: 
customsix: 
customseven: 
customeight: 
customnine: 
customten: 
commentsint: 
commentsext: 
referrer: 
ipaddress: 199.209.144.28
proctoken: 
sourceorder: 
posordertype: 
iswholesale: 0
iswholesalepremium: 0
isspecoffer: 0
channelid: DEFAULT
channelorderid: 
channelcompleted: 0
suppresscustemail: 0
custorderemails: 
intorderemails: 
netreturntotal: 0.00
returnshiptaxtotal: 0.00
returnsurchargetotal: 0.00
returnordadjpostotal: 0.00
shipwtaxdiscreturned: 0
surchdiscreturned: 0
adjposdiscreturned: 0
taxspshiprate: 0.000
taxcshiprate: 0.000
shippingmemo: 
acctsyspri: 
acctsysalt: 
acctsysdata: 
statusarchived: 0
paydetail: Credit Card
taxcesttotal: 0.00
taxcestreftotal: 0.00
taxcestshiptotal: 0.00
taxcestrefshiptotal: 0.00
tags: 
ordemaillogosup: 0
invoicemail: 0
invoicedisp: 0
taxcestshiprate: 0.000
currshow: 
currconvrate: 
customdata: 
procdebug: 
items: 
0: 
id: B202607153-4CDO563KRKKB
orderid: B202607153
epochorder: 1784123552
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 16632, Set 8 BriteGuard Plated Balldriver Screwdrivers .050 - 5/32 (1)
itemnum: 16632
itemid: bondhus_16632
xinvid: bondhus_16632
itemquan: 3
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 137.34
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 137.34
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 0.510
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: 4CDO563KRKKB
isaddon: 0
taxcountrydisp: STANDARD
offergroup: 5F6R13NSMY83
offerquantity: 3
id: bondhus_16632
offername: Bondhus 16632, Set 8 BriteGuard Plated Balldriver Screwdrivers .050 - 5/32 (1)
offernumber: 16632
offerimg: bondhus_16632.jpg
quantitymult: 1
quantity: 3
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 16632, Set 8 BriteGuard Plated Balldriver Screwdrivers .050 - 5/32 (1)
number: 16632
imgsm: bondhus_16632.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_16632
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 12.0
shipwidth: 4.3
shipheight: 1.3
shipnest: 0.0
shipweight: 0.510
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_16632
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 137.34
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 137.34
xpricemapid: DEFAULT-bondhus_16632-DEFAULT-bondhus_16632
sinprodprice: 
regprice: 45.780000
compprice: 45.780000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 5
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 1.81
phone: 5207138990
taxcestrate: 0
1: 
id: B202607153-82E75FN6NCB8
orderid: B202607153
epochorder: 1784123552
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 16637, Set 13 BriteGuard Plated Balldriver Screwdrivers .050 - 3/8 (1)
itemnum: 16637
itemid: bondhus_16637
xinvid: bondhus_16637
itemquan: 3
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 332.34
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 332.34
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 2.450
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: 82E75FN6NCB8
isaddon: 0
taxcountrydisp: STANDARD
offergroup: 6430N4UB91MW
offerquantity: 3
id: bondhus_16637
offername: Bondhus 16637, Set 13 BriteGuard Plated Balldriver Screwdrivers .050 - 3/8 (1)
offernumber: 16637
offerimg: bondhus_16637.jpg
quantitymult: 1
quantity: 3
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 16637, Set 13 BriteGuard Plated Balldriver Screwdrivers .050 - 3/8 (1)
number: 16637
imgsm: bondhus_16637.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_16637
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 14.3
shipwidth: 8.0
shipheight: 2.5
shipnest: 0.0
shipweight: 2.450
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_16637
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 332.34
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 332.34
xpricemapid: DEFAULT-bondhus_16637-DEFAULT-bondhus_16637
sinprodprice: 
regprice: 110.780000
compprice: 110.780000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 1
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 8.70
phone: 5207138990
taxcestrate: 0
2: 
id: B202607153-L3G1FBRZF18B
orderid: B202607153
epochorder: 1784123552
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 16686, Set 6 BriteGuard Plated Balldriver Screwdrivers 1.5 - 5mm (1)
itemnum: 16686
itemid: bondhus_16686
xinvid: bondhus_16686
itemquan: 3
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 127.08
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 127.08
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 0.560
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: L3G1FBRZF18B
isaddon: 0
taxcountrydisp: STANDARD
offergroup: 1OG97W74LK1L
offerquantity: 3
id: bondhus_16686
offername: Bondhus 16686, Set 6 BriteGuard Plated Balldriver Screwdrivers 1.5 - 5mm (1)
offernumber: 16686
offerimg: bondhus_16686.jpg
quantitymult: 1
quantity: 3
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 16686, Set 6 BriteGuard Plated Balldriver Screwdrivers 1.5 - 5mm (1)
number: 16686
imgsm: bondhus_16686.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_16686
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 12.5
shipwidth: 5.0
shipheight: 1.3
shipnest: 0.0
shipweight: 0.560
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_16686
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 127.08
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 127.08
xpricemapid: DEFAULT-bondhus_16686-DEFAULT-bondhus_16686
sinprodprice: 
regprice: 42.360000
compprice: 42.360000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 8
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 1.99
phone: 5207138990
taxcestrate: 0
3: 
id: B202607153-3B9DK14K7WD7
orderid: B202607153
epochorder: 1784123552
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 16699, Set 9 BriteGuard Plated Balldriver Screwdrivers 1.5 - 10mm (1)
itemnum: 16699
itemid: bondhus_16699
xinvid: bondhus_16699
itemquan: 3
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 274.26
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 274.26
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 2.110
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: 3B9DK14K7WD7
isaddon: 0
taxcountrydisp: STANDARD
offergroup: 5LV336274353
offerquantity: 3
id: bondhus_16699
offername: Bondhus 16699, Set 9 BriteGuard Plated Balldriver Screwdrivers 1.5 - 10mm (1)
offernumber: 16699
offerimg: bondhus_16699.jpg
quantitymult: 1
quantity: 3
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 16699, Set 9 BriteGuard Plated Balldriver Screwdrivers 1.5 - 10mm (1)
number: 16699
imgsm: bondhus_16699.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_briteguard_plated_balldriver_hex_screwdrivers_sets
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_16699
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 14.3
shipwidth: 8.0
shipheight: 2.5
shipnest: 0.0
shipweight: 2.110
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_16699
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 274.26
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 274.26
xpricemapid: DEFAULT-bondhus_16699-DEFAULT-bondhus_16699
sinprodprice: 
regprice: 91.420000
compprice: 91.420000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 2
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 7.50
phone: 5207138990
taxcestrate: 0
4: 
id: B202607153-X2Q45HS15A10
orderid: B202607153
epochorder: 1784123552
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 20599, Stubby Balldriver L-Wrench Double Pack .050- to 3/8-inch and 1.5mm to 10mm (1)
itemnum: 20599
itemid: bondhus_20599
xinvid: bondhus_20599
itemquan: 3
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 161.49
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 161.49
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: CARIN
lname: NAUGHTON
company: US ARMY
addone: 6263 HACKBERRY ROAD
addtwo: 
city: REDSTONE ARSENAL
stateprov: Alabama
country: United States
postalcode: 35898
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 1.620
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_stubby_balldriver_l-wrenches_sets
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: X2Q45HS15A10
isaddon: 0
taxcountrydisp: STANDARD
offergroup: WT4WJ8A18D9J
offerquantity: 3
id: bondhus_20599
offername: Bondhus 20599, Stubby Balldriver L-Wrench Double Pack .050- to 3/8-inch and 1.5mm to 10mm (1)
offernumber: 20599
offerimg: bondhus_20599.jpg
quantitymult: 1
quantity: 3
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 20599, Stubby Balldriver L-Wrench Double Pack .050- to 3/8-inch and 1.5mm to 10mm (1)
number: 20599
imgsm: bondhus_20599.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_stubby_balldriver_l-wrenches_sets
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_20599
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 11.0
shipwidth: 6.0
shipheight: 1.5
shipnest: 0.0
shipweight: 1.620
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_20599
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 161.49
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 161.49
xpricemapid: DEFAULT-bondhus_20599-DEFAULT-bondhus_20599
sinprodprice: 
regprice: 53.830000
compprice: 53.830000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 11
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 5.76
phone: 5207138990
taxcestrate: 0
payments: 
0: 
id: B202607153-5ADX6K3LRY51
email: carin.d.naughton.civ@army.mil
orderid: B202607153
orderidorig: 
creditid: 
paytype: PAYMENTAPPLIED
paydesc: Payment
payattrib: ORDER
payamount: 1058.27
paydate: 1784123552
payref: 
paymethod: CREDITCARD
gatewayid: paypalcp
proctransid: 26E25998JS810141E|card|134b2b5f6cf99|B202607153-1784123552-58ZQ3U537T
cctype: 
xmultisite: DEFAULT
acctsyspri: 
acctsysalt: 
procauthinfo: 
display: 
orderstatus: 
C: Completed
NS: Pending Shipment
P: Pending Submission
PCE: Pending Customer Emailed
PPR: Pending Processing
PS: Partially Shipped
SV: Servicing
X: Cancelled
shipstatus: 
DP: Shipping Request Pending
DS: Shipping Requested
N: Not Applicable
P: Pending Shipment
S: Shipped
servstatus: 
N: Not Applicable
P: Servicing
S: Serviced
custom: 
ordadjustpos: Positive Adjustment
ordadjustneg: Negative Adjustment
disccode: Discount Code
giftcert: Gift Certificate
credit: Credits
loyaltypoints: Redeem Loyalty Points
taxexemptnum: Tax ID Number
disability: Disability Selection
commentsint: Internal Order Comments
commentsext: Order Comments
customtwo: How did you find us?
customone: Terms
customthree: Mandatory Signature Required
customfour: PO Number
customfive: FedEx/UPS Account Number
customsix: Custom Field 6
customseven: Custom Field 7
customeight: Custom Field 8
customnine: Custom Field 9
customten: Custom Field 10
gateway: 
id: paypalcp
name: PayPal Commerce Platform
active: 1
xmultisite: 
beonly: 0
urltype: I
dispname: Secure online checkout payment
disporder: 1000
fieldrc: NotApplicable
fieldon: NotApplicable
fieldtransid: NotApplicable
fieldtotal: NotApplicable
validrc: NotApplicable
refurlstr: NotApplicable
transkey: 
userid: PayPal
postorder: 1
paymenttype: CREDITCARD
recursup: 0
incdisp: <?php 

// +--
// | This processor integration references an internal URL
// | for processing.  All internal payment methods
// | work in the same manner.  An order information array
// | is made available globally under the the global name
// | 'ecom.order_summary'.
// |
// | This must set a global variable named 'ecom.olpform'
// | which contains the form information to be posted to
// | an internal URL for processing.
// |
// | Anything printed within this code will be printed
// | above the form instructions on the payment information
// | page.
// +--

// +--
// | THERE IS NO NEED TO EDIT THE CODE BELOW THIS POINT TO 
// | ACTIVATE THIS INTEGRATION.  ONLY EDIT THIS CODE TO MODIFY
// | HOW THIS INTEGRATION WORKS.  BE SURE YOU KNOW WHAT YOU'RE 
// | DOING!
// +--

// +--
// | Ensure PayPal Commerce Platform is active.
// +--

$paypalcpactive = $this->globals('core_settings.ecom.paypalcpactive');

if (empty($paypalcpactive)) {

     $message  = 'PayPal Commerce Platform is not currently active.';

     print '<p class="kstrong">' . $this->xhtml_encode($message) . '</p>' . $eol . $eol;

     return false;

} // End of if statement.

// +--
// | Get a few global variables.
// +--

$eol       = $this->globals('core.eol');
$order     = $this->globals('ecom.order_summary');

// +--
// | Set up the olpform array.
// +--

$olpform = array('namespace' => 'gwprocinternal',
                 'button'    => 'Submit Payment',
                 'gateway'   => $order['gateway']['id'],
                 'orderid'   => $order['order']['id'],
                 'fields'    => array());

// +--
// | Create the HIDDEN fields for the form.
// +--

$olpform['fields']['HIDDEN'][] = array('name'  => 'paypalorderid',
                                       'value' => '');

$olpform['fields']['HIDDEN'][] = array('name'  => 'fundingsource',
                                       'value' => '');

// +--
// | Globalize the $olpform array and return.
// +--

$this->globals('ecom.olpform',$olpform);

?>
inventory: 
realtimetracking: 
FEDEX: 
id: FEDEX
UPSTOOLS: 
id: UPSTOOLS
USPS: 
id: USPS
fingerprints: 
order: 0322d179172e5e61d71d80ee36b70e11
items: 
B202607153-4CDO563KRKKB: 80dc6bdc2c2a8f5b7d373d11ac340b5a
B202607153-82E75FN6NCB8: e0b34605890d6a88417bd8e45f9f0153
B202607153-L3G1FBRZF18B: 348e20bc2ef5cc06780ff1d8f6012990
B202607153-3B9DK14K7WD7: 6065fb7919074c8b1bfcd37a54f25ec2
B202607153-X2Q45HS15A10: 9ff0c3b55202dc0103ba9e07dc0791ed
payments: 
B202607153-5ADX6K3LRY51: a486fb71b3cfcea048e9afd070932fa2
B202607155: 
order: 
id: B202607155
epochorder: 1784146399
epochcomplete: 1
datemonth: 07
dateday: 15
dateyear: 2026
status: NS
statusinit: 1
statusenabled: 1
statusserviced: 1
statuscompleted: 0
statusinvprocessed: 1
statusreturnsproc: 0
ordreviewstatus: 0
ordreviewinfo: 
mktexported: 
paymethod: paypalcp
payterms: 
custponum: 
xmultisite: DEFAULT
ordertotal: 306.28
recurtotal: 0.00
subtotal: 273.60
taxsptotal: 0.00
taxspshiptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
taxcshiptotal: 0.00
taxcrefshiptotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
custsurchargetotal: 0.00
disctotal: 0.00
shipdisctotal: 0.00
giftcerttotal: 0.00
shipwtaxgiftcerttotal: 0.00
surchgiftcerttotal: 0.00
adjposgiftcerttotal: 0.00
rebatetotal: 0.00
credittotal: 0.00
shiptotal: 32.68
shiptotalactual: 0.00
shiptotalmodified: 0
ordadjustpostotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 273.60
custpaytotal: 306.28
orderbalance: 0.00
disccode: 
giftcert: 
credit: 
taxexemptnum: 
disability: 
custsaledesc: 
custsurchargedesc: 
ordadjustpos: 
ordadjustneg: 
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: Kevin
lname: Adams
company: MAG45, Inc.
phone: 5033898094
email: op-us@mag45.com
addone: 10170 SW Nimbus Ave
addtwo: #H-1
city: Portland
stateprov: Oregon
country: United States
postalcode: 97223
rescom: C
customone: Agree
customtwo: 
customthree: 
customfour: 909095
customfive: 
customsix: 
customseven: 
customeight: 
customnine: 
customten: 
commentsint: 
commentsext: 
referrer: 
ipaddress: 51.144.101.253
proctoken: 
sourceorder: 
posordertype: 
iswholesale: 0
iswholesalepremium: 0
isspecoffer: 0
channelid: DEFAULT
channelorderid: 
channelcompleted: 0
suppresscustemail: 0
custorderemails: 
intorderemails: 
netreturntotal: 0.00
returnshiptaxtotal: 0.00
returnsurchargetotal: 0.00
returnordadjpostotal: 0.00
shipwtaxdiscreturned: 0
surchdiscreturned: 0
adjposdiscreturned: 0
taxspshiprate: 0.000
taxcshiprate: 0.000
shippingmemo: 
acctsyspri: 
acctsysalt: 
acctsysdata: 
statusarchived: 0
paydetail: Credit Card
taxcesttotal: 0.00
taxcestreftotal: 0.00
taxcestshiptotal: 0.00
taxcestrefshiptotal: 0.00
tags: 
ordemaillogosup: 0
invoicemail: 0
invoicedisp: 0
taxcestshiprate: 0.000
currshow: 
currconvrate: 
customdata: 
procdebug: 
items: 
0: 
id: B202607155-0W7TT0B4WQ49
orderid: B202607155
epochorder: 1784146399
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid: 
purchorditemsreqid: 
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 3756, 3mm Balldriver Screwdriver - Xlong (1)
itemnum: 3756
itemid: bondhus_3756
xinvid: bondhus_3756
itemquan: 24
itemopts: 
itemnote: 
recurtotal: 0.00
subtotal: 273.60
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 273.60
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: Kevin
lname: Adams
company: MAG45, Inc.
addone: 10170 SW Nimbus Ave
addtwo: #H-1
city: Portland
stateprov: Oregon
country: United States
postalcode: 97223
rescom: C
shipmethod: UPS Ground
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 1.040
epochship: 1
shipmanager: 
shipmanagerbatch: 
shipmanagershipment: 
tracknumtype: OTHER
tracknums: 
channelitemid: 
dlfiles: 
dlfilegets: 0
uploads: 
barcode: 
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: bondhus_balldriver_hex_screwdrivers_xtra_long_leng
addemtext: 
customdata: QBID:BONDHUS
promoname: 
giftcertissued: 
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate: 
giftcertexpdate: 
taxsprate: 0
taxcrate: 0
netreturntotal: 0.00
discitemsreturned: 0
cartdata: 
randid: 0W7TT0B4WQ49
isaddon: 0
taxcountrydisp: STANDARD
offergroup: Q8O658U545H9
offerquantity: 24
id: bondhus_3756
offername: Bondhus 3756, 3mm Balldriver Screwdriver - Xlong (1)
offernumber: 3756
offerimg: bondhus_3756.jpg
quantitymult: 1
quantity: 24
invitemminquan: 0
invitemincquan: 0
invitemmaxquan: 0
pricetype: REGPRICE
name: Bondhus 3756, 3mm Balldriver Screwdriver - Xlong (1)
number: 3756
imgsm: bondhus_3756.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: bondhus_balldriver_hex_screwdrivers_xtra_long_leng
xupsell: 
dlfiles: 
addemtext: 
customdata: QBID:BONDHUS
servreq: 0
discexclusions: 
xinvid: bondhus_3756
vendorid: MINNESOTA-55362
dodrop: 0
barcode: 
sinshipinfo: 
shiptype: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipboxes: 
shiplength: 15.0
shipwidth: 4.0
shipheight: 1.0
shipnest: 0.0
shipweight: 1.040
customship: bondhus
delmethod: C
warehouseloc: A1
shipfreethreshtrigger: 0
shipfreeoverride: 0.00
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd: 
beonly: 0
offergiftpromo: 0.00
prodfiltertype: Unspecified
microdatasku: bondhus_3756
microdatagroup: 
xinvcalc: LOCALUNL
forceprice: 0
taxinfo: 
ratebasissp: 
STANDARD: 1.000000
ratebasisc: 
STANDARD: 1.000000
classbasis: 
STANDARD: 1.000000
loyaltypoints: 0
subtotal: 273.6
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 273.60
xpricemapid: DEFAULT-bondhus_3756-DEFAULT-bondhus_3756
sinprodprice: 
regprice: 11.400000
compprice: 11.400000
recurprice: 0
rebate: 0
cost: 0
sinprodloyaltypoints: 0
optdisp: 
optids: 
optselids: 
sinoptprice: 
regprice: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
sinoptloyaltypoints: 0
uploads: 
savetype: CART
sortnum: 1
commtotal: 0
taxcesttotal: 0.00
taxcestreftotal: 0.00
shiptotalbasis: 32.68
phone: 5033898094
taxcestrate: 0
payments: 
0: 
id: B202607155-7ORT30Q6MRH4
email: op-us@mag45.com
orderid: B202607155
orderidorig: 
creditid: 
paytype: PAYMENTAPPLIED
paydesc: Payment
payattrib: ORDER
payamount: 306.28
paydate: 1784146399
payref: 
paymethod: CREDITCARD
gatewayid: paypalcp
proctransid: 9GS6203029527251D|card||B202607155-1784146399-138TAG45UG
cctype: 
xmultisite: DEFAULT
acctsyspri: 
acctsysalt: 
procauthinfo: 
display: 
orderstatus: 
C: Completed
NS: Pending Shipment
P: Pending Submission
PCE: Pending Customer Emailed
PPR: Pending Processing
PS: Partially Shipped
SV: Servicing
X: Cancelled
shipstatus: 
DP: Shipping Request Pending
DS: Shipping Requested
N: Not Applicable
P: Pending Shipment
S: Shipped
servstatus: 
N: Not Applicable
P: Servicing
S: Serviced
custom: 
ordadjustpos: Positive Adjustment
ordadjustneg: Negative Adjustment
disccode: Discount Code
giftcert: Gift Certificate
credit: Credits
loyaltypoints: Redeem Loyalty Points
taxexemptnum: Tax ID Number
disability: Disability Selection
commentsint: Internal Order Comments
commentsext: Order Comments
customtwo: How did you find us?
customone: Terms
customthree: Mandatory Signature Required
customfour: PO Number
customfive: FedEx/UPS Account Number
customsix: Custom Field 6
customseven: Custom Field 7
customeight: Custom Field 8
customnine: Custom Field 9
customten: Custom Field 10
gateway: 
id: paypalcp
name: PayPal Commerce Platform
active: 1
xmultisite: 
beonly: 0
urltype: I
dispname: Secure online checkout payment
disporder: 1000
fieldrc: NotApplicable
fieldon: NotApplicable
fieldtransid: NotApplicable
fieldtotal: NotApplicable
validrc: NotApplicable
refurlstr: NotApplicable
transkey: 
userid: PayPal
postorder: 1
paymenttype: CREDITCARD
recursup: 0
incdisp: <?php 

// +--
// | This processor integration references an internal URL
// | for processing.  All internal payment methods
// | work in the same manner.  An order information array
// | is made available globally under the the global name
// | 'ecom.order_summary'.
// |
// | This must set a global variable named 'ecom.olpform'
// | which contains the form information to be posted to
// | an internal URL for processing.
// |
// | Anything printed within this code will be printed
// | above the form instructions on the payment information
// | page.
// +--

// +--
// | THERE IS NO NEED TO EDIT THE CODE BELOW THIS POINT TO 
// | ACTIVATE THIS INTEGRATION.  ONLY EDIT THIS CODE TO MODIFY
// | HOW THIS INTEGRATION WORKS.  BE SURE YOU KNOW WHAT YOU'RE 
// | DOING!
// +--

// +--
// | Ensure PayPal Commerce Platform is active.
// +--

$paypalcpactive = $this->globals('core_settings.ecom.paypalcpactive');

if (empty($paypalcpactive)) {

     $message  = 'PayPal Commerce Platform is not currently active.';

     print '<p class="kstrong">' . $this->xhtml_encode($message) . '</p>' . $eol . $eol;

     return false;

} // End of if statement.

// +--
// | Get a few global variables.
// +--

$eol       = $this->globals('core.eol');
$order     = $this->globals('ecom.order_summary');

// +--
// | Set up the olpform array.
// +--

$olpform = array('namespace' => 'gwprocinternal',
                 'button'    => 'Submit Payment',
                 'gateway'   => $order['gateway']['id'],
                 'orderid'   => $order['order']['id'],
                 'fields'    => array());

// +--
// | Create the HIDDEN fields for the form.
// +--

$olpform['fields']['HIDDEN'][] = array('name'  => 'paypalorderid',
                                       'value' => '');

$olpform['fields']['HIDDEN'][] = array('name'  => 'fundingsource',
                                       'value' => '');

// +--
// | Globalize the $olpform array and return.
// +--

$this->globals('ecom.olpform',$olpform);

?>
inventory: 
realtimetracking: 
FEDEX: 
id: FEDEX
UPSTOOLS: 
id: UPSTOOLS
USPS: 
id: USPS
fingerprints: 
order: 3dd8c934aaf56ab473a4c54c33cc9db7
items: 
B202607155-0W7TT0B4WQ49: cbedb3200afbf33326984831075c8e88
payments: 
B202607155-7ORT30Q6MRH4: 5250b5339d024282a3aaeba2b333edf3
Banner Adverts
Banner Adverts
Bondhus Catalog

Welcome to BondhusTools.com, your one-stop shop for tools to turn fasteners!

C.R.S., Inc.
Your Cart
Your Cart
Your Cart: Empty
Categories
Categories
Your Cart
Search
© 2026 C.R.S., Inc., all rights reserved worldwide.
Kryptronic eCommerce, Copyright 1999-2026 Kryptronic, Inc. - https://kryptronic.com/ [0.029259 / 1.42128]