Last update: July 16, 2024

Import Products, Prices, and Stock Quantities to Catalog via CSV File

To efficiently 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.

Follow this step-by-step guide to learn how to import new products into the Virto Commerce Platform catalog (backend) and display them on the Virto Commerce Frontend Application:

1. Create a new price list. New-price-list in our example.

2. Copy the Id of the created price list to clipboard. c801f074-b9d3-4662-8978-845c8b0d75ca in our example.

   

3. Create a CSV file containing all the necessary fields, i.e., product name, Id, SKU, price, price list Id, etc. To create a new catalog, you can export a catalog in a CSV format or download this sample file to use as a template.

   Tip

   Add a CategoryPath field to specify the product's separate category in a catalog.
   Provide Quantity and FulfillmentCenterId fields to specify a quantity at a specific fulfillment center.
   Fill the PrimaryImage field with links to images to provide a product's image.

4. Paste the copied price list Id to the PriceListId field.

   

5. Create a new catalog (New_catalog in our example) and add a new category into it (New_category in our example).

   

6. Fill the catalog with information by importing your CSV file into it.

   

7. Link your catalog to the catalog of the store. As long as the store displays only one catalog, linking new catalogs to the one displayed is the best way to extend the displayed assortment:

   1. In the main menu, click Catalog.
   2. In the next blade, select the required Catalog. B2B-mixed in our example.
   3. In the next blade, click Add in the top toolbar.
   4. In the next blade, select Link.

   5. In the next blade, select the newly created catalog. New-catalog in our example.

      

   6. In the next blade, check the category. New-category in our example.

   7. Click Map in the top toolbar.

      

   In the Categories and Items blade, you will see that the required category has been linked to the catalog:

   

8. Create a price list assignment to connect to the price list (New-price-list in our example) to the catalog displayed in the Frontend Application (B2B-mixed in our example):

   1. In the main menu, click Pricing.
   2. In the next blade, click Price Lists.
   3. In the next blade, select the required price list (New-price-list in our example).
   4. In the next blade, click on the Assignments widget.

   5. In the next blade, click Add in the top toolbar.

      

   6. In the next blade, fill in at least the following fields:

      1. Specify the assignment name.
      2. Select a price list from the dropdown list (New-price-list in our example).
      3. Select a catalog from the dropdown list (B2B-mixed in our example).
      4. Click Create.

      

   Your new assignment appears:

   

9. Fill the price list with the items from your newly created catalog:

   1. Click on the Prices widget.
   2. In the next blade, click Add in the top toolbar.
   3. In the next blade, select the required catalog (New-catalog in our example.)
   4. In the next blade, select the category (New-category in our example).
   5. In the next blade, check the items to add to the price list.

   6. Click Add selected in the top toolbar. You might need to repeat it several times if the items are located on more the one page.

      

10. Check SEO Settings of your catalog (Catalog → Your catalog (New-catalog) → New category → SEO widget → Your category (New-category)). Make sure your catalog has a unique URL slug and is assigned to the proper store:

    

11. View the results in the frontend environment:

    1. In the main menu, click Stores.
    2. In the next blade, click on the required store (B2B-Store in our example).

    3. In the next blade, click Open in browser in the top toolbar.

       

    The frontend environment opens in a new window with the /new-category URL slug. The image below shows what it looks like and how it correlates to the columns in the CSV file: