The Bulk Edit screen allows administrators to quickly update multiple products at once from a single grid interface. This tool is designed for fast catalogue maintenance and supports editing pricing, stock, categories, brands, tax bands, shipping settings, promotional data, and more across many products simultaneously.

Accessing the Bulk Edit Screen

To access the screen, you select a number of products in the product list screen by checking their checkboxes - and then click the BULK EDIT button.

For example, if you want to bulk edit new products added, just change the SORT ORDER to NEWEST on the product list screen, and then select the products at the top of the list and click BULK EDIT.

Products Included in Bulk Edit

The screen loads product details including:

• SKU / Product Code
• Product Title
• Promotion Text
• Primary Category
• Brand/Vendor
• Price
• Promotional Price
• Cost Price
• Stock Quantity
• Stock Managed status
• Shipping Band
• Tax Band
• Weight
• Product Status (Active/Inactive)

Main Grid Features

Editable Spreadsheet-Style Grid

The interface behaves similarly to a spreadsheet:

• Click directly into cells to edit values
• Tab between fields
• Edit multiple rows rapidly:
  • By entering a value in a call and dragging it down across the other cells below it to copy the same valuer into them
  • OR By selecting rows using the left side checkboxes and clicking APPLY TO ALL
• Changes are tracked automatically

Default Columns

The following columns are shown by default:

Additional optional columns can be enabled through the column visibility menu - by clicking on the COLUMNS button.

Optional Columns

Optional editable columns include:

• Promo Price
• Promo Text
• Cost Price
• Stock
• Stock Managed
• Tax Band
• Shipping Band
• Weight

These can be toggled on/off using the Visible Columns panel - by clicking on the COLUMNS button.

Searching Products

The bulk editor includes a live search filter.

Users can search by:

• Product Title
• SKU/Product Code

Search filtering updates the visible grid immediately.

Pagination

The grid supports pagination for large product sets.

Supported page sizes:

• 15 rows
• 50 rows
• 100 rows

The footer displays:

• Current range
• Total products
• Search result counts

Product Selection

Administrators can select products using checkboxes.

Selection options include:

• Individual row selection
• Select all products on current page
• Multi-product selection banner

Selections are used for bulk actions.

Bulk Apply Feature

The Bulk Apply panel allows a single value to be applied to multiple selected products simultaneously.

Supported bulk-editable fields include:

• Status
• Category
• Brand
• Price
• Promo Price
• Promo Text
• Cost Price
• Stock
• Tax Band
• Shipping Band
• Weight

The administrator:

1. Selects products
2. Opens the Bulk Apply panel
3. Chooses a field
4. Enters/selects a value
5. Applies the update

Fill Handle / Drag Down Editing

The grid supports spreadsheet-style drag filling.

Administrators can:

• Edit one cell
• Drag the fill handle downward
• Copy the value across multiple rows

This works similarly to Excel.

Change Tracking

The system tracks unsaved changes automatically.

Features include:

• Cell-level change indicators
• Column-level edit markers
• Unsaved change counter
• Original value comparison

This allows administrators to clearly see what has been modified before saving.

Product Status Handling

Products can be toggled between:

• Active
• Inactive

The status column uses coloured indicators for visibility:

Searchable Dropdown Fields

Several fields use searchable dropdown selectors, including:

• Category
• Brand
• Tax Band
• Status

Features include:

• Type-to-search
• Keyboard navigation
• Auto-filtered results
• Selection highlighting

Variant Display

Products with variants display:

• Expand/collapse controls
• Variant count badges
• Read-only variant summary rows

Variant rows may show:

• SKU
• Variant options
• Colour swatches
• Price
• Promo Price
• Stock
• Weight
• Status

Variant Colour Swatches

If a version table represents colour/colour options, the system automatically displays colour swatches.

Swatches are determined using:

• Stored HEX colour values
• Generated fallback pastel colours

Saving Changes

When the user clicks Save Changes:

1. Only modified fields are collected
2. Products are updated individually

The system returns:

• Successful row count
• Failed row count
• Validation errors

Shipping Band Validation

Shipping bands are validated before saving.

Accepted values:

• Integer values only
• Range: 0–10

Invalid values are ignored.

Weight Handling

Weights support:

• Decimal values

Examples:

• 1.5
• 1.5 kg

Bulk Edit Attributes Screen

The Bulk Edit Attributes screen allows administrators to manage category-type relationships in bulk.

Supported attribute groups:

• Filters
• Product Groups
• Additional Categories

The system automatically:

• Loads available category trees
• Maps selected category names to IDs
• Adds/removes secondary category links

Bulk Edit Variants Screen

The Bulk Edit Variants screen is designed for editing version-table data.

Supported functionality includes:

• Variant lookup table editing
• Size/colour/version assignments
• Variant-level price changes
• Variant stock editing
• Variant status updates

The system supports up to five lookup/version levels.

Best Practices

Recommended Workflow

1. Load a manageable number of products
2. Use search/filtering first
3. Enable only required columns
4. Make changes in batches
5. Review change indicators
6. Save regularly

Tips

Use Fill Drag for Speed

Drag values down for:

• Status changes
• Brand assignment
• Promo text
• Shipping bands

Use Bulk Apply for Large Updates

Ideal for:

• Category assignment
• Tax band changes
• Activating/deactivating products

Expand Products to Review Variants

Variant summaries help confirm:

• Pricing consistency
• Stock levels
• Variant completeness