Importing Products: Parameters and CSV Upload

When uploading products via a csv file, operations containing parameters can be included along with the ‘answer’ to the parameter.

From ‘Factory Capabilities’ under ‘Upload Factory Capabilities’:

When you export the ‘Empty Product CSV’:

We have included ‘FinishParam’ fields to SectionFinishing and JobFinishing by default

(you can also manually add Finishparam columns for every type of finishing - front,back,section,job,section child, job child)

To use these fields in the csv, the format is key value pairs e.g. {ParamName}:{ParamValue} or Diecut Number Up:4

In the above example the name of the operation ‘MACH DIECUT Nup’ is added to the ‘SectionFinish’ field:

The parameter ‘Job Operation Name’ is added to the ‘FinishParam’ filed along with ‘:’ followed by the ‘answer’:

You can add additional new columns for "FinishParam" immediately after the "SectionFinish" "JobFinish" "BackFinish" etc operation name columns.

This will assign parameters to the operation preceding it.

Optionally you can specify more than one key value pair separated by semicolons 

e.g. Test Param 1:25;Test Param 2:30

• Related Articles

• Product Import - Upload Factory Capabilities - CSV Import (Simplified/SPC)

  Introduction Uploading products via a csv file from ‘Factory Capabilities’ under ‘Upload Factory Capabilities’. For explanations of the remaining Columns, not listed below, or products that have multiple sections, please speak to your printIQ Build ...

• Uploading Product Categories for Faster Setup

  Product Categories serve as a way to organize a company's product offerings. To manage these categories effectively, CSV exports and imports can be utilized. Adding and updating Product Categories can be a time-consuming task, especially during the ...

• Bulk Uploading Stock Items

  We have created a PDF document that goes through the stock CSV import document in detail. It is the most up-to-date document. It is attached to this page. See this document for the most recent information on the CSV file, and a description of the ...

• CSV Option 3 - Upload Kinds Pricing

  UPLOAD KINDS PRICING VIA CSV In the following example, we need to upload pricing for catalogue items with multiple kinds. NOTE: This option is best to use only when multiple 'sections' are required like on bookwork with a text and cover. For single ...

• CSV Option 4: Flat Sheet Pricing and Extras

  Flat Sheet Pricing plus extras – CSV pricing. Using this method, you can upload ‘catalogue’ pricing into IQ using a combination of flat sheet pricing (base item ‘CSV’ uploads) and optional extras using job operations. NOTE: This option is limited to ...