WordPress.org
Get WordPress

Plugin Directory

Changeset 1379927


Ignore:
Timestamp:
03/27/2016 06:34:01 PM (10 years ago)
Author:
firdousi
Message:

added search filter to exclude spaces from SKU

File:
1 edited

Legend:

Unmodified
Added
Removed

  • woo-search-on-product-sku/trunk/index.php

    r1316612 r1379927  
    1111    function wsops_get_product_by_sku( $sku ) {
    1212      global $wpdb;
    13       $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku ) );
     13      $un_spaced_sku = str_replace(' ', '', $sku);
     14      $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND (meta_value='%s'  OR meta_value='%s') LIMIT 1", $sku , $un_spaced_sku ) );
    1415
    1516      if ( $product_id ) {
Note: See TracChangeset for help on using the changeset viewer.