Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
248 views

Magento 2. Sales -> Invoices - How to set Filter in Invoice Grid?

I have invoice id- 0000017 and order id-12 but this order 3 items so we are create 3 invoice like 0000017,0000018,0000019.Invoice grid in I have set filter like display only 0000017 invoice.how to set ...
0
votes
1answer
2k views

Magento 2 Get Order Billing Details

So I am working on this export for a SOAP web service, I am currently getting the order information from the following namespace \Magento\Sales\Api\OrderRepositoryInterface but the thing is it doesn't ...
0
votes
1answer
756 views

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'store_id' in where clause is ambiguous

After searching around I still haven't found a solution so I thought I would post it here. Any help would be greatly appreciated. When I go to filter one of the columns it redirects me to dashboard ...
0
votes
0answers
224 views

Call to a member function getParentItem() on a non-object [duplicate]

When I print particular order invoice from sales=>order menu at that time i get error like Call to a member function getParentItem() on a non-object in app\code\core\Mage\Sales\Model\Order\Pdf\Invoice....
0
votes
0answers
55 views

Group products when showing recently sold items using sales/order_item

I can show the most recently sold items and sort them based on created_at using this: $itemsCollection = Mage::getModel('sales/order_item')->getCollection() ->setOrder('created_at', ...
0
votes
1answer
703 views

Admin order form - update custom area with ajax on add product

I add custom field to admin order form and I want it to be updated with ajax when admin add products to order, like other areas - shipping, billing and totals. I inspected file \vendor\magento\module-...
0
votes
1answer
573 views

Magento2 in After order placed Observer does not change order status

class AfterSaveOrderObserver implements ObserverInterface { /** * Sets current instructions for bank transfer account * * @param \Magento\Framework\Event\Observer $observer * @...
0
votes
2answers
1k views

Displaying columns in Sales Order Grid

I have the following code to show some extra columns in the sales order grid. It correctly shows the columns and data, but when I try to click an order it says "No order exists". I wondered if anyone ...
0
votes
1answer
917 views

Order View missing buttons

I have my first orders (all sold with PayPal) but in the order view there are no buttons for invoice, ship or reorder. I cant figure out what's wrong. /app/core/ hasn't been changed. Do you have an ...
0
votes
1answer
2k views

“sales_order_place_after” event not working in magento2

I first used sales_model_service_quote_submit_before then used event sales_order_place_after but secound event is not working..any idea? scope is global. ex- Company/Vendors/etc/events.xml <?xml ...
0
votes
1answer
660 views

How to add a custom block on sales order's create page inside admin panel?

I want to add a custom block on sales order's create page under admin section. Here is my code: <adminhtml_sales_order_create_index> <reference name="sidebar"> <block ...
0
votes
1answer
89 views

How to call for an custom attribute in magento backend order page?

I have magento 1.9 and at the order page ( /app/design/adminhtml/default/default/template/sales/items/column/name.phtml ) I need to add a custom attribute called "location" <?php if ($_item = $...
0
votes
1answer
333 views

Magento Add Fee or Discount to Order Totals

I am using a module provided in this link it is working fine for all payment methods except the online transaction. For that I am using PayU money. The same module is used everywhere but it is not ...
0
votes
1answer
153 views

Adding more than one column in Sales Grid

Edit: I managed to add the city column by changing parent to entity, and the city initially appeared in the Grid, but once we started working in the admin, we would eventually get an error! I used: ...
0
votes
1answer
51 views

What happens to the applied sales rules when items are cancelled?

I'm not sure magento supports the partial cancellation(cancel only subset of items from order) Below is my guess how magento works with this issue, but need confirmation. It seems one can achieve ...
0
votes
0answers
1k views

choose order state and status - Magento 2

1) I am looking to achieve below status flow. status flow: Approval -> Processing -> Shipping -> Delivered I could refer this link for understand about order state and status but still it is ...
0
votes
0answers
734 views

Display Best Selling Products

I want replacement of the following code in Magento 2.x class Mage_Catalog_Block_Product_Bestseller extends Mage_Catalog_Block_Product_Abstract{ public function __construct(){ parent::...
0
votes
0answers
166 views

How to Restrict Submit Order for unavailable products from magento backend

Magento frontend not allowed to process the order if cart contains either out of stock product or unavailable product. But When I create an order from Magento admin then How to Restrict Submit Order ...
0
votes
1answer
881 views

Recalculate Total after Order place

I m trying to recalculate magento total using magento event observer after placing order.I m use below code to calculate total. Observer Functon public function recalculateTotal($observer) { //...
0
votes
1answer
811 views

Sales order view custom tab and grid - Ajax problem

I have added a custom tab using xml layout updates to the order view in Magento. I have then added a custom grid to the new tab and enabled Ajax on the grid. I have set setUseAjax(true) and ...
0
votes
2answers
239 views

Can't see specific order magento on admin after supee-7405 [duplicate]

After a couple of days that the patch supee-7405 was released I've decided to install the it. I did a backup of my website because I could see there were a lot of files to modify and I suspected that ...
0
votes
0answers
113 views

Invoice slip not working

I download invoice slip it's not working <?php $orderIdForm = $order->getId(); ?> <form action="<?php echo $this->getUrl('mpshippingmanager/shipping/savetrackingnumber/',...
0
votes
1answer
547 views

Magento new orders are placed as guest in the general group

Suddenly a month ago our shop started getting some new orders with customers defined as guest while being in the general group. These customers do not fall into the NOT LOGGED IN group, in the ...
0
votes
1answer
443 views

How to have different Order ID's or Order Prefix/Suffix for Frontend and Backend Order

We have a unique requirement from one of our client. What is needed is a separate Order Id for Frontend orders and different for backend orders. The basic necessity is to differentiate between the ...
0
votes
1answer
558 views

How can I get special price of an ordered product in “sales_flat_order_item” table

A product which have following prices in catalog has been sold with qty 1:- Price - 65.00 [INR] [Inc. Tax Rs 8.23] Rate - 51.61 [INR] [Inc. Tax Rs 6.54] SpecialPrice - 61.75 [INR] [Inc. Tax Rs 7.82] ...
0
votes
1answer
716 views

Add column in sales order grid without join

Since I got on stackoverflow the comment to post my problem here, I'll give it a try. I hope this is ok because of duplicate posting. https://stackoverflow.com/questions/34336110/magento-add-column-in-...
0
votes
2answers
552 views

Get product id only from load order condition

I am working on order collection module. I want only product id after load particular order. This is my query, $ordered_items = Mage::getModel('sales/order')->loadByIncrementId($incrment_id); Is ...
0
votes
0answers
240 views

Why the same simple product with the same amount added twice into sales_flat_order_item table!

Sales Flat order Item table : Magento Order View Products Block : An other one, this time with 3 SAME SIMPLE ROWS: I recently had two orders which I see the exact same simple product created twice ...
0
votes
0answers
63 views

Override admin html of ordered items

I have created custom order item and quote item named logo. $installer->getConnection()->addColumn($this->getTable('sales_flat_quote_item'), 'logo', 'varchar(255) NOT NULL'); $installer-...
0
votes
1answer
135 views

How do I control the Store View context when programatically creating an Order?

I'm working on a module which imports orders from an external system; the code is working and orders are being created, but are appearing under the wrong Store View. Our installation uses only a ...
0
votes
1answer
99 views

Apply Order Number Prefix For Orders Container Recurring / Nominal Products

I am in the process of trying to highlight specific orders containing recurring / nominal products to an admin user as well as inside a data feed that exports order data on a daily basis to a ...
0
votes
1answer
739 views

Custom filter in the sales order admin grid giving Invalid block t

I've been able to filter custom added column like 'seller name ' its get from seller id of product. other filters are working. $this->addColumn('seller_id', array( 'header' => Mage::...
0
votes
1answer
81 views

why i am getting error while placing the order in magento

I am Getting the Error While Placing The Order. what i have to do for this?how can i place order sucessfully?
0
votes
0answers
163 views

How do I filter the sales grid in admin panel?

This is my code: class Mage_Adminhtml_Block_Sales_Order_Grid extends Mage_Adminhtml_Block_Widget_Grid { public function __construct() { ...
0
votes
1answer
1k views

Magento Admin Login Error: Item (Mage_Sales_Model_Order) with the same id “1178” already exist

I get this error when trying to log in to my admin. Please help! /lib/Varien/Data/Collection/Db.php(576): Varien_Data_Collection->addItem(Object(Mage_Sales_Model_Order)) Trace: 0 /lib/Varien/...
0
votes
1answer
377 views

Getting error while refreshing “adminhtml/sales_order_totals” block through AJAX

I am developing custom module, in which i'm adding custom block sales->order edit page with field price that update total paid price (Order Totals) block. But while refreshing adminhtml/...
0
votes
0answers
563 views

Magento 1.9.1.0 Order email stopped working after the latest security patch instalation

Magento order confirmation email was working properly, suddenly it stopped working after the installation of latest magento security patch. I am also unable to preview the new order template. Error ...
0
votes
1answer
534 views

How to block an order by country?

I currently authorized in the administration five countries but I would want to keep one, so I just chose this country in configuration> General> countries Options> allow countries. The problem is ...
0
votes
0answers
369 views

missing orders after failed order

I have noticed that after a customer does a purchase which fails on the Authorize.net side, the next successful transaction is not added. Any idea why this may happen or how I can fix it?
0
votes
1answer
161 views

observer work even don't use extension!

I used an observer in my extension called checkout_type_onepage_save_order_after but I don't know why this observer work even customers do not use my extension! My extension is custom shipping ...
0
votes
1answer
2k views

Apply custom discount in grand total in create order magento admin

i want to apply custom discount on grand total (without coupons) in create order section in magento admin. i have added 2 lines code for check in this file app\code\core\Mage\Adminhtml\Block\Sales\...
0
votes
3answers
760 views

Billing name order in billing_name column in sales_flat_order_grid table

Can someone please tell me when a record is pushed into the "sales_flat_order_grid" table? How can I switch first name and last name in "billing_name" column of this table?
0
votes
1answer
503 views

How to call new order email template for one Product only rest should default

How do you call a new order email template for one Product only rest of the Product should trigger default order email template?
0
votes
1answer
98 views

How to add custom field next to “Purchased From” column in order view section

In admin panel Order View section how to add custom field next to "Purchased From" column It should look like Purchased From: Main Website Main Website Store Default Store View Purchase Channel: ...
0
votes
0answers
26 views

Order doesn't come

I Just Installed fresh Magento Community with Ultimo theme. And when i tried to place an order it didn't show up in "Reports > Sales > Orders". Like Nothing in the orders list. I've got this warning ...
0
votes
2answers
2k views

Adding button to Adminhtml Order View (guides followed not working)

I know this is a question that has been asked a few times before, however, I have spent most the day trying various solutions (not least from StackExchange) and examples which I've tried to reference ...
0
votes
2answers
309 views

Why is additional_information on payment information empty?

While testing my checkout process, I buy an item and in the Sales, Orders admin screen, in the payment information box, I get 'CreditCard Payment has not been processed yet.' Instead of the credit ...
0
votes
2answers
797 views

Magento Custom field in order grid

I want to add a custom column in magento order grid which should have a input field to populate. This is for screen purpose only so that agent can see information quickly and populate it. customer ...
0
votes
1answer
604 views

Order details page is disturbed on admin side Magento

When i goto my order details page its look disturbed ,i think some css or something missing that disturb the layout.I replace the sales folder and upload new css but still no luck.What else i try to ...
0
votes
1answer
247 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 ...