Data Management
Data Management

Knowledge Base

In WooRewards, there are many tools at your disposal to manage your data. They’re all gathered at the same location :

WordPress Admin
Admin menu
WooRewards
Menu entry
System
Page
Data Management
Tab

Import and Export

Export points from WooRewards

This will let you export your customers points into a JSON file. You can find details about the JSON format down below.

Select the desired points and rewards system and click on Export.

It will generate a JSON file containing all users and their points. You can open this file into Excel or import it to another points and rewards system in WooRewards.

Export points from other plugins

If you want to migrate from another loyalty plugin to WooRewards, it is also possible.

In the Export from other plugins group, select the Loyalty Plugin for which you want to export the points and click on Export.

It will generate a JSON file containing all users and their points. You can open this file into Excel or import it on a points and rewards system in WooRewards.

Information

Currently, the export points from other plugins supports the following plugins :

  • 1 : HostPlugin
  • 2 : IgniteWoo
  • 3 : myCred
  • 4 : Sumo
  • 5 : WooCommerce points and Rewards
  • 6 : Yith points and rewards
  • 7 : Points and Rewards for WooCommerce (by WP Swings)
  • 8 : Loyalty Program (by Rymera)

If your plugin isn’t in the list, contact us so that we can add it.

Import points

To import points in a points and rewards system, go to the Import Points group.

Select the points and rewards system for which you want to import points, the JSON file containing the points (previously exported) using the Browse button and click on Import.

Other settings are available :

  • Round imported points : Select the desired round system applied. WooRewards only allows integer points.
  • Multiply imported points by : By default, it counts 1 point importer = 1 WooRewards point. You can set another multiplier if needed.
  • Import Mode : Select either Replace customers points or Add points to customers totals.

JSON File format

You can create your own JSON file to import points into WooRewards. The file must have the .json extension and have a content that looks like this :

[
    {
        "email":"jd@example.com",
        "points":"190"
    },
    {
        "email":"emma@example.com",
        "points":"224"
    }
]

If you have a CSV file, you must convert it first into a json file. You can do it by using specific services like https://www.convertcsv.com/csv-to-json.htm

Delete data

WooRewards stores a lot of data in your database and you might want to delete parts or all of it. Fortunately, there are many options at your disposal for that.

Delete points history and user data

Delete a user’s or all users points history for one or all points and rewards systems. Use this feature with care since this action is irreversible. Here are the available options :

  • Select a behavior : Select what type of data you want to delete
    • Delete History Only : Users keep their points and rewards, only history rows are cleaned.
    • Delete All User Data : This will leave users with zero points and no rewards.
  • End date : Only history before that date will be deleted. If you don’t pick a date, the whole history will be deleted.
  • Select a user : If you don’t select a user, all users points history will be deleted.
  • Select a points and rewards system : If you don’t select a system, history for all systems will be deleted.

Delete unused points reserves

Delete point reserves that do not belong to any points and reward system anymore. Use this feature with care since this action is irreversible.

Simply select the reserve you want to delete and click the Delete button.

Delete all data

Remove all points and rewards systems, user points and all WooRewards related data. Use this feature with care since this action is irreversible.

Was this article helpful?
Dislike 0
Views: 311

Continue reading

Previous: Process past orders
Next: Multisite Network