Demos Buy Now

Marketplace Mass Upload for Magento 2

Magento 2 Mass upload marketplace add-on allows the sellers to add products to store using CSV/XLS/XML file. 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.

Please Note: –

  1. To make this module work you will must be using Webkul’s Magento 2 Multi-Vendor Marketplace module.
  2. In Magento 2 root, run this command –composer require phpoffice/phpspreadsheet.
  3. For uploading products with custom attributes, you need to install Custom Attribute Marketplace Add-On
  4. For uploading products with custom options, you need to install Custom Option Marketplace Add-On
  5. If you want to upload mass products with custom attributes and options then you can check here 

Features

  • Upload multiple product images using the images zip file.
  • Works with simple, configurable, downloadable, virtual product types.
  • Download sample CSV/XLS/XML files for every product type.
  • Export existing products data using CSV file.
  • 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 languages translations.
  • The module source code is open for customization.

Installation

Customers will get a zip folder and they have to extract the contents of this zip folder on their system. 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 Magento2 root directory on the server as shown below.

After the successful installation, you have to run below-mentioned commands in the Magento 2 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 admin panel by navigating through->System->Cache management as shown below.

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 want to translate his store content).

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 Magento2 MpMassUpload folder and will get a CSV file with 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 Magento2 on the server. The module will get translated into the German Language. It supports both RTL and LTR languages.


The user can edit the CSV like the image below.

Admin Panel Configuration

Please note that 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.

Seller Management

After the installation of Marketplace Mass Upload for Magento2 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: Now we will see how to upload product 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 update button. You can see the below.

Now, the seller will select that profile and then click on the “Run Profile” option. You can see the screenshot for the same.

Please check the CSV file for the simple products.

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

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

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.

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

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

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 file and then click on the upload products as shown in the image below.

The seller 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.

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.

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

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

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

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

Please check the CSV file for uploading Virtual products. Here, the seller will enter all the details regarding the products expect the weight.

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

Uploading Downloadable Products

For uploading 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 update button.

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 products and then upload.

After this, a profile will be created as shown in the screen below. 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.

After this, a profile will be created as shown in the screen below. 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.

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.

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

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

Note: If there is any 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 error. The product will not be uploaded if there is any error. So this module provides 100% error free mass upload. You can see few of the error messages below.

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.

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.

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.

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.

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 MassUplaod Product Export section as shown below.

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.

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

Admin Management

The Admin can also mass upload the products for individual Seller. Under Marketplace Management > Upload Mass Upload Profile. From the backend, admin can upload any product (simple, virtual, downloadable, configurable). Admin will upload the CSV file and Image ZIP file for mass upload of products. Seller has to click on the checkbox for mass upload of downloadable.

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

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

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

Now, the admin can see the uploaded products under Marketplace Management->Manage Product section.

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 “Massupload Dataflow Profile” button as shown below in the snapshot.

After clicking the button, another page will appear to add the Profile name and select the Attribute Set as shown below in the snapshot.

After clicking the Save button, 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 configuration as shown below in the snapshot.

That’s all for the base Marketplace Mass Upload for Magento 2 module still have any issue feel free to add a ticket and let us know your views to make the module better at webkul.uvdesk.com

Current Product Version - 2.0.6

Supported Framework Version - 2.0.x, 2.1.x, 2.2.x

. . .

Comments (2)

Add Your Comment

  • Frank
    What if a product with the same sky already exists in the catalog? Will it create a new sku or take an existing product and assign that one?
    • kajal sharma
      If a product with the same SKU already exists in the catalog, then it will simply update the product as per the changes/updates the admin has made.
  • css.php
    Hire Us!
    Brief us about your requirements and we'll get back to you.
    Woo! Hooy!
    We have just recieved your project brief and our expert will contact you shortly.
    Send Again
    Close

    Index