Jump to content
Sign in to follow this  
saashosc

Featured Products Add-On

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

@@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 by saashosc

Share this post


Link to post
Share on other sites

@@saashosc

 

Run the SQL statement supplied with the contribution

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

@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: b_help.png

#1062 - Duplicate entry '18' for key 1

Share this post


Link to post
Share on other sites

@@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 by multimixer

Share this post


Link to post
Share on other sites

@@saashosc

 

The error means the table is already created.

 

Use George's suggestions to ensure the filenames and database table files are correct.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

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

 

form.jpg

 

Thanks

Edited by saashosc

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×