PXCommerce

When setting multiple values for one attribute, the values need to be separated by commas for the built-in CSV importer.

Try replacing the USA|United Kingdom|Singapore with “USA, United Kingdom, Singapore” in your CSV.

• This reply was modified 8 years, 9 months ago by PXCommerce.

I found the cause of my issue – although not 100% sure why it was interfering.

I had this snippet in a custom theme functions.php:

  // STORE : Hide Sub-category Products on Category Page
    
        add_filter('pre_get_posts', 'exclude_product_cat_children');

        function exclude_product_cat_children($wp_query) {
        if ( isset ( $wp_query->query_vars['product_cat'] ) && $wp_query->is_main_query()) {
            $wp_query->set('tax_query', array(
                                            array (
                                                'taxonomy' => 'product_cat',
                                                'field' => 'slug',
                                                'terms' => $wp_query->query_vars['product_cat'],
                                                'include_children' => false
                                            )
                                         )
            );
          }
        } 

It prevented child products from displaying in their parent categories.

Hi,
I’m having the same issue with my site and I can fool it by changing the query.

Maybe I have too many taxonomies too? How can I check?
Thanks,
George