SIMPLIFIED CSV - Option 1 - Pricing up to 30 price breaks

SIMPLIFIED CSV - Option 1 - Pricing up to 30 price breaks

SIMPLIFIED CSV - Pricing up to 30 price breaks




Before you attempt to make products in simplified always begin by creating the product as a custom quote to check that it can be priced first.



Creating Custom Pricing 

The idea behind custom pricing is to allow a site (or business) to offer fixed pricing to selected customers, regardless of how the factory prices the chosen product. In essence this is a price override function.


NOTE: This option is best to use when 'Folds, Pages or multiple sections' are required like on brochures & bookwork.
For single section 'flat' work, the best option is: SIMPLIFIED CSV - Option 4 - Flat Sheet Pricing + Extras




Go to Admin > Factory capabilities. Select “Define Filters” 




Either find an existing filter set or create one that suits the products that you are going to create. ie: Letterheads, Business Cards, Posters etc.

When creating a new filter: simply type in the name of the new filter, the description box is useful if it reflects what filters have been added to the filter set.
Select the tick to create. 




  |







Now add the required filtering methods to the filter set. For example, If you wish to filter by: stock and size, then simply hit the arrow next to those items on the right side of the page (under Available Filters). This will move them into the set. Hit “Save” to finish. 


Return to Factory Capabilities (under Admin) and select “Manage Product Categories”. 




Either choose a product category, or select the + to create a category, in which the product will reside. 






Create a Category for the specific product that you’re creating. (This stage can be repeated for multiple products ie: Business Cards, Post Cards, Posters, etc).

Add your product name, select the position for the product (ie: within the parent node). Select the filters to be used for this product and hit the “Add” button. 



After saving the category it will be given a category “ID” this ID is needed for the next process.


1172- Posters


The next step is to download the “ProductCreationTemplate” and save it as a version for the specific products that you’re creating 
ie: PIQ ProductCreationTemplate_Posters.


From the 'Factory Capabilities' screen, go to 'Upload Factory Capabilities': 





  |

Click the 'Download Product Template CSV' option at the bottom of the screen:




  |



Once saved enter a “Session Name” (see example below), an alphanumeric “Product Code” (a two to five letter alpha prefix followed by a number starting at 0001), your “Tree Node” number from the category you wish to place the products in. Hit save.

 
Below is an example of a standard ‘Pricing CSV’ file with the header included for reference. 
Note: that the header row must be deleted before any upload.







  |

FIELDS OF NOTE:


  • A (Factory Name) – Factory.
  • B (Session Name) – This field can be altered to reflect the description of the products being uploaded.
  • C (Product Code) – This must be individual for every product entered.
  • D (Tree Node) – This relates to the ‘Category’ or ‘Node’ created for the product – see help file ‘Build the Product Tree’
  • For example, if you want your product to sit in the Letterheads category you would check the Category ID for Letterheads i.e. 49 and enter that into your tree node field.
    49 – Letterheads 
  • E (Section Type) - Enter the section type. Options are: Single-Section, Text, Cover, Other, Front or Back
  • F (Stock) – The stock code must be entered here.
  • G (Fold Catalogue) - You need to enter a code from the fold catalogue (Admin-Configure Factory-Fold Catalogue).
    Scroll to the bottom to see the current fold catalogues loaded for your site. 

  • H & I (process Front and Back) - This is where you enter the colours per side.

FIELDS OF NOTE:

  • M & N (Max and Min Page) – This must always be set to 2 and 2. This represents a Front and Back.




  • Y (Size) – The job size is entered here. You need to use the ‘Short Name’ as reference

    NOTE: You can enter a custom size range using this format:
    Custom:40x40-55x90


FINISHING COLUMNS - J, K & L (Section) - N,O,P,Q,R,S (Side) & V,W,X (Job)
This is where you can add in additional operations required to produce the product.
There is only 3 options for each.
If you need to add more, you can leave the JobFinish2 and JobFinish3 fields empty and put it all in JobFinish1 with a ';' as a separator.
You can then enter as many as you need.




  |
  • Q (Pricelist) – This is the name of the 'Wholesale' pricelist you wish to link to.
  • S (PriceType)  – Leave as 3









You can enter up to 30 ‘Price’ breaks for each product. These quantities are what you want the user to be able to select from when quoting on the product.
Copy the Quanity & Price Column and insert the copied cells, do this for as many quantity breaks as you need






You can adjust the ‘Quantity’ columns to any quantity break you require enter a ‘price’ per quantity break.

Save the file once finished. 


Now back into Factory capabilities (under Admin), select “Upload Factory Capabilities” 

Click where it says “No file selected”, browse to the .csv file you just created and hit “Import”. 





A message will appear describing how many products have been read. Hit “Create Products”. 





|


A message will appear describing how many products have been created. Hit “Created Products”. 





Then Hit “View Created Products”. 


























The product (or products) that you have created will be displayed in draft mode. Select the tick box and hit “Activate Draft products.
















The process is now complete.


To check your new product, test quote a product using simplified. Don’t forget to test the pricing for the various quantity breaks you added as well.





    • Related Articles

    • SIMPLIFIED CSV - Option 4 - Flat Sheeting Pricing + 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 ...
    • SIMPLIFIED - Quote engine pricing

      Introduction Manage Simplified Sessions – Creating & Editing Simplified Sessions ‘Simplified’ products are predefined products that you create where you can offer ‘non-estimators’ access to quote. This included internal sales staff and even ...
    • SIMPLIFIED CSV - Option 2 - Pricing over 30 price breaks

      To print or download this document click here   SIMPLIFIED CSV - Pricing over 30 price breaks   In the following example, we need to upload pricing in excess of the ’x30 pricing maximum’ you can have in the standard ‘CSV’ upload.   NOTE: This option ...
    • 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 ...
    • Store Item Pricing CSV Upload

      The pricing details for IQstore items can be exported and updated off-line and then imported to update pricing methods and prices. Pricing rules can be divided into 3 kinds: Handling Item – with no Customer or Customer group Item – with Customer or ...