| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
Related products: with thb. + N column format + add to cart button. | ||||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||||
|
|||||||||
Related products: with thb. + N column format + add to cart button.
UPDATE 24-10-2008,
UPDATE 29-10-2008 (sql code) UPDATE 22-01-2009 (sql code for xcart 4.1.9) Little mode for Related Product on the detail product page: a) a "PRODUCT THUMBNAIL PHOTO", will appear in related products b) they can specify "HOW MANY PRODUCTS, WILL APPEAR" in related products (you can specify this option in the admin area) c) allow for the "BUY NOW" BUTTON, to appear in related products (you can specify this option in the admin area) --------------------------------- 0. Backup mysql 1. Apply mysql patch: Code:
for version x-cart 4.1.9: Code:
2. Change file code for "skin1/modules/Upselling_Products/related_products.tpl" PHP Code:
PS. Tested for xcart 4.1.9 - 4.1.11. PS2. I would be grateful for any comments on that decision. Product details page: Admin area: |
|||||||||
#2
|
|||||||
|
|||||||
Re: Related products: with thb. + N column format + add to cart button.
Smile... abbreviations in your thread title make it hard to read... it took me a few seconds to translate and see what you have done... but is great
Is cool you pass this finished RELATED PRODUCTS mod... - so people can have their "Related Products" appear as:- a) a "PRODUCT THUMBNAIL PHOTO", will appear in related products b) they can specify "HOW MANY PRODUCTS, WILL APPEAR" in related products c) allow for the "BUY NOW" BUTTON, to appear in related products This is a great little mod, as I see lots of sites with boring "list of related products" - a list I personally thinks adds nothing (PHOTOS like in your mod achieves is just so much better!!!). Great little mod Yurij and I am sure many forum members will benefit from it... Your team is a great addition to the forum and does offer very useful coding advice. Cheers - Asiaplay
__________________
X-Cart Gold version 4.1.9 (plus built in X-Cart bugs!) |
|||||||
#3
|
|||||||||
|
|||||||||
Re: Related products: with thb. + N column format + add to cart button.
Quote:
Thank you for message. I used it for description this modification. ))) Yesterday i did not have time to write a description. |
|||||||||
#4
|
|||||||
|
|||||||
Re: Related products: with thb. + N column format + add to cart button.
No problem Yurji - know you are busy... your mod is cool (no surprises here, as can see you know x-cart code inside out)... so I just wanted to make sure, that new members understood what it does... as it is a useful mod, but also an easy one for everyone to implement if they want to...
All the best and cheers - Asiaplay
__________________
X-Cart Gold version 4.1.9 (plus built in X-Cart bugs!) |
|||||||
#5
|
|||||||
|
|||||||
Re: Related products: with thb. + N column format + add to cart button.
Works great here, thank you. However, if I leave the number blank (under: Display related products list in multiple columns (leave empty to use standard format): it reverts back to 3 or the previous number entered. Is there a way to make these line up vertically with a partial description?
Thank you
__________________
-------------------- X-Cart Gold 4.1.11 Linux/Apache -------------------- |
|||||||
#6
|
|||||||||
|
|||||||||
Re: Related products: with thb. + N column format + add to cart button.
Quote:
Yes. Try apply next mysql query: PHP Code:
|
|||||||||
#7
|
|||||||
|
|||||||
Re: Related products: with thb. + N column format + add to cart button.
Kudos Yurji, Great job!
Awesome mod. Thank you, Christine
__________________
______________ version 4.1.9 Gold |
|||||||
#8
|
|||||||||
|
|||||||||
Re: Related products: with thb. + N column format + add to cart button.
I'm trying to install it on version 4.1.9 and got the follwing error when trying to apply patch
SQL PATCH FAILED AT QUERY: insert into xcart_config VALUES ('sep001', 'Related product', '', 'Appearance', '4', 'separator', '', '', '') |
|||||||||
#9
|
|||||||||
|
|||||||||
Re: Related products: with thb. + N column format + add to cart button.
Quote:
For version 4.1.9 use next MYSQL patch: PHP Code:
PS. I have not tested on version below 4.1.11 (in 4.1.9 I think should work). If this does not work, I try to fix it later (for old version). |
|||||||||
#10
|
|||||||
|
|||||||
Re: Related products: with thb. + N column format + add to cart button.
I had the same error, though it was a quick fix as I realized I needed to make sure I had the correct fields in MYSQL database on our server. I also verified within my name field other instances of sep--, so I knew our database was on par with his query. Yurij's query is to update 9 fields in his database, but for my database I had only 8 fields. So I needed to remove one field from his query and it worked.
First verify in your MYSQL database the number of fields you have and that will determine the query string. For those who need help with understanding query structure: insert into xcart_config is inserting new data into the xcart_config table, then VALUES ('', '', '', '', '', '', '', ''); is indicating the query string to apply a value where each field is separated by single quote as 'field value name here' or '' (the '' will pass through without applying new information to that field). Here's how my query read: insert into xcart_config VALUES ('sep001', 'Related product', '', 'Appearance', '4', 'separator', '', ''); insert into xcart_config VALUES ('related_num_column', 'Display related products list in multiple columns (leave empty to use standard format)', '3', 'Appearance', '5', 'text', '', ''); insert into xcart_config VALUES ('related_add_to_cart', 'Enable add to cart button for related products', 'N', 'Appearance', '6', 'checkbox', 'N', ''); Christine Quote:
__________________
______________ version 4.1.9 Gold |
|||||||
|
|||
X-Cart forums © 2001-2020
|