Items

dewabit help pages

Items Import/Export

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.

CSV-Export

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.

Export items via 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.

Export csv file

Select 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.

Select csv profile

Select save location

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.

Other options

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.

CSV-Import

To import your CSV file you have to click on Import/Export => CSV => Import CSV file in the main menu.

Import csv file

The CSV import window will open.

CSV import window

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.

Item import

If a CSV file has been imported correctly, the item import window opens.

CSV item import window

In this window you will see all the imported items and they are ready for further processing.

Errors

If errors occur during import or processing, the individual item lines are displayed in the colors yellow or red.

Yellow

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.

Red

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.

CSV import errors

If you hover a row with your mouse, the error messages will be displayed as a tooltip.

Show errors in tool tip

Another way to display the error messages is via right click => error messages.

Open errors

This will open another window with the error messages.

Show errors

Actions

Open items

You can display your imported items with a double click or via Right click => Show offer in the item overview window.

Open item

Delete items

With Right click => Delete you can delete selected items.

Using certain key shortcuts you can select/mark your items more easily.

Group items

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.

Group items

Import processing

As mentioned before for CSV export you can use the ItemStatus and Action options to determine the import processing of items.

ItemStatus

The ItemStatus specifies the desired item table when importing an item. The following parameters are available:

ItemStatusDescriptionProcessing
Activeebay ItemWith this ItemStatus all changes are copied to the queue
DraftDraft (local)Drafts are processed directly

Action

The action field is used to determine how an item will be processed during import. The following parameters are available:

AktionDescription
AddThe item is created as a new item
ReviseAn already existing item will be overwritten. If this item can’t be found, a new one will be created
PartialReviseitem values, similar to bundled editing, will be revised. Here the item is not overwritten, but only the individual values are revised
EndAn active ebay item will be ended
RelistA 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.

Set ItemStatus and Action

Using certain key shortcuts you can select your items more easily.

Sample import

Below you can see an example import with different input values:

Line numberItemStatusActionitem idTitleSKU
1ActiveAddTitle1SKU1
2DraftReviseD1111Title2SKU2
3DraftPartialReviseD2222New Title
4DraftPartialReviseD3333dewabit_clearNew SKU
5ActiveEndA1111
6ActiveEnd
7ActiveRelistA2222

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.

InventoryProfile

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):

  • item id
  • SKU
  • product identification (EAN, UPC, ISBN)

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.

Variation item

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.

Sample import (InventoryProfile)

In the following you can see an import of the InventoryProfile with variation items

Line numberItemStatusitem idSKUQuantityPriceEAN
1ActiveA1111202.99
2ActiveAV1111SKU13.50
3ActiveAV11110EAN123
4ActiveAV2222SKU15
5ActiveAV22226
6ActiveSKU210.00
7Active50EAN123

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.

You have some questions?

Feel free to drop us a message, we will reply as soon as possible.

Contact us