Seven bulk editing mistakes

All of these are cheap to avoid and expensive to discover a week later.

You will be redirected to the Shopify app store.

Bulk editing failures are remarkably consistent. Almost none of them are about the tool; they are about the selection, the arithmetic or the absence of a way back.

1. Trusting the filter without reading the preview

The rule is usually right. The selection is what surprises people. Read the match count, and read a sample of the products — especially at the edges of the filter.

2. Compounding percentages by accident

Three successive 20% cuts leave you at 51% of the original price, not 40%. If you have a margin floor, calculate the final stage from cost rather than applying another percentage.

3. Forgetting compare-at price

Cutting the price without setting the reference means no sale badge and no visible discount. Setting the reference without cutting the price means a discount that does not exist — which is worse.

4. No end time

A promotion without a revert time relies on a person remembering. Set both timestamps when you create the task.

5. Editing while a feed is running

If a sync app owns your inventory or prices, a manual bulk edit can be overwritten minutes later. Decide which system owns which field, and edit accordingly.

Every task in the app stores previous values, so mistake number six is survivable.

You will be redirected to the Shopify app store.

6. No way back

A CSV import with no prior export cannot be undone. If your workflow is file-based, take the export every single time, even when you are sure.

7. Changing handles without redirects

Shopify does not create redirects when a URL handle changes. Indexed pages and existing links simply break. Plan redirects before the task, not after the traffic drops.

The pattern behind all seven

Each one is a failure to check something that takes thirty seconds: the preview, the arithmetic, the second field, the timestamp, the owner of the data, the export, the redirects. Bulk editing is fast; the checks are what keep it from being fast in the wrong direction.

Keep reading

Undo a bulk edit on Shopify

Revert a finished task manually or on schedule, and read what changed.

Read more

How to change prices in bulk on Shopify

The four decisions behind every bulk price change, in the order that avoids accidents.

Read more

Bulk edit URL handles on Shopify

Fix import-generated URL handles in bulk — with redirects planned first.

Read more

Ready to edit your Shopify catalog in bulk?

Install Bulk Product Edit by MITS and run your first bulk edit in minutes. Free plan available.

You will be redirected to the Shopify app store.