Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 50
  1. #31
    Join Date
    May 2004
    Location
    UK
    Posts
    474
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    Quote Originally Posted by numinix View Post
    Thank you - perfect solution :)

  2. #32
    Join Date
    Nov 2010
    Posts
    16
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    Having a bit of a problem, implemented it as per the instructions, however, when i go to my specials page... it still doesn't list the sales?


    Please help!

  3. #33
    Join Date
    Nov 2010
    Posts
    16
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    If you go to http://gbsa.tyrmida.co.za/shop/all-products

    you'll see the first shoe top left (alma hi) is on special, and the shoe to the right of it (alma lo) is on sale.

    If you go to the specials page http://gbsa.tyrmida.co.za/shop/specials

    it only shows the alma hi.


    Please help, this is rather urgent

  4. #34
    Join Date
    Mar 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    Quote Originally Posted by numinix View Post
    Thanks for the fix but what would I have to change to get the specials to show on the index page in the center? I have "Show Special Products on Main Page" set to "on" but with the fix the salemaker don't show.

  5. #35
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    5,620
    Plugin Contributions
    211

    Default Re: Salesmaker not show under Specials?

    If you want to show the sales on the front page, use my "What's On Sale" contribution in the Free Software Add Ons at the top left of this page.
    That Software Guy, Plugin Moderator. Store: Zen Cart Modifications
    Contributions: Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more.

  6. #36
    Join Date
    Mar 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    Quote Originally Posted by swguy View Post
    If you want to show the sales on the front page, use my "What's On Sale" contribution in the Free Software Add Ons at the top left of this page.
    Thank you! The add-on works great!

  7. #37
    Join Date
    Jan 2014
    Location
    Hell
    Posts
    1
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    I went ahead and made a hack that lets you add multiple items to Specials at one time. Is anyone still interested in this? Don't want to waste my time putting this out there if no one needs it.

  8. #38

    Default Re: Salesmaker not show under Specials?

    Hi

    Using version 1.3.9h I am getting an error with Numinix fix

    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘*) as total FROM products p LEFT JOIN specials s ON (s’ at line 1
    in:
    [select count(distinct *) as total FROM products p LEFT JOIN specials s ON (s.products_id = p.products_id) LEFT JOIN products_description pd ON (pd.products_id = p.products_id) LEFT JOIN products_to_categories p2c ON (p2c.products_id = p.products_id) WHERE p.products_status = '1' AND ( (s.status = 1 AND p.products_id = s.products_id) OR (p2c.categories_id IN (235,201)) ) AND p.products_id = pd.products_id AND pd.language_id = 1 ]

    On his blog there are others having same problem and no solution, does someone know how to solve this error?

    Thanks

    L.

  9. #39
    Join Date
    Apr 2007
    Location
    Vancouver, Canada
    Posts
    1,510
    Plugin Contributions
    81

    Default Re: Salesmaker not show under Specials?

    Quote Originally Posted by wirefram View Post
    Hi

    Using version 1.3.9h I am getting an error with Numinix fix

    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘*) as total FROM products p LEFT JOIN specials s ON (s’ at line 1
    in:
    [select count(distinct *) as total FROM products p LEFT JOIN specials s ON (s.products_id = p.products_id) LEFT JOIN products_description pd ON (pd.products_id = p.products_id) LEFT JOIN products_to_categories p2c ON (p2c.products_id = p.products_id) WHERE p.products_status = '1' AND ( (s.status = 1 AND p.products_id = s.products_id) OR (p2c.categories_id IN (235,201)) ) AND p.products_id = pd.products_id AND pd.language_id = 1 ]

    On his blog there are others having same problem and no solution, does someone know how to solve this error?

    Thanks

    L.
    Please see my latest comment: https://www.numinix.com/blog/2010/10.../#comment-5001.

    Have you made other customizations to the specials listing? This code does work with ZC 1.5.1. Try using the developer's toolkit to find where this text is used:

    Code:
    select count(distinct *) as total FROM

  10. #40
    Join Date
    May 2004
    Location
    UK
    Posts
    474
    Plugin Contributions
    0

    Default Re: Salesmaker not show under Specials?

    In case this helps anyone:

    for those of you like me that suddenly got the “WARNING: An Error occurred, please refresh the page and try again.” using Zen Cart 1.5.1 – I dug around and for some reason when a new salemaker is being created its addin in 2 commas st the start of the field – which the MySQL cannot work with

    so in

    Open includes/modules/pages/specials/main_template_vars.php and find:

    I changed

    $sale_categories_all = substr($sale_categories_all, 1); // remove preceeding comma

    too

    $sale_categories_all = substr($sale_categories_all, 2); // remove preceeding 2 comma’s

    and error went away – now I don’t know why this is happening now – as it was working fine

    but for those that just want a solution try it - I don't guarantee that it won't have an effect further down the line :)

    Thanks
    Sarah

 

 
Page 4 of 5 FirstFirst ... 2345 LastLast

Similar Threads

  1. Only have % show up in specials, not .99
    By JEKB in forum Setting Up Specials and SaleMaker
    Replies: 3
    Last Post: 11 Sep 2010, 09:23 PM
  2. How to a pick which specific items show under MONTHLY SPECIALS
    By soultrain99 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 25 Jun 2008, 10:11 PM
  3. Include specials end date to under specials price?
    By this side up in forum Setting Up Specials and SaleMaker
    Replies: 7
    Last Post: 13 Jun 2007, 04:47 PM
  4. Specials vs. Salesmaker
    By DesignbyDemeter in forum Setting Up Specials and SaleMaker
    Replies: 1
    Last Post: 2 Jul 2006, 03:26 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