BC LDB Price Import

The Problem

If you're a BC brewery selling through the BCLDB, you know the pain of manually updating wholesale prices, deposit fees, and duty costs every time the LDB sends you a new price list. Updating dozens or hundreds of SKUs by hand is tedious, time-consuming, and prone to errors—especially when you're trying to keep your pricing accurate across different package sizes.

The Solution

BarSight's BC LDB Price Import feature lets you upload the official BCLDB CSV price list and automatically sync all your pricing data in seconds. The system intelligently matches SKUs, updates wholesale prices and deposits, calculates duty costs per unit based on your package multipliers, and ensures everything stays accurate for future orders—without touching your historical data.

How to Use It

1. Navigate to Brewery → Final Products
2. Click the Import LDB Price List button
3. Click Choose File and select your BCLDB CSV export
4. Click Upload to preview the data
5. Review the preview table to confirm SKUs and prices are detected correctly
6. Click Import into Database to apply the updates

[SCREENSHOT: Import LDB Price List button on Final Products page, with preview table showing SKU, price, and deposit columns]

What Gets Updated

The import automatically updates three key areas:

• Wholesale Prices – The per-unit price from the "WHOLESALE PRICE PER SELLING UNIT" column
• Container Deposits – Deposit fees per unit from the "CONTAINER DEPOSIT PER SELLING UNIT" column
• Duty Costs – Excise duty from "DUTY PAID COST PER CASE" divided by your SKU multiplier to get the accurate per-unit cost

The import applies to both batch packages and product packages, so all future orders use the updated pricing. Important: This does not change prices on existing orders—only orders created after the import.

How It Handles Different Package Sizes

Here's where BarSight gets smart: BCLDB gives you wholesale pricing per unit but duty costs per case. If you're selling 4-packs, 6-packs, and full cases of the same product, the duty cost needs to be divided correctly.

BarSight uses your package group's SKU Multiplier setting to automatically divide the duty cost. For example, if the LDB says duty is $48 per case and your package multiplier is 4 (because you sell 4-packs), BarSight stores the duty as $12 per 4-pack. This ensures accurate pricing regardless of how you package and sell your products.

Pro Tip

Before running your first import, double-check that your SKU multiplier values are set correctly in Brewery → Package Settings. This ensures the duty costs are calculated accurately for your specific package configurations.

Learn More

For more information about setting up package groups and multipliers, check out our guide on Package Groups.