In-App Edits vs. Spreadsheet Edits

Ablestar Bulk Product Editor has two methods for modifying products:

• In-App Edits: Allows both filtering and modifying all products. This could be used for a large number of variants that will be changed with the same value.
• Spreadsheet Edits: Allows the user to bulk edit several different values affecting several different products.

In-App Edits

Our app allows you to quickly apply advanced filters on a large set of products using predefined edit and modification options.

In many cases, this method can be set up faster than spreadsheet edits and includes both text and number options.

1. Number Fields

In this example, the user has filtered a set of products and is increasing prices by 2% and at the same time, rounding all prices to the same digit:

There are several other Price options you could use from the 'How to Edit' field. Learn more about advanced options on Number fields or modifying Compare-at prices to quickly bulk edit any number field.

2. Text Fields

In this example, the user has filtered a set of products and wants all Product Titles to include the Vendor name at the end of the text, so they have configured a Dynamic Field to pull in the Vendor name:

There are several other Text options you could use from the 'How to Edit' field. Learn more about advanced options on Text fields and using Dynamic Fields to quickly bulk edit your products.

Spreadsheet Edits

Spreadsheet edits are useful for more complex or layered modifications. Often, users find the spreadsheet controls like filtering, sorting and formulas help them to configure various points of data in the same edit.

The advantage of spreadsheets is being able to edit large amounts of data with different values. For example, not all prices have to change to the same $9.99 price, they could be several different amounts or variables.

You can use a spreadsheet editor like Google Sheets or Excel to both filter the products and make mulitiple changes in a single effort.

Some common things that can be done with a spreadsheet edit are:

• Filter products before bulk modifications.
• Update a variety of Inventory or Price amounts.
• Trim product fields to a specific number of characters.
• Move text from mid-sentence to beginning or end-sentence.
• Convert text to upper, lower, or sentence case.
• Calculate cost or price with formulas.

If you have trouble setting up a formula for a spreadsheet edit with Google Sheets or Excel, chat with us below. We are happy to help!

(02.80)