Import products from a CSV file

Load your product list (or customers, suppliers, employees and more) from a spreadsheet in three steps — upload, map columns, review and import.

How-toUpdated

You can save a spreadsheet from Excel or Google Sheets as a CSV file and import it into BuiltOFFICE.

Import products#

  1. Go to Inventory → Products and tap Import. You can also go to Reports → Import / Export → CSV Import and pick Products.
  2. Upload: tap Download Template if you want a file with the right columns. Fill it in. Then drop your file on the page or tap Choose CSV.
  3. Map Columns: BuiltOFFICE matches your columns to its fields. Check each one. Set a column you don't need to — Skip this column —. Product Name and Sell Price are required.
  4. Tap Continue to Review.
  5. Review & Import: check Total rows, Will import and Blocked. Blocked rows have a problem, such as a missing price.
  6. Tap Import N rows.
Mapping columns in the CSV import

What else you can import#

On Reports → Import / Export → CSV Import, pick what to import:

  • Products
  • Customers
  • Suppliers
  • Employees
  • Categories
  • Inventory Adjustments (stock changes)
  • Price List
  • Serialized Inventory

The same list also has:

  • Taxes — tax rates, matched by tax name.
  • Product Groups — groups and the products in them.
  • Promotions — matched by promotion name.
  • Loyalty Tiers — matched by tier name.
  • Store Settings — settings exported from another store.
  • Quick Buttons — these belong to each register, so import this file on the till instead (Store Management → CSV Import). In BuiltOFFICE every row is skipped with that message.

Rows that update an existing record count as imported. If the server refuses a batch for one of these six, the reason is shown (for example, an entity that works on BuiltPOS cloud stores only).

Export your data#

  • For customers, suppliers, employees and categories, tap Export current … to CSV on the import page.
  • For products, use Export on the Products list.
  • The Data Export & Bundles tab can export the whole store, or import a Store Data Bundle (.zip) made by another BuiltPOS store.

Good to know#

  • Files can be .csv, .txt or .tsv.
  • Only the store owner and admins can import. Managers see the Import button but can't use the import page.
  • Always check the Review & Import step before you tap import. It shows exactly how many rows will go in.
  • On a legacy Windows POS store, only the product import works. Every other import and export is refused.
  • To change many existing products at once (prices, categories, suppliers), use Stock and price changes instead.

Was this helpful?

Still need help?

Open a ticket from the app

In any BuiltSOFTHUB app, open Help & Support and choose Report a problem. Our replies appear under My tickets.

Email us

Write to support@builtsofthub.com. Tell us the store name and what you were doing when it happened.