Cronjobs "Import"

From Wiki csv4you
This page is a translated version of the page Cronjobs Import and the translation is 100% complete.

Other languages:
Deutsch • ‎English

Cronjobs "Import" gives the possibility to automatically import different data feeds - daily at certain times - into your data pool (for example, due to inventory changes). The following data types can be imported currently via a cronjob: products, inventory and categories.

Attention!
Cronjobs will be disabled automatically, if you have not logged-in to your account for more than 3 months.

To create a new cron job, click on the button [Create new cronjob (import)]. To modify a cron job, use the [Edit] button.


Cronjob (Import)

Watch out!

For the correct application of an import cron job, the creation of a corresponding import template is mandatory. To create a new import template - a data import must be performed once "manually! 
  • Name of Cronjob
a descriptive name for this cronjob
  • Type
Type of the import template: Product or Inventory
  • URL/FTP import file
URL - full weblink to your import file, e.g. http(s)://server.com/produkte.csv - or
FTP - full path to the import file on the FTP-server (see My Account -> Basic Settings -> FTP Data ), e.g. /folder1/sub-folder2/produkte.csv
For multiple files, each path must be on a separate line and all files must have the same format!
  • Separator
Specify the data- or column separator that is used in your import file.
  • Text Qualifier
Specify the text qualifier that is used in your import file.
  • Headers in Row
Specify which row contains the column labels (usually this is the 1st)

If a file imported by cronjob is either empty or does not exist, our system informs you about it via e-mail. In this case, please correct the settings or pause or delete the related import cronjob.

Type - Product or Inventory

Depending on the type of cron job, are either settings for the type product or inventory to make.


Settings "Produkt"

  • Template
Select a saved "Product" import template
For a Cronjob, only the columns assignment is taken from this import template. All import options for the Cronjob must be set up anew!
The import of product data and inventory data must be performed at least 1x by hand (under Data Pool -> Data Import). Only then can a template be assigned. If the selected template does not fit the specified file type - the column mapping is flawed and your Cronjob will break off or does not start at all.
That means:
For import-Cronjobs of the type Product you need a template type Product.
For import-Cronjobs of the type Inventory you need a template type Inventory.
  • Create Missing Items in the DataPool
Products from the import file that not yet exist in the DataPool are added to the DataPool as new products with a new ID. Note that under certain circumstances incorrect import data may also create new products. Always make sure, that your import files are formatted correctly.
  • Remove formatting from the text!
All HTML code will be removed from the imported data.
  • If UPDATE: Ignore missing columns!
Only applicable for UPDATES: If you want to transfer only certain columns from your file, this option must be enabled (Yes). That way, only the data from the selected columns that are stored in your import template will be imported and the rest ignored (Default Setting).
If you deactivate this setting (No), all cell contents of your products for which no column(s) are saved in the import template, would be deleted or to be more exact, overwritten with an "EMPTY" value.
Example:
Your data pool contains 20 fields with different values, but you want to import only the columns TITLE and EAN, e.g. because some product titles of your products have changed and should be updated. Then enable this option (Yes) and select only the columns EAN and TITLE. EAN numbers should of course not be changed to allow a correct assignment of the new title.
  • Incorporate categories from import file
If your import file contains product categories, you can incorporate these as internal categories in the data pool. Already existing data will be updated at every import. Newly added categories are then created as new internal categories.

Settings "Inventory"

  • Import Template
Select saved inventory import template
  • Set all inventory levels to 0 before importing
When checked, the inventory levels of all products in the data source are set to a value of 0 before importing.


XML-Settings

  • XML-element of the product data
Enter the XML-element of the actual product entries, e.g .: product
  • Variants
XML-element for Variants, z.B.: product->variant


Time Settings

Other languages:
Deutsch • ‎English

<translate> Mit Hilfe von Cronjobs lassen sich zu festgelegten Zeiten immer wiederkehrende Aufgaben z.B. in den Bereichen Import, Export und Artikellisting vollständig automatisieren. Die Anzahl der Cronjobs, die täglich ausgeführt werden kann, richtet sich nach Ihrem gewählten Tarifpaket. Markieren Sie daher bitte nur die maximal mögliche Anzahl an Cronjobs Ihres Tarifs, die nachfolgend angezeigt wird. Markierte Zeiten, die darüber hinaus gehen, ignoriert das System.

Tarifpaket / max. Cronjobs je Bereich *

Free = 3
Starter = 6
Business = 12
Premium = 24
* Davon ausgenommen sind vollständige Produktimporte. Hier sind maximal 4 Cronjobs am Tag möglich.

Die Angaben gelten separat für jeden Import sowie für jedes Exportprofil.

Beachten Sie auch, dass sämtliche Cronjobs auf dem System in eine Warteschlange gestellt und chronologisch abgearbeitet werden. Hinweise zum Status eines laufenden Crons finden Sie im jeweiligen Bereich.

Alle Zähler werden täglich um 0 Uhr MEZ/CET zurückgesetzt. </translate>

  • Time
Highlight the respective times at which your file should be imported.
Do not run the inventory cronjobs at the same times as product cronjobs (or vice versa). This prevents overlapping or incorrect updates.
  • Days
The weekdays for your cron job (several times or weekdays mark/delete with Ctrl + left mouse button)
No selection = every day
In order for your time settings to be saved, an import template must absolutely be selected!

Do not forget to Save your settings!