If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / products_price_sorter does not match product_price please help me understand

products_price_sorter does not match product_price please help me understand

Started by linnx on 30 Sep 2011, 4:31 PM · Views: 1,127

Results 1 to 12 of 12
30 Sep 2011, 4:31 PM
#1
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

products_price_sorter does not match product_price please help me understand

I am using Magnetic One POS system for Zen Cart 1.3.9h. I was scratching my head wondering why the prices on the POS invoice is all wrong. I was informed it uses product_price_sorter. So I went to view the database, and I found the products_price_sorter field. It is definitely off.

I understand this is the price after all discounts, etc.

Well, there are no sales, no discounts, no nothing.

Is it possible this field is somehow not updated to the correct value?

Any ideas?

Thanks

30 Sep 2011, 4:33 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

Do you import your Products?

Do all of your Products have valid master_categories_id values?

Do you use Linked Products?

Do you have both Products and Categories inside a Category?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Sep 2011, 4:57 PM
#3
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

Re: products_price_sorter does not match product_price please help me understand

Ajeh:

Do you import your Products?

Do all of your Products have valid master_categories_id values?

Do you use Linked Products?

Do you have both Products and Categories inside a Category?

Yes, master category ID's appear to be valid. How can it not be valid if it is sitting inside a category?

Yes, we link products into multiple categories that are similar.

No, we do not have products and categories inside a category (Perhaps there is somewhere but I cannot see it, I thought this was not possible to do?)

Thanks!

30 Sep 2011, 5:04 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

Do you Import your Products? Or do you always enter them in the Zen Cart Admin?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Sep 2011, 5:08 PM
#5
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

Re: products_price_sorter does not match product_price please help me understand

Sorry, I found a problem.

Many products that are linked, in the dropdown, say "invalid master category" but this is not selected. I can see it when I click the drop down.

How can I get rid of this? Or do I have to delete the product?

30 Sep 2011, 5:12 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

What version of Zen Cart are you using?

You can fix the Master Categories ID by either editing the Product and selecting a valid one from the dropdown ... and if no dropdown, you can click C for Copy and click the Multiple Categories Link Manager and set it there ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Sep 2011, 5:22 PM
#7
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

Re: products_price_sorter does not match product_price please help me understand

I'm using 1.3.9h

A valid master category is set on all of them, but when I click the dropdown, the first category says invalid master category. So it seems I need to get rid of that.

The only way I could find to eliminate it, was to copy the product to a new product.. then copy it again into the categories I want.

Is there another way to get rid of that invalid master?

30 Sep 2011, 5:30 PM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

You do not need to get rid of Invalid Master Category unless that is actually selected ...

If you go to your phpMyAdmin and browse the table:
products

and sort it on:
master_categories_id

do you see any set to 0 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Sep 2011, 5:58 PM
#9
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

Re: products_price_sorter does not match product_price please help me understand

Ajeh:

You do not need to get rid of Invalid Master Category unless that is actually selected ...

If you go to your phpMyAdmin and browse the table:
products

and sort it on:
master_categories_id

do you see any set to 0 ...

None of them are set to 0.

30 Sep 2011, 6:17 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

Was this a Clean install or an Upgrade?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 Sep 2011, 6:32 PM
#11
linnx avatar

linnx

Zen Follower

Join Date:
Jun 2009
Posts:
187
Plugin Contributions:
0

Re: products_price_sorter does not match product_price please help me understand

Ajeh:

Was this a Clean install or an Upgrade?

This was an upgrade. Been using Zen cart for over 2 years now.

30 Sep 2011, 6:34 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: products_price_sorter does not match product_price please help me understand

What happens if you switch to the Classic Template ... does this fix the problem?

You might use something like Beyond Compare from scootersoftware.com and see if the files on the server match your copy on your computer and then compare a clean install of v1.3.9 to the files to see if you can spot an issue ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!