admin filter custom field woocommerce
-
Hi, I ve woocommerce, I created an extra attribute for products but I cannot search for this new field in the admin product tab. I tried some scripts without luck.. my queries right now (in the backoffice) are this:
string(251) “SELECT Y34Wa_posts.* FROM Y34Wa_posts WHERE 1=1 AND Y34Wa_posts.post_type = ‘acf-field-group’ AND ((Y34Wa_posts.post_status = ‘publish’ OR Y34Wa_posts.post_status = ‘acf-disabled’)) ORDER BY Y34Wa_posts.menu_order ASC, Y34Wa_posts.post_title ASC ”
SELECT Y34Wa_posts.* FROM Y34Wa_posts WHERE 1=1 AND Y34Wa_posts.post_type = ‘acf-field-group’ AND ((Y34Wa_posts.post_status = ‘publish’ OR Y34Wa_posts.post_status = ‘acf-disabled’)) ORDER BY Y34Wa_posts.menu_order ASC, Y34Wa_posts.post_title ASC ” string(246) “SELECT Y34Wa_posts.* FROM Y34Wa_posts WHERE 1=1 AND Y34Wa_posts.post_parent = 4954 AND Y34Wa_posts.post_type = ‘acf-field’ AND ((Y34Wa_posts.post_status = ‘publish’ OR Y34Wa_posts.post_status = ‘trash’)) ORDER BY Y34Wa_posts.menu_order ASC ”
string(424) “SELECT SQL_CALC_FOUND_ROWS Y34Wa_posts.* FROM Y34Wa_posts WHERE 1=1 AND Y34Wa_posts.ID IN (0,0) AND Y34Wa_posts.post_type = ‘product’ AND (Y34Wa_posts.post_status = ‘publish’ OR Y34Wa_posts.post_status = ‘acf-disabled’ OR Y34Wa_posts.post_status = ‘future’ OR Y34Wa_posts.post_status = ‘draft’ OR Y34Wa_posts.post_status = ‘pending’ OR Y34Wa_posts.post_status = ‘private’) ORDER BY Y34Wa_posts.post_date DESC LIMIT 0, 20
The first 2 returns the correct result but the last one NO. Is cause the Y34Wa_posts.ID IN (0,0) but I dont know why this is there… some idea how to resolve that? I tried acf better search without luck too…
Thanks a lot
- The topic ‘admin filter custom field woocommerce’ is closed to new replies.