The brand IDs from PIXmania are required. You receive them by following the procedure described below.
Exporting the data format:
-
Go to Data » Dynamic export » Tab: New data format.
-
Select the setting Producer under Data format type.
-
Enter a name.
-
Activate the fields ProducerID, ProducerName, and ProducerPixmaniaID.
-
Save () the settings.
→ The Edit data format tab opens.
-
Expand the data format ().
-
Click on Export data.
-
Save the CSV file on your computer.
Send the CSV file to the PIXmania customer service. You will then receive an Excel file from PIXmania. Generate a CSV file from this Excel file which corresponds to the Producer data format.
Import the brand IDs into your plentymarkets system using ElasticSync. To do so, create a sync of the type Manufacturer. After you have created the sync, you have to set the import options for the sync, set the matching, and create the mappings.
Creating a sync
First create a sync of the type Manufacturer.
-
Go to Data » Data import: Import.
→ The sync overview opens.
-
Click on Add sync ().
→ The editing area New sync is displayed.
-
Carry out the settings. Pay attention to the explanations given in Table 2.
-
Save () the settings.
→ The sync is created.
→ The matching settings of the sync open.
Table 2. Creating a sync
Setting |
Explanation |
Basic data |
Name |
Enter a name. This name is displayed in the overview and can be used for the search. |
Interval |
Select an interval for the import of syncs.
By choosing the option Schedule you can determine how often and at what time the import of syncs shall be started. |
Type |
Select the type Manufacturer from the drop-down list. This sync type is used to import manufacturer data. |
Import |
Data type |
Select the file format of the import file.
Currently, CSV/TXT is the only available option, as only CSV or TXT files can be imported. |
Character set |
Select the character set of the file or the option Detect automatically. |
Starting in line |
Select a line starting from which the data should be imported. |
Header is included |
Select whether the import file contains a header. |
Use global cache |
Determine whether the global cache should be used for a file or not. If the setting is activated, only modified data rows will be imported. If the setting is not activated, you can import one and the same file again at any time. |
Automatic mapping |
Select whether the mapping should be done automatically. The columns in the CSV or TXT file can be mapped automatically to the plentymarkets data fields. To ensure that the mapping works properly, the names of the fields that you selected in the FormatDesigner must not be changed. |
Separator |
Separator |
The separator of the CSV or TXT file is automatically detected. This setting is activated by default.
Alternatively, you can manually select the field separator that is set in the import file in order to separate the data fields (columns) of a data record from each other.
Possible separators are Semicolon, Comma, Tab and Pipe. |
Delimiter |
Select delimiters within the fields that may contain multiple values.
* " = individual values within one field are separated by double quotation marks.
* ' = individual values within one field are separated by single quotation marks. |
Source |
Source |
Select Manual upload, FTP, HTTPS or SFTP.
Depending on the selected option, the following settings are displayed:
Manual upload = Select and upload a local file.
After running a sync, the file is automatically deleted from the webspace. This is preset by default. In order to save the file you need to remove the check mark. Note: storing the file on the webspace is subject to a fee.
FTP = Host, port, user name, password and file name are displayed.
-
Host (mandatory field) = Enter the host of the FTP server.
Tip: Use your plentymarkets FTP access.
-
Port = Enter the port of the FTP server. If no port is entered, the standard port (22) is used.
-
User name (mandatory field) = Enter the user name for the FTP access.
-
Password (mandatory field) = Enter the password for the FTP access.
-
File name = Enter the path and the name of the file from which the data is to be imported. The file name has to end with .csv or .txt.
Note: You can use wildcard characters in the field File name by e.g. replacing a part of the file name with a *. Only use wildcard characters in combination with the option Move file to archive when import was successful.
-
Move file to archive when import was successful = If this option is activated, the import file is automatically moved to the new Archive folder in the FTP directory once the import was successful.
HTTPS = *Select External URL.
SFTP = Host, port, user name, password and file name are displayed.
-
Host (mandatory field) = Enter the host of the FTP server.
-
Port (mandatory field) = Enter the port of the FTP server. If no port is entered, the standard port (22) is used.
-
User name (mandatory field) = Enter the user name for the FTP access.
-
Password (mandatory field) = Enter the password for the FTP access.
-
File name = Enter the path and the name of the file from which the data is to be imported. The file name has to end with .csv or .txt.
Note: You can use wildcard characters in the field File name by e.g. replacing a part of the file name with a *. Only use wildcard characters in combination with the option Move file to archive when import was successful.
-
Move file to archive when import was successful = If this option is activated, the import file is automatically moved to the new Archive folder in the FTP directory once the import was successful.
|
Setting the import options
After you created a Manufacturer sync, you set the import options. To do so, carry out the settings as described in the Setting the import options chapter on the ElasticSync page.
Setting the matching
Next, set the matching for the sync. To do so, carry out the settings as described in the Setting the matching chapter on the ElasticSync page.
Creating a mapping
Last, you have to create the mappings for the data fields. To do so, carry out the settings as described in the Creating a mapping chapter on the ElasticSync page.