Cross-Sell Advanced!

20 Sep 2006, 23:30

#1

Totally Zenned

Join Date:: Apr 2005
Posts:: 1,356
Plugin Contributions:: 0

Cross-Sell Advanced!

After realizing the current cross-sell module was very difficult to use if you have over a few hundred products, I contracted Chris (aka 'Absolute') from absolute-solutions.co.uk, to enhance this mod. The result: Cross-Sell Advanced!

What this mod does:
This mod uses all of the same functionality of the original mod on the catalog side. On the admin side, it allows you to assign cross-sell items quickly by first inputting the model # of the item you want to assign products to, and then input the model number for each item you want to cross-sell in the fields below it. Hit insert and you are done! Basically the idea is for you to use the catalog side to decide which items to cross-sell, and this quick and easy form to assign them. It also includes a list of the current cross sells and a search function to quickly find and edit/delete current cross sells.

All credit goes to Absolute for doing the coding (and of course to Merlin for the original mod). I just came up with idea and the cash :wink2: . I figured there would be many here who would enjoy it.

I assembled this download myself so please let me know if it works or not (I merged the new mod with the original). Once I get confirmation it works I will take down this link and submit it to the official download section.

The download includes the original readme along with instructions on how to "upgrade." Upgrading is easy, just upload the new files and you are ready to go - see the install.txt. (none of the original cross-sell files will be deleted).

Here are screenshots for your viewing pleasure.

http://www.moissaniteco.com/download/screenshot-1.gif
http://www.moissaniteco.com/download/screenshot-2.gif

21 Sep 2006, 19:24

#2

sn0ut

New Zenner

Join Date:: Oct 2005
Posts:: 56
Plugin Contributions:: 3

Re: Cross-Sell Advanced!

superb buddy :) thanks for releasing this, installed on 1.3.5 and its super. I have one question tho my online shop uses the barcode number as the model number so we can use a barcode scanner in store to quick enter when the store is used a a POS system on the till.

Having the advanced x-sell based on model number makes life very hard.. is there any way of modifying this to use product name instead?

21 Sep 2006, 20:02

#3

voltage

Totally Zenned

Join Date:: Apr 2005
Posts:: 1,356
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

When I hired Absolute to create this for me, I realized that for some, using the model number would be difficult, but it was the best solution to fit my needs. I'm not sure using the product name would be all that easy either (i guess it would depend on how complex the product naming scheme was). It could be altered to use the product id, which in the end is how it is stored in the database.

I'm glad to hear it works on 1.3.5. So for those who are wondering, it has been tested and works on 1.2+, 1.3, and 1.35.

On a side note, one way to more quickly use the barcode is to have it show on the product listing and as you find items to cross sell, you can copy and paste the model number into the advanced xsell form (have two windows open and hitting control + tab allows you to toggle between two windows). Anyways, just a thought.

22 Sep 2006, 08:23

#4

lennypeng

New Zenner

Join Date:: Nov 2004
Posts:: 45
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Thank you very much for the mod, it works perfect with my 1.3.5

23 Sep 2006, 18:14

#5

phid

Totally Zenned

Join Date:: Nov 2005
Posts:: 696
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Hey thanks to Voltage for taking the lead on this. I think that cross promotion is really quite an essential activity in e-commerce and this advanced mod should make it a bit quicker to do.

One question - I noticed that while using the Tabbed Products Lite mod the advanced cross sell box is showing with its header even though I have "Show Tab Headers" turned off. Is there a quick solution to this?

27 Sep 2006, 21:00

#6

phid

Totally Zenned

Join Date:: Nov 2005
Posts:: 696
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Nevermind....I did it by changing the <h2 class="centerBoxHeading"> in tpl_modules_xsell_products.

28 Sep 2006, 00:19

#7

tajul_ashyqin

Zen Follower

Join Date:: Apr 2006
Posts:: 362
Plugin Contributions:: 1

Re: Cross-Sell Advanced!

wow, very nice mod indeed! thanx voltage and chris!:smartass: one question; can these CS Advanced mod be install together with the old Xsell mod?!

28 Sep 2006, 00:36

#8

tajul_ashyqin

Zen Follower

Join Date:: Apr 2006
Posts:: 362
Plugin Contributions:: 1

Re: Cross-Sell Advanced!

oops, i just installed the CS Adv together with the ori CS mod and it works like a charm! :laugh:

28 Sep 2006, 03:54

#9

voltage

Totally Zenned

Join Date:: Apr 2005
Posts:: 1,356
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Actually, when I merged the new files with the original cross sell, I left the original files so that the package installs both. That way, you have both options.

28 Sep 2006, 06:45

#10

tajul_ashyqin

Zen Follower

Join Date:: Apr 2006
Posts:: 362
Plugin Contributions:: 1

Re: Cross-Sell Advanced!

:smile:

it would be more advanced if these mod can show the images of the cross sell items just after we opt to EDIT any of the current cross-sells products!

28 Sep 2006, 16:29

#11

phid

Totally Zenned

Join Date:: Nov 2005
Posts:: 696
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Say, what would be the point of having both X-sells on at the same time?

29 Sep 2006, 00:08

#12

tajul_ashyqin

Zen Follower

Join Date:: Apr 2006
Posts:: 362
Plugin Contributions:: 1

Re: Cross-Sell Advanced!

Phid:
Say, what would be the point of having both X-sells on at the same time?

yeah, you're right! :P

29 Sep 2006, 02:25

#13

voltage

Totally Zenned

Join Date:: Apr 2005
Posts:: 1,356
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

The current installation package attached to this thread installs both xsells. I agree it may seem redundant, but I figured there is no harm, and someone might find use for both. Personally, I felt the navigation system for the original was terrible which was why I never used it.

Showing the images when the edit button is hit would be a good addition to this.

02 Oct 2006, 14:05

#14

g0d4lm1ty

Zen Follower

Join Date:: Sep 2006
Posts:: 257
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/poison67/public_html/idiame/shoppingcart/admin/xsell.php on line 266

i get this on cross sell screen...every item
help..... thanx

03 Oct 2006, 20:34

#15

pivey

Zen Follower

Join Date:: Mar 2006
Posts:: 192
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

I get this error after installing the contrib:

1146 Table 'testbase.table_products_xsell' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from products p, products_description pd, TABLE_PRODUCTS_XSELL px where p.products_id = pd.products_id and p.products_id = px.products_id and pd.language_id ='1' group by p.products_id]

Fresh 1.3.5 install, No additional Mod's..no modifications
Database created succesful, i checked, is there....

03 Oct 2006, 20:44

#16

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Cross-Sell Advanced!

pivey, sounds like you're missing the file that contains the define() statement for TABLE_PRODUCTS_XSELL, which likely looks like this:

define('TABLE_PRODUCTS_XSELL', 'products_xsell');

and should be in the extra_datafiles folder in the contribution's files

03 Oct 2006, 23:04

#17

pivey

Zen Follower

Join Date:: Mar 2006
Posts:: 192
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Yes, that exactly is the error caused.
The file is already on the ftp. But I just realized that it is corrupt.
Whatever I try, can't make it work.

Can't open the file in editor either. Have downloaded the zip 10 times, extracted 10 times. I can only open the file only as soon as I extract the zip. Seems that something goes wrong during or after upload to FTP.

First time such a stupid bug?
Has anyone dealed with such an error?

04 Oct 2006, 03:47

#18

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Cross-Sell Advanced!

Well ... try creating a new file of similar name and content, and upload that.

maybe try a new zip program, or a different computer?

04 Oct 2006, 21:10

#19

pivey

Zen Follower

Join Date:: Mar 2006
Posts:: 192
Plugin Contributions:: 0

Re: Cross-Sell Advanced!

Thank you doctor.
I will do that....always this Tach Crash...@^*)... :lamo:

06 Oct 2006, 19:39

#20

jhosford

New Zenner

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

Re: Cross-Sell Advanced!

Hi guys,

Everytime I try to patch my database (Using the normal admin screen) I get the following errors:

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 'true','false'), ', now())' at line 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array('true','false'), ', now());]
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.

I've downloaded both V1.3 and Advanced and it does this with both sql files. Being absolutely new to sql databases, I'm nowhere near qualified to troubleshoot this one. Any help is appreciated.

Jon