someone

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 % ?

there is no separate column for sub_total in order table, just total in opencart, however there is a code sub_total un order_total table. how can i refer to that?

this: //START AFFILIATE INTEGRATION $jrox = mysqli_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD,DB_DATABASE); $sql = 'SELECT * FROM `' . DB_PREFIX . 'order` WHERE order_id = ' . (int)$this->session->data['order_id']; $jrox2 = mysqli_query($jrox, $sql); $aff_data = mysqli_fetch_assoc($jrox2); $aff_integrate = file_get_contents('https://www.somewebsite.com/affiliates/sale/amount/' . $aff_data['total'] . '/trans_id/' . $this->session->data['order_id'] . '/tracking_code/' . $_COOKIE['jamcom']); //END AFFILIATE INTEGRATION

Hello. I am trying the affiliate program on opencart 3.0x . I just noticed, that the comission is being given to the entire order_total, and that includes shipping. Is there way to give comission to the subtotal instead, or to resctict shipping from it somehow? Thank you.

Omg! thank you so much!

thank you for your respond. Sorry got distracted with a different project and did not respond back right away. That htaccess did not changed anything. I wonder if it have anything to do with this part? the store is located at domain.com/store/ has its own htaccess with rewrite rules # SEO URL Settings RewriteEngine On RewriteBase /store/ RewriteRule ^sitemap.xml$ index.php?route=extension/feed/google_sitemap [L] RewriteRule ^googlebase.xml$ index.php?route=extension/feed/google_base [L] RewriteRule ^system/storage/(.*) index.php?route=error/not_found [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css) RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA] -------- and affiliate is located at domain.com/affiliates/ and has this part in htaccess <ifModule mod_rewrite.c> RewriteEngine On # Some accounts require the RewriteBase to be set #RewriteBase / # Force URL to be on SSL page at all times #RewriteCond %{HTTPS} off #RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] RewriteCond %{REQUEST_URI} ^/system.* RewriteRule ^(.*)$ index.php?/$1 [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule ^(.+)$ index.php?/$1 [L] </ifModule> I think something is off between these two.

of course i do. what would be the generic one for this?

Ithis way it does show the main page. I have changed the url in the integration code to include index.php , but i am getting the same error on purchase.

this way it does show the main page.

nope. page not found

Thank you for helping to resolve that issue. It got me further. Now i am testing the integration. As customer i click on the link and made a purchase. checkout/success page showed error on top of the page: Warning: file_get_contents (https://website.com/affiliates/sale/amount/56.8177/trans_id/19775/tracking_code/1-1-someone-KJA9FRZRB7S3IPL): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/someplace/public_html/store/system/storage/modification/catalog/controller/checkout/success.php on line 178 And this is what i have on line 178 there: $aff_integrate = file_get_contents('https://website.com/affiliates/sale/amount/' . $aff_data['total'] . '/trans_id/' . $this->session->data['order_id'] . '/tracking_code/' . $_COOKIE['jamcom']); (website.com is edited of course)

thank you for your reply. I looked at that article and looked in my db . If i will change this, will this throw anything off in my other working database there, such online store database? this is what i have there: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Trying to test this software. Added a tex link for one user. Clicking on that link shoes error. What would this error mean? Error Number: 1055 Expression #79 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'something_affiliate.jam_members_photos.photo_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT `jam_members`.*, `jam_members`.`member_id` as `mid`, `jam_members_photos`.*, `jam_members_groups`.`group_id` FROM `jam_members` LEFT JOIN `jam_members_photos` ON `jam_members`.`member_id` = `jam_members_photos`.`member_id` LEFT JOIN `jam_members_groups` ON `jam_members`.`member_id` = `jam_members_groups`.`member_id` WHERE `jam_members`.`username` = 'someusername' AND `status` = '1' GROUP BY `jam_members`.`member_id` Filename: models/Affiliate_marketing_model.php Line Number: 373