Hi Steve,

We’re using Piklist for a WooCommerce site and created a new ‘locations’ post-type to represent where a product ships from. We then created a meta-box for the WooCommerce ‘product’ type which allows a user to select from a drop down and assign which physical store the item is located in. From my understanding, this should simply add a new meta key in the postmeta table for this particular post_id. We then created a shortcode which conducts a custom query for items on a per-location level, and outputs products grouped by this meta key (the store location – store_location).

All appears to be working with this when new products are added in, and the queries successfully work. However, my client reported to me that they had at first listed a few products in the wrong location, and went into the wp-admin to update the location. They were able to do this, but the front-end of the site did not update; the product was still listed in the old location. I investigated page caching issues, but even with all page caching disabled the problem persisted across several products. I even looked into our server mem_cache with no avail.

I dug deeper into the database, and manually into the postmeta table to see what the store_location value was for the corresponding post_id. Surprisingly, the store_location value was the stale value that had originally been posted. Subsequent product updates did not modify this value. What is strange, however, is that in the WP admin product page appears to be saving the value as when the page is reloaded, the correct drop-down setting is selected so something is being saved, just not in the right place from what I can tell.

Please advise and thanks in advance.

Here’s my PHP code for the related fields meta-box.

<?php
/*
Title: Ships from Location
Post Type: product
Order: 2
*/

piklist('field', array(
    'type' => 'select'
    ,'field' => 'store_location'
    ,'label' => __('Select which location this item ships from.', 'piklist')
    ,'choices' => piklist(
      get_posts(array(
        'post_type' => 'store_location'
        ,'numberposts' => -1
        ,'orderby' => 'title'
        ,'order' => 'ASC'
      ))
      ,array('ID', 'post_title')
    )
    ,'relate' => array(
      'scope' => 'post'
    )
  ));