I deleted products several times, and then the price was missing from the import. It was several days ago, and several deletions ago, so I cannot say for sure that the price was ever there.

I deleted another set of products, which had the price showing and also the icon for the product showing, and now the price is there but the icon does not show.

I tried Linda McGrath's suggestion in another post:

Look at your database to see how many rows are in the tables:
products
products_description
products_to_categories

These should match ...

If so, go to the Tools ... Store Manager ... and run, in order:
Update master_categories_id
Update products_price_sorter

Now see if everything is set right ...

Updating the master_categories_id will take the categories_id from the products_to_categories table and update all master_categories_id with that value ...

Updating the products_price_sorter will update the field used for sorting prices when in the Catalog so that things sort correctly without having to do any calculations on the sort ...
However, there was no change.

This is a test site, and I can easily restore the backup and start fresh.

I was just wondering if something as simple as copying prices into PHPMyAdmin could be done when the upload with Easy Populate does not place the products in the database.

Or, does it really interrelate with a lot of tables when you delete something, so that if you delete products by deleting the subcateories, you run the risk of damaging the database and needing to restore it, so that maybe deleting products one-by-one is really the only safe method of deletion.

One related question: My product numbers are getting to be very high even though I really do not have any products in my store yet; I am using test files. Is there a way to renumber the products?

Thanks.

Notageek