Mryntu

Is "three point ish" an acceptable use of ish?

what's the use of '% to gdp' type of variables?

0-rank tensor vs vector in 1D

Towers in the ocean; How deep can they be built?

Do I need to write [sic] when including a quotation with a number less than 10 that isn't written out?

Reference request: Grassmannian and Plucker coordinates in type B, C, D

Prepend last line of stdin to entire stdin

What does "shotgun unity" refer to here in this sentence?

Is there a way to save my career from absolute disaster?

Can I use the word “Senior” as part of a job title directly in German?

IC has pull-down resistors on SMBus lines?

How to avoid supervisors with prejudiced views?

Help understanding this unsettling image of Titan, Epimetheus, and Saturn's rings?

Iterate through multiline string line by line

Is French Guiana a (hard) EU border?

Is dried pee considered dirt?

Is there an equivalent of cd - for cp or mv

Help/tips for a first time writer?

Help! I cannot understand this game’s notations!

Is it professional to write unrelated content in an almost-empty email?

Is there such a thing as never melting snow?

What is the difference between Statistical Mechanics and Quantum Mechanics

TikZ: How to fill area with a special pattern?

Purpose of level-shifter with same in and out voltages

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

magento-1.9

share

asked 45 secs ago

programming_amazingprogramming_amazing

506

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

magento-1.9

share

asked 45 secs ago

programming_amazingprogramming_amazing

506

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

magento-1.9

share

asked 45 secs ago

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

asked 45 secs ago

programming_amazingprogramming_amazing

506

share

asked 45 secs ago

programming_amazingprogramming_amazing

506

asked 45 secs ago

programming_amazingprogramming_amazing

506

asked 45 secs ago

programming_amazingprogramming_amazing

506