Cross Sell Advanced [Support Thread]

Establishing a formal support thread for Cross Sell Advanced as there has never been one.

Based on the original Cross Sell module! It is easy to use, has a graphical interface to quickly find products to cross sell and is very light weight. 6 cross sell products can set specifically set for each of your Zen Cart product pages.

Cross Sell Advanced expands the original Cross Sell for even more ease of use by allowing you to setup 6 cross sells using the product model numbers.

Download it here: http://www.zen-cart.com/downloads.php?do=file&id=400

So is this an UPGRADE to the previous version of your cross sell or can it be a STAND ALONE install? I dont see a products_xsell.sql file with the 1.3 download. Thank you.

Nevermind, i just noticed the requirements.....this is an upgrade

"REQUIREMENTS: It REQUIRES cross sell to be installed."

Quote:

---

Originally Posted by SavaTom

Nevermind, i just noticed the requirements.....this is an upgrade

"REQUIREMENTS: It REQUIRES cross sell to be installed."

---

No it doesn't.. This is an UPGRADE of the original Cross Sell module.. The description is incorrect.. it SHOULD read:

Quote:

---

Based on the original Cross Sell module! It is easy to use, has a graphical interface to quickly find products to cross sell and is very light weight. 6 cross sell products can set specifically set for each of your Zen Cart product pages.


Advanced Cross Sell expands the original Cross Sell for even more ease of use by allowing you to setup 6 cross sells using the product model numbers.

---

Quote:

---

Originally Posted by SavaTom

Nevermind, i just noticed the requirements.....this is an upgrade

"REQUIREMENTS: It REQUIRES cross sell to be installed."

---

Module description has been updated to reflect the current codebase:

Quote:

---

A new and improved version of the original Cross Sell module!

What is Cross Selling??
=================
Cross selling is a suggestive selling method where the shopowner offers customers the opportunity to purchase items related to the product they are viewing.

Out the box, Zen Cart includes a "Customers who bought this product also purchased.." centerbox so that whenever a customer purchases an item, it looks and finds other customers who also purchased the same item and selects other products they purchased.

But what if the shopowner wanted to select specific related items to offer their customers? Advanced Cross Sell adds this exact kind of functionality.

Advanced Cross Sell has a graphical interface to quickly find products for cross selling. Set up to six (6) optional products per product for each Zen Cart product page. Additionally this module has an advanced cross sell user interface which allows the shopowner/administrator to setup all six (6) cross sells on the same screen using products numbers.

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."

---

You ONLY need to install this module..

If you were previously using a different version of this plugin, the auto installer doesn't remove the old database entries. The logic could be improved so that duplicate DB entry errors are not a problem.

Maybe I am not reading the code right in the file:
YOUR_ADMIN\includes\init_includes\init_xsell_config.php

but if there wasn't an old version or a previous version to clean up, wouldn't this end up deleting the configuration_keys for:
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

I have not tried to install this, but I was peeking at the code and it made me start to wonder about doom and gloom ... :lookaroun

Quote:

---

Originally Posted by numinix

If you were previously using a different version of this plugin, the auto installer doesn't remove the old database entries. The logic could be improved so that duplicate DB entry errors are not a problem.

---

If you are seeing this then perhaps you are right.. I'm not seeing the problem for no other reason except that I'm not really a true code monkey.. so perhaps a HINT on what the issue is would be most appreciated.. :smile:

Quote:

---

Originally Posted by Ajeh

Maybe I am not reading the code right in the file:
YOUR_ADMIN\includes\init_includes\init_xsell_config.php

but if there wasn't an old version or a previous version to clean up, wouldn't this end up deleting the configuration_keys for:
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX

I have not tried to install this, but I was peeking at the code and it made me start to wonder about doom and gloom ... :lookaroun

---

I'm not sure how this would happen since the delete statements target ONLY the Cross Sell configuration entries and groups.. But again, I'm not seeing the problem for no other reason except that I'm not really a true code monkey.. a hint as to where the issue lies would be appreciated.. :smile:

In that file, you check for the configuration_group_id in the configuration_group table then Delete for that value in the configuration table ...

Code:

---

        /* Find configuation group ID of Previous Version of Cross Sell */
        $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$xsell_old_menu_title."' LIMIT 1";
        $result = $db->Execute($sql);
        $xsell_old_configuration_id = $result->fields['configuration_group_id'];

        /* Remove Previous Version of Cross Sell from the configuration group table */
        $sql = "DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
        $db->Execute($sql);

        /* Remove Previous Version of Cross Sell items from the configuration table */
        $sql = "DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
        $db->Execute($sql);

---

But if nothing is found on the configuration_group, the value is probably going to be 0 for $xsell_old_configuration_id so you first delete from the configuration_group table where the configuration_group_id is 0 which should probably not cause any harm but is not a good idea ...

The problem is you then delete in the configuration table for that configuration_group_id and the 0 is the configuration_group_id for these 3 values in the configuration table ...

