Eduardo Marcolino

This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.
It uses ACF’s <code>acf/update_field_group</code> hook to create/update the database and then uses <code>acf/save_post</code> hook to store the data.
It was heavily inspired by Austin Ginder’s post <a href="https://anchor.host/acf-custom-fields-stored-in-custom-table/" rel="nofollow ugc">https://anchor.host/acf-custom-fields-stored-in-custom-table/</a>.
You can contribute to this plugin by submit PR/Issue in <a href="https://github.com/eduardo-marcolino/acf-fields-in-custom-table" rel="nofollow ugc">https://github.com/eduardo-marcolino/acf-fields-in-custom-table</a>.
<h4>Supported Fields</h4>
<ul>
<li>Text</li>
<li>Text Area</li>
<li>Number</li>
<li>Range</li>
<li>Email</li>
<li>URL</li>
<li>Password</li>
<li>Image</li>
<li>File</li>
<li>Wysiwyg Editor</li>
<li>oEmbed</li>
<li>Select</li>
<li>Checkbox</li>
<li>Radio Button</li>
<li>Button Group</li>
<li>True / False</li>
<li>Date Picker</li>
<li>Date Time Picker</li>
<li>Time Picker</li>
<li>Color Picker</li>
<li>Link</li>
<li>Post Object</li>
<li>Page Link</li>
<li>Relationship</li>
<li>Taxonomy</li>
<li>User</li>
</ul>
<h4>Relational Fields</h4>
This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.
It can store both single and multiple values based on the <code>multiple</code> option.
<ul>
<li>If it’s a single value field, then the column type will be <code>bigint(20) unsigned</code></li>
<li>If it’s a multiple value field, then the column type will be longtext and the date will be stored in json format.</li>
</ul>
You can query relational fields with multiple values using using MySQL’s function <a href="https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-contains" rel="nofollow ugc">JSON_CONTAINS</a>. 
Here is an example:
Table:
<pre><code>+---------+-------------------+--------+
| post_id | title | stores |
+---------+-------------------+--------+
| 1 | Lord of the Flies | [1,2] |
| 2 | The Island | [2] |
| 3 | 1984 | [3] |
+---------+-------------------+--------+
</code></pre>
Query:
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
The query above will return “Lord of the Flies” and “The Island”.
<h4>ACF Compatibility</h4>
This plugin was tested with ACF 5 FREE Version .

ACF: Fields in Custom Table

Stores ACF custom fields in a custom table instead of WordPress core meta tables.

tychesoftwares

