Products

The page products shows a list of all products in the active data source. In addition, you can search with specific selection criteria for products. Each record can be edited individually. Simply click on a title!

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

Category Selection / Search

Category Selection - 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 record to at least one internal category is an important precondition for exporting your data (including shop categories) later.

Search Term - Enter a keyword or use a filter as follows:

1. New - search for new entries (additions since last import)
2. Unnamed - looking for items without a title
3. [keyword] (Text in square brackets) - looking for the exact text "keyword"

All Products

Have already been records imported or created, you see here a list of your products. Sorting is done via the columns ID, Name, Price or Inventory.

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 (separated by data source) by using the function free fields / variations in Data Pool->Preferences->Data Sources. Of course, ideally all content should be imported / modified using the import function.

Master Data

• Name, Keywords, Descriptions

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.

Category

• Product in internal Category

In case you have imported internal categories (ie categories that you transfer so directly in the data pool) via DATAPOOL->Data Import, you can assign your 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 be established in any case when several different CSV files are imported into the data pool and all the records shall 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 (under Interfaces->Export Settings) convert them into another CSV structure.

Images

Image name or Image URL

Please use only "direct" image links to include an image. Forwarding image paths can cause errors.

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

• [ Group function ]

The button [Group Function] is used to edit several Products or Internal Categories at once. First, select the records you want to edit or delete, and then click the [Group Function] button. Now, select a function that shall be applied to the selected records and confirm the action with [Execute].

• [ Create a New Record ]

Ad a new Product

• [Use Test Data]

If your DataSource is still empty, you have the possibility to use the data of some of our jewelry items for testing purposes. Please note, that these products are not automatically updated by the system!

• [ Save List ]

Save changes

• [ Create a Backup ]

The backup function in the data pool is intended for occasional backups. The here created CSV file is not suitable for import into external systems! Creating of interfaces or csv-files for external systems must be done at the interfaces section.

• [ Delete all Records ... ]

Product data will be deleted after an additional confirmation message.

This option deletes all product data in the active data pool. If you want to delete certain items only, select the respective records (set checkmark on the left).

Products with Inventory

List of products that are in stock, for more information see section #All Products

Products without Inventory

List of products that are out of stock, for more information see section #All Products

Not available

Products that were not found during the last import and thus could not be updated.