Multi Cross Sell mod [Support thread]

Quote:

---

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

Code:

---

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 :

Code:

---

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 .

Quote:

---

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

Code:

---

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 :

Code:

---

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.

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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