Magento 2 import training videos

A series of ondemand video tutorials showing that anyone can be updating and maintain store product data using import tools.

Introduction to Managing and Updating Magento using Spreadsheets/ CSV’s

Possibly the one subject that will save you the most amount of time dedicated to running your Magento 2 store!

Running a Magento store can be a time-consuming business so finding areas where you can save time and improve efficiencies can only be a good thing. This chapter is all about that!

One of the most time-consuming tasks for most store owners is keeping products up to date, that may be price, descriptions, stock, or anything else for that matter. Updating this manually is a time consuming and a laborious task requiring you to go into each product in the admin and make the change. If you haven't got someone looking over your shoulder then there is no check to see if the change made is correct and so is prone to human error.

Does this ring true for you? If it does then make sure you watch this chapter, if it doesn't then watch this chapter anyway, you may learn something that will help you shave some time off your day!

Understanding the Magento export file

Understanding the Export file will help you understand the Import file.

But don't let the complexity of the export file cloud your judgement on how easy the product import could be. In this section, we will look at how you export your product data and then we will take a look through the export file to understand it. It is an import that you do not fall into the trap of thinking the export file is a template for any future import file, this will only seek to confuse.

Simple new product Import (Part 1)

Let's start with the basics and move up from there!

In this section, we are going to show you that adding a new simple product via a spreadsheet is not really any different to adding it via the admin tool. Anything you are required to do within the admin tool, such as system attributes and required values are also required in the product import. Once you know this you will be able to add products so much quicker than previously.

Simple new product Import (Part 2)

In the previous section, we look at what you need to do to get a product uploaded to your store with the minimum amount of information. In this section, we are going to build on this and add information that will ensure that the product you upload will appear in your store.

Importing Magento 2 Configurable Products

It is completely possible to build a configurable product using the import function. In this section, we look at what you need to consider before you start building your spreadsheet. We then take a two-step approach to building a configurable product.

Step 1 - requires us to create a spreadsheet containing all of the simple products that will make up the configurable options.

Step 2 - requires us, in a different spreadsheet, to create the configurable product which has the references to the simple products created in step 1.

Importing Advanced Pricing

Some products require advanced pricing. This could be a special price for a specific customer group(s) or it could be tier pricing to discount the product based on the quantity purchased. It could be both. In this section, we look at how to upload this pricing using the import function.

Complex Attribute Imports

Complex attributes are attributes that have more than one value per product. For example, a product may appear in more than one category so the attribute for a category may have more than one value associated with it. In this section, we will explore how complex attributes work and how we can update and add to them using the import function.

Updating Products and Keeping it Simple

Keeping your store up to date using spreadsheets does not have to be difficult. We will look at how simple 'do one job only' spreadsheets can help you maintain your store, reduce human error and coordinate updates in a way that will frustrate you that you did not do this a long time ago.