1. Home
  2. Knowledge Base
  3. Inventory
  4. Importing Products with CSV file

Importing Products with CSV file

Importing products into your account using comma-separated values (CSV) files is useful when you need to create multiple products. This feature is also useful when switching from another platform, as it allows you to import all active products at once.

When you import products, the data is converted from the CSV file into products under Inventory.

Steps

  • From your admin account, go to Products under the Inventory module
  • Click the three dots (…) in the top-right corner
  • Select Import Products
  • Then, select Import Products from a CSV file
  • And hit, Next

Tip: We recommend using Google Sheets to handle CSV files.

You can refer to this link if you want to Import Products from your Shopify Store

  • To get started, download our spreadsheet template file and fill it up with your products and variants information, including product name, description, options, variants, their different prices, and much more. 
  • Once you made the desired changes to the spreadsheet file, click next and you will be able to upload your products into Qoblex.

Your product CSV can’t exceed 2MB. Consider splitting your CSV files into multiple chunks if you have a large number of products to import.

If you have a CSV file that was exported from another inventory management software or came from another source, make sure it matches the CSV file format. If the format doesn’t match, or if there are any missing headers, then the import fails.

CSV File Format

ColumnDescription
Product NameA name given to a particular product that identifies it uniquely from other products in the same category.
Product DescriptionA description of the features, benefits, and specifications of a product that helps customers understand what the product is, how it works, and what it can do for them.
SupplierThis is where you purchase your products to increase your stock levels.
Tax nameThe name of a tax that is applied to a product or service, such as a sales tax or value-added tax (VAT).
Option 1-3 Values
Variant SKUA unique identifier assigned to a specific variant of a product, which helps to differentiate it from other variants of the same product.
Supplier SKUA unique identifier assigned by the supplier to a specific product that helps to track and manage inventory.
Barcode (ISBN, UPC, GTIN, etc.)Barcodes are typically used by resellers. The identifier needs to be a new or existing Global Trade Item Number (GTIN). Some sales channels require a GTIN before a product can be published using the channel. GTINs are unique identifiers used internationally to store and locate product information. UPC, EAN, and ISBN numbers are examples of GTINs, which might vary in length depending on the product type. You can find the GTIN above or below the barcode on the packaging for your product.
WholesaleThe price that a retailer pays to a supplier for a product, which is usually lower than the retail price.

Similar to the retail price. These fields are optional and are applicable only when you have a wholesale business
Wholesale compare priceThe price at which the product is being offered by other suppliers or retailers.
Retail priceThe retail price that you’re charging for the product. The retail price is expressed in your base currency.
Retail compare priceThe original price for a product that is on sale. When you enter a compare at price, the product displays a sale price. The compare at price is only applicable when you have an integration with a sale channel such as Shopify.
Buy price /Purchase priceHow much your supplier charges you for the product or variant excluding tax, shipping, or other costs.
Initial costThe cost you incur to acquire a product, including the cost of goods, shipping, and any other associated fees.
WeightThe physical weight of a product.
TagsKeywords or phrases that are used to describe a product, which helps customers find it more easily when searching online.
Product TypeThe category or classification of a product based on its attributes and features.
BrandThe name or symbol that identifies a product or company.
URLThe web address or link to direct users to your store

Was this article helpful?

Related Articles