Skip to content
Last update: January 29, 2025

Import Products, Prices and Stock Quantities from CSV

To bulk add new products, along with their prices and stock quantities at each fulfillment center, you can use the CSV file import option.

Note

Importing products to catalogs requires the preinstalled Catalog CSV Import module.

Importing information from a CSV file includes the following steps:

  1. Preparing a CSV file.
  2. Importing your CSV file to catalog.

Prepare CSV file

Let's create a CSV file containing all the necessary columns, i.e., product name, Id, SKU, price, price list Id, etc. To create a new catalog within this guide, we will download this sample file to use as a template.

  1. Fill in the products names and SKUs.

  2. Go to PricingPrice lists to copy the Id of the price list to clipboard:

    Copy pricelist Id

    Note

    If not set by default, you can find the Price list Id column by clicking the hamburger menu in the top right corner and then checking Id:

    Finding price list Id

    Paste the copied price list Id to the PriceListId column.

    Paste pricelist Id

  3. Fill the CategoryPath column to specify the product's separate category in a catalog as follows:

    Category path

    Note

    You can create categories and subcategories from the CSV file. You will need to add the names of categories (for example, Сategory 1) and subcategories (for example, Сategory 1/Subcategory 1). In our example, we use our manually created structure.

    Note

    If you import new products from a file without specifying either the category id or the category path, the default is the root directory - the catalog.

  4. Go to Catalog → Your catalog to copy the category Id by right-clicking:

    Category ID

    Paste it to the CategoryID column:

    Category ID column

  5. Go to Inventory to copy the fulfillment center ID:

    FFC ID

    Paste it to the FulfillmentCenterId column:

    Fulfillment center

    You may also specify quantities in stock in the Quantity column.

  6. Fill the PrimaryImage column with links to images to provide a product's image.

  7. Specify ListPrice to display regular product price.

Filling in the above columns is sufficient to start the import, but you can fill in other columns according to your needs.

Import CSV file to catalog

To import your CSV to your catalog:

  1. Click Catalog in the main menu.
  2. In the next blade, select your catalog.
  3. Click Import in the top toolbar.
  4. In the next blade, click VirtoCommerce CSV import.
  5. In the next blade:
    1. Select Comma as a delimiter from the dropdown list.
    2. Upload your CSV file.
    3. Click Map columns.
  6. In the next blade, check that the product properties are correctly mapped to the CSV columns. Click OK.
  7. In the Import catalog from csv blade, click Start import.

The catalog import begins. When the import is finished, you can see that your catalog is filled with products. Each product has a complete description:

Correct products

View results on frontend

  1. In the main menu, click Stores.
  2. In the next blade, click on the required store (Dental Demo Store in our case).
  3. In the next blade, click Open in browser in the top toolbar.

View result

The CSV file columns are displayed as follows:

CSV file and frontend correspondence