Takealot stock recon
Feb 5, 2026 by Dihan Stoltz · 8 min read
If you sell on Takealot through their fulfilment network, there is a very real chance that stock has gone missing in their warehouses and you are owed money for it. Products get lost during transfers between distribution centres, damaged during handling, or incorrectly scanned — and unless you actively reconcile your inventory, those losses go unnoticed. A Takealot stock recon is the process of comparing what Takealot says they have in their warehouses against what you actually sent them. When there are discrepancies, Takealot refunds you. The problem is most sellers either don't know this process exists, or they find it too tedious to do regularly. This guide walks you through exactly what a stock recon is, why you should be doing one every quarter, and how TSeller turns what used to be hours of spreadsheet work into a few clicks.
What Is a Takealot Stock Recon?
A stock recon — short for stock reconciliation — is a formal process where you ask Takealot to verify the physical inventory they hold for you across their distribution centres. You submit a list of your TSINs, Takealot checks their warehouse records, and if units are missing or unaccounted for, they issue a refund to your seller balance. This covers stock that was lost in the warehouse, damaged beyond sale, misplaced during DC-to-DC transfers, or cancelled by Takealot due to a DC stock enquiry — meaning a customer placed an order but the warehouse couldn't locate the product to fulfil it. These cancellations show up in your Seller Portal under Sales with the status 'Cancelled by Takealot – DC Stock Enquiry'. Every one of those represents a unit you paid to ship to Takealot that they could not find when it mattered.
Why Most Sellers Never Do a Stock Recon
The honest answer is that the manual process is painful. To do a stock recon without any tools, you need to export your cancelled sales from the Seller Portal, filter for the DC Stock Enquiry cancellation reason, extract the TSIN numbers, download the stock query template from Takealot, paste your TSINs into the template, submit a support ticket through the correct form, wait for a response, then generate and send an invoice for the refund amount. Each step involves navigating different parts of the Seller Portal, working with spreadsheets, and dealing with Takealot's ticketing system. For sellers with dozens or hundreds of SKUs, this process can take hours. And because it's tedious, sellers put it off — sometimes indefinitely. The result is thousands of rands sitting on the table that never get claimed. Takealot won't proactively tell you that stock is missing. The responsibility is entirely on the seller to identify discrepancies and raise them.
How Often Should You Run a Stock Recon?
At minimum, every 90 days. Takealot's internal processes and the volume of stock moving through their warehouses mean that discrepancies accumulate over time. The longer you wait between reconciliations, the harder it becomes to track down what went missing and when. Running a recon every quarter ensures you catch issues while the trail is still fresh and Takealot's records are still accessible. Some high-volume sellers run monthly recons because the amount of stock moving through DCs creates more opportunities for things to go wrong. If you're shipping hundreds of units per month across multiple distribution centres, monthly reconciliation is worth the effort — especially when the process is automated.
The TSeller Stock Recon Workflow
TSeller's Stock Recon feature was built specifically to eliminate the friction that stops sellers from reconciling regularly. The entire workflow — from downloading your recon data to generating the invoice you submit to Takealot — happens inside TSeller Web.
Step 1: Download Your Stock Recon File from Takealot
Start in your Takealot Seller Portal. Navigate to Manage my Offers, and at the bottom right you'll find the option to download the Stock Query Template. This is a spreadsheet that Takealot uses as the standard format for stock recon submissions. Download it and keep it ready — you'll upload it into TSeller in the next step.
Step 2: Upload the Recon File into TSeller
Open TSeller Web and navigate to the Stock Recon section. Upload the stock query template you downloaded from Takealot. TSeller reads the file and prepares it for processing. There's no need to manually edit the spreadsheet, copy-paste TSIN numbers, or cross-reference anything in Excel. TSeller handles the data extraction automatically.
Step 3: Automatic SKU Matching
Once the file is uploaded, TSeller matches the TSINs against your product catalogue. It identifies which products need reconciliation, cross-references quantities, and flags discrepancies between what should be in the warehouse and what Takealot's records show. This step alone saves significant time — manually matching TSINs across spreadsheets is where most sellers make errors or give up entirely.
Step 4: Generate Your Invoice
After reviewing the matched data, TSeller generates a properly formatted invoice that you can submit directly to Takealot. The invoice includes all the required TSIN numbers, quantities, and values that Takealot needs to process your refund. No more creating invoices from scratch in Word or Excel and hoping you've included everything Takealot requires.
Step 5: Submit Your Stock Recon to Takealot
With your invoice ready, submit your stock recon ticket through Takealot's support system. Select 'Manage my Offers / Bulk stock query (template upload)' as the query type, attach the completed template and your invoice, and submit. Takealot will review the submission and respond with the refund amount to be credited to your seller balance.
What Happens After You Submit
Once Takealot receives your stock recon submission, their warehouse team verifies the discrepancies against their physical records. This process typically takes a few business days depending on volume. They'll respond with a breakdown of what they've confirmed as missing and the refund value. In some cases, Takealot's support team may ask for additional context on why you're submitting the recon. A straightforward response — that you're reconciling cancelled orders with the DC Stock Enquiry reason — is all that's needed. After confirmation, you send them the invoice (which TSeller has already generated for you), and the refund amount is credited to your Takealot balance. This isn't a complicated dispute process. It's a standard procedure that Takealot has in place — it just requires sellers to initiate it.
The Real Cost of Not Reconciling
Every quarter you skip a stock recon is a quarter where lost inventory goes unrecovered. The amounts vary depending on your catalogue size and order volume, but even small sellers regularly discover discrepancies worth several thousand rand. For larger operations moving hundreds or thousands of units through Takealot's fulfilment network, unreconciled stock losses can run into tens of thousands per quarter.
Lost Units Add Up Quietly
A single unit going missing doesn't feel significant. But when it happens across multiple SKUs, across multiple DC transfers, over multiple months — the cumulative loss is substantial. Sellers who run their first stock recon after months of inactivity are often surprised by the total refund amount. It's money that was always owed to them but never claimed.
Storage Fees on Phantom Stock
If Takealot's system still shows units in storage that physically aren't there, you may be paying storage fees on inventory that doesn't exist. A stock recon corrects these records, which can reduce your ongoing storage costs in addition to recovering the value of lost products.
Inaccurate Inventory Data Affects Everything
When your stock levels in Takealot's system don't match reality, it creates a cascade of problems. Your replenishment calculations are based on wrong numbers. Your sales forecasts are off. Products show as available when they're not, leading to more DC Stock Enquiry cancellations which hurt your seller metrics. Regular reconciliation keeps your data clean so every other part of your operation runs on accurate information.
Stock Recon Best Practices for Takealot Sellers
Running a successful stock recon is straightforward, but there are a few things that make the process smoother and increase your chances of recovering the full amount owed.
Set a Recurring Schedule
Don't wait until you remember or until something goes obviously wrong. Set a calendar reminder for every 90 days — or every 30 days if you're a high-volume seller. Consistent reconciliation prevents large discrepancies from building up and makes each individual recon faster to process.
Keep Your Product Costs Updated
Your refund is calculated based on the cost value of the missing products. Make sure your product costs in TSeller are accurate and current so that invoices reflect the correct values. Outdated cost data means you could be under-claiming on legitimate losses.
Monitor DC Stock Enquiry Cancellations
Between formal recons, keep an eye on your cancellation reasons in the Seller Portal. A sudden spike in DC Stock Enquiry cancellations for a specific product might indicate a systemic issue at a particular warehouse — and that's something worth flagging sooner rather than waiting for your next scheduled recon.
Use TSeller to Eliminate Manual Errors
The biggest risk in manual stock recons is human error — missed TSINs, incorrect quantities, formatting mistakes in the template. TSeller's automated workflow removes these risks entirely. The file parsing, SKU matching, and invoice generation are all handled programmatically, so you can be confident that your submission is complete and accurate every time.
Conclusion
A Takealot stock recon is one of the simplest ways to recover money that's rightfully yours. Stock goes missing in warehouses — it's an unavoidable reality of fulfilment at scale. What's avoidable is leaving that money unclaimed. Whether you're a small seller with a handful of SKUs or a large operation moving thousands of units, regular reconciliation should be a non-negotiable part of your workflow. TSeller's Stock Recon feature turns what used to be a tedious, error-prone spreadsheet exercise into a streamlined process you can complete in minutes. Download your file from Takealot, upload it to TSeller, review the matches, generate your invoice, and submit. That's it. If you haven't run a stock recon in the last 90 days, now is the time. You're almost certainly owed money — and TSeller makes getting it back as painless as possible.
