Automatically Populate Member Custom Fields from Active Subscriptions (Name, Start Date, End Date)

Ask the community
, , , ,
1

Hi everyone,

Question:

Is it possible to automatically populate custom member fields with data from active subscriptions (subscription name, start date, end date), directly inside the Wix Members area?

Product:

Wix Editor – Members Area & Subscriptions

What are you trying to achieve:

I would like to automatically fill three custom fields in each member’s profile using information from their active subscriptions, which are currently accessible via Reports > Active Subscriptions.

Here are the three fields I want to populate:

  1. Subscription name → should be the name of the most recent (or current) subscription.

  2. First subscription date → should be the earliest start date across all subscriptions of the member.

  3. Subscription end date → should be the latest end date across all subscriptions of the member.

These values should appear directly in the Members area, ideally updated daily or in real time.

Special cases to consider:

• If a member has had multiple subscriptions:

• Use the name of the subscription with the latest end date.

• Use the earliest start date among all.

• Use the latest end date .

• If a member has had only one subscription, use that data directly.

What have you already tried:

• I attempted to build multiple backend scripts that runs daily via a jobs.config file, using ChatGPT’s help.

• The script is supposed to fetch subscriptions and update custom fields accordingly.

• Unfortunately, nothing happens, and the logs show no subscriptions are ever found, even though I do have active subscriptions for several members.

Additional information:

• As a workaround, I could manually export both members and subscriptions as CSVs and merge them using a Google Sheets script, but I’m trying to avoid this.

• The website is managed for an association , and the future admins are not comfortable with computers . The less manual work they have, the better .

• I expect to have between 500 and 1,000 members, with some plans added manually via the CRM (e.g., for members paying by check).

:folded_hands: I would greatly appreciate your help or guidance on how to best implement this. Thank you!

Kind regards,