Ask Your Question
4

How can I obtain woocommerce products through SQL that are visible to the front-end (not private or password-protected, and can be displayed in the search or catalog)?

asked 2023-03-23 11:00:00 +0000

qstack gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2022-01-20 05:00:00 +0000

lakamha gravatar image

You can obtain woocommerce products through SQL that are visible to the front-end (not private or password-protected, and can be displayed in the search or catalog) by using the following SQL query:

SELECT * FROM wp_posts

WHERE posttype = 'product' AND poststatus = 'publish'

AND (postpassword = '' OR postpassword IS NULL)

AND (postexcerpt != '' OR postcontent != '');

This query will fetch all the published products that are not password-protected and have either an excerpt or content. You can modify the query as per your requirement.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-03-23 11:00:00 +0000

Seen: 9 times

Last updated: Jan 20 '22