Very often whether you've imported from a data file or from an
older CactuShop database, you will want to run some additional
processing on the order. For example, you may want to change the
product display type for all items, or fix other problems you might
find in imported data.
Fortunately the Data Tool
has a built in method for doing this. Within the
KDT_Resources folder, there is an .sql
file called 'kartrisSQL_Update.sql'. This
SQL gets run against the database after an import is complete. This
mainly fixes null values and other such issues, but you can add your
own SQL code to this if required.
This SQL file
gets run after both data file or CactuShop data imports, both using
the GUI or in command line mode.