Dtjytyk

What's that red-plus icon near a text?

Does detail obscure or enhance action?

Did Shadowfax go to Valinor?

Why are electrically insulating heatsinks so rare? Is it just cost?

Which country benefited the most from UN Security Council vetoes?

Rock identification in KY

Was any UN Security Council vote triple-vetoed?

What does it mean to describe someone as a butt steak?

Can a monk's single staff be considered dual wielded, as per the Dual Wielder feat?

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

Is it possible to do 50 km distance without any previous training?

Add text to same line using sed

Why can't we play rap on piano?

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

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

What's the point of deactivating Num Lock on login screens?

meaning of に in 本当に?

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

Unable to deploy metadata from Partner Developer scratch org because of extra fields

Why doesn't H₄O²⁺ exist?

Codimension of non-flat locus

Has there ever been an airliner design involving reducing generator load by installing solar panels?

How to determine what difficulty is right for the game?

How does quantile regression compare to logistic regression with the variable split at the quantile?

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♦ 4 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♦ 4 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