Seller email Token - new module

Line 108 from mp_orders.ca.inc shows how to get the email from the user's ID:

$email_to = db_result(db_query("SELECT mail FROM {users} WHERE uid = %d", $uid));

I'm not sure that completely answers your question, so feel free to let me know how I can help further.

There is also a discussion of emailing when stock is low at http://drupal.org/node/411184.

I haven't looked at uc stock, so I can't say for sure. From your description that sounds reasonable. I would imagine UC Stock always sends email to the same place, but we want to send it to a variable email address based on the code above (assuming we know the user/seller ID). I wonder if you can hook into UC Stock? I'll try to take a look at the code sometime in the next couple days to give a more concrete answer.

Attached new module - mp_tokens, which adds the token [order-seller-email], the email addresses of the product's owners.

If other tokens are needed, it can be added by request.

What next with this module/features ?

Thanks shushu! I'll try to test it this weekend. Let me know how it works for you nyleve101?

Shushu, worked for me. Thanks! I'll commit this or something like it to Marketplace when I get a chance.

Evelyn, here's a quick hack until someone comes up with something better:

After installing shushu's module add line 249 to uc_stock.module.

$to = variable_get('uc_stock_threshold_notification_recipients', variable_get('uc_store_email', ini_get('sendmail_from')));
$to = token_replace_multiple($to, $token_filters);
$to = explode(',', $to);

Well, that was probably not clear on my part considering I didn't even give the version of Ubercart I was using :-) The top and bottom lines in post #8 should already exist in uc_stock. So I'm only adding:

$to = token_replace_multiple($to, $token_filters);

In the function _uc_stock_send_mail. For reference here it is in context:

function _uc_stock_send_mail($order, $stock) {
  $token_filters = array('global' => NULL, 'order' => $order, 'stock' => $stock);
  $account = user_load(array('uid' => $order));

  $to = variable_get('uc_stock_threshold_notification_recipients', variable_get('uc_store_email', ini_get('sendmail_from')));
  $to = token_replace_multiple($to, $token_filters);
  $to = explode(',', $to);

  $from = uc_store_email_from();

  $subject = variable_get('uc_stock_threshold_notification_subject', uc_get_message('uc_stock_threshold_notification_subject'));
  $subject = token_replace_multiple($subject, $token_filters);

  $body = variable_get('uc_stock_threshold_notification_message', uc_get_message('uc_stock_threshold_notification_message'));
  $body = token_replace_multiple($body, $token_filters);

  // Send to each recipient.
  foreach ($to as $email) {
    $sent = drupal_mail('uc_stock', 'threshold', $email, uc_store_mail_recipient_language($email), array('body' => $body, 'subject' => $subject), $from);

    if (!$sent['result']) {
      watchdog('uc_stock', 'Attempt to e-mail @email concerning stock level on sku @sku failed.', array('@email' => $email, '@sku' => $stock->sku), WATCHDOG_ERROR);
    }
  }
}

Hope that helps.

The file in #5 has some blocks [] like characters in it. It doesn't have an extension either, I changed mine to mp_tokens.module and put it in the ubercart_marketplace folder. When I uploaded it, I didn't see it under my modules, is this normal? Was this how it was for everyone else?

Here is a zipped version of what I have...

Thank you very much. I just uploaded that and applied the patch.
I don't see the tokens.

*ignore*
I found it. Didn't see the link at the bottom; I was expecting a colapse list.

Great. Cheers.

I found it. Didn't see the link at the bottom; I was expecting a colapse list.

Sorry, but where you found it?

Right below the input text box, there is this message "The message the user receives when the stock level reaches its threshold value (uses global, order, and stock tokens).", click on the link in the bracket.

count you tell me the link please?

domain/admin/..?

It's admin/store/help/tokens.

Hello,

I decided to make a decent module out of it.

http://drupal.org/project/mp_tokens

I do believe it should be integrated into the main module, but till then - it is available as an additional module.

In addition, in combination with another module - http://drupal.org/project/uc_ca_sms - it is possible to send SMS notifications for sellers.

Comments are welcome,
Shushu

Thanks for the work on this!
It's just what I was looking for.

Thanks a lot, I'll try it now

Hello, I am a new dev helping a little with this module. I have just added some support for this, not exactly this but what I did was support user tokens that work with the seller account, this would let you use any of the available user tokens on the email.

I've reviewed the module and although it's not exactly the same I would think this would serve its purpose without adding new tokens or any more functionality with the module. I am happy with a separate module as well, although if we agree would serve most purposes maybe doesn't worth duplicating things.

Any thoughts? This functionality is not yet committed, but soon will be.

There seems to be some relationship between this issue and #411184: uc_stock notify seller instead of store owner on low stock threashold, just noting it here.

Ok, the new feature that's commented on #24 is committed for anyone who wants to try it. You might have to wait for the -dev release to be made or checkout with git.

Just tried #10, it seems to send emails to all sellers which have products into the order.

Example:
Order 1
Product A from seller 1
Product B form seller 2

Prod A become out of stock, not product B.

Seller 1 & 2 recieve emails alerts.

Is it possible to notify only sellers with out of stock products?

Please did anyone create a module for mp_tokens and the actual sending of emails to each seller of a product in an order (see #10) for D7?

I really need this token on d7, is there someone help?