Hi everyone, The Czech Republic will be changing its standard VAT (Value Added Tax) rate from 19% to 20% on the 1st January 2010. Right now I have aMember configured to add the 19% VAT to every order coming from the EU but apparently need to change it to 20% soon. Each of the current 27 EU member countries is set under the "Regional Tax Setting" in aMember's Setup. My problem(s): 1) There is no way to edit the currently set rate in aMember's Setup, you can only remove the Country/State under the "Regional Tax Setting" and then add it again. There is one entry for each of the 27 EU member countries so it's a bit cumbersome. 2) Would it be possible to change the VAT rate in the aMember database directly or programmatically with PHP? The MySQL value is apparently of the BLOB datatype... Any ideas are welcome. The point is, so far it seems I will have to sit at the PC and change aMember's setup instead of enjoying New Year celebrations... Tomas
My guess would be: Yes, because I can't find the tax data at other places in the db. But I'd like to see confirmation from Alex On the other hand Toma, what would happen if you try it out? Just make sure you have a backup...
You cannot edit the db field directly because it's of the BLOB datatype. Who knows why it's BLOB though... I am seriously inclined againt "trying things out" with my aMember database as the website is quite frequented and I simply cannot try something without confirming it will work on either a test installation or at least have a reasonable theoretical prove it will not do anything bad. Keep in mind we are talking about a live website here... Tomas
You can change value field type from BLOB to TEXT in database then edit it. But you should be very carefull because value is serialized array. If you will just change 19 to 20 this should not broke that field, anyway backup databse before any modifications, or contact us in helpdesk.
Thanks for the suggestion Alex. I will try that. I suppose quite a few aMember merchants will have the same problem as I do because the UK is in a very similar situation now - i.e. the VAT rate will be changed on 1st January in the UK too. Also, if I change the BLOB field to TEXT, I suppose, I should change it back to BLOB after the edit? Tomas