One of the most challenging stages in setting up a webStore is adding products in a robust, quick and effective manner. This can be achieved using webShaper’s import tool which allows multiple products to be added in a go.

 

Note: Getting your Products Sorted and Adding your Product Information are prerequisites for the bulk upload, please make sure you complete these before you proceed onto the steps for bulk upload. To know how to work with your images, go to Step 2.

 

Getting your Products Sorted

 

1. Under Products, on your Dashboard you will find Import/Export.

 

productCatalogManager

In the dashboard, under Products, you will see Import/Export.

2. Download the sample under Import Products and get the excel file sample. Open this downloaded .xsl file in your Microsoft Excel.

Adding your Product Information

1. Feel free to manipulate the file and insert your own product information. After you have inserted your own information you will have to upload the file as demonstrated in step 1.

 

excel

 

The mandatory fields for New Product Upload  are:

  • SKU (your product SKU, this uniquely identifies your product)
  • Product Name (your product name; e.g iPhone 5)
  • Product Item: (your product item; e.g iPhone. (This is a mandatory field if this is a sub product item, meaning you cannot leave this field blank if this is a sub product item))
  • Stock: (your stock quantity)
  • Weight: (your product weight in kilograms (kg))
  • Product Type: (your product type)
  • Active (your product’s status. If ‘yes’, this product will appear on your website. If ‘no’, this product will be hidden on your website.)
  • Price (amount that your customer pays for this product)
  • category level: (your product’s main category)

The mandatory fields for Updating Products are:

  • SKU (your product SKU, this uniquely identifies your product)
  • Active (your product’s status. If ‘yes’, this product will appear on your website. If ‘no’, this product will be hidden on your website.)
  • Parent SKU: (if this product is a sub product item, please enter parent SKU)
  • Product Item: (your product item; e.g iPhone. (This is a mandatory field if this is a sub product item, meaning you cannot leave this field blank if this is a sub product item))

Note:

i. Products with two options must be in different excel sheet, to separate out the ones with one option. So if you have only one product option, as example Colour, then you need to remove ‘Option 2’, ‘Attribute 2’.

ii. We have added more columns for your benefit. Feel free to add more options as you desire. There is a list of options provided and what each option does, follow the link to know more.

 

2.  Save your .xls file

 

saved excel

Save your Excel file with the changes made, ready for uploading.

 

Step 1: Import Products

1. Click on Import Products.

 

StepOne

Here, upload your Excel File, and select Excel as the format

 

2. Select your excel file with all the product information and select Excel for Type.
3. Add New Products (if you are adding in new products to your online store) or Update Products (if you are updating your products).

Step 2: Adding Images

Note that there are two ways to add images to your product:

a) Drag and Drop

Drag and drop your product images into the image gallery.

 

Dragging

 

Note: If you have uploaded your product images via image gallery, then delete the productPictureSmallproductPictureNormal and  productPictureRaw fields from your excel file. 
productPictureRaw: is your product image name and file type; e.g iPhone5_black.jpg (this only applicable for product images uploaded via image gallery). You can learn how to upload products via image gallery.

 

To successfully upload your images into the system, you must make sure that the field in your excel file is named correctly as productPictureRaw. A green tick will appear on the top left of your picture showing that it has been uploaded without any issues.

 

draganddroptick

 

b) Using the Image Manager

You may upload the photos via the Image Manager. Products –> Image Manager –> Upload Images. 

If you are uploading your products via the Image Manager, you must do it before you add your excel file, so the pictures and the data correspond. An example is shown to aid you.

 

picturesinexcel

An example of Image Names in Excel.

 

Note: It is recommended that you create a new folder before uploading your pictures. You will have to add your pictures in the following manner :

folder-name/normal/picture.png . You can put this in your excel file accordingly.

ImageManager

Using the Image Manager.

 

Step 3: Viewing your Products

1. Your products have to now be inserted into the system. Note that your field names may not map exactly onto each other. Check to see if they correspond correctly by comparing the fields.
2.Proceed to the last step of bulk upload, click next.

 

StepThree

Here you can see the details of your Excel File.

 

3. You are almost done! You can also check whether your products have been uploaded successfully into the system. Click on View Log/Previous File Uploaded under Import/Export.

 

SuccessfulImport

Your successfully added products will be shown to you.

 

Important: The webShaper system can support up to 99 products in a single upload but this is not advisable as it might slow down the bulk upload process.