Zen Cart Logo
Forums / Customization from the Admin / Add on product in the site

Add on product in the site

Locked

Views: 2,756

Results 1 to 20 of 20
This thread is locked. New replies are disabled.
9 Dec 2007, 9:44 AM
#1
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Add on product in the site

Hi,

I am running the site https://www.spradhanflorist.com , I want to know if there is any possibility to add "Add on" product in ZenCart. So that, when user will try to buy any product, the Add on product will display in the bottom of the main product which the customer want to buy.

Please help me to add "Add on" product in ZenCart.

Waiting for your reply,

With Best Regards,
WDH

9 Dec 2007, 11:37 AM
#2
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Add on product in the site

Please search for the 2 modules: Cross Sell and Better Together.

10 Dec 2007, 6:31 AM
#3
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Hi, yellow1912, I have already downloaded those modules Cross Sell and Beter Togather. Will you please define me how it works and what i have to do next to add "Add on" products?

My Admin>Catalog>Advanced Cross-Sell> showing the following statement ::
"1146 Table 'spradhan_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."

Any suggession? how to create that DB table? Please help me

With Best Regards,
WDH

10 Dec 2007, 6:34 AM
#4
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Add on product in the site

Did you read the readme file comes with the package? It should contain detailed instruction on how to install and use it.

OH, seem like you are missing a file. Please read the readme file carefully and make sure you upload all the files to the correct folders.

10 Dec 2007, 7:58 AM
#5
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

i have not found the readme file inside your zip. and also i am unable to install the SQL patch of "cross_sell_1.3.1" .. it is showing the following error.

--------error start---------
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.

------end of error---------

I have found a readme file in "cross_sell_1.3.1" package and followed those carefully. but.. huh..

Any suggession? Please help me.

With Best regards,
WDH

10 Dec 2007, 9:11 AM
#6
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Oh! atlast i have done it...:clap:

Please note that, and do the change as i am mentioning..

Replace the code -->

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());]

Replace with the code -->

INSERT INTO spradhan_zc1.zen_configuration (
configuration_title ,
configuration_key ,
configuration_value ,
configuration_description ,
configuration_group_id ,
sort_order ,
date_added ,
set_function
)
VALUES (
'Cross-Sell - Display prices?',
'XSELL_DISPLAY_PRICE',
'false',
'Cross-Sell -- Do you want to display the product prices too?<br />Default: false',
'18',
'72',
now(),
'zen_cfg_select_option(array(\''true\'',\''false\''), '
);

It is now working fine with PHP5.

Waiting for the script developers correction for the "cross_sell_1.3.1" >> "products_xsell.sql" .

With Best regards,

WDH
www.webdesignerhoster.com , www.spradhanflorist.com , www.bstflorist4u.com/bestflorist/

10 Dec 2007, 3:48 PM
#7
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Add on product in the site

First, FYI, that cross sell is NOT written by me.
Second, seem like you run the patch on phpmyadmin, that patch is designed to be run usng ZC Admin SQL patch tool.

11 Dec 2007, 6:23 AM
#8
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Hi,

I have also tried to use ZC admin SQL patch upload, but the error i shown, what i have received. So i have done it through phpMyadmin. will you please correct it if it has any wrongs? bcause i gor error which i have described previously.

With Best Regards,
WDH

11 Dec 2007, 6:26 AM
#9
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Add on product in the site

Someone has exactly the same error, and I posted the solution just 1 or 2 previous page in this topic ^^. (oops, my bad, another thread _)
However, If you used phpmyadmin and everything is functioning then there is no need to try running it from the admin tool again.

11 Dec 2007, 6:45 AM
#10
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Thanks a lot for your information. I need some more help.

I need two category box, like one will be for "Flowers" and other one will be for "Events". Both should be shown in the left side box accordingly. How can i do that using ZenCart.

