dewabit help pages
In dewabit you have the possibility to import and export your items via CSV. This requires CSV profiles, which can be created via our profile manager.
To export items in CSV format you must first select the desired items in a table. After that you can open the window for exporting your selection by Right click => Export as CSV.
Using key shortcuts you can select your items more easily.
After clicking Export as CSV the CSV export window will open. There you will see information about the selection of your items, as well as the selected CSV profile.
When selecting the CSV profiles, you will be shown only the item profiles, sorted by predefined and custom profiles. With a click on the button next to the profile selection you open the profile manager to make changes to the CSV profiles.
Normally, the last selected folder is selected as the save location. If this folder is no longer available, your desktop will be selected automatically. You can select your own save location by clicking on the text field or the
You can change the default CSV file name in the settings.
Item export provides
Action options, which can be used during import to manipulate the records. You will learn more about these options later.
When you have selected everything as desired, you can click Export to export your items as a CSV file.
To import your CSV file you have to click on Import/Export => CSV => Import CSV file in the main menu.
The CSV import window will open.
There you will see information about the selected profile in the left pane. As already mentioned in the CSV export you can click on the button next to the profile selection to open the profile manager.
Once you have selected your CSV file and profile, click Import CSV file.
If a CSV file has been imported correctly, the item import window opens.
In this window you will see all the imported items and they are ready for further processing.
If errors occur during import or processing, the individual item lines are displayed in the colors
If a row is yellow, an error occured during the import process of the csv file. A possible error could be an incorrect entry for an expected numerical value.
If a row is red, an error occured during the processing of the item. A possible error could be when an item being processed could not be found.
If you hover a row with your mouse, the error messages will be displayed as a tooltip.
Another way to display the error messages is via right click => error messages.
This will open another window with the error messages.
You can display your imported items with a double click or via Right click => Show offer in the item overview window.
With Right click => Delete you can delete selected items.
Using certain key shortcuts you can select/mark your items more easily.
Via the icon , which you can find in the upper right corner, you can group your items via the item id. For example, you could display the variation items in the InventoryProfile.
As mentioned before for CSV export you can use the
Action options to determine the import processing of items.
The ItemStatus specifies the desired item table when importing an item. The following parameters are available:
|Active||ebay Item||With this ItemStatus all changes are copied to the queue|
|Draft||Draft (local)||Drafts are processed directly|
The action field is used to determine how an item will be processed during import. The following parameters are available:
|Add||The item is created as a new item|
|Revise||An already existing item will be overwritten. If this item can’t be found, a new one will be created|
|PartialRevise||item values, similar to bundled editing, will be revised. Here the item is not overwritten, but only the individual values are revised|
|End||An active ebay item will be ended|
|Relist||A sold or unsold ebay item will be relisted|
PartialRevise parameter works exactly like bundled editing. Only the fields that contain a value will be revised. If you want to clear a text field, you must enter the keyword
You can still edit the
Action even after an import. To do this, select the desired items and then right-click to select the desired
Using certain key shortcuts you can select your items more easily.
Below you can see an example import with different input values:
|Line number||ItemStatus||Action||item id||Title||SKU|
Explanation of the line numbers:
1: By the parameters
Add a new item will be added on ebay. Since the ItemStatus
Active was selected, the item is first copied to the queue and must be uploaded there manually.
2: By the parameters
Revise an already existing draft with the item id
D1111 will be overwritten. If the item is not found, it will be created as a new draft.
3: In this line we have the parameters
PartialRevise we want to revise in the draft only the values where the cell contains a value. In this example, for the draft with item id
D2222, we want to revise the title to
New Title. Since the SKU field does not contain a value, it is ignored.
4: This line also has the parameters
PartialRevise. Here the title is cleared by the keyword
dewabit_clear and SKU is replaced with the value
5: The parameters
End ends an active item with the item id
A1111 on ebay. However, only the
End parameter is significant here, because only active ebay items can be ended. You could also leave the field
ItemStatus empty. The action is not executed immediately, but first copied to the queue and must be started there manually.
6: In this row an active item shall be ended, but this will lead to an error, because no item id is provided. By using the
End action you must supply an item id.
7: In the last line, the parameters
Relist should be used to relist an unsold or sold item on ebay. The action is not executed immediately, but first copied to the queue, where it must be uploaded manually.
If you only want to revise individual values during an import, you should use our profile manager to create a new profile with your values to be revised and use the
PartialRevise action during import. This will allow you to export or import only the fields that are needed and keep your CSV file small.
The InventoryProfile is a special profile with the ability to adjust the stock and/or the item price (incl. variations). You have the possibility to select the items via the
SKU or a
product identification (EAN, UPC, ISBN). The search of the items is done in the following order (first match):
If an item was found via the
item id, the
product identification fields will be ignored (at least for non-variation items).
If you do not specify an
item id in the InventoryProfile and the search is to be done via the
SKU or a
product identification, the search is not so unique and could lead to several hits. If you have 3 items with the same EAN, all 3 will be found and revised. Therefore, if you don’t specify the
item id, you should be sure that only the correct items will be processed.
Searching variation items is done the same way as regular items, but to match the individual variations either the
SKU or the
product identification is required.
In the following you can see an import of the InventoryProfile with variation items
|Line number||ItemStatus||item id||SKU||Quantity||Price||EAN|
Explanation of the line numbers:
1: In the first line we search for an item with the item id
A1111 and set the price to
2.99 and the stock to
2: In our example, a variation item is being be revised in the 2nd line. The variation item is identified by the item id
AV1111. Subsequently, it is looked whether a variation of the item has the SKU
SKU1 and then revised. Since there is no value in the stock field, it is ignored and only the price with the value
3.50 is revised.
3: This item has the same item id as in line 2, but here the exact variation is searched with the EAN
EAN123. If it is found, the stock is revised with the value
0. The price does not contain a value and is therefore ignored.
4: In this line a variation item with the item id
AV2222 is revised. If the item is found, the variation with SKU
SKU1 will be revised. The SKU of the item is the same as for the item with the number
AV1111, but by entering the item id the correct item can be selected.
5: Here the variation item with the item id
AV2222 from line 4 is to be revised. The item is found, but since no SKU or EAN has been entered, the variation cannot be found and revised.
6: In this example, no item id is specified. This means that all items which have a SKU with the value
SKU2 will be revised. Here the price is set with the value of
10.00 and the stock is ignored.
7: In the last example all items with the EAN
EAN123 are searched and set to a stock of
50. Since no item id was entered and the EAN is the same as from line 3, the variation item with the item id
AV1111 is also revised, which should actually have a stock of 0. Therefore, when entering without the
item id, you should be sure that only the correct items are processed.
With the CSV import, you have the option of importing the K-type numbers. The numbers are separated from each other via the list separator of a CSV cell. Now there is the feature that you can insert the Notes in addition to the K-type number. The Notes are separated from the number by a space. In the following example you see a CSV file which imports an item with the item number
12345 and 3 K-Type numbers.
ItemID;KTypes 12345;123|456 dewabit Import|789
The following K-Types are processed: