Sort non translated products and change status to draft

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Our next available supporter will start replying to tickets in about 8.14 hours from now. Thank you for your understanding.

This topic contains 1 reply, has 2 voices.

Assisted by: Andreas.

Author	Posts
September 23, 2022 at 9:05 am #12109399
christoforosA	Tell us what you are trying to do? I am tying to sort my non translated products and set their status to draft. Is there any documentation that you are following? You suggested: An alternative is to create a custom SQL query which checks wp_posts and wp_icl_transations_status and change the post status from "published" to "draft" What is the link to your site? hidden link I checked the database but I cannot figure out the link between the two tables. Is there a unique identifier to use? I really did not figure the sql query to sort the non translated products. Can you help me? Could you send me the sql query to use?
September 23, 2022 at 10:52 am #12110133
Andreas	Hello there Thank you for contacting us. I am happy to help you. You can use our WCML Rest API in combination with the WooCommerce and achieve what you are asking. https://wpml.org/documentation/related-projects/woocommerce-multilingual/using-wordpress-rest-api-woocommerce-multilingual/ https://woocommerce.com/document/woocommerce-rest-api/ Please give it a try and you can achieve what you need with a few lines of code. I hope this helps. Please let us know how it goes or if you need any further assistance. I'll gladly help you. 🙂 Regards, Andreas

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.