Just another Cross-Sell mod (support thread)

It's actually quite easy, you just have to change the sql query a bit like this:

You can pull the products from the cross-sell table AND products from the products table that have the same categories_id. Of course you will need to add "ORDER BY RAND()" and "LIMIT 8" or something.

Quote:

---

Originally Posted by 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.

---

Does the original cross sell have to be installed? I don't see any mention of it needing to be installed here:
http://www.zen-cart.com/index.php?ma...roducts_id=694

You should find it mentioned in the readme file.

Quote:

---

Originally Posted by yellow1912

Alpha 1 rev 34 uploaded.

Changes:
This update addresses the javascript bug in the IE browser.
Moved some functions around to tidy up the codes.

Note:
There was a report that this mod does not work well in MySql 4.1. Let me know if you have the same problem with this version

---

Still not working for MySql 4.1 get the following error

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 zen_products WHERE products_model = 'stp02' UNION(SELECT products_id FROM zen_products WHERE products_model = 'te02')]
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.

Any ideas!!!
Many thanks
Rachel

I'll write a special version for mysql 4.1 to address this error, should be available within hours.

Regards.

Quote:

---

Originally Posted by yellow1912

I'll write a special version for mysql 4.1 to address this error, should be available within hours.

Regards.

---

Thank you
can't wait!! its such a pain having to cross sell each product individually with your mod i won't have to do this

Getting this error on 4.1 as well so the fix will be much appreciated... ;-)

The new version alpha1 rev 36 has been posted on download section and should be available within a few hours. This should fix the problem with mysql 4.1.

Regards.

PS: if the previous version is working fine for you, you do not need to upgrade to this one (there are some minor changes tho, so if you have time go ahead and update)

Just to say to address the 4.1 problem in the meantime I took the updated xsell_advanced.php file from your site and it now works perfectly - thanks.

located here.

I also updated the admin/xsell_advanced.php to show the model number in the Current Cross Sells table:

line 293 insert:

Quote:

---

echo '<td>Product Model</td>';

---

line 301 insert:

Quote:

---

echo '<td style="border-bottom:1px dashed #cccccc;">' . $xsell_products->fields['products_model'] . '</td>';

---

Ideally it would be good to be able to sort the product id and model by clicking those headings - but that's beyond me ;-0

Yup, for those of you who are impatiently waiting for the download to be available on ZC (we have to wait for a mod to approve it), you can go to the link about and download it.

The sort is quite easy (ZC may have function for it already), so we will see it in the next version.

PS: patski, if you want to insert the model column you should also insert it on the table header as well.