Mailing for Created orders not paid

Start
Prev
1
Next
End

codewarrior
Topic Author
Offline

Posts: 190
Thank you received: 0

10 years 4 months ago #135640

-- HikaShop version -- : 2.2.1
-- Joomla version -- : 2.5
-- PHP version -- : 5.3.8

Hello,
I know that there are topics about that in the forum, but it's not really clear for me

I have many "Created" orders not paid, and I want to sell a mass mail to remind users that they can pay it or cancel it.

With Acymailing Starter I saw Filters possibilities to send mailing to "Created" commands, but I don't understand how to create the message ???
- do I have to create before a specific newsletter ?
- how to customize the mail, inserting a direct link to the order of each customer ? (some customers have more than one command)

What is Hikashop Reminder ? There are no users if I select it.

Thanks for precisions.
Regards

Last edit: 10 years 4 months ago by codewarrior.

Please Log in or Create an account to join the conversation.

nicolas
Online

Posts: 81481
Thank you received: 13062
MODERATOR

10 years 4 months ago #135682

Hi,

Yes, you first need to create the newsletter that you want to send.
Then, you can create a filter in AcyMailing and send the newsletter to all the customers with unconfirmed orders with it. If you want something automatic, you will need the Enterprise edition of AcyMailing so that it triggers the filter regularly with a cron task in order to send the emails.

I the email, instead of the link to an order of the user, I would recommend instead to put the link to the orders listing page, and that for three reasons:
1. That way if the user has several ordrers he can see them all
2. If you turn on the "allow customers to pay their orders later" option of the configuration, your users will be able to pay the orders via a button on that listing. It can be a great easy way to get them back. And that button is not available of each order page.
3. The most important. There is no AcyMailing tag to be able to dynamically generate such order page URL.

Please Log in or Create an account to join the conversation.

dvddvd
Offline

Posts: 267
Thank you received: 5

5 years 9 months ago #294311

Hi

a) I need put the name of the product on list wiew orders of the front end , I made the following changes:

1.- I've added on wiew order/listing on the front end

<th class="hikashop_order_number_title title"><?php
echo JText::_('Curso');
?></th>

before:

<th class="hikashop_order_date_title title"><?php
echo JHTML::_('grid.sort', JText::_('DATE'), 'hk_order.order_created', $this->pageInfo->filter->order->dir,$this->pageInfo->filter->order->value);
?></th>

2.- I've added too

<td data-title="<?php echo JText::_('ORDER_NAME'); ?>" class="hikashop_order_number_value"><?php
echo $row->order_product_name;
?>
</td>

before:

<td data-title="<?php echo JText::_('DATE'); ?>" class="hikashop_order_date_value"><?php
echo hikashop_getDate($row->order_created,'%Y-%m-%d %H:%M');
?></td>

And the result is:

b) I can put a filter so that only a status of the order is shown, for example: provisional

thanks, very much

Attachments:

Last edit: 5 years 9 months ago by dvddvd.

Please Log in or Create an account to join the conversation.

nicolas
Online

Posts: 81481
Thank you received: 13062
MODERATOR

5 years 9 months ago #294312

Hi,

1. In $row you have the data of the order, from the hikashop_order table.
The order_product_name information comes from the hikashop_order_product table and isn't available there.
You would have to do something like that:

$orderClass = hikashop_get('class.order');
$order = $orderClass->loadFullOrder($row->order_id);
foreach($order->products as $product) {
 echo $product->order_product_name;
}

Note that orders can have more than one product and thus you can have several order_product_name.

2. You can add the HTML of the dropdown in the order / listing.php view file in the form near the top of the file.
Then you could just skip the display of the orders with such code:

if($row->order_status != $_REQUEST['filter_status']) continue;

after the line:

foreach($this->rows as &$row) {

where "filter_status" is the name you put for your dropdown.

PS: please note that this has nothing to do with the thread where you posted. Please open new threads in such case.

Last edit: 5 years 9 months ago by nicolas.

The following user(s) said Thank You: dvddvd

Please Log in or Create an account to join the conversation.