Skip to content

Import marketplace orders from a file ​

Sell on TikTok Shop, Temu, Facebook Marketplace, Amazon or eBay? Export your orders from the marketplace, then use Import on Online orders (/online-orders) to bring them into Retailer OS. Your sales, fees and shipping addresses end up in one place next to your other orders.

You choose how each line matches your items, and stock comes off for completed, shipped and delivered orders once you say the matches are right.

NOTE

Amazon and eBay also have a live connection under Setup → Marketplaces. If you use it, file orders never duplicate what it already brought in, and a file import will not take stock for that marketplace. See Amazon and eBay: files and the live connection.

How the import works ​

  1. Export your orders from the marketplace (steps for each one are below).
  2. Open Online orders and click Import.
  3. Drop in your file (.csv, .xlsx, or the .txt file Amazon gives you). You can add up to 3 files at a time, each up to 5 MB, up to 2,000 orders in total.
  4. Retailer OS checks the file and shows you a preview: how many orders are new, how many were already imported, total sales and fees, and any rows it could not read. Nothing is saved yet.
  5. Next comes the review screen, where you see how each product matched your items, choose the warehouse the stock comes from, and can mark open orders as completed. See Match items and take stock.
  6. Click Import and take stock to confirm. A progress bar shows while the orders are added.

You need permission to manage online orders and marketplaces. Owners, admins, managers and operators can import; cashiers cannot.

Limits ​

  • Up to 3 files at a time, each up to 5 MB.
  • Up to 2,000 orders in one import. For more, import in batches (for example, one month at a time).
  • Up to 500 different products in one import. If your file has more, split it.
  • Only orders in US dollars are imported. Orders in another currency are listed as problems in the preview and skipped.

What you get ​

  • Each order appears in Online orders, numbered like your other orders, dated with the date the buyer placed it (not today).
  • Sales, tax, shipping and marketplace fees are recorded when the file has them. Marketplace fees show in the order and in your reports; for Temu, shipping-label costs are counted inside the fees and listed separately in the fee breakdown.
  • Sales tax that the marketplace collects and pays itself (Amazon and eBay do this) is recorded for information only.
  • Each order carries a channel badge (Facebook, TikTok Shop, Temu, Amazon or eBay) so you can filter by it. See Online orders & fulfilment.
  • Customers are not messaged, and nothing is sent back to the marketplace. This is a record of orders, not a live connection.
  • Importing the same order twice is safe. It is skipped and shown as Already imported. If an order changed in a later file, the first version is kept.

Shipping addresses ​

To ship an order you need the buyer's address, and not every export has one. Some marketplaces hide the buyer's name and address once an order is delivered, and some files never include it.

Open orders that arrive with no address are still imported, but they are marked Can't ship – no address, and you cannot add a label or tracking until you type in the delivery address on the order.

How to get the file ​

How much we have tested ​

MarketplaceLayoutStatus
TikTok ShopStandard order exportIn use
TemuStandard order exportIn use (menu names vary by region, see below)
eBayOrders report, plus the optional Transaction reportBased on the published layout, not yet tested on a real export from a store
AmazonOrder Reports (tab-delimited .txt)Based on the published layout, not yet tested on a real export from a store
Facebook MarketplaceOur own templateOurs, so it always matches

Where a layout is marked Based on the published layout, we built it from the marketplace's own documentation and have not yet run it against a real export from a store. If your totals look off, tell us and send a sample file. We will fix it.

TikTok Shop ​

Export from TikTok Shop Seller Center (seller-us.tiktok.com, or the Seller Center for your country).

Orders (needed)

  1. In Seller Center, go to Orders → Manage Orders.
  2. Use the tabs and filters to pick what you want: for example All orders, or To ship for orders you still have to send. Set the date range.
  3. Click Export and download the file once it is ready.
  4. Import that file into Retailer OS.

Fees (optional, adds precision)

TikTok's order export carries sales and tax but not every fee. Settlement amounts are in the finance reports:

  1. Go to Finances → Statements.
  2. Choose the period and click Export.

Statements are for your own bookkeeping today; the order export is what you import.

TIP

Export To ship orders separately from delivered ones. The To ship export is the one that includes the buyer's shipping address.

Temu ​

