Orderby Taxonomy

So if Condition was a meta field ALM would be able to sort on it correct?

I am thinking since the database of 1,600 products already exists, it might be easiest to create a meta field that contains the taxonomy value also (yeah bad data management, but launch is next week and we are about out of time. lol.)

1) thank you very much @dcooney . Not only for the support but for the fantastic plugin. It’s ability to search on multiple taxonomies with different operators and all leveraged via a shortcode is AWESOME! I was blown away by how much I got out-of-the-box with ALM.

2) “What you would have to do is run two separate custom queries and pass an array of Post IDs to the post__in” – So one query to grab all the relevant post and the 2nd to sort them? I have not messed with WP custom queries, but I am comfortable with SQL and Php. I may be confused on what ALM will be doing and what my customer query will being as well as order of operations (my custom query first or ALM first then querying those results)?

@dcooney
That was immensely helpful.

I have the two queries working and building a comma delimited string of relevant post ids. However ALM does not appear to like this. If I just feed post__in the New items (216), it works great. If I add in or just do the Used (1,400), ALM loads nothing..not even the no records found message. 🙁

I should not be hitting the Apache or Php limits as they are both maxed out on script run time to temporarily support a migration (I am talking 512M of memory per script and 60+ minutes of run time).

I did try editing down my list of taxonomies and operators to the bare minimum in the shortcode since some of this had already been achieved by the custom queries, but that did not change the out come of ALM not display anything.

Any ideas?

Shortcode:

echo do_shortcode(‘[ajax_load_more container_type=”div”
post_type=”inventory”
taxonomy=”function:function:condition:status”
taxonomy_terms=”post-press:::sold”
taxonomy_operator=”IN:IN:IN:NOT IN”
order=”ASC”
orderby=”status”
post__in=’.$list_of_ids.’
posts_per_page=”30″
button_label=”Display More Listings”
no_results_text=”<h2>No listings found. </h2> <p>Please return to the previous page.</p>”
]’);

• This reply was modified 3 years, 3 months ago by bobhunter.
• This reply was modified 3 years, 3 months ago by bobhunter.

@dcooney no luck so far getting this to work.

Based on the feedback above and the roughly 1700 ids, am I overloading ALM?

@dcooney

“Way too many” – I am assuming I should send ALM all the possible results for listing (via post ids) that it potentially display so it could further filter and “paginate” for scroll/load. Am I miss understanding this?

Site is likely not crashing because server has incredibly high memory allocation and script run time at the moment to support migration scripts. AKA values that will be turned back to normal apache/php limits post migration.

https://stage.bestgraphics.net/listings/?c=packaging I believe line 252 is what you are looking for.

While we are at it….here are is one of two of the custom queries. The other one just is almost the same but grabs those that are not “new”:

<?php
$args2 = array(
‘post_type’ => ‘inventory’,
‘posts_per_page’ => -1,
‘order’ => ‘ASC’,
‘no_found_rows’ => true,
‘fields’ => ‘ids’,
‘tax_query’ =>
array(
array(
‘taxonomy’ => ‘condition’,
‘field’ => ‘id’, // ‘term_id’,
‘terms’ => array(453), // NEW items
‘operator’=> ‘IN’ // ‘NOT IN’
)
),
);

$query_posts2 = new WP_Query($args2);

if($query_posts2->have_posts()) :
while($query_posts2->have_posts()) : $query_posts2->the_post();
$new_listing_ids[]=get_the_ID();
endwhile;
wp_reset_query();
endif
?>

Thank you!