The Total Import PRO supports import of all the product special fields supported in OpenCart. You do not need to specify all the fields, you can specify just the price, and the rest will be auto-populated for you with sensible default options. Please see below for details on formatting special prices in your CSV or XML file. If you require a sample CSV file containing the correct formatting, it is available here.
Special Price Format:
Special price of 2.50 from January 7 to January 12
2.50:8:1:jan 7:jan 12
Special price 5 from December 10, 2014 to March 10, 2015
To import the special price your feed does not need all the fields, only the price. But if you wish to specify additional data for the special price (such as group and priority requirements) it has to be in this format. If you want only price, group and priority you can use:
Customer Group ID:
The Customer Group ID is the safest way to identify the customer group. You can also use the Customer Group's name, but you must make sure you use exactly the same name as the name of the customer group (even extra spaces will cause mismatches and incorrect import of this field).
The customer group id can be found by going to Sales -> Customers -> Customer Groups, select 'edit' on the customer group and you will see something like this in the URL of the page:
This is the ID for that particular group (in this example it is 8).