Export from Temu Seller Center (seller.temu.com, or the seller site for your region).

  1. In Seller Center, open Orders and choose the list you want (for example, all orders, or orders waiting to ship).
  2. Set the date range and use Export (or Download) on the order list.
  3. Download the file (.csv or .xlsx) and import it into Retailer OS.

WARNING

Unconfirmed steps. Temu does not publish its export instructions publicly, and the menu names differ between Temu seller regions and change from time to time. If you do not see an Export button on the order list, ask your Temu account manager or open a support ticket from Seller Center, or send us one of your exports and we will check that it imports correctly.

eBay ​

NOTE

Based on the published layout. We built this from eBay's published report layout and have not yet tested it on a real export from a store. If totals look off, tell us and send a sample.

Orders report (needed)

  1. In Seller Hub, go to Reports → Download.
  2. Choose the Orders report.
  3. Pick the dates. You can ask for 1 to 90 days at a time.
  4. Start the download. When it is ready, the file appears under Recent downloads. Download it.
  5. Import that file into Retailer OS.

Transaction report (optional, for fees and refunds)

The Orders report does not carry eBay's selling fees or refunds. To add them:

  1. In Seller Hub, go to Payments → Reports and request the Transaction report for the same dates.
  2. eBay emails it to you when it is ready.
  3. Drop it into the same import as the Orders report. Retailer OS joins the two files by order number.

What is in the Orders report: one row per item bought, the buyer's shipping name and address, the price paid, buyer-paid shipping, the tax eBay collected, the total, and dates for payment and shipment. eBay's report has no status column, so Retailer OS works out the status from the dates: orders with a shipped date count as shipped, paid orders without one are open, and unpaid orders are listed as problems and skipped.

Amazon ​

NOTE

Based on the published layout. We built this from Amazon's published report layout and have not yet tested it on a real export from a store. If totals look off, tell us and send a sample.

  1. In Seller Central, go to Orders → Order Reports.
  2. Choose a report type and a date range, then request the report. You can pick:
    • All Orders: every order in the dates you choose.
    • Unshipped (also called the shipping report): only orders waiting to ship. This one includes the buyer's name and address.
  3. Amazon makes the file in the background. It can take a while, sometimes close to an hour, so request it ahead of time. When the status says it is ready, click Download.
  4. You get a tab-delimited .txt file. Import it as it is. There is no need to open it in a spreadsheet and save it again.

Things to know:

  • The All Orders report has no customer name or street address (only city, state, ZIP and country). Those orders are imported, but you cannot mark them shipped from here. Use the Unshipped report for orders you still need to ship.
  • Orders Amazon ships for you (Fulfilled by Amazon, or FBA) are recorded but never take stock, because the stock sits in an Amazon warehouse, not yours.
  • Orders Amazon still shows as Pending have too little detail. They are listed as problems and skipped; import them once they are no longer pending.
  • Amazon's fees are not in these order reports, so fees show as zero.
  • Prices are for the whole line. Retailer OS divides by the quantity to get the unit price.

Facebook Marketplace ​

Facebook does not give sellers an order export. So for Facebook Marketplace you fill in our template and import that.

  1. On Online orders, click Import, choose Facebook Marketplace, and click Download the template.
  2. Open the template in Excel, Google Sheets or Numbers.
  3. Add one row for each item sold, using the columns below. The two example rows have an Order ID that starts with EXAMPLE. They are skipped when you import, so you can leave them or delete them.
  4. Save as .csv (or .xlsx) and import it.
ColumnWhat to put in itNeeded?
Order IDAny number or name you choose. Rows with the same Order ID become one order. If you leave it blank, we make one up from the date, buyer, item and price, so importing the same file twice never doubles up.Recommended
Order dateThe day the buyer paid, like 2026-03-14.Yes
Item titleWhat you sold.Yes
SKUYour SKU, if you have one. This helps it match your catalogue.Recommended
QuantityA whole number.Yes
Unit priceThe price for one, in US dollars.Yes
ShippingWhat the buyer paid you for shipping.Optional
TaxSales tax you collected.Optional
StatusSold, Pending or Paid (open), Shipped, Delivered, Cancelled or Refunded. Blank means open.Optional
Buyer Name, Buyer Phone, Address 1, Address 2, City, State, Zip, CountryThe delivery details, if you ship the order.Optional
Tracking Number, NotesAnything you want to keep with the order.Optional

