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

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

P
PPC Optimizer Pro Team
•November 20, 2026•10 min read
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:

  • Date range: up to 60 days. Pick the longest. Merch designs sell slowly, and 7 or 14 days rarely holds enough clicks to judge a bid.
  • Campaign items with zero impressions: excluded by default. Tick it if you want to see targets that get no traffic at all. Amazon itself suggests it for keyword work.
  • Placement data: included by default. Leave it on; you need it to see top of search and product page adjustments.
  • Sponsored Products search term data: optional. Tick it if you also want to harvest or negate search terms in the same sitting. Our guide to the search term report covers what to do with it.
  • Terminated campaigns: excluded by default. Leave them out.
  • 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.

    ColumnWhat it holdsEdit it?
    Product, EntityCampaign type, and what the row is (Keyword, Product Targeting, Bidding adjustment...)No, read only
    OperationWhat Amazon should do with the row: Create, Update, Archive, or blankYes, on every row you change
    Campaign ID, Ad Group ID, Keyword IDAmazon's IDs for the rowNever
    Stateenabled or pausedYes, to pause or switch on
    BidThe keyword or target bidYes, the main job
    Daily BudgetThe campaign's budgetSometimes
    Placement, PercentageTop of search and product page adjustmentsSometimes
    Clicks, Orders, Spend, Sales, ACOSPerformance for the date rangeNo, 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, not 0.25 or 25%.
    • 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 rate

    Here 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.

    TargetClicksOrdersBid nowCeilingNew bidOperation
    Keyword A403$0.30$0.31 (7.5% CVR)$0.25Update
    Keyword B250$0.28$0.21 (5%)$0.17Update
    Keyword C60$0.20$0.21 (5%)$0.20blank
    Keyword D122$0.15$0.21 (5%)$0.17Update
    Keyword E350$0.22$0.21 (5%)pausedUpdate
    Keyword F00$0.10$0.21 (5%)$0.10blank

    How each decision was made:

  • Keyword A has 3 orders, so its own rate counts: 3 / 40 = 7.5%, ceiling $4.14 x 7.5% = $0.31. Its bid of $0.30 sits right at break-even, so it comes down to 80%, $0.25. It sells; it was just costing almost all of the royalty.
  • Keyword B has no orders, so the cautious 5% applies: ceiling $0.21, bid $0.17. It isn't paused yet; 25 clicks at 5% would expect about one order, which is not enough to call it dead.
  • Keyword C has 6 clicks. That says nothing either way, so the row stays blank and the bid stays.
  • Keyword D has 2 orders on 12 clicks, a lovely rate on a tiny sample. With fewer than 3 orders it gets the cautious ceiling, and a raise to $0.17 rather than a jump to its own rate.
  • Keyword E has 35 clicks and no order. At 5% that is about 1.75 expected orders, and none came. Its State changes to paused. Our post on when to pause a keyword covers the click count in more detail.
  • Keyword F gets no impressions at all. A small test raise is an option, but nothing in the file says it will help, so it stays blank this round.
  • 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:

  • Filter the Operation column. Count the rows marked Update, Create or Archive. If you meant to change 40 bids and it says 400, stop: a fill-down went too far.
  • Look at the Bid column of the marked rows. Sort it high to low. A bid of 3.0 where you meant 0.30 shows up at the top.
  • Check the percentages. Every value in the Percentage column of a marked row should be a whole number.
  • Never edit an ID. If an ID cell looks different from your untouched copy, put the old value back.
  • Prefer paused over archived. Seller Labs' bulk operations guide notes that archived items can't be switched back on. Pausing keeps the option.
  • Upload, then read the results. The same guide notes Amazon offers a download of the rows that failed. Open it, fix those rows in a new file, and upload only them.
  • 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

    P

    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.