Zen Cart Logo
Forums / All Other Contributions/Addons / Multi Cross Sell mod [Support thread]

Multi Cross Sell mod [Support thread]

Views: 85,110

Results 221 to 240 of 476
10 Jan 2012, 11:54
#221
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Multi Cross Sell mod [Support thread]

Cookiepus:

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

In this version no you need to do it manually.

I am looking to have a default sort order based on the entry sequence. (This could only work for one way cross sells)

10 Jan 2012, 12:01
#222
cookiepus avatar

cookiepus

Zen Follower

Join Date:
Jan 2010
Posts:
131
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

OK - well
thanks again
Cookie

11 Jan 2012, 01:20
#223
my_red_zebra avatar

my_red_zebra

New Zenner

Join Date:
Sep 2011
Location:
Melbourne, Australia
Posts:
31
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

gilby:

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

Thanks, I'll see how I go. BTW the site is back up & running. Was only down for a short time. :smile:

18 Jan 2012, 18:33
#224
budgieoc18 avatar

budgieoc18

New Zenner

Join Date:
Oct 2011
Posts:
4
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

Zen Cart v1.3.8/v1.3.8
Multi Cross Sell Admin v1.02

Hi,
Above is the version of Zen Cart which I am using and my Multiple Cross Sell.

I am having problems using this feature....

Could anyone give me basic info on how to use it..

Thank You

30 Jan 2012, 04:50
#225
my_red_zebra avatar

my_red_zebra

New Zenner

Join Date:
Sep 2011
Location:
Melbourne, Australia
Posts:
31
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

gilby:

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

Okay, not having any luck. Saying that, I am a total novice at this sort of thing. I've got something that is reasonable looking but I need the bottom line on my box and need to centre the product titles under the image. Any advice on this would be greatly appreciated.

30 Jan 2012, 05:37
#226
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

My_Red_Zebra:

Okay, not having any luck. Saying that, I am a total novice at this sort of thing. I've got something that is reasonable looking but I need the bottom line on my box and need to centre the product titles under the image. Any advice on this would be greatly appreciated.

I remember using "view source on that page and at the bottom of the "also purchased" box there was a line with a class added by your template.
You simply grab that line and add it to the bottom of the cross sell box.
You have removed the "also purchased" box from your site so I cannot tell you exactly what that line is.

30 Jan 2012, 05:41
#227
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

budgieoc18:

Zen Cart v1.3.8/v1.3.8
Multi Cross Sell Admin v1.02

Hi,
Above is the version of Zen Cart which I am using and my Multiple Cross Sell.

I am having problems using this feature....

Could anyone give me basic info on how to use it..

Thank You

Have you looked in the mod here?
\docs\README-MultiCrossSell.txt
and
\docs\how_to_use.txt

04 Feb 2012, 18:55
#228
stizzed avatar

stizzed

New Zenner

Join Date:
Jan 2012
Location:
Northern Indiana
Posts:
42
Plugin Contributions:
0

Re: 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 .

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!

15 Feb 2012, 19:34
#229
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

Where is the SQL file located?

15 Feb 2012, 19:48
#230
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

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

15 Feb 2012, 20:40
#231
niccol avatar

niccol

Totally Zenned

Join Date:
Apr 2009
Posts:
2,138
Plugin Contributions:
1

Re: Multi Cross Sell mod [Support thread]

@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?

@The Mech
A bit more info would help. Zen Cart version?

In general, this is not my mod. Gilby is the man. I jsut posted what I did to get it to play with Zen 1.5.

The only other thing that I may not have answered because this was originally posted for a specific question was that you may need to ensure that BOX_CATOLOG_MULTI_XSELL_PRODUCTS is actually defined somewhere. I can't remember if I had to define that in a new language file or not, to be honest. If I get time I will re-install on a clean server and have a look at it. But it would be best if a Zen 1.5 compatible version was released, and I am kind of busy with other mods...

15 Feb 2012, 21:06
#232
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

Thanks Niccol,
zen-cart-v150-full-release-12302011

When running your patch for 1.5:

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

I get this:

Error

SQL query:

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

MySQL said: Documentation
#1048 - Column 'page_params' cannot be null 
15 Feb 2012, 21:31
#233
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

I tried changing the CONCAT bit to 'gID=31' where 31 was the next gID. It entered without error at that point, but nothing happened.

15 Feb 2012, 22:05
#234
niccol avatar

niccol

Totally Zenned

