Bulk Product Edit

The Bulk Edit feature allows you to make numerous changes to a large number of products at the same time.

This article details how to select the products and make changes.

Overview

From the Products > All Products page you can select products one by one, or carry out a search, to filter the products you would like to edit. A host of product fields can be edited, ranging from product price or weight, to meta title or stock values.

If fewer than 50 products are selected for editing, changes will be applied straight away. If 50 or more products are selected, these will be batched together and processed as and when server resource permits it, ensuring the performance of your server is not affected by changes to a large number of products.

📘

The Bulk Editing feature may need to be enabled for your store. Please contact your Aurora Account Manager for more information.

Selecting Products for Bulk Edit

Before making any changes to products, you have to select the products you would like to edit. This can be done in two ways, both from the Products > All Products page:

Individually

  • Find the products you would like to edit in the list of all products currently on your store.
  • Check the "Action" checkbox next to each product to be edited

Grouped

  • Carry out a search for products using the standard or advanced product search
  • Check the Select All action checkbox, which selects all visible products

Once the products you would like to edit have been selected, use the actions drop-down menu to select the Bulk Edit action, and then click the Go button. You'll be taken to the Bulk Edit form with the selected products.

Bulk Edit Form

When making changes to additional field values or categories, these changes can either be:

  • Added to any existing values or categories that already exist
  • Existing values or categories cleared first, and then the new items applied.

This behaviour is determined by the Remove existing data? checkboxes.

Affected Products

Once on the Bulk Edit form, you can confirm which products you are editing. These can be viewed on the Affected Products tab:

Fields

On each tab there are a selection of fields that can be updated. Any values entered into these fields will be applied to all of the Affected Products.

🚧

Sharing product fields using Multi-Domains is not supported by this feature. See the Multi-domain support article for more information.

Each field has an associated checkbox. Until this is checked the associated field will not permit any values to be entered. Once checked you can enter the value that you would like to update all products with.

👍

The Editor field can be changed to allow editing using your desired editor (as detailed here) without actually changing the editor saved to be used with the products themselves. To do this, avoid ticking the box beside the field when saving the form.

Ticking this box when saving will change the editor saved against each of your products, as per all other bulk fields below.

The below tables list the fields available to edit.

Overview

Field NameValidation RulesAdmin Activity LoggingTranslatable
Product NameNot Blank

Max length  = 255
YesYes
EditorN/ANoNo
Product DescriptionN/AYesYes
Selling TextN/ANoYes
Live?1 or 0NoNo
Searchable?1 or 0NoNo
Product Style CodeNot Blank

Max length  = 255
NoNo
Search TermsN/ANoYes
Internal NotesN/ANoYes

SEO

🚧

Only available if user has the Products > SEO > Edit permission granted.

Field NameValidation RulesAdmin Activity LoggingTranslatable
Meta TitleN/ANoYes
Meta DescriptionN/ANoYes
Meta KeywordsN/ANoYes

Measurements/Weights

Field NameValidation RulesAdmin Activity LoggingTranslatable
LengthNot Null

Numeric
NoNo
WidthNot Null

Numeric
NoNo
HeightNot Null

Numeric
NoNo
Dimension UnitsOne of the below:

Millimetres
Centimetres
Meters
Feet
* Inches
NoNo
WeightNot Null

Numeric
NoNo
Weight Unitsgrams or kilogramsNoNo

Pricing

🚧

Only available if user has the Products > Price> Edit permission granted.

Field NameValidation RulesAdmin Activity LoggingTranslatable
Price LabelAny available in Store > Price LabelsNoNo
PriceNot Null

Numeric

Precision of 2
NoNo
RRP LabelAny available in Store > Price LabelsNoNo
RRPNot Null

Numeric

Precision of 2
NoNo
Was LabelAny available in Store > Price LabelsNoNo
WasNot Null

Numeric

Precision of 2
NoNo

Stock Control

🚧

Only available if user has the Products > Stock > Edit permission granted.

Field NameValidation RulesAdmin Activity LoggingTranslatable
Stock #Not Null

Positive Integer (0 inclusive)
YesNo
Pre-order StockNot Null

Numeric
NoNo
Warning LevelNot Null

Positive Integer (0 inclusive)
NoNo
Action on Zero?One from the below:

Leave available, but cannot be purchased
Leave available, and able to be purchased
Leave available, and can be pre-ordered
Hide
NoNo

If not in stock

🚧

Only available if user has the Products > Stock > Edit permission granted.

Field NameValidation Rules Admin Activity LoggingTranslatable
Restock DateValid dateYesNo
Normally stock inNot Null

Positive Integer (0 inclusive)
NoNo
Min Shipping TimeNot Null

Numeric

Less than or equal to "Max Shipping Time" if provided
NoNo
Max Shipping TimeNot Null

Numeric

Greater or equal to "Min Shipping Time" if provided
NoNo

Drop Shipping

🚧

Only available if user has the Products > Stock > Edit permission granted.

Field NameValidation RulesAdmin Activity LoggingTranslatable
Min Shipping TimeNot Null

Numeric

Lower or equal to "Max Shipping Time" if provided
NoNo
Max Shipping TimeNot Null

Numeric

Greater or equal to "Min Shipping Time" if provided
NoNo

Categories

🚧

Only available if User has the Products > Categories > Edit permission granted.

Field NameValidation RulesAdmin Activity LoggingTranslatable
Main CategoryAny available in Products > CategoriesNoNo
Product CategoriesSet of categories available in Products > CategoriesNoNo
Remove existing assignments?1 or 0NoNo

Additional Fields

Field NameValidation RulesAdmin Activity LoggingTranslatable
Remove existing data?1 or 0NoNo
TemplateAny available in Products > Fields > Field TemplatesNoNo
Set of FieldsAny available in Products > Fields > FieldsNoYes (depending on the "Is Translatable?" setting for field itself)

Preview Changes

The Preview Changes option validates the values entered.

If the values entered fail validation, error messages will be shown next to the fields that need changing. Otherwise, on successfully passing validation, a preview will be shown of the changes to be made, along with a list of the products that are going to be updated.

From here you can either Apply Changes to the changes you have made, go Back to make further changes or Cancel the bulk edit process.

Bulk Edit Summary

Once you have submitted the changes, if fewer than 50 products were selected for editing, changes will be applied straight away - this is known as inline processing.

If 50 or more products were selected, these will be batched together and processed as a job when server resource permits, ensuring the performance of your server is not affected by changes to a large number of products.

A status will be shown:

StatusDescription
PendingIndicating that the bulk edit job has been created, but not processed yet.
CompletedIndicates that the processes completed.

Please be aware that the process might complete with errors.
FailedShown if processing of the data failed and stopped unexpectedly

🚧

If the process is in a Pending state the page will refresh itself every 5s, until a final summary is available.

Confirmation

A message will be shown indicating the outcome of the update. This could include:

  • Bulk editing completed.
  • The following error has occurred during bulk editing: {message}

📘

Number of Affected Products

This represents the number of products which were processed. If the process is still in the Pending state, this number will be 0 until the process has finished.

Errors

If any errors occurred during processing then these will be displayed here.

Errors section can include the following messages:

  • General - For the validation performed on the data itself. There is some high level validation which is applied to the data provided just before being applied to products. This includes:

    • Do all provided products still exist?
    • Do all categories provided for category association still exist?
    • Do all provided price labels still exist?
    • Do all provided additional fields still exist?
  • Product - For the errors from validation applied at the product level

🚧

There may be as many product error groups as products edited.