Not getting the information about orders - NULL (line level) The Next CEO of Stack OverflowObtain all orders from MAGENTO B2B without success`getLastPageNumber()` returning wrong number of pagesSQL Syntax Error near 'cat_index.is_parent=1'sales_flat_order_payment and column: method = null last 2 orderssales order grid custom column filter QLSTATE[42S22]: Column not found: 1054 Unknown columnMagento more than 61 product attribute database tables in join queryMagento 1.9: Maximum execution timeout after loginFind products (eav_attribute table) MagentoModifying a query (get products using SQL only)I am not getting all the products after executing my queryGet all products with status = enabled and price (not working)

Multi tool use
Multi tool use

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)



The Next CEO of Stack OverflowObtain all orders from MAGENTO B2B without success`getLastPageNumber()` returning wrong number of pagesSQL Syntax Error near 'cat_index.is_parent=1'sales_flat_order_payment and column: method = null last 2 orderssales order grid custom column filter QLSTATE[42S22]: Column not found: 1054 Unknown columnMagento more than 61 product attribute database tables in join queryMagento 1.9: Maximum execution timeout after loginFind products (eav_attribute table) MagentoModifying a query (get products using SQL only)I am not getting all the products after executing my queryGet all products with status = enabled and price (not working)










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:



example



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:



image



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










share|improve this question
























  • 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















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:



example



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:



image



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










share|improve this question
























  • 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













0












0








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:



example



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:



image



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










share|improve this question
















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:



example



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:



image



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















share|improve this question













share|improve this question




share|improve this question








edited 14 hours ago







programming_amazing

















asked yesterday









programming_amazingprogramming_amazing

506




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

















  • 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
















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





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





@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





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










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268102%2fnot-getting-the-information-about-orders-null-line-level%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Magento Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f268102%2fnot-getting-the-information-about-orders-null-line-level%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







bC3rnE NS2OY6Wbz1diQXpHY,1TFtzDXxA9CsWs0Le,T p,9MbT1H8JjVaojDM6 sktf6ImymwV0BGehvLpcase8GZP,v wGX V8TNcDPj K2
c7T0uXqi9ggP9vLR0 1t2ZljNAanFT7aXk UECJsJP,ci,GLOr,b,H O9TldeaRf

Popular posts from this blog

Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

Circuit construction for execution of conditional statements using least significant bitHow are two different registers being used as “control”?How exactly is the stated composite state of the two registers being produced using the $R_zz$ controlled rotations?Efficiently performing controlled rotations in HHLWould this quantum algorithm implementation work?How to prepare a superposed states of odd integers from $1$ to $sqrtN$?Why is this implementation of the order finding algorithm not working?Circuit construction for Hamiltonian simulationHow can I invert the least significant bit of a certain term of a superposed state?Implementing an oracleImplementing a controlled sum operation

Magento 2 “No Payment Methods” in Admin New OrderHow to integrate Paypal Express Checkout with the Magento APIMagento 1.5 - Sales > Order > edit order and shipping methods disappearAuto Invoice Check/Money Order Payment methodAdd more simple payment methods?Shipping methods not showingWhat should I do to change payment methods if changing the configuration has no effects?1.9 - No Payment Methods showing upMy Payment Methods not Showing for downloadable/virtual product when checkout?Magento2 API to access internal payment methodHow to call an existing payment methods in the registration form?