4 votes

TeaCommerce Populate Countries

This script performs various functions on the teaCommerce database in order to populate a list of countries. It:

  • WARNING: deletes all shipping, payment, order, country data - use with care.
  • populates the country table with a list of countries
  • assigns EU countries to the EU VAT group (See http://our.umbraco.org/projects/website-utilities/tea-commerce/tea-commerce-support/29297-Euro-VAT-checking for an explanation as to how I use the VAT grouping)
  • sets up the payment and shipping tables based on the list of countries
  • Sets shipping rates based on 3 zones: country (Sweden in this case), Europe, Rest of World

It should only be used if you are familiar with SQL Server and you should back up your database before using. It is likely the script will need to modified depending on your particular teaCommerce setup.

Tested against v1.4.2.4 of TeaCommerce

 

Screenshots

Package owner

Paul Blair

Paul Blair

Paul has 731 karma points

Package Compatibility

This package is compatible with the following versions as reported by community members who have downloaded this package:
Untested or doesn't work on Umbraco Cloud
8.2.x (untested)
8.1.x (untested)
8.0.x (untested)
7.15.x (untested)
7.14.x (untested)
7.13.x (untested)
7.12.x (untested)
7.11.x (untested)
7.10.x (untested)
7.9.x (untested)
7.8.x (untested)
7.7.x (untested)
7.6.x (untested)
7.5.x (untested)
7.4.x (untested)
7.3.x (untested)
7.2.x (untested)
7.1.x (untested)
7.0.x (untested)
6.1.x (untested)
6.0.x (untested)

You must login before you can report on package compatibility.

Package Information

  • Package owner: Paul Blair
  • Created: 22/03/2012
  • Current version 1
  • License MIT
  • Downloads: 1078