--- title: "Reward Points per Product" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31100561/Reward%20Points%20per%20Product" format: markdown --- The system also has a further optional ability to input and maintain reward points per product. The product group has against it the dollar value to be spent in order to obtain one point. A nightly scheduled task works through the sales transactions to calculate the rewards points for each cash sale transaction and updates the customer rewards points balance appropriately. Customers can then redeem their reward points to make purchases, as described above. To load used reward points by product, perform the following: Input of Product Group Reward Point Rates ProStix has the ability to import the product group and the dollars per point reward rate. There is also an option to maintain any of these product group reward point rates. Import from CSV file 1. From the ProStix Main Menu select 'Accounts Receivable' then 'Customer Rewards' then 'Product Group Reward Rates' then 'Import Reward Rates from CSV'. The system prompts for the .csv source file location and name: 'File Name: /prostix/dmp/prodgrprewards.csv', and when the user has entered this, the system validates the file exists and then imports the data into ProStix. This csv file name has the following format: Product group, $ per point. An example of the csv file is as follows: #12,5.00 #13,5.50 #14,9.00 #20,15.00 #30,25.00 For each line within the csv file, a product group rewards rate record is created. If the product group already exists, the existing value is overwritten with the value within the csv file. If an error occurs within the import (that is, the product group does not exist or the rate is zero or negative), then the line in error is exported out to the dump directory with the file name 'prodgrperr.csv'. Manual Maintenance 1. From the ProStix Main Menu select 'Accounts Receivable' then 'Customer Rewards' then 'Product Group Reward Rates' then 'Maintain/View Reward Rates'. 2. You are then presented with a standard ProStix browser that enables you to maintain the dollars per point rates by using the Add, search, Change and Delete function keys. Calculation of Reward Points from Sales A nightly scheduled task examines daily POS cash sale transactions and calculates the rewards points based upon the product groups of the products sold. The transaction's reward points total is then to be updated to the customers reward points total. There are no parameters for this job. Business Rules: A new scheduled task has been created via a separate setup program. This should only have to be run initially to create the task within the environment. The program is called 'syssprodrew.p'. This creates the scheduled task. The nightly task first extracts the last run date and time. Only POS log cash sales and cash refunds entries between this last run date and time stamp and the current date and time are picked up. If the POS Log entry has a tender type of 'Other' and is marked as a reward program tender, then it is excluded. We do not want to calculate points on transactions that have been paid by reward points. If there has been a mix of tenders used within the transaction (that is, cash and reward points), the points are only calculated on the cash value starting at the first line of the order down to that cash value amount. The points are calculated by each order transaction, that is, for each order transaction line, the product group is derived from the product purchased and then the order line total is divided by the product group reward rate. Each line's reward value is accumulated for the order and that reward total is then added to the customer's reward total. Note that for credits, the reward total is negative and will thus reduce the customers reward total. The Rewards Points Control G/L Account is then credited by the total reward points amount and the Rewards Allocated Account debited by that reward amount. At the end of processing all the cash sale/cash refund POS log entries, the last run date and time stamp is recorded so the next run only picks up new unprocessed POS log entries. For example: Product XYZ belongs to Product Group #12. Reward Rate = 5.00 Product ABC belongs to Product Group #20. Reward Rate = 15 Order 123 has 2 products. Order Line Amount Reward Points Gained Product XYZ $100.00 (100/5) = 20 points Product ABC $80.00 (80/15) = 5.3 = 5 points ORDER TOTAL: $180.00 (20+5) = 25 points Note : Reward points are rounded to the nearest whole point. In this example, 25 points are credited from the Rewards Point Control G/L Account and 25 points debited to the Rewards Allocated Account.