The uploading process is comprised of 2 main steps:
Step 1: create an Excel file.
Every row in the Excel file represents an Account or customer. The columns contain different properties for each Account.
The names and order of the columns is not critical, you can map your headers to Pepperi fields using a simple mapping tool as described below.
To make things quick and easy it is recommended you download the template Excel file and add your Account information to that template.
You can get a template in one of two ways:
1. Export your existing Accounts excel file from the Pepperi Web Admin (go to Accounts, click Import and then click the arrow for export).
2. Download the Accounts Sample File attached to this article.
Once you downloaded the sample file you can insert your data while maintaining the column structure.
For a detailed description of all the fields and more aspects of the import process refer to this article which contains the list of Account fields and their meanings: Explanation of Account fields.
Points to Remember:
- The mandatory fields are a unique Account ID and Account Name
- The file must be saved as an Excel workbook (xls, xlsx).
- Must not contain formulas, images, or currencies
Once your file is ready continue to Step 2.
Step 2: Map your Excel column headings to the Pepperi fields.On the Pepperi Manager Go to Accounts -> Import/Export Tab
In the Import/Export Tab click on the import icon and browse to your file.
If you already have Accounts in the system, you will be brought directly to the advanced mapping screen in our Wizard.
If you imported a file with the same column heading names as you have previously uploaded, Pepperi will remember your mapping and display it to you for review.
Review every field's mapping; review those fields that are already marked in blue as mapped and select a mapping for those that are not by selecting from the pull down menu.
If you need help selecting the correct field from the pull down menu refer to the meanings of the fields here: Explanation of the Account fields.
Click Finish and after a few minutes your Accounts will be uploaded and you'll be directed to the listing of Accounts in the import/export tab.
Please note that the headings you had in your excel file will serve as the names of the properties in Pepperi where property names are referenced.
Also, the names of the headers in your Excel file will be the column headings used in the Items list view in Pepperi Manager.
Once your file is mapped click Next Step -> Load Structure
You can also upload a list of contacts for each of your accounts in bulk. See the article: How To Upload Contacts to Accounts
If your Accounts did not load as you expected or you received an error message, look through the Error Log in order to determine the problem. How to Access the Pepperi Error Log
There is no Account > Upload, do you mean ERP Integration > Upload?
Please sign in to leave a comment.