Friday, June 26, 2015

Removing VAT from prices via MySQL

Just a wee note, if you've got prices in a table, for an online shop perhaps, that are Gross, but you want to change them to Net.  So, for example, prices with 20% VAT, switched to an Ex VAT price, you can do this with a neat one line of SQL.



So, via MySQL, perhaps phpMyAdmin, you would do something like...

UPDATE product_table SET price_field = price_field / 1.2


For a practical example, in OpenCart, this would be...

UPDATE oc_product SET price = price / 1.2

Tuesday, June 23, 2015

Wednesday, June 17, 2015

j2store Promotions plug-in API

Details on j2store Promotions plug-in API we're writing a buy one get one free (BOGOF) plug-in

Tuesday, June 16, 2015

CodeTheCity 4 Schedule

CodeTheCity 4 Schedule this weekend

[57north-announce] Summer Newsletter

[57north-announce] Summer Newsletter lots of good stuff in 57north newsletter, and a bit about J & Beyond

Piota - Home

Piota, Apps for Schools great to be a part of this team

Sunday, June 14, 2015

I Prefer This Over That | Test Obsessed

I Prefer This Over That | Test Obsessed A good piece, extolling...

Recovery over Perfection,

Predictability over Commitment,

Safety Nets over Change Control,

Collaboration over Handoffs,

and,

True Responsiveness over the Illusion of Control

Friday, June 05, 2015

Wednesday, June 03, 2015

The Code Manifesto

The Code Manifesto

Mileend flats

Mileend the crazy flats in the Mile End School

Monday, June 01, 2015

Code Manifesto


An inspiring talk at J and Beyond by Kayla Daniels


Joomla as a mobile App backend