Search By Product Code Query

Store Builder Questions
1

We want to add a list of products in bulk using there product id for a promotion but the search tab does only allows 1 product id at a time. http://prntscr.com/cx2ioi

Cant we make the query for the same to use " in ( values ) " rather than " = value "

2

We want to add a list of products in bulk using there product id for a promotion but the search tab does only allows 1 product id at a time. http://prntscr.com/cx2ioi

Cant we make the query for the same to use " in ( values ) " rather than " = value "

Do you mean that you want to define product codes comma separated?

3

Yes we want to add a list of product codes by comma separation to get results in one shot

4

What CS-Cart version do you use?

5

4.2.4 MVE

6

4.2.4 MVE

app/functions/fn.catalog.php

Replace:

        $pcode = trim($params['pcode']);
        $fields['combination'] = 'inventory.combination';
        $u_condition .= db_quote(" $union_condition (inventory.product_code LIKE ?l OR products.product_code LIKE ?l)", "%$pcode%", "%$pcode%");
        $inventory_condition .= db_quote(" AND inventory.product_code LIKE ?l", "%$pcode%");

with:

        $_pcode = explode(',', trim($params['pcode']));
        $_inventory_condition = array();
        foreach ($_pcode as $pcode) {
            $fields['combination'] = 'inventory.combination';
            $u_condition .= db_quote(" $union_condition (inventory.product_code LIKE ?l OR products.product_code LIKE ?l)", "%$pcode%", "%$pcode%");
            $_inventory_condition[] = db_quote(" inventory.product_code LIKE ?l", "%$pcode%");
        }
        $inventory_condition .= db_quote(" AND (" . implode(' OR ', $_inventory_condition) . ")", "%$pcode%");
7

It didnot work

8

We are trying to add the products from the promotions > New Promotion > Condition > Products In

http://prntscr.com/cyljf7

9

It didnot work

It works on my local installation. PM me temporary FTP access and we will check it

10

It says you cant accept any more msgs.

11

Your PM is also full. We have found that the search by SKU field is used for search by custom product attribute, which is called ff_sku.

Please let me know what field in the database do you want to use - ff_sku or product_code?
12

Please use product_code.

13

Please use product_code.

In this case it will be required to rework 3rd party module. Please contact us for the quote

14

And if its ff_SKU then ?

15

And if its ff_SKU then ?

We have already found where the code is located and can change it for you free of charge

16

Sure please let us know the change.

17

Sure please let us know the change.

Please clear your PM and PM me what variant is more suitable for you

18

Please clear your PM and PM me what variant is more suitable for you

Sent