Woocommerce Archives - Page 2 of 2

Add Custom Value to Woocommerce Order

Woocommerce documentation, while thorough, can be hard to follow sometimes. Here are some functions I found somewhere on the Woocommerce site (which I can never find) that allows adding some custom values to the checkout order form and then attaching that value to the order.

/**
 * Add the field to the checkout
 */

add_action( 'woocommerce_after_order_notes', 'my_custom_checkout_field' );
 
function my_custom_checkout_field( $checkout ) {
 
    echo '<div id="my_custom_checkout_field"><h2>' . __('Gift Card') . '</h2>';
 
    woocommerce_form_field( 'my_field_name', array(
        'type'          => 'text',
        'class'         => array('my-field-class form-row-wide'),
        'label'         => __('Have a gift card?'),
        'placeholder'   => __(''),
        ), $checkout->get_value( 'giftcard' ));
 
    echo '</div>';
 
}

/**
 * Validate Gift Card
 */
add_action('woocommerce_checkout_process', 'my_custom_checkout_field_process');
 
function my_custom_checkout_field_process() {
    // Check if set, if its not set add an error.
    if ( ! $_POST['my_field_name'] )
        wc_add_notice( __( 'Please enter something into this new shiny field.' ), 'error' );
}

/**
 * Update the order meta with field value
 */
add_action( 'woocommerce_checkout_update_order_meta', 'my_update_order_meta' );
 
function my_update_order_meta( $order_id ) {
    if ( ! empty( $_POST['giftcard'] ) ) {
        //woocommerce solution
        //update_post_meta( $order_id, 'gift_card', sanitize_text_field( $_POST['giftcard'] ) );
        
        //while these 2 statements probably do much the same thing I like to use the ACF fields to track meta data 
        update_field('gift_card', $_POST['giftcard'], $order_id);
    }
}

