In the controller
if(isset($this->session->data['coupon'])){
$coupon_price= $this->model_checkout_coupon->getCouponPrice($this->session->data['coupon']);
$this->data['coupon_price'] = $coupon_price;
}
In the model
public function getCouponPrice($data){
$coupon_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "coupon WHERE code = '" .$data . "'");
return $coupon_product_query->row;;
}
By this you will be easily get the coupon checked in the opencart and be able to apply the coupon code in the opencart. Now i have started to work in the CSV management
CSV stands for Comma Separated Value.
The easiest way to export the data in the database which is in the excel sheet.
What i have found from this video is that we have to buy the module for $22 to $30 so if you want to buy then only watch this video
Csv Import Pro Video, Opencart CSV import/export video tutorial