How to Find Variable Name for Coupon Code and Coupon Value

couponproduct

Can anyone tell me how I can include the coupon code and value of the coupon in an Order CSV that gets sent to the order fulfillment company? I am using Magento CE 1.8.1.

Basically when an order is generated, it also generates a CSV file with the order details and uploads this to the order fulfillment company. Looking through the code I can see that it pulls in other order data from variables e.g:

    $billingAddress = $order->getBillingAddress()->toArray();
    $email = $billingAddress['email'];
    $telephone = $billingAddress['telephone'];

What would be the variable name for pulling in the name and value of any money-off coupon that happens to be used for that order? I can't see any way of finding this out.

Best Answer

For getting order coupon code used below code

$order->getCouponCode();

For Coupon description

$order->getDiscountDescription();

And Also getting order discount Price

$DiscountPrice=$order->getDiscountAmount();

Related Solutions

Magento – How to find out what user used what coupon code

Which customers used which coupons:

I usually shy away from raw db queries, but in this case I will make an exception:

select customer_email, group_concat(distinct sfo.coupon_code) from sales_flat_order sfo
where coupon_code is not null
group by customer_email;

You could do the same with the Magento ORM - ~~will formulate a writeup on how to do that and edit afterward~~ and here's how:

$coll = Mage::getModel('sales/order')->getCollection()
    ->getSelect()->reset(Zend_Db_Select::COLUMNS)
    ->columns(array('customer_email',new Zend_Db_Expr('group_concat(distinct coupon_code)')))
    ->where(new Zend_Db_Expr('coupon_code is not null'))
    ->group(array('customer_email'));

How many times a coupon was used:

As already pointed out in another answer this is in a report. At the most basic level the query for that would be:

select coupon_code,count(coupon_code) from sales_flat_order
group by coupon_code;

The ORM-centric way of handling this is also fairly straightforward:

$coll = Mage::getModel('sales/order')->getCollection()
    ->getSelect()->reset(Zend_Db_Select::COLUMNS)
    ->columns(array('coupon_code',new Zend_Db_Expr('count(coupon_code)')))
    ->group(array('coupon_code'));

Note that this does not take into account order status or invoiced payment.

Coupon Code – Registration and Sending Process

You can follow this post and create your own codes:

https://magento.stackexchange.com/a/7917

For send email with generated coupon you can create a module, with event observer customer_register_success that generate the coupon and send email

Best Answer

Related Solutions

Magento – How to find out what user used what coupon code

Coupon Code – Registration and Sending Process

Related Topic