With the help of the module Laravel eCommerce bulk upload the admin and the sellers can upload product in bulk that will save the time while uploading a huge quantity of products.
Complete features list of Laravel-eCommerce-bulk-upload
- The product can be upload by CSV / XLS files.
- Data profile creation feature for admin.
- Each attribute has a different column.
- Image attachment with the product within CSV/XLS.
- If there is an error in the CSV / XLS file, then products will not be uploaded and hence customer/admin will come to know about the error.
How to install the module
Unzip the respective extension zip and then merge “packages” and “storage” folders into the project root directory.
Goto config/app.php file and add following line under ‘providers’
Then goto composer.json file and add following line under ‘psr-4’
Goto config/concord.php file and add following line under ‘modules’
Run these commands below to complete the setup
composer dump-autoload php artisan migrate php artisan storage:link php artisan route:cache php artisan vendor:publish
-> Press 0 and then press enter to publish all assets and configurations.
Admin Configuration:-Laravel eCommerce bulk upload
After the successful installation of the module laravel eCommerce bulk upload, the admin can see the options of Bulk upload in the side menu bar.
Firstly the admin needs to create the Profile and need to select the associated attribute family, under Dataflow profile a page will generate that will look like shown below.
After the profile has been created click on Upload files that will look like as shown in the below picture in which there are two sections.
under this section, the admin can download the sample of CSV/XLS files for both simple and configurable products and can further edit it.
Creating a sample CSV/XLS file
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 the product.
after editing Save the file to the desired location.
Lets 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:-
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 for 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 the admin can enter the beginning date for the special price regarding the products.
Special price to:- Here the admin can enter the end date for the special price regarding the products.
The admin also needs to select the inventory source products if created otherwise set it as default.
Inventories:- The admin can set the number of product 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.
The name of the images for each product should be same in the CSV/XLS file also.
For Virtual Products
Here the process is again same to upload the virtual product but some of the additional fields that are available for virtual products are as follows.
For Grouped Products
For the grouped products there are some new fields those need to be filled in CSV and XLS files.
Grouped SKU Product:- The admin needs to enter the grouped product SKU separated by comma.
for example:- Product name, SKU for product.
Grouped Quantity:- Enter the quantity in this field. These are the quantities for grouped products that are separated by comma.
Grouped Sort Order:- The admin can enter the sort order for the grouped products.
For Downloadable Products
For the downloadable products there are some extra fields like:-
Sample URL:- Insert URL to give the free sample
Link Sample URL:- If you want to give a free sample of your product to the customer, add a new link from the Samples section
Link URL:- Enter the link for the URL from where the customer can download the file.
For Bundle Products
For the bundle products there is a new field in the CSV and XLS files as shown and explained below:-
Bundle Options:- The admin need to enter the product that are available in bundle products.
For Booking Products
To upload the booking products from the CSV and XLS the admin need to enter several other fields as explained below:-
Booking Type:- Here the admin can enter booking type like Default, Appointment, Event, Rental ,Table.
Booking Location:- The admin need to enter the location accordingly
Quantity for booking product :-Enter the quantity for the booking product.
Booking Available from:- Enter the date and time saperted by comma from when the booking will be available.
Available to:- Enter the date and time till when the booking is available.
Booking Type Day Wise:- Enter the number of days till when the booking is available.
Booking Slot From Day:- Enter the day from when the booking Slot will start
Slot From:- Enter the date and time from when the booking slot will be available.
Booking Slot to day:- Enter the day till when the booking Slot will remain available.
Booking Slot to:- Enter the date and time till when the booking slot will be available.
Available Every Week:- The admin can enter between the Yes or No.
Duration:- The admin can also enter the value for a single appointment time period (This is the value in minutes)
Break Time:- The admin can enter the value of time betwwen 2 appointments(In minutes).
Same Slot All Days:- Enter the value betwwen Yes or No.
Event Ticket Name:- This is for the event booking where the admin can enter the event name.
Event Ticket Discription:- This is for event booking where the admin can enter the discription for an event.
Ticket Price:- Enter the price for the event.
Event Ticket Quantity:- Enter the ticket quantity for the event.
Renting type:- This is for the renting type products the admin can enter such as Daily, Hourly.
Daily Price:- The admin can enter the daily based price.
Hourly Price:- The admin can also enter the hourly based price.
Day Wise Slot:- This is for the table booking products where the admin can enter the day wise slot.
Price Type:- From here the admin can set that what the price type will be between per table or per guest.
Guest Limit:- The admin can enter the guest limit for tha table.
Prevent Scheduling Before:- the admin can enter the minutes to advance booking means that before the start time of the slot.
Default Booking Status:- The admin can set the default booking status here.
Under this section there are several fields as described below.
Is Downloadable have files:- If the admin has selected this option then two options will also generate i.e Is Links have samples and Is Samples Available the admin can multi-select select between these two.
Once these option have been selected by the admin the admin also need to upload the files regarding these as shown in the image below:-
- Attribute Family:- The attribute family can also be selected in this field.
- Data Flow Profile:- In this field, the admin can select the profile that has been created before.
- CSV/XLS File:- Under this field, the admin can upload the CSV/XLS file for the uploading of the product in bulk quantity.
- Image Zip file:- In this field, the admin can also upload the images regarding the products in Zip format.
Click on Save button.
Now the next step is to Run the profile.
Select File:- In this field, the admin can select the profile that has been created from the dropdown.
Click on Run.
Now the bulk products have been uploaded successfully to the eCommerce store.
Current Product Version - 1.2.0
Supported Framework Version - Bagisto, 1.2.0