Add on product in the site

[wdh]

Hi,

I am running the site 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

[yellow1912]

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

[wdh]

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

[yellow1912]

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.

[wdh]

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

[wdh]

Oh! atlast i have done it...

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/

[yellow1912]

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.

[wdh]

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

[yellow1912]

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.

[wdh]

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 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