Example

Order IDOrder dateItem titleSKUQuantityUnit priceShippingStatus
FB-10012026-03-14Puddlejump Wooden Train SetPJ-TRAIN-01124.005.00open
FB-10012026-03-14Puddlejump Stacking CupsPJ-CUPS-0228.50open
FB-10022026-03-15Puddlejump KitePJ-KITE-07112.004.00shipped

This makes two orders. FB-1001 has two lines and FB-1002 has one.

Facebook Marketplace Shops (with Facebook or Instagram checkout) is a different thing. See Marketplaces we cannot import yet.

What is in each file ​

TikTok ShopTemueBayAmazon (All Orders)Amazon (Unshipped)Facebook (template)
Buyer's addressOnly on To ship exportsOnly for orders waiting to shipYesNo (city, state, ZIP only)YesIf you fill it in
Marketplace feesNo (see Statements)YesOnly with the Transaction reportNoNoNo
Sales taxYesYesYes (collected by eBay)Yes (collected by Amazon)Yes (collected by Amazon)If you fill it in
Shipping paid by buyerYesYesYesYesYesIf you fill it in
SKU on each lineYesYesYour Custom labelYesYesIf you fill it in

Match items and take stock ​

After the preview, the review screen lists each product in the file, not each order. A file with 2,000 orders of the same 40 products shows 40 rows, so you only check each product once.

For each product you see:

  • the marketplace's title, SKU or listing number,
  • how many orders it is in, and the prices and quantities,
  • the item in your catalogue it matched, and how it was matched,
  • your stock now, and what it will be after the import,
  • any flags that need your attention.

Use the tabs to switch between Needs attention, Matched, Not matched and All. To change a match, pick a different item in that row. To say a line is not one of your items, pick No item; it is then kept as text and never touches stock.

How a match was found ​

The badge on each row tells you how Retailer OS matched it. Matching tries these in order and stops at the first hit:

BadgeWhat it means
SavedYou matched this product before and we remembered it.
SKUThe marketplace SKU is exactly the same as an item's SKU.
BarcodeThe marketplace barcode (UPC or GTIN) is the same as an item's barcode.
ListingIt is the same listing as one in your connected Amazon or eBay catalogue.
You pickedYou chose the item yourself on this screen.
SuggestedA guess based on similar names.

IMPORTANT

A Suggested match is never used on its own. It only counts if you click Use this on it. Until then the line is kept as text and does not touch your stock.

Matches you fix by hand are remembered for next time, so the next import already shows them as Saved. They are only saved when you confirm the import. If you close the review screen without importing, nothing is saved.

Flags in plain words ​

Flags are short notes on a row. Some are only information, some need a tick, and some stop that row from taking stock.

You seeWhat it meansWhat to do
Price more than 25% differentThe marketplace price is far from your item's price. A warning.Check that it is the right item. It is covered by the box at the bottom.
Price more than 60% differentAlmost certainly the wrong item, or the wrong price.Tick Yes, this is right on that row, or change the match. Without the tick the row cannot take stock.
Item is archivedThe matched item is archived.Pick another item. An archived item cannot take stock.
Quantity is not a whole numberFor example 1.5 or blank.Fix it in the file, or leave the line out of stock-taking. That row cannot take stock.
Totals do not add upThe lines, shipping and tax do not add up to the order total in the file.Look at the order. Often a discount or a missing line.
Not enough stockThe import would take more than you have. It shows how many are short.For open orders your store's setting decides whether that goes negative or to backorder. Shipped and delivered orders already left your shelf, so they take your count below zero instead of creating a backorder. Check your count.
Large quantityA single line with a very big number.Check it is not a typo.
Same item twiceTwo products in one order matched the same item of yours.Check they should both be that item.
Amazon is fulfilling thisAn FBA line.Nothing. It never takes stock.
No matchNothing in your catalogue fits.Pick an item, or leave it as text.

Orders you already have ​

