Hello @guglielmirent
Thank you very much for using our plugin. Where is stored the order number, and how to obtain it? For example, if the item number is stored in a database, how to identify an order number from the other?
Best regards.
I don’t understand your answer
Honestly, woocommerce orders will definitely be saved in the database, the url is composed for order #356
my-account/view-order/356/
I don’t know where it saves them
Hello @guglielmirent
Our plugin takes information from data sources (a database, CSV file, JSON structure, posts, taxonomies, URL parameters, ACF, server-side blocks of code, and javascript functions) to fill out the form fields.
If you want to fill in the dropdown field in the form with the orders a field in the form with order ids, our plugin must get them from someplace, like a database.
For example, assuming you want to fill the ordinicliente dropdown field in the form with the ids of WooCommerce orders. They are stored as the custom post types shop_order in the wp_posts table of the website.
In this case, you must insert a recordset field in the form to read the information from the database, and a link field to fill the dropdown list:
[cf7-recordset id="orders" type="database" query="SELECT ID FROM {wpdb.posts} WHERE post_type="shop_order""]
[cf7-link-field recordset="orders" field="ordinicliente" value="ID" text="ID" keep-options]Best regards.