Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Newbe Questions


Recommended Posts



Having just installed the cart i am impressed, however there are a few things i need to add to make it work for me.


1) Does anyone know how to add a user input box for an item in the cart? We have the requirement to add a message to an item.


2) On one item we have the option to request for next day delivery for an extra fee. Is there a way to add this to just one item?


3) I need to make the whole look and feel of the cart like our existing site. Any tips for doing this?



If anyone can answer my questions I would be grateful... .


Also I get the following error on some pages in the admin section:




Products Products Price Status Action

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 '-20, 20' at line 1


select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20





Look forward to all your replies,




Link to comment
Share on other sites

1. attributes options contribution

2. products attribute option

3. programming, design done with stylesheet.css

your 20,20 is very much searchable to ressolve, as it is dealing with a higher version of mysql than what is recommended.

thus, to get your feet wet, use the search in tips and tricks.

search is your best friend and reading is too.

Link to comment
Share on other sites

Thanks for the VERY quick reply!!!


I will give them all a try and see how i get on..


I am using MySQLv4 at the moment.

Link to comment
Share on other sites

Hi Mibble,


I have just run through 1 and 2. I can?t seem to find a way for customers to enter their own text. We print messages into vouchers purchased and are looking for a way to do this. Any ideas?






Link to comment
Share on other sites

I can?t seem to find a way for customers to enter their own text


Check through Contributions. There should be something there that will do what you want. However, my advice, for what it's worth, is to get to grips with the basic osCommerce before jumping into trying to amend it.


But if you do dive straight in then remember - BACKUP, BACKUP, BACKUP.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...