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:
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.
-
Fill in the products names and SKUs.
-
Go to Pricing → Price lists to copy the Id of the price list to clipboard:
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:
Paste the copied price list Id to the PriceListId column.
-
Fill the CategoryPath column to specify the product's separate category in a catalog as follows:
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.
-
Go to Catalog → Your catalog to copy the category Id by right-clicking:
Paste it to the CategoryID column:
-
Go to Inventory to copy the fulfillment center ID:
Paste it to the FulfillmentCenterId column:
You may also specify quantities in stock in the Quantity column.
-
Fill the PrimaryImage column with links to images to provide a product's image.
- 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:
- Click Catalog in the main menu.
- In the next blade, select your catalog.
- Click Import in the top toolbar.
- In the next blade, click VirtoCommerce CSV import.
- In the next blade:
- Select Comma as a delimiter from the dropdown list.
- Upload your CSV file.
- Click Map columns.
- In the next blade, check that the product properties are correctly mapped to the CSV columns. Click OK.
- 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:
View results on frontend¶
- In the main menu, click Stores.
- In the next blade, click on the required store (Dental Demo Store in our case).
- In the next blade, click Open in browser in the top toolbar.
The CSV file columns are displayed as follows: