saashosc Posted February 17, 2012 Share Posted February 17, 2012 (edited) Hi All, Iam new to OSC and iam developing onlie store with osCommerce Online Merchant v2.3.1 I installed and customized and working fine. Now i would like add/show 5 seleted products on home page. Can any one suggest an Add-On? Thanks Edited February 17, 2012 by saashosc Quote Link to comment Share on other sites More sharing options...
Guest Posted February 17, 2012 Share Posted February 17, 2012 @@saashosc Use Featured Products Chris Quote Link to comment Share on other sites More sharing options...
kelagedart Posted February 19, 2012 Share Posted February 19, 2012 I am considering installing Featured Products in my 2.2.rca dut the docs said someting about it *replacing* the New Items Listings. I want to have both. Is this possible???? Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 19, 2012 Author Share Posted February 19, 2012 @@DunWeb I just successfully installed. Thanks DunWeb Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 19, 2012 Author Share Posted February 19, 2012 (edited) @@DunWeb I installed same in my webserver, but iam getting an error in admin: ------------------------------------------------------------------------------ Featured Products 1146 - Table 'colorpi_chinababy.TABLE_FEATURED' doesn't exist select count(*) as total from products p, TABLE_FEATURED s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id [TEP STOP] Edited February 19, 2012 by saashosc Quote Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2012 Share Posted February 19, 2012 @@saashosc Run the SQL statement supplied with the contribution Chris Quote Link to comment Share on other sites More sharing options...
multimixer Posted February 19, 2012 Share Posted February 19, 2012 1146 - Table 'colorpi_chinababy.TABLE_FEATURED' doesn't exist Check if you have TABLE_FEATURED defined in file catalog/includes/database_tables.php Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
saashosc Posted February 19, 2012 Author Share Posted February 19, 2012 @DunWeb Its was perfectly working on local host, but not in Webserver. Now i run the SQL again and showing Error on DB -------------------------- Error SQL query: INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '18', 'Featured', 'Featured Products Display', '18', '1' ); MySQL said: #1062 - Duplicate entry '18' for key 1 Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 19, 2012 Author Share Posted February 19, 2012 @@multimixer Yes, i defined it in file catalog/includes/database_tables.php // BOF: Featured Products define('TABLE_FEATURED', 'featured'); Quote Link to comment Share on other sites More sharing options...
multimixer Posted February 19, 2012 Share Posted February 19, 2012 (edited) @@multimixer Yes, i defined it in file catalog/includes/database_tables.php // BOF: Featured Products define('TABLE_FEATURED', 'featured'); You need to do the same in admin catalog/admin/includes/database_tables.php The error showing the table name in capital letters mean that the constant is not defined Error has nothing to do with any sql so far Edited February 19, 2012 by multimixer Quote My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2012 Share Posted February 19, 2012 @@saashosc The error means the table is already created. Use George's suggestions to ensure the filenames and database table files are correct. Chris Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 20, 2012 Author Share Posted February 20, 2012 (edited) @@multimixer and @@DunWeb. You guys are just rocking. Now it got fixed. And working fine. Now i need few additional fields (Delivery Date: Pick Up Date: and Delivery Time: Pick Up Time: ) on Delivery Information page. Please check screen short, and can you please suggest a add-on or idea? Thanks Edited February 20, 2012 by saashosc Quote Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2012 Share Posted February 20, 2012 @@saashosc You can use Delivery Date and you can look at Delivery Time Table Chris Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 20, 2012 Author Share Posted February 20, 2012 @DunWeb Iam still checking on Delivery Date. I wanted to charge some% (may be 30%) to the total bill. Lets say the customer buy items worth 100$, then at the final bill i charge him extra of 30% of total amount, meaning 30$. Can you please help me? Quote Link to comment Share on other sites More sharing options...
saashosc Posted February 20, 2012 Author Share Posted February 20, 2012 @DunWeb. Delivery Date: I have checked, this is for admin add/defined delivery date/time in each product, in each module delivery. This not one iam looking. I need to place a form in Delivery information page with Delivery Date: Pick Up Date: Delivery Time: Pick Up Time: So, customer enter the details and then make payment etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.