Fast Woo Order Lookup vs Views for WPForms – Display & Edit WPForms Entries on your site frontend

WooCommerce’s Order and Subscription pages allow store owners to search for orders and subscriptions by customer name, email, and other attributes. By default, it does a general substring search. For example, if you put OllieJones into the search box, it will search with LIKE '%OllieJones%' using the leading wildcard %. That’s astonishingly slow on sites with many orders. Upon activation this plugin uses ActionScheduler to run a background process to create a special-purpose index table, a table of trigrams, to speed up that search. Then it uses those trigrams to search for orders. The downside: the trigram table takes database space and takes time to generate. The orders page itself contains a slow query to look up meta_keys. This fixes that query’s performance too, using a cache of available values. If you have problems The WordPress and WooCommerce ecosystems offer many optional features enabled by plugins. And, WooCommerce sites run on many different versions of database server. It is not possible to test this plugin on every imaginable combination. So, you may have problems getting it to work. Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created. If you tell the author about these problems, he will attempt to fix them. Please create a support topic, then visit Site Health, view the Info tab, click the Copy Site Info to Clipboard button, and paste that information into the support topic. And, of course, please describe what is going wrong. Credits Thanks to Leho Kraav for bringing this problem to my attention. Thanks to Sebastian Sommer and Maxime Michaud for using early versions of the plugin on large stores, and to Maxime Michaud for creating the transation into French. Thanks to Jetbrains for the use of their software development tools, especially PhpStorm. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s. How can I learn more about making my WordPress site more efficient? We offer several plugins to help with your site’s database efficiency. You can read about them here.

If you’re using the WPForms plugin to create forms on your WordPress site, then we have some great news for you. With the Views for WPForms plugin, you can now display and edit form entries on the front end of your site. That’s right, no more logging into the backend to manage your form entries. With our drag & drop view builder, you can easily create table or list views of entries, allow users to edit entries and approve or disapprove entries from the frontend of your site. Our plugin is also compatible with all WPForms Forms Add-Ons, so you can add even more features and functionality to your forms. NOTE: YOU NEED AT LEAST WPFORMS BASIC LICENSE TO USE VIEWS FOR WPFORMS AS WPFORMS LITE VERSION DOESN’T STORE ENTRIES Here is step by step guide to display WPForms Entries anywhere on your site Views for WPForms lets you display WPForms Entries in your site frontend using drag & drop View builder. You can create a table view, list view, or datatable (Pro feature). The plugin also allows you to add custom content before and after each View, and control the number of entries displayed per page. Demo Table View List View DataTable View Edit Entry Demo Top Free Features Intuitive user interface! Easy to use – drag and drop view builder! Set any number of form fields to show in View. Set custom labels for table headings. Set table column width. Set total number of entries to show on the page. Add pagination links before or after the table. Display Pagination Information. Display using Shortcode on any page, post or custom post type. Compatible with Elementor. Add Views to any page using Elementor Widgets. Compatible with the new Gutenberg block editor. Add View to your page using the WPForms Views block. Fully supported and regular updates. Get more features in Pro version * List View Format * DataTable View Format * Edit Entries from frontend * 25+ Premade Themes and Styler * Delete Entries from frontend * Display only approved Entries * Display only User submitted Entries * Add Search Form above or at View bottom to filter/search entries by field values * Display Entry details on Single Page * Add Custom HTML field & use WPForms Smart Tags inside View * Filter entries by field values or use Merge Tags * Sort WPForms Entries via field values * Display Only starred entries * Display Only viewed entries Get WPForms Views PRO! Pro Features = List & DataTable View Format = Display WPForms Entries in a multicolumn layout on your site frontend. Want more features than a regular table? We have you covered. Display data using dataTables including features like responsive layout, print, pdf, CSV download entries options. Edit WPForms Entries Allow logged-in users to edit their entries from the site frontend using the same form that they used to create an entry. Edit Entry works by prefilling Form fields with entry data. After the user submits Form entry is updated. Administrators can edit all entries. Send a custom notification/email when entry is edited from frontend Inline Edit WPForms Entries Inline Edit Entries without page refresh. The user will never leave the page & can update one field at a time. Best for quick updating of fields displayed in a View. Delete WPForms Entries Allow users to delete their submitted entries from the site frontend. Logged-in users can delete their entries and administrators can delete any entry. Premade themes & Custom Designs Apply premade Table and List View themes with single click. Select from 25+ premade design templates or create your own custom designs without any css Knowledge. Search WPForms Entries Display Search Form in your View to allow users to filter view data by any field value. Options also include searching by Entry Submission Date or Date Range e.g. Display entries submitted between two dates. Advanced Filters Set Filters to Filter Entries before displaying on the site frontend by using any Form field value, logged-in user meta, custom dates, etc. E.g. Display all entries where the user selected Male as Gender field value while submitting the form. Advance Sorting Sort by any Field value in Ascending or Descending order. Allows you to add multiple sort conditions. Entries Approval Display only those entries that are approved by admin from the backend. Approve or Unapprove Entries from site frontend. Calculations Display calculations like sum or average of field values in the table footer. Display Conditions Show field in view only if set conditions are matched. Duplicate Entries Duplicate Entries from your view. Customize Field Value Add any content before or field value inside view using Field Value Template. Google Maps Add-on Display data on Google Maps above or at bottom of View. Custom HTML Add custom HTML within View data. Support WPForms Smart Tags so you can display data by combining multiple field values. WPForms User Registration Addon Integration Works perfectly with User Registration Addon. Register new users on site, display their profile data on the frontend using WPForms Views & then allow them to update it using the Inline Edit addon. WPForms Post Submissions Addon Integration Update associated posts whenever you update entries from WPForms Views. Allow users to update their posts from the site frontend. WPForms Save and Resume Show or hide partial entries within View. Display the Entry Resume link to allow the user to complete partial WPForms entries. WPForms Geolocation Add-on Show Google Maps on the page where you have added View. Create a custom infobox with the data from the WPForms fields. Other WPForms Add-ons = WPForms Import Entries = Import Entries to WPForms CSV file WPForms Charts Display data from your WPForms entries in beautiful charts