Blog | Website Wizardry

Using CSV to Import Products into Shopping Carts

16/10/2012

Our preferred ecommerce solution is Magento. It’s an open source product which means we can download it and customise it however we want for our customers. This articles uses direction from Magento but the concept is similar no matter which shopping cart you use.

Do you have thousands (or even hundreds) of products that you want to get into your new (or existing) ecommerce website?  Well, you’re not alone and this article will help give an overview of how you do it.

Our preferred ecommerce solution is Magento.  It’s an open source product which means we can download it and customise it however we want for our customers. This articles uses direction from Magento but the concept is similar no matter which shopping cart you use.

Retrieving your CSV Template

When you want to import your products into a new (or even exisiting) shopping cart, the first thing you need to do is run a test export so you have the correct template.  In Magento, we do it this way;

1. From the top menu, select System > Import/Export > Export

2. On the next screen, choose Products and CSV

3. Then scroll to the bottom of the next view and click Continue

Your CSV file will now be downloaded and saved in your selected location.  You now use this as your csv template to help get your data in place when importing your new products.

Importing your Product Data

You will see a wide range of columns within your template.  The key here is to first identify which columns you need to use and one way to quickly do this is to refer to your shopping carts user manual – or ask your web developer of course :-)

Note: Remember to provide an SKU for each entity – without this your import will not pass the validation.

Once you have finished your CSV, follow these steps to finish off this process;

1. From the top menu, select System > Import/Export > Export

2. On the next screen, choose ProductsAppend Complex Data and then select your file.

3. Click the button Check Data and then see the results that appear

4. If your data is successful, click Import

Your data is now in the system, to check this you will need to go to Catalogue > Manage Productsand look in the product list to see if your products are listed.

The final step is to select a few of your products, go through the details pages and check that you have used the right data in the right places.

If you feel you have made a mistake and would like to start again, simply select all your products from the list view and using bulk action you can delete all lines.