In-App Edits Vs. Spreadsheet Edits
There are are two options for modifying products using the Bulk Editor. One option would be to use the 'in-app' bulk edit to both filter and modify the products, and the other option is to upload a spreadsheet into the Bulk Editor that contains the changes you wish to make. In this article we discuss the differences between the two.
In-app edits allow you to filter the products to be modified (based on product options), and then use predefined edits to make the modifications. The predefined options available vary based on the field in question, and you can see some of the edit options available below. In most cases, in-app edits can be set up faster than spreadsheet edits. For those cases where the in-app filters or edit options are not sufficient, a spreadsheet edit can be used.
Description Field Edit Options
- Set text to value
- Add text to end
- Remove text from end
- Add text to beginning
- Remove text from beginning
Price Edit Options
- Decrease by percent
- Increase by percent
- Change by fixed amount
- Set to a fixed value
- Set as a percent of Compare Price field
- Set as a percent of Cost field
- Set as a percentage of original value
Spreadsheet edits are useful for those modifications that are not easily accomplished with an in-app edit, as you can use a spreadsheet editor like Google Sheets or Excel to both filter the products and make changes, then upload the file into the Bulk Editor to update the products on the Shopify store. Some common things that can be done with a spreadsheet edit are:
- Trim product fields to a specific number of characters.
- Use wildcards for search and replace modifications.
- Converting text to upper, lower, or proper (sentence) case.
- Calculate costs or prices.
- Filter products for other modifications.
- Updating Inventory (If on the Bulk Editor Professional Plan, you also have the option of automating spreadsheet updates from things like an FTP site, DropBox, etc. You can read more about using Inventory Sync here.)
If you are having trouble setting up a formula for a spreadsheet edit with Google Sheets or Excel, email us at email@example.com.