Just another Cross-Sell mod (support thread)

Hello . We have cross sell already installed so All i did was upload the files then try to run the SQL patch. According to the read me. But the sqil file throws this error:

SQL query: Documentation

SELECT (
@t4 := configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title = 'Cross Sell';

MySQL said: Documentation
#1146 - Table 'croptcom_zencart.configuration_group' doesn't exist

...all my tables start with zen_ . Can you please tell me what to modify in the query?

Thanks

By the way this is the query Im trying to run. We use 1.3.7 and Mysql 5.0.45. The query is straight from the read me file.

Thanks again.

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';

UPDATE configuration SET configuration_group_id = @t4 WHERE configuration_key IN ('MIN_DISPLAY_XSELL','MAX_DISPLAY_XSELL','SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS','XSELL_DISPLAY_PRICE');

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
('', 'Input type to be used in form', 'XSELL_FORM_INPUT_TYPE', 'model', 'Choose to use product ID or MODEL as your input type. Check readme file for more info', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''id'', ''model''),');

I think i may have found the answer in post #53 of this thread:
I need to run the patch through the admin. Ill try that now.

Thanks

It worked... my bad. Had to use the admin > tools > install patch tool

Thanks for letting me talk my way through this. Hope it helps someone else.

makenoiz

makenoiz:

It worked... my bad. Had to use the admin > tools > install patch tool

Thanks for letting me talk my way through this. Hope it helps someone else.

makenoiz
I believe that the readme stated clearly that you have to use Zencart admin sql patch tool to run the script ^^.

Hi all,

I have installed the Cross Sell mod with no problem. When I tried to upgrade to Just another Cross-Sell mod I get this error when submitting the SQL statements via zen-cart.

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any idea of where to track this one down? Thank you.

I am getting this message after installing the mod, does anyone recommend this error or possibly know what I am doing wrong.

Warning: main(includes/modules/FILENAME_CART_UPSELL.php) [function.main]: failed to open stream: No such file or directory in /homepages/2/d208592347/htdocs/shop/includes/templates/template_default/templates/tpl_shopping_cart_default.php on line 232

Fatal error: main() [function.require]: Failed opening required 'includes/modules/FILENAME_CART_UPSELL.php' (include_path='.:/usr/local/lib/php') in /homepages/2/d208592347/htdocs/shop/includes/templates/template_default/templates/tpl_shopping_cart_default.php on line 232

It appears that you did not upload all the files to the correct folders. If you are using a custom template. there are several folders in the zip file that you need to rename before uploading.

Hi again,

When I am in the advanced X-Sell admin page and I click edit next to a product under Current Cross-Sells, I get the following error.

1054 Unknown column 'SSC' in 'where clause'
in:
[select p.products_id from products p where p.products_id = 01-SSC-5381 LIMIT 1]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Did a table not get created properly when installing the "just another X-Sell mod"

Thank you for any help or guidance.

In configuration->Cross sell choose:
Input type to be used in form -> model

See if that fixes the problem.

Ok, well I think I may have a bigger issue.

I do not have a Cross Sell option under configuration.

Under Catalog I have two options, Cross Sell Products and Advanced Cross-Sell. Perhaps I will start over at square one with the Cross Sell mod again.

Thank you

I plan to make several changes during Winter break:
Code: will use class instead of functions. Clean up messy codes, make it easier for you to make changes if needed.

On admin side:

1. No need to add new field for each product id/model. All will be in the same input field, separated by comma or semicolon. I realize from my own experience that this will make the job even faster and easier.
2. No longer list all cross-sells by default to speed up the loading (especially if you have lots of xsells)
3. Easy retrieval: If you have a group of xsell products (A, B, C) and want to add D to this group, you will be able to do this very easily.
   The same with master product (1 way cross sell)

On catalog side:
Will merge the original XSell to the package to make it easier for you.

Let me know if there is anything else you want.

Hello,

When I click the Add Product field button it throws the following Javascript error.

addFields is not defined
```The following appears to be the offending line. 
    ```
addFields('xsellProducts','product_id[',-1,prefix,sufix);
```Any idea what didn't get installed correctly. Besides that everything has been working great. 

PS
The idea of adding multiple items by separating by a comma is great.

This is a minor bug which has been reported. The js folder in the package must be placed in the root folder I think. I will fix this in the next version.

ok, good to know. Good luck with the next release. I am looking forward to it.

For now you just need to place the js folder in the root folder I think, that will fix it,

A new version is released, this version does not contain any new feature (except 1: it no longer lists all xsells by default --> faster loading speed)
Link: https://svn.rubikintegration.com/zencart_mods/cross_sell_advanced/
Since this is a minor release, I won't upload it to the download section.

Changes:

1. Included the original Xsell package now.
2. Moved most core functions out of the template file.

Upgrade: Simply upload all files to overwrite the old one, no change in database.

If you have time, please upgrade to this new version on your test server and let me know if things turn out okie. (especially the js folder, does it still have to be in root folder?)

yellow1912

A new version is available for testing, unfortunately I dont have time to document it yet:

1. NOW add all ids/models using a single input field
2. Added a switch in the admin panel that let you display xsell products randomly (in the store). You will need to run the new sql patch + overwrite the old includes/modules/yourtemplate/xsell_products.php with the new one.

All suggestions/comments are appreciated.

New version, this should be the last one of the day (and the last one for a while :P)

1. No longer loads and displays all current xsells by default (improve loading speed)
2. Includes the original Xsell package now.
3. Most core functions are moved out of the template file.
4. Use a different approach to input new xsells.
5. Added a switch in the admin panel that let you display xsell products randomly (in the store)
6. Many minor changes to code.
   and more ....

Link:
https://svn.rubikintegration.com/zencart_mods/cross_sell_advanced/

I will NOT upload to download section until this version is confirm bug free. So don't wait, since it will be for a while.

Hello there,

I just tried the last version mention before this post. I think this may be due to my setup of my cross sells, as it doesn't always show when you edit an item. But sometimes pressing edit brings this up:-

0 
in:
[select p.products_id, p.products_model, pd.products_name, px.ID, px.sort_order from zen_products p, zen_products_description pd, zen_products_xsell px where p.products_id = pd.products_id and p.products_id = px.xsell_id and px.products_id = '4' group by p.products_id]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Everything else is great though.

Thanks,

Heathenmagic