Problems with Sort by Price

[Ajeh]

I don't see a way to sort your Products by Price ...

You appear to be using some kind of Add On that has taken away that feature ...

If I go to the New Products, and sort the Products in reverse order, they appear correct but I did not go through the whole list ...

What specifically is not sorting by Price right now? How are you altering the Sort Order where this is not working?

[JohnBoyCR]

Linda,

As they were not working, I removed the options for sort by price.
I did not want to present the customers with something that did not
work.

I will make those sort options available for you so look at them.

They should be available at around 2PM ET on 24OCT.

John

[JohnBoyCR]

Linda,

The sort by price, low to high and high to low, are now available.

Yes, the sort seems to work correctly for new product. Also,
the sort by price also works for the Emergency Stamps category.

I really do appreciate your looking at this.

I downloaded code from the live site to my localhost and the
sort works on the localhost. Sure looks like a DB problem but then
one would think that the New Products sort by price would not work
correctly if it were a DB problem. I guess I am still an EGG !

John

[JohnBoyCR]

Linda,

I am seeing a pattern in the categories that sort properly and
those that do not. I believe that the problem may be related to
a recent upload I performed using EasyPopulate.

I believe that in the last upload there was some kind of problem
and there was a message for each of the products that the data
was not stored because the v_product_model was missing.
The tab delimited file looked fine but there was apparently
something not correct. I re-created the tab delimited text file
and reloaded the data and everything seemed to work.
HOWEVER, when I looked at the Categories and Products, in
admin, there were about 80 new Categories. Those categories all
had names that were the same as the v_products_image.

I deleted all of those new categories, as they had no products in them, but now I am beginning to wonder if that is were the problem
originated.

The categories that seem to sort correctly have NOT had any
new products uploaded recently. Those that do not sort
properly had product uploaded in that last upload.

I think we are getting somewhere.

So, here is the next question. The backups I have on the
server are FULL backups. I know that I can have the
support folks do a complete restore of a backup. However,
I would like to just do a restore of the database. Do you
suppose that they can extract just the DB files from the full
backup and restore just the DB?

John

[JohnBoyCR]

Linda,

I just had another thought, and I hope it is a good one ( I sure
need a good one right now ).

Let's assume that there is something messed up in the DB and
further assume that it is related to the Products table and
the Products to Categories table.

What if I were to go into the admin and delete all of the
categories? As I have a tab delimited download of the DB
I could then reload all of the product back into the DB. Would
that likely take care of the problem?

By the way, the site seems to be down, or REALLY SLOW, right now.

John

[JohnBoyCR]

Linda,

I just had an even better idea, I hope.

As soon as I can access the site I am going to delete just one of
the categories that is not sorting properly. I will then reload the
product data for that category and see if it sorts properly. If it
does, then I can proceed with the plan to remove and reload all
the product data.

Does that sound like a good plan?

John

[JohnBoyCR]

Linda,

Well, my last idea did not work. I removed the FDC and MC
big packs category and then reloaded it. The sort by price
still does not work. HMMM !

Is there a different sort routine used when looking at products by
category than the routine used for new products ?

John