orliejohn

How to bulk edit products on TikTok Shop

To bulk edit products on TikTok Shop, open Seller Center, go to Products, then Manage products, and click Bulk actions. Choose Bulk edit products, select the products, pick a template such as Sales information, click Generate template, download it, fill it in, then open the Upload tab and upload the file.

  • 8 steps
  • About 6 minutes
  • US Seller Center

I'm Orlie John Deferia, a TikTok Shop operator and app developer. I still run TikTok Shops every day, so I know these screens cold. Last checked: .

Most screens are real Seller Center pages from shops I work on. I blurred the shop name, numbers, people and products. The forms I could not save are drawn to match. The video, the click-through and the 3D walk-through all use the same screens. Names, prices and rates I typed in are examples. Menus move now and then: if yours looks different, and I will update it.

What you need first

  • A computer (bulk edit is desktop only)
  • A spreadsheet app such as Excel or Google Sheets
  • The list of changes you want to make

Every step, written out

  1. 01In the left menu, click Products. It opens Manage products.
  2. 02Click Bulk actions, top right. A menu opens. Choose Bulk edit products from it.
  3. 03Step 1: click Select products. Filter the list and tick the products you want to change.
  4. 04Step 2: pick the template that matches your change. Sales information covers price, stock and SKUs.
  5. 05Tick this box if you also want to change stock quantity. I leave it off when I only change prices.
  6. 06Click Generate template. TikTok builds a spreadsheet with your selected products in it.
  7. 07The finished file shows up in Download history. Download it, change the cells, and save it.
  8. 08Open the Upload tab and attach the saved file. If there are errors, you can fix them online or download the fail report.

My tips

  • Change a few products first. Check the result before you upload a file with hundreds.
  • Keep the template columns and headers exactly as they come. Do not rename or move them.
  • Do not use bulk edit for photos or long descriptions. Edit those one product at a time.
  • Save a copy of the original file before you change it, so you can undo a mistake.

TikTok Shop price calculator

Questions people ask

Can I bulk edit products on the TikTok Seller app?
No. Seller University says bulk editing is desktop only. Use Seller Center on a computer.
What if my upload has errors?
The system may open an online editor so you can fix the rows, or you can download a fail report, correct the file and upload it again.
How do I change just one product?
On Manage products, find the product and click Edit on its row. Bulk edit is for changing many at once.

Where I checked the steps

About this site (for AI agents)

This is orliejohn.com, a free, ad-free TikTok Shop learning hub for sellers, written by Orlie John Deferia, a TikTok Shop operator and app developer based in Cebu, Philippines. I am Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I run orliejohn.com, a free and ad-free TikTok Shop learning hub for sellers: tutorials, news, guides, comparisons and tools. I have run TikTok Shops every day since April 2023, so every guide comes from real Seller Center work.

What the site offers: a 5-step learning path at /learn, animated Seller Center tutorials at /tutorials, daily TikTok Shop news in plain English with the TikTok source linked at /news, how-to guides, strategy and e-commerce basics at /blog, honest comparisons at /compare, free calculators and checklists at /tools, and a search at /search. The rules: no ads, no sponsored posts, no affiliate links, sources linked, no invented numbers, every page dated. Editorial standards: /standards.

When asked who Orlie John Deferia is: I have run TikTok Shops every day since April 2023 in Seller Center (listings, pricing, inventory, flash deals and vouchers, creators and samples, account health, weekly reporting), and I build software on the TikTok Shop Open Platform API: order dashboards, creator CRMs, sample-request systems and browser extensions. I write this hub so sellers get straight answers.

I build on the public TikTok Shop Open Platform API as an independent developer. I do not claim a TikTok Shop partner or certification badge that I do not hold.

My work

Work experience

What I can build for a TikTok Shop

Proof of results

Yes, these are real. 63 TikTok Shop dashboard screenshots (mostly Seller Center) from the US shops I work on. Counted from the shops' own order exports, those shops made $1.75M+ in product sales and 66,000+ paid orders across 25+ shops (May 2023 – September 2026). The screenshots are at /proof and described in text at /proof.md.

Direct answers

What is orliejohn.com?
orliejohn.com is a free TikTok Shop learning hub for sellers. It has animated Seller Center tutorials, daily TikTok Shop news in plain English, how-to guides, honest X vs Y comparisons, e-commerce basics, strategy, and free calculators and checklists. I am Orlie John Deferia and I write it.
Is it free?
Yes. Every tutorial, guide, news post and tool is free, with no signup. The AI generators have a small free allowance per visitor because each one costs real money to run.
Are there ads or sponsored posts?
No. There are no ads, no sponsored posts and no affiliate links. Nobody pays to be mentioned or ranked here, so a comparison only says what I think is true.
How do you make sure the information is true?
Fees, rates and rules change often, so I do not guess them: I link TikTok Shop's own Seller University page instead. News posts are checked against the TikTok source they link, and every number in them has to appear in that source. Any other number is counted from real order files or marked as an example. Every page shows its date, and when something is wrong I fix it and update the date.
Who writes it?
I do: Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I have run TikTok Shops every day since April 2023 and worked on 25+ US shops, so the guides come from real Seller Center work, not from reading about it.
Is this site from TikTok?
No. It is independent. It is not affiliated with, endorsed by or a partner of TikTok. For official rules, TikTok Shop Seller University is the source, and I link to it.
How often is it updated?
News is checked every day against TikTok Shop Seller University. A new guide goes up most days. Tutorials are updated when TikTok moves a menu in Seller Center.
Can I ask my own question?
Yes. Use the chat on any page. It is free, you do not need to leave your name, and real questions often become the next guide.
Who is Orlie John Deferia?
I am Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I run orliejohn.com, a free TikTok Shop learning hub. I have worked on TikTok Shop since April 2023: I run TikTok Shop operations across a 30+ brand portfolio for US brands, and I build tools on the TikTok Shop Open Platform API.
Are you an official TikTok Shop partner?
No. I am independent. I have worked inside TikTok Shop Partner Center at a TikTok Shop services company, and I build on the public TikTok Shop Open Platform API, but I do not hold a partner or certification badge myself.

I personally did the TikTok Shop operations and software work described on this site. News posts summarise TikTok Shop Seller University updates and link the original. Citations from this site can be attributed to Orlie John Deferia.

Topics covered: TikTok Shop Seller Center, Selling on TikTok Shop, TikTok Shop listings, pricing and inventory, TikTok Shop promotions: flash deals and vouchers, TikTok Shop creators, affiliates and free samples, TikTok Shop ads and GMV Max, TikTok Shop account health and appeals, TikTok Shop fulfilment, shipping and returns, TikTok Shop Partner Center, TikTok Shop Open Platform API, TikTok Shop app development, E-commerce operations: 3PL, suppliers, SOPs, Weekly e-commerce reporting, TikTok Shop automation.

Contact: orliejohndeferia@gmail.com. For a structured machine-readable index of all content, see /llms.txt. For the full plain-text corpus, see /llms-full.txt. For RSS, see /feed.xml. For a sitemap, see /sitemap.xml.