If an order in the file is already in Retailer OS (you imported it before, or the live Amazon/eBay connection brought it in), the review screen shows a red warning: N orders in this file are already in Retailer OS. They will NOT be imported again. Click Show which orders to see the order id, the Retailer OS order number it matches and the date. These orders cannot be ticked. If every order in the file is already there, the import button is switched off and says Nothing new to import. The server also refuses duplicates, so importing the same file twice never counts an order or its stock twice.

Take stock, step by step ​

Stock always comes off for orders that are completed, shipped or delivered. Past orders you import are history of goods that already left your shelf, so their quantities come off your count. You do not need to switch anything on.

  • Cancelled orders and orders refunded in full never take stock.
  • Amazon FBA lines never take stock (the stock is in Amazon's warehouse).
  • A line only takes stock if it is matched to one of your items and you confirmed the match. Unmatched lines are imported as text and leave stock alone.

WARNING

If your old system already took stock off for orders that shipped, importing them takes those units off again. Check that your counts do not already include these orders, or leave those orders unticked on the first screen.

Mark open orders as completed ​

Orders that are still open in the file (not shipped yet) are normally imported as open. If you already fulfilled them, for example because you are importing past orders, turn on Mark open orders as completed on the review screen. They land in Completed, take their quantities off stock, and nobody has to open each one. Shipped and delivered orders are always Completed.

To import with stock coming off:

  1. On the review screen, check the warehouse the stock comes from (your default is picked for you).
  2. Go through the rows. Fix any match that is wrong. Tick Yes, this is right on any row that asks for it.
  3. Read the line at the bottom, for example Remove 12 units across 5 items from Main warehouse.
  4. Tick I checked the items, prices and quantities. The button stays off until you do.
  5. Click Import and take stock.

Good to know:

  • Stock only comes off after you tick I checked the items, prices and quantities. This is enforced when the import runs, not just on the screen.
  • A line you did not confirm (a Suggested match you did not use, a row with no match, a row that needs a tick you did not give) never touches stock. The order is still imported.
  • If Amazon or eBay is connected live for that marketplace, the live connection already manages stock, so a file import does not take any. The screen says so and the button reads Import orders (no stock change).

Amazon and eBay: files and the live connection ​

If you connect Amazon or eBay under Setup → Marketplaces, their orders already arrive on their own. A file is useful for older orders, or if you have not connected. Retailer OS keeps the two from clashing:

  • No double orders. If an order in your file was already brought in by the live connection, it is skipped and counted as Already imported, even though it came from a different place.
  • One way to take stock. While a live connection exists for that marketplace, a file import will not take stock. The live connection already does it, and doing it twice would count the same item twice. The screen shows a note explaining why.
  • No later updates for file orders. The live connection keeps its own orders up to date (shipped, cancelled and so on). Orders that came from a file are a record only. They do not get later status changes from the live connection, so update those by hand if something changes.

If you have not connected Amazon or eBay, none of this applies: file imports work like any other marketplace, and completed orders take stock.

Marketplaces we cannot import yet ​

No order-file export exists ​

These marketplaces do not let sellers export an order file, so there is nothing to import. We will add them if that changes.

MarketplaceWhy
WayfairOrders are passed on only through a connection set up by Wayfair, not a download.
Target PlusOrders are only available through a connection set up by Target, not a download.
Alibaba.comThere is no order download for sellers.
SheinThere is no order download for sellers.
Facebook and Instagram Shops (checkout on Facebook or Instagram)Meta does not give sellers an order file for these. For Facebook Marketplace listings, use the template.
WooCommerceThe built-in export has no item lines or addresses without an extra plugin.

Coming next ​

We plan to add file import for Shopify, Etsy, Mercari, Faire, BigCommerce, Walmart, Newegg, Best Buy, Poshmark and Depop. If you sell on one of these and want it sooner, tell us and send a sample export.

Files in a different layout ​

Retailer OS recognises the standard export layouts above for free. If a file looks different (for example, you renamed columns), you will be asked to confirm the marketplace, and AI matches the columns. The AI only looks at the column names and a few sample rows to work out which column is which. It never reads out or invents your orders. This uses a small amount of AI credit, about 1 to 3 cents a file, and needs permission to spend AI credits. Fees are not available in a file matched this way.

Undoing an import ​

If something looks wrong, contact support with the import's date and the file name. An import can be undone as a whole, which removes the orders it added and puts back any stock it took.