<blockquote>
<h3>🚀  New Launch: Flexi BOGO for WooCommerce</h3>
The only BOGO plugin with a revenue tracking feature. Now, at an attractive introductory price. <a href="https://www.tychesoftwares.com/products/woocommerce-flexi-bogo-plugin/?utm_source=wprepo&utm_medium=pluginpagetop&utm_campaign=ProductInputFields" rel="nofollow ugc">Check out our new plugin here</a>.
</blockquote>
<a href="https://www.tychesoftwares.com/store/premium-plugins/product-input-fields-for-woocommerce/?utm_source=wprepo&utm_medium=topprolink&utm_campaign=ProductInputFields" rel="nofollow ugc">Product Input Fields for WooCommerce</a> plugin lets you add custom input fields to WooCommerce product’s frontend for customer to fill before adding product to cart.
Input fields can be added globally (i.e. for all products) or on per product basis.
You can choose numerous different types for fields:
<ul>
<li>Text</li>
<li>Textarea</li>
<li>Number</li>
<li>Checkbox</li>
<li>Color</li>
<li>File</li>
<li>Datepicker</li>
<li>Weekpicker</li>
<li>Timepicker</li>
<li>Select</li>
<li>Radio</li>
<li>Password</li>
<li>Country</li>
<li>Email</li>
<li>Phone</li>
<li>Search</li>
<li>URL</li>
<li>Range</li>
</ul>
Each type comes with specific options you can set for each field.
Additionally you can set fields HTML template and much more.
Plugin is limited to adding two input fields to each product – one (global) field for all products and one more (local) for each product individually. If you wish to add unlimited number of global and/or local product input fields, please check our <a href="https://www.tychesoftwares.com/store/premium-plugins/product-input-fields-for-woocommerce/?utm_source=wprepo&utm_medium=prolink&utm_campaign=ProductInputFields" rel="nofollow ugc">Product Input Fields for WooCommerce Pro</a> plugin.
Some of our Pro plugins:
<ol>
<li>
<a href="https://www.tychesoftwares.com/products/woocommerce-flexi-bogo-plugin/?utm_source=wprepo&utm_medium=pluginpagetop&utm_campaign=ProductInputFields" title="Flexi BOGO for WooCommerce" rel="nofollow ugc">Flexi BOGO for WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/woocommerce-abandoned-cart-pro/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Abandoned Cart Pro for WooCommerce" rel="nofollow ugc">Abandoned Cart Pro for WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/woocommerce-booking-plugin/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Booking & Appointment Plugin for WooCommerce" rel="nofollow ugc">Booking & Appointment Plugin for WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/order-delivery-date-for-woocommerce-pro-21/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Order Delivery Date Pro for WooCommerce" rel="nofollow ugc">Order Delivery Date Pro for WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/product-delivery-date-pro-for-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Product Delivery Date Pro for WooCommerce" rel="nofollow ugc">Product Delivery Date Pro for WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/deposits-for-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Deposits For WooCommerce" rel="nofollow ugc">Deposits For WooCommerce</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/payment-gateway-based-fees-and-discounts-for-woocommerce-plugin/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Payment Gateway Based Fees and Discounts for WooCommerce - Pro" rel="nofollow ugc">Payment Gateway Based Fees and Discounts for WooCommerce – Pro</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/custom-order-status-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Custom Order Status for WooCommerce - Pro" rel="nofollow ugc">Custom Order Status for WooCommerce – Pro</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/custom-order-numbers-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Custom Order Numbers for WooCommerce - Pro" rel="nofollow ugc">Custom Order Numbers for WooCommerce – Pro</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/woocommerce-call-for-price-plugin/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Call for Price for WooCommerce - Pro" rel="nofollow ugc">Call for Price for WooCommerce – Pro</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/price-user-role-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Price based on User Role for WooCommerce - Pro" rel="nofollow ugc">Price based on User Role for WooCommerce – Pro</a>
</li>
<li>
<a href="https://www.tychesoftwares.com/store/premium-plugins/currency-per-product-for-woocommerce/?utm_source=wprepo&utm_medium=link&utm_campaign=ProductInputFields" title="Currency per Product for WooCommerce - Pro" rel="nofollow ugc">Currency per Product for WooCommerce – Pro</a>
</li>
</ol>
Some of our other free plugins:
<ol>
<li>
<a href="https://wordpress.org/plugins/woocommerce-abandoned-cart/" title="Abandoned Cart for WooCommerce" rel="ugc">Abandoned Cart for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/order-delivery-date-for-woocommerce/" title="Order Delivery Date for WooCommerce - Lite" rel="ugc">Order Delivery Date for WooCommerce – Lite</a>
</li>
<li>
<a href="https://wordpress.org/plugins/woocommerce-delivery-notes/" title="Print Invoice & Delivery Notes for WooCommerce" rel="ugc">Print Invoice & Delivery Notes for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/product-delivery-date-for-woocommerce-lite/" title="Product Delivery Date for WooCommerce" rel="ugc">Product Delivery Date for WooCommerce – Lite</a>
</li>
<li>
<a href="https://wordpress.org/plugins/checkout-fees-for-woocommerce/" title="Payment Gateway Based Fees and Discounts for WooCommerce" rel="ugc">Payment Gateway Based Fees and Discounts for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/custom-order-statuses-woocommerce/" title="Custom Order Status for WooCommerce" rel="ugc">Custom Order Status for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/custom-order-numbers-for-woocommerce/" title="Custom Order Numbers for WooCommerce" rel="ugc">Custom Order Numbers for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/woocommerce-call-for-price/" title="Call for Price for WooCommerce" rel="ugc">Call for Price for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/price-by-user-role-for-woocommerce/" title="Price based on User Role for WooCommerce" rel="ugc">Price based on User Role for WooCommerce</a>
</li>
<li>
<a href="https://wordpress.org/plugins/currency-per-product-for-woocommerce/" title="Currency per Product for WooCommerce" rel="ugc">Currency per Product for WooCommerce</a>
</li>
</ol>
<h4>Feedback</h4>
<ul>
<li>We are open to your suggestions and feedback. Thank you for using or trying out one of our plugins!</li>
</ul>
<h3>External Services</h3>
This plugin communicates with our tracking server to send usage data only if the user has explicitly opted in to usage tracking. For detailed information about what is tracked, please refer to our <a href="https://www.tychesoftwares.com/docs/docs/product-input-fields-for-woocommerce/product-input-fields-usage-tracking/" rel="nofollow ugc">usage tracking documentation</a>.

Product Input Fields for WooCommerce


Even though we only use PIF Lite, Tyche Software was very responsive and helpful to my quite technical inquiry about their plugin.


Great support

Add product addons (fields) to WooCommerce products. Personalise with various product options for WooCommerce. Create product forms for WooCommerce.

ACF: Fields in Custom Table vs Product Input Fields for WooCommerce