Cross Sell Advanced [Support Thread]

DivaVocals:

The issue is with your theme, and not this module.. You will have to go back to Theme Forest and ask the template author to help you with this..

OK, I've asked the question at Theme Forrest, but I thought I'd send a small FYI here as well. I've managed to display the additional products (I had forgotten to rename a few of the admin folders. :frusty:). I've also managed to narrow the problem down to the tpl_modules_additional_images.php file located in \includes\templates\template_default\templates. This is the file that displays 'Search' right above the additional images. I have no idea what the problem is, but it seems that I can simply remove this file, without disrupting the display of additional images. :blink:

McLovin:

OK, I've asked the question at Theme Forrest, but I thought I'd send a small FYI here as well. I've managed to display the additional products (I had forgotten to rename a few of the admin folders. :frusty:). I've also managed to narrow the problem down to the tpl_modules_additional_images.php file located in \includes\templates\template_default\templates. This is the file that displays 'Search' right above the additional images. I have no idea what the problem is, but it seems that I can simply remove this file, without disrupting the display of additional images. :blink:
Let me start with the BIG warning first.. you NEVER EVER remove ANYTHING from or modify ANY files in the \includes\templates\template_default\ folders. This is the PARENT template for Zen Cart, and if your template modifies anything from the parent (default), then there will be an equivalent OVERRIDE file in your template folder for that file.

