Page tree
Skip to end of metadata
Go to start of metadata

You can import all your products from a CSV file. It is recommended that you use the import option for testing only.

  1. On the top bar, click the Products tab.
  2. On the top-right side, click the Import products from A CSV file  icon.
    The CSV Importer for Print Products window appears.
    The CSV Importer enables you to upload a list of products from a CSV file into the Products table of the Console:

    Step 1: Customize your CSV format
    1. In the CSV Importer for Print Products window, click Define CSV format.
    2. Define each parameter according to the values in your CSV file. For example, if spot colors are not included in your CSV file, in the Spot colors front and Spot colors back parameters, select No.
      Note: You do not have to use all parameters:
      • Optional – provides the user flexibility if needed
      • Mandatory – must be used (see the Obligatory column in the table below)
      If you choose to not use a parameter, the Define CSV format must be set to No in order for the correct number of fields submitted match the expected presented CSV file.



    3. In this window, you need to specify your individual CSV format that fits your print products. You can either work only with the standard columns or expand the format to include more requirements. 
      When you finish customizing your CSV format, you can select the entire table that appears in the lower part of the CSV Importer for Print Products window and copy it into a file in your CSV editor. The columns' names and values will be displayed in your CSV file.





      Note: When you reopen the CSV Importer for Print Products window, all the last saved settings that you defined are displayed.

      The following table displays all the values and their expected formats:
No.ColumnExplanationObligatoryStandardFormat
1idUnique identifier of the product.yes-Length 1 to 15 consisting of a-z A-Z 0-9 / . _ - . No white spaces!
2orderIdOrder id of the product.no-Length 1 to 15 consisting of a-z A-Z 0-9 / . _ - 'whiteSpace'.
3labelLabel of the product.no-Length 0 to 100 consisting of a-z A-Z 0-9 / . _ - 'whiteSpace'.
4printReadyDefines if the product is ready for print.notrueEither 'x' or empty.
5widthTrim width of the plano product, open format.yes-Number from 20 to 10000.
6heightTrim height of the plano product, open format.yes-Number from 20 to 10000.
7bleedBleed of the product. If you have different values for each side, instead of 'bleed' you can have four columns 'bleedT' (top), 'bleedR' (right), 'bleedB' (bottom) and 'bleedL' (left), each with the same specifications as 'bleed'.no2Number from 0 to 99.9.
8marginMargin of the product. If you have different values for each side, instead of 'margin' you can have four columns 'marginT' (top), 'marginR' (right), 'marginB' (bottom) and 'marginL' (left), each with the same specifications as 'bleed'.no0Number from 0 to 99.9.
9quantityNumber of copies to print.yes-Number from 1 to 10000000.
10canQuantityMaximum number of copies of the product, the customer would still pay for.nosame as quantityNumber from 1 to 10000000.
11kFrontDefines if front side contains color 'Black'.yes-Either 'x' or empty.
12cmyFrontDefines if front side contains colors 'Cyan', 'Magenta' and 'Yellow'.yes-Either 'x' or empty.
13spotFrontDefines the spot colors on the front side.no-Comma-separated color-names. Overall, up to 100 characters consisting of a-z A-Z 0-9 / _ - *. 'whiteSpace'.
14kBackDefines if back side contains color 'Black'.yes-Either 'x' or empty.
15cmyBackDefines if back side contains colors 'Cyan', 'Magenta' and 'Yellow'.yes
Either 'x' or empty.
16spotFrontDefines the spot colors on the back side.no-Comma-separated color-names. Overall, up to 100 characters consisting of a-z A-Z 0-9 / _ - *. 'whiteSpace'.
17blockSheetsIf some of your products a re blocks or block-like, you can define the sheet number per block. The quantity to print is 'blockSheets' x 'quantity'.no-Number form 1 to 1000000.
18paperCatIndicates on which substrate this product has to be printed on. This value needs to fit to your defined papers. For more informations about paper categories read here, section 'Medias'.yes-Comma-separated categories. Up to 100 characters consisting of a-z A-Z 0-9 / _ - *. 'whiteSpace'.
19grainDirectionDefines the direction of the grain on the product.nofreeEither 'free', 'equal', 'parallelToWidth', or 'parallelToHeight.
20earliestStartTimeDefines the earliest point in time when the printing of this product could start.no-Date time in format 'YYYY-MM-DD HH:MM', e.g. '2020-12-24 12:00'.
21dueDateDefines the deadline, when the product has to be finished printing.yes-Date time in format 'YYYY-MM-DD HH:MM', e.g. '2020-12-24 12:00'.
22priorityDefines the priority of the product. A higher value goes with a higher priority.no-Number from 0 to 99.
23deviceCat

Defines on which of the fitting presses the product is allowed to be printed on. This value needs to fit to your defined papers. For more informations about device categories read here, in the Devices section.

Note: Note: The DPP-deviceCat custom field should not contain the following special characters: white space, a comma (,), or a dollar sign ($).

no*Comma-separated categories. Up to 100 characters consisting of a-z A-Z 0-9 / _ - *.
24groupThe 'Groups'-value lets you define groups for your products simply by putting in an descriptive or non descriptive name. Only products with the same group are possibly to be ganged.no-Comma-separated group names, up to 60 characters, any digits and letters.
25pdfPathFPath of the artwork PDF-file for the front page.no-Up to 250 characters including whitespaces.
26pdfPageFPDF page number of the artwork PDF-file for the front page.no-Number from 0 to 99.
27pdfPathBPath of the artwork PDF-file for the back page.no-Up to 250 characters including whitespaces.
28pdfPageBPDF page number of the artwork PDF-file for the back page.no-Number from 0 to 99.
29varnishOffsetXOffset in x-direction (width-direction) of the varnishing area on the product.no-Number from 0 to 99999.9.
30varnishOffsetYOffset in y-direction (height-direction) of the varnishing area on the product.no-Number from 0 to 99999.9.
31varnishWidthWidth of the varnishing area on the product.no-Number from 0 to 99999.9.
32varnishHeightHeight of the varnishing area on the product.no-Number from 0 to 99999.9.
33revenueSales revenue for the product.no-Number from 0 to 99999.99


Step 2: Import a CSV file

    1. When you complete defining the CSV format, click the Import button and navigate to the required CSV file.
      Note: The imported CSV file should have the same format as the CSV file that you defined earlier.

    2. Click Open.

    3. The CSV Importer starts uploading the products to the Console. You need to wait until the import process is complete.
      Note: If there are any failures in your data, the CSV Importer displays an error message.

  • No labels