Join Date:
Apr 2009
Posts:
2,138
Plugin Contributions:
1

Re: Multi Cross Sell mod [Support thread]

basically that means that you have not got the entry in the configuration_group table there already. that should have been created by the original install of the mod.

have you followed the instructions correctly. For instance :

using that you install the mod with the install button
16 Feb 2012, 01:49
#235
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

niccol:

basically that means that you have not got the entry in the configuration_group table there already. that should have been created by the original install of the mod.

have you followed the instructions correctly. For instance :

using that you install the mod with the install button


Yeah, and after installing, I ran your SQL.
16 Feb 2012, 04:48
#236
the_mech avatar

the_mech

New Zenner

Join Date:
Feb 2012
Posts:
67
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

I've found that the first SQL works without a table prefix but the second SQL only works with...

16 Feb 2012, 06:02
#237
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

The above sql's may work for you with the existing 139 code. If so good!

My testing has shown that some functions relied on by this mod have changed in 1.5.0 and may result in blank admin pages on some sites.


Just an update as to where I am with this.

  • Have sorted out the install and uninstall, that now works fine.
  • Fixed a number of compatibility problems.

Working on making it work WITH 1.5.0 and not just work IN 1.5.0
eg: replacing some of the gets with posts.

At this stage it looks like being around 2 to 3 weeks before it should be ready.

16 Feb 2012, 09:14
#238
niccol avatar

niccol

Totally Zenned

Join Date:
Apr 2009
Posts:
2,138
Plugin Contributions:
1

Re: Multi Cross Sell mod [Support thread]

@The_Mech
Yeah, that may well be it. I hope you get it to work. To be honest I slightly regret having even posted this as it is much better to wait for Gilby to do his update. I have it running fine on 1.5 but then I have tweaked the code anyway.

And as Gilby actively supports this mod I sort of feel that one should have the courtesy of waiting for that update. Gilby, I apologise for having got tangled up in it all. I absolutely understand how much work goes into it all and probably should have kept my mouth shut. It was just one of those cases when I had just done something myself and someone asked how to do it. Apologies.

16 Feb 2012, 09:50
#239
gilby avatar

gilby

Totally Zenned

Join Date:
Aug 2005
Location:
Vic, Oz
Posts:
1,816
Plugin Contributions:
0

Re: Multi Cross Sell mod [Support thread]

niccol:

@The_Mech
Yeah, that may well be it. I hope you get it to work. To be honest I slightly regret having even posted this as it is much better to wait for Gilby to do his update. I have it running fine on 1.5 but then I have tweaked the code anyway.

And as Gilby actively supports this mod I sort of feel that one should have the courtesy of waiting for that update. Gilby, I apologise for having got tangled up in it all. I absolutely understand how much work goes into it all and probably should have kept my mouth shut. It was just one of those cases when I had just done something myself and someone asked how to do it. Apologies.

No need to apologise and if it seemed I was having a go at you, I wasn't. I was just mentioning that there had been some problems that I had seen in some setups with the existing code.

As well I have been busy with my real job and haven't needed to get started on this until recently. If you or anyone want to improve or update it, go ahead I won't be miffed.

As it is, I certainly didn't write this from scratch. I looked at what was available and took what I thought was the best from other cross sells (especially yellow1912's version) and made changes that suited what I wanted it to do at the time.

Others have taken this and adapted it to their own use.
Take a look at ultimate_zc's version. He needed it to work a different way and has done it his way.

I rarely find a mod that works exactly the way I want it and often adapt it to what I need at the time. At the time I adapted yellow1912's cross sell I thought that this might also be useful to others as well, that why I submitted it.
I don't see this as "mine, keep off" it was just an evolution from what was available at the time. It is still useful to me so I will still work on it, but that doesn't mean others can't also.

16 Feb 2012, 11:38
#240
niccol avatar

niccol

Totally Zenned

Join Date:
Apr 2009
Posts:
2,138
Plugin Contributions:
1

Re: Multi Cross Sell mod [Support thread]

@gilby
I completely understand.
I kind of just wanted people to know that I was just 'getting it to work' in 1.5 rather than having looked at the code in any deep way, which I haven't. The sql statements are very much a 'hack' and I haven't looked at the code closely enough to make any other observations other than that.
As I say I am kind of busy with other mods and other projects. So, I also completely appreciate your position with this mod. I was trying to find a way of saying ' wait for an official update' without seeming to pressure you to produce one because I know that it takes work and that no-one is ultimately responsible for a mod at all.