Products

Aus Wiki csv4you
Wechseln zu:Navigation, Suche
Sprachen:
Deutsch • ‎English

The page products shows a list of all products in the active data source. Use the button in the top left corner to switch the view between individual Products and Product Parents.

In order to use a CSV- or API- interface - existing product data in the DataPool are prerequisite. Please refer to our information in the Quick Guide...

Search and Search Filters

Enter a Search Term or use the filter as follows:

  1. OR - returns items where at least one of the search terms is found, separated by spaces. Example: 'OR red blue'
  2. AND - returns articles in which all search words are found, separated by spaces. Example: 'AND red blue'

In addition, there is the option of using special, already preconfigured search filters. Thus, within the different areas Products, "Variants", Categories as well as the Amazon and eBay Listings, targeted search criteria for finding specific data records can be selected. Simply click on the [Filter] button next to the input field to select one of these searches.

Search Filter Products

Determine which products to search for, e.g. products without title or description, new products, products without variant value assignment or products with special markings (see marking management).

Search Filter Category

Lets you choose a pre-selection for the search in the active Data Source . You can search for records in certain categories, in order to edit them specifically. The selection of records with no assignment to any internal category, is also possible ('Products w/o Category Assignment'). Several records can be selected and assigned to a desired category.

Watch out!
The assignment of a product data record to at least one internal category is an important precondition for exporting your data (including shop categories) later.

Search Filter Amazon/eBay

Filter here, for example by products without eBay item attributes, without eBay category, without Amazon item attributes or without Amazon category.

All Products

If data records (listings) have already been imported or created, you will see a list of these products here. Different sortings can be selected via the small button with the two arrows (ascending/descending) to the right of the search.

Detail Page

To edit the properties of a single product, either click on the ID, the name or on the [Actions] button. You will be directed to the details page of each product and can edit the individual properties there.

General

  • ID, Parent ID, EAN / GTIN, ISBN, inventory, packaging unit, price, old price, MSRP, purchase price, base price, base price unit, base price content, VAT, weight, height, length, width, height, vendor ID, manufacturer SKU, external URL for product, date, text information, (free data fields) and cross-data among others

Item numbers (ID or Parent ID) may be up to 50 characters long. Any additional characters are truncated during import.

If you are missing certain fields or columns, you can add them subsequently (for each data source individually) by using the [Actions] buttons in My Account->Base Settings->Data Sources. Of course, most easily can any content be created/ modified via the import function.

Master Data

  • Name, Keywords, Descriptions, Short Description, Material, Color, Packaging unit
product name or title, product descriptions, more attributes
When using JavaScript in the field Description there can be problems with the preview, depending on the code. Consult the support in such cases.

Prices

  • Sales Price, VAT, other Prices (purchasing, net, ...), Discount scale Prices
Necessary price details

Category

  • Product in internal Category
In case you have imported internal categories (i.e., categories that you have created directly in the data pool) via DATAPOOL->Data Import, you can assign a product here to one of these internal categories. Then, you enter your shop categories for the CSV file under Interfaces->Category Mapping and map them to the internal categories from the data pool. Internal categories should definitely be created, if several different CSV-files are imported into the DataPool and then all records are supposed to be exported via one interface.
  • External Category 1-5
These fields are for so called external categories, if you import products with existing category names or category IDs from an external system via DATAPOOL->Import Data. This makes it possible, in a time saving manner, to imort several thousand records with matching (external) category assignments in the data pool. In this case, it is no longer necessary to create internal categories manually and to assign the products from your data pool to them individually.

Tip: You should only work with external categories, when you need to import many records from a large CSV-file to then convert them (via Interfaces->Export Settings) into another CSV-structure.

Images

  • Image 1, Image 2, Image 3, ... Image 10

Image name or Image URL

Verwenden Sie bitte nur vollständige Bildpfade, die ein Bild direkt aufrufen. Bildpfade die weiterleiten, können Fehler verursachen. Werden lediglich Bildnamen hinterlegt (z.B. 24936.jpg), so müssen die dazu passenden Bilddateien im richtigen Verzeichnis Ihres Shops gespeichert sein. Wir hosten keine Bilddateien für Produkte.

Language 2-10

Cells for additional Languages