So, rather than deleting for what you mean to delete for, you delete important configuration_keys for Zen Cart ...

This thread better explains the issue:
http://www.zen-cart.com/showthread.p...ag-not-working

and post #9 is a nice write up by swguy explaining the specifics of the issue with a possible better approach to this ...

NOTE: you really need to read through that file to find any other similar issues ...

Quote:

---

Originally Posted by Ajeh

NOTE: you really need to read through that file to find any other similar issues ...

---

Well if I run the query

Code:

---

SELECT configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'Deluxe Cross Sell' LIMIT 1;

---

I get zero results. So wouldn't the delete statement be deleting nothing and NOT the 0 configuration group???

Quote:

---

Originally Posted by DivaVocals

Well if I run the query

Code:

---

SELECT configuration_group_id FROM zen_configuration_group WHERE configuration_group_title = 'Deluxe Cross Sell' LIMIT 1;

---

I get zero results. So wouldn't the delete statement be deleting nothing and NOT the 0 configuration group???

---

I see that this is the same thing going on when I asked in the Testimonials manager about those inserts in the uninstall sql. And Ajeh responded that those are 3 stock configs for ZC. After research under certain circumstances it can remove the 3 stock configs. So the 3 inserts plus another for IH was there as a safety when the sql deletes the id for 0.

After reading, there has to be a "and xxx != 0" as a fallback in case the mod id equates to 0.

I would suggest posting your full proposed fix, before contributing it so that it can be checked ...

Not the SAME thing at all.. The Testimonials Manager SQL is just plain old WRONG because it inadvertently sets a configuration group id variable to configuration group '0'. (read my response in that thread -- I DO state the issue and solution)

The SQL in question for this module DOES NOT do this..

Quote:

---

Originally Posted by grantopt

I see that this is the same thing going on when I asked in the Testimonials manager about those inserts in the uninstall sql. And Ajeh responded that those are 3 stock configs for ZC. After research under certain circumstances it can remove the 3 stock configs. So the 3 inserts plus another for IH was there as a safety when the sql deletes the id for 0.

After reading, there has to be a "and xxx != 0" as a fallback in case the mod id equates to 0.

---

No fall back required.. simply DO NOT set a variable for configuration group id '0'.. Just don't write SQL scripts which delete ANYTHING from configuration_group '0'

Quote:

---

Originally Posted by Ajeh

I would suggest posting your full proposed fix, before contributing it so that it can be checked ...

---

Are you responding to my previous post.. because HONESTLY I am still not seeing the issue with the SQL.. If I query for a configuration group that does not exist, I can't possibly delete anything from it let alone configuration group ID '0'.. I WANT to fix it if it's broken, but I'm REALLY not understanding why it's wrong..

**confused**

As I tiptoe :lookarouninto the discussion, I'd like to propose the following changes to the code fragment that Ajeh posted in post #9. The issue, as I see it, is that if the 'old title' didn't exist, the $result object wouldn't have any fields and, with mySQL's conversion in effect the value '$xsell_old_configuration_id' would be magically converted to (you guessed it) 0.

Code:

---

/* Find configuation group ID of Previous Version of Cross Sell */
        $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$xsell_old_menu_title."' LIMIT 1";
        $result = $db->Execute($sql);
        $xsell_old_configuration_id = $result->fields['configuration_group_id'];

        /* Remove Previous Version of Cross Sell from the configuration group table */
        $sql = "DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
        $db->Execute($sql);

        /* Remove Previous Version of Cross Sell items from the configuration table */
        $sql = "DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
        $db->Execute($sql);

---

I'd suggest a small recoding of the fragment as follows:

Code:

---

/* Find configuation group ID of Previous Version of Cross Sell */
        $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$xsell_old_menu_title."' LIMIT 1";
        $result = $db->Execute($sql);
        // -----
        // Only remove the old configuration if it exists!
        //
        if (!$result->EOF) {
          $xsell_old_configuration_id = $result->fields['configuration_group_id'];

          /* Remove Previous Version of Cross Sell from the configuration group table */
          $sql = "DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
          $db->Execute($sql);

          /* Remove Previous Version of Cross Sell items from the configuration table */
          $sql = "DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
          $db->Execute($sql);
        }

---

As a test, temporarily create the file:
/your_secret_admin/test_delete.php

with the code:

Code:

---

<?php
require('includes/application_top.php');


    $xsell_old_menu_title = 'Cross Sell';
    $xsell_menu_title = 'Cross Sell Advanced';
    $xsell_menu_text = 'Cross Sell Advanced Configuration';

echo 'Previous Version of Cross Sell: ' . '<br><br>';
      /* Find configuation group ID of Previous Version of Cross Sell */
      $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$xsell_old_menu_title."' LIMIT 1";
echo 'XSELL CODE what would be deleted TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';
      $result = $db->Execute($sql);
        $xsell_old_configuration_id = $result->fields['configuration_group_id'];
