Back to Top

Magento 2 Multi Vendor Mass Upload

Updated 17 April 2024

Magento 2 Mass upload marketplace add-on allows the sellers to add products to the store using CSV/XLS/XML files. The mass upload marketplace add-on supports simple, configurable, virtual, and downloadable types of products.

Mention all the details such as name, category, price, stock, description, tax, etc. in the file including the images. The admin can also upload the products for the seller from the back-end.

Note:

  • To make this module work you will be using Webkul’s Magento 2 Multi Vendor Module module.
  • In Magento 2 root, run this command –composer require phpoffice/phpspreadsheet.
  • For uploading products with custom attributes, you need to install Custom Attribute Marketplace Add-On
  • For uploading products with custom options, you need to install Custom Option Marketplace Add-On
  • If you want to upload mass products with custom attributes and options then you can check here.
  • It is compatible with Adobe Commerce Cloud as well. 

Watch the video to understand the plugin workflow:-

Magento 2 Multi-Vendor Mass Upload Add-On- Simple Product

zn91D1X1obo

Magento 2 Multi-Vendor Mass Upload Add-On- Configurable  Product

5YS6b-g9k1w

Features

  • Upload multiple product images using the images zip file and also through image links ( Publicly Hosted Image URL ).
  • Works with simple, configurable, downloadable, virtual product types.
  • Mass Upload Profile Listing Option is available at the seller end to manage the profiles which are not executed successfully.
  • Download sample CSV/XLS/XML files for every product type.
  • Mass upload related, cross-sale, and up-sale products through the supported files.
  • Export existing product data using the CSV file.
  • The admin will be able to export the products based on sellers.
  • Dataflow profile for mapping the product attributes correctly.
  • Add any number of products, there is no limitation.
  • The admin can do mass product upload for the sellers.
  • Mass upload is compatible with multi-store.
  • View product upload process result to view any errors.
  • Add a product in various categories or subcategories.
  • It supports many language translations.
  • The module source code is open for customization.
  • The extension is compatible with GraphQL as well.
  • This extension is compatible with the  HYVA theme as well.

Note – If you want to sell your products on various platforms like CS-Cart then you can use our Magento 2 CS-Cart Connector extension for the same.

Installation

Customers will get a zip folder and they have to extract the contents of this zip folder on their system.

Searching for an experienced
Magento 2 Company ?
Find out More

The extracted folder has an src folder, inside the src folder you have the app folder. You need to transfer this app folder into the Magento 2 root directory on the server as shown below.

Installation Of Marketplace Mass Upload for Magento2

After the successful installation, you have to run the below-mentioned commands in the Magento 2 (Adobe Commerce) root directory.

First Command – 

composer require phpoffice/phpspreadsheet

Second Command – 

php bin/magento setup:upgrade

Third Command – 

php bin/magento setup:di:compile

Fourth Command – 

php bin/magento setup:static-content:deploy

After running the commands, you have to flush the cache from Magento (Adobe Commerce) admin panel by navigating through->System->Cache management as shown below.

Installation Of Marketplace Mass Upload for Magento2

Multi-lingual Support

For the multilingual support, the admin will navigate through Store->Configuration->General ->Locale Options and select the locale as German (the language into which admin wants to translate his store content).

Configuration For Multilingual Support

Translation

If a user wants to translate their module from English to German then they need to follow the path app/code/Webkul/MpMassUpload/i18n in their unzipped Magento 2 MpMassUpload folder and will get a CSV file with the name “en_US.csv”.

Now they will rename that CSV as “de_DE.csv” and translate all right side content after the comma in the German language.

After editing the CSV, save it and then upload it to the path app/code/Webkul/MpMassUpload/i18n where they have installed Magento 2 (Adobe Commerce)  on the server. The module will get translated into the German Language. It supports both RTL and LTR languages.

Marketplace Mass Upload for Magento2 Translation
Marketplace Mass Upload for Magento2 Translation

The user can edit the CSV like the image below.
Marketplace Mass Upload for Magento2 Translation

Admin Panel Configuration

Please note that the sellers can only mass upload those product types which have been selected by the admin from the backend panel configuration.

For selecting the product type for the seller, please go to Stores>Configuration>Marketplace>Seller Product’s Settings>Product Type For Seller and select the product types for the sellers that they can add to their catalog.

The sellers can mass upload simple, downloadable, virtual, and configurable products as selected by the admin.

webkul-marketplace-mass-upload-product-type