As for your issue, this REALLY is NOT an issue with this module.. If Theme Forest template authors would bother to code templates correctly to begin with (sadly most don't and most are not even REALLY familiar with Zen Cart) then merging in the template changes from this module should work just fine.. As it turns out they and their brethren over at Template Monstrosity, like to do one off kinds of crap things that lead to these kinds of discussions when one is installing modules which include template file changes..

I wish I could help, but if Theme Forrest has modified the product info page in a manner that prevents stock parts of it (like additional images) to stop working, you will have to work with the template author to get things working as they should.. If the author REALLY knows Zen Cart, this should be a breeze for him..

DivaVocals:

Let me start with the BIG warning first.. you NEVER EVER remove ANYTHING from or modify ANY files in the \includes\templates\template_default\ folders. This is the PARENT template for Zen Cart, and if your template modifies anything from the parent (default), then there will be an equivalent OVERRIDE file in your template folder for that file.

As for your issue, this REALLY is NOT an issue with this module.. If Theme Forest template authors would bother to code templates correctly to begin with (sadly most don't and most are not even REALLY familiar with Zen Cart) then merging in the template changes from this module should work just fine.. As it turns out they and their brethren over at Template Monstrosity, like to do one off kinds of crap things that lead to these kinds of discussions when one is installing modules which include template file changes..

I wish I could help, but if Theme Forrest has modified the product info page in a manner that prevents stock parts of it (like additional images) to stop working, you will have to work with the template author to get things working as they should.. If the author REALLY knows Zen Cart, this should be a breeze for him..

OK thanks, I'll let you know what it was (if I can correctly resolve it)!

Hello.

Our site has zen cart 1.3.8 and has this cross sell plugin, Cross Sell - Just Another Cross Sell Mod (https://www.zen-cart.com/downloads.php?do=file&id=477).

We will upgrade zen cart to 1.5.4 and was wondering if Cross Sell Advanced is a direct upgrade to the one we are using and if so will the installation be automatic after I uploaded the files or do I need to remove first any folder, files and database entries before installing Cross Sell Advanced.

Thanks.

dendelcruz:

Hello.

Our site has zen cart 1.3.8 and has this cross sell plugin, Cross Sell - Just Another Cross Sell Mod (https://www.zen-cart.com/downloads.php?do=file&id=477).

We will upgrade zen cart to 1.5.4 and was wondering if Cross Sell Advanced is a direct upgrade to the one we are using and if so will the installation be automatic after I uploaded the files or do I need to remove first any folder, files and database entries before installing Cross Sell Advanced.

Thanks.

Cross Sell - Just Another Cross Sell Mod is a completely different mod.. you will need to uninstall if you want to install this one..

DivaVocals:

Cross Sell - Just Another Cross Sell Mod is a completely different mod.. you will need to uninstall if you want to install this one..

I guess that is the only way. Will post questions if I encounter problems after installation. Thanks. :smile:

Cross-Sell Items not appearing after adding main item to cart. http://secure.edbeckphotography.com/shop

Zen Cart? 1.5.4
Is it a new install or an upgrade? New
What the addons/contributions you have installed? Tableau, Cross Sell Advanced v1.3 (This is the only version of Cross-Sell I've installed. The forum says that I don't need the previous version installed even though previous versions did.)
What customizations have you made? Just adding products and images through the admin panel.
What type of server are you using? inMotion Apache v. 2.2.27
Are you installing locally? No
What operating system? linux
What version of PHP is installed on the server? 5.3.28
What version of MYSQL is installed on the server?5.6.23
What you were doing when your problem occurred? Added product to shopping cart.
What are the steps to reproduce the problem?

1. go to https://secure.edbeckphotography.com/shop
2. Under "Categories" select "Real Estate Photography"
3. Select the "Up to 1,999 sq. ft. product and add to the cart.
4. The shopping cart summary appears, I expected the cross-sell products to be displayed. The cross-sell products for any of the houses are "Overnight Delivery" and "Mobile Web Site".

Have you attempted to fix the problem? Yes, though reading and trying different settings,

What steps have you taken?

Configuration:
Cross Sell Advanced
Title Value Action
Display Cross-Sell Products Minimum 1 Info
Display Cross-Sell Products Maximum 6 Info
Cross-Sell Products Columns per Row 3 Info
Cross-Sell - Display prices? true
Cross Sell Advanced Version 1.3 Info

Current Cross-Sells

Product Name No. of Current Cross-Sells Action
Up to 1,999 sq.ft. 2 Edit Cross Sell Delete Cross Sell
2,000 - 2,999 sq. ft. 2 Edit Cross Sell Delete Cross Sell
3,000 - 4,499 sq. ft. 2 Edit Cross Sell Delete Cross Sell
4,500 - 5,999 sq. ft 2 Edit Cross Sell Delete Cross Sell
6,000 - 7,500 sq. ft 2 Edit Cross Sell Delete Cross Sell
Academic Year Subscription 1 Edit Cross Sell Delete Cross Sell
Banquet Posters 2 Edit Cross Sell Delete Cross Sell
Package A - Ultimate 6 Edit Cross Sell Delete Cross Sell
Package B - Deluxe 6 Edit Cross Sell Delete Cross Sell
Package C - Classic 6 Edit Cross Sell Delete Cross Sell
Package D - Basic 6 Edit Cross Sell Delete Cross Sell

Displaying 1 to 20 (of 23 products) << Page of 2 >>
Product Id Product Name Current Cross-Sells Update Cross-Sells
2 Up to 1,999 sq.ft.

1. Overnight Delivery (before noon the next day)
2. Mobile Web Site

How do I get the cross-sell products to display after a customer selects and adds a product to the shopping cart?

Thanks

Short answer is that you would need to modify this module to support displaying cross sell items in the shopping cart..

From the module description (please note the highlighted portion):

How Does Advanced Cross Sell Work??
=============================
The shop sells Walkmans.. If the shopowner/administrator adds cross sell products to the Walkman product via the Advanced Cross Sell interfaces, the product page will now includes a new centerbox.. "may we also recommend batteries, case cd's etc."

edbeck:

Cross-Sell Items not appearing after adding main item to cart. http://secure.edbeckphotography.com/shop

Zen Cart? 1.5.4
Is it a new install or an upgrade? New
What the addons/contributions you have installed? Tableau, Cross Sell Advanced v1.3 (This is the only version of Cross-Sell I've installed. The forum says that I don't need the previous version installed even though previous versions did.)
What customizations have you made? Just adding products and images through the admin panel.
What type of server are you using? inMotion Apache v. 2.2.27
Are you installing locally? No
What operating system? linux
What version of PHP is installed on the server? 5.3.28
What version of MYSQL is installed on the server?5.6.23
What you were doing when your problem occurred? Added product to shopping cart.
What are the steps to reproduce the problem?

1. go to https://secure.edbeckphotography.com/shop
2. Under "Categories" select "Real Estate Photography"
3. Select the "Up to 1,999 sq. ft. product and add to the cart.
4. The shopping cart summary appears, I expected the cross-sell products to be displayed. The cross-sell products for any of the houses are "Overnight Delivery" and "Mobile Web Site".

Have you attempted to fix the problem? Yes, though reading and trying different settings,

What steps have you taken?

Configuration:
Cross Sell Advanced
Title Value Action
Display Cross-Sell Products Minimum 1 Info
Display Cross-Sell Products Maximum 6 Info
Cross-Sell Products Columns per Row 3 Info
Cross-Sell - Display prices? true
Cross Sell Advanced Version 1.3 Info

Current Cross-Sells

Product Name No. of Current Cross-Sells Action
Up to 1,999 sq.ft. 2 Edit Cross Sell Delete Cross Sell
2,000 - 2,999 sq. ft. 2 Edit Cross Sell Delete Cross Sell
3,000 - 4,499 sq. ft. 2 Edit Cross Sell Delete Cross Sell
4,500 - 5,999 sq. ft 2 Edit Cross Sell Delete Cross Sell
6,000 - 7,500 sq. ft 2 Edit Cross Sell Delete Cross Sell
Academic Year Subscription 1 Edit Cross Sell Delete Cross Sell
Banquet Posters 2 Edit Cross Sell Delete Cross Sell
Package A - Ultimate 6 Edit Cross Sell Delete Cross Sell
Package B - Deluxe 6 Edit Cross Sell Delete Cross Sell
Package C - Classic 6 Edit Cross Sell Delete Cross Sell
Package D - Basic 6 Edit Cross Sell Delete Cross Sell

Displaying 1 to 20 (of 23 products) << Page of 2 >>
Product Id Product Name Current Cross-Sells Update Cross-Sells
2 Up to 1,999 sq.ft.

1. Overnight Delivery (before noon the next day)
2. Mobile Web Site

How do I get the cross-sell products to display after a customer selects and adds a product to the shopping cart?

Thanks

DivaVocals:

Short answer is that you would need to modify this module to support displaying cross sell items in the shopping cart..

From the module description (please note the highlighted portion):

Is there a long answer? I've looked all over for where to configure it.

edbeck:

Is there a long answer? I've looked all over for where to configure it.
Modify = Create new custom code to extend the module's current functionality to include NEW functionality.

It's not a "configuration" thing, it's a "you would need to write new code for this module to add the feature you want" thing..

Now that said if a community member has the code to share or the time to write and share this code they will.. Otherwise, you might want to look at the other cross sell modules and see if they have the feature you are looking for or you might consider utilizing the services of a developer to create the code you are after..

G'day,

If someone is looking to enhance this plugin it would be really nice if given a list of n products, the mod had an option (checkbox) to ask it to automatically go through and cross-sell EACH combination together.

For example, if you give it 3 products: A, with cross sell to B and C, it could optionally cross-sell:
A to B and C,
B to A and C, and
C to A and B.

Obviously the larger n is, the greater the admin time saving would be.

Best regards, Lloyd Borrett.

lloyd_borrett:

G'day,

If someone is looking to enhance this plugin it would be really nice if given a list of n products, the mod had an option (checkbox) to ask it to automatically go through and cross-sell EACH combination together.

For example, if you give it 3 products: A, with cross sell to B and C, it could optionally cross-sell:
A to B and C,
B to A and C, and
C to A and B.

Obviously the larger n is, the greater the admin time saving would be.

Best regards, Lloyd Borrett.

There are other cross sell modules that may already provide this functionality.. Suggest looking at one of those if you want the feature.. It's likely why no one has ever enhanced this one beyond it's current featureset..

Hello, I'm having a problem with cross_sell_plus_advanced_combo_1.3. I'm running Zencart 1.5.4 which I updated to back in May of 2015. Before that I had been using this addon through many versions back to maybe 1.3.x and always appreciated its functionality. Decided to give it another try on my locally hosted test site (Mac OS X 10.8). I downloaded the latest version 1.3a and reuploaded the files to their proper places (checked it closely several times to make sure I hadn't dropped something in the wrong place. Went back to the admin page (running in the latest version of Firefox) and got a big white screen with this message- WARNING: An Error occurred, please refresh the page and try again. Maybe it was luck, maybe I remembered from the last try but the first file I pulled out of the configuration - config.xsell.php - fixed it. Well at least admin worked again but no configuration menu and no cross-sell. And the other thing, if I remember right, there used to be a sql patch that needed to be installed. Doesn't seem to be one in the new version. If the new version depends on an existant sql patch maybe mine disappeared along the upgrade path. Any suggestions would be appreciated as I did see this problem mentioned earlier in the thread

One little addition. The Table: products_xsell is still in the database. I checked it with phpmyadmin.

Ok, a month or so later, I noticed a bump up in the version of this mod to cross_sell_plus_advanced_combo_1.3 2, so I had another go at it. Went through and striped out any files from older versions ( I've got several old ones in my downloads folder.) Don't think I missed any. But still the same results - admin/includes/auto_loaders/config.xsell.php breaks the admin and triggers the "WARNING: An Error occurred, please refresh the page and try again." Pull config.xsell.php out and admin comes back. Sill in Zencart 1.5.4.

I checked in in server of mine running Zencart 1.5.1 to check what products were entered in cross-sell and then went back to my current install and realized that they were still working. Unfortunately, I have no cross sell and advanced cross sell in my drop down catalog menu so I can't add new products to the cross sell data base, which I really need to do.

Any suggestions would sure be appreciated. I really miss this modules.

Thanks

roeghar:

breaks the admin and triggers the "WARNING: An Error occurred, please refresh the page and try again."
That usually indicates a SQL error, and its details are in your /logs/ folder on the server.
This FAQ (which I find by using the Search and pasting in the error message) speaks directly to that issue: http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

Thank you DrByte for getting back to me. This is what myDEBUG reports:

[22-Jan-2016 17:44:29 America/Chicago] PHP Fatal error: 1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 'unq_config_key_zen' :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Display Cross-Sell Products Minimum', 'MIN_DISPLAY_XSELL', '1', 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', '86', 20, NULL, now(), NULL, NULL) ==> (as called by) /Library/WebServer/Documents/jokgha/includes/init_includes/init_xsell_config.php on line 69 <== in /Library/WebServer/Documents/includes/classes/db/mysql/query_factory.php on line 155

I mucked about in the files and tried to enable STRICT_ERROR_REPORTING but that didn't seem to yield any more information. I'm afraid I just don't understand what "Duplicate entry 'MIN_DISPLAY_XSELL' for key 'unq_config_key_zen' " means or how to correct it. Every thing about my local of line site works fine.

Here are its values:Server Host: www.esftestsite (127.0.0.1) Database Host: localhost (127.0.0.1)
Server OS: Darwin 12.6.0 Database: MySQL 5.5.41
Server Date: 01/23/2016 14:36:59 Database Date: 01/23/2016 14:36:59
Server Up Time: 14:36 up 2 days, 19:55, 1 user, load averages: 0.58 0.68 0.71 HTTP Server: Apache/2.2.29 (Unix) DAV/2 PHP/5.3.29 mod_ssl/2.2.29 OpenSSL/0.9.8zd
PHP Version: 5.3.29 (Zend: 2.3.0) PHP Memory Limit: 128M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 2M POST Max Size: 8M
Database Data Size: 141,787 kB Database Index Size: 3,702 kB

I checked out your post 1062: Duplicate entry 'xxxxxx' for key which seems to be relevant to this problem but an not sure as only the cross-sell module seems to be affected.

Not sure what to do next.

You probably have remnants of a previous cross that did not get uninstalled completely before installing this version
Using phpmyadmin search for the key in configuration
MIN_DISPLAY_XSELL
and then delete it

Thanks to both gilby and DrByte

First, I carefully repeated the edits to cache.php and sessions.php to make sure I hadn't messed up in making the changes. Still the same results: admin works fine with the edits until config.xsell.php is dropped into the auto_loaders folder. The only change is in the error message. Now returns: "WARNING: An Error occurred, please refresh the page and try again."

Next, I searched and found in phpmyadmin the MIN_DISPLAY_XSELL configuration entry and deleted it. No change, same result. Then I also deleted MAX_DISPLAY_XSELL to see if that might help. Same results. Same error message.

Again, I'm stuck. I appreciate the suggestions and am open to whatever else anyone can suggest.

Hi all,

I am using ZC 1.5.4, rebuild / upgrade it on a testing folder .. (Before running ZC 1.5.1 on Live)
On the ZC 1.5.1 it work well WITH Cross Sell 1.3.1 Modules.

Now, on ZC 1.5.4 I am experience error of the Cross Sell 1.3.1 modules, it show this error at log
PHP Warning: mysql_query(): Access denied for user in admin/xsell.php on line 151
PHP Warning: mysql_query(): A link to the server could not be established in admin/xsell.php on line 151
PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in admin/xsell.php on line 170

Ok, I know it is abit off topic above ... now go the key point ....

Do Cross Sell Advanced 1.3a now still need Cross Sell First??? (Since on the early version I see a notice text it depend on Cross Sell this Modules)

Thank you.

Best Regards,
Jimmy Chan