Questions tagged [sales-order]

Denotes questions related to Magento Sales module's order functionality.

Filter by
Sorted by
Tagged with
1
vote
2answers
1k views

Why are both configurables and simples stored in sales_flat_order_item?

I am working with sales_flat_order_item using direct sql and I can't make sense of why both configurable and simple products are inserted into the sales_flat_order_item table. What is the reason ...
-1
votes
2answers
865 views

Send Extra 1 Custom Email to Admin When New Order is Placed

How to Send an extra Custom Email to Admin along with New Order Email is sent ?? OR Where I can find the Triggering Method of Sending Email of New Order to Administrator ??
2
votes
3answers
2k views

How do I query the sales/order_collection to shipping_lastname

I'm trying to query the database and build a page which is outside of the admin console. It's a quick page to show what products my manufacturing guys need to make. I've managed to put this together (...
0
votes
1answer
627 views

getting customer group using Grid control

I would like to get the customer group in Sales > Order grid. I'm using the gridcontrol module for this. I used below XML tag to get customer group but after that I do not see any order. I think ...
2
votes
2answers
114 views

Insert a miniform on adminhtml order view page right above order items

I'm trying to find a way of inserting a small form into the adminhtml sales order view page, right above the order items block, without intervening in the template file. So, basically, is there a way ...
0
votes
1answer
30 views

TransactionAmount problems!

Hello is it possible to get the 'price' without shipping & tax? $transactionAmount = $order->getData('price');
7
votes
2answers
324 views

Email not send when put order for recurring profile products

I placed the order for recurring profile products. New order email not received. If I put the order for normal products, I received the email.How to fix this. Is any option in backend to enable this?
1
vote
1answer
2k views

Export CSV file from order grid

I wanna export CSV from sales -> orders grid with only selected lines and not all commands like with the default button. If there's a solution for that ? Thank you for advance
1
vote
1answer
862 views

Magento Order Email Notification not sent to customer and to admin

Am facing problem on order email notification not sent to customer. I don't know why, but when i search some articles it maybe cause of cron jobs not working. Here's my error log: exception '...
6
votes
2answers
3k views

How to add shipped date to admin sales order grid

I am stuck with adding new column(Shipped date) to sales order admin grid. I copied the file Grid.php from app/code/core/Mage/Adminhtml/Block/Sales/Order to app/code/local/Mage/Adminhtml/Block/Sales/...
2
votes
1answer
1k views

Order email not working in CE 1.9 in hostgator shared hosting plan

Hello could anyone help me to resolve my order email problem, i am struggling with setting up cron job in hostgator, currently i am running on shared plan, as per hostgator, in shared service plans ...
7
votes
1answer
3k views

Right magento observer for order paid

I'm trying to send orders to a third-party after and ONLY after an order has been paid and has now been set to 'Processing' as status. What's the best observer to use to set up this to work for all ...
1
vote
1answer
257 views

Added column to sales_flat_shipment_item, how can I commit value to this new field on order shipment?

I'm developing a dropship extension. Everything is going really well. The integration so far is seamless. I've added a column to sales_flat_shipment_item, called 'dropshipped'. Boolean data, ...
4
votes
2answers
1k views

Order creation for multi-vendor setup [closed]

Initially it looked very simple to me but now i realize that it is little more complicated then i thought it would be. I am working on marketplace website. Where the system will have buyers as well ...
8
votes
1answer
6k views

Difference Between Sales Quote and Sales Quote Address

I am looking which collect_totals observer I can use. There are two observers, sales_quote_collect_totals_before and sales_quote_address_collect_totals_before. They can be found in /app/code/core/...
0
votes
2answers
915 views

How to Update Order Attribute

I was able to successfully add new order field through an install script: $installer->addAttribute('order', 'is_local', array('type'=>Varien_Db_Ddl_Table::TYPE_SMALLINT, 'default'=>1)); ...
0
votes
1answer
442 views

updateAttribute() function is not working on order attribute

