You can maintain a product master in 12return to support the returns process.
The product master serves several purposes:
Purpose | Description |
Create a return | Create a return in the return portal or merchant dashboard by selecting a product from the product master in stead of using data from an external source. |
Enrich data | Products from an external source (API, Order Connector) can be enriched with data from the product master. |
Trigger features | Several features, such as custom attributes and asset grading sets can be triggered for a product group or product. |
Receive returns | Data from the product master can be used for the operations process in Return Dock. |
The product master includes to levels:
Level | Description |
Product group | Product groups that contain products. |
Product | Individual products that below to a product group. |
Set up product groups
Product groups are set up for each channel (portal). This allows you to define which products groups are allowed to be returned in a certain channel.
Product groups can be created in two ways:
Manual
Automatic during import of products
Each product group can be linked to a product group from an external source (API or Order Connector) by inserting the Matching Value from the external source. With this option, the product group can be matched.
Under a product group, processing and disposition data can be maintained for the operations process in Return Dock.
Several features can be triggered at the product group level:
Asset grading sets
Custom attributes
Setup products
Products are set up for each channel (portal). This allows you to define which products are allowed to be returned in a certain channel.
Products can be created or uploaded in settings/channels/products
Product parameters
Each product, once created is directly searchable for by the customer in the portal when adding a product. Each product can also be edited and removed.
Products have different sections that each control a part of the returns process:
Section | Description |
General | General information about the product such as model number, description, SKU, and article type (see below). |
Pricing | Different prices that are relevant for the product and that are used in the returns process. |
Authorization | Parameters that can be used in automation rules to authorize a product. |
Processing | Instructions and images that can be used in the Unpack and Inspect activities in Return Dock. |
Disposition | Parameters that can be used for the disposition of a product. |
Customs | Parameters that can be used for the disposition of a product. |
Settlement | Parameters that can be used adding an administrative product (see below). |
Article type
In the general parameters you can define the type of article with 2 options:
Catalog: a catalog item can be selected when a return is created. By default a catalog item is flagged as returnable but can also be flagged as non-returnable;
Service: a service item cannot be selected when a return is created. By default, a service item is flagged as non-returnable. With Return Profiling Automation Rules a service item can automatically be added to a return.
Administrative product
In the settlement parameters you can define an administrative product. The administrative product, as maintained in the product master, can be added to the product in a return and can be used for settlement in an external system.
Administrative products are not functionally used or exposed in 12return.
You can add an administrative number, an administrative description, and additional data fields.
The additional data fields for a product can be set up as Product Master custom attributes.
For each return policy, it can be defined if and how the administrative product is added: never, always, controlled by flag from external source.
The flag from the external source can be included in the Create Return API and Order Connector.
The administrative product is sent to an external system with the Return Alert.
Import
Importing products
If you have a large number of products or a catalog that changes on a semi-regular basis, you might want to use our data import function. This function lets you import .csv files with your products and will create new products or update existing ones. Product groups will be automatically be created.
Information about data import can be found here.
Import restrictions
Currency
The currency that is being uploaded must be set up in the master data of your account settings. Only a single currency setup is supported. Currencies need to be uploaded in the following formats:
Currency | Format |
Euro | EUR |
United States Dollar | USD |
Weight Unit of Measure
The weight unit of measure that is being uploaded must be set up in the master data of your account settings. Weight Unit of Measures need to be uploaded in the following formats:
Weight Unit of Measure | Format |
Kilogram | KG |
Gram | G |
Product Groups
Product groups are created on the fly if they do not exist. Products are added to them dynamically if they do exist. For more information about product groups, see the product group page.
Parent Product Groups
Parent Product Groups are not created and are only used to confirm the proper Product Group should more than one share the same name. Relations between Product Groups and Parent Product groups are not created during import, these types of configurations need to be manually confirmed in the product group admin screen.
Importing customs values
Importing one or multiple Country of Origin needs to be done as follows:
Type | Description |
Default COO | The 2 digits country code can be added in column "DefaultCountryOfOrigin" |
Additional COO | The 2 digits country code can be added in columns "CountryofOrigin" or "CountryofOrigin_1". When you want to upload more COOs, you can insert a new column "CountryofOrigin_2" or further. |
Importing customs HTS codes need to be done as follows:
Type | Description |
HTS code global | 6 characters |
HTS code USA | last 4 characters of 10 digits code |
Taric code EU | last 4 characters of 10 digits code |
HS code UK | last 4 characters of 10 digits code |
The Customs Description is mandatory for using customs declarations.
Excluded from import
The following can not be imported and needs to be imported or set product-by-product:
Type | Description |
Processing | Images need to be imported into the image gallery and linked to a product manually. |
Settlement | Linking a replacement product needs to be done manually. |
Disposition | Linking a default vendor needs to be done manually. |
Import results
If the import of a record in the .csv file fails, the entire import will not be executed.
Using products
Product Parameters
For each return policy, you can control how products are used to create a return. These settings are controlled in settings/return policy/parameters/product feed