Multi Cross Sell mod [Support thread]

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

[bloomingvine]

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!

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

[bloomingvine]

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 .

[bloomingvine]

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.

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

[bloomingvine]

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.

[Stizzed]

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 .

Nick,

Could you be so kind as to provide the SQl script to add 'Admin/Configuration/Cross Sell Settings' to the admin?

Thanx in advance!

[The_Mech]

Where is the SQL file located?

[The_Mech]

Nevermind. I got it. But I still don't have a Cross Sell option in my configuration menu.