News:

Looking for documentation? Take a look on our wiki

Main Menu

add countries the quick way

Started by omeganos, December 09, 2012, 18:57:20 PM

Previous topic - Next topic

omeganos

Gone into the database and found table virtuemart_shipmentmethods with data

shipment_logos=""|countries=["5","14","21","53","57","72","73","81","84","98","103","105","124","150","160","170","171","203","204","220","222"]|zip_start=""|zip_stop=""|weight_start=""|weight_stop=""|weight_unit="KG"|nbproducts_start=""|nbproducts_stop=""|orderamount_start=""|orderamount_stop=""|cost=""|package_fee=""|tax_id="-1"|free_shipment=""|

I would like to know the numbers for europe and then the rest of the world to save time adding each country via joomla and just add straight to the database via phpmyadmin but cannot find this information anywhere. Can anyone help?

Omeganos

omeganos

Just finished the Europe post zone which includes the following countries:

    Albania
    Andorra
    Armenia
    Austria
    Azerbaijan
    Belarus
    Belgium
    Bosnia and Herzegowina
    Bulgaria
    Croatia
    Cyprus
    Czech Republic
    Denmark
    Estonia
    Finland
    France
    Georgia
    Germany
    Greece
    Hungary
    Iceland
    Ireland
    Italy
    Kazakhstan
    Latvia
    Lithuania
    Luxembourg
    Macedonia, The Former Yugoslav Republic of
    Malta
    Moldova, Republic of
    Monaco
    Netherlands
    Norway
    Poland
    Portugal
    Romania
    Russian Federation
    San Marino
    Serbia
    Slovakia
    Spain
    Sweden
    Switzerland
    Turkey
    Ukraine
    United Kingdom
    Vatican City State (Holy See)

Below are the relevant numbers:
"2","5","11","14","15","20","21","27","33","53","55","56","57","67","72","73","80","81","84","97","98","103","105","109","117","123","124","126","132","140","141","150","160","170","171","175","176","182","245","189","195","203","204","215","220","222","228"

Below is the table entry in full:
shipment_logos=""|countries=["2","5","11","14","15","20","21","27","33","53","55","56","57","67","72","73","80","81","84","97","98","103","105","109","117","123","124","126","132","140","141","150","160","170","171","175","176","182","245","189","195","203","204","215","220","222","228"]|zip_start=""|zip_stop=""|weight_start="500"|weight_stop="1000"|weight_unit="G"|nbproducts_start="1"|nbproducts_stop="9999"|orderamount_start="1"|orderamount_stop="9999999999999"|cost="12.25"|package_fee=""|tax_id="-1"|free_shipment=""|

stavroch

Very nice job, I am looking also for America US, Canada, Asia, Africa, Oceania.

Any help?