Amazon Ads Bulk Operations for Merch: change hundreds of bids in one file

Amazon Ads bulk operations let you download all your campaigns as one spreadsheet, change bids, states and budgets in it, and upload it back so Amazon applies every change at once. For a Merch seller with hundreds of one-design campaigns, it is the only practical way to keep bids in line with each design's royalty.
The mechanics are simple. The hard part is deciding what each row's new bid should be, and making sure the file changes only the rows you meant to change.
This guide covers the download settings that matter, the handful of columns a Merch seller actually edits, a worked example of six rows, and a check you can do in two minutes before every upload.
What bulk operations are, in plain terms
Amazon calls the files bulksheets. Its bulksheets overview describes them as a spreadsheet tool to "create and optimize multiple campaigns in batches", including updating thousands of keywords, targets and bids at once, with performance columns such as impressions, clicks, ACOS and CPC in the same file.
For sellers, the page is in the ads console under All campaigns > Bulk operations, according to Amazon's getting started guide.
There are two kinds of file:
- A custom spreadsheet: your existing campaigns with their data. This is the one you use to change bids.
- A blank template: only the column headers. This is for building new campaigns from scratch, which our campaign flat file builder can also do for you.
Each row is one thing: a campaign, an ad group, a product ad, a keyword, a product target or a placement adjustment. Amazon's guide says the first three columns are always Product, Entity and Operation.
Download the right file
The download screen has a few boxes, and their defaults are not the best choice for bid work. From Amazon's getting started guide:
A useful habit: download a 30-day and a 14-day file as well. The 60-day file tells you whether a target has ever paid; the shorter ones tell you whether it still does.
Before you edit anything, save an untouched copy of the file. If an upload goes wrong, that copy holds every old bid.
The columns a Merch seller actually edits
A Sponsored Products sheet has around 30 columns. For bid work you need to read a few and change even fewer.
| Column | What it holds | Edit it? |
|---|---|---|
| Product, Entity | Campaign type, and what the row is (Keyword, Product Targeting, Bidding adjustment...) | No, read only |
| Operation | What Amazon should do with the row: Create, Update, Archive, or blank | Yes, on every row you change |
| Campaign ID, Ad Group ID, Keyword ID | Amazon's IDs for the row | Never |
| State | enabled or paused | Yes, to pause or switch on |
| Bid | The keyword or target bid | Yes, the main job |
| Daily Budget | The campaign's budget | Sometimes |
| Placement, Percentage | Top of search and product page adjustments | Sometimes |
| Clicks, Orders, Spend, Sales, ACOS | Performance for the date range | No, these are what you decide from |
Three formatting rules from Amazon's overview save most upload errors:
- A blank Operation means no change. Amazon's words: rows where the Operation field is blank "will be ignored in the bulk upload and will remain unchanged". This is your safety net. Only rows you mark with Update change.
- Percentages are whole numbers. A 25% top of search adjustment is written
25, not0.25or25%. - Bids are plain numbers. No dollar sign and no commas, for example
0.21.
Set each bid from the royalty, not from a target ACoS
The file shows ACOS on every row, and the temptation is to sort by it and cut everything over 30%. On a Merch shirt that is the wrong line. The right ceiling comes from what one sale pays you.
The break-even bid for a target is:
royalty after returns x conversion rateHere is a worked example. Say a $19.99 shirt pays about $4.55 in royalty. Take off returns: at the 9.1% return rate measured on 1,645 Merch units in our 60-day returns data, that is about $4.14 per order you keep.
At a 5% conversion rate (1 order in 20 clicks), the break-even bid is $4.14 x 5% = about $0.21. Any bid above that loses money on average, before you've paid for a single impression that didn't convert. Our break-even ACoS table gives the same ceiling at other prices, and ACoS and Returns explains why the returns step matters.
Two practical rules keep this from swinging on luck:
- Use the target's own conversion rate only once it has 3 or more orders. Below that, use a cautious rate such as 5%.
- Bid about 80% of the ceiling, not 100%. That leaves room for the orders that come back as returns later than you expected.
If you'd rather not do this by hand per price, the Merch max bid calculator gives the ceiling from your price and conversion rate.
A worked example: six rows from one bulk file
Here are six keyword rows from a made-up 60-day file. All six advertise $19.99 shirts, so the royalty after returns is $4.14 for each.
| Target | Clicks | Orders | Bid now | Ceiling | New bid | Operation |
|---|---|---|---|---|---|---|
| Keyword A | 40 | 3 | $0.30 | $0.31 (7.5% CVR) | $0.25 | Update |
| Keyword B | 25 | 0 | $0.28 | $0.21 (5%) | $0.17 | Update |
| Keyword C | 6 | 0 | $0.20 | $0.21 (5%) | $0.20 | blank |
| Keyword D | 12 | 2 | $0.15 | $0.21 (5%) | $0.17 | Update |
| Keyword E | 35 | 0 | $0.22 | $0.21 (5%) | paused | Update |
| Keyword F | 0 | 0 | $0.10 | $0.21 (5%) | $0.10 | blank |
How each decision was made:
Four rows change, two don't. In the upload, only the four marked Update reach Amazon.
Upload safely: the two-minute check
Most bulk mistakes happen in the last minute, not in the maths. Before you upload:
3.0 where you meant 0.30 shows up at the top.After the upload, note the date. A bid you just changed needs fresh clicks before it can be judged again, roughly 1 / conversion rate clicks, so about 20 at 5%. Re-download a new file next time rather than editing the old one: the old file's numbers are a snapshot and go stale.
How PPC Optimizer Pro handles this
PPC Optimizer Pro does the decision part of this workflow for you. In the Optimizer Lab you upload the 60, 30 and 14-day bulk files plus your Merch sales report. It works out each target's break-even bid from the royalty, with returns subtracted, and explains every suggested change: the numbers it looked at and why the bid moved. You can untick any change or type your own bid, then download one Amazon-ready file in which only the changed rows are marked for update. Nothing reaches Amazon until you upload it yourself. There's a 7-day free trial, and the free tools work without an account.
FAQ
Can bulk operations break my campaigns?
Only the rows you mark with an Operation change. The risk is marking too many rows or typing a wrong value, which is why the two-minute check above matters. Keep an untouched copy of the download so you can restore old bids.
How often should a Merch seller upload a bulk file?
Weekly is a sensible rhythm for most accounts. Each changed bid needs fresh clicks before it can be judged again, so changing the same rows every day mostly reacts to noise.
Why is my bulk upload giving errors?
The usual causes are percentages written as decimals or with a % sign, bids with a dollar sign, edited ID cells, and bids outside Amazon's allowed range. Download the error file after the upload; it lists the rows that failed.
Should I include zero-impression items in the download?
Include them if you want to act on targets that get no traffic, for example to give them a small test raise. Leave them out if you're only cutting bids on what spends, since they make the file much longer.
Can I create new Merch campaigns with a bulk file?
Yes. Use the blank template, with Create in the Operation column and one row per campaign, ad group, product ad and keyword. The campaign flat file builder builds those rows for you.
Keep reading
Written by
PPC Optimizer Pro Team
The PPC Optimizer Pro Team consists of Amazon sellers and developers who built this tool after years of managing Sponsored Products campaigns manually. We share data-driven strategies to help sellers reduce wasted ad spend and improve ACOS.