Provider commissions system for X-Cart Pro

Hello All, I need a Provider commissions system for X-CART PRO! I need a project programmed for me that will provide me FULL control over payments for providers. Project aim The project aim is development of the specific Providers' commissions functionality based on 4.1.7 version of X-Cart Pro site. All customer payments will go in admin merchant account (as in original X-Cart Pro) and admin will manually pay each provider for their orders, with holding admin commissions for the services. The following specifications are for the conversion of X-CARTs X-Affiliate module to be able to handle payment to provider. If you have a better idea on how to program for us a provider payment system not necessarily based on X-affiliate module we would be very interested to hear your suggestions and your price. Features' descriptions 1. Provider profile changes We will add two new fields to the provider profile. These fields will be visible and editable to the store administrator only. The fields are: - Provider commission (Basic commission rate) [text field] [This field will contain the provider commission percent] - Minimum commission payment [text field] [This field will contain value of minimal admin payment to the provider] Using these fields, the store administrator will control the commission percent for each provider 2. Customer area changes Basically, no visible changes in the ordering process will be made. The provider commission will be calculated at the moment of purchase and record about it will be inserted to the database (the same way as X-Affiliate module processes its commissions) The difference between partner commissions (X-Affiliate module) and provider commissions is following: - The partner commissions are calculated from the order subtotal. This means total product sale prices excluding shipping cost, TAX and Payment method surcharge. - The provider commission will be calculated according to the subtotal of the order including TAX + full shipping cost. Example Partner receives 5% commission Provider receives 70% commission Order Example: Product A = $100 Product B = $200 Subtotal = $300 Shipping cost = $10 Tax = $30 Payment method surcharge = $20 Total = $360 Derived Commissions: Partner receives 5% of product sale price excluding TAX = $15 Provider receives 70% of product sale price including TAX + shipping cost = $231+$10=$241 Admin receives the remaining sum + any addition cost admin has add (Payment method surcharge) = $84+$20=$104 It may happen that partner commission + provider commission sum will be bigger than order total. In this case the Admin commission (remaining sum) will be shown in red, as it will be a negative amount, on the "Provider orders" page (see "New pages in admin area"). Note: Connection with the "X-Special offers" module: If the customer receives the bonus points as a result of special offer the appropriate amount will be deducted from the provider commission. The deduction sum will be calculated using the "Gift Certificate conversion rate" option. 3. New pages in admin area Three new pages will be added to the admin area in order to manage provider commissions: - Provider orders - Provider accounts - Payment history 1. "Provider orders" page. The page will be similar to the "Partner orders" page for X-Affiliate module Initially, the page will contain the search form with the following search criteria: - Date from [date selector] - Date to [date selector] - Order id [text field] - Provider [select box: list of all providers in the system + "All" option] - Order status [select box: all order statuses + "All" option] - Payment status [select box: "All", "Pending", "Approved", "Paid" options] - Payment id [text field] - "Search" button By clicking the "Search" button, the list of found orders with the commissions will be shown. The search results page will contain list of provider order commissions. Each record will contain following information: - Provider [provider login, clickable. By clicking on this link the provider profile page will be opened] - Order id [order id, clickable. By clicking on this link the order details page will be opened] - Order date [order date] - Total [order total] - Commission Admin [remaining sum (admin commission), $] - Commission Provider [provider commission, $] - Commission Partner [partner commission, $] - Partner [partner login, clickable. By clicking on this link the partner order page will be opened for the specific order (Search for order ID in partner sale page)] The link can point to the example URL: [login to view URL][orderid]=(#order id here) - Status [order status] - Commission [commission status: "Pending", "Approved" or "Paid". If the status is "Paid", the payment id is shown near the status] - (bonus/membership) [if some special offers are applied to this order, it will be shown in this column. If special offer was bonus points, the number of points will show. i.e. 40] Below this table, the totals information will be shown for each column. 2. "Provider accounts" page. The page will be similar to the "Partner accounts" page for X-Affiliate module with some differences This page will contain summary information about provider commissions. At the top of the page store administrator will be able to select between all providers and providers "Ready to be paid". "Ready to be paid" provider account is an account for which the approved commission is greater than the minimum commission limit. To do this we will add two links to the top of the page: - All accounts [radio button, checked by default] - Accounts "Ready to be paid" [radio button] - Use date [checkbox, unchecked by default] - Date from [date selector] - Date to [date selector] - Search [submit button] By clicking on the "Search" button, the appropriate provider accounts will be shown. The commissions will be calculated according to the selected date (or, if the "Use date" is unticked, the whole payment history will be used) Below these link, the found provider accounts will be shown. The following account information will be shown: - Provider [provider login, clickable. By clicking on this link the provider profile page will be opened] - Paid [paid commissions sum. The sum of commissions with the "Paid" status] - Approved [approved commissions sum. The sum of commissions with the "Approved" status] - Pending [pending commissions sum. The sum of commissions with the "Pending" status] - Minimum limit [the minimum commission limit for the provider. This value is taken from the provider profile] - Ready to be paid [checkbox] - Payment details [text area] - "Paid" button By clicking on the "Paid" button, the status of the commissions, selected using "Ready to be paid" checkbox will be set to "Paid". The payment date and details will be saved to database. Note that commission should be in "Approved" status and the commission sum should be bigger than "Minimum limit" value. Otherwise, the commission status won't be changed. The commission statuses explanation: - Pending. This status is set for all commissions for orders with "Queued" status. - Approved. This status is set for all commissions for orders with "Processed" and "Completed" statuses. This status is set automatically when order status is changed to the "Processed" or "Completed" - Paid. The same as above, but the "Paid" status is set by admin only. Note: commissions are calculated only for orders with following statuses: Queued, Processed, Completed 3. "Payment history" page. This page will contain the list of payments for providers The search form will be shown on this page by default. It will contain following criterias: - Search using date [checkbox] - Date from [date selector] - Date to [date selector] - Payment id [text field] - Provider [text field] - Use paging [checkbox] - "Search" button By clicking on the "Search" button, the list of found transactions will be shown. It will contain following information: - Transaction ID (payment id) - Provider - Transaction Date - Transaction amount - Transaction details [text area, editable] Below the list the "Save" button will be added. By clicking on this button, the payment details will be updated. 4. New pages in provider area Three new pages will be added to the provider area in order to track commissions: - Product sales - Summary statistics - Payment history 1. "Product sales". This page will be similar to the "Referred sales" for the X-Affiliate module. This page will show the sales statistics per each sold product in the store. Initially, the search form will be shown. This search form will contain the following criterias: - Period from [date selector] - Period to [date selector] - SKU [text field] - Order id [text field] - Show top products [checkbox] - Status [select box, commission status: "All", "Pending" and "Paid" options]. Note: "Pending" status in this case includes commissions with "Pending" and "Approved" statuses. - Payment id [text field] - Search button According to "Show top products" checkbox, the search results page will be shown in two modes: a. "Show top products" checkbox is ticked. In this case, the products sales information will be shown. The search results table will contain following information: - Product [product name, clickable. By clicking on this link, the product details page will be shown] - Quantity [total quantity] - Total [total sum of this product] - Commission [commission sum for this product] b. "Show top products" checkbox is unticked. In this case, the orders information will be shown. The search results table will contain following information: - Product [product name] - Order id [order id, clickable. By clicking on this link, the order details page will be shown] - Order date [order date] - Quantity [ordered quantity of particular item within order] - Total [The product sales price] - Commission [commission sum] - (bonus/membership) [if some special offers are applied to this order, it will be shown in this column. If special offer was bonus points, the number of points will show. i.e. 40] - Status [commission status (if the status is "Paid", the payment id will be shown near it)] Below this table, the totals information will be shown. It will contain summary quantity, summary pending commissions sum and summary paid commissions sum. Note: by clicking the "Order id" link, the provider will be redirected to the order details page where he will be able to see all information about special offers, attached to this order. 2. "Summary statistics" page. This page will be similar to the "Summary statistics" for the X-Affiliate module. This page will show the sales statistics per each sold product in the store. On this page, the provider will be able to see the summary statistics about his commissions. This page will contain following information: - Total sales [number of orders with "Queued", "Processed" or "Completed" statuses] - Total unapproved sales [number of orders with not paid commission] - Pending Sale Commissions [sum of "Pending" commissions] - Approved Sale Commissions [sum of "Approved" commissions] - Paid Sales Commissions [sum of "Paid" commissions] 3. "Payment history" page. Similar to the "Payment history" page for X-Affiliate module page. The search form will be shown on this page by default. It will contain following criterias: - Search using date [checkbox] - Date from [date selector] - Date to [date selector] - Payment id [text field] - Use paging [checkbox] - "Search" button By clicking on the "Search" button, the list of found transactions will be shown. It will contain following information: - Transaction ID (payment id) - Transaction Date - Transaction amount - Transaction details Below list the "Paid total" sum will be shown 5. Processing of "Failed" and "Declined" orders 1. If the commission was paid and after that the order status has been set to "Failed" or "Declined", the new transaction with negative amount will be added to the commissions list (both partner and provider commissions). 2. If the order status has been changed once again to one of "good" order statuses: "Processed" or "Completed", this transaction will be deleted from database. 3. If some items from the order has been returned (X-RMA module), then the commission for this order will be recalculated (the correction transaction with negative amount will be added to the list) 4. If the order has been changed using X-AOM module, the commission for this order will be recalculated and the correction transaction (either with negative or positive amount will be added to the list). Notes The new functionality will be similar to the X-Affiliate module. It will affect with the other modules (X-RMA, X-Special offers, X-AOM) in the same way as X-Affiliate does Requirements X-Affiliate module X-AOM module X-RMA module X-Special Offers module Hope to hear from you soon.... Thanks.