Profile manager

CSV Profile manager

Importing and exporting data in dewabit is managed with csv profiles, which you can configure via our CSV profile manager. Apart of our already predefined profiles, you also have the possibility to create your own profiles.

You will find the profile manager in the main menu under Import/Export => CSV => Profile manager.

Profile management

You configure the profiles using the icons which you can find in the upper right corner of the Profile properties area. The icons have the following meaning:

Actions

Create a new profile

Edit an already existing profile

Delete an already existing profile

Export a sample CSV file of the profile on your desktop

Duplicate an existing profile

Actions during a revision

Save changes

Cancel

The profile management is divided into 3 areas.

Profile properties

In this section you can give the profile a name and a description and define other important CSV properties.

Delimiter

The delimiter is used to seperate the individual values within a CSV file. In the following example, the delimiter is a semicolon (;), which separates the part number from the SKU in the first line.

ItemID;SKU
12345;SKU_1

Decimal separator

The decimal separator specifies the separator of decimal numbers. Here you can choose between a comma (,) or a dot(.).

List separator

The list separator combines a list of values within a CSV cell. As an example you see here a CSV in tabular form. In the column Item images the single images are separated by the list separator |. The item with the item id 12345 has 3 images with the values image1, image2 and image3.

Date format

Here you define the date format you want to use for your date values. You can choose between 2 formats.

Profile specification (Items or Orders)

In this section you can specify your profile and choose between Items or Orders. Depending on the selection, options and mapping fields will differ.

Items

When you choose to import/export Items you get the additional option Item specifics (prefix). If you enter a prefix, item specifics will be activated within the CSV and inserted as single CSV columns. If you leave the field empty, the specifics will not be managed.

Below you can see an example with the prefix C: and the individual item specifics Color and Size. The item with the id 12345 has the two item specifics Color with the value Blue and Size with the value XL. The 2nd item with the item number 67890 has only the item feature Size with the value S. The item characteristic Color is ignored here, because no value is deposited.

Orders

When you choose to export Orders there are currently no further options, but the CSV mapping fields will change.

CSV-Mappings

In the last section of the Profile Manager you define the CSV mapping fields. By mapping data values (e.g. properties of items) you link these values to the corresponding csv column.

Example:

You have a CSV file, with the columns ItemID and Condition and now you want to insert them in your dewabit item.

ItemID;Condition
12345;1000

In this case you have to link the CSV mapping fields ItemID with the CSV value Item number and Item condition with the value Condition in the profile manager, so that dewabit can assign them correctly during import and export.

Add mapping fields

To add new mapping fields you can either click on the icon, which you can find in the upper right corner of the CSV mappings area, or by right-clicking on Add CSV mapping fields.

The window for adding new mapping fields opens.

In this window all fields of a data type are displayed, which have not been selected yet. Fields with a as a symbol are identification values. This means that they will be used as identification during import to find a desired record.

When you click the Apply button, all fields with an active checkbox will be added. You can select multiple rows and activate or deactivate them by right-clicking to save time.

Import mapping fields

Using the icon, which you can find in the upper right corner of the CSV mappings area, you also have the option to import the CSV mapping fields from an already existing profile.

Select the desired profile there and then click Apply.

Manage mapping fields

If you have added CSV mapping fields, you can change the values from the CSV field column as you wish. Double-click on the desired cell to revise the value. Values that do not contain a value will be displayed in yellow and will not be applied when saving.

You can remove selected CSV mapping fields by Right click => delete.

Predefined profiles

As already mentioned, we offer predefined profiles for items and orders.

Items

The following profiles are predefined for Items import/export.

dewabit_Item

The dewabit_Item profile is dewabit’s default CSV format for items and includes nearly all variables from ebay and dewabit.

InventoryProfile

With this profile you can adjust the inventory and/or the item price. You have the possibility to select the items by item id, SKU or a product identification (EAN, UPC, ISBN). The profile also supports variaton items. For more information see InventoryProfile.

ebayCSVManagerFormat.

This profile is the default CSV profile from ebay. You can use this profile to import your item data from Turbolister.

Orders

Below you will find the predefined profiles for orders import/export.

dewabit_Order

The dewabit_Order profile is dewabit’s default CSV format for orders and includes nearly all variables from ebay and dewabit.

CompleteSale

With this profile you have the possibility to revise the order status. You can mark orders as paid or shipped and provide a shipping number and the service provider. For more information, see CompleteSale.

Backup

You can save your CSV profiles in a backup.