Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

export sku's categories from magento to reimport into a new magento db with magmi
Donald Steinberg

December 19, 2016 - 5:19 pm
Member Since: December 19, 2016
Forum Posts: 25
sp_UserOfflineSmall Offline

Hi, my first posts, Feel free to recommend alternative methods if you think they will work better.
I would greatly appreciate the assistance of the understandinge community. I am running magento 1.9.3
I have a previous setup of a magento database whose sku’s categories I would like to conserve to recreate the database. Is there a way to export each sku’s categories from magento that will not require too much fiddling to reimport with magmi?
thanks again please help

Paul Cartwright
West Midlands, UK

December 20, 2016 - 8:59 am
Member Since: January 7, 2015
Forum Posts: 414
sp_UserOfflineSmall Offline

Hi Donald,

Go to System>Import/Export and create a dataflow export of the fields you require and then export. If you have a large inventory this might to do done using a script or calling direct from ssh. I think Matt & Dave did a tutorial on a dataflow export script, if you look around the UE site I’m sure you will find it.

As to reimporting with magmi, yes it is really easy just will need to change a few headers though images are a little tougher. If you want the images it might be easier to move the whole database across and the media folder. Or if you have the images saved on the your computer then its no issue at all.

Hope this helps

Everyday is an opportunity to learn something new


Why Should You Join UnderstandingE?

  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks


Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.


Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606