WebAsyst and Shop-Script forums / edit SKU

cyrus · 2012-05-01 11:12

hi
i have 600 product in store.
when i add this product i dont need to SKU(product code)...and all 600 products havnt SKU!

now i want add sku...but its very difficult to open all 600 product and edit it!
in product list, price and in stock is editable...how we can change sku field and convert it to editable field?

tnx alot dear Rat...

rat · 2012-05-02 03:00

1. In file published/SC/html/scripts/templates/backend/categories_products.html change

Code:

<td><a href="{$product_url}">{$GridRows[i].product_code|escape:'html'}&nbsp;</a></td>

to

Code:

<td><input type="text" name="product_code_{$GridRows[i].productID}" size="10" value="{$GridRows[i].product_code|escape:'html'}" /></td>

2. In file published/SC/html/scripts/modules/test/_methods/b_categories_products.php change

Code:

$data = scanArrayKeysForID($_POST, array( "price", "left", "sort_order" ) );
foreach( $data as $key => $val ){
    $sqlValues = array();

    if ( isset($val["price"]) ){
        $temp = $val["price"];
        $temp = round($temp*100)/100;
        $sqlValues[] = "Price='{$temp}'";
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET Price='$temp' "." WHERE productID=".$key );
    }
    if ( isset($val["left"]) ){
        $sqlValues[] = 'in_stock = \''.intval($val["left"]).'\'';
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET in_stock = '".$val["left"]."' WHERE productID=".$key);
    }
    if ( isset($val["sort_order"]) ){
        $sqlValues[] = 'sort_order = '.$val["sort_order"];
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET sort_order = '".$val["sort_order"]."' WHERE productID=".$key);
    }
    /*if(isset($_POST['categoryID'])){
        $sqlValues[] = 'categoryID =\''.intval($_POST['categoryID']).'\'';
        }*/
    if(count($sqlValues)){
        $sql = 'UPDATE `'.PRODUCTS_TABLE.'` SET '.implode(', ',$sqlValues).' WHERE productID='.$key;
        db_query($sql);
    }
}

to

Code:

$data = scanArrayKeysForID($_POST, array( "price", "left", "sort_order", "product_code" ) );
foreach( $data as $key => $val ){
    $sqlValues = array();

    if ( isset($val["price"]) ){
        $temp = $val["price"];
        $temp = round($temp*100)/100;
        $sqlValues[] = "Price='{$temp}'";
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET Price='$temp' "." WHERE productID=".$key );
    }
    if ( isset($val["left"]) ){
        $sqlValues[] = 'in_stock = \''.intval($val["left"]).'\'';
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET in_stock = '".$val["left"]."' WHERE productID=".$key);
    }
    if ( isset($val["sort_order"]) ){
        $sqlValues[] = 'sort_order = '.$val["sort_order"];
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET sort_order = '".$val["sort_order"]."' WHERE productID=".$key);
    }
    if ( isset($val["product_code"]) ){
        $sqlValues[] = 'product_code = "'.$val["product_code"].'"';        
    }
    /*if(isset($_POST['categoryID'])){
        $sqlValues[] = 'categoryID =\''.intval($_POST['categoryID']).'\'';
        }*/
    if(count($sqlValues)){
        $sql = 'UPDATE `'.PRODUCTS_TABLE.'` SET '.implode(', ',$sqlValues).' WHERE productID='.$key;
        db_query($sql);
    }
}

cyrus · 2012-05-02 07:02

tnx Rat...You are wonderful

Я люблю тебя

cyrus · 2012-05-06 15:21

now i add ProductID...but sorting with ProductID dont work!!!
i think...all product sort with name.

how we can do this?

rat · 2012-05-07 03:51

How do you add productID?

cyrus · 2012-05-07 12:52

Code:

