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
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)
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
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
shipping_instruction
,payment_term
are not fields of standard Magento in thesales_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 thecarrier_code
: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your statuswaiting_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
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
magento-1.9
edited 14 hours ago
programming_amazing
asked yesterday
programming_amazingprogramming_amazing
506
506
shipping_instruction
,payment_term
are not fields of standard Magento in thesales_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 thecarrier_code
: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your statuswaiting_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 |
shipping_instruction
,payment_term
are not fields of standard Magento in thesales_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 thecarrier_code
: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your statuswaiting_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
add a comment |
0
active
oldest
votes
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
shipping_instruction
,payment_term
are not fields of standard Magento in thesales_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 thecarrier_code
: The tracking data is usually assigned to an order when something has been shipped, which might not be the case in your statuswaiting_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