Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  3. #3
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default Re: products_price_sorter does not match product_price please help me understand

    Quote Originally Posted by Ajeh View Post
    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!
    Last edited by linnx; 30 Sep 2011 at 06:04 PM.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  5. #5
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default 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?

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  7. #7
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default 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?

  8. #8
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  9. #9
    Join Date
    Jun 2009
    Posts
    187
    Plugin Contributions
    0

    Default Re: products_price_sorter does not match product_price please help me understand

    Quote Originally Posted by Ajeh View Post
    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.

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. LEGEND: Billing and Shipping does not match, Please Help
    By vitalyk78 in forum General Questions
    Replies: 2
    Last Post: 14 May 2010, 06:35 AM
  2. Please help - Pricing does not match
    By sparkiii in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 25 Jul 2007, 07:05 PM
  3. Billing and Shipping does not match
    By Visual Designs in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 8 Feb 2007, 03:01 AM
  4. tep_db_fetch_array in while please help me understand it!
    By Reesy in forum General Questions
    Replies: 5
    Last Post: 8 Sep 2006, 03:42 PM
  5. Please help me understand the override system.
    By angelicdezigns in forum Templates, Stylesheets, Page Layout
    Replies: 9
    Last Post: 9 Jul 2006, 06:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR