Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newbe Questions


Guest

Recommended Posts

Hi,

 

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:

 

Specials

 

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

 

[TEP STOP]

 

 

Look forward to all your replies,

 

 

Neil

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?

 

 

Thanks

 

Neil

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.

 

Vger

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...