Migrating data from other E-comm Platforms to Instamojo Online store

The Following Migration document will help you migrate the following data to your Store 

  1. Products data

  2. Customers data 

Don't want to spend time adding products one by one? No problem, use our batch product uploader feature to upload multiple products in one go.

Follow the below simple steps to Bulk Import product data.

From the left panel in your dashboard select Online store -> Products -> select Bulk Import icon on the Toolbar

Note: Upload an excel file of max size 20 MB and save it as product.xls. Only Excel and CSV files are supported. 

Check for your product details and organize the data into columns which include Product images, Product descriptions, categories, and variants in a CSV file. 

Follow the sample file to see exactly how we organize data.  Download the file.

You can import products with variants and without variants. Excel sheet Format is different for products with Variants and Products without Variants.

Products with Variants: Use this format when your products have more than one variant. For example, If you are selling clothing items and the product range has different sizes and colors. 

Products without Variants: Use this format when your products do not have any variants. For example, if you sell books that do not have different categories/subjects.

Note:  You can only add up to a maximum of 500 variants for each product for a smoother flow. 

Import your products file to the store after organizing the data in the file. 

If there is an error while uploading the file the errors are highlighted on the product batch uploader page. If the Error still exists, drop an email to support@instamojo.com with a screenshot of the error.

Dropbox Folder 

You can also share the URL of a  dropbox folder from which image files can be downloaded. 

Here’s how you can use dropbox folder to Upload Product Images in Bulk

Create an account on www.dropbox.com. Ignore if you already have one. 

Log in and select the ‘upload folder’ option, and select the folder from your desktop which has the product images. 

Select the ‘share’ option, copy the folder link, and paste it into the dropbox link column in the store dashboard’s Batch product uploader page.

Note: Image names in the dropbox folder should match with the image names that you have entered in the import excel sheet.

You will receive a confirmation email to your registered email address after the CSV is successfully uploaded.

Bulk Edit Products Data

Here's how you can Bulk Edit the Products data

From the left panel in your dashboard select Online store -> All products -> Manage products page -> select Bulk Edit icon on the Toolbar

Points to remember while Editing the Excel File

  1. To remove attribute values, fill the cell with - :delete: (colon included).
  2. To remove an image, clear the corresponding cell of any value (do not delete the cell).
  3. If you need to edit only a few products, you can safely delete the ones that don't need updating.
  4. Make sure that you do not remove the base product of a variant (First row starting with the same value in the first column), if editing a variant.
  5. You can add more attributes by adding the attribute headings (in "group-name:key-name" format) after the last column heading and filling their corresponding cells for the product.

Import Customers data to your Online Store

Here's how you can Import Customers data in Bulk 

From the left panel in your dashboard select Online store -> Customers -> Select Bulk Import icon on the Toolbar

Here is the Sample excel file format to upload customer profiles data. Download the sample file 

Import your products file to the store after organizing the data in the file.

If there is an error while uploading the file errors are highlighted on the product batch uploader page. If the error still exists, drop an email to support@instamojo.com with a screenshot of the Error.

How to Bulk Edit Customers Profile data 

Here's how you can edit the customer's data in Bulk

From the left panel in your dashboard select Online store -> Customers -> All customers  -> Select Bulk Edit Icon on the Toolbar

  1. Select the Profile type as registered or guest users 
  2. Select tags if you have created any
  3. The default columns in the excel should be email, first name, last name, sex, birthday, anniversary, contact, etc as shown in the above screenshot.
  4. Select the date range of the customers created (such as last 30 days etc)
  5. Upload the modified sheet back again through the ‘Upload’ option.

 

 

 

Start Exploring
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request