Skip to content
SellSail
Selling on OnBuy

OnBuy bulk upload: how to list hundreds of products at once

How to bulk upload products to OnBuy: preparing your catalogue, EANs and SKUs, pricing that covers fees, common errors, and keeping listings up to date.

By the SellSail team · Updated · 6 min read

Customer signing for a parcel delivery

Key takeaways

  • Bulk upload saves hours once you have more than a handful of products.
  • Clean data first: valid barcodes, unique SKUs, accurate stock and prices that cover OnBuy fees and VAT.
  • Upload a small test batch, fix the errors, then upload the rest.
  • After upload, prices and stock still need regular updates, ideally automated.

Bulk uploading to OnBuy means creating or updating many listings at once from a file or an integration, instead of one by one. It is the fastest way to grow a range, but it only works well when your data is clean: valid barcodes, unique SKUs, real stock levels and prices that cover OnBuy's fees.

When is bulk upload worth it?

  • You have more than about 20 products to list.
  • You update prices or stock across many listings regularly.
  • You are moving a catalogue from another marketplace or a supplier feed.

For a few products, the single-listing form is fine.

How do you prepare your catalogue?

FieldWhat to check
Barcode (EAN/GTIN)Valid, and matches the exact product variant
SKUUnique to you, readable, consistent (SKU generator guide)
PriceCovers cost, OnBuy commission, VAT and your minimum profit
StockReal, available quantity
ConditionNew, refurbished and so on, as OnBuy requires
DeliveryMatches what your supplier can actually achieve

Barcodes matter most: OnBuy matches many products to its catalogue by barcode, so a wrong EAN puts your offer on the wrong product. Our guide to EAN, ASIN and GTIN explains the differences.

How does the bulk upload process work?

  1. Get the current template or tool from your OnBuy seller dashboard, or connect an integration that uses the OnBuy API.
  2. Fill in a test batch of 10 to 20 products.
  3. Upload and read the error report. Fix every rejected row.
  4. Check live listings: right product, right price, right stock.
  5. Upload the rest in batches.

OnBuy's tools and templates change over time, so always download the current version rather than reusing an old file.

What are the most common errors?

  • Invalid or missing barcodes.
  • Duplicate SKUs across rows.
  • Prices with currency symbols or commas in a numeric column.
  • Required fields left blank.
  • Stock written as text ("in stock") instead of a number.

How do you price a bulk upload correctly?

Every row needs a price that covers the supplier cost, OnBuy's commission on the selling price, VAT if you are registered, and your minimum profit. Doing that by hand across hundreds of rows invites mistakes. The OnBuy fee calculator shows the sum for one product; our guide on how to price OnBuy dropshipping shows how to set bands for a whole catalogue.

What happens after the upload?

Uploading is a one-off; keeping listings right is ongoing. Supplier prices and stock change daily, and so do competitors. Bulk listings need:

  • Price updates when your costs change.
  • Stock updates so you never sell what your supplier can't send.
  • Competition checks so you stay competitive without dropping below your floor.

SellSail imports your OnBuy listings, links them to Amazon UK products and keeps every price and stock level up to date automatically, so a 2,000-product upload stays as accurate as a 20-product one.

Frequently asked questions

Can I bulk upload products to OnBuy?
Yes. OnBuy offers bulk tools for sellers, and integrations and the OnBuy API can also create and update listings in bulk. Check your seller dashboard for the current options and templates.
Do I need EAN barcodes to list on OnBuy?
Most branded products are matched to OnBuy's catalogue by barcode such as an EAN. Check OnBuy's current listing rules for your category, including any exemptions.
Why did my OnBuy bulk upload fail?
Common causes are invalid or missing barcodes, duplicate SKUs, wrong column formats, missing required fields and prices or stock in the wrong format. Fix the rows the error report names and upload again.
All articles

Keep reading

Set sail with SellSail

Start your 14-day free trial. No card needed, cancel any time.