Seller Management

After the installation of Marketplace Mass Upload for Magento 2 module, the seller can find an option called “Mass Upload Product”. On clicking on that option, the seller will be re-directed to a new page as seen in the screenshot below: webkul-magento2-marketplace-mapp-upload-seller-mass-upload-product-1

If the seller select “Is Downloadable” checkbox then there will an additional “Upload link files zip” option with two other options i.e. Is Links have samples and Is Samples Available will appear.

webkul-magento2-marketplace-mapp-upload-seller-mass-upload-product-zip-link-1

Now if the seller checks the Is Links have samples checkbox then additional “Upload Link sample files zip” option will appear.

webkul-magento2-marketplace-mapp-upload-seller-mass-upload-product-zip-link-3

& if the seller checks the Is Samples Available checkbox then additional “Upload samples file zip” option will appear.

webkul-magento2-marketplace-mapp-upload-seller-mass-upload-product-zip-link-2

Now we will see how to upload products through CSV.

Uploading Simple Products

The sellers will be able to mass upload the products using three types of file types – CSV, XLS, and XML. The seller will select the attribute set, upload the CSV file and images zip files, and then click on the Upload Profile button. You can see below.

upload-profile

Further, a success message will appear as “Your file was uploaded and unpacked”. After that, the seller will select that profile and then click on the “Run Profile” option. You can see the screenshot for the same.screencapture_devmage_11825_mpmassupload_product_view_2020_05_28_12_38_53

Please check the CSV file for the simple products.

webkul-magento2-marketplace-mapp-upload-seller-simple-product-csv

webkul-magento2-marketplace-mapp-upload-seller-simple-product-csv-1

Also while editing the CSV File, now the seller can also use external image links for a product. For this only the image link needs to be entered under the Images field.

When profile run will be successful then you can see this message:

webkul-marketplace-mass-upload-run-profile

Now the seller can see the uploaded products under the option called “My Product List”.

simple-products

Example 1 Using CSV File:

After creating the CSV file for upload you can easily assign the products to the various categories and their sub-categories as well.

Below you can see a sample simple CSV file that has some products in it and we are assigning these products to the electronics category that has two more sub-categories computers and cameras.

webkul-marketplace-mass-upload-simple-csv-file

  1. For assigning the product only to the main category, under the category column directly write – Electronics
  2. For assigning the product only to the first sub-category of the main category, write – Electronics>>Cameras
  3. Now, for assigning the product only to the 2nd sub-category of the main category, write – Electronics>>Computers
  4. If you want to assign a product to the first and second category of the main category write –
    Electronics>>Computers,Electronics>>Cameras
  5. If you want to assign a product into different sub-categories write – Electronics>>Computers, Footwear>>Stilettos

Example 2 Using XML :

After creating the XML file for upload you can easily assign the products to the various categories and their sub-categories as well.

Below you can see a sample simple XML file that has a product in it and we are assigning this product to the electronics category that has two more sub-categories computers and cameras.

webkul-marketplace-mass-upload-xml-file

  1. For assigning the product only to the main category, within the category tag directly write – Electronics
  2. For assigning the product only to the first sub-category of the main category, within the category tag write – Electronics>>Cameras
  3. Now, for assigning the product only to the 2nd sub-category of the main category, within the category tag write –Electronics>>Computers
  4. If you want to assign a product to the first and second category of the main category, within the category tag write –
    Electronics>>Computers,Electronics>>Cameras
  5. If you want to assign a product into different sub-categories, within the category tag write – Electronics>>Computers, Footwear>>Stilettos

Uploading Configurable Products

Sellers will be able to mass upload the products using three types of file types – CSV, XLS, and XML. The seller will select the attribute set, upload the CSV file and images zip file and then click on the upload products as shown in the image below.Marketplace-Mass-Upload-8

Sellers can see the available configurable super attributes and view the options from the drop-down.

After this, a profile will be created as shown in the screen below. Seller will select that profile and then click on the “Run Profile” button.Marketplace-Mass-Upload-11

In the CSV file, the seller will also include the associated products along with the configurable products as shown in the screenshot below.

It is important to note that, parent configurable product will not upload if any of its associated products already exist in the Marketplace.

Confi-csv-1

You can also see the message when the profile runs successfully.

webkul-marketplace-mass-upload-run-profileNow the seller can see the uploaded Configurable products under the option called “My Product List”.

configurable product

Uploading Virtual Products

