Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Extracting product data
Steve Froggatt
Member
May 15, 2014 - 12:47 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

is there anyway i can extract product data without using the standard export routine, as that brings in loads of stuff i dont want.

ideally i just want SKU, Description & price.

if not in module form, does anyone know if you can extract it from the SQL database straight into excel when using Simple Servers.

Thanks
Steve

Avatar
Matthew Ogborne

Founder
May 15, 2014 - 2:58 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Steve,

Yes, use the dataflow export option in Magento.

Go to System > Tools > Dataflow profiles

If you check the existing ones you’ll be able to see what you can export (which is pretty much everything) and control what is exported as well.

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

Steve Froggatt
Member
May 15, 2014 - 3:14 pm
Member Since: May 2, 2014
Forum Posts: 514
sp_UserOfflineSmall Offline

Thanks matt….. however do you know where it saves the excel/xml I am presuming it stores it on the remote (simplyserver) server.

I have been playing around with excel so I can have the products in a spreadsheet and just hit refresh to get the upto date data without running data profiles

Steve

Avatar
Matthew Ogborne

Founder
May 15, 2014 - 6:59 pm
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Hi Steve,

Yes see the folder where it extracts to, by default this is var/export

Export-All-Products-Profiles-Import-and-Export-System-Magento-Admin.pngImage Enlarger

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

 

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:
22 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: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606