[SOLVED]How to add new text field to a product which will only be available from the BO?

[Dolke]

Hi guys,

Here is the situation:

 

What I need is another text field which I can add to a product. This text field should be similar to a field where you put the product name.

 

This filed should be only visible in the back office and not to be available on the front end.

The reason why I need this filed is the following.

 

Product names which I use on my web store are usually full names, with full words, numbers and descriptions of the product like manufacturer, type, model etc...These are used for SEO purposes.

Product names which I use in my offline retail stores are usually shortened for practical purposes like when I'm printing the labels with the prices, when printing fiscal receipts etc...

Here is one simple example form my website:

 

Webstore product name: Grejač bojlera 2000w 5/4 bakarni, fi 8,1mm 482873 / Gorenje Tiki
My retail product name:  Gr. bojlera 2000w 5/4 bak. fi8,1mm 482873 Gor.

This is just one example probably not the best one either but that's basically how the names of the products are shortened in my retail stores. 

For my and my employees I would like to add another text filed where I can give them short version of the name as well and this is only for our internal purposes and not needs to be visible on the website.

How can I make this happen? Can I use some module that extends product fields so I can add new text field? Someother way?

 

Thank you in advance
Dean
 

Edited November 8, 2013 by Dolke (see edit history)

[vekia]

hello

 

you can easily modify the core and database, i will show you step by step tutorial below. So we want to create field name: internal name

 

(1)

For the first, we need to create new field in ps_product table. so, open phpmyadmin and alter ps_product table.

add new VARCHAR(200) field (i think that 200 chars for internal name are enough, am i right? )

field name: internal_name, specification:

 

(2)

Now it's time to extend object, open classes/product.php file

there is code like:

 

....

 

 

read full tutorial here: new field for products in back office

[vekia]

hello Dean!

 

have you tried this? im so curious!

[Dolke]

Hi Vekia,

 

Thank you for this solution and sorry for my late replay.

I wasnt on the forums for a few days. 
I'll implement this solution later on today and post the news.

 

Cheers.
Dean

[vekia]

no worries this should work well because i use the same solution, i'm just so curious

thank you for your reply

 

with regards,

Milos

[Dolke]

Nice! It worked like a charm.

This is a really nice and elegant solution Miloš and hopefully one less problem for me.

I just need to check if this data will also be included once I export the products using Store Manager.

 

I will label this thread as SOLVED and report back once I test this export part.

Thanks a million. 
Dean

[vekia]

i don't think so that store manager will work with this customization, unfortunately

[Dolke]

Why do you think that Miloš?

Without that I'm afraid I cannot use it.

Don't get me wrong, its a great customization its just that we are working totally automated so I would need to have this exported for over a 4000 products and prior to that imported as well.

P.S. 
For some unknown reason Im unable to connect to my test website using Store Manager due to some a2 hosting limitation probably so Im waiting for them to replay to my ticket...

Edited November 8, 2013 by Dolke (see edit history)

[vekia]

i never used store manager in production, only several tests.

i don't know if this software supports non-default fields in database 

[Dolke]

I don't know either but that's exactly what I want to test

If not I will submit feature request to them.

I will replay as soon as I have something Milos.

have a good one.
Dean

[Dolke]

Milos, I just tested this on my test website and used Store Manager to export that field also.

 

All went successfully.

Thumbs up for this feature! Maybe you can add this as a sort of module perhaps? 

What do you think?

[vekia]

hello

 

woohoo! store manager is powerful tool!

btw. i created article on my website and added there little advertise about dekom once again!

 

 

unfortunately, to get new fields in back office like i described it's necessary to modify the core.

it mean that module is not as good option as modification of these files manually

[Dolke]

It is very powerful, I'm using it on daily basis and it does help me a lot and save so much time.

Great m8, you can use my solved threads anytime   
 

I understand about the module proposal, no worries.

 

Thanks.

[TheWolf]

Hi Vekia, is it possible to make this field visible in FO too? if so this is exactly what i need.

I'm developing a computer parts shop based on Prestashop and i want to add a Warranty line below the product name stating what kind of warranty and duration an item have.

it would be great even if it can be a text box so i can even use html code in order to link to the warranty provider if ppl click on it.

 

any thought?