Multi Cross Sell mod [Support thread]

bloomingvine:

Just setting up an upgrade shop with 1.5 released. I uploaded from the old database and installed multi-cross sell, which I really need in my shop. It is the best mod. However, in 1.5, there is no boxes folder in the admin, so there is no way to install the mod through admin. Is there any way to get a sql patch ti install it? I loaded the3 old database and pasted into product infodisplay in template default, and all my cross sells from the old store are there and displaying. there is just no way to add more or access the mod from admin. Thanks. no hurry.

I attempted to install this mod on a fresh install of v1.50. Had a little trouble merging some of the files - I think I'll wait until gilby is able to issue an upgrade.

As a work around to your admin access problem, using the Admin>Admin Access Management>Admin Page Registration facility and the details in /includes/boxes/extra_boxes/multi_xsell_catalog_dhtml.php one is able to activate the Admin->Catalog->Advanced Cross-Sell option. I'm afraid I can't remember if Admin->configuration->cross sell is subsequently activated of if I navigated there by amending the ?gID= in the Configuration url.

Of course, my installation problems may not have been caused by merging files but by the mods incompatability with v1.50, I don't really know enough to decide which.

Anyway hopefully this might give you something to play with.

Back next year!

Thanks, I was able to go to the page by navigating and changing the url as you suggested, but it seems there is an indefined link in the code on the page. I also moved the boxes/extra_boxes/multi_xsell_catalog_dhtml.php file out into the main admin folder to try to get it to install that way. When I try to type in the admin access page, under filename I am trying all sorts of variations of the path name, but it can't find it. I did just the filename, no path, the whole path with the boxes folder which I uploaded for good measure, and the path to the file I put in the main admin folder. It also returne the error that language is not de4rfined and I need to put the key on the page I think.

As for merging files, I think there was only one file altered, the product info display file. I used the one in template default since I use a heavily modified classic template.

Yeah, I can wait for an update. I am not switching over to the new cart till all my favorite mods are updated. Just testing stuff so far. This is my most important one as I sell artwork on all kinds of products and it is helpful to see all the different products with the same pieces. Happy New Year!

Well as a work around for 1.5 you could do this:

Install as before. You won't see anything in the admin menus yet.

Then run the following sql patch:

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('multiXsell', 'BOX_CATALOG_MULTI_XSELL_PRODUCTS', 'FILENAME_MXSELL_PRODUCTS', '', 'catalog', 'Y', 999);

if your site uses a prefix for the database tables then you'll have to change the 'admin_pages' to 'prefixadmin_pages' ( and in the next one) . that will let you see the menu item in the 'catalog' menu.

using that you install the mod with the install button

however you still won't be able to see the configuration menus. for that you can run this sql :

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);

that should get you functional with this great mod even if it not ideal .

niccol:

Well as a work around for 1.5 you could do this:

Install as before. You won't see anything in the admin menus yet.

Then run the following sql patch:

INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('multiXsell', 'BOX_CATALOG_MULTI_XSELL_PRODUCTS', 'FILENAME_MXSELL_PRODUCTS', '', 'catalog', 'Y', 999);

