Questions tagged [sales-order]

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

Filter by
Sorted by
Tagged with
4
votes
3answers
4k views

Why I cannot create an invoice from an completed order

I am using Magento 1.7.0.2 and I have a problem with some orders. They are paid by CC and the order is now Completed but I can not create an Invoice. I can not see the invoice button on Order and I ...
3
votes
1answer
1k views

addColumn to sales_flat_order_grid table with CASE data

Using Magento ver. 1.9.0.1 Using this amazingly well written answer "Add Column to a grid (observer) - Column ‘store_id’ in where clause is ambiguous issue" I have added new basic columns to the ...
0
votes
1answer
3k views

What is the best method to delete sub stores from Magento?

So we have a Magento setup with 1 main store and 48 sub stores. For a multitude of reasons we now want to reverse a lot of work quickly and essentially delete these 48 sub stores systematically. We ...
7
votes
7answers
11k views

How do I add a customer's email to the sales invoice?

Essentially looking to add customer email to our customer's receipts (invoices) and sales order emails that are generated to dispatch/couriers as well etc. With a bit of searching I've established ...
1
vote
1answer
2k views

cannot add new field to sales flat table in magento CE 1.9.0.1

I wrote module which will create a new varchar field in sales_flat_order. For this we create seutp set but it not working ,where the issue: app/code/local/Bh/Affiliate/etc/config.xml <?xml ...
1
vote
1answer
1k views

Null customer_address_id on sales_flat_order_address table

Does somebody know why field customer_address_id is null on sales_flat_order_address table? As regards to order for customer who has an address. In class: Mage_Sales_Model_Order_Address I found this: ...
1
vote
1answer
2k views

Add the 'Short Description' to the 'items ordered' table within a sales order admin view

Is it possible to add the 'Short Description' to the 'order view' within the 'Sales admin page'. Primarily in the 'items ordered' table so; [Product][Item Status][Original Price][Price][Qty]...etc ...
-1
votes
2answers
868 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 ??
4
votes
5answers
14k views

Magento's sales orders report is wrong

We use the Sales orders report to know how many bucks we earn. For this reason we update the statistic every day by a cron job. But the report has wrong values. Nothing it's equal to the values that ...
1
vote
4answers
2k views

How reset order history magento without myphpadmin?

I need nulling/zero/ reset order history. For example, New Order # 100000001 (BUT NOT # 10000023) Preferably without the use MyPHPadmin. Maybe my problem can be solved through SSH commands or by ...
0
votes
1answer
250 views

Override Mage_Adminhtml_Block_Sales_Items_Column_Name Block

I'm trying to add an extra data to the file: /app/design/adminhtml/default/ad02/template/downloadable/sales/items/column/downloadable/name.phtml Target idea: provide a link with a href="....": <...
1
vote
3answers
619 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
3answers
13k views

How to change the title text on the sale email?

How can I change the title text on the sale email? I always get this in my email when I make an order, Main Website Store: New Order # 100000016 I want to change it to, [Name of my Store]: New ...
2
votes
1answer
1k views

Add Customer Group attribute to Sales Order

I have created a new attribute for Customer Groups called course_id but I need to get the value of this attribute to then become the value for a new attribute for a Sales Order. Any ideas how I could ...
2
votes
4answers
8k views

How to get invoice from order item

Is it possible to get the invoice from an order item? To be more specific: I'm iterating the order ItemsCollection and if the order-item has been invoiced $item->getStatusId() == ...
3
votes
3answers
15k views

add custom section in admin sales order view in Magento

I am stuck in custom code. Actually I want to add custom information section on sales order view page in admin like Account Information', 'Billing Address', 'Shipping Address'. But I don't want to ...
1
vote
1answer
953 views

Magento: create order programatically: Configurable product issue [duplicate]

I am trying to create order programmatically. There are configurable products having single base attribute i.e. Size. and some of configurable products have multiple (more than one) associated ...
0
votes
3answers
2k views

Online Refund to Paypal

Is it possible to create an online refund to PayPal? I am going to Sales -> Orders Selecting the order I want, then select Invoices from the menu at the left and click Credit Memo, however the only ...
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.
2
votes
3answers
3k views

Customers multiple email addresses

I've been searching high and low but I can't seem to find any information on this. My client would like the ability of multiple email addresses to a customer, so that all sales emails would be sent ...
0
votes
1answer
287 views

how to set payment method to new order by code [closed]

I have payment method: $paymentmethods = Mage::getModel('marketplace/paymentmethods'); $paymentmethods->load(1); and new order: $order = Mage::getModel('sales/order') ->...
3
votes
2answers
4k views

