Script SQL to add all the departamentos (states) of Colombia into the ps_state table in the database

[Andrés Díaz]

Hello,

 

Recently I was developing an e-commerce site in Colombia and had the need to add all the states (in Colombia it is called departamentos) into the database.

 

To quickly do this, I used a SQL script to add all the Colombian departamentos and I thought it would be useful to share them with you.

 

SQL script to add the list of Colombian departamentos into the ps_state table in Prestashop database

 

http://trickortip.co...ates-table.html

 

I hope this helps since prestashop does not have the Colombian departamentos in the ps_state by default.