Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Featured Products Add-On


saashosc

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
Link to comment
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
Link to comment
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

Link to comment
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
Link to comment
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
Link to comment
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...