Gsyfuy

How old can references or sources in a thesis be?

Why do I get two different answers for this counting problem?

How to determine what difficulty is right for the game?

Is it possible to run Internet Explorer on OS X El Capitan?

How does one intimidate enemies without having the capacity for violence?

A case of the sniffles

Is it legal for company to use my work email to pretend I still work there?

What's the output of a record needle playing an out-of-speed record

Can I ask the recruiters in my resume to put the reason why I am rejected?

Watching something be written to a file live with tail

infared filters v nd

Rock identification in KY

Add text to same line using sed

Languages that we cannot (dis)prove to be Context-Free

Roll the carpet

Are astronomers waiting to see something in an image from a gravitational lens that they've already seen in an adjacent image?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

meaning of に in 本当に?

Are the number of citations and number of published articles the most important criteria for a tenure promotion?

What does the "remote control" for a QF-4 look like?

Can a Cauchy sequence converge for one metric while not converging for another?

Does an object always see its latest internal state irrespective of thread?

Convert two switches to a dual stack, and add outlet - possible here?

When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?

Magento 2.2: Order, Invoice, and Shipment do not display in admin grid

How magento 1.7 creates new shipment from admin area?Editing Magento Admin and User order detail pagePrevent Magento from auto-completing ordersShow notice in admin order grid based on filterDisplay custom billing address checkout fields in admin sales order gridOrder grid fails to load in admin panelautomatically email invoice and shipment after creatingsend invoice email immediately when customer place an orderExtending Admin Grid Using Foreach and VariablesSales Order Grid Filter issue with custom column - Magento 2

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I added a product to the cart and create order. It displays properly on the front side in "My Order" tab.

But, when I checked in admin side order grid, then records not updated in order grid.

I have also do reindexing and flush cache and also async indexing is disabled. But, there is no any luck working.

Note: When I create invoice or shipment of the previous order, then it's also not created in admin side. But, it's recorded in the database table is already available. Only not display in order grid.

admin/sales/order/view/order_id/`<previous_order_id>`/key

If direct change by order_id, then it'll display. But, record not display in order grid.

The same issue occurred in invoice and shipment.

How to solve it?

Please help me.

magento2.2 invoice order-grid shipment

share|improve this question

edited Apr 10 '18 at 11:05

Emipro Technologies Pvt. Ltd.

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

bumped to the homepage by Community♦ 30 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have you run command => php bin/magento indexer:reindex?
  
  – Abdul
  Apr 10 '18 at 11:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have already done reindex, cache flush. Asynchronous indexing is disabled. The issue is I get stuck in the database when I checked the record of last order in sales_order table its record is present. but when I check sales_order_grid table last order's record is not added to the table.
  
  – Emipro Technologies Pvt. Ltd.
  Apr 10 '18 at 11:37
  

  
  
  
  

add a comment | 

0

I added a product to the cart and create order. It displays properly on the front side in "My Order" tab.

But, when I checked in admin side order grid, then records not updated in order grid.

I have also do reindexing and flush cache and also async indexing is disabled. But, there is no any luck working.

Note: When I create invoice or shipment of the previous order, then it's also not created in admin side. But, it's recorded in the database table is already available. Only not display in order grid.

admin/sales/order/view/order_id/`<previous_order_id>`/key

If direct change by order_id, then it'll display. But, record not display in order grid.

The same issue occurred in invoice and shipment.

How to solve it?

Please help me.

magento2.2 invoice order-grid shipment

share|improve this question

edited Apr 10 '18 at 11:05

Emipro Technologies Pvt. Ltd.

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

bumped to the homepage by Community♦ 30 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  have you run command => php bin/magento indexer:reindex?
  
  – Abdul
  Apr 10 '18 at 11:12
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have already done reindex, cache flush. Asynchronous indexing is disabled. The issue is I get stuck in the database when I checked the record of last order in sales_order table its record is present. but when I check sales_order_grid table last order's record is not added to the table.
  
  – Emipro Technologies Pvt. Ltd.
  Apr 10 '18 at 11:37
  

  
  
  
  

add a comment | 

I added a product to the cart and create order. It displays properly on the front side in "My Order" tab.

But, when I checked in admin side order grid, then records not updated in order grid.

I have also do reindexing and flush cache and also async indexing is disabled. But, there is no any luck working.

Note: When I create invoice or shipment of the previous order, then it's also not created in admin side. But, it's recorded in the database table is already available. Only not display in order grid.

admin/sales/order/view/order_id/`<previous_order_id>`/key

If direct change by order_id, then it'll display. But, record not display in order grid.

The same issue occurred in invoice and shipment.

How to solve it?

Please help me.

magento2.2 invoice order-grid shipment

share|improve this question

edited Apr 10 '18 at 11:05

Emipro Technologies Pvt. Ltd.

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

admin/sales/order/view/order_id/`<previous_order_id>`/key

share|improve this question

edited Apr 10 '18 at 11:05

Emipro Technologies Pvt. Ltd.

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

share|improve this question

edited Apr 10 '18 at 11:05

Emipro Technologies Pvt. Ltd.

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

asked Apr 10 '18 at 10:52

Emipro Technologies Pvt. Ltd.Emipro Technologies Pvt. Ltd.

2,6431825

1 Answer
1

active

oldest

votes

0

I think you have issue in increment_id. So, try to execute this query in your db.

Note : Here, 7 is current store id which receive order data & 1 is default store id .

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;



ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

So, If you execute this query in your db, then you'll get all new upcoming records will be in order grid.

I think it may be helpful to you.

share|improve this answer

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

add a comment | 

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

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f221714%2fmagento-2-2-order-invoice-and-shipment-do-not-display-in-admin-grid%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I think you have issue in increment_id. So, try to execute this query in your db.

Note : Here, 7 is current store id which receive order data & 1 is default store id .

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;



ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

So, If you execute this query in your db, then you'll get all new upcoming records will be in order grid.

I think it may be helpful to you.

share|improve this answer

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

add a comment | 

0

I think you have issue in increment_id. So, try to execute this query in your db.

Note : Here, 7 is current store id which receive order data & 1 is default store id .

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;



ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

So, If you execute this query in your db, then you'll get all new upcoming records will be in order grid.

I think it may be helpful to you.

share|improve this answer

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

add a comment | 

I think you have issue in increment_id. So, try to execute this query in your db.

Note : Here, 7 is current store id which receive order data & 1 is default store id .

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;



ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

So, If you execute this query in your db, then you'll get all new upcoming records will be in order grid.

I think it may be helpful to you.

share|improve this answer

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

ALTER TABLE sequence_order_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_invoice_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_shipment_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_creditmemo_7 AUTO_INCREMENT = 700001602;

ALTER TABLE sequence_rma_item_7 AUTO_INCREMENT = 700001602;



ALTER TABLE sequence_order_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_shipment_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_creditmemo_1 AUTO_INCREMENT = 100001602;

ALTER TABLE sequence_rma_item_1 AUTO_INCREMENT = 100001602;

share|improve this answer

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865

answered Apr 11 '18 at 4:29

Rohan HapaniRohan Hapani

6,85431865