echo '$xsell_old_configuration_id set to: ' . $xsell_old_configuration_id . '<br><br>';

      /* Remove Previous Version of Cross Sell from the configuration group table */
      $sql = "DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
//        $db->Execute($sql);
echo 'XSELL CODE what would be deleted TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';


// test results with SELECT
echo '==================================' . '<br><br>';
      $sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
      $chk_sql =  $db->Execute($sql);
echo 'TEST XSELL CODE what SELECT finds in TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';
echo '<strong>RecordCount found TABLE_CONFIGURATION_GROUP: ' . $chk_sql->RecordCount() . '</strong><br>';

// if found what would be deleted
while (!$chk_sql->EOF) {
  echo 'configuration_group_id: ' . $chk_sql->fields['configuration_group_id'] . '<br><br>';
  $chk_sql->MoveNext();
}

// test results with SELECT
      /* Remove Previous Version of Cross Sell items from the configuration table */
      $sql = "DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
echo '==================================' . '<br><br>';
echo 'TEST XSELL CODE what would be deleted TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
echo '$xsell_old_configuration_id set to: ' . $xsell_old_configuration_id . '<br><br>';
echo 'XSELL CODE what DELETE would be run on TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
//        $db->Execute($sql);
      $sql = "SELECT * FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
      $chk_sql =  $db->Execute($sql);

echo 'XSELL CODE what SELECT finds in TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
echo '<strong>RecordCount found TABLE_CONFIGURATION: ' . $chk_sql->RecordCount() . '</strong><br><br>';

echo 'What would be removed: ' . '<br>';
// if found what would be deleted
while (!$chk_sql->EOF) {
  echo 'configuration_key: ' . $chk_sql->fields['configuration_key'] . '<br>';
  $chk_sql->MoveNext();
}
echo '==================================' . '<br><br>';

---

While kind of a scrappy file, it would show you the results of what gets deleted if there isn't a value for: $xsell_old_configuration_id

and what would end up deleted from the configuration table ...

This will not delete anything as it uses SELECTS rather than actual DELETE on the tables but does show you the content of the $sql and what keys would get wiped out ...

Lat9's fix would add a safety on this portion of the code, and it needs to be done similarly on anything else doing DELETE in this file ...

Quote:

---

Originally Posted by Ajeh

As a test, temporarily create the file:
/your_secret_admin/test_delete.php

with the code:

Code:

---

<?php
require('includes/application_top.php');


    $xsell_old_menu_title = 'Cross Sell';
    $xsell_menu_title = 'Cross Sell Advanced';
    $xsell_menu_text = 'Cross Sell Advanced Configuration';

echo 'Previous Version of Cross Sell: ' . '<br><br>';
      /* Find configuation group ID of Previous Version of Cross Sell */
      $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$xsell_old_menu_title."' LIMIT 1";
echo 'XSELL CODE what would be deleted TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';
      $result = $db->Execute($sql);
        $xsell_old_configuration_id = $result->fields['configuration_group_id'];
echo '$xsell_old_configuration_id set to: ' . $xsell_old_configuration_id . '<br><br>';

      /* Remove Previous Version of Cross Sell from the configuration group table */
      $sql = "DELETE FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
//        $db->Execute($sql);
echo 'XSELL CODE what would be deleted TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';


// test results with SELECT
echo '==================================' . '<br><br>';
      $sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
      $chk_sql =  $db->Execute($sql);
echo 'TEST XSELL CODE what SELECT finds in TABLE_CONFIGURATION_GROUP <br>$sql: ' . $sql . '<br><br>';
echo '<strong>RecordCount found TABLE_CONFIGURATION_GROUP: ' . $chk_sql->RecordCount() . '</strong><br>';

// if found what would be deleted
while (!$chk_sql->EOF) {
  echo 'configuration_group_id: ' . $chk_sql->fields['configuration_group_id'] . '<br><br>';
  $chk_sql->MoveNext();
}

// test results with SELECT
      /* Remove Previous Version of Cross Sell items from the configuration table */
      $sql = "DELETE FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
echo '==================================' . '<br><br>';
echo 'TEST XSELL CODE what would be deleted TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
echo '$xsell_old_configuration_id set to: ' . $xsell_old_configuration_id . '<br><br>';
echo 'XSELL CODE what DELETE would be run on TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
//        $db->Execute($sql);
      $sql = "SELECT * FROM ".TABLE_CONFIGURATION." WHERE configuration_group_id ='".$xsell_old_configuration_id."'";
      $chk_sql =  $db->Execute($sql);

echo 'XSELL CODE what SELECT finds in TABLE_CONFIGURATION <br>$sql: ' . $sql . '<br><br>';
echo '<strong>RecordCount found TABLE_CONFIGURATION: ' . $chk_sql->RecordCount() . '</strong><br><br>';