The sellers will be able to mass upload the products using three types of file types – CSV, XLS, and XML.

For uploading the virtual product, the seller will select the attribute set, upload the CSV file and images zip files and then click on the upload products button.

uploading simAfter this, a profile will be created like the screen below. Seller will select that profile and then click on the “Run Profile” button.

Marketplace-Mass-Upload-9

When the profile runs successfully, you can see the message.

webkul-marketplace-mass-upload-run-profilePlease check the CSV file for uploading Virtual products. Here, the seller will enter all the details regarding the products expect the weight.

virtual-csv-2

Now the seller can see the uploaded products under the option called “My Product List”.

virtual

Uploading Downloadable Products

For uploading the downloadable product, the seller will first tick the checkbox for the downloadable product and then the seller will then select the attribute set, upload the CSV file and images zip files, and then click on the Upload profile button.

webkul-magento2-marketplace-mapp-upload-seller-mass-upload-

Please note that, for uploading the link file for the downloadable products, the seller will compress each link files separately and then copy them into another zip folder.

In the CSV, the seller will enter the name of the zip link for each downloadable product and then upload it.

After this, a profile will be created as shown in the screen below. The seller has to click on the checkbox for mass upload for downloadable products and will select that profile and then click on the “Run Profile” option. You can see the screenshot for the same.webkul-magento2-marketplace-mapp-upload-seller-mass-run

Please check the CSV file for uploading the downloadable products. In the CSV file, the seller will also include the link file, link type as shown in the screenshot below.

webkul-magento2-marketplace-mapp-upload-seller-downloadable-product-csv-1

webkul-magento2-marketplace-mapp-upload-seller-downloadable-product-csv-2

webkul-magento2-marketplace-mapp-upload-seller-downloadable-product-csv-3

When the profile runs successfully then you will see this message.

webkul-marketplace-mass-upload-run-profileNow the seller can see the uploaded products under the option called “My Product List”.

Downloadable-1

Note:

If there is an error in the CSV file then you will get an error message and products will not be uploaded. By this error detection technique, the uploader can see the error and can rectify those errors. The product will not be uploaded if there is an error. So this module provides 100% error-free mass upload. You can see a few of the error messages below.
webkul-marketplace-mass-upload-run-profile

Mass Upload Dataflow profile

Mass Upload Dataflow profile: It is a column mapping feature that allows you to keep other names of the columns in your CSV file, you just have to link them to the appropriate database fields.

The sellers will navigate to the “Mass Upload DataFlow Profile” menu option under the “Marketplace” block. Here the seller can create data flow profiles as per need.

Upload-dataflow

To create a data flow profile, enter the name for the profile first, then select the attribute set for which it will be applicable. Now, click the “Save Profile” button to save the profile.

Create-Profile

After clicking the “Save Profile” button, you will have to do the field mapping i.e you will have to set the In file name for the corresponding database entries.

Mapping
After this, the seller will find the CSV file with these in file names in place of the database names as shown below in the snapshot.
In-File-Name-Changed-CSV

MassUpload Product Export

Under this section, the sellers can export their products into the CSV file format. The sellers can also select the Custom Attributes to export in the file. To export the products, the seller will go to the Mass Upload Product Export section as shown below.

Product-Export

The sellers can find here all the custom attributes that are available.

The seller will first select the product type (Simple, Configurable, Downloadable, and Virtual) to export, then select the custom attributes to export in the file. lastly, click the Export button to export the products to the CSV file.

Product-Export-1-1

After clicking the export button, the CSV file will get downloaded with the selected custom attributes as shown below in the snapshot.

webkul-marketplace-mass-upload-product-CSV

Mass Upload Profile Listing

In case any profile not getting executed successfully or the seller doesn’t want to run a particular profile than for deleting that profile sellers can use the Mass Upload Profile Listing option.

profile-listing

Admin Management

The Admin can also mass upload the products for individual Seller. Under Marketplace Management > Mass Upload Manager

magento-marketplace-admin

From the backend, admin can upload any product (simple, virtual, downloadable, configurable).

The admin will upload the CSV file and Image ZIP file for the mass upload of products. The seller has to click on the checkbox for the mass upload of downloadable.

Manage Mass Upload Mass Upload Manager Marketplace Management Magento Admin (1)

After uploading the CSV and Image ZIP, the admin will see the success message as per the below image.

Manage Mass Upload Mass Upload Manager Marketplace Management Magento Admin

