OpenCart Bulk Upload: Uploading products one at a time can be an extremely tedious task, and also a time-consuming task. If a user wants to edit a product that is to be done manually, it will take lots of time and will be a hassle causing process.
The user might end up making mistakes such as uploading the product twice or not uploading some products.
Through the Opencart Bulk Upload module, the admin can add/ upload multiple products in a single click. This saves time and also there are fewer chances of making mistakes.
The admin can upload the products using CSV, XML, or XLS files. It also allows the admin to export the products in bulk using the CSV, XLS, and XML files.
Opencart Bulk Upload eases things in a way that enhances the efficiency of the user as it saves a huge amount of time which a user may waste while uploading products manually.
1. zipArchive extension needs to be installed on the server.
2. This module supports all templates and themes including the Journal theme.
3. Opencart Bulk Upload module supports the Multi-Store feature of default Opencart.
4. To use this module, the PHP version must be lower than the 7.3.
- The admin enables the Keyword and on updating a product, the SEO comprises of SEO+Product Id.
- Also, on enabling the Keyword and adding a new product, the SEO will contain the SEO provided and four random characters.
- The admin can disable the keyword and an error will display and the product skips.
- Admin can upload bulk files under Uploads.
- Using the CSV, XML or XLS files, the admin can upload the products in bulk.
- The admin can upload a zip file for the images.
- Admin can get the ID data of various options like – Product, Catalog, Manufacturer, Filter, Download, Stock Status, etc.
- Under the Bulk option, the admin can export all the products.
- On choosing the Selection option, the admin will have to tick mark the checkbox for the products, which he needs to export.
- Under Data Flow Profile, the database is mapped between the file that needs to be uploaded and Opencart Database.
- The customers can view the bulk products in the frontend.
First, extract the downloaded zip file. After that, open the correct Opencart Version Folder. According to Opencart Version installed in your system. Then, upload admin, demo, and system to the Opencart root directory.
The admin needs to install the Opencart Bulk Upload module by uploading the massupload.ocmod.zip file through Extension>Extension Installer.
Edit User Groups
The admin can configure the Product Mass Upload module as follows:
Status- The admin can configure the module status as Enabled or Disabled.
Keyword- The keyword may be set as Enabled or Disabled.
Case 1: If the Keyword option is set as Enabled.
- If the admin updates the product, the SEO will comprise of SEO+Product Id.
- On adding a new product, the SEO will contain the SEO provided and four random characters.
Case 2: If the Keyword option is set as Disabled.
- An error is shown and the product skips.
Admin End Workflow- Uploads
Once the admin sets the configurations for Opencart Bulk Upload in the admin panel, the Mass Upload tab is visible as a dashboard icon in the admin panel.
Thereafter, the admin can configure the settings for Mass Upload on the basis of two icons- Uploads and Data Flow Profile.
The admin will set the configurations for the “General” tab as follows-
- Data Flow Profile- The admin can select the ‘Data Flow Profile’ from the dropdown list.
- Select- The admin can set ‘Select’ as Admin in order to upload the products of the admin.
- File Type- The File Type can be chosen as XML, XLS, and CSV.
- Update new Products or Replace Old Ones- The admin can choose either- Add New Products Only or Update Old Products.
- Upload Zip File- The admin needs to click on the Upload button in order to upload the XML/XLS/CSV file.
By clicking on the “Next” button, the user can import the products and a success message will display for the user.
The admin can upload the images under the Image tab as shown in the image.
The admin will set the configurations for the “Image” tab as follows-
- Select: The admin can select the whose products the user can upload, from the dropdown list.
- Upload Images(Zip): The admin can upload the zip file.
The admin will set the configurations for the “Get Id” tab as follows-
- Select: The admin can select an option from the given list and click on the search box to display the IDs of the respective option.
- Search: The admin will have to simply click on the search box and the Ids for the option which the admin selects display in the box.
For example- In the given image the admin selects Category option against the Select option.
On clicking the Search Box, the Id’s for the option display. The admin can type and name and the id’s for that specific name will display in the Search Box.
The admin will set the configurations for the “Export” tab as follows-
- Select: The admin will select the admin products from the given dropdown list.
- Mail: The admin will have to select the mail option from the list.
- Backup File Type: The admin will choose either CSV, XML or XLS form the given list of options.
- Select Download Type: Against Select Download Type, the admin will have to choose either Bulk or Selection.
——-On choosing Bulk, the admin can export all the products.
——-On choosing Selection, the admin can tick mark the checkbox for the products, which he needs to export.
——-Once the admin has chosen the products, on clicking the Export button, the admin can export the products.
——–After exporting the products, the admin can find the files in the email.
Data Flow Profile
The admin can create a new Data Flow Profile on clicking the “Plus Sign”.
The ‘Profile Name’ details are added by the admin. Under ‘Profile information’, the admin adds the name of Database and name of the files.
This will help in mapping the database between the file that needs to be uploaded and Opencart Database.
Once the mapping of the fields is done, the admin can save the details.
A success message, “Data Flow Profile Successfully Updated” displays as soon as the admin saves the details. The admin can navigate through Catalog > Products in the admin panel and view the products which are uploaded in bulk, under Product List as shown in the image below.
Front End Workflow
In the frontend, the customers can choose a category and select a bulk upload product.
That’s all for the Opencart Bulk Upload extension. Still, have issues or want to give your suggestions to make this module better just raise a ticket at webkul.uvdesk.com
Current Product Version - 184.108.40.206
Supported Framework Version - 2.x.x.x, 3.x.x.x