Zen Cart Logo
Forums / All Other Contributions/Addons / Just another Cross-Sell mod (support thread)

Just another Cross-Sell mod (support thread)

Views: 133,961

Results 541 to 560 of 704
19 Aug 2009, 12:43 AM
#541
masterrusty avatar

masterrusty

Zen Follower

Join Date:
Mar 2007
Location:
Oregon
Posts:
152
Plugin Contributions:
0

Just another Cross-Sell mod (support thread)

Ok. So after a little more research, and modifications, I have the cross sell items showing with the products.

However the "We also Recommend" verbiage is located a little high, and to the right. I added some <br>'s to the "TEXT_XSELL_PRODUCTS" line in the product _info.php file, and tried to add an <align="left"> as well.

This caused the verbiage to drop down, but it did not move it to the left. How can I get it to the left side of the center box wrapper?

20 Aug 2009, 11:36 AM
#542
robm avatar

robm

New Zenner

Join Date:
Nov 2006
Posts:
88
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

I'm getting the following error when i'm trying to enter product ID's to cross sell.

1146 Table 'reptileszcd.products_xsell' doesn't exist
in:
[select count(products_id) as records from products_xsell where products_id = '6' and xsell_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas? Thanks.

20 Aug 2009, 11:58 AM
#543
robm avatar

robm

New Zenner

Join Date:
Nov 2006
Posts:
88
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

I'm getting the following error when i'm trying to enter product ID's to cross sell.

1146 Table 'reptileszcd.products_xsell' doesn't exist
in:
[select count(products_id) as records from products_xsell where products_id = '6' and xsell_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas? Thanks.

22 Aug 2009, 6:23 PM
#544
urbanfoodie avatar

urbanfoodie

New Zenner

Join Date:
Aug 2009
Posts:
6
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

AATECH:

Never mind... It looks like 1.SQL was never ran with the Module Manager... So I ran it in the Admin Sql

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';

UPDATE configuration SET configuration_group_id = @t4 WHERE configuration_key IN ('MIN_DISPLAY_XSELL','MAX_DISPLAY_XSELL','SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS','XSELL_DISPLAY_PRICE');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'Input type to be used in form', 'XSELL_FORM_INPUT_TYPE', 'model', 'Choose to use product ID or MODEL as your input type. Check readme file for more info', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('id', 'model'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Product Input Separator', 'XSELL_PRODUCT_INPUT_SEPARATOR', ',', 'You will need to insert all product id/model you want to cross-sell in 1 field, so each product id/model needs to be separated by a separator. The default is comma, choose another if you want to', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('', 'XSell Sort Order', 'XSELL_SORT_ORDER', 'sort_order', 'Sometimes you may want to display the xsell products randomly, especially if each product xsells with lots of others', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array('sort_order', 'random'),');

Hope it helps someone...

You absolute super star - thank you, thank you, it really helps!

:bigups:

22 Aug 2009, 6:25 PM
#545
urbanfoodie avatar

urbanfoodie

New Zenner

Join Date:
Aug 2009
Posts:
6
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Also,

Thank YOU very much yellow1912 - great module mash!

27 Aug 2009, 8:15 PM
#546
kismetdesign avatar

kismetdesign

Zen Follower

Join Date:
May 2009
Location:
Junction City, Oregon
Posts:
315
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Question for you... I accidentally installed the cross_sell_advanced_1-0, thinking that it was the original cross sell mod.

So... I went back to look for the original, and there are about 3 contributions that look like they could be the original because they are worded very similar. There's Cross Sell, and Cross-Sell, and yours.

Which should I install?

One more question... I have a product that is up right now, available in 3 different reader formats for download. I have those listed at the top of the item.

My client has decided that we want to offer Publish on Demand for this product too, but says that for that option, we need a new information page.

He wants me to list the 'Order Hardcopy' as just a text link, right under my attribute options for the downloads. So... I was originally trying to set up another attribute using text, that would just link to a second info page where they could order the hardcopy book with Print on Demand. I definately didn't see any options to do that.

Is this cross sell mod something that might be able to do this?

Thanks for any help or feedback. :smile:

KismetDesign

27 Aug 2009, 8:53 PM
#547
masterrusty avatar

masterrusty

Zen Follower

Join Date:
Mar 2007
Location:
Oregon
Posts:
152
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

:oops:

OK so I figured out that there is now a "Random" display option in the Config settings. However, it does not seem to work. The items keep appearing in the same order.

Also, I am still trying to get the "We also recommend" Verbiage moved to the left of the column.

Here is a sample product page:
http://riversidelandsale.com/index.php?main_page=product_info&cPath=7_11_28&products_id=167

29 Aug 2009, 6:07 PM
#548
jarcher avatar

jarcher

New Zenner

Join Date:
Jul 2006
Posts:
10
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Same here - the addon refers to an addon which also refers to another addon that is not uniquely identified and the name cross sell is overloaded. Can anyone help here?

thanks
john

KismetDesign:

Question for you... I accidentally installed the cross_sell_advanced_1-0, thinking that it was the original cross sell mod.

So... I went back to look for the original, and there are about 3 contributions that look like they could be the original because they are worded very similar. There's Cross Sell, and Cross-Sell, and yours.

Which should I install?

One more question... I have a product that is up right now, available in 3 different reader formats for download. I have those listed at the top of the item.

My client has decided that we want to offer Publish on Demand for this product too, but says that for that option, we need a new information page.

He wants me to list the 'Order Hardcopy' as just a text link, right under my attribute options for the downloads. So... I was originally trying to set up another attribute using text, that would just link to a second info page where they could order the hardcopy book with Print on Demand. I definately didn't see any options to do that.

Is this cross sell mod something that might be able to do this?

Thanks for any help or feedback. :smile:

KismetDesign

29 Aug 2009, 6:21 PM
#549
jarcher avatar

jarcher

New Zenner

Join Date:
Jul 2006
Posts:
10
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

how did you add the jquery version to the upsells/crosssells? - that is nice...

thanks
john

1 Sep 2009, 4:07 PM
#550
kismetdesign avatar

kismetdesign

Zen Follower

Join Date:
May 2009
Location:
Junction City, Oregon
Posts:
315
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

jarcher - I had already installed the cross sell advanced, before I realized I needed the original mod as well. So, I installed the Just Another Cross Sell mod (the one we're primarily talking about on this forum), and then ran into the issue of not having the module manager installed. So I went back and installed that and then this.

So, I successfully installed all 3 with the exception of having just a couple of questions afterwards.

I think you can get away with just installing the 2 mods: the module manager and then the just another cross sell mod.

Does that sound about right to everyone?

1 Sep 2009, 4:10 PM
#551
kismetdesign avatar

kismetdesign

Zen Follower

Join Date:
May 2009
Location:
Junction City, Oregon
Posts:
315
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Update: I installed the Module Manager and the Just Another Cross Sell Module. If I go into my admin section and click on Tools -> Module Manager and then click on List all modules: I get this to show up: 1 ri_jaxs 1 Revision 185 update

Is this what I'm looking for? Do you think I ran everything correctly?

Thanks for any help. :smile:

KD

4 Sep 2009, 4:01 PM
#552
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

I am getting ready to install cross sell. Which one?

This one (I think) is in this forum.
Cross Sell - Just Another Cross Sell Mod
Last Updated by: yellow1912 Apr 24 2009 v1.3.8 rev 186

Do I also install with above one?
Cross Sell Advanced
Last Updated by: Absolute May 26 2007 v1.3.7 1.0

What is this one?
Cross Sell
Last Updated by: matteoraggi.com Jan 06 2008 v1.3.7

Any advice on which one to load?

Thanks,
Kim

4 Sep 2009, 6:17 PM
#553
kismetdesign avatar

kismetdesign

Zen Follower

Join Date:
May 2009
Location:
Junction City, Oregon
Posts:
315
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

You don't need the last one at all.

4 Sep 2009, 6:20 PM
#554
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

KismetDesign:

You don't need the last one at all.

Thank you:clap:

Does it matter which one I load first out of the first two?

Kim

4 Sep 2009, 9:06 PM
#555
kburner avatar

kburner

Totally Zenned

Join Date:
Apr 2008
Location:
Flint, Michigan
Posts:
684
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

kburner:

Thank you:clap:

Does it matter which one I load first out of the first two?

Kim

Ok started reading directions and said to load "module manager" first.

Is this Correct? Load in this order.
Module manager
Cross sell - just another cross sell mod
cross sell advanced

Thanks, Kim

14 Sep 2009, 7:43 PM
#556
shane78 avatar

shane78

Banned

Join Date:
Oct 2008
Location:
newcastle upon tyne (UK)
Posts:
876
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

just wanted to say thank you to Yellow for all the work he does towards ZC

i have installed this add-on.. works 1st time!

Cheers

14 Sep 2009, 8:30 PM
#557
molywerks avatar

molywerks

Zen Follower

Join Date:
Aug 2006
Posts:
136
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

In Tabbed Products Pro I have created several tab clones to hold my several Cross Tab clones. Each tab functions properly just like the original cross sell tab of TPP. And now I am trying to create a "combo" tab that holds the data of two or more other tabs. I got that far but now realize I need to ensure that the "combo" tab is not omnipresent as is the case now.

What is it about Zen Cart, and in this case the Cross Sell mod, that lets Tabbed Product Pro to not display a contentless tab? Or what is it that is in TPP that hides empty tabs (which I can certainly ask in TPP if/when appropriate))?

This probably will be more involved than the copy'n'pasting I've done thus far (and obviously changing pertinent reference points and whatnot) in Cross Sell cloning and in includes\modules\tabbed_products_pro.php. Seeing as I am combining cross sell clones, I'll probably need to write or mimic an OR statement or two somewhere in one of Cross Sell's files or in tabbed_products_pro.php.

IF Cross Sell is empty AND Cross Sell 2 is empty AND Cross Sell 3 is empty, too, THEN do not show the Combo Tab OTHERWISE display the tab.

25 Sep 2009, 12:12 AM
#558
teedave avatar

teedave

New Zenner

Join Date:
Feb 2007
Posts:
3
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Hi All,
I have been asked to implement a one-click add to cart functionality, which I have done, so I thought I'd share!

This is for version 1.3.1

Juts replace the loop at the bottom of template_directory/xsell_products.php page with this (you will need to change template directory info):

while (!$xsell_query->EOF) {

// add add_to_cart button
$add_to_cart_text = '<form name="cart_quantity" action="index.php?main_page=product_info&products_id=' . (int)$xsell_query->fields['products_id'] . '&action=add_product" method="post" enctype="multipart/form-data">
<input type="hidden" name="cart_quantity" value="1" /><input type="hidden" name="products_id" value="' . (int)$xsell_query->fields['products_id'] . '" />';

$add_to_cart_button = zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);

$display_add_to_cart_button = zen_get_buy_now_button($xsell_query->fields['products_id'], $add_to_cart_button);

$add_to_cart_text .= $display_add_to_cart_button . '</form>';

// add view details button
//button_goto_prod_details.gif
$details_button = zen_image(DIR_WS_TEMPLATES . 'freetemplate2/buttons/english/' . BUTTON_IMAGE_GOTO_PROD_DETAILS, 'Show Product Details');

$xsell_query->fields['products_name'] = zen_get_products_name($xsell_query->fields['products_id']);
$list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsCrossSell centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',
'text' => zen_image(DIR_WS_IMAGES . $xsell_query->fields['products_image'], $xsell_query->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br /><a href="' . zen_href_link(zen_get_info_page($xsell_query->fields['products_id']), 'products_id=' . (int)$xsell_query->fields['products_id']) . '">' . $details_button . '</a>' . $add_to_cart_text . '<br />' . $xsell_query->fields['products_name'] . (XSELL_DISPLAY_PRICE=='true'? '<br />'.zen_get_products_display_price($xsell_query->fields['products_id']):'') );
$col ++;

if ($col > (SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS -1)) {
$col = 0;
$row ++;
}
$xsell_query->MoveNext();
}

I had to add minor styling to the buttons for them to line up, so:

$details_button = zen_image(DIR_WS_TEMPLATES . 'freetemplate2/buttons/english/' . BUTTON_IMAGE_GOTO_PROD_DETAILS, 'Show Product Details', 100, 20, "style="padding: 6px;"");

and

$add_to_cart_button = zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT, "style="padding: 5px;"");

lines were changed accordingly.

Hope this helps someone.
Cheers
Dave T

26 Sep 2009, 1:09 AM
#559
dealbyethan_com avatar

dealbyethan_com

Totally Zenned

Join Date:
Dec 2005
Location:
Perth, Western Australia, Australia
Posts:
782
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Hi, the following message appears just below the shopping cart (on the "View Cart" page). How do I fix this problem? Please help. Thanks.


1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1)' at line 1
in:
[(select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '9962' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '12603' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '6081' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '5082' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '3304' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '12600' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '10290' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit 2) UNION (select p.products_id, p.products_image from zen_products_xsell xp, zen_products p, zen_products_description pd where xp.products_id = '5668' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = '1' order by xp.products_id asc limit -1)]


27 Sep 2009, 11:26 PM
#560
belaze avatar

belaze

New Zenner

Join Date:
Dec 2006
Posts:
84
Plugin Contributions:
0

Re: Just another Cross-Sell mod (support thread)

Hi All,
I installed "Just another Cross-Sell" mod, uploaded all the files and manually ran the sql files since module manager would not find it.

The mod shows under the right places in the admin section and it tells me when I cross sell a product > "Product 14 has been added as a Cross-Sell to Product 42"...

but when I go to the online store it does not display any cross sells.

  1. I did upload all files
    2)I did modify the files as stated in the readme file.
  2. I have module manager installed.

Am I missing any thing?

Any help would be greatly appreciated. :smile:

Thanks,
Dario