Importing customers is the fastest way to add or update customers in DecoNetwork. To import customers, you need to have all your customer information in a CSV file, which can be edited as a spreadsheet. You can create the CSV file by downloading the sample CSV file or you can export your existing data. Click here for instructions on how to export customers.
When you import, the column headers in the CSV file will be matched with the corresponding customer fields in DecoNetwork and the customer information will be added or updated accordingly. You can also import data for custom fields. Before importing, you must first add custom fields in your Fulfillment Center Admin. Click here for instructions on how to add custom customer fields.
Prerequisites
- You must have Administrator and/or Sales Manager permission to use this feature.
In this article...
- To create the Customers CSV file using the supplied Sample CSV
- To import customers
- To import data for custom fields
To create the Customers CSV file using the supplied Sample CSV:
- Log into your DecoNetwork website.
- Browse to Business Hub > Customers.
- Click on Import Customer CSV.
The Import Customers popup is displayed.
- Click on the Download Sample CSV File link.
Depending on your browser settings, the sample file, customers.csv, will be immediately downloaded to the default download location or you will be prompted to choose a download location.
The Customers CSV file will have all the required column headers required for a complete customer record.
The following information can be imported for each customer:
- Account ID: the identification number of the customer account.
- Login: the username for the customer account.
- Email: the email address of the customer.
- Salutation: the customer's title.
- First name: the customer's first name.
- Last name: the customer's last name.
- Date the customer was added: the date on which the customer account was created.
- Phone number: the customer's phone number.
- Billing address: the address where billing information will be sent to.
- Billing City: the city where billing information will be sent to.
- Billing State: the state where billing information will be sent to.
- Billing Country: the country where billing information will be sent to.
- Billing Zip: the post/zip code where billing information will be sent to.
- Shipping address: the address where orders will be delivered.
- Shipping City: the city where orders will be delivered.
- Shipping State: the state where orders will be delivered.
- Shipping Country: the country where orders will be delivered.
- Shipping Zip: the post/zip code where orders will be delivered.
- Company name: the name of the company that the customer belongs to.
- Credit allowance: the total amount of credit allocated to the customer for making website purchases.
- Discount: the percentage discount that is applied to each order the customer places.
- Credit Balance: the amount of unused store credit remaining of the total credit allowance.
- Store ID: the identification number of the store the customer is registered under.
- Newsletter opt-in: the opt-in status of the customer for receiving marketing newsletters.
- Order count: the total number of orders the customer has placed.
- Total order value: the total value of all orders the customer has placed.
- Outstanding balance: The current amount owing on orders.
- Tax Exempt: a true or false value indicating whether the customer is tax exempt.
- [Custom fields]: any custom customer fields that have been defined.
- Enter your customer information into the Customer CSV file and save it.
To import customers:
- Click on Import Customer CSV.
The Import Customers popup is displayed.
- Tick or un-tick the checkbox options as required:
- Create website account creates an account allowing the customer to log in to your primary DecoNetwork store.
- Send welcome email sends a welcome email to the customer.
- Resend welcome email if user already exists re-sends a welcome email to the customer if the customer already exists in your DecoNetwork system.
- Add customers as Company contacts will add new customers and their orders to a company record if the company name specified for the customer matches an existing company in the system. If the customer already exists in the system, the customer's details will be updated and their quotes and orders added to the matching company.
-
Click on the Browse... button.
- Locate your customers.csv file and click Open in the File Upload dialog.
- Click Okay in the Import Customers popup.
An Import Progress popup will be displayed with a progress bar to show you the progress of the import. On completion of the import, a message will be displayed informing you of the success or failure of the import. If the import failed, a list of errors will be shown in the popup.
To import data for custom fields:
- Add custom customer fields from the Customer Settings section of your Fulfillment Center Admin. Click here for instructions.
- Export the Customer CSV file as per instructions above for creating the Customer CSV.
- Enter the data for the custom fields into the Customer CSV.
- Import the Customer CSV as per the instructions above for importing the Customer CSV.
Comments
9 comments
I assume at this point that custom fields are not available for import?
The sample csv does not include them?
Also, curious - will multiple imports update client info or create duplicate records
-Tommy
Hi Tom,
Custom fields are not supported at this time.
Entering the correct ids into the id field will ensure customer records are updated and not duplicated.
So I've done some testing and see import does update with an edited export list, using the id as a key I assume.
I suggest adding a bit more to help page in regards to what happens without an email address - it has a blank Login that will populate once an email is entered into the account and saved.
Regarding updates, its confusing because in my testing, reusing the Sample CSV File did indicate some updates but for records with email it does not.
However, if you export the customers, edit the records and import that edited list - it works perfectly - only updating records - likely because the ID is present.
So this could be explained a bit more.
-Tommy
Is there a limit on how many records can be imported in a file? I have 19,000 customer records in csv.
I have tried splitting it up, and can get some imports run in batches of 500, but it still seems to give errors and only import a few sometimes.
Thanks,
David.
Hi David,
There is no limit on the number of records. The errors may be due faults in your CSV file. Can you please submit a support ticket so that one of our client services team members can help you troubleshoot.
Regards,
Lee
Hey, looks like custom fields import is now available - cool!
what about credit_allowance? looks like that field exports, but is not included on downloaded csv template for import.
I assume this will not import, even if I add the column to csv?
-Tommy
SUGGESTION: The only way I could get custom fields to import was by making them visible with Register.
Often, we only want fields for HUB use. Would be helpful if custom fields imported if only visible for Quotes/Orders
Hi Tom,
The credit_allowance field, although not included in the Sample CSV, will import if added to the CSV.
Thank you for your feedback. You are correct, custom fields currently will only import if configured as visible under Register in the Field Usage Definitions.
Regards,
Lee
Please sign in to leave a comment.