Black Friday

30% off premium pluginsEnds 2 December

Shop the sale
Simple Wishlists

How can we help?

Search the documentation or ask the AI agent anything about the plugin.

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 or wp swlp recount.
  • Order item meta _swlp_list_id and _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.

Related

Was this article helpful?