Overview
- The Product Catalogue lets you store all relevant details about your products within DHL Express Commerce, including SKU, HS code and bin location. You can then access these details to populate missing values during order import.
- Maintaining a product catalogue in DHL Express Commerce, with all relevant fields, gives you flexibility and makes it easier to maintain and transfer information to DHL.
How it works
Add a new product to the Product Catalogue
- In your account, go to Settings.
- Select Product Catalogue from the left menu.
- Go to Manage your products section.
- Click Add New.
- Enter your product details.
- Click Save to save.
Edit product details
- In your account, go to Settings.
- Select Product Catalogue from the left menu.
- Go to Manage your products section.
- Click the Edit button located on the respective row.
- Update your product details.
- Click ‘Save’ to save.
Import a product using a CSV file
CSV file requirements
- You must add one product/item per line.
- Each product SKU must be unique.
- Variant must be treated as a separate Product SKU
How to import a product using a CSV file
- In your account, go to Settings.
- Select Product Catalogue from the left menu.
- Click Import CSV.
- Click Select and choose the CSV file from your computer.
- Click Upload.
Important: You can only import CSVs using our preformatted template. To download this template, go to the Product Catalogue page, click Import CSV then click Download the CSV template.
Use the Product Catalogue to populate missing values during order import
- In your account, go to Settings.
- Select Product Catalogue from the left menu.
- Tick to enable During import populate missing values from product catalogue.
- Click Save.
Note: When this feature is enabled, any order with a SKU matching a SKU in the Product Catalogue will have all missing fields filled with those in the Product Catalogue.
FAQs
How will enabling the populate missing values from the Product Catalogue affect the HS Code rules that I have set up?
If a rule is set up, it will take precedence over the settings in the Product Catalogue.
What is the process for adding a variant of a product?
Currently, the variant should be handled and added as a distinct SKU.
What happens if I import a CSV file containing SKUs that already exist in the Product Catalogue?
If the SKU already exists in the product catalogue, we will replace the existing values with the imported values.
What will happen if there are duplicate SKUs in a CSV file?
The first occurrence of the SKU is imported. If the product already exists then we’ll replace existing values. Any subsequent duplicates are ignored while flagging SKUs as errors.
Can product details imported from an eCommerce platform be replaced with values from the Product Catalogue?
Currently, it is not possible to replace the product details that have been imported from the eCommerce platform with values from the Product Catalogue. We only populate missing values from the Product Catalogue.