Now, the admin will go to “Run Mass Upload Profile”, and select the seller for whom he wants to upload the products in mass.

webkul-marketplace-mass-upload-run-profile

You can also see Profiler running and executing like in the image shown below.

webkul-marketplace-mass-upload-run-profileNow, the admin can see the uploaded products under Marketplace Management->Manage Product section.

webkul-magento2-marketplace-mass-upload-admin-manage-product

Import Product for Multiple Sellers

Also, after the upload and unpacking of the file, click on “Import product for multiple Seller(s)”

import

In the CSV file, the admin needs to provide the seller id to which seller they want to assign a product.

Screenshot-from-2022-06-17-15-32-08-1

The admin will be redirected to Manage Mass Upload page.

run

Store– Here the admin needs to select the store.

Select Profile– The need to select the seller profile.

After that click on the Run Profile tab, which will begin the uploading process.

level

Mass Upload Dataflow Profile

MassUpload Dataflow Profile:  It is a column mapping feature that allows you to keep other names of the columns in your CSV file, you just have to link them to the appropriate database fields.

To add the mass upload data flow profile click the “Mass upload Dataflow Profile” button as shown below in the snapshot.

webkul-magento2-marketplace-mapp-upload-admin-Mass-Upload-Dataflow-Profile

After clicking the button, another page will appear to add the Profile name and select the Attribute Set as shown below in the snapshot.
webkul-marketplace-mass-upload-New-Profile
After clicking the Save button, the field mapping section will appear. Here the admin will have to do the field mapping i.e you will have to set the In file name for the corresponding database entries. 

After doing the mapping click the Save button to save the configurations shown below in the snapshot.

profile with id

Mass Upload Product Export

The admin can export the products for the selective seller by navigating to Marketplace Management>Manage Mass Product Export. The admin can select the following:

  1. Select Seller: The admin can choose which seller’s products are needed to be exported.
  2. select product Type: The admin will select which product type for the products that are to be exported.

mass upload export

Mass Uploaded Profile List

The admin can view the list of sellers by navigating to Marketplace Management> Mass Upload Profile Listing.

If any profile is not successfully executed or the admin does not want to run a specific profile then the Mass Upload Profile Listing option can be used by profile admin to delete it.mass-upload-list-1

Product Edit Page

Once the admin or the seller has mass uploaded the product through the CSV/XML/XLS files. They can see all the uploaded cross-sell, related, and up-sale products while editing it.

Also, they can add or add or Remove new products. For the reference. you can check the below image:

related-cross-sell-up-sale-1

  • For the Cross-sell, and Up-sell products, check the below image:
  • cross-sell-up-sale
  • Product Page – Front view

  • After successful uploading of the CSV/XML/XLS files, the customer can view all the uploaded products at the front-end as per below image:
  • product-page-2
  • Also, the customer can view the related, and up-sale uploaded product on the product page as shown below:
  • related-upsale-front-view
  •  
  • And the uploaded cross-sell products will be visible on the cart page as shown below:

    cross-sell-front-view

    Support

    That’s all for the base Marketplace Mass Upload for Magento 2 module still have any issues feel free to add a ticket and let us know your views to make the module better at HelpDesk Support. You may also browse other Magento 2 marketplace addons and our quality Adobe Commerce extensions.

Current Product Version - 5.0.2-p2

Supported Framework Version - Magento 2.0.x, 2.1.x, 2.2.x,2.3.x, 2.4.x

. . .

Leave a Comment

Your email address will not be published. Required fields are marked*


28 comments

  • shashank shirodkar
    • Neelesh Singh (Moderator)
  • Sangeeta
    • Archana Tiwari (Moderator)
  • Byron
    • Suraj Kumar (Moderator)
  • Pragya
    • Archana Tiwari (Moderator)
  • Frenkel
    • abhishek oberoi (Moderator)
  • Sodhan Manandhar
    • gunjita joshi (Moderator)
  • David
    • gunjita joshi (Moderator)
  • Moochie
    • gunjita joshi (Moderator)
  • Luan Carlos
    • gunjita joshi (Moderator)
  • Armando
    • kajal sharma (Moderator)
      • Armando
        • kajal sharma (Moderator)
  • Frank
    • kajal sharma (Moderator)
      • Frenkel
        • abhishek oberoi (Moderator)
          • shuvojit
          • Archana Tiwari (Moderator)
  • Back to Top

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home

    Table of Content