export all products from magento 2 for import into magento 1.9 programaticallymagento 1.9 export all products not workMigrate products, sales and customer data to upgraded Magento dev siteMagento How to Export/Import all products from all store in a single fetch/dump?Magento 2.0 rollback to Magento 1.9x - question about attributesExport all categories & products then import themWhat tables among these to export to start another web not based on magentoMagento 1.9 category import and exportImport only the products from magento 1.9 to Magento 2.1.8Exporting / importing products

How do I check if a string is entirely made of the same substring?

What was Apollo 13's "Little Jolt" after MECO?

What is this word supposed to be?

std::unique_ptr of base class holding reference of derived class does not show warning in gcc compiler while naked pointer shows it. Why?

Is there a word for the censored part of a video?

How to pronounce 'c++' in Spanish

How do I reattach a shelf to the wall when it ripped out of the wall?

What *exactly* is electrical current, voltage, and resistance?

How much of a wave function must reside inside event horizon for it to be consumed by the black hole?

Injection into a proper class and choice without regularity

I preordered a game on my Xbox while on the home screen of my friend's account. Which of us owns the game?

Is there a better way to say "see someone's dreams"?

Check if a string is entirely made of the same substring

Can a stored procedure reference the database in which it is stored?

Can I criticise the more senior developers around me for not writing clean code?

Are there moral objections to a life motivated purely by money? How to sway a person from this lifestyle?

A ​Note ​on ​N!

Why do games have consumables?

Why did Rep. Omar conclude her criticism of US troops with the phrase "NotTodaySatan"?

Find a stone which is not the lightest one

Drawing a german abacus as in the books of Adam Ries

What makes accurate emulation of old systems a difficult task?

How to be good at coming up with counter example in Topology

Is there any pythonic way to find average of specific tuple elements in array?



export all products from magento 2 for import into magento 1.9 programatically


magento 1.9 export all products not workMigrate products, sales and customer data to upgraded Magento dev siteMagento How to Export/Import all products from all store in a single fetch/dump?Magento 2.0 rollback to Magento 1.9x - question about attributesExport all categories & products then import themWhat tables among these to export to start another web not based on magentoMagento 1.9 category import and exportImport only the products from magento 1.9 to Magento 2.1.8Exporting / importing products






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








2















I have finally come to realize that Magento 2 is a way to buggy and unusable. I have 30,000 products and 1500 categories. What tables do I need to export in order to bring them in Magento 1.9?



Also, are there any differences I need to know about? I know category paths are stored as text instead of primary keys in 1.9, anything else?










share|improve this question
















bumped to the homepage by Community 4 hours ago


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















  • Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

    – Purushotam Sharma
    May 12 '16 at 13:32


















2















I have finally come to realize that Magento 2 is a way to buggy and unusable. I have 30,000 products and 1500 categories. What tables do I need to export in order to bring them in Magento 1.9?



Also, are there any differences I need to know about? I know category paths are stored as text instead of primary keys in 1.9, anything else?










share|improve this question
















bumped to the homepage by Community 4 hours ago


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















  • Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

    – Purushotam Sharma
    May 12 '16 at 13:32














2












2








2


1






I have finally come to realize that Magento 2 is a way to buggy and unusable. I have 30,000 products and 1500 categories. What tables do I need to export in order to bring them in Magento 1.9?



Also, are there any differences I need to know about? I know category paths are stored as text instead of primary keys in 1.9, anything else?










share|improve this question
















I have finally come to realize that Magento 2 is a way to buggy and unusable. I have 30,000 products and 1500 categories. What tables do I need to export in order to bring them in Magento 1.9?



Also, are there any differences I need to know about? I know category paths are stored as text instead of primary keys in 1.9, anything else?







magento-1.9 magento2 export






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 30 '18 at 7:14









Teja Bhagavan Kollepara

2,99241950




2,99241950










asked May 12 '16 at 13:20









Justin BlayneyJustin Blayney

10029




10029





bumped to the homepage by Community 4 hours ago


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







bumped to the homepage by Community 4 hours ago


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














  • Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

    – Purushotam Sharma
    May 12 '16 at 13:32


















  • Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

    – Purushotam Sharma
    May 12 '16 at 13:32

















Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

– Purushotam Sharma
May 12 '16 at 13:32






Magento2: Got to System >> Export >> Entity type: products >> Format type: CSV export the product and import in magento1.9

– Purushotam Sharma
May 12 '16 at 13:32











1 Answer
1






active

oldest

votes


















0














I suggest you use the export function in the magento2 Backend. Its pretty good giving you all content needed.



Then dive into Magmi https://sourceforge.net/projects/magmi/ in order to import it back into Magento1.9






share|improve this answer























  • Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

    – Justin Blayney
    May 12 '16 at 21:19











  • There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

    – Kay Int Veen
    May 13 '16 at 6:48











  • How about this: github.com/firebearstudio/importexport

    – Kay Int Veen
    May 13 '16 at 6:49











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


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f115119%2fexport-all-products-from-magento-2-for-import-into-magento-1-9-programatically%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














I suggest you use the export function in the magento2 Backend. Its pretty good giving you all content needed.



Then dive into Magmi https://sourceforge.net/projects/magmi/ in order to import it back into Magento1.9






share|improve this answer























  • Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

    – Justin Blayney
    May 12 '16 at 21:19











  • There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

    – Kay Int Veen
    May 13 '16 at 6:48











  • How about this: github.com/firebearstudio/importexport

    – Kay Int Veen
    May 13 '16 at 6:49















0














I suggest you use the export function in the magento2 Backend. Its pretty good giving you all content needed.



Then dive into Magmi https://sourceforge.net/projects/magmi/ in order to import it back into Magento1.9






share|improve this answer























  • Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

    – Justin Blayney
    May 12 '16 at 21:19











  • There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

    – Kay Int Veen
    May 13 '16 at 6:48











  • How about this: github.com/firebearstudio/importexport

    – Kay Int Veen
    May 13 '16 at 6:49













0












0








0







I suggest you use the export function in the magento2 Backend. Its pretty good giving you all content needed.



Then dive into Magmi https://sourceforge.net/projects/magmi/ in order to import it back into Magento1.9






share|improve this answer













I suggest you use the export function in the magento2 Backend. Its pretty good giving you all content needed.



Then dive into Magmi https://sourceforge.net/projects/magmi/ in order to import it back into Magento1.9







share|improve this answer












share|improve this answer



share|improve this answer










answered May 12 '16 at 13:32









Kay Int VeenKay Int Veen

1,0681923




1,0681923












  • Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

    – Justin Blayney
    May 12 '16 at 21:19











  • There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

    – Kay Int Veen
    May 13 '16 at 6:48











  • How about this: github.com/firebearstudio/importexport

    – Kay Int Veen
    May 13 '16 at 6:49

















  • Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

    – Justin Blayney
    May 12 '16 at 21:19











  • There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

    – Kay Int Veen
    May 13 '16 at 6:48











  • How about this: github.com/firebearstudio/importexport

    – Kay Int Veen
    May 13 '16 at 6:49
















Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

– Justin Blayney
May 12 '16 at 21:19





Hello, Thanks for responding. The Mag 2 export is ok, but it can't handle 30,000 products, i have tried many times and it just freezes. I think sql is the way to go

– Justin Blayney
May 12 '16 at 21:19













There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

– Kay Int Veen
May 13 '16 at 6:48





There are so many records and tables associated. so sounds like a hassle / fault-sesentive. I think this might be a great read to this: firebearstudio.com/blog/…

– Kay Int Veen
May 13 '16 at 6:48













How about this: github.com/firebearstudio/importexport

– Kay Int Veen
May 13 '16 at 6:49





How about this: github.com/firebearstudio/importexport

– Kay Int Veen
May 13 '16 at 6:49

















draft saved

draft discarded
















































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.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f115119%2fexport-all-products-from-magento-2-for-import-into-magento-1-9-programatically%23new-answer', 'question_page');

);

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







Popular posts from this blog

Nidaros erkebispedøme

Birsay

Where did Arya get these scars? Unicorn Meta Zoo #1: Why another podcast? Announcing the arrival of Valued Associate #679: Cesar Manara Favourite questions and answers from the 1st quarter of 2019Why did Arya refuse to end it?Has the pronunciation of Arya Stark's name changed?Has Arya forgiven people?Why did Arya Stark lose her vision?Why can Arya still use the faces?Has the Narrow Sea become narrower?Does Arya Stark know how to make poisons outside of the House of Black and White?Why did Nymeria leave Arya?Why did Arya not kill the Lannister soldiers she encountered in the Riverlands?What is the current canonical age of Sansa, Bran and Arya Stark?