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.

Common use cases for the Product Catalogue

• Wanting to pick/pack from DEC but need to specify where the items are stored? Use the product catalogue to specify the location of each item. This will be printed on the packing slips and displayed in the UI.
• Missing item dimensions when creating packages? Specify the dimensions of each product and configure your packages to be based on these item dimensions (link to set up packages guide for more info)
• Shipping internationally and missing crucial customs details like HS codes and COO? Configure these in the product catalogue and we'll ensure they're submitted to the courier for you.
• Is the item name on your storefront causing hold ups at customs and you want to overwrite it with something more customs friendly? Set the customs description for your items using the PC and we'll update this for you when you ship your orders.
• Dont have item weights loaded up in your platform? Set them in DEC so we can ensure your quotes are correct and your couriers are happy.

How it works

Add a new product to the Product Catalogue

• In your DHL Express Commerce account, select Products from the left menu.
• Click Add New.
• Enter your product details.
• Click Save to save.

Edit product details

• Select Products from the left menu.

• Locate the product you wish to edit by either searching in the search field or scrolling to the desired product row.

• Click on the specific field you want to edit within the respective product row.

• Update the necessary product details.
• Save your changes by clicking tab or any other section of the page.

Note: If the field you intend to update is not visible, click on the cog icon to select and display the field.

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
• Ensure there are no commas in any fields (e.g. Shirt, with pants).

How to import a product using a CSV file

• Select Products from the left menu.
• Click More actions.
• Click Import CSV file.
• Click Browse and choose the CSV file from your computer.
• Click Upload.

Important: You can only import CSVs using our preformatted template. To download this template, click on pre-formatted CSV template as shown in above modal.

How to enable Product Catalogue to populate all values during order import

• In your account, go to Settings.
• Select Product Catalogue from the left menu.
• Tick to enable Override all values.
• Click Save.

Note: When this feature is enabled, any order with a SKU matching a SKU in the Product Catalogue will have all product fields filled with those in the Product Catalogue.

How to enable Product Catalogue to populate missing values during order import

• In your account, go to Settings.
• Select Product Catalogue from the left menu.
• Select Only populate missing value.
• Click Save.

Note: When this feature is enabled, any order with a SKU matching a SKU in the Product Catalogue will have missing product fields filled with those in the Product Catalogue.

How to enable to add missing items to Product Catalogue during order import if the item doesn’t exist in the Product Catalogue

• In your account, go to Settings.
• Select Product Catalogue from the left menu.
• Select When importing orders, add items to the Product Catalogue if the items doesn’t match an existing SKU.
• Click Save.

Note: When this feature is enabled, any order with a SKU that doesn’t have matching SKU in the Product Catalogue will automatically be included in the Product Catalogue.

How to disable Product Catalogue from populating values during order import

• In your account, go to Settings.
• Select Product Catalogue from the left menu.
• Untick to Disable the Product catalogue.
• Click Save.

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?

Yes this is possible, please follow the steps here

There are no bin locations importing from my eCommerce platform. Can I use the product catalogue to address this issue?

You can upload a CSV file containing the SKUs of your products along with their respective bin locations. Upon importing your orders into DEC, we will be able to link the SKUs and automatically include the bin locations. This will greatly facilitate your order fulfillment process, as the DEC packing slips will now include this vital information for your convenience.