Importing Your Product Catalog
Bring your product catalog into Floorzap quickly using the import feature. This lets you upload bulk inventory with the right details and formatting, so your records stay organized and up to date. Follow the steps below to import products from an Excel template.
From the main menu, select Inventory.
Click Products.
Select Import Products.
Download the Excel template by clicking the provided link. This template contains all the necessary headers, formats, and step-by-step instructions for filling out each column.
Fill out your inventory details in the Excel template. Follow the on-sheet guidelines to avoid errors.
Back in the system, choose your Vendor.
Upload the completed Excel file.
Map your Excel columns to the system fields. The system usually matches them automatically. Double-check each one for accuracy.
All required fields — including Inventory UOM and Product Cost — must be filled in for the import to succeed. If you enter a Selling Price, Floorzap calculates the Margin % automatically. If you don't, you'll need both a valid Product Cost and a Default Margin Percent, otherwise the margin can't be calculated.
Click Map and Preview to see a list of the products that will be imported.
Review the preview list. Green check marks mean all fields are valid; red exclamation points indicate problems. Hover over any red markers to see what needs to be fixed.
Once everything has a green check, select the items and click Import Selected Products.
If you run into any issues, check the template instructions or the on-screen guidance for help.
Importing Carpet
Carpet is imported differently from other inventory products. Follow the rules in this section carefully — incorrect entries will result in wrong roll counts, sizing errors, or duplicate products.
Carpet is entered by the roll, not by product. Each row in the import sheet represents one physical roll. Entering it any other way will produce wrong roll counts, sizing errors, or duplicate products.
One row = one physical roll. If you have two rolls of the same carpet, enter two rows.
To keep multiple rolls under a single product, use the same SKU on every row for that carpet. Floorzap matches on SKU (per vendor) and files each row as a separate roll under one product — it does not create duplicates. Roll numbers and on-hand roll count are assigned automatically. Use a different SKU only for a genuinely different product.
Quantity = the roll's total square footage (e.g. 186.98) — not the number of rolls. This is the number the system uses to build the roll.
Coverage is ignored for carpet. The system calculates it automatically from Quantity and Carpet Width. Leave it blank — it won't be used.
Carpet Width = roll width in feet (e.g. 12). Required for the size to calculate correctly.
Unit = SqFt or SqYd (how the carpet is priced/measured).
UOM = Roll.
Product Name is required — don't leave it blank.
Roll Length is calculated automatically (Quantity ÷ Carpet Width) — you do not enter it.
Optional roll-tracking columns: Roll No, Dye Lot, Roll Price.
Example — two rolls of the same carpet: Enter two rows, both with SKU 13158, both named Carpet Bed Rock, Carpet Width 12, Unit SqFt, UOM Roll. Put each roll's square footage in its own Quantity cell. Result: one product with two rolls on hand.