Automattic

WooCommerce

<p><strong>WooCommerce Admin is no longer supported</strong></p>
<p>WooCommerce Admin is now part of <a href="https://wordpress.org/plugin/woocommerce">WooCommerce</a>! To make sure your store continues to run smoothly, check that WooCommerce is up-to-date (at least version 6.5) and then disable the WooCommerce Admin plugin.</p>
<p>WooCommerce Admin is a new JavaScript-driven interface for managing your store. The plugin includes new and improved reports and a dashboard to monitor key metrics of your site.</p>
<p><strong>Do I need this plugin?</strong></p>
<p>This is a <a href="https://woocommerce.com/document/what-is-a-woocommerce-feature-plugin/" rel="nofollow ugc">feature plugin</a> for testing the latest features, such as Analytics, for future versions of WooCommerce. A stable version of this plugin is packaged with WooCommerce since version 4.0, so you don’t need to install this plugin for analytics in your WooCommerce store.</p>
<p>Install this plugin if you want to test new features before they are released in WooCommerce. If you have trouble, let us know in the <a href="https://wordpress.org/support/plugin/woocommerce-admin/">Support Forums</a> and participate in its development on the public <a href="https://github.com/woocommerce/woocommerce-admin" rel="nofollow ugc">GitHub repository</a>.</p>
<p><strong>New Reports for WooCommerce</strong></p>
<p>WooCommerce Admin has a host of new reports that are optimized for speed and have advanced filters that allow you to dive into data about your store:</p>
<ul>
<li>Revenue Report</li>
<li>Orders Report</li>
<li>Products Report</li>
<li>Variations Report</li>
<li>Categories Report</li>
<li>Coupons Report</li>
<li>Taxes Report</li>
<li>Downloads Report</li>
<li>Stock Report</li>
<li>Customers Report</li>
</ul>
<p><strong>Customizable Dashboard</strong></p>
<p>WooCommerce Admin also allows store owners to customize a new dashboard screen with “performance indicators” that correspond in importance to their store’s operation.</p>
<h3>Getting Started</h3>
<h4>Minimum Requirements</h4>
<ul>
<li>WordPress 5.4.0</li>
<li>WooCommerce 5.7.0 or greater</li>
<li>PHP version 7.0 or greater. PHP 7.4 or greater is recommended</li>
<li>MySQL 5.6 or greater OR MariaDB version 10.1 or greater.</li>
</ul>
<p>Visit the <a href="https://woocommerce.com/document/server-requirements/" rel="nofollow ugc">WooCommerce server requirements documentation</a> for a detailed list of server requirements.</p>
<h4>Automatic installation</h4>
<p>Automatic installation is the easiest option, as WordPress handles the file transfers and you don’t need to leave your web browser. To perform an automatic install:<br />
1. Log in to your WordPress dashboard.<br />
2. Go to: Plugins > Add New.<br />
3. Enter “WooCommerce Admin” in the Search field, and view details about its point release, the rating and description.<br />
4. Select “Install Now” when you’re ready.</p>
<h4>Manual installation</h4>
<p>The manual installation method involves downloading the plugin and uploading it to your web server via your favorite FTP application. The WordPress Codex contains instructions at <a href="https://codex.wordpress.org/Managing_Plugins#Manual_Plugin_Installation" rel="nofollow ugc">Manual Plugin Installation</a>.</p>
<h4>Where can I report bugs or contribute to the project?</h4>
<p>Bugs should be reported in the <a href="https://github.com/woocommerce/woocommerce-admin/" rel="nofollow ugc">WooCommerce Admin GitHub repository</a>.</p>
<h4>This is awesome! Can I contribute?</h4>
<p>Yes, you can! Join our <a href="https://github.com/woocommerce/woocommerce-admin/" rel="nofollow ugc">GitHub repository</a></p>
<p>Release and roadmap notes are available on the <a href="https://developer.woocommerce.com/blog/" rel="nofollow ugc">WooCommerce Developers Blog</a></p>


WooCommerce Admin

<p>Just place some SQL on in the box and save it as a report. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click. You can place your reports on the User’s Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]</p>
<p>There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site:<br />
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]<br />
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.</p>
<p>If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode.<br />
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.</p>
<h4>Automatic Database Backups</h4>
<p>Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.</p>


EZ SQL Reports Shortcode Widget and DB Backup

Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.

WooCommerce Admin vs EZ SQL Reports Shortcode Widget and DB Backup