Price drop is empty after manual record entry in ps_specific_price table

[sadi21]

I am importing XML data and adding products directly into database with php code. It works fine, i can edit the product successfully. Checkout also working fine.

 

I am also manually adding records to specific_price table. I can view it in Specific Prices section when i edit the product. But ALL OF THE ITEMS does not appear in the Price Drop page (the page is empty)

 

When i add new SPECIFIC PRICE from back office to any product, everything starts working fine. All products are started displaying in Price Drop.

 

I believe i am missing some function call or a table which activates price drop or something similar.

 

Any help is appreciated.

 

PS version 1.6.09

 

 

[shacker]

update the priority able too like:

 

Db::getInstance()->Execute('

INSERT INTO `'._DB_PREFIX_.'specific_price_priority` (

`id_specific_price_priority` ,

`id_product` ,

`priority`

)

VALUES (

NULL ,  \''.$veri3['id_product'].'\',  \''.$veri2['priority'].'\'

);');

}

[sadi21]

Thanks for the reply Shacker

 

i got it working by setting PS_SPECIFIC_PRICE_FEATURE_ACTIVE to 1 in ps_configuration table.

[shacker]

youre right, i forgot that.

remember to change the title of the post to solved.

regards