Adding order item to orders grid in Magento

Adding order item to orders grid in Magento

magento order viedw how to add new filster coloume ?

magento order viedw how to add new filster coloume ?
Labels:

Magento how to mail in magento php script

Magento how to mail in magento php script ?

Labels:

how to add new filter magento admin order filter by country

magento admin order filter by country

please give me php code for magento

C:\xampp\htdocs\m\app\code\local\Pkmodule\Reward\Block\Adminhtml\Reward\Grid.php


magen i add new $this->addColumn for filter but value not showing ?

magento php code for discount whithout coupone code

i was try to many time to discount first time 20% any purchasing but i did not get any code for discount
please help me give me any idea how can i resolve this functionality without coupon code discount to customer


How do i call .phtml block at specfic page in magento?

below code for simple cms page

{{block type='core/template' name='Test' template='goodtest/test.phtml'}} 
 
and this below code is for php file
 
 

How do i call .phtml block at specfic page in magento?

below code for simple cms page

{{block type='core/template' name='Test' template='goodtest/test.phtml'}} 
 
and this below code is for

How do i call .phtml block at specfic page in magento?

below code for simple cms page

{{block type='core/template' name='Test' template='goodtest/test.phtml'}} 
 
and this below code is for php file
 
<?php 
  echo $this->getLayout()->createBlock('core/template')->setTemplate('goodtest/test.phtml')->toHtml();
?>

banner slider

magento insert and update and delet and all querys

It is very easy to select, insert, delete and update the record in magento site. following functions are helpful in magento site for database queries. You can also use this function outside magento environment with the help pf include “Mage.php” file form “app” folder like.
This is very simple to get data from database of magento site to frontend of magento site or another sites

  1. require_once '../../app/Mage.php';
  2. Mage::app('default');
Select query to get the value form table
  1. $connection = Mage::getSingleton('core/resource')
  2. ->getConnection('core_read');
  3. $select = $connection->select()
  4. ->from('tablename', array('*')) // select * from tablename or use array('id','name') selected values
  5. ->where('id=?',1)               // where id =1
  6. ->group('name');         // group by name
  7. $rowsArray = $connection->fetchAll($select); // return all rows
  8. $rowArray =$connection->fetchRow($select);   //return row
insert query
  1. $connection = Mage::getSingleton('core/resource')
  2. ->getConnection('core_write');
  3. $connection->beginTransaction();
  4. $fields = array();
  5. $fields['name']= 'test';
  6. $fields['age']='25';
  7. $connection->insert('tablename', $fields);
  8. $connection->commit();
update query
  1. $connection = Mage::getSingleton('core/resource')
  2. ->getConnection('core_write');
  3. $connection->beginTransaction();
  4. $fields = array();
  5. $fields['name'] = 'jony';
  6. $where = $connection->quoteInto('id =?', '1');
  7. $connection->update('tablename', $fields, $where);
  8. $connection->commit();
delete query
  1. $condition = array($connection->quoteInto('id=?', '1'));
  2. $connection->delete('tablename', $condition);

magento file uploading error http error

i analyses that media folder should me right-able i mean permission should be 7777

and other think is .htaccess permission


############################################
## adjust memory limit

#    php_value memory_limit 64M
    php_value memory_limit 256M
    php_value max_execution_time 18000


###############R A V I ###################
#php_value upload_max_filesize 712M
php_value post_max_size 712M

php_value upload_max_filesize 712M
php_value max_execution_time 2000
php_value max_input_time 2000
php_value memory_limit 512M
###############P U N I T ###################

Phone SMS: Hasna jamara kisi ko gawara nahi hota,Har musafir ...

Phone SMS: Hasna jamara kisi ko gawara nahi hota,Har musafir ...: Hasna jamara kisi ko gawara nahi hota, Har musafir zindagi ka sahara nahi hota, Milte hain bahot insaan is tanha is zindagi mein, ...

Phone SMS: Milta nahi hai pyaar aasani se zindagi me,Mera nas...

Phone SMS: Milta nahi hai pyaar aasani se zindagi me,Mera nas...: Milta nahi hai pyaar aasani se zindagi me, Mera nasib bhi kabhi khola tha khuda ne, Par ab to dil mein Patjhad hi hain, Fir bhi a...

hot to get actual value when we have inc tax value and percent ?



Inc tax amount = 999

Tax  = 12.5%

Actual value = x

1.       X+(12.5)/100 =999

2.       100x+12.5x/100 =999

3.       112.5x = 99900

4.       X = 99900/112.5

5.       X = 888

Your actual value = 888

Your tax = 999-888 = 111

Short  900*100/(12.5+100)=888

by ankit and abhay
Labels:

module Mage::Sales

Module: Mage_Sales

Resource: sales_order

Aliases:
  • order
