BC Export to TeamPOS Converter
Instructions:
- Upload your BC Export .xlsx file
- The converter will map the data according to the specifications below
- UoM conversions are automatically applied if configured in the admin panel
- Download the converted .xls file for TeamPOS
🔧 Admin Panel - Manage UoM Conversions
| TeamPOS Column |
BC Export Column |
Notes |
| SKU |
Item No. |
Direct mapping |
| PURCHASE QUANTITY |
Quantity |
Direct mapping |
| UNIT COST (BEFORE DISCOUNT) |
Sales Amount (Actual) ÷ (Invoiced Quantity × Conversion Factor) |
Calculated field |
| DISCOUNT PERCENT |
- |
Set to empty |
| TAX NAME |
- |
Set to empty |
| LOT NUMBER |
Lot No. |
Direct mapping |
| MFG DATE |
- |
Set to empty |
| EXPIRY DATE |
Expiration Date |
Date format converted to yyyy-mm-dd |