Just another Cross-Sell mod (support thread)

[yellow1912]

Copy your settings in Admin->configuration->Cross-sell here.

[brimsjewelry]

Copy your settings in Admin->configuration->Cross-sell here.

Title Value Action
Input type to be used in form model
Display Cross-Sell Products 1
Display Cross-Sell Products 6
Cross-Sell Products Columns per Row 3
Cross-Sell - Display prices? true

[yellow1912]

It seems to set correctly. If your xsell products are not displayed on the product's page, check if you have installed the original XSell mod correctly (check all the steps again, if you are using a custom template then you have to edit you custom template, not the default one).

Please remember that my mod (currently) does not have anything to do with displaying the xsell products on the site, it simply makes it much more easier for you to cross-sell products in admin.

[brimsjewelry]

Hmm ok, I didn't realize your mod only enhanced the xsell mod. Xsell seems set up correctly too so I'll just have to do some research and figure out the problem.

Thanks!

Jason

[yellow1912]

Yes, I'm sorry that I could not help you.
There is one more thing you can check: if you know how to use phpmyadmin, use it to access the cross-sell table, see if it's set up correctly (product with id X cross-sell to product with id Y, etc...)

[brimsjewelry]

Hi,

I got it to work. I started from scratch and reinstalled xsell. I guess I missed something the first time around.

Many thanks!

Jason

[paulm]

I would definitely be interested in adding an add to cart button along with quantity box to the cross sell items! That would save extra clicks for my customers and streamline their shopping experience. Please post the code either here or in a new thread.

I decided to post what I have in another thread: http://www.zen-cart.com/forum/showth...261#post437261

Actually, my current mod does not touch any file belongs to the old Cross-Sell mod, which is working just fine. I will have to contact the author of that mod, asking for his permission before making any change

It's GPL, so you don't *have* to contact the author. Of course it's often wise to contact the author, and I assume you meant something along that line. But I doubt if there's someone available who's the current author of cross sell. There are many authors of pieces of cross sell code.

[AppMedia]

Hi there,

I seem to receive the following error but i'm not quite sure on how to fix it.

1146 Table 'wwwmaxg_zc1.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from zen_products p, zen_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]
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.

Now the table "TABLE_PRODUCTS_XSELL" exists within my database. I'm not too sure what is going wrong over here though. Any ideas on how to fix this?

Much Appreciated!

[AppMedia]

I was thinking about the error and was wondering whether it had to do with my input as I am getting this error when I input something and hit submit.



1146 Table 'wwwmaxg_zc1.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select count(products_id) as records from TABLE_PRODUCTS_XSELL where products_id = '12' and xsell_id = '13']
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.



Would products_id have to be zen_products_id as that is what is being shown in my database?

[yellow1912]

It seems that you are missing the definition of TABLE_PRODUCTS_XSELL. If you are using a custom template, make sure you change the name of the folders (as instructed in the readme file) BEFORE you upload all the files and folders to your server.