Author: jibran

VaultPress Is Awesome, But Not Realtime For Plugins Like WooCommerce

Update 13 July 2016: According to VaultPress support, WooCommerce tables are now backed up realtime just like core WordPress tables. However, non-WooCommerce and non-WordPress core tables are still only backed up once a day. So if you have custom tables

Posted in: Development, News  |  Tagged with: , , , ,  |  Leave a comment

SQL Script To Get All WooCommerce Orders Including Metadata

A client of mine has a rather large WooCommerce database. We’ve been trying to run reports using the WooCommerce Customer/Order CSV Export plugin but have been running into timeout issues—the glorious WordPress white screen of death. I got fed up

Posted in: Code Samples, Development  |  Tagged with: , , ,  |  Leave a comment

Well Don’t You Just Have Some Nice Manners (Music)

Ok here’s the deal, kids. There’s this pretty rad recording studio based out of LA with the most badass of names: they’re called Nice Manners. Not only do they have a badass name they also do badass work. And not

Posted in: Portfolio  |  Tagged with:  |  Leave a comment

ProtonMail Turning One, Doubles Storage to 1GB

Me yes me; I am a ProtonMail fan. They provide end-to-end encrypted email and are based in Switzerland. I know there are those that feel privacy is dead or quickly default to the “I have nothing to hide” excuse, but

Posted in: News, Technology  |  Tagged with: ,  |  Leave a comment

Move Your Damn WordPress Debug Log so It’s Not Accessible via HTTP

Every time I need to view a WordPress debug log, I get a little belly-side security loophole cringe. It completely depends on what information you stuff into it that would cause a security issue, but it’s so easy to mitigate

Posted in: Code Samples, Development  |  Tagged with: , ,  |  Leave a comment

Convert A Massive CSV To Many CSVs Using PHP

I’m in the process of working in a CSV file with roughly 26000+ rows and 20 some odd columns. Each row represents an historical purchase order, including information such as date, time, name, address, product name, product sku, etc. My

Posted in: Code Samples, Development  |  Tagged with: , ,  |  Leave a comment

Launched: Valhalla DSP

Gosh, it has been far too long since I posted anything. And for that I’m only apologizing to myself, which is effectively moot because I’m also, at the same time, forgiving myself. I’m sorry, Jibran. You’re forgiven, Jibran. Phew, dodged

Posted in: Portfolio, Technology  |   |  Leave a comment

Run Your Own Damn Code after PayPal Calls WooCommerce Back

This isn’t rocket science, but the WooCoommerce documentation (as robust and complete as it is) isn’t clear about how to hook into a PayPal IPN successful charge webhook call back thingy—yes, that’s its technical name. In fact “isn’t clear” insinuates

Posted in: Code Samples, Development  |  Tagged with: , , ,  |  Leave a comment

MySQL: Group By Column And Include Its Count

Without going into too much detail about the why, consider the below table. It’s a snippet of a table I’m working with for an e-commerce site. Any user (user_id) can have different products (product_id), but any user can also have

Posted in: Code Samples, Development  |  Tagged with:  |  Leave a comment

WooCommerce: How To “Trash” All Orders Really Fast

Some context I am working on a WooCommerce installation where I’m dealing with literally thousands of historical orders. All of which I am programmatically importing (including user accounts!) and doing a bunch of special updates, which are numerous and complicated,

Posted in: Code Samples, Development  |  Tagged with: , ,  |  Leave a comment