Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

All Questions

0
votes
0answers
11 views

Sales order report per currency

We are using the M1 default sales order reports for our internal reports. However we have three different sites (language purpose) sharing the same base currency, but they can all have up to three ...
0
votes
0answers
23 views

order sale vs purchase order in Magento (not getting the difference)

I dont fully understand what is the difference between Sale Order and Purchase Order in MAGENTO. In my system i have 4 tables that are related to the Sale Order and 4 tables that are related to the ...
0
votes
0answers
17 views

Magento1 admin order status update 404 error page

I have Magento1 website but when Admin panel Order Grid select any order then submit that order status update click on submit button show second page 404 error come. So solution please this problem. ...
0
votes
2answers
32 views

How to get value from sales_flat_order_item table using quote_item_id?

Using the sales_order_place_after event in my custom Observer. I have the quote_item_id value (example 324). How to get the corresponding item_id value from the sales_flat_order_item table? I am ...
1
vote
1answer
34 views

Efficient method to load/get and assign multiple custom options/attributes from quote item?

Is there a more efficient way to load and assign quote item custom options/attributes? This is code in my Observer: public function MyFunction(Varien_Event_Observer $observer) { $QuoteObject = Mage::...
1
vote
0answers
28 views

How to get additional_information on sales/order

This is my code. I would like to get additional_information on API. I'm using getPayment, on this way, I believe that I can define this function there. I don´t know, just looking for some help or ...
1
vote
0answers
27 views

Magento 1.9 set custom field/attribute when order is set to complete

When order change status from "x" to "complete" I need save when order was completed. I am trying to achieve this with sales_order_save_commit_after event. Problem is that I can't save order when the ...
0
votes
1answer
62 views

checkout success page events magento

I have just created one module after checkout success event in Magento. etc/config.xml <?xml version="1.0"?> <config> <modules> <Tech_Paymentinfo> &...
1
vote
1answer
23 views

Magento 1 - Predict Order Id Before creating the order

I have a use-case where I need to know the order id from Magento before completing the order. The idea is that I essentially call an API and if the API call is successful, then I proceed to complete ...
0
votes
1answer
35 views

how to update Items Ordered order qty in magento 1

how to update order Items qty in admin panel? (magento 1.9)
1
vote
1answer
42 views

Magento 1.9 - Customer placed the order successfully but its not in the Magento Admin Panel

I am facing a very serious issue with Magento 1.9 website. This has happened a couple of times. Customer places the order, they even get an email confirming the order but the order does not show in ...
1
vote
2answers
55 views

Magento1.9 Product SKU in Sales order grid

i have use default collection and change this file /app/code/core/Mage/Adminhtml/Block/Sales/Order/grid.php Now replace your _prepareCollection() function to this following code protected ...
2
votes
1answer
49 views

Can't change customers groupId in observer

I try to change the customers group id in the observer sales_order_place_after but it seems to be impossible. I successfully managed to change the firstname of the customer just for test, but groupId ?...
1
vote
1answer
39 views

Get total in observer sales_order_place_before

I try to get the total value (price of his order) of the customer in the sales_order_place_before event. How can I read the total value? This is a part of my observer, it is getting called, I only ...
2
votes
1answer
63 views

What is different between subtotal and subtotal_invoiced

Sometimes I have seen in order in the sales_flat_orders table that have a subtotal but have no subtotal_invoiced. What is different between them? Here is a sample row extracted from sales_flat_orders ...
0
votes
0answers
20 views

Order Totals Block Missing in admin and customer portal Magento1.9.2.4

When I view orders in admin and customer portal the totals section is not displaying in the table footer section. The same issue with invoice and credit memo in the customer portal and admin panel. ...
0
votes
1answer
183 views

add username to order comment history

I wanna show the username who commented on order history my question is like below question https://stackoverflow.com/questions/6219620/add-username-to-order-comment-history but it is for Magento 1....
1
vote
0answers
46 views

Magento 1 - How to exclude column data from export csv file?

I want to exclude Email and Billing Telephone columns data from orders export csv file for specific user. I am using Rave Infosys Order Import / Export extension. These columns data should be empty ...
1
vote
0answers
27 views

Magento1.9 shipping method must be specified when admin edit orders

I am trying to edit order in the admin section when showing "Shipping method must be specified." enter image description here
2
votes
1answer
35 views

Mail Notification when Item is Out of Stock

I am trying to achieve the following: When an item is Out of Stock send an E-Mail Notification to the warehouse. First question would be: what's the easiest and cleanest way to achieve this?! My ...
1
vote
2answers
198 views

Magento 1.9 The requested Payment Method is not available

We want to disable a specific payment method, because we changed to another payment service provider. But when we disable the module, we can not open the old orders anymore. We get the error: The ...
0
votes
0answers
46 views

Admin Product Price Rounding issue in Order Detail Item

I have Magento 1.9.3.2 and I have import order with my custom code and it's working fine only one issue is when I open order from admin All order item (Product) price is roundup like 8.51 will become ...
1
vote
0answers
40 views

client order detail page total due issue magento 1.9

i am using magento 1.9 i have created a rule for if order price is less then $5000 add shipping charges $10. its working fine but what i need is when the rule is applied than plus $10 into total due ...
1
vote
1answer
395 views

Creating Quote and Order programmatically and the issue with ReservedOrderId

I was trying to create orders and quotes programmatically, in an API resource that is consumed by a Mobile Application, and i was successful. However every now and then I got a ...
3
votes
1answer
43 views

Magento1.9 updated orders list programatically

programatically fetch the magento updated orders list in magento1.9 Thanks
1
vote
1answer
46 views

On order page in action tab want to delete button

In the Sales>Order page on the right side, there is the drop-down option for Actions. In that actions tab, there is the delete option and I want to hide this option from that page. Anyone know how to ...
0
votes
1answer
28 views

Configurable Product MSRP

I'm working on a query where I need to grab the MSRP from a simple product for orders placed to run some finance calculations (margin...). The sales_flat_order_item table includes the configurable ...
0
votes
0answers
17 views

Forward order to dealers who are appointed by main admin pin code wise in magento 1.9

When any new order is received, forward that order to dealer who is from same area where customer wants shipment. That dealer will further process the order & will take payment from customer. ...
1
vote
2answers
342 views

Get all the details of sales order via order id in my controller?

I want to get my all the details of a sale order in my controller and then update the status of that order. Plus how can I pass order ID in URL string and than get it as Magento1.9 doesn't allow $...
0
votes
0answers
33 views

Mganto1.9 : Item (Mage_Sales_Model_Order) with same id already exist

After I migrate my Magento shop from one hosting provider to another one I have a big problem. When I want to go in back to administration into sales->order I get an error There has been an ...
0
votes
1answer
339 views

how to fetch order number, payment method and customer name according to invoice number in admin panel grid?

I`m fetching invoice collection using Mage::getModel('sales/order_invoice')->getCollection(); but I also want Order number, payment method and customer name according to the invoice number. How to ...
0
votes
1answer
120 views

Admin submit order event

I want to fire my custom ajax request when admin click on submit order button. What I need to do for this ?
1
vote
0answers
186 views

How to check all order item already invoiced

Currently I can check if order already has invoice like this: $order = Mage::getModel('sales/order')->load('1'); $hasInvoice = $order->getInvoiceCollection()->count(); if($hasInvoice > 0) ...
1
vote
1answer
124 views

How to get billing address from sales/order_grid_collection?

I have sales/order_grid_collection where I'm getting the desired attributes on my grid, but the last one attribute I need is the billing street of the order, how can I get that programmatically? ...
1
vote
1answer
171 views

Error when creating order from admin panel (Invalid method Mage_Sales_Model_Order::queueNewOrderEmail)

We are running Magento CE 1.9.3.8 and have noticed an issue when creating an order manually from the admin panel (Sales > Orders > Create New Order). When we create an order the following error is ...
0
votes
0answers
34 views

Magento 1.9 the changes in core/Mage/Sales/wsdl.xml not working?

I have changed directly the core sales/wsdl.xml and wsi.xml files to add a custom column value in order_info and order_list of SOAP API V2 but it doesn't appear, Please help me. I am stuck.
0
votes
1answer
498 views

Fatal error: Call to a member function getTelephone() on boolean in /app/code/core/Mage/Sales/Model/Order.php

I am using Magento 1.9.1.0. Below mentioned error happen after payment made by using paypal express checkout. Steps 1: Register and add a product to cart Steps 2: Give the Billing Information & ...
0
votes
0answers
169 views

How to add the new field in sales order item at Magento 1.9.x

How to add the new field in sales order item at Magento 1.9.x And save the field in the database. Add that table field
2
votes
0answers
257 views

Why some order id are skipping from admin panel Sales > Order [duplicate]

Why this number jumps from 189 to 191 ? When i found this issue there were many missing order number. Even i got solution that some order with status : pending or hold cant be seen in the admin ...
0
votes
1answer
308 views

“Call to a member function getMethodInstance() on boolean in /magento/app/code/core/Mage/Payment/Model/Observer.php on line 46”

this is my code $URL='';(url of third party api) $simple = simplexml_load_file($URL); foreach($simple->FEEDBACK as $result){ $service_score=$result->SERVICESTARRATING; $...
2
votes
1answer
220 views

Magento 1.9 API v2 Payment Additional Information

I'm trying to extend the API response of Magento SalesOrderInfo - more specifically, I'm trying to get back the paymnent additional_information In my module, in etc/wsdl.xml I added <...
0
votes
1answer
33 views

Get list of all order item for a product

I want to get the list of sales_flat_order_item for a product. I tried the following $read = Mage::getSingleton('core/resource')->getConnection('core_read'); $result = $read->query("SELECT ...
2
votes
1answer
40 views

Order collection not showing the order that have been invoiced

I try to retrieve all the order collections, but when I observe by looping the collections and print the order id, I notice the order that has been invoiced is not inside the collection. $collections ...
0
votes
1answer
337 views

Magento 1.9.2 coupon( discount) not appearing while creating invoice

We are currently using magento 1.9.2 and facing some issue, discount is not showing on invoice. Neither on invoice pdf nor on invoice page. This issue only appear if order is created from magento ...
1
vote
1answer
344 views

Tracing missing order numbers in the database, possibly even before they are “reserved”

Hoping for someone to chime in who extensively knows the Magento database architecture inside out. Missing order numbers. Example, in Magento, order number increments like: 100002410 100002411 ...
5
votes
4answers
590 views

How can I create Admin(Manual) order without the Products available in the Website?

I need to create manual(Admin) order, without the products present in the website, I mean order create for not available products in website. How to achieve using any custom options?
0
votes
1answer
29 views

Create an auto reference number for every magento order id (for courier billing purposes )

I want to create a reference number for every Magento order that comes, which I want to use for courier billing purposes. A reference number will be additional security for me for courier billing ...
1
vote
2answers
898 views

Magento 1.9 : sales_flat_order and sales_flat_order_grid tables are not updating

I used many update methods for update values in sales_flat_order and sales_flat_order_grid tables.but no method didn't work. I don't know why the update is not done. Method 1:- $coreResource = Mage:...
0
votes
2answers
127 views

Why is the $this->getOrders method always returns a null object in this code Magento

I am new to magento.I am trying to create a view for the purchase history for users.Already there is a page to display this(As I am using a template).But as a experiment I tried to create a new page ...
1
vote
2answers
3k views

How to export orders in csv file?

I'm new on Magento. How to export orders with code SKU price etc. I read the link below but didn't get where to add this code and how this code works please help. Programmatically Export Sales ...