$data = scanArrayKeysForID($_POST, array( "price", "left", "sort_order", "product_code", "productID" ) );
foreach( $data as $key => $val ){
    $sqlValues = array();

    if ( isset($val["price"]) ){
        $temp = $val["price"];
        $temp = round($temp*100)/100;
        $sqlValues[] = "Price='{$temp}'";
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET Price='$temp' "." WHERE productID=".$key );
    }
    if ( isset($val["left"]) ){
        $sqlValues[] = 'in_stock = \''.intval($val["left"]).'\'';
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET in_stock = '".$val["left"]."' WHERE productID=".$key);
    }
    if ( isset($val["sort_order"]) ){
        $sqlValues[] = 'sort_order = '.$val["sort_order"];
        //db_query( "UPDATE ".PRODUCTS_TABLE." SET sort_order = '".$val["sort_order"]."' WHERE productID=".$key);
    }
    if ( isset($val["productID"]) ){
        $sqlValues[] = 'productID = "'.$val["productID"].'"';        
    }
    if ( isset($val["product_code"]) ){
        $sqlValues[] = 'product_code = "'.$val["product_code"].'"';        
    }
    /*if(isset($_POST['categoryID'])){
        $sqlValues[] = 'categoryID =\''.intval($_POST['categoryID']).'\'';
        }*/
    if(count($sqlValues)){
        $sql = 'UPDATE `'.PRODUCTS_TABLE.'` SET '.implode(', ',$sqlValues).' WHERE productID='.$key;
        db_query($sql);
    }
}

and add this to template files:

Code:

<td><a href="{$product_url}">{$GridRows[i].productID|escape:'html'}&nbsp;</a></td>

Last edited by cyrus (2012-05-07 12:52)

rat · 2012-05-10 01:50

It is not productID but product code (or SKU). What exactly are you doing at what happens?

cyrus · 2012-05-10 06:19

i want sort product by ProductID(or sort by Add Date) and after add Sku(productID+145=Product Code)

i need to add product code for all product...if product sort by ID or add date i can edit easely add SKU.

cyrus · 2012-05-14 17:16

dear rat its possible?

rat · 2012-05-15 02:03

Your question is not clear to me, I'm afraid. Will you try to re-phrase it?

cyrus · 2012-05-15 02:23

i want sort product by productID.

rat · 2012-05-15 03:48

In file published/SC/html/scripts/modules/test/_methods/b_categories_products.php change

Code:

$callBackParam['sort'] = 'name';

to

Code:

$callBackParam['sort'] = 'productID';

In file published/SC/html/scripts/core_functions/product_functions.php change

Code:

if(isset($callBackParam['sort'])&&in_array($callBackParam['sort'],array('name','brief_description','in_stock','Price','customer_votes','customers_rating','list_price','sort_order','items_sold','product_code','shipping_freight'))){

to

Code:

if(isset($callBackParam['sort'])&&in_array($callBackParam['sort'],array('name','brief_description','in_stock','Price','customer_votes','customers_rating','list_price','sort_order','items_sold','product_code','shipping_freight', 'productID'))){

cyrus · 2012-05-15 16:30

tnx dear Rat:cool:

#1 2012-05-01 11:12

edit SKU

#2 2012-05-02 03:00

Re: edit SKU

Code:

Code:

Code:

Code:

#3 2012-05-02 07:02

Re: edit SKU

#4 2012-05-06 15:21

Re: edit SKU

#5 2012-05-07 03:51

Re: edit SKU

#6 2012-05-07 12:52

Re: edit SKU

Code:

Code:

#7 2012-05-10 01:50

Re: edit SKU

#8 2012-05-10 06:19

Re: edit SKU

#9 2012-05-14 17:16

Re: edit SKU

#10 2012-05-15 02:03

Re: edit SKU

#11 2012-05-15 02:23

Re: edit SKU

#12 2012-05-15 03:48

Re: edit SKU

Code:

Code:

Code:

Code:

#13 2012-05-15 16:30

Re: edit SKU

Board footer