3 replies [Last post]
Axel_Pressbutton's picture
Offline
Joined: 11/30/2008
Juice: 123
Was this information Helpful?

Hi All,

Could anyone please tell me if it's possible to send an email to a 3rd party warehouse using Conditional Actions when orders are created?

This is the second build I've been asked to look at that could really benefit from this functionality Smiling

Also, this is probably a long shot, but is it possible for a warehouse to update the order status and add tracking codes etc. by uploading a (daily) CSV file?

Many thanks Laughing out loud

Axel_Pressbutton's picture
Offline
Joined: 11/30/2008
Juice: 123
amend

OK, so it's straight forward enough to do the CA (it was late when I started writing this and didn't send until the following morning)...

...but I can't see any tokens to display the product information/SKU directly in an email - is it possible to achieve this?

The idea being that when an order has received payment an email alert gets sent to the warehouse giving them the delivery address information as well as the SKU/product information and shipping method chosen.

Once the item has been dispatched, flagged by a new Order Status of 'Item dispatched' (how this flag is set is another matter), I'd like to then inform the user but also include the product details in the email, just in case they have other orders open as well, and possibly any tracking code that the warehouse may have assigned to the shipment.

Sorry for not being clearer in the earlier post.

TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3424
Re: amend

http://drupal.org/project/uc_edi does most of this, triggered off the order status change rather than CA. You should try to use that module. Then all you will have to do is create a callback that can change the order status upon receipt of shipping confirmation from the warehouse. That is how it's done with payment gateways, for example.

<tr>.
Axel_Pressbutton's picture
Offline
Joined: 11/30/2008
Juice: 123
_

Many thanks TR, This looks ideal!!!

I've found the D6/UC2 version of this and it appears to be working OK. I'm still testing locally at the minute via XAMPP. I know the EDI configuration options allow for Import and Export file extensions to be defined but I appear to be having problems setting this up with .xls and both Comma and Tabbed delimination. Could you, or anyone else please give me any pointers as to how this needs to be done as I've tried numerous different setups?

I also noticed that someone else has asked the question "Only certain products need to be sent via EDI" (http://drupal.org/node/453280) - is this possible to achieve?

Thanks again