When it comes to importing your data, such as orders, customers or products, into Brightpearl, you're going to need it formatted in a way that Brightpearl recognizes.
Formatting dates for import
When importing data, dates will need to be formatted in a specific way so that Brightpearl is able to read them correctly.
| Data Type | Format Required |
|---|---|
| Date | YYYY-MM-DD |
| Date / Time | YYYY-MM-DD hh:mm:ss |
How to format dates in Excel for imports
- Click on the column header to select the entire column. In this case it's column H, so click on the grey box with H in it. The whole column will be highlighted.
- Right-click anywhere on the highlighted area to display the menu.
- Select Format cells.
- In the displayed window, in the Number tab, select Custom from the category list on the left.
- If the format you need is already listed it can be selected. If it is not listed use the Type field above to enter your own, "yyyy/mm/dd hh:mm:ss".
Note: The date only format can be found under the Date category.
- Once you have selected or entered the format you need, click the OK button.
- Save your Excel file.
You are now ready to import it into Brightpearl.