Add Multiple Products Using Excel File

Table of Contents

In case you have many products that need to be added to the Omisell system, using Excel files will save you a lot of time and effort in data entry.

Follow the instructions below:

Go to “Inventory”, click “New product” and select “Import products (Excel)”.

In the new window, download the Excel template file to fill in the product information.

  • How to fill in the Excel template:
  • Product name
  • Category: Product category (Refer to the Category sheet in the template)
  • Product type: Physical or Digital
  • Variant name: Specific details like specifications, sizes or colors
  • Description: Detailed product description (Usually requires at least 100 characters to be listed on the e-commerce platform)
  • Option 1 / Option 2 / Option 3: Type of goods classification (by color, size, volume, …)

Option 1 Value / Option 2 Value / Option 1 Value: Value according to the specific classification of the product. (Example: If “Attribute 1” is color, “Attribute value 1” will be the color of the product to be specified as black/red/white, …).

_Note that each “Attribute value” must be displayed separately on a separate line, not on a single line. For example, Product A has 2 color attributes: black and white, when shown on the excel file, it should be entered into 2 separate lines and distinguished by the “attribute value” in black or white.

  • EAN / UPC / BARCODE: Product management barcode (optional)
  • SKU: The product barcode set by the store owner
  • Weight: Weight of the product
  • Dimension: The size of the product packaging (Width x Length x Height)
  • Price: Product price
  • Sale price: Product price after discount (optional)
  • Image 1 URL / Image 2 URL / Image 3 URL: Link to detailed product pictures

After finishing the excel file, add the product according to the model, drag the newly created file to the file upload section and select “Import file”. After adding an excel file, a product will be notified by a listing.

Omisell is currently partners with more than 1,000 retailers, processing more than 20,000 orders with over 300,000 products every day with Southeast Asia’s largest e-commerce platforms like Lazada, Shopee, Shopify, etc. We operate in 5 SEA countries: Vietnam, Philippines, Indonesia, Thailand and Malaysia.

Want Omisell to help you improve sales and reduce operating costs?

Contact Sales

Contact us for a free consultation
and increase sales​

- Contact Us

Get Started

Sign up for free and experience
all the features of Omisell

- Get a free trial account

Related Posts

Set up your Omisell account

Personal information settings After logging in to Omisell, you need to set up personal information to be able to use the features on the system.

Read More »

Benefits of using Omisell

Sales management software is no longer a strange phrase for business owners, especially in the era where online sales are booming like today. Having sales

Read More »