Method:
  • sales_order.info (SOAP V1)
  • salesOrderInfo (SOAP V2)
Allows you to retrieve the required order information.
Aliases:
  • order.info
Arguments:
Type Name Description
string sessionId Session ID
string orderIncrementId Order increment ID
Returns:
Type Name Description
array result Array of salesOrderEntity
The salesOrderEntity content is as follows:
Type Name Description
string increment_id Increment ID
string parent_id Parent ID
string store_id Store ID
string created_at Date of creation
string updated_at Date of updating
string is_active Defines whether the order is active
string customer_id Customer ID
string tax_amount Tax amount
string shipping_amount Shipping amount
string discount_amount Discount amount
string subtotal Subtotal sum
string grand_total Grand total sum
string total_paid Total paid
string total_refunded Total refunded
string total_qty_ordered Total quantity ordered
string total_canceled Total canceled
string total_invoiced Total invoiced
string total_online_refunded Total online refunded
string total_offline_refunded Total offline refunded
string base_tax_amount Base tax amount
string base_shipping_amount Base shipping amount
string base_discount_amount Base discount amount
string base_subtotal Base subtotal
string base_grand_total Base grand total
string base_total_paid Base total paid
string base_total_refunded Base total refunded
string base_total_qty_ordered Base total quantity ordered
string base_total_canceled Base total canceled
string base_total_invoiced Base total invoiced
string base_total_online_refunded Base total online refunded
string base_total_offline_refunded Base total offline refunded
string billing_address_id Billing address ID
string billing_firstname First name in the billing address
string billing_lastname Last name in the billing address
string shipping_address_id Shipping address ID
string shipping_firstname First name in the shipping address
string shipping_lastname Last name in the shipping address
string billing_name Billing name
string shipping_name Shipping name
string store_to_base_rate Store to base rate
string store_to_order_rate Store to order rate
string base_to_global_rate Base to global rate
string base_to_order_rate Base to order rate
string weight Weight
string store_name Store name
string remote_ip Remote IP
string status Order status
string state Order state
string applied_rule_ids Applied rule IDs
string global_currency_code Global currency code
string base_currency_code Base currency code
string store_currency_code Store currency code
string order_currency_code Order currency code
string shipping_method Shipping method
string shipping_description Shipping description
string customer_email Email address of the customer
string customer_firstname Customer first name
string customer_lastname Customer last name
string quote_id Shopping cart ID
string is_virtual Defines whether the product is a virtual one
string customer_group_id Customer group ID
string customer_note_notify Customer notification
string customer_is_guest Defines whether the customer is a guest
string email_sent Defines whether the email notification is sent
string order_id Order ID
string gift_message_id Gift message ID
string gift_message Gift message
array shipping_address Array of salesOrderAddressEntity
array billing_address Array of salesOrderAddressEntity
array items Array of salesOrderItemEntity
array payment Array of salesOrderPaymentEntity
array status_history Array of salesOrderStatusHistoryEntity
The salesOrderAddressEntity content is as follows:
Type Name Description
string increment_id Increment ID
string parent_id Parent ID
string created_at Date of creation
string updated_at Date of updating
string is_active Defines whether the address is active
string address_type Address type
string firstname First name
string lastname Last name
string company Company name
string street Street name
string city City
string region Region
string postcode Post code
string country_id Country ID
string telephone Telephone number
string fax Fax number
string region_id Region ID
string address_id Address ID
The salesOrderItemEntity content is as follows:
Type Name Description
string item_id Item ID
string order_id Order ID
string quote_item_id Shopping cart item ID
string created_at Date of creation
string updated_at Date of updating
string product_id Product ID
string product_type Product type
string product_options Product options
string weight Weight
string is_virtual Defines whether the product is a virtual one
string sku Product SKU
string name Product name
string applied_rule_ids Applied rule IDs
string free_shipping Defines whether free shipping is applied
string is_qty_decimal Defines whether the items quantity is decimal
string no_discount Defines whether no discount is applied
string qty_canceled Items quantity canceled
string qty_invoiced Items quantity invoiced
string qty_ordered Items quantity ordered
string qty_refunded Items quantity refunded
string qty_shipped Items quantity shipped
string cost Cost
string price Price
string base_price Base price
string original_price Original price
string base_original_price Base original price
string tax_percent Tax percent
string tax_amount Tax amount
string base_tax_amount Base tax amount
string tax_invoiced Tax invoiced
string base_tax_invoiced Base tax invoiced
string discount_percent Discount percent
string discount_amount Discount amount
string base_discount_amount Base discount amount
string discount_invoiced Discount invoiced
string base_discount_invoiced Base discount invoiced
string amount_refunded Amount refunded
string base_amount_refunded Base amount refunded
string row_total Row total
string base_row_total Base row total
string row_invoiced Row invoiced
string base_row_invoiced Base row invoiced
string row_weight Row weight
string gift_message_id Gift message ID
string gift_message Gift message
string gift_message_available Defines whether the gift message is available
string base_tax_before_discount Base tax before discount
string tax_before_discount Tax before discount
string weee_tax_applied Applied fixed product tax
string weee_tax_applied_amount Applied fixed product tax amount
string weee_tax_applied_row_amount Applied fixed product tax row amount
string base_weee_tax_applied_amount Applied fixed product tax amount (in base currency)
string base_weee_tax_applied_row_amount Applied fixed product tax row amount (in base currency)
string weee_tax_disposition Fixed product tax disposition
string weee_tax_row_disposition Fixed product tax row disposition
string base_weee_tax_disposition Fixed product tax disposition (in base currency)
string base_weee_tax_row_disposition Fixed product tax row disposition (in base currency)
The salesOrderPaymentEntity content is as follows:
Type Name Description
string increment_id Increment ID
string parent_id Parent ID
string created_at Date of creation
string updated_at Date of updating
string is_active Active flag
string amount_ordered Amount ordered
string shipping_amount Shipping amount
string base_amount_ordered Base amount ordered
string base_shipping_amount Base shipping amount
string method Payment method
string po_number Purchase order number
string cc_type Credit card type
string cc_number_enc Credit card number
string cc_last4 Credit card last 4 digits
string cc_owner Credit card owner
string cc_exp_month Credit card expiration month
string cc_exp_year Credit card expiration year
string cc_ss_start_month Credit card start month (Switch/Solo)
string cc_ss_start_year Credit card start year (Switch/Solo)
string payment_id Payment ID
The salesOrderStatusHistoryEntity content is as follows:
Type Name Description
string increment_id Increment ID
string parent_id Parent ID
string created_at Date of creation
string updated_at Date of updating
string is_active Active flag
string is_customer_notified Defines whether the customer is notified
string status Order status
string comment Order comment

