Menu Close

Get Support From ShopWired Close

All Systems Are Operational

Subscribe To Updates
Prefer To Live Chat? Chat directly with ShopWired support Available 9.00am to 7.00pm Monday to Friday
11.00am to 5.00pm Saturday
Quickest response time

Send A Message
Response within 24 hours

Menu Close

Menu

Importing/exporting trade customers in bulk

You can import trade accounts in bulk onto your account using a spreadsheet upload. These trade customers will then be able to login to their accounts on your website as if they’d created an account themselves.

Additionally, you can also take an export of all of the trade accounts that currently exist on your account.

• Exporting trade customers
• Preparing the import file
• Saving the spreadsheet
• Importing the file


Exporting trade customers

To export your trade customers into a CSV spreadsheet select B2B > View Trade Accounts from the menu. In the top right corner select Export:

A box will then appear. Select prepare your export and allow the system to process your spreadsheet:

Once the system has finished processing the spreadsheet select download your export and the file will be downloaded to your computer’s hard drive:


Preparing the import file

By using a spreadsheet upload you can import trade accounts in bulk to your account. The spreadsheet must be in a specific format in order to process correctly.

To obtain a template of the spreadsheet select B2B > View Trade Accounts from the menu. In the top right corner select Import:

A new box will appear. Select download the import template here:

An editable CSV file of the template will then be downloaded to your computer's hard drive.

Each trade customer should be placed on a new row of the spreadsheet.

The template has the following fields to be filled in:

First Name
Last Name
Date Of Birth
Company
Email Address
Phone
Mobile
Address Line 1
Address Line 2
Address Line 3
City
State/County
Postcode
Country
In this field place the name of the country the customer is from. The name of the country must be entered according to the names specified in the system. If you don't use the approved name the country information will not import correctly. Download the list of countries here:

XLS
country names

Password
Enter a password for the customer’s account which they will then be able to change later.
Reward Points Balance
This field will be available to you if you are using the reward points app.
Website
VAT Number
Global Discount
If the trade customer is to be given a global discount enter it in this field, using only numbers.
Credit Account
If the trade customer has a credit account enter Yes here.
Trade Pricing Band
If you are using the trade pricing bands feature enter the exact name of the band in this field. If the name does not exactly match a trade pricing band it will not work.
Source
This field will be available to you if you are using the how you heard about us app.
Additional Data 1
In the 5 additional data fields you can enter any internal notes you want to store on the trade customer’s account.
Additional Data 2
Additional Data 3
Additional Data 4
Additional Data 5

Saving the spreadsheet

In order to successfully upload, the spreadsheet needs to be saved as a CSV file. If you are using an Apple computer save the file as a ‘Windows Comma Separated (.csv)’ file. The upload will not process if the spreadsheet is in any other format.


Importing the file

To upload your file and import the trade accounts go back to your ‘Trade Accounts’ page and select Import to see this box again:

Select Choose file and find the spreadsheet in your computer’s hard drive.

Once you have attached the file select import.

Allow the system to process the file. If you are uploading a large file it might take some time to process, but don't navigate away from the page. Once the file has uploaded you will see an 'Import completed' success message.