Questions tagged [orders]

Mark questions related to Magento orders

Filter by
Sorted by
Tagged with
47 votes
7 answers
18k views

Price re-index causes DB deadlocks during checkout

I'm experiencing an issue where I believe the Product Price re-indexing process is causing a deadlock exception in the checkout process. I caught this exception in the checkout process: Order ...
user avatar
  • 1,019
44 votes
6 answers
45k views

How to add fee to order totals in Magento 2

The following link will describe http://excellencemagentoblog.com/blog/2012/01/27/magento-add-fee-discount-order-total/ to add fee to order totals in Magento 1. Now this functionality is moved to ...
user avatar
  • 1,993
37 votes
1 answer
27k views

Recurring Profiles - How do they work?

I'm trying to understand how Magento manages Recurring Profiles and orders associated with them. I have some open questions about that: Order: How the subsequent "order" is created from a Magento ...
user avatar
  • 6,855
33 votes
12 answers
54k views

Magento 2 - What is the correct way to change default Order Id?

Magento 2. After a fresh install, the new Order id will be 100000001, 100000002, and so on. What is the correct way to change that increment id so it would be a higher number? For example 155555552, ...
user avatar
  • 963
32 votes
2 answers
111k views

Get Order Details by Order Id

I need to retrieve an order in Magento by its Id. How do I load a specific order by Id? So far I've gotten the initial query constructed: Mage::getModel('sales/order');
user avatar
  • 2,047
32 votes
3 answers
19k views

Programmatically Creating Shipments

I came across different ways to create shipment programmatically. They are //Type 1 $converter=Mage::getModel('sales/convert_order'); $shipment=$converter->toShipment($order); ...
user avatar
  • 1,935
28 votes
4 answers
39k views

Confusion with order id, order increment id and I am not getting order id as 20001201

I am bit confused with order id and order increment id, So can any one help me to understand the difference between these two? I have an observer for sales_order_place_after where I store sales ...
user avatar
  • 3,036
27 votes
3 answers
19k views

New order email being sent twice

I'm using Magento 1.9.1 and when creating a new order, whether it's from the frontend or Admin, the system is sending out 2 emails - both the same! I've looked on the net and found a bug which was an ...
user avatar
25 votes
4 answers
33k views

What are the definitions of the order statuses? OR: Where should I integrate my order state?

I want to define some order states like "credit card payment received", the question is to which statuses they belong. Is there a definition for each of the built-in statuses? Edit: Seems like I ...
user avatar
25 votes
1 answer
56k views

magento: invoice PDF design customization

I want to customized the Invoice PDF layout. when there is big product name the the table data are not looking proper aligned. How Can i easily manage the design of the PDF INVOICE. I tried to ...
user avatar
23 votes
2 answers
34k views

Magento 2.1.1 How to load Order with Increment ID using OrderRepository object

What would be the latest best practice to load Order using increment ID (instead of Order ID) using OrderRepository
user avatar
22 votes
2 answers
2k views

Orders editing feature

Right now Magento supports altering an order only in form of a reorder, which is may be due to complex ordering process and the database structure. But often reorder is not an option in case of ...
user avatar
  • 1,198
21 votes
4 answers
37k views

Add Column to Admin > Sales > Orders Grid

How can I add a column to the grid in the Admin section under Sales > Orders?
user avatar
19 votes
1 answer
12k views

What's the difference between voiding and canceling an order?

What is the difference between voiding and canceling an order? What are the reasons to perform one over the other? When looking at an Order where the credit card has been captured online in the ...
user avatar
  • 3,242
18 votes
2 answers
15k views

What is the difference between grand_total and base_grand_total of the order?

Can any one explain the difference between following attributes of the order? grand_total base_grand_total Any suggestions will be appreciated.
user avatar
  • 9,857
16 votes
5 answers
12k views

How to check if billing and shipping address are equal?

