1. Home
  2. Marketplace
  3. How To Bulk Upload Product In Stormerce

How To Bulk Upload Product In Stormerce

Step 1: From your admin dashboard, go to “Marketplace” and click on “Bulk upload Dataflow profile” to create a dataflow profile.

A page will generate as shown below:

dataflow profile

Step 2: After the profile has been created click on the “Bulk upload product”. Enter the respective information as required and then click the save button.

A page will generate as shown below:

bulk upload product in stormerce

DOWNLOAD SAMPLE SECTION:-

DOWNLOAD SAMPLE SECTION

Under this section, you can download the sample of CSV/XLS files for both simple and configurable products and can further edit it.

After downloading the CSV/XLS sample files you can edit the files according to the products. And can also upload as many numbers of the product.

After editing save the file to the desired location.

Let’s take an example to upload the Simple products and Configurable products through XLS and CSV files.

For Simple products:-

After downloading the sample for the simple product the CSV/XLS file contains several fields as shown in the image below:-

xsl bulk upload file format

You need to fill all the fields regarding the product such as:-

Category slug:- Enter the slug of the category for the products.

Name:- Enter the name for the product.

Description:-Enter the Description of the product.

Short Description:- Enter the short description regarding the product.

SKU:- Enter the SKU for the products.

Price:- Enter the price of the products.

Special Price:-  Enter the special price for the products if required.

Special Price From :-  Enter the beginning date for the special price regarding the products.

Special Price To :-  Enter the end date for the special price regarding the products.

Inventories:- Set the number of products across each inventory in this field.

Weight:- Enter the weight for the simple products.

Enter the meta title, meta keywords, and meta description regarding the products in their respective fields.

Size:- Enter the size of the products if available.

Url Key:- Enter the Url key regarding the products.

Tax Category ID:- Enter the tax category ID in this field.

New:- Enter new product set it as 1 otherwise 0.

Featured:- Enter featured products set it as 1 otherwise 0.

Visible individually:- Set it as 1 or 0 according to the requirements.

Status:- Enable the status as active by setting as 1 otherwise 0.

Cost:- Enter the cost if required.

Enter the width, height, and depth regarding the simple products.

Type:- Select Simple for simple products.

Attribute family:- Enter the attribute family that has been created or selects as default.

Images:- Enter the image’s name regarding the products.

Guest Checkout:- Set it as 1 to enable product for guest checkout otherwise set it as 0.

Save the file to the desired location.

For Configurable products:-

The process to upload the configurable products is the same as the simple products but there are some additional fields also for the configurable products as described below:-

xsl format for bulk upload product

Super Attributes:- Set the attributes in this field according to the requirements and can separate them by comma(,).

Super Attribute Option:- Set the attribute options according to the attributes that have been selected by the admin.

Set the super attribute price according to the super attribute option.

Super Attribute Quantity:- Set the quantity for each variant of the product,

Super Attribute Weight:- Set the weight for each variant of the product.

All the remaining fields are the same as the simple products as described above for the simple products.

After filling all these fields regarding the configurable products save the file to the desired location.

Note**:- For the images save all the images regarding the products in a separate zip folder to upload images in bulk for the products.

The name of the images for each product should be the same in the CSV/XLS file also.

IMPORT PRODUCT SECTION:-

import upload

Under this section, there are several fields as described below.

  • Set Seller:- In this field, you select the seller to whom the admin wants to assign the products.
  • Attribute Family:- You select attribute family in this field.
  • Data Flow Profile:- In this field, you select the profile that has been created before.
  • CSV/XLS File:- Under this field, you can upload the CSV/XLS file for the uploading of the product in bulk quantity.
  • Image Zip file:- In this field, you can upload the images regarding the products in Zip format.

Step 3: Click on the “run profile” tab to run the profile

run profile for bulk upload of product in stormerce

Select File:- In this field, you select the dataflow profile that has been created for the bulk product.

Then, click on Run.

Now the bulk products have been uploaded successfully to your store.

MARKETPLACE BULK UPLOAD PRODUCT FOR SELLERS:-

The seller can also upload products in bulk with the help of this feature can see the options of Bulk upload on the profile page as shown below:-

sellers bulkupload product

Firstly the seller needs to create the Dataflow Profile and need to select the associated attribute family, by navigating to Bulk upload Dataflow profile a page will generate that will look like shown below.

dataflow profile update

After the profile has been created click on Bulkupload product that in which there are two sections.

Download Sample:- under this section the seller can download the sample of CSV/XLS files for both simple and configurable products and can further edit it.

Import Products:-Under this section there are several fields as described below.

  • Attribute Family:- The attribute family can be selected in this field.
  • Data Flow Profile:- In this field, the seller can select the profile that has been created before.
  • CSV/XLS File:- Under this field, the seller can upload the CSV/XLS file for the uploading of the product in bulk quantity.
  • Image Zip file:- In this field, the seller can upload the images regarding the products in Zip format.

bulk upload

Click on upload button.

Now the next step is to Run the profile  by selecting the created profile.

Select File:- In this field, the seller can select the profile that has been created from the dropdown.

run the profile now

 

Click on Run.

Now the bulk products have been uploaded successfully to the store from the seller’s end.

Updated on September 17, 2020

Was this article helpful?

Related Articles