echo 'What would be removed: ' . '<br>';
// if found what would be deleted
while (!$chk_sql->EOF) {
  echo 'configuration_key: ' . $chk_sql->fields['configuration_key'] . '<br>';
  $chk_sql->MoveNext();
}
echo '==================================' . '<br><br>';

---

While kind of a scrappy file, it would show you the results of what gets deleted if there isn't a value for: $xsell_old_configuration_id

and what would end up deleted from the configuration table ...

This will not delete anything as it uses SELECTS rather than actual DELETE on the tables but does show you the content of the $sql and what keys would get wiped out ...

Lat9's fix would add a safety on this portion of the code, and it needs to be done similarly on anything else doing DELETE in this file ...

---

At last.. thanks ladies.. It's not that I didn't believe there WAS a problem.. I just wasn't quite sure how it was an issue (thanks for the explanation lat9!! I GET IT now.. :laugh:) I will make the change and re-submit when I return from New York next week..

GIRL POWER ROCKS!!!

Again, you might post your customizations for this file before you submit it to the add-ons to ensure the fixes are complete ...

Quote:

---

Originally Posted by Ajeh

Again, you might post your customizations for this file before you submit it to the add-ons to ensure the fixes are complete ...

---

yes ma'am will do!:cool:

I installed the cross sell advanced on a 1.5.1 cart. I see that the cross sell advanced requires model numbers in order to use it. The problem is this shop is not using model numbers and there isn't a setting in the configuration to switch to using product ID's instead. Is there a way around this?

thanks

Quote:

---

Originally Posted by buildingblocks

I installed the cross sell advanced on a 1.5.1 cart. I see that the cross sell advanced requires model numbers in order to use it. The problem is this shop is not using model numbers and there isn't a setting in the configuration to switch to using product ID's instead. Is there a way around this?

thanks

---

Use Catalog > Cross-Sell (X-Sell) Admin to set up your cross sell products..

well yes, thanks. I was just hoping there might be a simple code change to be able to use cross sell admin advanced with product ID's. I recall one of the previous versions of cross sell had that option.

Quote:

---

Originally Posted by buildingblocks

well yes, thanks. I was just hoping there might be a simple code change to be able to use cross sell admin advanced with product ID's. I recall one of the previous versions of cross sell had that option.

---

Not this particular version of Cross Sell..

ok, thanks for responding.

Thank you for this mod, just downloaded the latest and installed on 1.5.1 ZC. Everything looks fine in admin, I was able to add a product as a trial, but now my product display got messed up. The zooming function is gone and I do not see the cross sell product. I switched to classic template just to see how is it there. The main product displays fine, but I do not see the cross sell product appear there either. I replaced the tpl_product_info_display.php back to the original one to see if my product will display the normal way again. It does. This is a freshly installed ZC with a custom template. This is the first time I installed the Cross Sell Advanced Combo.
Any ideas or thoughts, please?
Thank you,
Peter

I must be missing something. I'm installing fresh into 1.5.3. Running the classic template

Within admin I can see and configure Advanced Cross-sell. Have an item that has 5 items listed in "Current Cross-Sells". Tried recopying the template directory patches but still no items display

Catch is when I refresh the page of the item, it doesn't show anything. If I enable "also purchased" I see those items below. Turned off also purchase and refreshed, those items go away with a refresh.

So wondering did I miss part of the install, or is there a place to enable or set the display position for cross sell?

Thanks in advance

Quote:

---

Originally Posted by loveofthehorse

I must be missing something. I'm installing fresh into 1.5.3. Running the classic template

Within admin I can see and configure Advanced Cross-sell. Have an item that has 5 items listed in "Current Cross-Sells". Tried recopying the template directory patches but still no items display

Catch is when I refresh the page of the item, it doesn't show anything. If I enable "also purchased" I see those items below. Turned off also purchase and refreshed, those items go away with a refresh.

So wondering did I miss part of the install, or is there a place to enable or set the display position for cross sell?

Thanks in advance

---

Since you didn't post a link so I can SEE things.. my GUESS is that you need to re-examine your template file merges.. Sounds like you have the cross sell module code INSIDE the if statement for "also purchased" items.. (Which is why it only appears when "also purchased" is on..

Now that said until and UNLESS you post a link I will not GUESS anymore on the solution..

Quote:

---

Originally Posted by petergy

Thank you for this mod, just downloaded the latest and installed on 1.5.1 ZC. Everything looks fine in admin, I was able to add a product as a trial, but now my product display got messed up. The zooming function is gone and I do not see the cross sell product. I switched to classic template just to see how is it there. The main product displays fine, but I do not see the cross sell product appear there either. I replaced the tpl_product_info_display.php back to the original one to see if my product will display the normal way again. It does. This is a freshly installed ZC with a custom template. This is the first time I installed the Cross Sell Advanced Combo.
Any ideas or thoughts, please?
Thank you,
Peter

---

Yep.. sounds like you need to re-merge your template files with the ones in this module..

Hi, I have this mod installed and it has been working well but I now have a small problem...

I had the same 6 items on all my products as 'cross sell' items, however one of these is now discontinued so only 5 images are showing up. I would like to add another similar product but is there a way to do this in one go rather than have to add it on to each product individually? There are almost 200 products I need to add this new cross sell on so it would take hours doing one at a time.

Hello, I see in the previous posts that there were some possible issues that were found but I don't see a recent version submitted. Is the Cross Sell Advanced good to go for v1.5.3?

Thank you for taking the time to work on this mod.

Hi,

I cannot login my admin after installing the module. It is saying WARNING: An Error occurred, please refresh the page and try again.

I have used a older version which didnt work after the Zen Cart 1.5.3 update.

Quote:

---

Originally Posted by pascal020

Hi,

I cannot login my admin after installing the module. It is saying WARNING: An Error occurred, please refresh the page and try again.

I have used a older version which didnt work after the Zen Cart 1.5.3 update.

---

Can you post the contents of your debug logs (use [ code] tags via the # button on the forum when posting)?

Hi,

I used the Strict_error tool and got:
1062 Duplicate entry 'MIN_DISPLAY_XSELL' for key 'unq_config_key_zen'

Deleted the table and now it is working

Thanks

Cant login to my admin after uploading the files (yes I followed instructions and renamed admin folder correctly and renamed the your template folders correctly, etc, etc. Below is the error log file. I have omitted my domain from the path.

white screen of death...

WARNING: An Error occurred, please refresh the page and try again.

error log...

1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: 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', '76', 20, NULL, now(), NULL, NULL) in /var/www/vhosts/1/124646/webspace/httpdocs/myprivatedomain/includes/classes/db/mysql/query_factory.php on line 120

that smiley in the error log is from the forum...

the correct syntax is

1062 : Duplicate

with no spaces

i should note i am using ZC 1.51

Code:

---

1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: 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', '85', 20, NULL, now(), NULL, NULL) in /var/www/vhosts/1/124646/webspace/httpdocs/myprivatedomain/includes/classes/db/mysql/query_factory.php on line 120

---

Ok, i figured it out, nevermind any of my posts. Here was the problem.

So, I backed up my site and moved it to another host.

What happened was my site has the old "Cross Sell Plus Advanced Sell Combo" here http://www.zen-cart.com/downloads.php?do=file&id=1364

I forgot I was using that version and tried to load the new version called "Cross Sell Advanced" here http://www.zen-cart.com/downloads.php?do=file&id=400

DONT DO THAT!

SavaTom, I have run into the same problem you had. I am getting the error message - 1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: etc...

Were you able to get the new version working? What did you have to do?

I really don't want to keep the old version since it is now basically obsolete.

Thanks for any help you can give me.

Quote:

---

Originally Posted by traci

SavaTom, I have run into the same problem you had. I am getting the error message - 1062:Duplicate entry 'MIN_DISPLAY_XSELL' for key 2 :: etc...

---

Sorry for being so slow to a response. Problem is most likely you have (or in the past had) another XSELL module installed. The fix is generally to remove the other module (or older version of this module) before trying to install the current version of this module.

Alternately one could try to remove the old configuration key from the database manually, but one may run into additional issues unless the old module (database entries and files) are removed (and any modified files have the changes reverted).

Removing the configuration key (SQL - assumes no db_prefix in configure.php):

Code:

---

DELETE FROM `configuration` WHERE `configuration_key`='MIN_DISPLAY_XSELL';

---

Hmmmmmmm.. I'll have to take a looksee at the readme and make adjustments accordingly..

Is this mod suitable for use on version 1.3.9h ? (Not upgrading site to 1.5.x) - if not is there a similar mod that is suitable for 1.3.9h?

thanks, Mike

Dunno.. Didn't test this with v1.3.9 when I updated this because v1.3.x versions are no longer officially supported.. If you have a dev store, you can install and test..

Hello Diva,

I am looking for something similar to work in the cart - wrote the following earlier based on cart before I read the mod readme and see it relates to product pages - do you know of anything that can do the following?

- with this mod can I add a single product, the same item every time, to the cart for any and every product a customer may add to the cart. Example is I sell Pendants - I want to suggest a Chain (a specific item#) with every Pendant put in the cart - is there a way to say 'add this as cross sell item to every product' without laboriously adding every product to the one I want to cross sell or vice versa (there are hundreds of Pendants).

cheers,
Mike

Quote:

---

Originally Posted by shags38

Hello Diva,

I am looking for something similar to work in the cart - wrote the following earlier based on cart before I read the mod readme and see it relates to product pages - do you know of anything that can do the following?

- with this mod can I add a single product, the same item every time, to the cart for any and every product a customer may add to the cart. Example is I sell Pendants - I want to suggest a Chain (a specific item#) with every Pendant put in the cart - is there a way to say 'add this as cross sell item to every product' without laboriously adding every product to the one I want to cross sell or vice versa (there are hundreds of Pendants).

cheers,
Mike

---

No.. I'm afraid that I do not know of a module that works as you describe.. You could always have someone re-engineer one of the cross sell modules to work as you require..

New to Zen Cart (v1.5.4) and just installed Cross Sell Advanced plugin .. not sure it is working ??? Is there a place to enable the plugin. I have found in the Categories drop-down: "Cross-Sell (X-Sell) Admin, Cross Sell (X-Sell) Advanced Admin" ; however after entering product numbers show up on admin but not on live site pages... did I miss running an install script ?

Any direction would be helpful, as I said, new to zen cart.
Thank, H

My Image Handler has stopped working after installing this module.

Sequence of events:
Add new product
Add attributes
Add cross sell
Image Handler stopped working

ZC 1.5.4 fresh install using installation on Camelot.

Plugins added in sequence:
Image Handler 4
Easy Populate (not using)
Cross Sell Adv.

Quote:

---

Originally Posted by Parafanaylya

My Image Handler has stopped working after installing this module.

Sequence of events:
Add new product
Add attributes
Add cross sell
Image Handler stopped working

---

Cross-sell is not displaying, but accepting products in the cross sell UI.

website under construction

Quote:

---

Originally Posted by K_C_Enterprises

New to Zen Cart (v1.5.4) and just installed Cross Sell Advanced plugin .. not sure it is working ??? Is there a place to enable the plugin. I have found in the Categories drop-down: "Cross-Sell (X-Sell) Admin, Cross Sell (X-Sell) Advanced Admin" ; however after entering product numbers show up on admin but not on live site pages... did I miss running an install script ?

Any direction would be helpful, as I said, new to zen cart.
Thank, H

---

Quote:

---

Originally Posted by Parafanaylya

ZC 1.5.4 fresh install using installation on Camelot.

Plugins added in sequence:
Image Handler 4
Easy Populate (not using)
Cross Sell Adv.



Cross-sell is not displaying, but accepting products in the cross sell UI.

website under construction

---

I'd say you both missed part of the install.. namely the template files which add the cross sell display to the product information page..

Quote:

---

Originally Posted by DivaVocals

I'd say you both missed part of the install.. namely the template files which add the cross sell display to the product information page..

---

I found the culprit in >templates, and moved the files to the right place. Will test in the morning. Bed time now.

Is this plugin compatible with zen cart version 1.54?

Quote:

---

Originally Posted by fjbern1943

Is this plugin compatible with zen cart version 1.54?

---

Almost, but not quite. You'll need to find the "Product URL" block in each of the *_display.php files in the /includes/templates/YOUR_TEMPLATE/templates directory and make the change below. The handling of the product's URL display changed in Zen Cart v1.5.3 -- please note that these changes apply ONLY TO Zen Cart v1.5.3 or later!

Find:

Code:

---

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

---

Change to:

Code:

---

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=product&products_id=' . zen_output_string_protected($_GET['products_id']), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

---

Quote:

---

Originally Posted by lat9

Almost, but not quite. You'll need to find the "Product URL" block in each of the *_display.php files in the /includes/templates/YOUR_TEMPLATE/templates directory and make the change below. The handling of the product's URL display changed in Zen Cart v1.5.3 -- please note that these changes apply ONLY TO Zen Cart v1.5.3 or later!

Find:

Code:

---

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

---

Change to:

Code:

---

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=product&products_id=' . zen_output_string_protected($_GET['products_id']), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

---

---

Cool.. thanks for posting the fix..

No problem, nice plugin!

Quote:

---

Originally Posted by lat9

No problem, nice plugin!

---

It is now..:smile: I take no credit for anything but cleanup.. RodG did the original code consolidation between the two OG cross sell plugins..

G'day,

So lat9 has installed Cross Sell Advanced for me and I've been testing it out on our test setup.

I added a product model to one product and it looked okay, but I wanted to try it on another product with five X-sell items.

So I've tried to add the following five Cross Sell products to Product Model: M-212 + MC-750
TEC52A-ANTIFOG
TA-200A
MS-20
VA-TOWEL3
SP-0101

But I get an error: Product Model: M-212 + MC-750 was not found. No Cross Sell Added.

I suspect Cross Sell Advanced has limitations on the Product Model character set, e.g. no spaces. There may be other limitations. It would help if the limitations were documented, but it would be even better if the problem was just fixed. Without a fix it's going to be difficult for us to use Cross Sell Advanced.

Also, what's Cross Sell Advanced going to do if two products have the same Product Model value, because I'm not aware of Zen Cart stopping this from happening. We may well have some duplicate Product Model values.

Personally, I'd like to be using the Product Id value. After all, that value is unique.

It would be really nice if Cross Sell Advanced supported us being able to use either of Product Model or Product Id on its various inputs.

(By the way, it's simply not practical to use the old Cross Sell interface on a site with more than 2000 products. Not being able to go direct to a product id and having to page around is just not a workable interface. And no doubt, that's why Cross Sell Advanced was created.)

Best regards, Lloyd Borrett.

Quote:

---

Originally Posted by lloyd_borrett

G'day,

So lat9 has installed Cross Sell Advanced for me and I've been testing it out on our test setup.

I added a product model to one product and it looked okay, but I wanted to try it on another product with five X-sell items.

So I've tried to add the following five Cross Sell products to Product Model: M-212 + MC-750
TEC52A-ANTIFOG
TA-200A
MS-20
VA-TOWEL3
SP-0101

But I get an error: Product Model: M-212 + MC-750 was not found. No Cross Sell Added.

I suspect Cross Sell Advanced has limitations on the Product Model character set, e.g. no spaces. There may be other limitations. It would help if the limitations were documented, but it would be even better if the problem was just fixed. Without a fix it's going to be difficult for us to use Cross Sell Advanced.

---

Dunno if this is a limitation of Cross Sell.. Never had this issue reported before.. Can't document a problem that can't be replicated or has not been reported.. (see results of my own test below..

Quote:

---

Product Name: Grifo Fasce Tablecloth

Current Cross-Sells:

Product Model	Product Name	Action
01-050614 + 001	Galatea Tablecloth	https://www.eyeitalia.com/shop/admin...ons/delete.gif
01-0702GB	Grifo Fasce Napkins-Set of Four	https://www.eyeitalia.com/shop/admin...ons/delete.gif

---

Quote:

---

Originally Posted by lloyd_borrett

Also, what's Cross Sell Advanced going to do if two products have the same Product Model value, because I'm not aware of Zen Cart stopping this from happening. We may well have some duplicate Product Model values.

---

Again, not an issue that's been reported, but I'd say the short answer is to make your model numbers unique so that this is not an issue.. Not seeing the upside of modifying this community module to account for something that isn't a recommended business practice.. (meaning the use of duplicate model numbers)

Quote:

---

Originally Posted by lloyd_borrett

Personally, I'd like to be using the Product Id value. After all, that value is unique.

It would be really nice if Cross Sell Advanced supported us being able to use either of Product Model or Product Id on its various inputs.

---

And you (and any other community member) are free to submit these kinds of changes to this module..

Quote:

---

Originally Posted by lloyd_borrett

(By the way, it's simply not practical to use the old Cross Sell interface on a site with more than 2000 products. Not being able to go direct to a product id and having to page around is just not a workable interface. And no doubt, that's why Cross Sell Advanced was created.)

---

Again, you (and any other community member) are free to submit improvements/changes to this module.. You also might want to look at one of the other cross sell modules ad see if they provide an interface more to your liking..

Hi Guys, I've recently installed this plugin (everything seems to have installed without any problems), but for some reason I can't get the additional images to display below the page. I'm running ZenCart v1.5.1 with a custom (ThemeForrest) template that I've merged with the plugin template files. Even so, my template strangely only displays 'Search' at the bottom of the page where the additional images are supposed to show. Does anyone have any ideas what the problem might be?

Quote:

---

Originally Posted by McLovin

Hi Guys, I've recently installed this plugin (everything seems to have installed without any problems), but for some reason I can't get the additional images to display below the page. I'm running ZenCart v1.5.1 with a custom (ThemeForrest) template that I've merged with the plugin template files. Even so, my template strangely only displays 'Search' at the bottom of the page where the additional images are supposed to show. Does anyone have any ideas what the problem might be?

---

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..

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

Originally Posted by 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):

Quote:

---

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."

---

Quote:

---

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

---

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

The plugin is making direct PHP mysql_* function calls on a version of Zen Cart where the database has been opened via the PHP mysqli_* series of calls; that's where the debug-log arises.

lat9,

Thank you of the hint and inform, I try to replace those old mysql to mysqli see what will happened.

I upgraded to 1.5.4, and now Multi Cross sell is not reading my database. I have over 6200 entries in the database, but none show up in the admin area.

fantasycostume.com

Quote:

---

Originally Posted by masterrusty

I upgraded to 1.5.4, and now Multi Cross sell is not reading my database. I have over 6200 entries in the database, but none show up in the admin area.

fantasycostume.com

---

Sorry, ignore,me. Wrong thread Goingto Multi Cross Sell thread now.

Hi, 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? Can someone let me know what needs changing. I would love it to look how my 'Also purchased' module looks, but understand this is styling done by the Template I used, but I want my products to be vertical and bigger at least. Would appreciate the help, Thanks.
Cross sell advanced version: 1.3 Zen cart version: 1.5.1 example here (remove spaces): playandbuy . co . uk/store/index.php?main_page=product_info&cPath=65_66&products_id=180

Hi there all you Amazing Zeners. I really Really need help, I don't know what I did but ever since I installed and then (because I couldn't get it to work right had to uninstall it) my zen cart wont go further than clicking the checkout button www.marsmusic.co.za/shop please see attached image. can anybody help me please I have NO idea what I have done and need this working again asap. Attachment 16401

I have posted in the other cross sell advanced thread but havnt found what would fix my problem.....I installed cross sell advanced combo, no problems, went into admin configured cross sells,....but the are not showing on site in catelog? any possible solutions?

Thank you

Brent

Quote:

---

Originally Posted by Hollywood691

I have posted in the other cross sell advanced thread but havnt found what would fix my problem.....I installed cross sell advanced combo, no problems, went into admin configured cross sells,....but the are not showing on site in catelog? any possible solutions?

Thank you

Brent

---

forgot - http://axiscups.com

I am running v.154 and I have both Cross Sell (x-Sell) Admin and Cross Sell (x-Sell) Advanced Admin and neither one is working. Unfortunately, I can't recall when I installed them but I can check the appropriate products or enter the right product numbers and absolutely nothing happens. I don't know whether I should try to uninstall both and try to install an updated plugin or what. Any ideas?

Thanks,

Silver

I just installed the "new" Cross Sell Advanced and nothing happened. I even removed the obsolete files and nothing shows up in admin. Anybody know what gives? Any help is appreciated.

Silver

Updated this mod to add integration with Common Xsell Sort order

https://www.zen-cart.com/downloads.php?do=file&id=2102

Common XSell Sort Order has been coded for 1.5.5 only but could be backported to lower versions just by doing the appropriate merges.

Common Cross Sell Sort Order allows you to set the cross sell sort order once per product (rather than once per cross sell).

Quote:

---

Originally Posted by swguy

Updated this mod to add integration with Common Xsell Sort order

https://www.zen-cart.com/downloads.php?do=file&id=2102

Common XSell Sort Order has been coded for 1.5.5 only but could be backported to lower versions just by doing the appropriate merges.

Common Cross Sell Sort Order allows you to set the cross sell sort order once per product (rather than once per cross sell).

---

I have installed this update as well,.....everything works right in the admin section, but does NOT display in the catelog......I have been looking for weeks for a resolution but havn't found one. I have seen so many threads with the same problem but havnt seen a fix.

a) Is tpl_modules_xsell_products.php in includes/templates/YOUR_TEMPLATE/templates?

b) Is xsell_products.php in includes/modules/YOUR_TEMPLATE ?

c) Are you including this file in includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

Code:

---

<!--bof xsell module -->
<?php require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php'); ?>
<!--eof xsell module -->

---

Quote:

---

Originally Posted by swguy

a) Is tpl_modules_xsell_products.php in includes/templates/YOUR_TEMPLATE/templates?

b) Is xsell_products.php in includes/modules/YOUR_TEMPLATE ?

c) Are you including this file in includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

Code:

---

<!--bof xsell module -->
<?php require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php'); ?>
<!--eof xsell module -->

---

---

The last part got me,.....I never saw in any instructions to add that to the file,.....It is displaying in catelog now, But says (TEXT_XSELL_PRODUCTS) how do I change that to say something else?

nevermind,....I got it....Thank you for your Help!!!!:clap:

Quote:

---

Originally Posted by Hollywood691

The last part got me,.....I never saw in any instructions to add that to the file.

---

If a mod includes a file like

Code:

---

./includes/templates/YOUR_CLASSIC_RESPONSIVE/templates/tpl_product_info_display.php

---

or

Code:

---

./includes/templates/YOUR_TEMPLATE/templates/tpl_product_info_display.php

---

It means you either have to take these files and copy them into your cart, or merge the changes in these files (as compared to a fresh download of the same file) into your copy of the file.

HI,

Great Mod, but is there a way to change the order of the cross-sell items shown?
I have noticed they seem to show in a totally random order - not alphabetical or in the order I add them.
Thanks for any help

Hi Guys,
I have this mod installed and it works perfectly. Is it possible to place a "add to cart button" below each of my x-sells rather than have to go to that item first?
Thanks

Quote:

---

Originally Posted by roeghar

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

---

I'm having this issue even is a new installation of the module, not an update.

Quote:

---

Originally Posted by DrByte

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?...-and-try-again

---

There's no error in any of my logs.

Quote:

---

Originally Posted by gilby

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

---

I do not since it's a new installation.

Quote:

---

Originally Posted by roeghar

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.

---

I don't have any table with xsell. The only one there is xsell1 which is from the Multi Cross Sell which I'm trying to substitute.

ZC v1.5.5e (upgrade from 1.5.4)
PHP Version: 5.6.30
Database: MySQL 5.6.35

Quote:

---

Originally Posted by ideasgirl

Quote:

---

Originally Posted by DrByte

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?...-and-try-again

---

There's no error in any of my logs.

---

Perhaps. But "Warning: An error occurred, please refresh the page" always means a database error is occurring. So, somewhere you're missing a table, or using incorrect SQL syntax when making queries. The FAQ article gives additional ways of diagnosing.