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.
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.
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 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.
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.
Item import
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.
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.
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.
Actions
Open items
You can display your imported items with a double click or via Right click => Show offer in the item overview window.
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.
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:
| ItemStatus | Description | Processing |
|---|---|---|
| Active | ebay Item | With this ItemStatus all changes are copied to the queue |
| Draft | Draft (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:
| 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.
Sample import
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.
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 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.
Features
K-Type
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|789The following K-Types are processed:
| ItemID | Notes |
|---|---|
| 123 | |
| 456 | dewabit Import |
| 789 |