php - Magento attribute values saved in admin disappear -

php - Magento attribute values saved in admin disappear -

i had set catalog sort on these values, saved through admin lastly night. of total day there. now, ghosts have disappeared.

i suspect problem tied values saved through admin rather imported.

can point me source of problem , solution in code?

between lastly time saw values working on frontend (a few hours ago) , now, did several things:

1.) added 2 new attributes , test values (unrelated problem attribute), reindexed.

2.) tried import unrelated values 60,000 products. import hanged, so

3.) imported values 20,000 products @ time, no errors.

4.) reindexed.

now values saved manually gone. again, how can happen? if saved db, shouldn't take delete phone call code db this? how/why such phone call made when did not execute such command in code or through admin? how can prepare , avaoid in future?

to axel (clarifying):

thanks reply, @axel.

1.) created text attribute called "sort_order" , entered integer values through admin.

2.) did full db backup mysqldump.

3.) then, created 2 new attributes, "random_order" (price type) , "random_order_1" (text type). purpose experiment 2 solutions shuffling products in catalog pages.

4.) through phpmyadmin did simple query give me products in random order:

select `sku` `catalog_product_entity` 1 order rand( )

and exported result csv. used excel number items 1-60,000, creating import csv file columns: sku, random_order (price type), random_order_1 (text type), both attributes having same integer values.

5.) used standard import method (replace existing complex data) in admin, 20k products @ time. after import, values set , seemingly totally unrelated "random_order" have been deleted.

before reindexing, every item's sort_order reset default (=1), still appears in proper order on frontend (so value still exists in product flat table), while random_order , random_order_1 attributes have imported values.

after reindex, trace of sort_order wiped out. create sense if importing attribute, i'm not. no other attribute appears have been affected.

i restored db mysqldump, tried whole process again. same result.

php mysql magento