i am trying to update an sales order attribute default using updateAttribute() function But it is not working. code is here: $installer = $this; /* @var $installer ...
3
votes
2answers
970 views

Magento 1.9.1 Cron Jobs

Is it possible not to use the cron jobs to send my sales confirmation email? I am on a shared hosting with hostgator and they don't allow cron jobs to be less than every 15 minutes. I don't want my ...
1
vote
1answer
866 views

sort ordered items by product name in magento admin

I want to sort items ordered by product name in magento backend. I followed this link, https://stackoverflow.com/questions/17572936/magento-change-sort-order-of-ordered-items, but what this is doing ...
0
votes
1answer
2k views

get current customer from admin section

If I am on the admin section for creating manual orders and I have selected to use an existing customer rather than create a new one how can I access that customers details? To clarify, by manual ...
0
votes
1answer
284 views

Display block on email order confirmation only when check / money order

I want to display a li in the order confirmation email only when the customer selected check / money order. Is this possible and if so, how? Thanks
0
votes
1answer
245 views

Query Problem on _prepareCollection()

how to convert mysql query to magento query mysql query SELECT `p`.`product_id` , `p`.`name` , `o`.`increment_id` FROM `sales_flat_order_item` AS `p` LEFT JOIN `sales_flat_order` AS `o` ON ...
-1
votes
2answers
21k views

Magento 1.9.1 Not sending order emails [duplicate]

Magento will not send order emails automatically or manually. The invoice emails work(only manually), but when something is ordered the order doesn't get send to the customer's email address. If I go ...
1
vote
1answer
316 views

what is the relation between Mage_Sales_Model_Order_Payment & child classes of Mage_Payment_Model_Method_Abstract?

I'm trying to understand payment flow. I have idea on following topics: Auth only:Its only check authorization of transaction. Auth & Capture: Its check authorization of transaction also ...
0
votes
1answer
973 views

Magento Sale Transaction Type

I was wondering what is the best approach for implementing sale (auth with immediate capture from the gateway) transaction in Magento? I would like to achieve the best possible compatibility with any ...
1
vote
1answer
2k views

Remove Mass action from Sales/Order Grid

I need to remove a few options from the Admin/Sales/Order Actions list. I do not want to edit the core files in Magento Right now when I click on the drop down list Actions in the top right corner of ...
2
votes
2answers
315 views

Assign order to customer if email exist

If customer try to place order as guest using email, which is already register then assign order to that register user.
3
votes
1answer
7k views

PHP Get Order Status name by State code?

I am working on an extension and i need an info how to get the status name by state code, is it possible ? The picture is from the Admin's panel Order Statuses page. How i can get the status name by ...
0
votes
1answer
1k views

magento 1.9.0.1 no order mails with store email, what could cause this? [closed]

when placing an order, the customer does receive the order confirmation. also the e-mail copy is received at the correct address (all configured in sale emails)... but for some reason i don not ...
1
vote
2answers
6k views

How to get Order details in the model of custom module

Im creating a module to send the order details to another server's database when a order is placed in my magento server. Im using event to point to the model class but Im not able to get the order ...
0
votes
1answer
2k views

Unable to get custom order attribute from magento v2 soap api [closed]

here is the problem. I have added additional fee to my orders. When calling the magento api v1 i get the response including this additional fee (called handling_fee_amount). But when calling the ...
0
votes
1answer
130 views

SalesOrderList is returning “created_at” an hour late

The problem is that when I invoke the field "created_at" is always an hour late and I don't know where can i change it.
1
vote
1answer
152 views

First line of the address is not displayed in sales order?

I can not get the first line of the address in receiver and sender address in sales -> order. But when I click edit, it displays all the address line which I have given Now I want to display the ...
2
votes
2answers
162 views

make increment_id of an order syncron to external system

We are integrating Magento with an existing system. Our existing system already has order numbers. There has been a lot of confusion since Magento has its own order numbers, and our existing system ...
2
votes
3answers
5k views

Sales Grid, adding columns from different SQL tables

Using Magento 1.8.1 I've added custom columns to the Sales Order Grid. The collection is as follows in my app/code/local/Mage/Adminhtml/Block/Sales/Order/Grid.php: protected function ...
0
votes
1answer
214 views

Raw query to display promotion name and how many orders it has been used with?

Title says it. I am looking for a raw query (direct sql) to tell me a promotions name, and how many orders it has been used on. Results should look something like this +----------------------------+--...
0
votes
1answer
2k views

Is it safe to change order status before save?

I have Collect In Store extension installed on Magento 1.9.0.1. The client wants a different default order status when this shipping method is chosen - it should be Processed instead of Pending. I ...
1
vote
1answer
290 views

How do I retrieve a list of Order Statuses allowed for a given Order State?

My understanding of Order States and Order Statuses are that a given Order State can have one or more allowed Statuses. I've found that I can retrieve a list of all Statuses in the system using: ...
1
vote
0answers
221 views

How can I set my order to a custom status after it's been fully paid / invoiced?

I'm working on a case in which we need to put orders into a custom status after they have been invoiced (either manually in the backend or automatically by the payment method). What I've found so far ...
1
vote
1answer
47 views

Default Order Search

How can I set the Sales Order search to by default only display "Processing" orders? So when I view the orders page it displays "Processing" orders by default?
1
vote
1answer
3k views

Change Order Confirmation Email For Specific Orders

I have two 'special' products that when ordered should send a custom email (in place of the standard order confirmation email). An Observer is set up for the sales_order_place_after event but not ...
0
votes
1answer
563 views

Send BCC of order confirmation email for a particular SKU

I am new to Magento and not able to figure out how to do this. I need to add a BCC email to the order confirmation emails that are being sent when the user buys a particular product. For e.g., The ...
0
votes
1answer
165 views

Adding a button in sales order. Old vs New Approach

Okay, I am a very new magento developer. Here is what I am facing. Module one -> is adding a button to sales order page by rewriting sales_order_view Module two -> is adding a button to sales order ...
1
vote
3answers
615 views

Pull recent records from collection with group clause

I am pulling records from sales_flat_quote using collection and to make the records unique i have applied customer_email group clause on collection. Below is the code. $collection = Mage::...
2
votes
1answer
1k views

Magento 1.8: How to insert the customer’s email into the email templates

How can I insert the customer’s email into the email templates for both guest and registered customers? I came across this answer but it seems a bit too old now as I am using Magento 1.8. The code ...
2
votes
3answers
2k views

What's the difference between order_id and Parent_id in sales Order?

The question might look a bit stupid but I don't understand the difference between parent_id and order_id.
1
vote
0answers
689 views

Magento re-order button for ALL customers (also guest), simple copy order details [closed]

I would like to +1 this thread: http://www.magentocommerce.com/boards%20/viewthread/40273/#t428770 This quote from 'egyember' sums it up To be honest the reorder button would be very useful on ...
0
votes
1answer
989 views

Get soled Products with counter in Magento

I want to get all the products that are sold also with counter like if product1 with 3 (times soled ).I am trying code like this one : $itemsCollection= Mage::getResourceModel('sales/...
2
votes
1answer
4k views

Get Order Info Using SOAP API

I am trying to make a simple API call to get some information on an Order. The reason I am trying with SOAP is because a similar API request is returning empty values for some sales attributes so I am ...
0
votes
2answers
2k views

Custom sales/order attribute in admin grid [duplicate]

How would I add a custom field to the order grid? I have the following code by looking at other questions but after I have ran the code the new field is not showing up. require_once('app/Mage.php'); ...