Customer Contact Upload Including Addresses
CUSTOMERS – Contact bulk upload includes address
The customer contact bulk upload csv also has the option of uploading the address at the same time.
To export the template csv file, go to – Admin - Import and Contact Bulk Upload.
Select ‘Contact Bulk Upload’ and export the template:
The template csv is split into two sections:
Contact Details – Columns A to N:
Address Details – Columns P to AA:
In this example I want to add a contact and address to the customer ‘Aus University’:
Enter the existing customer code and name into columns A & B:
Enter the contact details in columns E to N:
Enter address details in columns P to AA:
*In column Y you can enter either ‘Billing’ or ‘Delivery’**You can set the address as the default in column Z
In the ‘Customer Upload’ screen select ‘Contact Bulk Upload and select file and click ‘Create Contacts:
Confirmation will show on successful upload:
Back in the customer record, the new contact and address are entered:
Notes on template
‘Active’ column in Column “N” is for customer details. Marking it as TRUE/YES will reflect in this section in customer details view.
Leaving the column ‘Active’ as blank will mark the contacts as inactive, and contact/s will be hidden from the customer details view.
‘Active’ column in Column AA is for Address details. Marking it as TRUE/YES will reflect in this section in customer details view.
Leaving column ‘Active’ as blank will mark the address as inactive and address will be hidden from the customer details view.
Related Articles
Customer Billing Address and Billing Contact Edit Restrictions
A Customer may only have one Billing type address specified. They can have multiple delivery addresses. A delivery address can be set as the billing address, but it will remove the ‘billing’ flag from the previously set billing address. Two settings, ...Edit Customer
This is where you can view all customers and suppliers you have entered into printIQ. All this is managed from Customers > View Customers. The following box will appear: From here you can click on the customer name to open up the customer ...Bulk Upload IQstore Items
IQ Store Items can be created and modified in bulk using the sales item import / export options on the IQStore Admin screen toolbar. Download the CSV Selecting Import from the drop-down menu will open a file selector to select the CSV for upload. The ...Quoting Upload CSV Field Details
By default quote upload CSV imports live here: You can search your menu using magnifying glass in the menu as per screenshot below. Download the latest CSV Import Template: A CSV file will download, enter required details into the spreadsheet: Column ...Create Customer / Supplier
New Customer The following screen will appear with a customer number and type at the top. The options are Customer, Supplier and Type. The type can't be changed once the customer is created. Add Price Lists Click the plus button next to Price Lists. ...