/**

* Add the field to the checkout

add_action( 'woocommerce_after_order_notes', 'my_custom_checkout_field' );

function my_custom_checkout_field( $checkout ) {

echo '<div id="my_custom_checkout_field"><h2>' . __('Gift Card') . '</h2>';

woocommerce_form_field( 'my_field_name', array(

'type' => 'text',

'class' => array('my-field-class form-row-wide'),

'label' => __('Have a gift card?'),

'placeholder' => __(''),

), $checkout->get_value( 'giftcard' ));

echo '</div>';

}

/**

* Validate Gift Card

add_action('woocommerce_checkout_process', 'my_custom_checkout_field_process');

function my_custom_checkout_field_process() {

// Check if set, if its not set add an error.

if ( ! $_POST['my_field_name'] )

wc_add_notice( __( 'Please enter something into this new shiny field.' ), 'error' );

}

/**

* Update the order meta with field value

add_action( 'woocommerce_checkout_update_order_meta', 'my_update_order_meta' );

function my_update_order_meta( $order_id ) {

if ( ! empty( $_POST['giftcard'] ) ) {

//woocommerce solution

//update_post_meta( $order_id, 'gift_card', sanitize_text_field( $_POST['giftcard'] ) );

//while these 2 statements probably do much the same thing I like to use the ACF fields to track meta data

update_field('gift_card', $_POST['giftcard'], $order_id);

}

Set Woocommerce State

Most clients want to limit the number of states they sell to…but for reasons beyond comprehension Woocommerce does not make this easy.

Here is some code to exclude a few state.

add_filter( 'woocommerce_states', 'custom_woocommerce_states' );
 
function custom_woocommerce_states( $states ) {
	$excluded_states = array('AA','AE','AP','AS','GU','MP','PR','UM','VI');
	foreach($excluded_states as $no_state){
		unset($states['US'][$no_state]);
	}
	 
	return $states;
}

add_filter( 'woocommerce_states', 'custom_woocommerce_states' );

function custom_woocommerce_states( $states ) {

$excluded_states = array('AA','AE','AP','AS','GU','MP','PR','UM','VI');

foreach($excluded_states as $no_state){

unset($states['US'][$no_state]);

}

return $states;

}

You could also set the $states[‘US’] array to just the states you want if that would be easier.

Add Item to WooCommerce From Outside Shop

Sometimes I need to setup donations or memberships or some other item that needs to be added to a users cart but NOT be listed in the shop. First thing we should do is make sure to hide these items in the shop. For this to work you will need to set your Product Category. It can be anything you want of course. Then place this code in your functions.php file

//remove item from the shop page AND do custom sorting based on selected category
if ( is_shop() ) {
 
	$q->set( 'tax_query', array(array(
		'taxonomy' => 'product_cat',
		'field' => 'slug',
		'terms' => array( 'ticket', 'donation', 'person', 'no-sale', 'wagon', 'membership' ), // Don't display products in these categories on the shop page
        	'operator' => 'NOT IN'
	)));
}

//remove item from the shop page AND do custom sorting based on selected category

if ( is_shop() ) {

$q->set( 'tax_query', array(array(

'taxonomy' => 'product_cat',

'field' => 'slug',

'terms' => array( 'ticket', 'donation', 'person', 'no-sale', 'wagon', 'membership' ), // Don't display products in these categories on the shop page

'operator' => 'NOT IN'

)));

}

Now that these items are hidden on the shop page (you may also find you need to hide them on other pages depending on your setup but just add those pages to the “if” check. Next we need to setup the code to add this to the cart.

//?membership=1234 this is the product ID of the membership
if(! empty($_GET['membership'])){

	global $woocommerce;

        //these next two lines determine the category ID of the membership.
	$term_list = wp_get_post_terms($_GET['membership'],'product_cat',array('fields'=>'ids'));
	$member_cat_id = $term_list[0];
		
	//check for existing memberships. Only 1 membership at a time.
	foreach ( WC()->cart->get_cart() as $cart_item_key => $cart_item ) {
		//what terms does this cart item have?
		$term_list = wp_get_post_terms($cart_item['data']->id,'product_cat',array('fields'=>'ids'));
                //since a membership will only have one term, membership, just check the first term. Does this term match the member term?
		if($term_list[0] == $member_cat_id) {
			//remove this membership from the cart so another can be added.
			WC()->cart->set_quantity( $cart_item_key, $quantity = 0);
		}
	}
        
        //add membership to cart
	$success = $woocommerce->cart->add_to_cart($_GET['membership'], 1);

	if($success){
		header('Location: http://'.$_SERVER['HTTP_HOST'].'/cart/');
		exit();
	}
}

//?membership=1234 this is the product ID of the membership

if(! empty($_GET['membership'])){

global $woocommerce;

//these next two lines determine the category ID of the membership.

$term_list = wp_get_post_terms($_GET['membership'],'product_cat',array('fields'=>'ids'));

$member_cat_id = $term_list[0];

//check for existing memberships. Only 1 membership at a time.

foreach ( WC()->cart->get_cart() as $cart_item_key => $cart_item ) {

//what terms does this cart item have?

$term_list = wp_get_post_terms($cart_item['data']->id,'product_cat',array('fields'=>'ids'));

//since a membership will only have one term, membership, just check the first term. Does this term match the member term?

if($term_list[0] == $member_cat_id) {

//remove this membership from the cart so another can be added.

WC()->cart->set_quantity( $cart_item_key, $quantity = 0);

}

//add membership to cart

$success = $woocommerce->cart->add_to_cart($_GET['membership'], 1);

if($success){

header('Location: http://'.$_SERVER['HTTP_HOST'].'/cart/');

exit();

}

Here is the basic code to add this to the cart. I have also setup a check to make sure no other items of the same category are in the cart, and if they are remove them and add this one. Then, if successful, direct the user to the cart page.

Get Product by SKU

Sometimes you need to find the page id of your product simply using the sku. I ran into this when I had to build a backend inventory manager which updated Receiving and Sales figures based off of some spreadsheets.

Stolen from: http://www.skyverge.com/blog/find-product-sku-woocommerce/

function get_product_id_by_sku( $sku ) {

	global $wpdb;
	
	$product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='mp_sku' AND meta_value LIKE '%s' LIMIT 1", '%:"'.$sku.'"%' ) );
	
 	if ( $product_id ) return $product_id;//new WC_Product( $product_id );
	
 	return null;

}

function get_product_id_by_sku( $sku ) {

global $wpdb;

$product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='mp_sku' AND meta_value LIKE '%s' LIMIT 1", '%:"'.$sku.'"%' ) );

if ( $product_id ) return $product_id;//new WC_Product( $product_id );

return null;

}

NOTE: The site I was working with was actually a Marketpress site and not a Woocommerce site. I ended up modifying the code from skyverge a little bit to fit my needs. Same idea.