Help Centre

Support > Ecommerce > Selling Online

How to use the Create Import/Export tool

Import/Export is a fantastic way to update your whole Create Shop at one time, using a .txt file. It's perfect if you would like to edit any existing options, such as the price of many products, as well as adding products in bulk.

In this guide we will be looking at the following:

How to export your file
How to edit your spreadsheet
Things to check before you import your file
How to import your file

How To Export Your File

Before you can start editing your file and uploading new products the first thing you will need to do is export a file of your existing Shop. This gives you the basis to then make your changes, ensuring you keep the same format.

To export your file please follow these instructions:

  1. Go to your “Shop” area on the Top Menu
  2. Click “Import/Export” in the left-hand menu
  3. Under the “Export” title choose if you wish to export a file of your Shop Categories or Shop Products. Exporting your Shop Categories will display all the information within your shop categories, such as the “Title” and “Category Image”, but not any product information. Exporting your Shop Products will display all the information in each of your shop products, meaning you can edit each product separately
  4. If you would like to export Shop Categories select the “Export Categories” button
  5. If you would like to export your Shop Products choose a specific category of products you would like to download, by selecting the “Choose Category” drop-down menu. If you wish to download all products select the “Top” category. Click the "Export Products" button
  6. Save your file to your computer.

 

Once you have saved this file you will then need to open this to start editing your Shop. For more information on how to open your exported file please see our guide here.

How To Edit Your Spreadsheet

When you have opened your file into a spreadsheet format you can now start to edit this and make changes to your Shop. You can make these changes simply by adding or editing existing content in the fields of this spreadsheet.

Firstly, it is extremely important that the format of the spreadsheet does not change while you are editing this as this will have a negative effect on your import. Therefore we would strongly recommend reading our guide here for an overview of the format of your file.

Secondly, it is imperative that an unedited version of your file is saved separately before you start to make any changes. This will help your Account Manager, should they need to see these changes you have made.

Lastly there are certain aspects of your products that could have a negative effect on your import, should they be changed or added. These are as follows:

  • Product Options - It is not currently possible to edit these using Import & Export
  • HTML Fragments – If these are present within your products this could cause some error
  • Special Characters – Characters such as TM or (another!) will cause your file to error when importing
  • Spaces – Any spaces added before titles or SKU's will create a new product in your Shop, so if you are editing these ensure there is no space before
  • Amount of products – If you have over 3000 products in your file we would recommend uploading this in batches. This will ensure the Create Shop updates all the information correctly.

Once you have made these changes to your file you are now ready to import this into your Create account!

Things To Check Before You Import Your File

Before you import your edited file into your Create Shop there are a few things we would advise double checking!

  • Do you have any spaces before the text in your SKU or Product Title field?
  • Do you have any HTML Fragments in your products or categories?
  • Do you have any special characters within your file?
  • Do all the URL's within your spreadsheet have “http://” in front of them?
  • Have you saved an unedited version of this file to your computer?
  • How many products are on your spreadsheet?
  • Is your file in the correct format? The file name must have no spaces in it and it should end with .txt.

If you have ticked off the list above then you can import your file into your Shop!

How To Import Your File

To import your file into your Shop please follow these instructions:

  1. Go to your “Shop” area on the Top Menu
  2. Select “Import/Export” from the left-hand menu
  3. Choose your import “Type” from the drop-down list
  4. Click “Choose File” next to your “File” field and choose your file
  5. Choose whether or not to "Update Images?" - see below for more details
  6. Click “Import”!

Update Images - By choosing this option, when you upload your file it will retrieve any images that are hosted externally and upload them into your Create account. This means that they will now be hosted with Create and not on your external host. You will be able to use the optimise features with these images, and they will count towards your account storage space usage. This is useful if you are transferring a Shop you are about to close to our service as you can move all of the images in one go, without manually uploading them individually. The images will be automatically reduced if they are larger than the allowed image/file size.?

 

This feature is on request with the Shop Builder Advanced package. If you are interested in having this feature added to your account please contact your Account Manager who would be happy to add this for you.

Please note: We cannot offer support should you experience any malfunction caused by incorrect use of this feature. In addition we may not be able to retrieve any information lost and revert any changes made. Because of this we strongly recommend an unedited version of your file is saved each time to help should any mishap occur.