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.

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.

Quote:

---

Originally Posted by 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_PRODUC TS','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:

Also,

Thank YOU very much yellow1912 - great module mash!

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

: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.p...roducts_id=167

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

Quote:

---

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

---

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

thanks
john

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?

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