Examples

Request Example SOAP V1
$client = new SoapClient('http://magentohost/api/soap/?wsdl');

// If somestuff requires api authentification,
// then get a session token
$session = $client->login('apiUser', 'apiKey');

$result = $client->call($session, 'sales_order.info', 'orderIncrementId');
var_dump($result);

// If you don't need the session anymore
//$client->endSession($session);
Request Example SOAP V2
$proxy = new SoapClient('http://magentohost/api/v2_soap/?wsdl'); // TODO : change url
$sessionId = $proxy->login('apiUser', 'apiKey'); // TODO : change login and pwd if necessary

$result = $proxy->salesOrderInfo($sessionId, '200000006');
var_dump($result);
Request Example SOAP V2 (WS-I Compliance Mode)
$proxy = new SoapClient('http://magentohost/api/v2_soap/?wsdl'); 

$sessionId = $proxy->login((object)array('username' => 'apiUser', 'apiKey' => 'apiKey')); 
 
$result = $proxy->salesOrderInfo((object)array('sessionId' => $sessionId->result, 'orderIncrementId' => '200000006'));   
var_dump($result->result);
Response Example SOAP V1
array
  'state' => string 'new' (length=3)
  'status' => string 'pending' (length=7)
  'coupon_code' => null
  'protect_code' => string 'defe18' (length=6)
  'shipping_description' => string 'Flat Rate - Fixed' (length=17)
  'is_virtual' => string '0' (length=1)
  'store_id' => string '2' (length=1)
  'customer_id' => string '2' (length=1)
  'base_discount_amount' => string '0.0000' (length=6)
  'base_discount_canceled' => null
  'base_discount_invoiced' => null
  'base_discount_refunded' => null
  'base_grand_total' => string '619.9700' (length=8)
  'base_shipping_amount' => string '10.0000' (length=7)
  'base_shipping_canceled' => null
  'base_shipping_invoiced' => null
  'base_shipping_refunded' => null
  'base_shipping_tax_amount' => string '0.0000' (length=6)
  'base_shipping_tax_refunded' => null
  'base_subtotal' => string '609.9700' (length=8)
  'base_subtotal_canceled' => null
  'base_subtotal_invoiced' => null
  'base_subtotal_refunded' => null
  'base_tax_amount' => string '0.0000' (length=6)
  'base_tax_canceled' => null
  'base_tax_invoiced' => null
  'base_tax_refunded' => null
  'base_to_global_rate' => string '1.0000' (length=6)
  'base_to_order_rate' => string '1.0000' (length=6)
  'base_total_canceled' => null
  'base_total_invoiced' => null
  'base_total_invoiced_cost' => null
  'base_total_offline_refunded' => null
  'base_total_online_refunded' => null
  'base_total_paid' => null
  'base_total_qty_ordered' => null
  'base_total_refunded' => null
  'discount_amount' => string '0.0000' (length=6)
  'discount_canceled' => null
  'discount_invoiced' => null
  'discount_refunded' => null
  'grand_total' => string '619.9700' (length=8)
  'shipping_amount' => string '10.0000' (length=7)
  'shipping_canceled' => null
  'shipping_invoiced' => null
  'shipping_refunded' => null
  'shipping_tax_amount' => string '0.0000' (length=6)
  'shipping_tax_refunded' => null
  'store_to_base_rate' => string '1.0000' (length=6)
  'store_to_order_rate' => string '1.0000' (length=6)
  'subtotal' => string '609.9700' (length=8)
  'subtotal_canceled' => null
  'subtotal_invoiced' => null
  'subtotal_refunded' => null
  'tax_amount' => string '0.0000' (length=6)
  'tax_canceled' => null
  'tax_invoiced' => null
  'tax_refunded' => null
  'total_canceled' => null
  'total_invoiced' => null
  'total_offline_refunded' => null
  'total_online_refunded' => null
  'total_paid' => null
  'total_qty_ordered' => string '2.0000' (length=6)
  'total_refunded' => null
  'can_ship_partially' => null
  'can_ship_partially_item' => null
  'customer_is_guest' => string '0' (length=1)
  'customer_note_notify' => string '1' (length=1)
  'billing_address_id' => string '1' (length=1)
  'customer_group_id' => string '1' (length=1)
  'edit_increment' => null
  'email_sent' => string '1' (length=1)
  'forced_shipment_with_invoice' => null
  'payment_auth_expiration' => null
  'quote_address_id' => null
  'quote_id' => string '1' (length=1)
  'shipping_address_id' => string '2' (length=1)
  'adjustment_negative' => null
  'adjustment_positive' => null
  'base_adjustment_negative' => null
  'base_adjustment_positive' => null
  'base_shipping_discount_amount' => string '0.0000' (length=6)
  'base_subtotal_incl_tax' => string '609.9700' (length=8)
  'base_total_due' => null
  'payment_authorization_amount' => null
  'shipping_discount_amount' => string '0.0000' (length=6)
  'subtotal_incl_tax' => string '609.9700' (length=8)
  'total_due' => null
  'weight' => string '1.2000' (length=6)
  'customer_dob' => null
  'increment_id' => string '200000001' (length=9)
  'applied_rule_ids' => null
  'base_currency_code' => string 'USD' (length=3)
  'customer_email' => string 'john@example.com' (length=16)
  'customer_firstname' => string 'johny' (length=5)
  'customer_lastname' => string 'doe' (length=3)
  'customer_middlename' => null
  'customer_prefix' => null
  'customer_suffix' => null
  'customer_taxvat' => null
  'discount_description' => null
  'ext_customer_id' => null
  'ext_order_id' => null
  'global_currency_code' => string 'USD' (length=3)
  'hold_before_state' => null
  'hold_before_status' => null
  'order_currency_code' => string 'USD' (length=3)
  'original_increment_id' => null
  'relation_child_id' => null
  'relation_child_real_id' => null
  'relation_parent_id' => null
  'relation_parent_real_id' => null
  'remote_ip' => string '127.0.0.1' (length=9)
  'shipping_method' => string 'flatrate_flatrate' (length=17)
  'store_currency_code' => string 'USD' (length=3)
  'store_name' => string 'website
