From the supplier's spreadsheet to your import file.

Step 1

Setup

Setup is easy, and we do it for you. Send us a recent file from each supplier and tell us what your system imports. We build the setup for each supplier: which of their columns become which of yours, plus any rules you want applied. You check the first result, and from then on we look after everything.

• Markups and price rounding
• Category and brand matching
• SKU prefixes and supplier code lookups
• Australian date and number formats
• Rules a value must pass, such as "price is above zero" or "every row has a SKU"

Step 2

Sending files

Pick whichever suits you. Most people forward the supplier's email.

• Email. Forward or auto-forward supplier emails to your BridgeSeal address.
• Upload. Drop a file on your upload page.
• SFTP or API. For suppliers or systems that send files automatically.

Excel (.xlsx, .xls) and CSV files are supported, including files with title rows, logos, notes and totals around the data.

Step 3

Checking

Before anything is converted, BridgeSeal finds the real header row and compares it with the layout we set up. If a column we need is missing or renamed, the file is held.

After converting, every row is checked against your rules. A file that fails is held too. Nothing half-right is delivered.

The alert names the columns and rows at fault. It never includes your data. We update the setup and re-run the file.

Step 4

Delivery

The converted file is emailed to you or your team, in the format your system imports. Every run is logged: which file came in, how many rows went out, and what was held.

Systems we can produce files for include:

• Shopify
• Lightspeed
• Maropost (Neto)
• WooCommerce
• Square
• MYOB
• Xero
• Your own system's CSV or Excel template

The same approach works for any file one business sends another in the wrong shape: purchase orders, freight invoices, timesheets, POS takings, insurance bordereaux and registry reports. If you rework a partner's file by hand every week or month, ask us.