• coopero

• in reply to: Convert plain text to Importable Post Object
• June 29, 2021 at 11:09 pm

Ahh, I see – so it will take an array and serialize it when it gets imported? That makes more sense…

So it should be like:

Array
(
[0] => 9801
[1] => 10371
)

or this?

array(9801,10371)

• coopero

• in reply to: Convert plain text to Importable Post Object
• June 29, 2021 at 8:21 pm

I think I’m still missing a piece of the puzzle. Perhaps I’m missing something obvious.

In the spreadsheet is 14,000 records with JSON such as [“5667″,”93872”] for my custom field. I was planning on using a plugin to import this spreadsheet and create the new users. Do I need to format the sheet further before importing or is that code you provided to fix it after it’s imported?

Thanks for your help 🙂

• coopero

• in reply to: Convert plain text to Importable Post Object
• June 28, 2021 at 10:49 pm

Ahh, that makes sense – not sure how I missed that looking at it now. I’ve managed to convert my data to JSON in the spreadsheet with simple regex replace – do you know if ACF will take that or do I need to further convert the JSON to serialized?

• coopero

• in reply to: Custom field to change Cart Price
• September 18, 2020 at 8:29 pm

My end goal is to be able to use a custom price for specified customers. I’ve figured that part out and the alter_price function is working. the hard part, making that translate into the cart is where I’m struggling – it seems to be a different ball game.

function alter_price( $price ) {
    
    $customer = get_field('customer',$product->id);
    $special_customer_ids = [$customer];
 
   if ( in_array( get_current_user_id(), $special_customer_ids, true ) && (get_field('special_price',$product->id))) {
      $price = get_field('special_price');
      return $price;
   } else {
    return $price;
   }
}

add_filter( 'woocommerce_product_get_price', 'alter_price', 10, 1 );

add_action( 'woocommerce_before_calculate_totals', 'add_custom_price', 20, 1);

function add_custom_price( $cart_obj ) {

    // This is necessary for WC 3.0+
    if ( is_admin() && ! defined( 'DOING_AJAX' ) )
        return;

    // Avoiding hook repetition (when using price calculations for example)
    if ( did_action( 'woocommerce_before_calculate_totals' ) >= 2 )
        return;

    // Loop through cart items
    foreach ( $cart_obj->get_cart() as $cart_item ) {
        $customer = get_field('customer',$product->id);
        $special_customer_ids = [$customer];
 
        if ( in_array( get_current_user_id(), $special_customer_ids, true ) && (get_field('special_price',$product->id))) {
            $newprice = get_field('special_price');
            $cart_item['data']->set_price( $newprice );
        }
    }
}

I have been looking all over the place and been through several alterations of add_custom_price. I think I should probably be using the_field and a product ID. Any help is appreciated.

• coopero

• in reply to: Filter Posts by Custom Fields
• September 4, 2020 at 11:13 pm

Amazing! Thank you so much. Just missing a comma on the end of ‘meta_value’.

Thanks again