Points & Loyalty Module is now Live!

[Brennan]

The brand new points and loyalty module for Miva is now available on the app store. This new module allows you to:

• Configurable point accrual based on price or item quantity
• Ability to set when points are added to the customer account (ordered or shipped)
• Set a points Expiration
• Tiered redemption rules based on minimum point thresholds
• Run Point Promotions (2x points for this weekend only)
• Points History Page – Customers can view their point transaction history from their account
• Template Level Functions – Ability to give customers points for completing actions
• API support for integrations

Download Module: https://apps.miva.com/points-loyalty-program.html

Docs: https://docs.miva.com/how-to-guides/points-loyalty

[Beefy Nugget]

WOO Amazing! Is there any difficulties when trying to transfer over from the Sebenza points module? Im looking now and dont see a nice way to export the sebenza data :/

[lesliekirk]

Or anything available for the EmporiumPlus Coupon Redemption module Points Redemption?

[Brennan]

As long as you can get the point balances into a spreadsheet, these can be imported via CSV into the new module.

[Beefy Nugget]

Anyone looking for a way to swap over from Sebenza here is what i just did.

Use this SQL code inside your PHPMyAdmin (Thx Dan - Glendale Designs )

 
 SELECT     s01_Customers.login,     s01_SS_POINTS_cust.total  FROM     s01_Customers  INNER JOIN     s01_SS_POINTS_cust  ON     s01_Customers.id = s01_SS_POINTS_cust.cust_id

Then generate a XML file using the export from the SQL output. That should look like this..

      <Module code="points" feature="payment">
<CustomerPointTransaction_Add customer="[Username]" descrip="Sebenza Import" points="[POINTS]" pending="0" />
</Module>

Not sure if there is a better way but i essentially just loaded the CSV into excel and did a formula of

   =CONCAT($E$2,A2,$F$2,B2,$G$2)
  Where A is [Username] and B is [Points]
E is "<Module code="points" feature="payment"><CustomerPointTransaction_Add customer=" "
F is "" descrip="Sebenza Import" points=" "
G is " " pending="0" /></Module> "

Then copy paste into txt file and upload.

Haha please let me know if there is an easier way to generate XML haha

[Beefy Nugget]

Is there any way to exclude a price group from accruing any points?

[Viscott]

Is there any way to exclude a price group from accruing any points?

We don't want wholesale accounts assigned to wholesale price group accruing points.

[K Series Parts]

are points removed if an item/order is returned?

[K Series Parts]

just read through the docs and it does refund so that is nice. Right now we offer up to 5% off an order with your points but it doesn't appear that is an option, unless I am missing it.

[Brennan]

Viscott We're looking at adding availability group restrictions in a future update. Currently points will apply to all customers. However, you can work around this today by using the template level functions to remove the points from customers you don't want to receive them

Example:

<mvt:comment>Load the current ponit balance of the customer</mvt:comment>
<mvt:item name="points" param="CustomerPoints_Load( l.settings:order:cust_id, g.customerpoints )" />


<mvt:comment>Clear any points for this customer</mvt:comment>
<mvt:assign name="l.settings:transaction:cust_id"      value="l.settings:order:cust_id" />
<mvt:assign name="l.settings:transaction:user_id"      value="0" />
<mvt:assign name="l.settings:transaction:pending"      value="0" />
<mvt:assign name="l.settings:transaction:order_id"  value="l.settings:order:id" />
<mvt:assign name="l.settings:transaction:line_id"      value="0" />
<mvt:assign name="l.settings:transaction:descrip"      value="'Wholesale Customers Not Eligible for Points'" />
<mvt:assign name="l.settings:transaction:points"      value="g.customerpoints:points * -1" />


<mvt:item name="points" param="CustomerPointTransaction_Insert( l.settings:transaction )" />

K Series Parts Points are removed automatically when the order is refunded or cancelled via Miva. If you wanted to offer a discount to customers paying with points you could use the give them the discount using https://docs.miva.com/how-to-guides/...-template-code. I have not tested this though, It may be late in the checkout to apply a discount to the order since you don't know they want to pay via points until OPAY.

[Brennan]

Viscott Another option after talking to our dev team would be to just always hide the points payment method for your wholesale customers. So they could still technically accrue points, but would never be able to use them as that payment method would always be excluded.

[K Series Parts]

Brennan percents would be nice, can't just afford to give it all way on an order, that happened to us in the past and it wasn't sustainable. Point cap for ranges are also very hard to explain and customers to understand, we found that saying a 5% max discount was the easiest.

[Beefy Nugget]

I think there is also a slight bug or rounding error with the points. Our current settings are to offer 3points per dollar on an item. When a customer adds two quantity of an item wih a value of $1.50, it should award them 9 points but it currently only offers 8. My guess is that its doing the rounding prior to multiplying the quantity. So 1.5 x3 -> 4.50 then it rounds down to 4, then runs the same item again for another 4 and adds them. Instead of just doing 1.5x3 -> 4.5x2 -> Round

[delcorsets]

Brennan , I think K Series Parts (and me too) is looking for a way to cap the discount as a percent of the order sub-total. This is a feature I'm currently using in the E.O.L. Sebenza Points Redemption module. I can't allow a shopper to redeem points for a value more than 50% of their order sub-total.

I've attached a screenshot of the Sebenza admin screen as it shows a pretty simple setup of the various settings that the module offers.

[Brennan]

Got it. That is not something the module currently supports, but we can add it as a phase 2. A potential work around would be to via template code and JavaScript to only let the customer redeem x% of their points on the OPAY page. This already has the ability to do a partial payment using points so it would not be too difficult to limit how much they can use and hide the option to pay the total via points.

pay-by-pts2.jpg