
someone
Members-
Content Count
13 -
Joined
-
Last visited
Community Reputation
0 NeutralRecent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Comission on subtotal not total
someone replied to someone's topic in Affiliate Manager Help and Support
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 % ? -
Comission on subtotal not total
someone replied to someone's topic in Affiliate Manager Help and Support
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? -
Comission on subtotal not total
someone replied to someone's topic in Affiliate Manager Help and Support
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.
-
Affiliate Tracking Code Issue
someone replied to someone's topic in Affiliate Manager Help and Support
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 %{REQUE
-
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_inte
-
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