Multi Cross Sell mod [Support thread]

niccol:

@stizzed
sorry missed your question. those sql statements in my post are the ones that I use to get full ( I think) functionality. What exactly don't you have?

niccol,

Thank you for the response and sharing your knowledge of this very useful mod!

'Admin->Configuration->Cross Sell Settings' is not there. I am able to use the mod because 'Admin->Catalog->Multi Cross Sell' is there (and works) but am not able to tweak the settings...

Thankx in advance!

Well the second sql statement should make the configuration menu setting visible.

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

As has been noted if you are using a table prefix for your store then you'd have to add that to the table names. Like prefix_admin_pages and prefix_configuration group.

I think that is it.

niccol:

Well the second sql statement should make the configuration menu setting visible.

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

> 
> As has been noted if you are using a table prefix for your store then you'd have to add that to the table names.  Like prefix_admin_pages and prefix_configuration group.
> 
> I think that is it.

Interesting...  I ran both originally, do not use prefixes, and still, no 'Cross Sell Settings' on the Admin Menu...

I do seem to remember an error with the CONCAT portion of the INSERT statement. 

Thoughts?

niccol:

Well the second sql statement should make the configuration menu setting visible.

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

> 
> As has been noted if you are using a table prefix for your store then you'd have to add that to the table names.  Like prefix_admin_pages and prefix_configuration group.
> 
> I think that is it.

Yep!  Checked the script, compared it to the database and everything looks like it made it in.  Still not making the menu... :cry:

niccol:

