Additional Sku

Store Builder Questions
1

Hello,

Is there any way to add additional SKU code in backend?

1st SKU code for customers in visible just in front end

2nd SKU code for admin visible just for admin

Thanks

2

Hello,

Is there any way to add additional SKU code in backend?

1st SKU code for customers in visible just in front end

2nd SKU code for admin visible just for admin

Thanks

Yes, you will need to add the column in the products table and the field in this file: design/backend/templates/views/products/update.tpl

3

Yes, you will need to add the column in the products table and the field in this file: design/backend/templates/views/products/update.tpl

Thanks, is there any manual how to do it?

4

Thanks, is there any manual how to do it?

1. Run this query in phpMyAdmin:

ALTER TABLE cscart_products ADD sku2 VARCHAR(64)  NOT NULL DEFAULT '';

2. Add this code in design/backend/templates/views/products/update.tpl:


    {__("sku2")}:

after this:


    {__("sku")}:

3. Add the language variable for "sku2".

5

1. Run this query in phpMyAdmin:

ALTER TABLE cscart_products ADD sku2 VARCHAR(64)  NOT NULL DEFAULT '';

2. Add this code in design/backend/templates/views/products/update.tpl:


    {__("sku2")}:

after this:


    {__("sku")}:

3. Add the language variable for "sku2".

Thanks Oleg.

Perfect.

6

Thanks Oleg.

Perfect.

You are welcome! :)

7

Sorry to use this topic, but can I add a second customer ID, visible only in admin?

I need this ID to use same ID code used in ERP and I will fill it manually.

Thanks in advance

Frank

8

Sorry to use this topic, but can I add a second customer ID, visible only in admin?

I need this ID to use same ID code used in ERP and I will fill it manually.

Thanks in advance

Frank

Hello, Frank!

1. Run this query in phpMyAdmin:

ALTER TABLE cscart_users ADD erp_user_id mediumint(8) unsigned NOT NULL DEFAULT '0';

2. Add this code in design/backend/templates/views/profiles/update.tpl:


    {__("erp_user_id")}

before (or after) this

{include file="views/profiles/components/profiles_account.tpl"}

3. Add the language variable for "erp_user_id".

9

Dear Oleg,

thank you so much.

Frank

10

Dear Oleg,

thank you so much.

Frank

You are welcome, Frank!

11

Hi Oleg,

I have try your solution, but the additional field appears out of form.

Please see attachment.

Can you help me?

Thank you

Frank

12

Ok ... solved, thank you anyway ...

Frank

13

You are welcome! :)

I'm sorry to disturb You second time, but could you please tell me how to make display second SKU under the first SKU in backend.

Sample here: http://nimb.ws/VcB1vT

And thank's again.

14

I'm sorry to disturb You second time, but could you please tell me how to make display second SKU under the first SKU in backend.

Sample here: http://nimb.ws/VcB1vT

And thank's again.

1. Add this code in design/backend/templates/views/products/manage.tpl:


    {__("sku2")}

after this:


    {__("sku")}

2. In app/functions/fn.catalog.php replace this code (~6049 row, fn_get_products function):

$fields = array(
    'product_id' => 'products.product_id',
);

with this:

$fields = array(
    'product_id' => 'products.product_id',
    'sku2' => 'products.sku2'
);
15

1. Add this code in design/backend/templates/views/products/manage.tpl:


    {__("sku2")}

after this:


    {__("sku")}

2. In app/functions/fn.catalog.php replace this code (~6049 row, fn_get_products function):

$fields = array(
    'product_id' => 'products.product_id',
);

with this:

$fields = array(
    'product_id' => 'products.product_id',
    'sku2' => 'products.sku2'
);

Hmmm, I'm sorry, but nothing change after I made changes as mentioned above. After I deleted cache folder, still got just 1 SKU code.

Thanks

16

Hmmm, I'm sorry, but nothing change after I made changes as mentioned above. After I deleted cache folder, still got just 1 SKU code.

Thanks

It is strange. Please, send me PM with the ftp access to your store.

17

It is strange. Please, send me PM with the ftp access to your store.

Done. I sent PM with FTP details.

18

We have sold the issue. One of the add-ons overrides the manage.tpl file, so the changes should be made in the overriden file.