Additional languages must be activated by you under "My Account -> Base Settings -> Data Source -> Actions -> Language Sub-Sets". Insert there e.g. the value English into the field Language 2 . On the product page you will then see a new tab [English] with the respective fields of this language.

Amazon

  • Country
List of the Amazon marketplaces
  • ASIN
Enter the ASIN of your product or import this value
  • Category
Product category on Amazon

Individual item attributes can be assigned to each product. Typically, the assignment of item attributes should always be made first for the Internal Categories. You can identify existing market assignments by the color of the country code in the list of the Internal Categories (i.e. US, UK, DE).

Country Code Red: Marketplace-ID assigned
Country Code Black: Marketplace-ID and Item Attributes assigned

eBay

  • Country
eBay-marketplace country
  • eBay: ID
The eBay item ID for the product in the respective marketplace appears here. The import of your eBay IDs occurs via the data import through the eBay API at Products->eBay->Load Data from eBay. This works only if in My Account->Base Settings->eBay a valid eBay token for the marketplace exists.
  • eBay: Category
Product category on eBay
  • 2. Product category on eBay
2. Produktkategorie bei eBay
  • eBay-store category on eBay
eBay-store category on eBay
  • 2. eBay Store Category
2. eBay-store category on eBay

If existing, all category IDs can be assigned/imported individually via data import for each product.

Individual item attributes can be assigned to each product. Typically, the assignment of item attributes should always be made first for the Internal Categories. You can identify existing market assignments by the color of the country code in the list of the Internal Categories (i.e. US, UK, DE).

Country Code Red: Marketplace-ID assigned
Country Code Black: Marketplace-ID and Item Attributes assigned

API

  • API
The product ID that is read via the API from your shop system is stored here.

Buttons

  • [ Gruppenfunktion ]
Die Schaltfläche [ Gruppenfunktion ] dient zum gebündelten Bearbeiten von mehreren Produkten bzw. Internen Kategorien. Markieren Sie zunächst die gewünschten Datensätze die Sie bearbeiten oder löschen möchten und klicken Sie dann auf die Schaltfläche [ Gruppenfunktion ]. Wählen Sie danach eine Funktion, die auf die markierten Datensätze angewendet werden soll und bestätigen Sie die Aktion durch [ Ausführen ].
  • [ Neuen Datensatz anlegen ]
Neues Produkt anlegen
  • [ Testdaten benutzen ]
Ist Ihre Datenquelle noch leer, haben Sie hier die Möglichkeit einige Schmuckartikel für Testzwecke zu übernehmen. Beachten Sie bitte, dass diese Testprodukte nicht automatisch vom System aktualisiert werden!
  • [ Liste Speichern ]
Änderungen speichern
  • [ Sicherung erstellen ]
Die Backupfunktion im Datenpool ist für gelegentliche Datensicherungen gedacht. Die dabei erstellte CSV-Datei ist nicht für den Import in Fremdsysteme geeignet! Das Erstellen von Schnittstellen bzw. CSV-Dateien für Ihr System muss über den Bereich Export erfolgen.
  • [ Alle Produkte löschen ... ]
Produktdaten löschen mit zusätzlicher Bestätigungsabfrage (z.B. alle, mit Bestand, ohne Bestand, nicht verfügbar)
Diese Option löscht die jeweiligen Produktdaten des aktiven Datenpools. Datensätze lassen sich über die Optionsfelder links auch einzeln markieren und dann löschen.

Products with Inventory

Liste aller Produkte mit Bestand, für weitere Informationen siehe Abschnitt #Alle Produkte

Products without Inventory

Liste aller Produkte ohne Bestand, für weitere Informationen siehe Abschnitt #Alle Produkte

Not available

Produkte, die beim letzten Produktimport (nicht Bestandsupdate) nicht gefunden wurden und somit nicht aktualisiert werden können. Beispiel:
Ihr Großhändler liefert in seinen CSV-Dateien immer nur Daten von Artikeln die er auf Lager hat. Artikel ohne Bestand oder Artikel, die beim Großhändler ausgelaufen sind, stehen nicht in der Datei. Damit sammeln sich mit der Zeit Artikelnummern im System, die schön länger nicht mehr geändert wurden und bei denen gleichzeitig auch keine Bestandsaktualisierung mehr erfolgte (trotz regelmäßigem Import). Über diesen Reiter können solche Produkte schneller gefunden und bei Bedarf aus dem System entfernt werden.