I would def. leave this job up to the database. My companies e-commerce system uses (in simple terms) a table which represents your order header, which has your system generated order number, which is also the basket header (baskets and orders are all the same, it's just basket is one of the orders status', as is paid & dispatched)