> 
> if your site uses a prefix for the database tables then you'll have to change the 'admin_pages' to 'prefixadmin_pages' ( and in the next one)  . that will let you see the menu item in the 'catalog' menu.
> 
> using that you install the mod with the install button
> 
> however you still won't be able to see the configuration menus. for that you can run this sql :
> 
> ```
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);

that should get you functional with this great mod even if it not ideal .

That installed the instance of multi cross sell to the catalog menu, however, when clicked it directed me to multi_xsell.php instead of the file mentioned above. It then said file not found. So I changed the file that was originally to go in the boxes folder to just multi_xsell.php and when I click on the menu item in the admin I get the following error Fatal error: Call to undefined function zen_href_link() in /home/content/36/5920136/html/store/admin42666wild/multi_xsell.php on line 17

Thanks for trying though, I really appreciate it!

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

niccol:

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

I had missed the initial file that is out in the main admin folder. Now when I click on the menu item in catalog, I see a box that says edit cross sells with a pull down menu of 1-5 and a remove button on the far right. I may have to reinstall. This is my first mod on a fresh install of zen 1.5 for testing, but I loaded the old database from zen1.3.9h .

niccol:

Well, the first part of the sql just makes the menu item visible.

It should direct you to :

your-admin/multi_xsell.php

Which seems to be what you are saying that you experienced. On that page there is an 'install' button.

You then click on the install button. Which, puts some records into the database, including the menu items for the configuration.

But you need to then use the second sql statement to show the menu items in the configuration menu items.

The order is important. And it is important that the module is fully uninstalled before you start. That means that the files are removed and the database entries are removed.

I think that something else is going on here. If you are getting that error to that particular function as undefined then something is not installed correctly. As I say, my instructions were based on starting from a clean install so if files and database have been altered before that then it is hard to comment on those changes.

I see, so it may not be working because I used the old database? I can't import 600 products any other way. Way too much work.

OK. Well, that means that you have some of it installed fine but other bits not so much.

Basically, you need to remove anything from the databases that is to do with the mod and configuration. ( but not the actual cross sells )

So, you are interested in the following tables in the database:
configuration (mulptiple rows)
configuration_group ( 1 row )
admin_pages ( 1 or 2 rows )

but you DO NOT want to alter the products_xsell table.

If you can do that with phpMyAdmin then that is the easiest way to do it. Just go through the tables and delete the rows. ( after having backed up obviously)

Then run my first sql.
Then navigate to the page and click on 'install'
Then run the second sql

If you are not happy with phpMyAdmin I'd recommend that you give it a go anyway. It is good to know how to do it. And if not then I can probably write you an sql statement that would get rid of it all for you, but....

niccol:

OK. Well, that means that you have some of it installed fine but other bits not so much.

Basically, you need to remove anything from the databases that is to do with the mod and configuration. ( but not the actual cross sells )

So, you are interested in the following tables in the database:
configuration (mulptiple rows)
configuration_group ( 1 row )
admin_pages ( 1 or 2 rows )

but you DO NOT want to alter the products_xsell table.

If you can do that with phpMyAdmin then that is the easiest way to do it. Just go through the tables and delete the rows. ( after having backed up obviously)

Then run my first sql.
Then navigate to the page and click on 'install'
Then run the second sql

If you are not happy with phpMyAdmin I'd recommend that you give it a go anyway. It is good to know how to do it. And if not then I can probably write you an sql statement that would get rid of it all for you, but....

Thanks, I removed the items you mentioned from the database and that removed it. I did see the install button then before running the second squl patch. However, That produced an error and I found I had one file missing in the uploads again. I have to re edit the databases and try again.

gilby:

It easier to work out with a live site.....

However Multi Cross Sell uses..
class="centerBoxWrapper" and class="centerBoxHeading"

So find what styling has been applied to the "also purchased box" and apply it to these classes.

My test site is technically 'live' (https://www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

My_Red_Zebra:

My test site is technically 'live' (https://www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

Undo what you have done
You have duplicated id="alsoPurchased"

Then in includes\templates\YOUR_TEMPLATE\templates\tpl_modules_multi_xsell_products.php
around line 30 find..php <h2 class="centerBoxHeading"><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></h2> add <span> tags and change to```php
<h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

See if that works....

gilby:

Undo what you have done
You have duplicated id="alsoPurchased"

Then in includes\templates\YOUR_TEMPLATE\templates\tpl_modules_multi_xsell_products.php
around line 30 find..php <h2 class="centerBoxHeading"><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></h2> add <span> tags and change to```php
<h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

> See if that works....

Thanks very much Gilby. Almost there now.

We have a light blue bar/line under the heading which shouldn't be there.  How do I remove that?  Also, is it very hard to get the blue shaded box around the products the same as in the 'also purchased' box?

My_Red_Zebra:

Thanks very much Gilby. Almost there now.

We have a light blue bar/line under the heading which shouldn't be there. How do I remove that? Also, is it very hard to get the blue shaded box around the products the same as in the 'also purchased' box?

Just a typo
you have <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?><span></h2>and it should be```
<h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

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.

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.

Go to Admin->Catalog->Multi Cross Sell
Click Install
Go to Admin->Configuration->Cross Sell Settings
By default one cross sell is installed
Configure as required.

Go to Admin->Catalog->Multi Cross Sell
Below the Go button it should show the cross sell options

Clean up Cross Sell 1
New Cross Sells 1
Edit Cross Sells 1
Delete All Cross Sells 1
Multi Cross Sell Summary
List All Cross Sells 1

If these don't show you have missed something in the uploads
go to your "cache" directory and check the error logs there.

Brilliant, thanks so much. I didn't notice before that the bottom of the box is missing it's line too. How would I fix that one?

Also, would it be hard to format the box to look the same as the 'Also Purchased' Box - all shaded in blue etc.??

My_Red_Zebra:

Brilliant, thanks so much. I didn't notice before that the bottom of the box is missing it's line too. How would I fix that one?

Also, would it be hard to format the box to look the same as the 'Also Purchased' Box - all shaded in blue etc.??

Again its a matter of playing with the CSS and the styles for those elements.
Your site is down at this time so I can't see it

Hello
i cant seem to control the sort order which my items appears in the cross sell.
Editing each products sort order (in the products info page) doesn't seem to have any effect.
i don't have the random setting set to 'on' either.
Any advice appreciated.
Thanks for the mod!

Cookiepus:

Hello
i cant seem to control the sort order which my items appears in the cross sell.
Editing each products sort order (in the products info page) doesn't seem to have any effect.
i don't have the random setting set to 'on' either.
Any advice appreciated.
Thanks for the mod!

admin/catalog/Multi Cross Sell

Either "Edit Cross Sells" and enter the Product
or "List all Cross Sells" and select "edit" for the one you want

Then add numbers into the "sort order" of the cross sells

Thanks Gilby
i didnt know that was built in.
what a great mod.
i have my items grouped in cross sells of around 8.
Do i have to enter sort order for each & every item?
i mean, can i set it so certain items will appear first in each cross sell group?
Cheers
Cookie