dewabit help pages
Search
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 ...
button.
You can change the default CSV file name in the settings.
Item export provides ItemStatus
and 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 yellow
or red
.
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 ItemStatus
and 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:
ItemStatus | Description | Processing |
---|---|---|
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:
Aktion | Description |
---|---|
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 |
The 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 dewabit_clear
.
You can still edit the ItemStatus
and Action
even after an import. To do this, select the desired items and then right-click to select the desired ItemStatus
or Action
.
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 |
---|---|---|---|---|---|
1 | Active | Add | Title1 | SKU1 | |
2 | Draft | Revise | D1111 | Title2 | SKU2 |
3 | Draft | PartialRevise | D2222 | New Title | |
4 | Draft | PartialRevise | D3333 | dewabit_clear | New SKU |
5 | Active | End | A1111 | ||
6 | Active | End | |||
7 | Active | Relist | A2222 |
Explanation of the line numbers:
1: By the parameters Active
and 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 Draft
and 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 Draft
and PartialRevise
. With 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 Draft
and PartialRevise
. Here the title is cleared by the keyword dewabit_clear
and SKU is replaced with the value New SKU
.
5: The parameters Active
and 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 Active
and 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 item id
, 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 SKU
or 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 |
---|---|---|---|---|---|---|
1 | Active | A1111 | 20 | 2.99 | ||
2 | Active | AV1111 | SKU1 | 3.50 | ||
3 | Active | AV1111 | 0 | EAN123 | ||
4 | Active | AV2222 | SKU1 | 5 | ||
5 | Active | AV2222 | 6 | |||
6 | Active | SKU2 | 10.00 | |||
7 | Active | 50 | EAN123 |
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 20
.
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:
ItemID | Notes |
---|---|
123 | |
456 | dewabit Import |
789 |