Woocommerce Archives - Page 2 of 2

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.