Magento: Customer Desired Delivery Date Module
This Magento Module allows you to add a date picker to the checkout process, which the customer can use to input a desired delivery date. There is minimal setup required. You will need to add the supplied code to your template pages in order to display the date-picker on the checkout process and add one line of code to the admin template. As soon as I find a convenient way to add the necessary block to the template files with out having to modify the template files I will remove the manual part of the Module.
Here is a link to the modules page: Delivery Date Plugin NOTE: Not compatible with Magento Ver 1.4.1 or above
To Add to email templates: (provided by Magento user: mrgniarf)
You can modify yourtheme/yourdesign/template/email/order/items.phtml and before :
<table cellspacing="0" cellpadding="0" border="0" width="100%" style="border:1px solid #bebcb7;background:#f8f7f5">
<thead>
<tr>
<th align="left" bgcolor="#d9e5ee">__('Sku') ?></th>
<th align="left" bgcolor="#d9e5ee">__('Item') ?></th>
<th align="right" bgcolor="#d9e5ee">__('Subtotal') ?></th>
<th align="center" bgcolor="#d9e5ee">__('Qty') ?></th>
</tr>
</thead>
Add:
<table cellspacing="0" cellpadding="0" border="0" width="100%">
<thead>
<tr>
<th align="left" width="100%" bgcolor="#d9e5ee">__('Desired Arrival Date') ?></th>
</tr>
</thead>
<tbody>
<tr>
<td valign="top" style="padding:7px 9px 9px 9px;border:1px solid #bebcb7;border-top:0;background:#f8f7f5">
helper('deliverydate')->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
</td>
</tr>
</tbody>
</table>
<br>
Here Is the Zip file for the module (DOWNLOAD).