English store
English' (length=29)
  'x_forwarded_for' => null
  'customer_note' => null
  'created_at' => string '2012-03-30 11:40:30' (length=19)
  'updated_at' => string '2012-03-30 11:40:32' (length=19)
  'total_item_count' => string '2' (length=1)
  'customer_gender' => null
  'hidden_tax_amount' => string '0.0000' (length=6)
  'base_hidden_tax_amount' => string '0.0000' (length=6)
  'shipping_hidden_tax_amount' => string '0.0000' (length=6)
  'base_shipping_hidden_tax_amnt' => string '0.0000' (length=6)
  'hidden_tax_invoiced' => null
  more elements...
Labels:

magento create customer code

magento create customer
 

image light box easy or simple script

Subscribe to: Posts (Atom)

How to check if Magento is running in production mode or developer mode

If you want to know. your Magento 2 website is running on which environment you can run below command on terminal and very easily you can kn...

Popular Posts

  • Create a Linux Swap File
    Swap is a space on a disk that is used when the amount of physical RAM memory is full. When a Linux system runs out of RAM, inactive pages...
  • Magento 2 Speed Optimze
      Basic 1 . Merge css and js. By Run below command you can find out which mode is active. php bin / magento deploy:mode:show ...
  • Magento 2 | What is proxies in magento 2.
      Video link for real example. Proxies Design Pattern Proxies  is a powerful and easy technique to help you overcome a huge problem of Mag...

Posts