Mastering Magento (Version 1) - Running a Store with Spreadsheets - Import/ Export

More Views

Mastering Magento (Version 1) - Running a Store with Spreadsheets - Import/ Export

Regular Price: $180.00

Special Price $126.00

Online Training Webinar

This is an online course which you can take from the comfort of your own office or home. Once you have purchased your place you will be sent details of how to join the course.

For stores with a large number of products managing these day to day via the Magento admin panel can be quite a chore. What you need to be able to do is update products on mass and for most a familiar tool to use is the spreadsheet. This webinar is all about the import tool which uses CSV's (or spreadsheets) to maintain, add and update your product data. In this webinar we will show you:

  • What you need to import data...
  • ... and as importantly what you do not need
  • breaking down imports into manageable tasks
  • creating template spreadsheets
  • Adding new products
  • Mass adding of images via import
  • Simplifying the process and debunking many of the complexities

* Required Fields

Regular Price: $180.00

Special Price $126.00

Magento Certified Solution Specialist (MCSS)

Deryck Harlick - UK

Deryck is a Magento Certified Solution Specialist (MCSS), trainer and joint owner of MageTraining. His understanding of Magento’s capabilities along with his knowledge of the best complimentary products and services has enabled him to not only successfully train hundreds of eCommerce managers but also to help them realize the choice of options they have on their eCommerce journey. Deryck is a strong advocate of the Magento community and can be found at many events.

Additional Information

Additional Information

Using spreadsheets to keep your store catalogue up to date, mass update prices at the touch of a button, assign multiple related, cross sell and upsell products. Upload product images for hundreds of products in one import. Imagine the amount of time you would save if you could do all of this without having to go into each product in the admin panel! Yet these are just some of the features of the native import facility in Magento.

We want to show you how to use this tool properly, at first glance it can look complicated but we can show you that actually it is pretty simple if you follow just a few simple rules. Once you get the hang of it there will be no stopping you will find that going into the admin to change products becomes the exception rather than the rule

Magento Version Information Magento Community Edition 1.5 - 1.9.2.2 (also applicable to all version 1.x of Magento Enterprise Editions)
Who Should Attend Product Managers, Ecommerce Managers and Merchandisers
Course Outline

Export

  • Using the filter to export only the products you want
  • How to read the exported CSV file (spreadsheet file)

Import

  • What you need to know about import all data
  • The fundamental of the data
  • What is complex data? How does it look on the spreadsheet
  • Interpreting the column names

Examples Covered in the Session (all done through spreadsheets)

  • Creating new simple products
  • Creating new configurable products
  • Amending products
  • Updating pricing and stock levels
  • Assigning and reassigning products to categories
  • Uploading product images
  • Changing product data for multi store installations
  • Assigning related, cross sell and upsell products

Also

  • Making your uploads manageable
  • Creating spreadsheet templates for specific import jobs
Duration 2.5 Hours