-select p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_image, p.products_date_added, pd.products_name, pd.products_description,
m.manufacturers_name, cd.categories_name, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, st.stores_id from stores st, products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m, products_to_categories p2c LEFT JOIN categories_description cd
ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '0' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and st.stores_id = '5' and pd.language_id = '1' and p2c.categories_id = '0'
GROUP BY p.products_id
ORDER BY p.products_id DESC
Mothers Day 2010 Delivery Information:
We are open on Saturday & Sunday, March 13th & 14th.
Please note however, that some of our partners outside of Dublin may only be open on Saturday. We will do our very best in all of these cases to get your order fulfilled exactly as you ask for it.
Order Early –
Orders will be Accepted until 12 Midday on Saturday 13th of March.
After that, we cannot promise anything. We will do our best, and if it is not possible to get your order out on time we will deliver it on Monday for you. In all cases you will be notified as soon as is possible.
We will sell out again this year so don’t leave it too late.
We will do everything we can to make sure you flowers are successfully delivered as requested by you. Our job is made much easier when the following details are correct:
Recipients Phone Number
Please provide us with a phone number for the recipient (preferably a mobile). Without this all bets are off. We will do our best but we cannot guarantee delivery.
Please make sure the delivery address you provide is correct. If it is a house which is hard to find, please provide additional details in the “Additional Comments” field.
We cannot guarantee specific delivery times; however, you do have the option of selecting AM or PM delivery. We will do our very best to honour this. Please let us know if someone is leaving work early, or if they won’t be home until late etc.
In the shopping cart you will find a place for Additional Information field. This field is they so that you can help us help you. The more information you provide us about the location of the intended delivery address, the easier it is for us to get things right.
Nobody Home Policy
Our drivers tend to be logical people. They will do what makes sense depending on the situation they are face with if nobody is home. But generally speaking, this is what tends to happen:
1. We will call the recipient (unless we are asked not too) and make arrangements with them.
2. The next step we will take is to leave it with a neighbour and leave a Flowers Made Easy card in the door saying "Flowers left at number X"
3. If all else fails we will bring it back to base and await further instructions from you, the sender.
Please note that some hospitals, and some wards within other hospitals cannot accept flower deliveries. Please do your best to find out about your hospital before placing your order.
Funeral Flower Deliveries
Funeral Flowers are guaranteed. Please provide as much information as is possible in the Additional Comments field. We will look after the rest.
Same Day Delivery
We offer our customers a same day delivery service to most areas within Ireland, UK, Europe and the USA and a next day delivery service for Australia and New Zealand. This service applies to orders placed before 1 pm. This service is carried out by Flowers Made Easy where possible, or by our handpicked network of local florists around the world, where the address falls outside of our own delivery areas.
Next Day Delivery
Next day delivery is completed centrally from one of our central hubs around the world. This ensures that we can provide a top notch product delivered directly by Flowers Made Easy to you recipient.
Morning / Afternoon Flower Delivery
For certain areas, we can deliver in the morning or the afternoon. This is subject to an additional fee.
Public / Bank Holiday Flower Delivery
unfortunately we are closed on public holidays but only in the country where the public holiday effects. Click here for a list of these days for the different countries.
Sunday Flower Delivery
We are closed on Sundays except for Mothers Day, Valentine’s Day 2010.
International Flower Delivery
Flowers Made Easy have an official presence in the following countries:
We also have a network of handpicked partner florists in every corner of the world.
Click here for a full list of countries we deliver too. Our online system passes orders through our system automatically on receipt of the order. This means that you order will be delivered ASAP.