When uploading Accounts the address field is the Billing Address of the Account. The shipping address shown on the order PDF and cart is editable at the time of the order (the default is the same as the billing).

If you require multiple shipping addresses, meaning you have one main office for the billing address with different branches for shipping then you can upload chain stores or multiple locations.

If you require this, then use this article instead: Uploading Accounts with chain Stores / branches.

If you do not require multiple shipping addresses then continue with these instructions:

 

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.