Post by Silencer » Fri Apr 09, 2021 3:59 am

My customer can enter some promo code which is only applied to some products. I am now sending data to my accounting system and I don't know how to get data from database which products in users order use discount. I can get total discount (but that doesn't add up since I am guessing that value if before total tax). I am using OC version 2.1.0.1.

Newbie

Posts

Joined
Sun Feb 05, 2017 8:25 pm

Post by wrick0 » Fri Apr 09, 2021 5:34 pm

this should be stored in oc_product_discount in mysql based on the product_id so you will have to use that data (i dont use it in my stores so i cant exactly see)

Active Member

Posts

Joined
Fri Jan 18, 2019 10:00 pm
Location - 127.0.0.1 @ The Netherlands

Post by paulfeakins » Fri Apr 09, 2021 6:16 pm

Silencer wrote:
Fri Apr 09, 2021 3:59 am
My customer can enter some promo code which is only applied to some products. I am now sending data to my accounting system and I don't know how to get data from database which products in users order use discount. I can get total discount (but that doesn't add up since I am guessing that value if before total tax). I am using OC version 2.1.0.1.
This is the sort of custom development that requires a developer such as ourselves or post a job in the Commercial Support Forum.

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom
Who is online

Users browsing this forum: No registered users and 214 guests