Can I import discounts?

The Total Import PRO supports import of all the product discount fields supported in OpenCart. If you do not need to specify all the fields, you can specify just the price and quantity fields, and the rest will be auto-populated for you with sensible default options. Please see below for details on formatting discount prices in your CSV or XML file. If you require a sample CSV file containing the correct formatting, it is available here.

Discount Price Format:


Example data:

2.50:5:8:1:jan 7:jan 12

To import the discount price you feed does not need all the fields, only the price. But if you wish to specify additional data for the discount price (such as group and quantity requirements) it has to be in this format. If you want only price, group and quantity 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).

Was this article helpful?
3 out of 3 found this helpful
Have more questions? Submit a request


  • Avatar
    Gino Shemesh

    I can't seem to get the customer group part working, I have this code setup:


    It keeps thinking that the 5 is quantity for some reason, and it does not register the customer group (5 in this case) at all. Any help would be much appreciated!

  • Avatar
    Yow Chuan

    What if I need to have multi-tier discounts. If that's possible, how do I separate each tier?

    For instance, I want to set the price at 15.00 for 3 units, 14.50 for 6 units, 14.00 for 9 units so on and so forth.

    Hope there'll be a response.

  • Avatar

    This tutorial basicly tells how to do that, read it more carefully or ask what exactly do you need .

    In your case it should be like 15:3 14.5:6 14:9.

  • Avatar
    Yow Chuan

    Gxtidus, what do you mean read it more carefully? If I could find it in the article above, I wouldn't have asked, unless you are referring to another tutorial that I haven't read. 

  • Avatar

    Sorry my bad i was reading it through mobile and didn't see correctly you'r question. But i have given you an example , have you tried it? 

  • Avatar
    Yow Chuan

    Nope, it doesn't work after I set up the second tier entry.

    What workes now:


    What didn't work:

    15.00:3 14.00:6

  • Avatar
    Yow Chuan

    Hello? Do I have to pay for support? If so, name a price.

  • Avatar

    It should be in separate fields, if you download the example file you will see that there are "discount_price" "discount_price2" .

    So in your case it should be "Discount Price 15:3" "Discount Price 2 14.5:6" "Discount Price 3 14:9"


    Hope this was helpful .

    FYI: you can always open up a support ticket the team will help you they are pretty great.

Powered by Zendesk