Introduction

REMEMBER 

This functionality should be used after your stock catalogue is loaded via Stock Bulk Upload: 

https://printiq.zohodesk.com/portal/en/kb/articles/stock-bulk-upload

Stock Bulk Cost Update is typically used when you receive updated pricing from a supplier and need to update the records in printIQ.

It is found in the Inventory section under Admin-> Configuration:

TEMPLATES:

1. Template: Stock Pricing

This is a blank template that allows you to enter your stock pricing:

1. The IQ Supplier Code* is the code for the supplier (not necessarily their name)
   
2. The StockRef* is the suppliers reference for the stock (ie. the part number)
   
3. The CostPrice per 1000 is the "buying price" per 1000 - and is what will appear on your purchase order
   
4. The SellPrice per 1000 is the "selling price" per 1000 - and what will appear in your quote.
5. The CostPrice per Roll is the "buying price" per roll - and is what will appear on your purchase order
   
6. The SellPrice per Roll is the "selling price" per roll - and what will appear in your quote.
   
7. The CostPrice per ft is the "buying price" per foot or material - and is what will appear on your purchase order
   
8. The SellPrice per ft is the "selling price" per foot - and what will appear in your quote.
   

The Stock Pricing import influences the pricing captured directly on the stock record:

The Supplier Pricing import influences the pricing captured directly in the inventory:

1. Limits the stock to the owner (most likely you will want "Factory Owned")

2. Choose the supplier(s)

3. Choose the item type (for Stock - choose "Paper")

Once exported, you will see the following csv layout:

The Supplier Pricing import is intended to be used with Inventory Pricing, which prevents the need to stipulate a charge price/sell price.

Further information on Inventory Pricing configuration can be found on the 'Stock - Inventory Component Pricing' Article: 

https://printiq.zohodesk.com/portal/en/kb/articles/stock-inventory-component-pricing

Updating the Pricing

It is recommended that you test and review a sample stock first before carrying out a mass upload. 

Testing steps should include a review of sample stock configuration, a review of sample stock within a quotation and a review of sample stock within a purchase order.

Before Updating

If using Inventory based Pricing	If using Stock based Pricing

The Order in units of are what you pay your supplier - what appears on the PO

The Charge units are used in quoting to calculate the quoted cost, if not using Inventory Pricing.

1. Updating the COST and SELL price (Stock Pricing)

If you want to update BOTH the COST and the SELL price - use Stock Pricing Template (#1 above)

This will allow you to simultaneously change both the Cost and Sell (if using Stock Pricing) prices at the same time.

This is done either by 1000's, by Roll or by the Foot (metre in metric)

When you update using this method you will see the following:

If using Inventory based Pricing	If using Stock based Pricing

The Order unit price is changed

The Charge price is changed (if using Stock based Pricing)

In order to obtain the required information for the Stock Price import, you can use the Stock Bulk Export functionality:

2. Updating the Cost Per Unit (Supplier Pricing)

If you want to update the price per purchase unit you can use columns D (Cost per Unit) and F (Unit Type) on the Supplier Pricing import

If using Inventory based Pricing	If using Stock based Pricing

The Order unit price and the unit type are changed

The Charge price remains unchanged as supplier pricing is not intended to function with the concept of a Charge unit.

3. Updating the Per 1000 Price (Supplier Pricing)

When you update using this method you will see the following:

If using Inventory based Pricing	If using Stock based Pricing

The Order unit price is changed - relative to the current unit type

Use Supplier Pricing to capture Multiple Supplier Prices

Supplier Pricing allows the ability to capture pricing for multiple suppliers against the same inventory item.

This should be the same stock sourced at the same size from a different merchant or the same merchant with an alternative Unit of Measure (EG: Ream Wrapped/Bulk Packed paper).

The import file can be used to either update existing supplier prices or create new supplier prices for an existing inventory item.

Using the sample stock I add the following supplier to the Inventory of the stock size 12x18:

Exporting the Supplier Pricing with 'Extra' and 'Spicers West Coast' defined as the suppliers will return the following.

Note - The exported csv has been manually filtered to view this Inventory Item in isolation:

I then configure a third supplier 'Spicers East Coast' into the csv:

When imported back in, I now have three suppliers listed in the inventory of this item:

At quoting stage, the cheapest supplier price will be selected unless the Manually calculated check box is ticked above.

The estimator will have the ability to define which suppliers price should be used. 

At purchasing stage, all associated suppliers of the item will be available to manually select when raising a purchase order.

The 'Preferred' supplier will be selected by default.