Laravel eCommerce Marketplace Bulk Upload

• Products can be uploaded through CSV or XLS files.
• The seller can upload bulk products.
• Admin can upload the bulk product into the individual seller account.
• This module supports all product types i.e., Simple, Configurable, Bundled & Grouped products except Virtual and downloadable products.
• Add any number of the product there is no limitation.
• Mass upload is compatible with multiple channels.
• It supports multi-lingual.
• Mass update via product SKU and url_key.
• Image attachment with the product within CSV / XLS files.
• The admin or seller can upload a zip file for the images.

Note: Make sure the Marketplace Status is enabled before installing the Marketplace Bulk Upload module.

Unzip the respective extension zip file and merge the “packages” directory into the project root directory.

Goto config/app.php file and add the following line under ‘providers’

Webkul\MpDataTransfer\Providers\MpDataTransferServiceProvider::class

Goto composer.json file inside the Bagisto root directory and add the following line under ‘psr-4’.

 "Webkul\\MpDataTransfer\\": "packages/Webkul/MpDataTransfer/src"

Open the config/bagisto-vite.php file and add the following command under the ‘viters‘ folder.

'mp_data_transfer' => [
'hot_file' => 'mp-data-transfer-vite.hot',
'build_directory' => 'themes/mp_data_transfer/build',
'package_assets_directory' => 'src/Resources/assets',
],

#Run Commands

Next, run these commands below to complete the setup in the bagisto root directory.

composer dump-autoload

php artisan migrate

php artisan vendor:publish --provider="Webkul\MpDataTransfer\Providers\MpDataTransferServiceProvider" --force

php artisan optimize:clear

After the successful installation of the module Laravel eCommerce marketplace bulk upload, the admin can follow the below given steps to bulk upload the products.

Step 1: Go to the Admin panel of Bagisto click on Settings >> Data Transfer and click on Create Import button

Step 2: Under general configurations select the below fields:

1) Type – Kindly select the type i.e. (Products, Customers, Tax rates, Categories, Seller Products, Seller Categories ) which you want to import.

2) File – Choose the file in your desired format (CSV, XLS, XLSX) and kindly make sure you have all the required fields in the file.

Note – While importing the product data Simple, Configurable, Bundled & Grouped product types can be imported except  Virtual and Downloadable products.

3) Download Sample – You can also download the sample files of types (Products, Customers, Tax Rates, Categories, Seller Products, Seller Categories ).

Kindly make sure the file you are uploading is similar to this sample file.

4) Image Directory Path – Use relative path to /project-root/storage/import/app, e.g. product-images, import-images.

5) Action – Kindly select from the settings configuration that you want to Create/Update or Delete the records.

6) Validation Strategy – This unique feature allows you to Skip the Errors or to Stop on Errors while Importing the data.

7) Allowed Errors – This feature allows you how much quantity of errors will get neglected while importing the data.

8) Field Separator – This feature allows you to set the fields.

9) Process in Queue – This feature allows you to run your import process in a queue.

So now click on the Save Import Button.

Step 3: Admin can also add seller bulk Product. To add seller products select Type “Seller Product” and Select the Seller on Set Seller option.

Step 4: Now the import process will get started and after it is completed the product import process will be done.

Step 5: Now you will able see to all the products under the Catalog >> Products section as shown in the given image.

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

After downloading the CSV/XLS sample files the admin /Seller can edit the files according to the products. The admin/seller can upload ‘n’ numbers of product.

A sample file for both Simple products and configurable products are downloadable for the further edition.

after editing Save the file to the desired location.

Let’s take an example of uploading 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:-

The admin needs 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 of the product.

Description:-Enter the Description for the product.

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

SKU:- Enter the SKU for the products.

Price:- Here the admin will enter the price for the products.

The admin can also enter the special price for the products if required.

Special price from:- Here admin can enter the beginning date for the special price regarding the products.

Special price to:- Here admin can enter the end date for the special price regarding the products.

Admin also needs to select the inventory source products if created otherwise set it as default.

Inventories:- admin can set the number of products across each inventories in this field.

Weight:- Enter the weight for the simple products.

The admin can also enter the meta title, meta keywords and meta description regarding the products in their respective fields.

Size:- The admin can also enter the size for 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:- To set as the new product set it as 1 otherwise 0.

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

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

Status:- To enable the status as active set as 1 otherwise 0.

Cost:- Enter the Cost if required.

The admin can also enter the width,height and depth regarding the simple products.

Type:- Select Simple for the simple products.

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

Images:- Enter the images name regarding the products.

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

Save the file to the desired location.

For Configurable products:-

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

Super Attributes:- The admin can 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.

The admin can also 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 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 also

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

Sellers can also upload products in bulk using this module. On the profile page, they will find the Data Transfer options, as shown below.

Step 1: Click on the Data Transfer and then you can see the Create Import button click on that as shown below given the screenshot.

Step 2: Now, Under the Create import section select the below fields:

1) Type – Kindly select the type i.e. (Products, Categories, Seller Product, Seller Categories) which you want to import.

2) File – Choose the file in your desired format (CSV, XLS, XLSX) and kindly make sure you have all the required fields in the file.

Note – While Import the product data Simple, Configurable, Virtual, Bundled & Grouped product types can be imported except Downloadable products.

3) Download Sample – You can also download the sample files of types (Products, Categories, Seller Product, Seller Categories).

4) Image Directory Path – Use relative path to /project-root/storage/import/app, e.g. product-images, import-images.

5) Upload Images – Upload all the product images in form of a zip file.

Under the Settings configuration fill the below-given fields.

6) Action – Kindly select from the settings configuration that you want to Create/Update or Delete the records.

7) Validation Strategy – This unique feature allows you to Skip the Errors or to Stop on Errors while Importing the data.

8) Allowed Errors – it allows you how much quantity of errors will get neglected while importing the data.

9) Field Separator – This allows you to set the fields.

10) Process in Queue – This feature allows you to run your import process in a queue.

Now click on the Save Import Button.

Step 3: After that, the import process will get started and after it is completed the product import process will be done.