Comission on subtotal not total in Affiliate Manager Help and Support Posted May 26, 2020 this is the answer i got from opencart community. "All line items on the order are stored in the "order_total" table. You can find the relevant lines using the "order_id" column, then loop through the rows you find, and pick the one with code "shipping". The cost of the shipping will be stored in the "value" column." How do i subtract this from the commission % ?