Uploading a product list to Clientbook allows you to quickly add a multitude of products at once. This makes it easier to organize products into collections and send them directly to clients. Follow this guide to prepare and upload your product data efficiently.
Preparing Your Product List
-
File Format: Ensure your file is in a .csv format.
-
Data Fields: Your file can include any or all of the following supported fields:
-
Name
-
Description
-
Brand
-
Price
-
Website URL
-
Image URL (must be a web-hosted URL to the product image)
-
SKU
-
Unique POS Reference Number
-
-
Matching Products:
-
If a POS reference number is provided, Clientbook will match and combine existing products using this number.
-
Products will also be merged automatically based on matching product names or SKUs.
-
If no matches are found, a new product will be created in Clientbook.
-
-
Headers: Make sure your .csv file includes headers that clearly label the sections corresponding to the above fields.
-
Records: Your file should have one record per row.
Example:
| Name | Description | Brand | Price | Website URL | Image URL | SKU | POS Reference |
|---|---|---|---|---|---|---|---|
| Product Name | Example Product | Brand A | 19.99 | www.example.com/1 | www.images.com/1.jpg | SKU1234 | 1001 |
Uploading Your Product List
-
Log In Log into your Clientbook dashboard.
-
Navigate to Setup
-
From the dashboard, go to the Setup section.
-
On the left-hand menu, scroll down and select Data.
-
-
Select Data Upload
-
In the Data section, click Upload.
-
Choose the option to upload products.
-
-
Upload Your File
-
Select the .csv file you want to upload.
-
Mapping and Verifying Your Data
-
Map Columns:
-
After uploading, you will be prompted to map your spreadsheet columns to the corresponding data points in Clientbook.
-
For example, match the “Image URL” column in your file to the “Image” field in Clientbook.
-
-
Clean Up Data:
-
Review the data to ensure accuracy.
-
You can mark any columns as “Ignore” for incomplete or irrelevant data.
-
-
Finalize:
-
Once your columns are correctly mapped and the data is verified, click Next to proceed.
-
Completing the Upload
-
Confirm:
-
Review the final preview of your data and confirm the upload.
-
-
Success:
-
Your product list will now be uploaded to Clientbook.
-
Existing products will be updated, and new products will be created as needed.
-
If you have any questions or need additional guidance contact our Customer Support Team at support@clientbook.com or (385) 352-3518.