Automatically change store based on user location magento
Magento has the inbuilt facility to set up multistore functionality in the admin side.It can be managed from the front end by a store switcher or language switcher.But what if we needed to be automatically change store based on user …
Map integer to text string in mysql
We can use the functions CASE .. WHEN … to map integer to text string in mysql The example query is as shown below You can also use the ELSE clause to specify a default, e.g.
Delete all categories in Magento
If you have been working on a demo store – or yours is still in the early stages of construction, you will probably find it necessary to remove all the categories to start fresh at some point So here is …
Find and Replace with MySQL
— 1st example UPDATE files SET filepath = REPLACE(filepath,’path/to/search’,’path/to/replace’); — 2nd example UPDATE customers SET address = REPLACE(address,’_CODE_’,postcode);
