Magmi Import 'price' Update Issue
So, after doing a Magmi Import to a product with 'price' included, whilst looking through the product catalog in the back-end of Magento, it will appear as if the product hasn't been changed (price stays as old price) along with looking at the product in a category view in front-end.
However, if going into the actual product editor in the back-end, OR going to the actual product page in front-end, it shows the proper updated price. Also, if you now save the product in back-end, it will save the new price to where it can be seen everywhere properly.
Any idea why this happens and how it can be done to import the new price and have it working in all areas?
MAGmi: v0.7.22 //
Magento: CE1.9.3.2
UPDATE:
I have done the re-indexing and cleared cache many a time, this is actually a recurring issue that I've had for a while, just now taking the opportunity to try and resolve it rather than manually fix.
magento-1.9 price magmi
asked Mar 6 '17 at 17:58
ne0nlight
80218
add a comment |
So, after doing a Magmi Import to a product with 'price' included, whilst looking through the product catalog in the back-end of Magento, it will appear as if the product hasn't been changed (price stays as old price) along with looking at the product in a category view in front-end.
However, if going into the actual product editor in the back-end, OR going to the actual product page in front-end, it shows the proper updated price. Also, if you now save the product in back-end, it will save the new price to where it can be seen everywhere properly.
Any idea why this happens and how it can be done to import the new price and have it working in all areas?
MAGmi: v0.7.22 //
Magento: CE1.9.3.2
UPDATE:
I have done the re-indexing and cleared cache many a time, this is actually a recurring issue that I've had for a while, just now taking the opportunity to try and resolve it rather than manually fix.
magento-1.9 price magmi
asked Mar 6 '17 at 17:58
ne0nlight
80218
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago
add a comment |
So, after doing a Magmi Import to a product with 'price' included, whilst looking through the product catalog in the back-end of Magento, it will appear as if the product hasn't been changed (price stays as old price) along with looking at the product in a category view in front-end.
However, if going into the actual product editor in the back-end, OR going to the actual product page in front-end, it shows the proper updated price. Also, if you now save the product in back-end, it will save the new price to where it can be seen everywhere properly.
Any idea why this happens and how it can be done to import the new price and have it working in all areas?
MAGmi: v0.7.22 //
Magento: CE1.9.3.2
UPDATE:
I have done the re-indexing and cleared cache many a time, this is actually a recurring issue that I've had for a while, just now taking the opportunity to try and resolve it rather than manually fix.
magento-1.9 price magmi
asked Mar 6 '17 at 17:58
ne0nlight
80218
So, after doing a Magmi Import to a product with 'price' included, whilst looking through the product catalog in the back-end of Magento, it will appear as if the product hasn't been changed (price stays as old price) along with looking at the product in a category view in front-end.
However, if going into the actual product editor in the back-end, OR going to the actual product page in front-end, it shows the proper updated price. Also, if you now save the product in back-end, it will save the new price to where it can be seen everywhere properly.
Any idea why this happens and how it can be done to import the new price and have it working in all areas?
MAGmi: v0.7.22 //
Magento: CE1.9.3.2
UPDATE:
I have done the re-indexing and cleared cache many a time, this is actually a recurring issue that I've had for a while, just now taking the opportunity to try and resolve it rather than manually fix.
magento-1.9 price magmi
magento-1.9 price magmi
asked Mar 6 '17 at 17:58
ne0nlight
80218
asked Mar 6 '17 at 17:58
ne0nlight
80218
edited Mar 6 '17 at 20:36
asked Mar 6 '17 at 17:58
ne0nlight
80218
asked Mar 6 '17 at 17:58
ne0nlight
80218
asked Mar 6 '17 at 17:58
ne0nlight
80218
80218
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago
add a comment |
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago
add a comment |
3 Answers
3
active
oldest
votes
Try these below, might be it's help for you.
Solution 1 :-
Have you performed a Re-Index after import?(Or have "Magmi Magento Reindexer" Plugin enabled on import)
That should fix the issue and show updated price also in frontend category view
Re-Indexed only product prices index?
Probably also re-index for product flat data index is required for update price everywhere.
Or go for a full re-index (which is what Magmi reindexer would do) to verify its indeed an issue with indexes and not related to something else (e. g. some cache, FPC etc.)
Solution 2:-
To work with multistore, you MUST vary on "store" column putting
storeviews code, not on "websites" column.
here:
store, sku, price
abc, 1001, 5.00
bab, 1001, 7.00
should do it.
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
add a comment |
Once you upload prices go to System > Index Management and reindex:
- Product prices
- Product flat data (if you are using flat catalog)
magmi doesn't update price index tables
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
add a comment |
At a guess, you need to update the indexes and clear cache on completion. I'm sure there's an option in magmi to do this.
answered Mar 6 '17 at 19:17
Steve Holdoway
572
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%2f163115%2fmagmi-import-price-update-issue%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 these below, might be it's help for you.
Solution 1 :-
Have you performed a Re-Index after import?(Or have "Magmi Magento Reindexer" Plugin enabled on import)
That should fix the issue and show updated price also in frontend category view
Re-Indexed only product prices index?
Probably also re-index for product flat data index is required for update price everywhere.
Or go for a full re-index (which is what Magmi reindexer would do) to verify its indeed an issue with indexes and not related to something else (e. g. some cache, FPC etc.)
Solution 2:-
To work with multistore, you MUST vary on "store" column putting
storeviews code, not on "websites" column.
here:
store, sku, price
abc, 1001, 5.00
bab, 1001, 7.00
should do it.
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
add a comment |
Try these below, might be it's help for you.
Solution 1 :-
Have you performed a Re-Index after import?(Or have "Magmi Magento Reindexer" Plugin enabled on import)
That should fix the issue and show updated price also in frontend category view
Re-Indexed only product prices index?
Probably also re-index for product flat data index is required for update price everywhere.
Or go for a full re-index (which is what Magmi reindexer would do) to verify its indeed an issue with indexes and not related to something else (e. g. some cache, FPC etc.)
Solution 2:-
To work with multistore, you MUST vary on "store" column putting
storeviews code, not on "websites" column.
here:
store, sku, price
abc, 1001, 5.00
bab, 1001, 7.00
should do it.
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
add a comment |
Try these below, might be it's help for you.
Solution 1 :-
Have you performed a Re-Index after import?(Or have "Magmi Magento Reindexer" Plugin enabled on import)
That should fix the issue and show updated price also in frontend category view
Re-Indexed only product prices index?
Probably also re-index for product flat data index is required for update price everywhere.
Or go for a full re-index (which is what Magmi reindexer would do) to verify its indeed an issue with indexes and not related to something else (e. g. some cache, FPC etc.)
Solution 2:-
To work with multistore, you MUST vary on "store" column putting
storeviews code, not on "websites" column.
here:
store, sku, price
abc, 1001, 5.00
bab, 1001, 7.00
should do it.
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
Try these below, might be it's help for you.
Solution 1 :-
Have you performed a Re-Index after import?(Or have "Magmi Magento Reindexer" Plugin enabled on import)
That should fix the issue and show updated price also in frontend category view
Re-Indexed only product prices index?
Probably also re-index for product flat data index is required for update price everywhere.
Or go for a full re-index (which is what Magmi reindexer would do) to verify its indeed an issue with indexes and not related to something else (e. g. some cache, FPC etc.)
Solution 2:-
To work with multistore, you MUST vary on "store" column putting
storeviews code, not on "websites" column.
here:
store, sku, price
abc, 1001, 5.00
bab, 1001, 7.00
should do it.
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
answered Mar 29 '17 at 5:07
Umesh Kumar
2,3491328
2,3491328
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
add a comment |
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
How can i import images for my multi store.multi store details : snag.gy/rGlAPY.jpg and csv screen shots : snag.gy/Q9ZEme.jpg. its not working. may i know what is an error?
– Gem
Aug 2 '17 at 7:46
add a comment |
Once you upload prices go to System > Index Management and reindex:
- Product prices
- Product flat data (if you are using flat catalog)
magmi doesn't update price index tables
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
add a comment |
Once you upload prices go to System > Index Management and reindex:
- Product prices
- Product flat data (if you are using flat catalog)
magmi doesn't update price index tables
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
add a comment |
Once you upload prices go to System > Index Management and reindex:
- Product prices
- Product flat data (if you are using flat catalog)
magmi doesn't update price index tables
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
Once you upload prices go to System > Index Management and reindex:
- Product prices
- Product flat data (if you are using flat catalog)
magmi doesn't update price index tables
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
answered Mar 6 '17 at 19:16
Konstantin Gerasimov
3,395730
3,395730
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
add a comment |
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
This has been done many a time, so I would rule this out. Still thumping my head against what could be the issue
– ne0nlight
Mar 6 '17 at 20:36
add a comment |
At a guess, you need to update the indexes and clear cache on completion. I'm sure there's an option in magmi to do this.
answered Mar 6 '17 at 19:17
Steve Holdoway
572
add a comment |
At a guess, you need to update the indexes and clear cache on completion. I'm sure there's an option in magmi to do this.
answered Mar 6 '17 at 19:17
Steve Holdoway
572
add a comment |
At a guess, you need to update the indexes and clear cache on completion. I'm sure there's an option in magmi to do this.
answered Mar 6 '17 at 19:17
Steve Holdoway
572
At a guess, you need to update the indexes and clear cache on completion. I'm sure there's an option in magmi to do this.
answered Mar 6 '17 at 19:17
Steve Holdoway
572
answered Mar 6 '17 at 19:17
Steve Holdoway
572
answered Mar 6 '17 at 19:17
Steve Holdoway
572
answered Mar 6 '17 at 19:17
Steve Holdoway
572
572
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f163115%2fmagmi-import-price-update-issue%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
I'm having the same issues. Tried store view, ect. My Brain hurts. Re indexed. Cleared Cache. Still nothing. Just went down to one sku to test. Below is my report and the CSV used. I've also tried with store just "admin" with same reuslts no updates. store,sku,Price,Force FS,Ship Cost,package_id "admin,storeview1,storeview2,storeview3",TP-87740,384.99,399.99,15, title:MAGMI by dweeves - version:0.7.18 startup:Running Magmi Product Import Engine v1.7.1 by dweeves startup:Import Profile:Prices startup:Import Mode:update step:step:0.5% plugin;Magmi_CSVDataSource;pluginhello:CSV Datasource-1.3-Dwe
– Nick Hartman
23 hours ago
This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. You can also add a bounty to draw more attention to this question once you have enough reputation. - From Review
– Aasim Goriya
22 hours ago