Well the second sql statement should make the configuration menu setting visible.

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='configuration';
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Cross Sell Settings' LIMIT 1;
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('configMultiXsell', 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS', 'FILENAME_CONFIGURATION', CONCAT('gID=', @configuration_group_id), 'configuration', 'Y', @sort_order);

> 
> As has been noted if you are using a table prefix for your store then you'd have to add that to the table names.  Like prefix_admin_pages and prefix_configuration group.
> 
> I think that is it.

Found it! :clap: There is a simple misspelling in the statement 'BOX_CATOLOG_MULTI_XSELL_PRODUCTS'.  As you can see 'CATOLOG' is misspelled.

Now however, instead of 'ADMIN>CONFIGURATION>Cross Sell Settings' we have 'ADMIN>CONFIGURATION>Multi Cross Sell'.  When selecting this entry however, the proper menu options are there.

Any idea why the Menu Option Name is wrong?

Thanks in advance!

Well, the 'hack' that I posted has three parts.

1. Run the first sql statement. This will make the item in the catalog item visible.

2. Use the normal 'install' button in that page. This will run more sql statements.

3. Run the second sql statement. This will make the config menu item visible if the other two steps have been completed correctly.

Step three will cause an error if the other two steps have not been completed successfully. What it is doign is finding the configuration_id that is created by the normal instal and assigning it a admin page. If the configuration doesn't exist then the sql will fail.

If you are seeing this then you will need to wait for an official update.

great :smile:

the title is 'wrong' because this is a 'hack'. that title is already define in the code so I used that. You can easily define another constant and use whatever text you want, but this 'hack' avoided having to describe to people how to make a new language file and then define a new constant and then use that new constant in the sql statement.

niccol:

great :smile:

the title is 'wrong' because this is a 'hack'. that title is already define in the code so I used that. You can easily define another constant and use whatever text you want, but this 'hack' avoided having to describe to people how to make a new language file and then define a new constant and then use that new constant in the sql statement.

Thanks again Nick! As you do not see a problem with the title and the mod seems to work as it is I won't take the time to try to 'fix' it. :D

I very much appreciate your assistance!

Hi everyone,
I'm having what looks like the same exact problem morganmoran had and despite my best efforts I can't figure out how to fix it.
Here's the info:
-ZC 1.3.9g
-PHP 5.2.17
-Double checked that all files from install package are where they need to be.
-Double checked that I included the code from the Document.txt file in the tpl_product_info_display.php file.
-Went to my admin under Catalog => Multi Cross Sell and clicked the install button.
-Now on the Multi Cross Sell Admin v1.02 page I have: "Select cross sell to edit" with a dropdown which has "1" selected, and a "Go" button.

When I click the "Go" button it seems to execute some process (i.e. I can tell that something is loading) but after 1-2 seconds nothing has happened, it's done loading, and the page remains the same. I'm expecting something to pop up or appear so that I can adjust the parameters for the cross sell, but nothing happens.

Can anyone point me in the right direction?
Thanks.

morganmoran:

I am running Zen v1.3.9h and PHP 5.2

I just installed this mod and everything seemed to install fine. However, I don't see anywhere in the admin to add/manage cross sell items.

The only options I see are:

Admin >> Configuration >> Cross Sell Settings

and

Admin >> Catalog >> Multi Cross Sell

The first is obviously the page with config settings and the latter has only a small drop down and a Go button, and nothing else. And nothing happens when I click "GO".

I fear I am missing something, but all files seem to have copied correctly.

bhensarl:

Hi everyone,
-Now on the Multi Cross Sell Admin v1.02 page I have: "Select cross sell to edit" with a dropdown which has "1" selected, and a "Go" button.

When I click the "Go" button it seems to execute some process (i.e. I can tell that something is loading) but after 1-2 seconds nothing has happened, it's done loading, and the page remains the same. I'm expecting something to pop up or appear so that I can adjust the parameters for the cross sell, but nothing happens.

Can anyone point me in the right direction?
Thanks.

This is one of the problems with the existing code working with 1.5.0

You will find in your cache directory debug files that show what this problem is.
Not sure off the top of my head what the fix for that problem is.

However its not the only one that can pop up.

I should have a fully working update in 2 to 3 weeks.

Thanks, gilby.

Checked the debug and found the problem here:

[19-Feb-2012 12:01:15] PHP Warning: require(../includes/languages/english/extra_definitions/multi_xsell_box_defines.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/content/52/6977852/html/admin8dr7kj34/multi_xsell.php on line 222
[19-Feb-2012 12:01:15] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '../includes/languages/english/extra_definitions/multi_xsell_box_defines.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/52/6977852/html/admin8dr7kj34/multi_xsell.php on line 222

It looks like the "multi_xsell_box_defines.php" in the install package should be located at languages/english/extra_definitions/ instead of going all the way to languages/english/extra_definitions/YOURTHEME/ .

Works like a charm now. Thanks for this great addon!

bhensarl:

Thanks, gilby.

Checked the debug and found the problem here:

It looks like the "multi_xsell_box_defines.php" in the install package should be located at languages/english/extra_definitions/ instead of going all the way to languages/english/extra_definitions/YOURTHEME/ .

Works like a charm now. Thanks for this great addon!

Yes thats one way around that problem!

Now all you have to do is rename your admin again as you have posted it for all to see.

Which facebook addon works best for the social media button for this mod?

Thanks

perkiekat:

Which facebook addon works best for the social media button for this mod?

Thanks

I haven't tried it with any of the available mods here...

It is basically a placeholder in the mod that can be used for social media, (or other purposes).

You need to have a good understanding of how to setup Open Graph variables on the product info pages for the sample code to work correctly.

gilby:

I haven't tried it with any of the available mods here...

It is basically a placeholder in the mod that can be used for social media, (or other purposes).

You need to have a good understanding of how to setup Open Graph variables on the product info pages for the sample code to work correctly.

Thank you for the info. Where is the "placeholder" for social media located at within this mod?
I checked the documentation and I do not see any information pertaining to where it is located. Maybe I missed it??
Thank you

perkiekat:

Thank you for the info. Where is the "placeholder" for social media located at within this mod?
I checked the documentation and I do not see any information pertaining to where it is located. Maybe I missed it??
Thank you

includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
line 65 has the default placeholder code
line 72 has the sample "commented out" facebook code

gilby:

includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
line 65 has the default placeholder code
line 72 has the sample "commented out" facebook code

Thanks, but not sure how to make this work ... :shocking:
so I will pass on it right now until I can dig deeper. Will just add the Like button for now in the site.

Hello Gilby,

I was wondering if you will be releasing a new version for 1.5.0?

Best Regards

Multi Cross Sell has now been updated to work with zen-cart v1.5.0

gilby:

Multi Cross Sell has now been updated to work with zen-cart v1.5.0

Woo-Hoo! :clap:

Thanx Gilby!