I'm currently doing a registering service for products with WordPress and WooCommerce.
All products that customers can register will be in the WooCommerce database, but not visible on frontend.
Here is my goal: make a form with a dropdown list (items inside it will be all my WooCommerce products), where user can pick his product. He will then write when he bought his product, name, address, etc.
The path will be : get all information I want from product the database of WooCommerce before using it later -> get personal info written inside form on frontend -> write all that data inside a table in MySQL.
I tried with
wc_get_products(); but I do not know how to get specific information (name, URL of photo, SKU, and some specific information like warranty period), it returns some weird array.
I already mapped my table for MySQL. I just need to know how to get info and write to it.
Any help is welcome.