#dev | Logs for 2017-05-21

« return
[01:31:06] -!- charon_ [charon_!~0c0959f3@Soylent/Staff/Editor/charon] has joined #dev
[02:22:35] -!- charon_ has quit [Quit: socialist worker communes or GTFO]
[10:07:16] <Bytram> blurgh...
[10:07:50] <Bytram> TheMightyBuzzard: Ima confused about the "Recent Subscription Payments" page... https://soylentnews.org
[10:07:51] <upstart> ^ 03- SoylentNews User ( https://soylentnews.org )
[10:08:09] <TheMightyBuzzard> ...
[10:08:11] <TheMightyBuzzard> okay
[10:08:18] <Bytram> (Note: I've updated the template using the template editor, so is diffferent from what is in github
[10:08:20] <Bytram> )
[10:08:37] <Bytram> I'm seeing different net amts for same gross pmts
[10:08:58] <Bytram> compare spid: 676 with 675
[10:09:44] <Bytram> both have gross pmt of $10.00, net for 676 is showing "18.82", but for 675, is showing net of "19.12"
[10:09:49] <TheMightyBuzzard> that's paypal. they DO report the net so you'll have to ask them.
[10:10:37] <Bytram> I just find it strange that the difference is $0.30 which is their per-trans fee.
[10:10:55] <TheMightyBuzzard> probably CC vs PayPal
[10:11:09] <Bytram> nope, both are PayPal
[10:11:18] * Bytram thought that, too
[10:11:20] <TheMightyBuzzard> no... paypal processes cards as well
[10:11:30] <TheMightyBuzzard> and we can't tell if they did or not
[10:11:54] <Bytram> now I'm really confused.
[10:12:23] <TheMightyBuzzard> it could have come either from a proper paypal account or just someone using their CC on the paypal button.
[10:12:33] <Bytram> both are PayPal trans, not BTC, both had gross of "$20.00", one is net "19.12" other is "18.82" -- why did they charge us more in one case than the other?
[10:12:44] <TheMightyBuzzard> they don't say
[10:12:59] <Bytram> Looks like we are being overcharged.
[10:13:17] <TheMightyBuzzard> possible. we've no way to find out but calling them and asking them though.
[10:14:33] <Bytram> I cannot trust the net amt, as we have historical data with incorrect values (cf spid == 655)
[10:15:08] <Bytram> I cannot *calculate* the net amt, cause PP reports different NET based on something I cannot see on that page.
[10:15:24] <Bytram> grrr.
[10:16:58] <Bytram> there's gotta be something in their reply that distinguishes the different net charges as we cannot be the only ones in the entire world who are seeing different net amts for the same gross -- someone else would have reported the bug and they'd have fixed it by now.
[10:17:59] <TheMightyBuzzard> nope. i looked when trying to set them up with subtypes like stripe is.
[10:18:34] <TheMightyBuzzard> mind you, you might be able to look on the control panel on the site and see why.
[10:18:37] <Bytram> hmmmph! :/
[10:20:01] <Bytram> i do not have access to $ stuff for the site. I'd be happy with read-only access, but that is apparently not possible... for me to be able to see $amts, I'd also have to be given write access (IOW, I could take money out, etc.) DO NOT WANT that.
[10:20:25] <Bytram> now, I could drop one or several servers on Linode, but that's an entirely different kettle of fish.
[10:21:03] <Bytram> unless somethng has changed over the past year or so? that's what I recall from the last discussion.
[10:33:51] <TheMightyBuzzard> i don't have paypal access either. pj is the dev for that.
[10:41:45] <Bytram> TheMightyBuzzard: Appreciate the feedback... very much!
[10:42:24] <Bytram> btw, hope you are getting over your cold and feeling better. Allergy season is in full swing in my neck of the woods. :(
[10:43:16] <Bytram> hmmm, where do we keep the replies from Stripe? I'm assuming it's prolly some kind of json structure?
[10:47:56] <TheMightyBuzzard> yup. stripe_log or some such. show tables like '%stripe%';
[10:48:33] <Bytram> Would that have the *raw* data/replies in it?
[10:50:13] <Bytram> Looks like it should be: stripe_log.raw_transaction
[10:50:23] * Bytram goes to take a closer look
[10:56:23] <Bytram> ummm, that is the data for *stripe* -- I was looking for data for *paypal*
[10:56:40] <TheMightyBuzzard> <Bytram> hmmm, where do we keep the replies from Stripe? I'm assuming it's prolly some kind of json structure?
[10:57:00] * Bytram self-flagelates with a wet noodle
[10:57:18] <TheMightyBuzzard> second verse, same as the first. just sub paypal for stripe.
[10:57:24] <Bytram> nod nod
[10:57:29] <Bytram> on it.. THANKS!
[10:58:07] <Bytram> more columns in paypal_log than in stripe_log
[10:58:29] <TheMightyBuzzard> ya. different returned data necessitates different structure.
[10:58:36] <Bytram> nod nod
[10:58:49] <TheMightyBuzzard> personally, i'd rather keep it simple like the stripe_log.
[10:59:01] <Bytram> and, apparently we gots lot more records, too. 941 vs 150, atm.
[11:00:48] <TheMightyBuzzard> we pulled in another $389 even since midnight utc on stripe. should be close to funded.
[11:01:54] <Bytram> nod nod
[11:02:12] <Bytram> was about to re-update the beg-o-meter, until I saw the discrepancy
[11:06:57] <Bytram> for now, my calcs should be close enough for reminder-to-subscribe purposes
[11:07:23] <TheMightyBuzzard> yar
[11:07:56] <TheMightyBuzzard> once we get a proper treasurer we should do a State of the Wallet post.
[11:08:12] <Bytram> that would be good!
[11:09:31] <Bytram> gots a favor to ask of ya... I updated the recent_subs;admin;default template on prod using the template editor... would you be so kind as to copy that and make a proper update for the site from it?
[11:09:59] <Bytram> IOW, if the site goes sideways, we'd lose my changes... which I have tested and seem to work fine.
[11:10:32] <TheMightyBuzzard> yeah. not just this moment though. still coughing up the morning lung.
[11:12:44] <Bytram> I have a copy saved to my local hard disk, but would like to make it official... not a hurry, just don't want it to fall through the cracks, is all.
[11:12:46] <Bytram> hope things clear up soon for ya
[11:13:26] * Bytram sends some extra-spicy chilli through the interwebs to TMB in hopes its consumption would help clear sinuses, etc.
[11:14:34] <Bytram> beg-o-meter updated; we are now at *approximately* $2850.13 out of $3000.00 -- 95.0% of goal
[11:15:13] <TheMightyBuzzard> near as i can tell, if you take care of yourself, drink lots of fluids, and get plenty of rest a cold is gonna last seven days.
[11:15:21] <TheMightyBuzzard> if you don't it'll last a whole week.
[11:16:02] <Bytram> true, that... but one approach is a bit less uncomfortable than the other
[11:16:34] * Bytram likes spicy hot-n-sour soup and spring rolls with chinese mustard to help clear his sinuses
[11:17:02] <TheMightyBuzzard> knod knod
[11:17:19] <Bytram> break time
[11:17:30] * TheMightyBuzzard prefers taking mucinex and eating bowls of jalapenos
[11:17:42] <Bytram> that'd work, too.
[11:18:39] * Bytram orders express delivery of moist-towelettes for shipment to TMB to help alleviate 'back-of-house', ummm, 'issues'
[11:18:42] <Bytram> ;)
[11:18:49] <Bytram> biab
[11:23:22] <TheMightyBuzzard> think ima go in search of breakfast n read a book
[12:32:01] <Bytram> TheMightyBuzzard: I'm not absolutely certain, but I think I found the thing in common which causes paypal to charge an extra $0.30 per transaction for a $20.00 subscription: residence_country != "US"
[12:41:48] <Bytram> https://www.paypal.com
[12:41:51] <upstart> ^ 03PayPal Merchant Fees: Current Rates for all Merchant Accounts – PayPal US
[12:42:08] <Bytram> In the U.S. a fee of 2.9% of the transaction amount plus a fixed fee based on the currency.
[12:42:21] <Bytram> Outside the U.S. a fee of 4.4% of the transaction amount plus a fixed fee based on the currency.
[12:42:40] <Bytram> note: "fixed fee" links to: https://www.paypal.com
[12:42:41] <upstart> ^ 03PayPal Merchant Fees: Current Rates for all Merchant Accounts – PayPal US ( https://www.paypal.com )
[12:43:46] <Bytram> values, there, are given in THAT country's local currency -- Euro, Pound Sterling, Canadian Dollar, Australian Dollar, etc.
[12:44:42] <Bytram> taking another break