Questions tagged [sales-order]
Denotes questions related to Magento Sales module's order functionality.
1,172
questions
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');
...