Just another Cross-Sell mod (support thread)

Hi Yelllow,

This is just wrong, when you check the box "Cross sell 1 way only?", a new input field will be added on top of all other fields with the name main_product_id!!!wrong indeed, if the javascript loads.... but it didn't because I put the js/ folder in the wrong place :blush::blush:

Highly unusual though that it needs to be copied to the webroot. I would suggest to move it to some folder relative to the shop. Is there a special reason why it's not in the includes/javascript/ folder?

It's not really the web root, but actually the ZC's root. Yeah we can move it to includes, just have to change the path.

yellow1912:

It's not really the web rootI have not looked at the code, but it certainly points to the webroot here.

Anyway, I reverted the code edits (so I am back to a stock Alpha 1 rev 39), moved the js/ folder, and it works great now :thumbsup:

Thanks paulm. If it really points to the root now then I really have fix that in the next release.

paulm:

I have not looked at the code, but it certainly points to the webroot here.

Anyway, I reverted the code edits (so I am back to a stock Alpha 1 rev 39), moved the js/ folder, and it works great now :thumbsup:

Question: I have your advance cross-sell mod installed. What does the "add product field" button in the New Cross Sells section do? It gives the following JS error when I click it:

Line: 25
Char: 2
Error: Object Expected
Code: 0
www....com/admin/xsell_advanced.php

Answer: This happens when your shop is located at the subfolder, for example: yoursite.com/shop
fix:
Is the js folder located at shop/ now? if yes please move it to the root folder (above shop).

Reason: The link to js file is hard-coded and assumes your shop files are located at root. Will try to fix this in the next version.

Regards.

yellow1912:

Question: I have your advance cross-sell mod installed. What does the "add product field" button in the New Cross Sells section do? It gives the following JS error when I click it:

Line: 25
Char: 2
Error: Object Expected
Code: 0
www....com/admin/xsell_advanced.php

Answer: This happens when your shop is located at the subfolder, for example: yoursite.com/shop
fix:
Is the js folder located at shop/ now? if yes please move it to the root folder (above shop).

Reason: The link to js file is hard-coded and assumes your shop files are located at root. Will try to fix this in the next version.

Regards.

This has fixed the problem for me too! Now it works on my test site which has zen in a subfolder htdocs/zen. I moved the js folder into htdocs and Presto! it works now.:clap:

Thanks!!!

Matt

Hi paulm,

Sorry for the late reply. I have just had the chance to look at the file you sent me, it looks like an useful and easy feature. I will try to have it in the new version soon, but not in a very near future, maybe the next 2 weeks. There are several reasons:

1. This mod was coded based on the old Advanced XSell mod, so the code behind looks very messy, I'll have to take time and clean it up. My goal is to code things that others can easily modify later.
2. Many of my projects due date are coming.

Regards,

Hi Yellow,

no problem, thanks for the reply :-) There is no hurry at all. Maybe I will just hack it into my copy of the cross sell code FTB. And when you got a new version ready including a cross sell copier I will update to that version.

I also have a modified xsell_products.php file which adds Buy Now buttons and quantity inputs and such to the catalog side of xsell. It was not intended for public release, but it might be handy as an example (it's works without problems, but it a.o. includes hardcoded texts). I don't know if you have plans to release a full xsell version and if you're interested, but if you are I can post or PM the code (but if you are not interested this thread might not be the best place to post it, I don't want to hijack the thread...).

paulm:

Hi Yellow,

no problem, thanks for the reply :-) There is no hurry at all. Maybe I will just hack it into my copy of the cross sell code FTB. And when you got a new version ready including a cross sell copier I will update to that version.

I also have a modified xsell_products.php file which adds Buy Now buttons and quantity inputs and such to the catalog side of xsell. It was not intended for public release, but it might be handy as an example (it's works without problems, but it a.o. includes hardcoded texts). I don't know if you have plans to release a full xsell version and if you're interested, but if you are I can post or PM the code (but if you are not interested this thread might not be the best place to post it, I don't want to hijack the thread...).

Hi Paulm,

I would definitely be interested in adding an add to cart button along with quantity box to the cross sell items! That would save extra clicks for my customers and streamline their shopping experience. Please post the code either here or in a new thread. I think it should be added to the mod, it's a very practical function!

Thanks!

Matt

Actually, my current mod does not touch any file belongs to the old Cross-Sell mod, which is working just fine. I will have to contact the author of that mod, asking for his permission before making any change.

My plan for all my mods, is to eventually move all the logic functions into classes, and clean up the code and html to make it easier for others to make any change.

Hi,

I've installed Advanced Cross sell as well as the original cross sell mod (as required) and it seems to run ok but the cross sell products are not showing up under the products. In other words nothing has changed from before I installed the mod. Is this a java problem? I've read some of the entries here and I have both the store and the js folder installed in root so I can't figure out what's wrong. ANy clues?

Jason

Copy your settings in Admin->configuration->Cross-sell here.

yellow1912:

Copy your settings in Admin->configuration->Cross-sell here.

Title Value Action
Input type to be used in form model
Display Cross-Sell Products 1
Display Cross-Sell Products 6
Cross-Sell Products Columns per Row 3
Cross-Sell - Display prices? true

It seems to set correctly. If your xsell products are not displayed on the product's page, check if you have installed the original XSell mod correctly (check all the steps again, if you are using a custom template then you have to edit you custom template, not the default one).

Please remember that my mod (currently) does not have anything to do with displaying the xsell products on the site, it simply makes it much more easier for you to cross-sell products in admin.

Hmm ok, I didn't realize your mod only enhanced the xsell mod. Xsell seems set up correctly too so I'll just have to do some research and figure out the problem.

Thanks!

Jason

Yes, I'm sorry that I could not help you.
There is one more thing you can check: if you know how to use phpmyadmin, use it to access the cross-sell table, see if it's set up correctly (product with id X cross-sell to product with id Y, etc...)

Hi,

I got it to work. I started from scratch and reinstalled xsell. I guess I missed something the first time around.

Many thanks!

Jason

lankeeyankee:

I would definitely be interested in adding an add to cart button along with quantity box to the cross sell items! That would save extra clicks for my customers and streamline their shopping experience. Please post the code either here or in a new thread.I decided to post what I have in another thread: http://www.zen-cart.com/forum/showthread.php?p=437261#post437261

yellow1912:

Actually, my current mod does not touch any file belongs to the old Cross-Sell mod, which is working just fine. I will have to contact the author of that mod, asking for his permission before making any changeIt's GPL, so you don't have to contact the author. Of course it's often wise to contact the author, and I assume you meant something along that line. But I doubt if there's someone available who's the current author of cross sell. There are many authors of pieces of cross sell code.

Hi there,

I seem to receive the following error but i'm not quite sure on how to fix it.

1146 Table 'wwwmaxg_zc1.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from zen_products p, zen_products_description pd, TABLE_PRODUCTS_XSELL px where p.products_id = pd.products_id and p.products_id = px.products_id and pd.language_id ='1' group by p.products_id]
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.

Now the table "TABLE_PRODUCTS_XSELL" exists within my database. I'm not too sure what is going wrong over here though. Any ideas on how to fix this?

Much Appreciated! :smile:

I was thinking about the error and was wondering whether it had to do with my input as I am getting this error when I input something and hit submit.

1146 Table 'wwwmaxg_zc1.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select count(products_id) as records from TABLE_PRODUCTS_XSELL where products_id = '12' and xsell_id = '13']
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.

Would products_id have to be zen_products_id as that is what is being shown in my database?