Memberships Import

Import WooCommerce Memberships from a CSV, XML, or JSON file.

Requires WooCommerce Memberships

This entity type only appears in the wizard if the WooCommerce Memberships plugin is active.

Wizard step 2 — column mapping for memberships Step 2 maps source columns to membership fields: user_id, plan_id (or plan_name), status, start_date, and end_date.

When to Use

Migrating members from another membership platform
Bulk granting memberships to users
Restoring memberships from a backup

Match Keys

id (default) — Membership ID
user_id — WordPress user ID

Column Reference

Column	Required	Example
`id`	No	`42` (for updates)
`user_id`	Yes	`15` (WordPress user ID)
`plan_id`	Yes (or plan_name)	`100` (membership plan ID)
`plan_name`	Alternative to plan_id	`Gold Membership`
`status`	No (default `active`)	See status list below
`start_date`	No	`2026-04-14 10:30:00`
`end_date`	No (empty for unlimited)	`2027-04-14 10:30:00`
`order_id`	No	`456` (linked WC order)

Membership Statuses

Status	Meaning
`active`	Currently valid
`free_trial`	In free trial period
`delayed`	Not yet started
`complimentary`	Free, granted by admin
`pending`	Awaiting payment or approval
`paused`	Temporarily on hold
`expired`	Reached end date
`cancelled`	Cancelled by user or admin

Example CSV

user_id,plan_id,status,start_date,end_date
15,100,active,2026-04-14 10:30:00,2027-04-14 10:30:00
16,100,active,2026-04-14 10:30:00,2027-04-14 10:30:00
17,101,complimentary,2026-04-14 10:30:00,

Row 3 has empty end_date — it is a lifetime membership.

Using plan_name Instead of plan_id

If you do not know the plan ID, use the plan name:

user_id,plan_name,status,start_date
15,Gold Membership,active,2026-04-14 10:30:00
16,Silver Membership,active,2026-04-14 10:30:00

The plugin looks up the plan by name.

Granting Complimentary Memberships

For free memberships (like staff, beta testers, promos):

user_id,plan_id,status,start_date
15,100,complimentary,2026-04-14 10:30:00

Complimentary memberships do not require an order.

Linking to Orders

If the membership was granted via a WC purchase, link the order ID:

user_id,plan_id,status,order_id
15,100,active,456

Troubleshooting

Problem	Fix
Entity type not in dropdown	WooCommerce Memberships plugin is not active
"User not found"	Create users first with Users Import
"Plan not found"	Membership plans must be created manually in WC Memberships first
Status does not update	Check status value matches the list exactly
Expiry not working	Use `Y-m-d H:i:s` format for dates

Wizard step 5 — import results summary Results screen confirms memberships granted, existing ones renewed or updated, and any rows skipped because the user or plan could not be found.

Users Import — Create users first
Quick Import Wizard — How to run the import