Custom Field Value not saving on sales_flat_quote & sales_flat_order

I have created a custom field from sales_flat_quote & sales_flat_order tables and in checkout page have field called delivery_date. When an order is being placed, it's not saving my custom field ...
0
votes
2answers
173 views

Placing orders programmatically from 3rd party ordering system

Before I start pulling my hair out with this one as I think its going to be a complicated one I would really appreciate someones advice. The current situation is a company I'm working on makes all of ...
3
votes
1answer
426 views

Why is there a quote_address_id field in sales_flat_order_address table?

Just stumbled upon the quote_address_id property of sales/order_address entity (sales_flat_order_address table) which in my case is always NULL. Well I wonder .. what is is for? My only guess it is ...
1
vote
2answers
546 views

insert custom item variable through xml in magento admin order detail Magento

Hi I am developing a magento extension in which I need to show a product custom attribute in the magento order detail. I want to add it through xml without editing/ overwriting any core file .. For ...
4
votes
2answers
7k views

how to set custom field in order

how to set custom field in order and use that field in all the appropriate linked pages like order admin grid, customer my account page, order details page in admin. I want to create one field in ...
1
vote
0answers
152 views

download custom option uploaded image in order even if Add Store Code to Urls set yes [duplicate]

Magento ver. 1.7.0.2 In my Store Under System -> Configuration -> General -> Web , I set Add Store Code to Urls Yes. Due to i get problem to download custom option image from order. If I set NO than ...
1
vote
1answer
3k views

Add product to wishlist programmatically not working

I am trying to add products from the admin create order screen straight into the users wishlist programmatically however it doesn't seem to be working. $quote = Mage::getSingleton('adminhtml/...
2
votes
1answer
691 views

add error message to order view and stop shipment creation process [closed]

I have created event observer to add tracking numbers automatically. I am useing this event: <sales_order_shipment_save_before> And there is my code for adding tracking number: public ...
0
votes
1answer
30 views

TransactionAmount problems!

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

add button to order view after tracking number is added to order

is it possible to add custom button to order view when tracking number is added? i have event observer(<sales_order_shipment_save_before>) that adds tracking number to order when button submit ...
0
votes
1answer
1k views

How to redirect to custom module after order is placed on admin panel?

After I create an order (fill the form) in the admin panel and clicking submit order button, usually the page gets redirected to order_view page. I use sales_order_place_after event , I need to ...
2
votes
1answer
1k views

New order email code

I am having a bit of trouble finding the code in Magento which relates to sending the new order email to the admin emails specified in the Configuration > Sales menu in the back-end. Where is this ...
1
vote
1answer
941 views

Magento Database: Negative values in sales_flat_order.discount_amount?

Looking into my Magento database inside the sales_flat_order table, I find - since the day I updated from the 1.4 to the 1.5 version - the values of discount_amount being negative (e.g. -5 EUR for a 5 ...
1
vote
1answer
645 views

Magento : get customer_id from salesOrderList

i try to get orderl list with this API :salesOrderList (SOAP V2) i use this code : env = new SoapSerializationEnvelope(SoapEnvelope.VER11); env.dotNet = false; env.xsd = ...
0
votes
1answer
341 views

Add discount rule name in sales order [closed]

I want to add discount rule with coupon code in order total section in sales order in admin-end. Please let me know where I can make modifications. Sorry I just forgot to tell that coupon are getting ...
2
votes
1answer
2k views

Attaching guest checkout orders to user accounts

I'm stuck with a specific requirement on my magento shop. I have enabled the guest checkout method on magento to remove the necessity of registering. But now this information is useless for providing ...
0
votes
1answer
274 views

Change created order number

I lost a few orders at Magento and I am recreating it manually, but I need to keep the old id. I do not have enough information to create all the lost orders, because this some orders id need to be ...
0
votes
1answer
1k views

How to display multiple, fully detailed orders per page in the My Orders section of customer area?

I'm currently able to display single, detailed orders in the customer area of Magento's front-end. I log into my test account and I go to My Account > My Orders where I am presented with a summary of ...
1
vote
2answers
6k views

how to get the qty of items invoiced

I'm creating a partial invoice and I'm unable to get the qty invoiced to send it to the payment gateway. The code I'd written in my model for capture() is: if ($order->hasInvoices()) { ...
1
vote
2answers
527 views

Why is the updated_at field handled differently than other fields when removing from archive?

When trying to move an order from archive back to the sales I get the following error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual ...