[Skip to main content](#vessel-content) # Affiliate payments (unpaid amount). ## - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") Topic Author - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 9 months ago [\#34678](#34678) by [slydog](/forum/user/4407-slydog "View slydog's Profile") *[Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34678 "Is it possible to make affiliate payments were considered from several order statuses?")* was created by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* Is it possible to make affiliate payments were considered from several order statuses? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 9 months ago [\#34721](#34721) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34721 "Is it possible to make affiliate payments were considered from several order statuses?")* Yes. In the Affiliate tab of the configuration, you have the option "Valid order status" in order to configure that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") Topic Author - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 9 months ago - 14 years 9 months ago [\#34784](#34784) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34784 "Is it possible to make affiliate payments were considered from several order statuses?")* Sorry for the stupid question:) I wanted one more thing to learn. Can I change the display of user/listing (backend) "total unpaid amount" by the "affiliate unpaid amount" (total or only sales). Last edit: 14 years 9 months ago by [slydog](/forum/user/4407-slydog "View slydog's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 9 months ago [\#34806](#34806) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34806 "Is it possible to make affiliate payments were considered from several order statuses?")* If you want to change the name of the column, like any text in HikaShop, you can override it: [ www.hikashop.com/en/download/languages.html#modify](http://www.hikashop.com/en/download/languages.html#modify) The affiliate information of the partner of each order is not loaded on that page so you can't display his total. You would first need to load that data from MySQL but that's really not easy to do as there are several queries to use for that, like we did in the listing function of the file administrator/components/com_hikashop/views/user/view.html.php for the partners listing page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") Topic Author - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 9 months ago [\#34952](#34952) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34952 "Is it possible to make affiliate payments were considered from several order statuses?")* I need to sum​​, which is displayed in user/form with this line here "echo $ this-> escape (@ $ this-> user-> accumulated );" was displayed in the user/listing for each user instead of total_unpaid_amount Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 9 months ago [\#34983](#34983) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#34983 "Is it possible to make affiliate payments were considered from several order statuses?")* You can do that: echo $row->user_unpaid_amount; However, that information is only updated on the partner's listing (and on the front end when the user access his partner account). So it's quite useless on the orders listing by itself. That's why I said that you would first need to load that data from MySQL but that's really not easy to do as there are several queries to use for that, like we did in the listing function of the file administrator/components/com_hikashop/views/user/view.html.php for the partners listing page. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[slydog](/forum/user/4407-slydog "View slydog's Profile")** - [![slydog's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4407-slydog "View slydog's Profile") Topic Author - [ Offline](/forum/user/4407-slydog) Less More - Posts: 45 - Thank you received: 0 - - 14 years 9 months ago [\#35237](#35237) by [slydog](/forum/user/4407-slydog "View slydog's Profile") Replied by *[slydog](/forum/user/4407-slydog "View slydog's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#35237 "Is it possible to make affiliate payments were considered from several order statuses?")* I precisely need it in the partner's listing (user/listing - this is the view of partner's listing page). There is a default "$ row-> user_unpaid_amount", and for me it is not working properly. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86293 - Thank you received: 14271 - - 14 years 9 months ago [\#35263](#35263) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Affiliate payments (unpaid amount).](/forum/2-general-talk-about-hikashop/34678-affiliate-payments-unpaid-amount#35263 "Is it possible to make affiliate payments were considered from several order statuses?")* That display is already done : echo $this->currencyHelper->format($row->user_unpaid_amount,$row->user_currency_id); If that doesn't work: make sure that you're using the latest version of HikaShop as we fixed that in a recent release. if you have the latest version, activate the debug mode in the joomla configuration and try again to display that listing. Do you get an error message ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzM0Njc4LWFmZmlsaWF0ZS1wYXltZW50cy11bnBhaWQtYW1vdW50P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.117 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)