Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    158
    Plugin Contributions
    0

    Default Sale applied to a category but it discounted almost storewide

    I have a few sales on different categories running but today when I changed the percentage on an existing sale it discounted heaps of other categories along with it even though they weren't ticked in the sale maker.

    I have now deleted all of my sales and doing it that hard way by individually editing each product.

    What could be causing the problem as this isn't the first time it has incorrectly assigned sales to many other categories in error.

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

    Default Re: Sale applied to a category but it discounted almost storewide

    What version of Zen Cart are you using?

    Clean install or an Upgrade?

    Sale Maker uses the master_categories_id of a Product to determine sales ...

    If you do not have Linked Products, then the master_categories_id should match the only categories_id that it is in ...

    If you do have Linked Products, then the master_categories_id should belong the the Category that "owns" the Product ... meaning, that when you put a Category on sale, should the Product be on sale ...

    If you import Products, you could be missing the master_categories_id as well as the products_price_sorter in the table:
    products

    The products_price_sorter is used for sorting Products by price, without having to calculate this price ... the products_price_sorter is the Lowest price a Product can be purchased for ...

    If you do not use Linked Products, and your master_categories_id are not correct you can go to the Tools ... Store Manager ... and use the:
    Reset ALL Products Master Categories ID
    to be used for Linked Products and Pricing:
    Then, you would want to run the Update on the Product Price Sorter:
    Update ALL Products Price Sorter
    to be able to sort by displayed prices: Update
    If you do use Linked Products, you can still use this method, however, the master_categories_id will be set to the lowest value of categories_id found for the Product, and you may need to reset this value either individual by Product for those that are incorrect, or use the Multiple Categories Link Manager ... which you would find when you hit the C for Copy on a Product ...
    Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
    Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID
    If you are using older versions of Zen Cart than v1.3.9, you will need to at the minimum, apply all of the Known Bug Fixes:
    http://www.zen-cart.com/forum/showthread.php?t=82619

    and all of the Security Patches and Updates:
    http://www.zen-cart.com/forum/showthread.php?t=131115

    or, upgrade to the current version of Zen Cart, on our Home page ...

    NOTE: the Upgrade contains all of the Known Bug Fixes and Security Patches and Updates as well as much, much more ...
    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!

 

 

Similar Threads

  1. Quantity discounts not being applied to Sale products
    By tj1 in forum Setting Up Specials and SaleMaker
    Replies: 8
    Last Post: 2 Jan 2014, 09:11 PM
  2. v139h How can I EXCLUDE select items from a storewide 'salemaker' sale?
    By sportbiker in forum Setting Up Specials and SaleMaker
    Replies: 0
    Last Post: 28 Nov 2012, 11:23 PM
  3. Shipping by percentage of retail value vs sale or discounted value
    By giftsandwhatnot in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 8 Aug 2011, 05:16 PM
  4. Replies: 2
    Last Post: 8 Mar 2011, 11:26 AM
  5. Almost there but missed something...
    By Rizla in forum Installing on a Windows Server
    Replies: 2
    Last Post: 8 Dec 2010, 02:38 PM

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