Delivery Time in osCommerce

The other day, I was asked about the possibility of including a time selection field in the shipping page of an osCommerce site. A typical example would be a delivery service such as a flower shop.

This is very alike my previous code for selcting a delivery date which works well. Basically, all I had to was copy that but make it "time" instead of "date".

With some Googling, I found a nice jQuery based timepicker which i integrated into the checkout_shipping page.

So, the checkout_shipping.php after the changes;

In the admin, on the orders.php details, it looks like this;

Obviously I chose that date and time in the checkout page. Th selcted date and time also shows in the customer facing order history page(s) as well. Sweet!

As you can see I prettied up the time selector by adding a clock image. Looks pretty nice!

Posted in Style
  • Maano

    Hi, where can i find this contribution?

  • Gary

    I never made it into a contribution. It's really easy though if you give it a go.

  • http://www.comprecestas.com Diego

    Hi, I'm in need of contribute as this. Could I send it via email?

    Thanks.

  • Ralfm

    Hello Gary

    Your delivery time is very good, congratulations, but i have now a problem:

    How can i integrate the jQuery based timepicker into the checkout_shipping page?

    Thank you very much
    Ralf

  • Gary

    Guys, you need to install the oscommerce datepicker http://addons.oscommerce.com/info/6178 and then repeat for the timepicker http://labs.perifer.se/timedatepicker/

    It's not difficult. If you want it all installed for you, email me and can do that at very low cost.

  • Ralfm

    Thanks for nothing. :-(

  • Gary

    Thank you for nothing :)

    Do not get Open Source, GPL and Free confused. You are running a business as is everyone else.

  • parry

    Thank you Gary for installing them for me!

    It's great :)

  • Gary

    Thank You Parry

  • Stan

    Hi,

    Can we prevent costumers to book twice the same time?

    I mean if the costumer 1 booked tuesday at 10 am I would like to block this delivery time.

    Thank you

    Stan

  • Gary

    Stan – that's possible, with a lot more coding. The way it's done now does not track time slots, so would need a way of marking slots which have been bought and not show them on a per product basis. Not straightforward. If you want to explore it further and get a quote, email me on oscshops@gmail.com

  • http://tiendahojasblancas.com Gabriel Zapata

    hi,
    the date is not stored in the database.
    shows this:
    table: delivery_date
    0000-00-00 00:00:00

    Thanks!

  • Gary

    Hi, means you have not installed correctly. Are you using paypal as the payment method?


Buy Gary A Beer?
Buying me a "beer" helps me to keep my contributions updated and keep this blog alive - and you get a link from my homepage to your site. Cheers!