And one more thing, please open the site https://www.i4uflorist.com << i used orange template for this site. But see, in the center colomn, the underline is comming just under 2 rows of the 3. and when i set number of rows 2, then the underline is comming just under the 1st row. I mean there last row is out of the block .. Any suggession for that?

Waiting for your reply,

WDH

11 Dec 2007, 7:46 AM
#12
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: Add on product in the site

If you want these boxes one right above the other, you can get the effect using Categories Dressing.

Organize all the categories in the sort order you want, and insert a non-linked heading above the first category in the second group. Make the heading look like the box heading.

12 Dec 2007, 9:04 AM
#13
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Dear Glan,

I have tried the Category listing in my another site https://www.spradhanflorist.com . Its good, but one thing is there, will you please suggest me how to insert a category just under the "Comming soon" button in that site? I have tried to insert a category item just under the "Coming Soon", but that category showing under the Category Item.

And more than that i want, if any customer clicks on the subcategory under the Category links, the center box i want to show like the home page. i.e. the products i don't want to show in single product per row. I want 3 produts per row. and when the user again click on the product, then it will go for the product description page.

How it is possible? awaiting for your kind help.
With Best Regards,
WDH

12 Dec 2007, 10:10 AM
#14
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: Add on product in the site

Sorry, you can't place categories in with the new products and all products links. They have to be above the links, unless you do some custom coding.

You can put the Coming Soon heading above your category item in the standard Categories Dressing.

For the product layout you want, get the Column Layout Grid mod from Downloads.

12 Dec 2007, 11:27 AM
#15
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Dear Glen,

I am glad to get your opinion. The Column Loyout Grid working good. Thanks for this kind help, But i am still working in Categories Dressing.. .. I will let you know when all will be completed.

Thanks for your kind information.

With Best Regards,
WDH

15 Dec 2007, 6:52 PM
#16
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Dear Glen,

I have integraded your Category Dressing tool. Please look https://www.spradhanflorist.com . Its really nice. Will you please tell me one thing, how can i display Cross sale page in the "index.php?main_page=shopping_cart" page?

Please help me in this matter.

With Best Regards,
WDH

15 Dec 2007, 7:14 PM
#17
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: Add on product in the site

Good job! That does look very nice.

I haven't used any cross sell mod, so can't help you there. You might post in the support thread for the one you are trying to use.

15 Dec 2007, 7:23 PM
#18
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Thanks Glen.

In near future i want to submit my all designed templates to Zencart Template. So that user can doenload and use those for their use. How it is possible?

I am Rudraraj from Kolkata, India. And I am the owner of the site https://www.webdesignerhoster.com . I have designed the follwing sites in zen cart::

https://www.spradhanflorist.com
https://www.spradhanflorist.com/usa/
https://www.bestflorist4u.com
https://www.we4uflorist.com
and so on. I want to show and publish all templates to ZenCart for further Use. So that Zencart can get some revenew from those templates. I don't need a single penny for that. That should be as a contribution. But I want ZenCart should get some money from those. Becase I really love ZenCart and their developers for their kind help to me.

Waiting for your reply,
WDH

15 Dec 2007, 8:08 PM
#19
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: Add on product in the site

Those are nice looking templates, and it's good of you to want to contribute them to Zen Cart. It will take some work to make the template files into a package that you can zip up without personal settings or information. You might want to look at some of the existing template packages in Downloads to see how to organize your own.

I might suggest you start with spradhanflorist.com/usa/, as that is the most distinctive design with its soft sidebar edges.

15 Dec 2007, 8:39 PM
#20
wdh avatar

wdh

New Zenner

Join Date:
Oct 2007
Posts:
56
Plugin Contributions:
1

Re: Add on product in the site

Dear Glen,

Thanks for your kind reply. I will make the package very soon and will send to ZenCart authority to grant my contribution. As well as I am too much happy to get your all possitive services. You and all ZenCart member are really helpfull. Thanks a lot.

And I will inform you after completion of my zip. I want to be Zenned in near future with your kind and valuable suggession.

Thanks,

--WDH (Rudraraj)