I'm trying to check if billing and shipping address are equal when creating invoice PDFs. What I've tried so far was: $order = $invoice->getOrder(); if( $order->getBillingAddress()->getData(...
user avatar
  • 926
15 votes
2 answers
5k views

Difference between `sales_order_place_after` and `sales_order_save_after`?

Magento 1 and Magento 2 both have the two event: sales_order_place_after sales_order_save_after. I have some confusion about them, what is the detailed differences between them? Which situation ...
user avatar
  • 3,205
15 votes
3 answers
25k views

Magento not sending order confirmation emails to admin

I'm at loss on what to do. This morning I configured cron and according to Aoe_Scheduler the emails in the queue are sent each 5 minutes. I don't, however, receive new order confirmations on my email ...
user avatar
  • 365
13 votes
1 answer
2k views

Integrity constraint violation: 1062 Duplicate entry for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'

I'm helping a merchant track down the root cause for some failed payment transactions (during a heavy order day), that failed with the following error SQLSTATE[23000]: Integrity constraint ...
user avatar
  • 43.8k
13 votes
4 answers
4k views

Allowing customers to pay an admin created order?

I'm wondering if there is an extension or some guidelines on how I might think about allowing for an order to be created in the admin area for a customer and then allow them to log in to their account ...
user avatar
  • 181
12 votes
5 answers
19k views

Magento2 Correct Way to get Order items

I am working on M2 Payment Extension our merchant need us to send items details along with order Everything works fine but $order->getAllItems(); or $order->getAllVisibleItems(); returning ...
user avatar
12 votes
5 answers
12k views

Can I edit an Order and keep the payment information?

I have a customer that ordered 5 products, but 2 are out of stock and cannot fulfill the full order. However, when I edit the order (delete it and create a new one) to remove the two SKUs, the credit ...
user avatar
  • 649
12 votes
2 answers
33k views

Get order items inside the order

I need to get order item inside the order loop , how to achieve this, here is my code $orderCollection = Mage::getModel("sales/order")->getCollection(); foreach ($orderCollection as $...
user avatar
11 votes
2 answers
6k views

Magento: send New Order Email only with cronjobs

How can I send The new order Emails using: $order->sendNewOrderEmail(); only from a cronjob used in My custom Module. Thanks for help.
user avatar
  • 597
11 votes
1 answer
2k views

How to automatically add a comment on order when is placed

I have the following situation: I am on the checkout page, and i have 3 Shipping methods. If i select a specific method form all 3 and i finish the order, i want a comment to be added automatically ...
user avatar
  • 2,602
11 votes
1 answer
7k views

Process to create partial credit memo/refund for Paypal Standard orders

I see a number of issues reported that if an administrator sends a partial refund to a customer via Paypal then Magento receives an IPN that causes the whole order to be marked as Refunded (e.g. https:...
user avatar
11 votes
3 answers
6k views

Magento 2 Duplicate Orders

I'm getting an strange issue in Magento 2.2.7. Some of the orders are duplicating despite us only receiving one payment. It is the exact same order information except for the order number (which ...
user avatar
  • 370
10 votes
5 answers
34k views

Magento 2 how to get order collection

how to get order collection in custom module ? like My Orders collection in customers dashboard (frontend). this collection how to get?
user avatar
  • 357
10 votes
4 answers
15k views

Magento 2: how to delete orders from the database

How can I delete the test orders created in my store? I have opened the database but I couldn't find the order table. Please help me to delete the orders. I'm using the later version of Magento 2.
user avatar
10 votes
3 answers
12k views

How to get customer phone from order shipping data?

How to get customer telephone number mentioned in order shipping address?
user avatar
  • 1,649
10 votes
2 answers
5k views

Convert Order to Quote and Load to Current Cart

I can successfully convert convert an order into quote but I still couldn't load it into current cart. I tried several methods but to no avail. Here's the simplest one: $_quote = Mage::getModel('...
user avatar
  • 1,319
10 votes
3 answers
4k views

E-mail address missing in order

We have 2 stores (a 1.7.0.2 upgrade from 1.5.1 and a 1.6 install) that both have a problem that for some orders has a missing e-mail address (customer_email in sales_flat_order). The stores are two ...
user avatar
10 votes
5 answers
5k views

Magento 2 API: Filter orders by extension attribute

I have an extension with an attribute assigned to order items called warehouse. I can see this attribute under the property "extension_attributes". I need to filter orders based on this attribute. I ...
user avatar
  • 101
9 votes
1 answer
9k views

Find out how many times a product was ordered

I am trying to find out how many times a product was ordered over the last two weeks. So far I have a loop getting the products. foreach($productCollection as $product){ } I assume I ...
user avatar
  • 2,164
9 votes
1 answer
16k views

What's the best event/way to listen for all order state changes in Magento 2?

I want to observe every order state change and react depending on the old and new status. What is the best way to accomplish this in Magento 2? It looks like there is the event ...
user avatar
  • 1,091
9 votes
3 answers
17k views

How to Get order increment id using order id in Magento 2

Can anyone please tell me How to Get order increment id using order id in Magento 2? Thanks.
user avatar
9 votes
3 answers
13k views

Observing order state change

It seems there is no order state event by default, so how do you usually go about observing order state change? There are two possibilities I see: a) Overwrite the sales/order model to create your ...
user avatar
  • 4,660
9 votes
1 answer
14k views

Get current order ID magento 2

I know how to retrieve last order id by this code, $this->_checkoutSession->getQuote()->getReservedOrderId(); Where _checkoutSession is obtained with the injection, \Magento\Checkout\...
user avatar
9 votes
3 answers
4k views

Is it possible to refund tax on a partial order refund?

When issuing a Credit Memo (aka refund), Magento automatically refunds tax on shipping and products BUT NOT on values entered in the "Adjustment refund" field (aka partial refund). Is it possible to ...
user avatar
9 votes
1 answer
4k views

Recent orders are not appearing in the backend but exist in the database and are displayed in the dashboard

I'm using Magento 1.9.1.0. There are three recent orders that do not appear in the Sales > Orders panel. Here is a screenshot of the most recent orders, please see the order numbers: However, the 3 ...
user avatar
  • 103
8 votes
2 answers
10k views

How to know if an order is paid ? When "state" is "processing"?

I'm running Magento 1.6.2. I need to determine if an order is paid. If yes, I generate some XML data for export. There is many cases in the Magento order/payment/shipment workflow. My first guess is ...
user avatar
8 votes
1 answer
7k views

How to Perform Invoice Capture in Magento2 Programmatically

How to capture payment for the created invoice. In Magento1.x it is like $invoice = Mage::getModel('sales/Service_Order', $this->getOrder())->prepareInvoice(); $invoice->...
user avatar
  • 1,935
8 votes
2 answers
15k views

In which table payment method information of order save

I am checking with admin panel order and suddenly when i view particular order. I get error Uncaught exception 'Mage_Core_Exception' with message 'The requested Payment Method is not available.' . ...
user avatar
  • 783
8 votes
1 answer
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/...
user avatar
  • 1,319
8 votes
5 answers
5k views

Custom Order, Invoice, and Shipping Starting Numbers

What's the safest approach to change the next starting numbers for order, invoice, and shipment on a live site?
user avatar
  • 550
8 votes
3 answers
5k views

Magento order confirmation is sent to all customers

I see a strange behaviour in one of our shops: when an order is placed, the confirmation email is sent in CC to all registered customers that have an order in state "processing". It happens ...
user avatar
8 votes
1 answer
599 views

Creating a order from the backend, adding quantity calculates a incorrect price

Somehow Magento calculates an incorrect price when adding an order from the backend. This problem only occurs on products with a custom option field and when the locale is set to a land that uses ...
user avatar
7 votes
4 answers
15k views

The requested Payment Method is not available.On order details page

I recently migrated to a new server and upgraded to the latest Magento. However, the order details page on the backend is now broken for any order that used our old 'PayPoint' extension (which we no ...
user avatar
  • 71
7 votes
5 answers
45k views

Magento 2: How to get order information using REST API?

I want to get order,customer information by using REST API. Anyone have idea about this?
user avatar
  • 1,448
7 votes
6 answers
12k views

Magento 2 How to Programmatically Ship an Order

In Magento 2 how can I programmatically ship a order? I am currently developing a custom XML order import, which sends requests to a SOAP back office service. This service replies with the order ...
user avatar

1
2 3 4 5
45