Bulk Operations Feature – Manage Products, Categories & Brands in One Go

Bulk Operations Feature – Manage Products, Categories & Brands in One Go

How to Update Products, Categories, and Brands Using Bulk Operations


This article explains how to update multiple products, categories, and brands at once using the Bulk Operations feature. You can upload Excel or CSV files to quickly make changes instead of editing records one by one. It helps save time, reduce manual effort, and manage large data easily.
Follow the steps below to perform bulk updates smoothly.

Sign in to SwilMart Admin  

  • Open the SwilMart Admin login page.
  • Enter your Email and Password.
  • Click on the Sign In button.
After successful sign-in, you will be redirected to the SwilMart Admin Dashboard.

Reference Image:


  • From the SwilMart Admin Dashboard, go to the left-side menu panel.

  • Click on the Bulk Operations option (as highlighted in the menu).

  • The Bulk Operations Dashboard page will open.

  • Here, you will see three sections:

    • Product Bulk Operations

    • Category Bulk Operations

    • Brand Bulk Operations

  • Click on the Get Started button under the required module to begin the bulk update process.


Note:

Here, we are explaining the steps for Product Bulk Operations. The process for Category Bulk Operations and Brand Bulk Operations is the same. You just need to select the respective module and follow the same steps.

Reference Image:


Product Bulk Operations – Upload & Configure File

  • After selecting Product Bulk Operations, the Upload File page will open by default.

  • Click on the Download Template button (top right) to download the sample Excel format.

  • Under Step 1: Upload File & Configure Options, click Choose File to upload your Excel (.xlsx, .xls) or CSV (.csv) file.

  • Ensure the file size does not exceed 50MB.

  • (Optional) Upload an Images ZIP file if you want to update product images (Max size: 500MB; supported formats: JPG, PNG, WebP).

  • Select the Update Type from the dropdown. You can choose:

    • Product – To update only product details.

    • Variant – To update only variant details.

    • Both – To update both product and variant details together.

  • Enter the Batch Size (default is 50 rows per batch; you can set between 10–100 as required).

  • Enable additional options if needed:

    • Process Images – To process and update product images.

    • Allow Protected Fields – To update protected fields.

    • Override ERP Fields – To override existing ERP field values.

  • After completing all configurations, proceed to the next step for Preview & Mapping.

Reference Image:


Preview & Mapping  

  • After uploading the file, you will be redirected to Step 2: Preview & Mapping.

  • The system automatically detects and maps the columns with the required fields.

  • You can see the summary of columns detected, mapped, and unmapped at the top.

  • Review the Column Name, Normalized Field, Model Field, Status, and Notes sections carefully.

  • Required fields will be marked as Required, and successfully linked fields will show as Mapped.

  • If you need to modify any field mapping, click on the Edit Mapping button.

Reference Image:


File Preview & Validation  

  • After completing column mapping, the system will display the File Preview section.
  • You can review the uploaded data row-wise to ensure all details are correct.

  • Required fields are clearly marked as Required, and successfully linked fields show as Mapped.

  • The Expected Fields for Product section displays all fields supported for this update type.

  • Check the Validation Summary to see whether the data is valid or contains errors.

  • If all records are correct, the status will show All Valid.

  • A confirmation message will appear stating that the file is ready to upload.

  • Click on Confirm & Upload to proceed with the bulk update process.

  • If changes are needed, click Back to modify the file or mapping before uploading.


Reference Image:

Job Status  

  • After clicking Confirm & Upload, go to the Job Status tab to track the upload progress.

  • Here, you can view the Job ID for the uploaded file.

  • The dashboard displays the total number of rows, processed records, successful updates, and failed records.

  • You can also check the Image Processing status (if images were included).

  • The system shows the Created, Started, and Completed date & time of the job.

  • If any records fail, an alert message will appear with error details.

  • Click on Download Error Report to view and correct the failed records.

  • To upload a corrected or new file, click on Start New Upload.


Reference Image:

Export Data

  • Click on the Export Data tab to download products or variants in Excel/CSV format.
  • In the Format dropdown, select the required file type:

    • Excel (.xlsx)

    • CSV (.csv)

  • In the Status dropdown, choose the product status you want to export:

    • All Statuses

    • Active

    • Archived

    • Draft

    • Inactive

  • Select a specific Category from the dropdown or keep All Categories selected.

  • Select a specific Brand from the dropdown or keep All Brands selected.

  • Enter the Limit to define the number of records to export (Maximum limit: 50,000).

  • Click on the Export Data button to download the filtered product list.

  • The section below will display Products Matching Export Filters based on your selected criteria.


Reference Image:

      • Related Articles

      • Manage Your Brand Catalog and Settings in SwilMart Admin

        How to Organize and Customize Your Brand Catalog in SwilMart Admin SwilMart Admin provides a powerful and user-friendly Brand Management feature that allows you to organize, manage, and optimize your brand catalog in one place. With this feature, you ...

      • Manage Product Categories in SwilMart Admin

        How to Manage Product Categories in the SwilMart Admin Portal SwilMart Admin’s Category Management helps you easily organize your product catalog. You can add or edit categories, manage visibility, filter lists, and export reports—all from a simple, ...

      • Managing Products in SwilMart Admin

        How to Manage and Explore Products with Advanced Search and Filtering Managing products becomes faster and more efficient with SwilMart’s advanced search and filtering tools. These features help you quickly find specific items, organize your product ...

      • Managing Product Variants in SwilMart

        Product Variants in SwilMart: Step-by-Step Guide to Managing Product Variations Product Variants in SwilMart Admin allow you to manage different versions of a product—such as pack size, weight, dosage, or configuration—under one main product. This ...

      • Manage Locations in SwilMart

        A Complete Guide to Using Location Management in the SwilMart Admin Portal The Location Management feature in the SwilMart Admin Portal helps you manage all your store locations, warehouses, dark stores, and fulfillment centers from one place. With ...