How to import products with Excel in Books?
TB Books · data-migration · Last updated October 13, 2026 · Version 1
This process works in apps: TB Books, TB Sync, TB WMS
This article will teach you how to bulk-load the product catalog (and optional on-hand qty) with the Data Migration wizard.
Organization Settings → Data Migration bulk-loads your product catalog from Excel/CSV — the same wizard Sync and WMS use. The flow is upload → map fields → review → import; there is no separate download-template-only path required to begin. When quantity and cost are mapped, Books posts inventory adjustments and a journal entry for inventory value.
Steps
- Go to Settings → Data Migration (Organization Settings).
- Under Imports, pick Product Catalog.
- Upload your Excel/CSV file. Under Select Your Header Row, click the row that contains the column names. That row is marked HEADERS and fills Map Catalog Fields. If a dropdown shows a part number or a price, click the header row again.
- Map columns to Tire Base fields (MFG/part number, brand, size, description, cost, price, quantity, and optional Image 1–3 URL columns).
- Review the preview row-by-row for obvious mapping mistakes.
- If you mapped Quantity, select the target wms-locations location and choose Update Only or Full Replace.
- Click Confirm & Import and wait until the job shows complete.
Conclusion & best practices
Mapped Quantity + Cost creates inventory adjustments and Books posts a JE for that value. Update Only is safer day-to-day; Full Replace can zero SKUs missing from the file. Bulk imports do not create Global Catalog recommendations — that is intentional to avoid flooding review queues. If the mapping dropdowns show part numbers or prices, click the header row under Select Your Header Row — see How to change the column header row on a vendor file or catalog import?. Map Image 1–3 to image URL columns when the file has photos; Tire Base tries to download and save unique images, and keeps the original URL if a download fails (those photos can break if the source website goes down).