Ttdfjt

A hang glider, sudden unexpected lift to 25,000 feet altitude, what could do this?

Is it a bad idea to plug the other end of ESD strap to wall ground?

That's an odd coin - I wonder why

"Eavesdropping" vs "Listen in on"

How to implement Comparable so it is consistent with identity-equality

Why was Sir Cadogan fired?

Free fall ellipse or parabola?

How to compactly explain secondary and tertiary characters without resorting to stereotypes?

Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico

Arrows in tikz Markov chain diagram overlap

Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?

Is it correct to say moon starry nights?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

Can Sri Krishna be called 'a person'?

Are British MPs missing the point, with these 'Indicative Votes'?

Can this transistor (2N2222) take 6 V on emitter-base? Am I reading the datasheet incorrectly?

Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact

How dangerous is XSS

Is the offspring between a demon and a celestial possible? If so what is it called and is it in a book somewhere?

Can I cast Thunderwave and be at the center of its bottom face, but not be affected by it?

What day is it again?

Find a path from s to t using as few red nodes as possible

Compensation for working overtime on Saturdays

Can a PhD from a non-TU9 German university become a professor in a TU9 university?

Not getting the information about orders - NULL (line level)

0

I've been trying without success to obtain the line level information about a specific order but i am getting the header information.

Take a look at this picture:

This is my query:

select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term
from sales_flat_order o
join sales_flat_order_item oi 
 on o.entity_id = oi.order_id 
left join sales_flat_shipment_track t 
 on o.entity_id = t.order_id 
where oi.parent_item_id is null

What's wrong? Can you please help me to solve this?

EDIT:

This is what i found in MYSQL:

The problem here is that i do not understand how should i look into this in order to obtain what i need :/.

magento-1.9

share|improve this question

edited 14 hours ago

programming_amazing

asked yesterday

programming_amazingprogramming_amazing

506

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  shipping_instruction, payment_term are not fields of standard Magento in the sales_flat_order table. Therefore you should look into your customization if you would expect data in that fields - the SQL returns NULL because there is no data in that fields for the orders you have selected. Regarding the carrier_code: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your status waiting_approval (which again is not standard Magento but some customization). IMHO the SQL is correct and returns the data you have in database.
  
  – HelgeB
  19 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @HelgeB Thank you for replying, dude. I've edited my question. Have you got any idea about it? What should i do?
  
  – programming_amazing
  14 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have the data of order lines ( sales_flat_order_item table) in your SQL joined to the order head (sales_flat_order table) data. For example the SKU comes from there. So I don't really understand what your problem is - it's not clear what you are looking for and what is not working. Again, your SQL is correct and returns oder lines joined to order head data.
  
  – HelgeB
  14 hours ago
  

  
  
  
  

add a comment | 

0

I've been trying without success to obtain the line level information about a specific order but i am getting the header information.

Take a look at this picture:

This is my query:

select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term
from sales_flat_order o
join sales_flat_order_item oi 
 on o.entity_id = oi.order_id 
left join sales_flat_shipment_track t 
 on o.entity_id = t.order_id 
where oi.parent_item_id is null

What's wrong? Can you please help me to solve this?

EDIT:

This is what i found in MYSQL:

The problem here is that i do not understand how should i look into this in order to obtain what i need :/.

magento-1.9

share|improve this question

edited 14 hours ago

programming_amazing

asked yesterday

programming_amazingprogramming_amazing

506

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  shipping_instruction, payment_term are not fields of standard Magento in the sales_flat_order table. Therefore you should look into your customization if you would expect data in that fields - the SQL returns NULL because there is no data in that fields for the orders you have selected. Regarding the carrier_code: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your status waiting_approval (which again is not standard Magento but some customization). IMHO the SQL is correct and returns the data you have in database.
  
  – HelgeB
  19 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @HelgeB Thank you for replying, dude. I've edited my question. Have you got any idea about it? What should i do?
  
  – programming_amazing
  14 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have the data of order lines ( sales_flat_order_item table) in your SQL joined to the order head (sales_flat_order table) data. For example the SKU comes from there. So I don't really understand what your problem is - it's not clear what you are looking for and what is not working. Again, your SQL is correct and returns oder lines joined to order head data.
  
  – HelgeB
  14 hours ago
  

  
  
  
  

add a comment | 

I've been trying without success to obtain the line level information about a specific order but i am getting the header information.

Take a look at this picture:

This is my query:

select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term
from sales_flat_order o
join sales_flat_order_item oi 
 on o.entity_id = oi.order_id 
left join sales_flat_shipment_track t 
 on o.entity_id = t.order_id 
where oi.parent_item_id is null

What's wrong? Can you please help me to solve this?

EDIT:

This is what i found in MYSQL:

The problem here is that i do not understand how should i look into this in order to obtain what i need :/.

magento-1.9

share|improve this question

edited 14 hours ago

programming_amazing

asked yesterday

programming_amazingprogramming_amazing

506

select o.increment_id, o.status, oi.price_incl_tax, t.carrier_code, o.created_at, oi.price_pvp, oi.created_at, o.shipping_instruction, o.payment_term
from sales_flat_order o
join sales_flat_order_item oi 
 on o.entity_id = oi.order_id 
left join sales_flat_shipment_track t 
 on o.entity_id = t.order_id 
where oi.parent_item_id is null

share|improve this question

edited 14 hours ago

programming_amazing

asked yesterday

programming_amazingprogramming_amazing

506

share|improve this question

edited 14 hours ago

programming_amazing

asked yesterday

programming_amazingprogramming_amazing

506

asked yesterday

programming_amazingprogramming_amazing

506

asked yesterday

programming_amazingprogramming_amazing

506