Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2005
    Location
    Houston, TX
    Posts
    1,412
    Plugin Contributions
    1

    Default Cross Sell Advanced

    I have uploaded the cross sell advanced mod to the downloads section. Many of you may find it a simpler way to assign cross sell products.

    Enjoy!

    http://www.zen-cart.com/index.php?ma...roducts_id=597

    Here is a screen shot:


  2. #2
    Join Date
    Mar 2007
    Posts
    58
    Plugin Contributions
    0

    Default Re: Cross Sell Advanced

    Hi Voltage,

    Just wanted to say thank you for this great mod. I'm using it and loving it!


    Steve
    Stuff: ZC v1.37 | Linux | mysql v 4.1x | php v 4.4x | phpmyadmin v 2.6x | Default Template

    Mods: Login Box v 1.41

  3. #3
    Join Date
    Apr 2005
    Location
    Houston, TX
    Posts
    1,412
    Plugin Contributions
    1

    Default Re: Cross Sell Advanced

    Most of the thanks goes to Absolute. He did the hard coding. I just came up with idea and the $$$ to pay him to do it. ;)

    Before this mod, I could not stand setting up the cross sell items. It would take way too long searching for the right item in the list. Now, you can just use the catalog side to decide what to cross sell, and then simply type in the model #'s.

    Quote Originally Posted by StevenB View Post
    Hi Voltage,

    Just wanted to say thank you for this great mod. I'm using it and loving it!


    Steve

  4. #4
    Join Date
    Nov 2005
    Location
    www.carouseltoyshop.co.uk
    Posts
    20
    Plugin Contributions
    0

    Default Re: Cross Sell Advanced

    It says that is required cross sell to be installed but i cant find the cross sale..


  5. #5
    Join Date
    Nov 2003
    Location
    Haarlem | Netherlands
    Posts
    1,989
    Plugin Contributions
    15

    Default Re: Cross Sell Advanced

    Thanks a lot, nice idea

    I did a quick hack which allows to copy existing cross sells quickly. The zip is attached to this post (includes a short readme and screenshot).
    Attached Files Attached Files

  6. #6
    Join Date
    Apr 2005
    Location
    Spokane, Washington
    Posts
    372
    Plugin Contributions
    0

    Default Re: Cross Sell Advanced

    When a customer places more than 12 items in their shopping cart the "Also Purchased" box at the bottom disappears and a very long sql error messages appears. This only occurs if there are more than 12 items in the box.

    I have removed all cross sell items, but it still appears.

    Just knowledgeable enough to be dangerous.

  7. #7
    Join Date
    Nov 2003
    Location
    Haarlem | Netherlands
    Posts
    1,989
    Plugin Contributions
    15

    Default Re: Cross Sell Advanced

    "Also Purchased" is not the same as "Cross Sell". Sounds like a wierd error though.

    a very long sql error messages appears
    "very long" is not clear enough. You should post the exact message here.

  8. #8
    Join Date
    Apr 2005
    Location
    Spokane, Washington
    Posts
    372
    Plugin Contributions
    0

    Default Re: Cross Sell Advanced

    Here's the complete error text. I associated it with cross sell because of some of the text.

    Code:
    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 '-1)' at line 1
    in:
    
    [(select p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '265' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '268' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '270' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '283' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '292' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '521' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '307' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '314' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '363' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '367' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '365' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '344' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
    p.products_id, p.products_image from products_xsell xp, products p, 
    products_description pd where xp.products_id = '1229' and xp.xsell_id = 
    p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
    p.products_status = '1' order by xp.products_id asc limit -1)]
    I am using ZC 1.3.7

    jacque
    Last edited by jacque427; 4 Aug 2007 at 04:46 PM. Reason: forgot version

    Just knowledgeable enough to be dangerous.

  9. #9
    Join Date
    Nov 2003
    Location
    Haarlem | Netherlands
    Posts
    1,989
    Plugin Contributions
    15

    Default Re: Cross Sell Advanced

    The last part:
    limit -1
    could be the problem. I tried to reproduce the issue but I did not encounter the same error (not using the newest MySQL version though).

  10. #10
    Join Date
    May 2007
    Posts
    79
    Plugin Contributions
    0

    Default Re: Cross Sell Advanced

    I have some products with the same model number. Cross Sell Advanced doesn't seem to do anything when I enter cross sells for those products. Is this normal, or should it add them for the first product with that model number, or all products with that model number?

 

 

Similar Threads

  1. Cross Sell Plus Advanced Sell Combo
    By Limitless in forum All Other Contributions/Addons
    Replies: 40
    Last Post: 13 Aug 2017, 06:26 AM
  2. v155 cross sell advanced
    By Hollywood691 in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 10 Aug 2016, 01:14 PM
  3. Replies: 1
    Last Post: 18 Sep 2013, 11:24 PM
  4. Advanced Cross Sell
    By NWCE in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 3 Jan 2010, 11:05 PM
  5. Cross Sell and Advanced Cross Sell Modules
    By fairway in forum Addon Templates
    Replies: 4
    Last Post: 8 Dec 2009, 08:44 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