Importing Packaged Products (Final Products)

Use the packaged products import feature to bulk-add your finished beer inventory to BarSight. This is useful for importing existing stock counts, updating prices across multiple products, or migrating data from another system.

Before You Start

• Prepare your data in a CSV (comma-separated values) file
• Ensure you have access to Brewery → Final Products
• Have your product names and package types already set up in BarSight
• Know your SKUs and/or UPCs for each product variant

Accepted CSV Column Headers

BarSight recognizes the following column headers in your CSV file. You can use either the Primary Header or any of the Alternative Headers - they will be automatically matched.

Primary Header	Alternative Headers	Description	Required
Product	-	The beer/product name (must match existing product in BarSight)	Yes
Package	Container	Package type (e.g., "6-Pack Cans", "500mL Bottle", "50L Keg")	Yes
SKU	-	Your internal stock-keeping unit code	No
UPC	-	Universal Product Code (barcode number)	No
Stock	Available Count	Current quantity available for sale	No
Price	-	Selling price per unit	No
Deposit	-	Container deposit amount (if applicable)	No
Visible	-	Whether product appears in ordering portal (Yes/No or 1/0)	No
Tax	-	Tax code or tax rate to apply	No
Stock Id	-	Internal ID for updating existing stock records	No

Step-by-Step Import Process

Step 1: Prepare Your CSV File

1. Open your spreadsheet application (Excel, Google Sheets, etc.)
2. Create columns using the headers from the table above
3. Enter your packaged product data, one item per row
4. Save or export as a CSV file

Example CSV structure:

Product,Package,SKU,UPC,Stock,Price,Deposit,Visible
Pale Ale,6-Pack Cans,PA-6PK,123456789012,48,14.99,0.60,Yes
Pale Ale,50L Keg,PA-50L,,12,195.00,50.00,Yes
IPA,500mL Bottle,IPA-500,234567890123,120,6.99,0.10,Yes
Stout,4-Pack Cans,ST-4PK,345678901234,36,12.99,0.40,No

Step 2: Upload the File

1. Navigate to Brewery → Final Products
2. Click the Import button
3. Select your CSV file
4. Click Upload

[SCREENSHOT: Final products import dialog]

Step 3: Map Your Columns

1. Review the column mapping screen
2. BarSight will automatically match recognized headers
3. For any unmatched columns, use the dropdown to select the correct mapping or choose -Unused- to skip
4. Click Continue

[SCREENSHOT: Column mapping with Package and Product fields highlighted]

Step 4: Review and Confirm

1. Preview the products that will be imported
2. Check for any errors - particularly products or packages that don't match existing items
3. Click Import to complete the process

Tips and Best Practices

• Products must exist first: The Product name must exactly match an existing product in BarSight. Create products first via Brewery → Products
• Package groups must exist: The Package name must match an existing package group. Set these up via Brewery → Packaging Settings
• Use consistent naming: "6 Pack" vs "6-Pack" vs "6pk" will not match - use exact names from your system
• Update stock carefully: Importing stock quantities will set the current count - make sure your numbers are accurate

Troubleshooting

Problem: Product not found

Solution: The product name in your CSV must exactly match an existing product in BarSight. Check spelling and capitalization, or create the product first.

Problem: Package type not recognized

Solution: Use Package or Container as your header. The value must match an existing package group name exactly.

Problem: Stock count shows as zero after import

Solution: Ensure your Stock or Available Count column contains numeric values only - no text, currency symbols, or formatting.

Problem: Prices not importing correctly

Solution: Price values should be numbers only (e.g., 14.99 not $14.99). Remove currency symbols and thousand separators.