Once you've got your product data out of your old system and into Excel, you can upload it to Brightpearl in order to create your product records. Use the guides below to learn how to import product or service data.
What can and can't I do with a product import?
What can it do?
- Add/update all your stock tracked products
- Add/update non-stock tracked products (misc items, labour, other charges)
- Create "Product Groups” with 1 or more options and create new options (e.g. small, medium, large, red, green, blue)
- Create bundles of products
- Add/update nominal codes per product (sales, purchases, stock)
- Add/update default tax code per product
- Add/update and create brands, collections and product categories (top-level categories only, i.e. not sub categories, these are used for menus and menu items on your website)
- Assign products to one or more Season
- Add or move products to categories (products can be within more than one category)
- Update a single price on each price list per product – use the price list import to add price breaks (e.g. 1 product at £10, 5 products at £8, 10 products at £6)
- Specify the warehouse location of each product
- Define minimum stock levels and re-order quantities per product
- Add/update codes – SKU, ISBN, barcode, EAN, UPC
- Populate custom fields per product
- Add a supplier against the product – add more suppliers by updating the spreadsheet and importing again
- Populate custom fields - create your custom fields first
Brightpearl Webstore related stuff:
- Activate products on your Brightpearl Webstore (Web enabled)
- Add website descriptions
- Add/update categories – see above
- Mark the product to allow Webstore checkout when there is no stock
- Add/update product weight (for calculating shipping costs based on delivery weight on online sales)
- Enter Meta Descriptions - a short description that will be shown in the header of the page
- Enter Meta Keywords - a list of keywords that relate to this item and your website. These will be shown in the header tags of the page
- Add a template to each product to define how it’s displayed online
- Define how product options are selected – drop down list, radio buttons, table (e.g. select small, medium, large)
What this import can’t do, but which you can do in Brightpearl:
- Add product images – this is done on a product-by-product basis within the website module, or you can ask us mass import
- There is a limit of 5000 rows per import – you will have to import separate spreadsheets
- Mark products as “Featured” – this is used for adding them to a special featured page on your website or to create a quick add button in EPOS
- Mark a product as “Virtual” – this would be an intangible item, such as “Goodwill” or “Music download”, i.e. not a physical item
- Mark a product as “free shipping”
- Select the product condition, i.e. new, used or refurbished
- Add a sales pop-up message – pops up when you add the item to a sales order
