If I understood correctly you need a dropdown product attribute, but the actual values that are going to be stored in the db, need to be exactly 1000, 2000 and 3000
.
if that is the case, then you need an attribute with a custom source model.
Here is an explanation on how you can do that.
The main idea in the article is that you need a custom module that will add a product attribute and specify a custom source model to it.
Something like this:
$this->addAttribute('catalog_product', 'provider', array(
'group' => 'General',
'type' => 'int',
'backend' => '',
'frontend_input' => '',
'frontend' => '',
'label' => 'Provider',
'input' => 'select',
'class' => '',
'source' => 'provider/attribute_source_provider',
'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,//can be SCOPE_WEBSITE or SCOPE_STORE
'visible' => true,
'used_in_product_listing' =>true,//can also be false
'frontend_class' => '',
'required' => false,//can be true
'user_defined' => true,
'default' => '',
'searchable' => false,//can be true
'filterable' => false,//can be true
'comparable' => false,//can be true
'visible_on_front' => false,//can be true
'unique' => false,
'position' => 60,//put any number here
));
Notice the source
element in the config array. In this case is provider/attribute_source_provider
. This means that the options you will see in the dropdown are generated by the call of
Mage::getModel('provider/attribute_source_provider')->getAllOptions();
You can implement that method in your custom model and set the values as you want.
For example
public function getAllOptions($withEmpty = false){
if (is_null($this->_options)){
$this->_options = array();
//$this->_options[] = array('label'=>'HERE GOES THE LABEL', 'value'=>'HERE GOES THE VALUE');
//as example
$this->_options[] = array('label'=> $this->__('New'), value=>1000);
$this->_options[] = array('label'=> $this->__('Refurbished'), value=>2000);
$this->_options[] = array('label'=> $this->__('Used'), value=>3000);
}
$options = $this->_options;
if ($withEmpty) {
array_unshift($options, array('value'=>'', 'label'=>''));
}
return $options;
}