Cross Sell Advanced [Support Thread]

Thanks DrByte, I did the local/configure technique and help me figure out the errors of "duplicated keys" and fixing them. :clap:

Hi all,

2 things:

1. So the name that's on the page where you download & the name in the actual software are different. That's why there was some confusion. Looks like someone took the old version & updated it, & didn't create a new unique name.

2. The issue was the template files that go into the "includes/modules" folder. We didn't see any instructions for them. The instructions say to rename YOUR_TEMPLATE directory (singular), there's actually multiple directories that need to be changed. There is one under "includes/modules," & that also needs to be changed, & that solved that problem.

HTH

I am trying to translate the display for the customers into French.

I copied all the files from the "english" language folders in a "french" language folder, and translated everything i could see.
However, i can still see TEXT_XSELL_PRODUCTS displayed, and i have no clue where i might be missing the translation of that header. I am not even sure in what file.

Could you point me to the right place?

Use your admin's Tools->Developers' Tool Kit and search for TEXT_XSELL_PRODUCTS in all Catalog .php files. That will let you know where it's defined in the english version.

We're really going to have to find you something to do:P

IF you have filled everything in, you might have missed a single quote (')on that define. Search first with the developers toolkit for the TEXT_XSELL_PRODUCTS to find what file(s) it is in.

If it's NOT in two files (english and french), add it to the french to match the english.

If it IS in two files, the french version is the problem. Should look something like```
define('BOX_HEADING_MANUFACTURERS', 'Manufacturers');

Thank you. Fixed it (I should get a hang of that developer tool!)

I'm using version 1.5 and it works well for my site and products but I wonder if there is a way to include a small text message to each cross sell. My cross sells are substitutes for out of stock or unavailable products. These substitutes often have some differences from the original product. I already have the messages available and linked up in a local database and I fill the cross sell table from a homemade php socket. I need a text field maximum of 256 characters in size to display with each cross sell. I know that I'll need another column in my db table and I can load it via my homemade socket, but I need help with displaying it and adding an extra field on the admin page just in case I need to change an individual entry.

Hi, I have just added this mod onto my site.
Why do my products fall below each other (vertical) shouldn't they be side by side (horizontally) i.e 3 products per row and bigger?
If I change the column settings the list just moves from centre (1 per row) to the left (6 per row)

Using version 1.5.5f

Is this module compatible with 1.5.6?

ideasgirl:

Is this module compatible with 1.5.6?

I'd also like to know the answer to this...

Anyone know?

Thanks!

Confirmed Working with 1.5.6c! Thanks Developers and Support!!!

***Only issue I noticed is that "config.xsell" must be installed last.
When I copied that file before anything else in the "YOUR_ADMIN" folder, My Zen Kart Admin portal would return the error HTTP 500 Bad Request.

After installing each file, I make sure to refresh a random page on my website and refresh the Zen Kart Admin (YOURWEBSITE.COM/YOURADMIN).
This helped my find the issue much faster than in the past :)

For Tagging:
Cross Sell Advanced HTTP 500 Bad Request fix

I am working on a site that is v 1.5.7c
Will this mod work on v1.5.7c?

4tinak:

I am working on a site that is v 1.5.7c
Will this mod work on v1.5.7c?

Yes, it will - 100% compatible.

Hollywood691:

.It is displaying in catelog now, But says (TEXT_XSELL_PRODUCTS) how do I change that to say something else? New install v1.5.7c TEXT_XSELL_PRODUCTS is defined in product_info.php file but the TEXT_XSELL_PRODUCTS is displayed in box and now the "can we recommend?" as defined. Any suggestions on why the define is not working.

Is it compatible with 1.5.7c and ZCA bootstrap template? Any specific installation instructions?

Georgecy:

Is it compatible with 1.5.7c and ZCA bootstrap template? Any specific installation instructions?

I have installed the Cross sell advanced on 1.5.7.c with php 7.4 and mysql 5.7 and it gave the error below. Any comments are welcome.

PHP Fatal error: 3065:Expression #1 of ORDER BY clause is not in SELECT list, references column 'store_157c.xp.sort_order' which is not in SELECT list; this is incompatible with DISTINCT :: select distinct p.products_id, p.products_image, pd.products_name
from products_xsell xp, products p, products_description pd
where xp.products_id = '4400'
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.sort_order asc limit 6 ==> (as called by) /includes/modules/bootstrap/xsell_products.php on line 40 <== in /includes/classes/db/mysql/query_factory.php on line 170.

I've just submitted v2.0.0 of (now) Cross Sell Advanced II for the Zen Cart moderators' review and will post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=2334.

This version, based on v1.5 of Cross Sell Advanced (https://www.zen-cart.com/downloads.php?do=file&id=400:

• Requires Zen Cart 1.5.7 (fully-patched) or later.
• Is updated to support now-current versions of PHP and strict MySQL installations.
• Combines the processing of the previous version's two admin tools into one.
• Includes a Database I/O Manager (DbIo) handler, enabling import/export of the cross-sells via a .csv file.
• No more auto-deleting admin installation!
• Removes associated cross-sells when a product is removed.
• Includes integration with the ZCA Bootstrap template.

Early adopters can check out the updates on the plugin's GitHub repository: https://github.com/lat9/cross_sell_advanced

lat9:

I've just submitted v2.0.0 of (now) Cross Sell Advanced II for the Zen Cart moderators' review and will post back here when it's available for download at https://www.zen-cart.com/downloads.php?do=file&id=2334.

This version, based on v1.5 of Cross Sell Advanced (https://www.zen-cart.com/downloads.php?do=file&id=400:

• Requires Zen Cart 1.5.7 (fully-patched) or later.

• Is updated to support now-current versions of PHP and strict MySQL installations.

• Combines the processing of the previous version's two admin tools into one.

• Includes a Database I/O Manager (DbIo) handler, enabling import/export of the cross-sells via a .csv file.

• No more auto-deleting admin installation!

• Removes associated cross-sells when a product is removed.

• Includes integration with the ZCA Bootstrap template.

Early adopters can check out the updates on the plugin's GitHub repository: https://github.com/lat9/cross_sell_advanced
Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2334

My 1.5.7c doesn't appear to have zca_bootstrap. Is it needed for this add-on to work?

Elemi:

My 1.5.7c doesn't appear to have zca_bootstrap. Is it needed for this add-on to work?

So I went ahead and installed it, however when I add the /YOUR_ADMIN/includes/auto_loaders/config.xsell.php my admin crashes completely, and when I remove it I have full access again... here's the error log:

[09-Jan-2022 10:11:38 Pacific/Auckland] Request URI: /ditCh-yIE-joInt/whos_online.php?t=15, IP address: 222.155.5.136
#1 trigger_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php:164]
#5 require_once(/home/amoraromatherapy/public_html/ditCh-yIE-joInt/includes/init_includes/init_xsell_config.php) called at [/home/amoraromatherapy/public_html/includes/autoload_func.php:37]
#6 require(/home/amoraromatherapy/public_html/includes/autoload_func.php) called at [/home/amoraromatherapy/public_html/myadmin/includes/application_top.php:37]
#7 require(/home/amoraromatherapy/public_html/myadmin/includes/application_top.php) called at [/home/amoraromatherapy/public_html/myadmin/whos_online.php:11]
--> PHP Fatal error: 1146:Table 'amorarom_amordotcom.products_xsell' doesn't exist :: ALTER TABLE products_xsell
MODIFY COLUMN ID int(11) NOT NULL auto_increment,
MODIFY COLUMN products_id int(11) NOT NULL,
MODIFY COLUMN xsell_id int(11) NOT NULL,
MODIFY COLUMN sort_order int(11) NOT NULL DEFAULT 1 ==> (as called by) /home/amoraromatherapy/public_html/myadmin/includes/init_includes/init_xsell_config.php on line 164 <== in /home/amoraromatherapy/public_html/includes/classes/db/mysql/query_factory.php on line 170.

All manual template changes have been done.