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

Piota Apps - Piota - Apps for Schools

Piota Apps - Piota - Apps for Schools a great intro to Piota's App offering

Danscentre's Dancing Dads 2015 is fundraising for The Archie Foundation

Danscentre Adults is fundraising for The Archie Foundation hitting the HMT stage this Saturday, feel free to donate

j2store Promotions plug-in API

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

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

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

PHP at 20: From pet project to powerhouse | InfoWorld

PHP at 20: From pet project to powerhouse | InfoWorld a nice retrospective by Ben Ramsey

Join Our Award Winning Team | We are AD

Join Our Award Winning Team | We are AD quite a few good jobs on offer at AD just now

Prestige Event – Raspberry Pi from Concept to Creative Platform | Learning Technologies Team

Raspberry Pi from Concept to Creative Platform | Learning Technologies Team

Speaker: Pete Lomas

11/06/15 17.30-20.30

Learning Technologies Team

Learning Technologies Team a good resource for school tech in Aberdeen

Raspberry Pi Multi-Room Audio (Mobile/Tablet/PC Controlled)

Raspberry Pi Multi-Room Audio (Mobile/Tablet/PC Controlled) sounds like a good FOSS Sonos

Join the Guardian’s Development Team – The Guardian – Developers

Join the Guardian’s Development Team – The Guardian – Developers some interesting dev jobs at The Guardian

Notification - Web API Interfaces | MDN

Notification - Web API Interfaces | MDN really useful docs on HTML5 Notifications

The Code Manifesto

The Code Manifesto

Mileend flats

Mileend the crazy flats in the Mile End School

Code Manifesto

An inspiring talk at J and Beyond by Kayla Daniels

Joomla as a mobile App backend