Data storage and database tables
Simple WishlistsUpdated
Wishlists are stored in three custom database tables, not in posts or user meta, so they stay fast on large stores. The plugin also keeps a counter on each product, a note on order lines bought from a wishlist and one settings option. To change wishlist data from code, use the developer API functions rather than writing to the tables, so counters and caches stay correct.
The tables
Each table starts with your database prefix, for example wp_swlp_lists.
swlp_lists
One row per wishlist. Main columns: user_id (0 for a guest), guest_hash (a hash of the guest cookie, never the cookie itself), token (the 20-character share token), title, description, privacy (private, shared or public), is_default, type (wishlist, or registry in PRO), event_date, meta (JSON), item_count, position, created_at, updated_at and expires_at (guest lists).
swlp_items
One row per saved item. Main columns: list_id, user_id, product_id (always the parent product), variation_id, attributes (JSON of chosen “any” attributes), quantity, price_added (the price in your store currency when saved), note, priority, purchased_qty, alert_flags, last_alert_at and added_at. Each list can hold a product, variation and set of options only once.
swlp_events
Analytics events: add, remove, cart, purchase, share and view_shared, with the product, list, user, order, quantity, value and date. Old rows are deleted daily after the retention period on the General tab.
Other stored data
- Product meta
_swlp_count: how many lists contain the product. It is updated on every add and remove, and rebuilt by Recount now orwp swlp recount. - Order item meta
_swlp_list_idand_swlp_item_id: the wishlist an order line came from. Hidden from customers and admins. - Option
swlp_options: all settings in one array.
Multilingual stores
Product IDs are stored in the site’s default language and mapped to the visitor’s language when shown, so the tables hold one row per product whatever language it was saved in.
Background tasks
A daily maintenance task removes expired guest lists and old events. PRO alerts, reminders and campaigns also run in the background. The plugin uses Action Scheduler, which comes with WooCommerce, and falls back to WP-Cron if it is not available. The System information card on Wishlists › Tools shows the table sizes and task status.


