Adding New Fields To Products For Product Import

[Hartung]

Hi,

 

I try to add two new fields to my Prestashop 1.6.0.14  http://www.thecartridgecompany.eu    to use for product import.

The fields that I added are 

 

printer_type

 

cartridge_nummer

 

 

When I fill those fields manually I get Unknown column 'printer_type' in 'field list'   see attachment new added fields

 

What did  do wrong?

 

1) I added the fields in my database, see attachment (added fields to Database)

2) in the informations.tpl i add this lines

 

{* start added by WBF *}

 

<div class="form-group">

<label class="control-label col-lg-3" for="printer_type">

<span class="label-tooltip" data-toggle="tooltip"

title="{l s='printer_type'} {l s='Allowed special characters:'} .-_#\">

{$bullet_common_field} {l s='printer_type'}

</span>

</label>

<div class="col-lg-5">

<input type="text" id="printer_type" name="printer_type" value="{$product->printer_type|htmlentitiesUTF8}" />

</div>

</div>

 

<div class="form-group">

<label class="control-label col-lg-3" for="cartridge_nummer">

<span class="label-tooltip" data-toggle="tooltip"

title="{l s='cartridge_nummer'} {l s='Allowed special characters:'} .-_#\">

{$bullet_common_field} {l s='cartridge_nummer'}

</span>

</label>

<div class="col-lg-5">

<input type="text" id="cartridge_nummer" name="cartridge_nummer" value="{$product->cartridge_nummer|htmlentitiesUTF8}" />

</div>

</div>

 

 

{* end added by WBF *}

 

 

3) In my product.php I added

 

/** @var string printer type */

public $printer_type;

 

/** @var string cartridge nummer */

public $cartridge_nummer;

 

 

and

 

/* fields added by WBF */

/* 'printer_type' => array('type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml'),*/

/* 'cartridge_nummer' => array('type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml'),*/

'printer_type' =>              array('type' => self::TYPE_STRING, 'validate' => 'isCleanHtml'),

'cartridge_nummer' =>           array('type' => self::TYPE_STRING, 'validate' => 'isCleanHtml'),

 

 

Now I can see the added fields I my B.O but cannot use because i'm missing something..

What do I do wrong?

Edited January 19, 2016 by Willbefine (see edit history)