SKU mapping, demystified.
One-time setup. Do it yourself in minutes with our guides, or have us set it up for you.
Export your QuickBooks Item List
Lists > Item List > Export in QB Desktop, or Sales > Products and Services > Export in QBO. Save the file.
Upload it to KitchenAPI's SKU Mappings page
We accept CSV (RFC 4180 compliant) or JSON. The upload handles even very large item lists.
Review your mappings
Your mappings load instantly — see every Design Flex SKU alongside its QuickBooks item, with anything unmapped clearly flagged for review.
Save and use
Future Design Flex XML uploads automatically use your saved mappings. Unmapped SKUs are flagged in amber so you can add them as you encounter them.
SKU Mappings
| Design Flex SKU | QuickBooks Item | Status |
|---|---|---|
| KCB-B36-CH | Base Cabinet 36" Cherry | Mapped |
| KWC-W3015-OAK | Wall Cabinet 30x15 Oak | Mapped |
| CT-GRAN-L8 | — | Unmapped |
| HW-PULL-BRASS | Hardware Pull Brass | Mapped |
Time investment
Do it yourself in minutes with our guides, or have us set it up for you. Most dealers map their frequently-used SKUs quickly and add the rest as they appear in real conversions.
Smart features
Bulk import from CSV
RFC 4180 parser handles quoted fields, embedded commas, edge cases. Duplicates flagged with exact row numbers from your source file.
Duplicate detection with row numbers
When your QB Item List has duplicate SKU codes (it happens), we flag them inline so you can clean them up.
Unmapped SKUs flagged every run
Every conversion's mapping report lists the SKUs that appeared but aren't mapped yet — add them as you go.
Match modes
Choose how strictly KitchenAPI matches Design Flex SKUs to your QuickBooks Items.
Exact
Case-sensitive, whitespace-sensitive. Use if your QB names are clean.
Case-insensitive
Ignores capitalization differences.
Normalized (recommended)
Lowercase + trim whitespace. The forgiving default that handles most edge cases.
Ready to map your SKUs?
14-day free trial. Unlimited conversions. No credit card required.