Product .csv import stuck on “Please Wait”
I'm not sure why but all of a sudden when I try to import my .csv file to update my products it gets stuck on the "Please Wait" screen. It was working just fine one day then the next it's doing this. What do I do... Please help!
product-import
add a comment |
I'm not sure why but all of a sudden when I try to import my .csv file to update my products it gets stuck on the "Please Wait" screen. It was working just fine one day then the next it's doing this. What do I do... Please help!
product-import
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48
add a comment |
I'm not sure why but all of a sudden when I try to import my .csv file to update my products it gets stuck on the "Please Wait" screen. It was working just fine one day then the next it's doing this. What do I do... Please help!
product-import
I'm not sure why but all of a sudden when I try to import my .csv file to update my products it gets stuck on the "Please Wait" screen. It was working just fine one day then the next it's doing this. What do I do... Please help!
product-import
product-import
asked Oct 9 '17 at 13:59
LacyLacy
61
61
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48
add a comment |
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48
add a comment |
3 Answers
3
active
oldest
votes
Try submitting the file again with the network window opened (F12 on Chrome) & search for the request to see if there are any visible errors.
I had a similar issue & in my case I had to increase the value of client_max_body_size on nginx.conf.
It may also be a result of too low memory_limit/max_execution_time/post_max_size/... on php.ini
add a comment |
The actual "Import" button (after the validation step), trigger an AJAX request to the server. If the server takes too long to respond (1 minute by default, depending our your server/php.ini settings), the "Please wait" notification will never disappear.
This doesn't mean however, that your import isn't running. The AJAX request still triggered the import to run. Check the import_history
table in your database and search for your import there. If the execution_time
field is set, it means that the import is processed and you can view the output in the summary
field.
add a comment |
I would wait and check htop
and inspect the tree
of the top process. If your using a limited environment, it may be running slow because of not enough resources.
As soon as I started an import of an ~11M file in Magento 2.3 , my site became unresponsive, /usr/sbin/apache2 -k start
began consuming >90% of my CPU while mysql
started consuming more memory. There are multiple of /usr/sbin/apache2 -k start
running all the time but during import one went to ~100%.
Eventually (after 5min) the "Please wait" notification did go away and the page updated on it's own. Then CPU and memory consumption went back to normal. If the import has errors, they will be listed on the page after "Please wait..." goes away.
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
});
}
});
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%2f196485%2fproduct-csv-import-stuck-on-please-wait%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try submitting the file again with the network window opened (F12 on Chrome) & search for the request to see if there are any visible errors.
I had a similar issue & in my case I had to increase the value of client_max_body_size on nginx.conf.
It may also be a result of too low memory_limit/max_execution_time/post_max_size/... on php.ini
add a comment |
Try submitting the file again with the network window opened (F12 on Chrome) & search for the request to see if there are any visible errors.
I had a similar issue & in my case I had to increase the value of client_max_body_size on nginx.conf.
It may also be a result of too low memory_limit/max_execution_time/post_max_size/... on php.ini
add a comment |
Try submitting the file again with the network window opened (F12 on Chrome) & search for the request to see if there are any visible errors.
I had a similar issue & in my case I had to increase the value of client_max_body_size on nginx.conf.
It may also be a result of too low memory_limit/max_execution_time/post_max_size/... on php.ini
Try submitting the file again with the network window opened (F12 on Chrome) & search for the request to see if there are any visible errors.
I had a similar issue & in my case I had to increase the value of client_max_body_size on nginx.conf.
It may also be a result of too low memory_limit/max_execution_time/post_max_size/... on php.ini
answered Dec 20 '17 at 12:27
PiniPini
371212
371212
add a comment |
add a comment |
The actual "Import" button (after the validation step), trigger an AJAX request to the server. If the server takes too long to respond (1 minute by default, depending our your server/php.ini settings), the "Please wait" notification will never disappear.
This doesn't mean however, that your import isn't running. The AJAX request still triggered the import to run. Check the import_history
table in your database and search for your import there. If the execution_time
field is set, it means that the import is processed and you can view the output in the summary
field.
add a comment |
The actual "Import" button (after the validation step), trigger an AJAX request to the server. If the server takes too long to respond (1 minute by default, depending our your server/php.ini settings), the "Please wait" notification will never disappear.
This doesn't mean however, that your import isn't running. The AJAX request still triggered the import to run. Check the import_history
table in your database and search for your import there. If the execution_time
field is set, it means that the import is processed and you can view the output in the summary
field.
add a comment |
The actual "Import" button (after the validation step), trigger an AJAX request to the server. If the server takes too long to respond (1 minute by default, depending our your server/php.ini settings), the "Please wait" notification will never disappear.
This doesn't mean however, that your import isn't running. The AJAX request still triggered the import to run. Check the import_history
table in your database and search for your import there. If the execution_time
field is set, it means that the import is processed and you can view the output in the summary
field.
The actual "Import" button (after the validation step), trigger an AJAX request to the server. If the server takes too long to respond (1 minute by default, depending our your server/php.ini settings), the "Please wait" notification will never disappear.
This doesn't mean however, that your import isn't running. The AJAX request still triggered the import to run. Check the import_history
table in your database and search for your import there. If the execution_time
field is set, it means that the import is processed and you can view the output in the summary
field.
answered Mar 13 '18 at 9:35
NielsNiels
1,167722
1,167722
add a comment |
add a comment |
I would wait and check htop
and inspect the tree
of the top process. If your using a limited environment, it may be running slow because of not enough resources.
As soon as I started an import of an ~11M file in Magento 2.3 , my site became unresponsive, /usr/sbin/apache2 -k start
began consuming >90% of my CPU while mysql
started consuming more memory. There are multiple of /usr/sbin/apache2 -k start
running all the time but during import one went to ~100%.
Eventually (after 5min) the "Please wait" notification did go away and the page updated on it's own. Then CPU and memory consumption went back to normal. If the import has errors, they will be listed on the page after "Please wait..." goes away.
add a comment |
I would wait and check htop
and inspect the tree
of the top process. If your using a limited environment, it may be running slow because of not enough resources.
As soon as I started an import of an ~11M file in Magento 2.3 , my site became unresponsive, /usr/sbin/apache2 -k start
began consuming >90% of my CPU while mysql
started consuming more memory. There are multiple of /usr/sbin/apache2 -k start
running all the time but during import one went to ~100%.
Eventually (after 5min) the "Please wait" notification did go away and the page updated on it's own. Then CPU and memory consumption went back to normal. If the import has errors, they will be listed on the page after "Please wait..." goes away.
add a comment |
I would wait and check htop
and inspect the tree
of the top process. If your using a limited environment, it may be running slow because of not enough resources.
As soon as I started an import of an ~11M file in Magento 2.3 , my site became unresponsive, /usr/sbin/apache2 -k start
began consuming >90% of my CPU while mysql
started consuming more memory. There are multiple of /usr/sbin/apache2 -k start
running all the time but during import one went to ~100%.
Eventually (after 5min) the "Please wait" notification did go away and the page updated on it's own. Then CPU and memory consumption went back to normal. If the import has errors, they will be listed on the page after "Please wait..." goes away.
I would wait and check htop
and inspect the tree
of the top process. If your using a limited environment, it may be running slow because of not enough resources.
As soon as I started an import of an ~11M file in Magento 2.3 , my site became unresponsive, /usr/sbin/apache2 -k start
began consuming >90% of my CPU while mysql
started consuming more memory. There are multiple of /usr/sbin/apache2 -k start
running all the time but during import one went to ~100%.
Eventually (after 5min) the "Please wait" notification did go away and the page updated on it's own. Then CPU and memory consumption went back to normal. If the import has errors, they will be listed on the page after "Please wait..." goes away.
answered 2 days ago
learnsomemorelearnsomemore
61
61
add a comment |
add a comment |
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%2f196485%2fproduct-csv-import-stuck-on-please-wait%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
Might be a server issue, check the logs under var/logs
– gabehou
Oct 9 '17 at 14:57
Has your csv increased in size? Have you tried importing just a single product?
– jscar
Oct 9 '17 at 15:48