117 Responses to “ Magento: Customer Desired Delivery Date Module ”
May 3rd, 2010 at 3:31 am
Great module. Works perfectly under 1.4.0.1CE.
Is it possible to get desired delivery date in transactionnal email ?
May 3rd, 2010 at 7:08 am
Hey Ben,
You can get the date into an email template using
{{var order.getShippingArrivalDate()}}This will probably be an un-formatted datetime string, so I believe that in transaction email you could format it like so:
{{var order.getShippingArrivalDateFormated(’long’)}}Let me know if this works for you.
May 22nd, 2010 at 3:01 pm
Thanks a lot for your module. Works like a charm.
I’ve tried to add the date into an email template (order).
With {{var order.getShippingArrivalDate()}}
I get : 2010-05-31 00:00:00
And with {{var order.getShippingArrivalDateFormated(’long’)}}
I get nothing
Have you got an idea ?
May 22nd, 2010 at 3:02 pm
an idea to get only 2010-05-31
May 23rd, 2010 at 5:13 am
another request please :
how can I get delivery date in progress column during order
in :
>> app/design/frontend/default /default/template/checkout/onepage/progress
doesn’t work with :
<?php echo "".$this->helper('deliverydate')->__('Desired Arrival Date').": ".$this->helper('deliverydate')->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
Thanks a lot
May 23rd, 2010 at 12:02 pm
@Gaebarre: For now you should be able to edit the email templates and use:
helper('deliverydate')->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>To place the delivery date into the template.
I will need to get back to you regarding getting the delivery date into the progress block. That will probably take editing the layout xml file.
May 26th, 2010 at 9:04 am
HI Mike
where to put this code in ?
helper(‘deliverydate’)->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
defiantly not in email template
May 26th, 2010 at 9:12 am
Hey Marcilud,
Please see the end of the post. I have updated it with this information.
May 28th, 2010 at 12:01 pm
For some reason when I add this module. On the one page checkout, after choosing date and clicking continue I get redirected to the shopping cart, any ideas? Thanks.
May 28th, 2010 at 12:20 pm
Hmm.. That is strange.
1. Is the site online so I could see this bug?
2. Does your cart contain all the products or is it empty after you get redirected?
3. Does this happen when trying to submit the order or when moving to the next step in the checkout process?
4. Does this happen in all browsers?
5. If you use FIREBUG and watch the console, when the background ajax calls fire, do any result in a 404 error?
June 3rd, 2010 at 4:35 pm
Hello,
Module is awesome! I would like change the text from “Desired Arrival Date” to “Delivery Date” & Also I would like to change comments” Please use the calendar icon to select your desired arrival date or leave blank for ASAP” as well. Is it possible? Please help!
June 6th, 2010 at 10:09 am
Hi
Music : change comments in
>> app/design/frontend/default/default/template/deliverydate/onepage/deliverydate.phtml
Mike
Sorry but can’t place the delivery date into the template. (html) with
helper('deliverydate')->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
Thanks
June 14th, 2010 at 10:32 am
Hi,
I have installed on Magento 1.4.1.0 through magento commerce. I don’t see this datapicker when I do the check out. Is there any changes I have to do?
Thanks
Robert
June 14th, 2010 at 11:03 am
Hi Robert,
Yes you will need to add a line of code to a template file.
In the modules main folder there is a readme.txt file that has directions on doing this. (app\code\community\Sharpdot\Deliverydate\ReadMe.txt)
June 15th, 2010 at 9:00 am
Hi mike ,
I have installed your module but cannot get it working …I have added the code to the template file as well …need help
June 15th, 2010 at 9:17 am
Hey Jesse,
Lets get a little background:
1. What Magento Version do you have?
2. Are there any error messages?
3. What template files did you update to try to get the code to show up.
4. Are there any JavaScript errors being thrown on the checkout page?
5. Is the site web accessible(so i can take a look).
June 16th, 2010 at 5:25 am
hi,
the magento version is 1.4.0.1 , i did not get any error messages nor I got the output on the checkout process .
i have added the code to shipping_method.phtml and deliverydate.xml , there are no java script errors on the checkout page ….
yes the site is online …please have a look at giftasmile.com and a review on the full site will be greatly appreciated .
June 23rd, 2010 at 7:18 pm
Hi,
Is there any way to validate the date?. How do I disable the past dates? I want to force my user to select the date after 2 days from the current Date.
Please advice me.
Thanks
Robert
June 24th, 2010 at 3:32 pm
Hi Mike,
Thanks for posting this. I’m having a little trouble getting this working on Magento 1.4.1.0. Will it work on this version? I can see the delivery date is being saved to database but on the backend it always displays as:
Desired Delivery Date: No Delivery Date Specified.
Could this be because of the new database structure. I would be greatly appreciative of any advice.
Regards,
Matt.
June 24th, 2010 at 4:07 pm
@Matt – Are you using code like this to display it in the back end?
<?php echo "".$this->helper('deliverydate')->__('Desired Arrival Date').": ".$this->helper('deliverydate')->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
Check to see that “$_order->getShippingArrivalDate()” is populated, that could be the issue. I have tested it on 1.4.0 and don’t see why 1.4.1.0 would be any different.
June 25th, 2010 at 1:58 am
Hi Mike,
Thanks for the reply, I added the code:
getShippingArrivalDate();if (isset($rawDate)){
echo 'The date is set, it is'.$rawdate;
}
else {
echo 'The date is not set';
}
?>
It seems that it isn’t populated.
Matt
June 25th, 2010 at 2:00 am
There’s a bit missing from that, the first line is
$rawDate = $_order->getShippingArrivalDate();June 27th, 2010 at 8:55 am
Hi Mike,
I dont want my user select past dates. How can I do this?
thanks
Robert
June 27th, 2010 at 10:51 am
Robert
add this in deliverydate.phtml
function ourDateStatusFunc
if (((date.getTime() - today.getTime()) / DAY) <= -1 ) return true;
else return false;
June 27th, 2010 at 10:55 am
Lot of answers at
http://www.dynarch.com/projects/calendar/old/
July 5th, 2010 at 12:03 pm
Mike can you please clearly tell me how to get the delivery date and the date picker displayed in the shipping information step because i want to remove the shipping method because it is free on my website
Please help me out with all the steps that would be needed ( all the details about the filed to be edited and what has to be changed in them)
regards ,
jesse
July 5th, 2010 at 1:35 pm
@Jessy – You will need to edit/override the deliverydate.xml file and change it to the controller action you want to use(shipping info).
Reference the layout guide for help – http://www.magentocommerce.com/design_guide/articles/intro-to-layouts.
I am pretty booked up on my time so I can not go through and test making a change to do this, but if you don’t figure it out then You may want to submit a RFP and I could finish the changes. http://www.sharpdotinc.com/contact/
July 26th, 2010 at 3:09 pm
Did any one managed to solve the problem on 1.4.1.1?
I get “Desired Arrival Date: No Delivery Date Specified.”
Thanks,
Ron.
August 17th, 2010 at 7:10 am
Hi,
has anyone extended the extension to work on multishipping? I stuck on saving more than one address…
Greetings,
Oliver
August 27th, 2010 at 9:40 am
Hey Mike,
I got also the same problem “No Delivery Date Specified” in admin, while it has already been specified.
I had placed the code as per readme.txt file. But still getting the above message in admin.
It looks like it’s not inserting the value in database. I checked the sale_flat_quote table it has shipping_arrival_date column but its NULL. I tried to edit that row manually to set the date but still it’s not showing in admin section.
Please help me fix this issue. Thanks a lot
August 27th, 2010 at 10:01 am
@Ravi: What Version of Magento are you using?
August 27th, 2010 at 10:03 am
Hey Mike,
Thanks for a quick reply. I am using 1.4.1.1 version.
Sorry I forgot to mention it.
Thanks
August 27th, 2010 at 10:04 am
Hi Ravi,
You need to add the column to sales_flat_order table as in this version magento takes it from there.
August 27th, 2010 at 10:25 am
Thanks for the Reply Ron. I will need to update the module to fix this.
August 27th, 2010 at 10:26 am
Hey Ron,
Thanks for reply.
I had inserted new column “shipping_arrival_date” in sales_flat_order tablse.
When I placed a test order with delivery date. The column has null value, but when I edit manually and set the date, then I can see it in admin.
I think its not populating in sale_flat_order table. Do I need to change any other setting in any xml file or .phtml file?
Thanks for all your help.
August 27th, 2010 at 10:28 am
Hi Ravi,
Send me your email, I’ll send you my code.
Ron.
August 27th, 2010 at 10:30 am
Hey Ron,
Please email me at ravig@ironwoodcapital.net
I need to say that this thread is more active than the Magento’s community.
Thank you Ron. I really appreciate your help.
September 4th, 2010 at 2:13 am
I absolutly dont understand why u publish this. Its not ready for copy & paste. No Starting php-tags,”echo”’s and no “$this->”.
September 5th, 2010 at 11:23 am
Looks like the WYSIWYG Messed up some of the tags and code.
September 16th, 2010 at 2:59 am
Hey folks
got the same problem about 1.4.1.1
Could someone send me the solution to ttreppke@oso24.com ?
Thanks in advance
September 28th, 2010 at 9:43 pm
Hey Mike,
I got also the same problem “No Delivery Date Specified” in admin.
I am using 1.4.1.1 version
Thank you
October 16th, 2010 at 7:25 am
Hi everyone
got the same problem about 1.4.1.1
Could someone send me the solution to ebowsoft@gmail.com ?
Thanks in advance
Best wishes
Janky
October 16th, 2010 at 7:49 am
Hi Mike
got the same problem about 1.4.1.1 as Ravi
I had inserted new column “shipping_arrival_date” in sales_flat_order tablse.
Now the problem is its not populating in sale_flat_order table. Do I need to change any other setting in any xml file or .phtml file?
Thanks much
Best wishes
Janky
October 21st, 2010 at 6:46 pm
Hi Mike,
How can I change the date format in the checkout calendar so instead of it appearing as mm/dd/yyyy, it appears as dd/mm/yyyy?
I’ve tried changing the ifFormat: “%m/%e/%Y” in deliverydate.phtml, to ifFormat: “%e/%m/%Y”… This made it appear as dd/mm/yyyy in the checkout calendar but displayed a different value in the email.
Example: 29/10/2010 displayed as 10/05/2012
I then tried to change the %e to %d, like ifFormat: “%d/%m/%Y”, but that didn’t work either.
Any ideas?
Thanks so much
Ben
October 25th, 2010 at 5:37 pm
Hi,
question, can i make the delivery date mandatory? and how?
I’ve read all the replies here and none asked about this so far.
I run a flower shop, so for me, it’s a mandatory field
October 26th, 2010 at 9:05 am
Hey INsane,
Try adding the class “required” to the input element. the JavaScript should then make the field required.(Note: I have not tried this and this would only be javascript validation, but since the check out process needs JavaScript it should be fine.)
October 27th, 2010 at 8:01 am
Hi,
I tried installing the module on magento 1.4.1.1 (crossing my fingers to be able to make the necessary changes to make it work); however, i got the error below:
“magento-community/Sharpdot_Deliverydate requires PHP (version >= 5.2, version <= 5.3), installed version is 5.3.2-1ubuntu4.5"
Is there a workaround for this? Hopefully without having to change my installation of PHP. :')
Thanks so much in advance.
October 27th, 2010 at 9:03 am
This is a setting when I created the module. I am not sure if there is a work around to by-pass it. Next time I do a release I can change that value.
Check in the “/app/downloader/pearlib/download” folder and see if it downloaded the tar package. if so you can untar it and manually place the files into the directories.
October 28th, 2010 at 12:35 am
Thanks, unfortunately, the tar package was not downloaded.
If it’s not asking too much, could you send the files (tar/zip) to me via email instead?
Thanks again.
October 28th, 2010 at 7:05 am
Sure I will Send it to the email you registered with on this site.
October 28th, 2010 at 3:28 pm
Hi Mike,
Any luck on the date format question?
Thanks.
Ben
October 29th, 2010 at 7:13 am
Awesome! I’ll be on the lookout for your email.
November 15th, 2010 at 10:09 pm
got the same problem about 1.4.1.1 and the ‘Desired Arrival Date: No Delivery Date Specified.’
Do you think you could someone send me the solution? I really need this as soon as possible
November 16th, 2010 at 2:30 am
Nevermind – I figured out that it was trying to point to sales_flat_order and in my database the table names are setup with mgn_sales_flat_order. I updated the table by using:
ALTER TABLE `mgn_sales_flat_order` MODIFY `shipping_arrival_date` DATETIME
Actually I used the wrong format the first time:
ALTER TABLE `mgn_sales_flat_order` ADD `shipping_arrival_date` DATE <-oops (don't do this)
use this if you did: ALTER TABLE `mgn_sales_flat_order` MODIFY `shipping_arrival_date` DATETIME
I also updated this table:
ALTER TABLE `mgn_sales_flat_quote_address` ADD `shipping_arrival_date` varchar(100)
I then updated mysql4-install-0.1.0.php and mysql4-upgrade-0.1.0-0.1.1.php to point to the "mgn" versions and voila – it now shows the actual date in the admin. I hope this helps someone.
November 17th, 2010 at 1:08 am
Hi
I’m running magento 1.4.1.1 and i’m having trouble getting your extension to work. Where you ever able to come up with a fix for 1.4.1.1
If you want to email use the one i used to register with the site.
Thanks
November 17th, 2010 at 7:45 am
I have not upgraded the module to work with the 1.4+ database schema.
November 23rd, 2010 at 1:20 pm
Hi Mike
I’ve removed shipping address in onepage checkout
First step : billing address
goes to
2nd step : shipping method / delivery date
(shipping adress is given somewhere else)
Before the calendar was working well when delivery date was the 3rd step.
Now where delivery date is in the 2nd step, the calendar doesn’t appear when clinking on calendar.gif
Have you got a quick idea ? I can’t see
(I made no change in delivery date mod)
Thanks
November 23rd, 2010 at 1:36 pm
Off the top of my head the only thing I can think of is that you have caused a JavaScript Error and that could cause the problem.
Is the site publicly accessible? I could look real quick.
November 23rd, 2010 at 3:20 pm
Thanks for your help
It’s on a test site :
http://www.classynet.fr/kerbio/
I’ve found :
GET …/checkout/onepage/progress/
Calendar._MN is undefined
error source line: [Break on this error] for (i = 0; i < Calendar._MN.length; i++) {
in calendar.js (ligne 1660)
November 26th, 2010 at 3:35 pm
Hum, I still don’t understand why
Calendar._MN is undefined
??
Have you got an idea ?
November 28th, 2010 at 9:46 am
This comment thread has been extremely helpful. I am quite new to Magento, a lot of it is quite mysterious.
Here’s where I’m at:
Magento ver. 1.4.1.1
`sales_flat_order` now has the column `shipping_arrival_date`
if I manually enter a date in there, it displays correctly in the admin area (and I’m sure it will also work everywhere else).
the problem I’m having is that when the order is made, it’s still being stored in the table `sales_flat_quote`
where do I change that? in an XML file somewhere? I’m sure it’s something simple, I just don’t know enough about Magento to do it.
December 3rd, 2010 at 3:40 pm
Wondering if anyone has had any luck enabling the TIME as well as the date? I’ve been hacking away for a couple of days now, and I am making no progress.
December 4th, 2010 at 1:29 pm
Hi,
im using magento 1.4.1.1 and had to install the module manually.
Module is correctly recognized, and when i set a date in sales_flat_order.shipping_arrival_date in mysql, i can see it in the admin interface.
But it seems it is not set when using the field in checkout.
any idea ?
Thanks.
December 8th, 2010 at 8:33 am
@Tabber: in the deliverydate/onepage/deliverydate.phtml file, just change “showsTime” to “True”
December 8th, 2010 at 8:36 am
for my pb, I don’t know what changed but it is working now after a few full uninstall/reinstall
that’s a nice module, thanks for this!
December 9th, 2010 at 2:04 am
Hi Mike,
I have followed readme.txt to do
Add getChildHtml(‘deliverydate’) ?> into template\checkout\onepage\shipping_method.phtml
Check that the field shipping_arrival_date [varchar(100)] is existing in mgn_sales_flat_order table.
After I checkout the shopping cart, the value of shipping_arrival_date is still NULL, any step i missed?
December 9th, 2010 at 3:11 am
Hi Mike,
I have followed readme.txt to do
Add getChildHtml(‘deliverydate’) ?> in template\checkout\onepage\shipping_method.phtml
Checked that the field shipping_arrival_date [varchar(100)] is added in mgn_sales_flat_order.
In the shopping cart, the calendar is able to display. After submit the cart, found that the value of shipping_arrival_date is still NULL in the mysql database
any step i missed to configure?
Thanks,
Raymond
December 9th, 2010 at 9:01 am
What Magento Version are you using?
December 9th, 2010 at 6:46 pm
Hi Mike,
I am using 1.4.1.1
Thanks,
Raymond
December 13th, 2010 at 4:06 am
Hi Ravi,
Could you send me the code you used to fix the problem? For me in version 1.4.1 the date isn’t being saved to the database (though I have tried to follow the updates as detailed above).
Thanks,
Darren
December 14th, 2010 at 1:37 pm
I got this extension working in 1.4.1.1 as follows:
1. As mentioned above, add shipping_arrival_date column to the sales_flat_order table.
2. edit Sharpdot/Deliverydate/Model/Observer.php by adding:
public function deliverySalesEventConvertQuoteToOrder($observer) {
$observer->getEvent()->getOrder()->setShippingArrivalDate($observer->getEvent()->getQuote()->getShippingArrivalDate());
return $this;
}
3. edit Sharpdot/Deliverydate/etc/config.xml in the section – add after :
singleton
deliverydate/observer deliverySalesEventConvertQuoteToOrder
December 14th, 2010 at 1:38 pm
Sorry – step 3 above should be:
edit Sharpdot/Deliverydate/etc/config.xml in the section – add after :singleton
deliverydate/observer
deliverySalesEventConvertQuoteToOrder
December 14th, 2010 at 1:40 pm
One more try – step 3 about should be :
edit Sharpdot/Deliverydate/etc/config.xml in the “frontend” “events” section – after “/checkout_controller_onepage_save_shipping_method” add:
“sales_convert_quote_to_order”
“observers”
“deliverydate_observer”
“type”singleton”/type”
“class”deliverydate/observer”/class”
“method”deliverySalesEventConvertQuoteToOrder”/method”
“/deliverydate_observer”
“/observers”
“/sales_convert_quote_to_order”
(replace ” with brackets > <)
December 18th, 2010 at 3:10 am
Its work, thanks Emily
December 28th, 2010 at 10:47 am
Hey I tried the above Emily and couldn’t get the data to save in the DB.
In your new function I tried adding an “exit()” which did make the checkout not place the order. So it would appear the function is being called by the event. I looked to see if it was going into the quote table but it wasn’t either. Can anyone confirm if it should go into their as well?
I tried using a column type of varchar(100) and datetime to the sales_flat_order table. It always appears as null though.
I am just wondering if there is anything else other than those 3 steps that needs to be done?
Currently pulling my hair out over something which seems so simple but as with magento it rarely is!
Thanks for the
January 9th, 2011 at 6:51 pm
Hi Mike,
My company is using Magento Enterprise 1.8.0. Does your code work on this version? If not, what are the options to implement the delivery date.
Thanks.
January 9th, 2011 at 9:48 pm
I am not sure if Magento Enterprise 1.8.0 uses flat tables for sales or if it still uses the EAV structure. If it uses EAV then it should work, if it uses Flat tables then you would have the same issues as people using 1.4 Community Edition.
As far as options to implement this, I believe there are a few paid versions that would probably support Enterprise Versions, or my module could be customized to work with 1.4/Enterprise Editions.
January 27th, 2011 at 10:10 am
Hi,
I am getting the “no date specified” in admin on my site. Would you be able to let me have any updates i need to do ? im using magento 1.4.0.1 and 1.4.1.0
Any help would be greatly appreciated
January 27th, 2011 at 10:14 am
not compatible with 1.4
January 27th, 2011 at 10:19 am
where there is a will there is way, it simply isn’t pulling through date from database. Will update when have a solution.
Great extension other than that. Any plans on releasing a 1.4 compatible version?
Keep up the good work.
January 27th, 2011 at 10:25 am
Only if I have a client that needs it. or if someone from the community shoots me updated files that work for 1.4+.
I am actively working on other modules.
January 27th, 2011 at 10:44 am
How much would it be for you to update it to work with version 1.4.0.1 and 1.4.1.0?
email: alex@attitudewebdesign.co.uk
February 8th, 2011 at 12:28 pm
Hi I’m getting this error:
magento-community/Sharpdot_Deliverydate requires PHP (version >= 5.2, version <= 5.3), installed version is 5.3.3-1ubuntu9.1
Install Errors
No valid packages found
PEAR ERROR: install failed
What can I do? the downloader/pearlib/download is empty
February 8th, 2011 at 12:55 pm
Hey,
I will Add a zip file to this post with the module in it. That error is due to some required settings by Magento.
P.S. You did catch that this module does not work on 1.4 version of magento right.
February 8th, 2011 at 8:57 pm
Thanks,
Yes I know it is not working on 1.4 I’m using 1.3.
I’m waiting for the zip on this post. (or if you want to email me it can also be great)
Thanks a lot
February 9th, 2011 at 8:08 am
Hey Nash,
I have added a download link to the end of the post.
Enjoy!
February 9th, 2011 at 8:46 am
Hey Mike Thanks a lot! you are great.
I have a newbie question, I added all the files to my magento site, but I don’t see it no where. should I add some code some where?
I’m using Magento 1.3
should I run the installation?
Thanks
February 9th, 2011 at 9:11 am
Sorry,
I did not include the readme file.
Download the zip file again and in “app\code\community\Sharpdot\Deliverydate” you will see a read me file with instructions on what code needs to be added.
February 9th, 2011 at 10:18 am
Hi Mike,
I’m getting now JavaScript error “Calendar._MN is undefined” in calendar.js
so nothing is happening when I click the calendar icon.
I saw some one asked how to solve it before but no answer.
any ideas?
Thanks
February 10th, 2011 at 8:28 am
Is this site web accessable? (provide url)
How do you have your theme set up?
February 10th, 2011 at 8:37 am
the site is http://www.mainsweet.com
Its under the default theme
Thanks a lot
February 11th, 2011 at 8:48 am
Hi mike,
I got it working – it had a conflict with different JS I used.
Thanks a lot
February 11th, 2011 at 12:02 pm
Hi Nash
Please, could you tell what kind of conflict it was ?
Cause I have still not fixed my problem with
Calendar._MN is undefined
Thanks
February 11th, 2011 at 12:31 pm
I’m not sure what exactly was it,
But I had a different calendar I tried to work with before.
And I included the js file in the header.
After removing the old calendar js from the header it worked for me. probably it had a same name function like the Calendar from the current js uses.
Good luck
April 3rd, 2011 at 12:05 pm
@Mike D : I will need to get back to you regarding getting the delivery date into the progress block. That will probably take editing the layout xml file
Somebody got it working ? How can we make it ?
Thanks
May 18th, 2011 at 8:09 am
I can confirm this works:
ALTER TABLE `mgn_sales_flat_order` MODIFY `shipping_arrival_date` DATETIME
Actually I used the wrong format the first time:
ALTER TABLE `mgn_sales_flat_order` ADD `shipping_arrival_date` DATE <-oops (don't do this)
use this if you did: ALTER TABLE `mgn_sales_flat_order` MODIFY `shipping_arrival_date` DATETIME
I also updated this table:
ALTER TABLE `mgn_sales_flat_quote_address` ADD `shipping_arrival_date` varchar(100)
PLUS: i had to clean `core_cache` flush cache storage and it worked.
May 26th, 2011 at 1:11 am
Is this worked on magento 1.5 version. i got the field on admin sales module but on client it said compatible with version 1.4
August 11th, 2011 at 1:56 pm
Thanks Mike and all the contributors – working great for me version 1.5. Brilliant thread
August 22nd, 2011 at 6:55 am
sadly, i cant install it on “1.5.0.1″
CONNECT ERROR: Package file is invalid
Invalid package name, allowed: [a-zA-Z0-9_-] chars
Invalid version, should be like: x.x.x
Invalid stability
Invalid date, should be YYYY-DD-MM
Invalid channel URL
Empty authors section
Empty package contents section
August 22nd, 2011 at 7:18 am
Correct,
This is not supported above Mage version 1.4.0
August 22nd, 2011 at 7:56 am
Ah ok, i was just puzzled by the replys above me saying they got it working on 1.5
Thanks for clearing that up
August 22nd, 2011 at 8:04 am
If you want to try to get it working in 1.5 you will need to use the zip package from in the post, then follow some of the steps previous posters have noted to get it working in 1.5
September 6th, 2011 at 4:39 am
Hi mike ,
I have installed your module but cannot get it working …I have added the code to the template file as well …need help
1. Magento Version 1.5.0.1
2. no error messages?
Thanx
September 6th, 2011 at 4:56 am
Hi mike ,
one more thing is date is not show in admin side.
September 6th, 2011 at 6:35 am
Did you take extra steps to make it work with magento versions above 1.4.1?
If not read the comments and see what needs to be done.
You probably need to add the database column to the orders table.
September 6th, 2011 at 6:38 am
Hii Mike,
Table is also show in database.but at the admin side data not display,
September 6th, 2011 at 6:46 am
To display the value in the admin you need to adjust the admin order view template. There should be a readme file included in the module that describes what to add and to which file to add it to.
September 6th, 2011 at 6:50 am
Hii,
Yes i read the file and according to this,i made the changes like:
shipping_method.phtml -getChildHtml(‘deliverydate’) ?>
info.phtml- <?php echo "“.$this->helper(‘deliverydate’)->__(‘Desired Arrival Date’).”: “.$this->helper(‘deliverydate’)->getFormatedDeliveryDate($_order->getShippingArrivalDate()); ?>
after that Data not display in order view.
Thanx
September 6th, 2011 at 6:52 am
Ok Lets check 2 things.
1. Disable Cache and check again.
2. Check the Database for this order and make sure that there is a timestamp saved for the delivery date.
September 6th, 2011 at 7:00 am
Hii
Not solve.
September 6th, 2011 at 7:01 am
What value was stored for the delivery date for the order in question?
September 6th, 2011 at 7:03 am
Hii
value 2011-09-30 00:00:00 of shipping_arrival_date.
September 6th, 2011 at 8:35 am
Did you add static text like “Desired Delivery Date” to the admin template? is that showing up?
I am trying to determine if the issue is that the template changes did not take effect or if it is an issue with displaying the time.
September 6th, 2011 at 8:52 pm
Hiii
I see the text “Desired Delivery Date” to the admin template.
but “Delivery Date” still not show.
November 23rd, 2011 at 1:23 am
Hello,
.. just a few hints
Is this module compatible width magento ver 1.6.1.0 ? what is to be modified to make it compatible ? pls help.
November 23rd, 2011 at 8:37 am
@stefan – as the second paragraph in this post states “Not compatible with Magento Ver 1.4.1 or above” so version 1.6.1.0 is certainly above version 1.4.1. No it is not compatible out of the box.
If you read these comments you should get an idea of how to adjust things to get it to work. Basically the issue is that above version 1.4 the sales tables in the database switched to flat_tables. So you would need to add a column to the table.
November 24th, 2011 at 4:46 am
10x … made it work on magento 1.6.1.0.