Purpose: This article introduces the Products feature, showing you how to upload and manage product data to improve warehouse efficiency and how it interacts with other settings.
What is the Products feature
The Products feature is designed to give you direct control over essential data for your SKUs in Sendcloud. With a simple CSV upload, you can add details like warehouse location and customs information.
During this Beta phase, you can:
- Set Item Location for each SKU, allowing pickers to find items faster and plan routes efficiently within the warehouse.
- Add EAN Codes for each SKU, enabling item scanning if your shop does not support it. Learn more about item scanning here.
- Complete or override Products data coming from your webshop when the information is missing or you want to change it
Why Item Location Matters: By uploading item locations, you can access these details in picking lists, helping pickers locate items quickly, reduce movement across the warehouse, and organize picking routes by location, ultimately enhancing productivity and reducing search times.
How to Add and Set Up Your Products
| 1. |
Navigate to Settings > Products and click Get Started.
|
| 2. |
Download the CSV Template: This file contains columns for SKU, Item Location, and additional fields for customs (to be enabled later).
Important: When editing the CSV template, do not delete any columns, even if you don’t need them. If a column is not required, simply leave it empty. Removing columns will change the file format and may cause an error when uploading.
|
| 3. | Fill in Product Information: Each product should be identified by a unique SKU. Only Item Location will be used in this Beta release. |
| 4. |
Upload Your File: After filling in the CSV, upload it to Sendcloud. You can update product information anytime by uploading a new CSV; existing data will be replaced for the specified SKU. Important: If you want to update existing products, upload a new CSV file that contains:
Sendcloud will automatically match each SKU and update its data. No new products will be created, and no duplicates will appear in your list.
|
| 5. |
Customize Your Display: Choose which columns to display in your product table by selecting the column icon.
|
Managing your products
Take full control of your product data with the Products feature. Learn how to manage your product catalog efficiently: add new items, update existing details, preview key information, and organize your data.
Adding Products
Expand your product catalog:
- Go to Settings > Products and click New Product.
- Fill in the required fields, such as SKU, Name, and Location, along with optional fields like HS Code or EAN Code.
- Once complete, hit Save, and the product is added to your list instantly.
Modifying Products
Keep your product information up-to-date:
- Click the three-dot menu next to the product you want to update.
- Select Edit, make your changes, and click Save to ensure accuracy across your orders and warehouse operations.
Bulk Deleting Products
Simplify the cleanup of your product list:
- Select the checkbox next to the products you want to delete.
- To remove all visible items, use the checkbox at the top of the list to select everything on the page.
- Click Delete and confirm your selection.
Fields Overview
With the Beta version of Products, the only fields that will be used in Sendcloud are SKU and Location, to be used in the picking list.
Here is a detailed overview of the fields:
| Field | Character Type | Additional Info | Example Value |
|---|---|---|---|
| SKU | String (75 characters) | SKU is used to link your shop products to the products you upload in Sendcloud. Ensure it matches your webshop SKU. Sorting is alphabetical. | T0023 |
| Name | String (255 characters) | This will override the information from the shop. | Toothpaste Extra-white 75ML |
| Location | String (24 characters) | Sorting is alphanumeric. Example: A35, A123, A5 (sorted: A5, A35, A123). | B-29 |
| Weight | Digits | This will override the information from the shop. Use "." as a decimal separator. Weight is in KG. | 0.09 |
| HS Code | String | This will override the information from the shop. | 8517.13.0000 |
| Origin Country | String (2 characters) | This will override the information from the shop. Use ISO 3166-1 alpha-2 2-letter code. | NL |
| EAN | Digits | This will override the information from the shop. Remove any spacing between digits. | 123456789123 |
| Value | Digits | This will override the information from the shop. Use '.' as a decimal separator. Value is in the account currency. Maximum 10 digits. The value represents the sales price of the product, not the purchase cost. | 20.99 |
| Material Content | String (255 characters) | This will override the information from the shop. | 100% cotton |
| Intended Use | String (255 characters) | This will override the information from the shop. | For use as a house or gardening plant |
| MID Code | String (15 characters) | This will override the information from the shop. | AUOZR92MEL |
Using Item Location in Picking lists
-
Enable Product Location in Picking Settings: To display item locations in picking lists, go to Shipping > Printing Options. In the Picking Lists section, select "Item Location" and "Show location", then click on update settings.
- Order Picking: Once enabled, your pickers can see the item location in picking documents, improving efficiency and accuracy.
FAQ
What is Integration Data?
Integration Data is the initial product information imported from your shop’s integration. It serves as the base layer for all product data in Sendcloud.
How do Products interact with your Integration?
Any updates you make through the Products feature will override the Integration Data. This allows you to adjust product information directly in Sendcloud, providing more control over specific SKU details.
How do Shipping Rules interact with Products?
Shipping rules can be applied to individual products and will take priority over the details you’ve set in the Products feature or imported from your shop’s integration. This means any shipping rule you set will be used first, above other product data.
What role do Manual Modifications play in data priority?
Manual modifications made directly to an order in Sendcloud have the highest level of control and will override all other data layers, including Integration Data, Products Data, and Shipping Rules.
What currency is used for customs values in Products?
The item value is automatically set to your account's currency, which is also the currency displayed on customs documents. Therefore, it is not possible to change this currency.
I encountered an error: "Field format not valid" when uploading my products. What should I do?
This error means the uploaded file doesn’t meet the required format. To fix this, check the data in your CSV file and ensure it matches the format guidelines provided in the template. Pay attention to these common requirements:
- SKUs must not exceed 75 characters
- SKUs must not contain commas or points (e.g., using periods in SKUs can cause an error like "SKU column doesn't exist")
- EAN codes should be written without any spaces between digits
Replacing points with dashes in SKUs is a safe workaround and should allow your upload to proceed successfully.