Just another Cross-Sell mod (support thread)

[yellow1912]

JUST ANOTHER CROSS SELL MOD
Version: aplha 1

Based on Advanced Cross-sell originally coded by Absolute
Link to the original:
http://www.zen-cart.com/index.php?ma...roducts_id=597


Features:
1. Allow unlimited number of product fields instead of only 5.
2. Accept product id or model as input value.
3. Clean up table.
4. Given a list of n products, the mod will go through and cross-sell EACH pair together.
IMPORTANT: This is the VERY different from the way the old cross-sell mod work! As a seller, I realize that when I cross-sell A and B I want the customers to see the product B while they are viewing A and VICE VERSA.
With the old cross-sell and the Advanced Cross-Sell mod I had to add A to B then B to A, which is lots of work.

With this mod, if you give it 3 products: A - B - C, it will cross-sell:
A to B, B to A
A to C, C to A
B to C, C to B

Screenshot:
https://svn.rubikintegration.com/zen...screenshot.gif

Bug report:
http://www.rubikintegration.com/mantis
Latest (unstable) version:
https://svn.rubikintegration.com/zen...sell_advanced/
Latest (stable) version:
link should be available here soon!

yellow1912

[yellow1912]

Download link:
http://www.zen-cart.com/index.php?ma...roducts_id=694

I accidentally included .svn folders in the first zip file. Make sure you don't upload them to your server. They won't do any harm, just take a few kB extra space.

[paulm]

Sounds very interesting

I was wondering about this though:

Given a list of n products, the mod will go through and cross-sell EACH pair together.

Is this an option? Is it possible to link some products from A to B only and others vice versa?

[yellow1912]

No, not an option now. But since this mod requires that you must have the old cross-sell installed, you still have access to that one after installing this in case you want to cross a to B only.

I'll add that specific option in the next version.

Sounds very interesting

I was wondering about this though:
Is this an option? Is it possible to link some products from A to B only and others vice versa?

[paulm]

Ok thanks :-)

(I was thinking about batteries for example, one battery may be x-sold with many products, but it's not logical to x-sell all those products together with the battery)

[yellow1912]

That's very easy to do, I'll add it to my to-do list and the new version will be ready very soon. Right now my time is running out (school starts next week), so I'm working on another mod (retrieves articles from blogs about a specific product and show to customers)

Ok thanks :-)

(I was thinking about batteries for example, one battery may be x-sold with many products, but it's not logical to x-sell all those products together with the battery)

[yellow1912]

Just a side-note, there is one feature of this mod that I forgot to mention:
When you edit the cross-sell(s) of 1 product, you can change the sort_order or delete cross-sell(s) very easily. This was one of the features missing in Advanced XSell

[yellow1912]

I made a very stupid mistake which prevents dynamically adding new product fields on certain browsers. I have uploaded alpha 1 (rev 29), please download it when it's available on the download section.

For a quick fix, just open admin/xsell_advanced.php, search for "xsellProducts", you will find 2 results. Change the FIRST one to "xsellCleanup".

[michaelhl]

Hello,
I install it, and if I want insert a cross sell, I get a SQL-Error like this:


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 ')' at line 1
in:
[SELECT products_id FROM products WHERE products_id = 1175 LIMIT 1 UNION (SELECT products_id FROM products WHERE products_id = 1152 LIMIT 1)]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[michaelhl]

Now I install the rev29 files, but all is the same. Also the dynamic input fields dosen't work in IE6.
IE6 shows an error-symbol down on the left side:

Row: 280
Character: 78
Mistake: Bezeichner, Zeichenfolge oder Zahl erwartet
Code:0
URL: xxxxxxxxxxxxx/xxxxxxx/xsell_advanced.php