Just another Cross-Sell mod (support thread)

Hello there,

I was wondering, while I was using the cross sell mods, is it at all possible to cross sell by category id? All the cross sells I have setup cross sell items from the same category. Like once you have a category full of items, they inter cross sell each other. Just a crazy idea! lol :smile:

Regards,

Heathenmagic

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.

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?main_page=product_contrib_info&cPath=40_60&products_id=694

You should find it mentioned in the readme file.

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.

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:

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

line 301 insert:

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.

I did didn't I - isn't that the first insert above?

Yeah sorry patski, I somehow did not see it. And I have updated that to the file on svn too,

Regards.

that was quick....

and if you're thinking about future enhancements :blink: then to be able to filter the current cross sells by category would be good...

Great time saving mod though - I've got hundreds to do!

installed the update aswell works great with MySql4 now
thank you

I note that the original cross sell has to be installed first, but that one is not specifically 1.3.7 - and some of the YOUR_TEMPLATE directories are not in all the 1.3.7 directories.

Are you able to include all the files necessary for the install in your own download, and so have as one package???

I am looking to install cross sell and this mod. Are there any site samples of the customer's POV? I want to see how it looks.

Thanks

I installed the original one on my site(1.3.7) with no problem as all, so it should work for you. Do that on your test site first tho. And I will think about including those files on my next version, need to look at the "term of use" tho. > T2DMan:

I note that the original cross sell has to be installed first, but that one is not specifically 1.3.7 - and some of the YOUR_TEMPLATE directories are not in all the 1.3.7 directories.

Are you able to include all the files necessary for the install in your own download, and so have as one package???

I PMed you the link.

fbords:

I am looking to install cross sell and this mod. Are there any site samples of the customer's POV? I want to see how it looks.

Thanks

New version Alpha rev 39 has been added to the download section and should be available for download soon. If you are impatient, get the files at my svn (the link is on the first post of this thread)

This version introduces a new feature that some of you requested:
You can now do one-way cross sell, you can cross sell one product to many others (and not vice versa). With this feature added, this mod now can completely replace the old Advanced Cross Sell mod.