Price Matrix Import Format

NOTE For general information on using imports, see Imports FAQ.

The following tables list the format for importing a price matrix, price matrix override, or companion product record in Price Matrix Import.

Note Price matrix override records must appear in the row immediately below the related price matrix record in the import file, or must include the exact value of the first user-defined field for the price matrix.

Price Matrix Record

Column	Position	Field	Maximum Length	Format	Required	Description
A	1	Break Type	14	Character	Yes	Enter one of the following break types for the price matrix: product customer-prod customer-class book-prod book-class style customer-style book-style price class
B	2	Customer Code	12	Character	Yes, only if customer-prod, customer-class, or customer-style is entered for the Break Type field (position 1).	Enter a valid customer code for the price matrix. For information on setting up customer codes, see Customer Maintenance.
C	3	Price Book	12	Character	Yes, only if book-prod, book-class, or book-style is entered for the Break Type field (position 1).	Enter a price book for the price matrix. If this price book did not previously exist, it is created during the import process. For information on setting up price books, see Price Book Maintenance.
D	4	Product Code	40	Character	Yes, only if product, customer-prod, or book-prod is entered for the Break Type field (position 1).	Enter a valid product code for the price matrix. For information on setting up product codes, see Product Maintenance.
E	5	Price Class	20	Character	Yes, only if customer-class, book-class, or price class is entered for the Break Type field (position 1).	Enter a price class for the price matrix. If this price class did not previously exist, it is created during the import process. For information on setting up price classes, see Price Class Maintenance.
F	6	Multiply against/Price Source	11	Character	Yes, only if Yes is entered for the Price Multiplier or Discount off Price field	Enter one of the following price or cost types to multiply against or subtract from when creating a price matrix using multipliers or discounts: List1 List2 List3 List4 Avg Cost Std Cost LIFO FIFO Lot Cost Serial Cost Burden Cost Last Cost Do not use your company's naming conventions for the user-defined list prices for List1-4.
G	7	Price Region	10	Character	No	Enter a price region for the price matrix. If this price region did not previously exist, it is created during the import process. For information on setting up price regions, see Price Region Maintenance. If this field is blank, it defaults to All.
H	8	Price 1/Multiple 1/Discount 1/Discount % 1	12	>,>>>,>>9.9999	Yes	Enter the first break price, multiplier, or discount.
I	9	Break 2	10	Character	No	Enter the second break quantity.
J	10	Price 2/Multiple 2/Discount 2/Discount % 2	12	>,>>>,>>9.9999	No	Enter the second break price, multiplier, or discount.
K	11	Break 3	10	Character	No	Enter the third break quantity.
L	12	Price 3/Multiple 3/Discount 3/Discount % 3	12	>,>>>,>>9.9999	No	Enter the third break price, multiplier, or discount.
M	13	Break 4	10	Character	No	Enter the fourth break quantity.
N	14	Price 4/Multiple 4/Discount 4/Discount % 4	12	>,>>>,>>9.9999	No	Enter the fourth break price, multiplier, or discount.
O	15	Break 5	10	Character	No	Enter the fifth break quantity.
P	16	Price 5/Multiple 5/Discount 5/Discount % 5	12	>,>>>,>>9.9999	No	Enter the fifth break price, multiplier, or discount.
Q	17	Break 6	10	Character	No	Enter the sixth break quantity.
R	18	Price 6/Multiple 6/Discount 6/Discount % 6	12	>,>>>,>>9.9999	No	Enter the sixth break price, multiplier, or discount.
S	19	Break 7	10	Character	No	Enter the seventh break quantity.
T	20	Price 7/Multiple 7/Discount 7/Discount % 7	12	>,>>>,>>9.9999	No	Enter the seventh break price, multiplier, or discount.
U	21	Break 8	10	Character	No	Enter the eighth break quantity.
V	22	Price 8/Multiple 8/Discount 8/Discount % 8	12	>,>>>,>>9.9999	No	Enter the eighth break price, multiplier, or discount.
W	23	Break 9	10	Character	No	Enter the ninth break quantity.
X	24	Price 9/Multiple 9/Discount 9/Discount % 9	12	>,>>>,>>9.9999	No	Enter the ninth break price, multiplier, or discount.
Y	25	Break 10	10	Character	No	Enter the tenth break quantity.
Z	26	Price 10/Multiple 10/Discount 10/Discount % 10	12	>,>>>,>>9.9999	No	Enter the tenth break price, multiplier, or discount.
AA	27	Start Date	10	99/99/9999	Yes	Enter the first date in a range of dates for the price matrix.
AB	28	End Date	10	99/99/9999	Yes	Enter the last date in a range of dates for the price matrix.
AC	29	Authorization Status	6	Character	No	Enter Active, Plan, or Review. For more information, see Pricing Authorization Level FAQ. If this field is blank, it defaults to Active.
AD	30	Family Price Code	10	Character	No	Enter a valid family price code for the price matrix. For information on setting up family price codes, see Family Price Maintenance.
AE	31	User Defined 1	60	Character	No	Enter data for user-defined field 1.
AF	32	User Defined 2	60	Character	No	Enter data for user-defined field 2.
AG	33	User Defined 3	60	Character	No	Enter data for user-defined field 3.
AH	34	Style	12	Character	Yes, only if style, customer-style, or book-style is entered for the Break Type field (position 1).	Enter a valid style for the price matrix. For information on setting up styles, see Style Maintenance.
AI	35	Currency	8	Character	No	Enter a valid currency for the price matrix. For information on setting up currencies, see Currency Maintenance. If this field is blank, it defaults to the customer's default currency or the ledger default currency.
AJ	36	Ignore Margin Check	3	Yes/No	No	Enter Yes if you want the price matrix to be ignored by margin checking (if margin checking is enabled for a related product). This field defaults to No. For more information, see Gross Margin Testing FAQ.
AK	37	Special Promotions	3	Yes/No	No	Enter Yes if the price matrix is for a special promotion. Quantities sold for special promotions are tracked separately for sales analysis and DRP. This field defaults to No.
AL	38	Country	10	Character	No	Enter a valid country code for the price matrix. For information on setting up country codes, see Country Maintenance.
AM	39	Price Includes VAT	3	Yes/No	No	Enter Yes or Y if prices for the price matrix include VAT. Enter No or N if prices for the price matrix exclude VAT.
AN	40	Charge 1	12	Character	No	Enter an additional charge/ credit related to the first price break quantity that will automatically be created during order entry.
AO	41	Charge 1 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the first charge.
AP	42	Charge 1 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 1 field, enter an amount or percentage for the first charge.
AQ	43	Charge 2	12	Character	No	Enter an additional charge/ credit related to the second price break quantity that will automatically be created during order entry.
AR	44	Charge 2 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the second charge.
AS	45	Charge 2 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 2 field, enter an amount or percentage for the second charge.
AT	46	Charge 3	12	Character	No	Enter an additional charge/ credit related to the third price break quantity that will automatically be created during order entry.
AU	47	Charge 3 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the third charge.
AV	48	Charge 3 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 3 field, enter an amount or percentage for the third charge.
AW	49	Charge 4	12	Character	No	Enter an additional charge/ credit related to the fourth price break quantity that will automatically be created during order entry.
AX	50	Charge 4 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the fourth charge.
AY	51	Charge 4 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 4 field, enter an amount or percentage for the fourth charge.
AZ	52	Charge 5	12	Character	No	Enter an additional charge/ credit related to the fifth price break quantity that will automatically be created during order entry.
BA	53	Charge 5 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the fifth charge.
BB	54	Charge 5 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 5 field, enter an amount or percentage for the fifth charge.
BC	55	Charge 6	12	Character	No	Enter an additional charge/ credit related to the sixth price break quantity that will automatically be created during order entry.
BD	56	Charge 6 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the sixth charge.
BE	57	Charge 6 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 6 field, enter an amount or percentage for the sixth charge.
BF	58	Charge 7	12	Character	No	Enter an additional charge/ credit related to the seventh price break quantity that will automatically be created during order entry.
BG	59	Charge 7 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the seventh charge.
BH	60	Charge 7 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 7 field, enter an amount or percentage for the seventh charge.
BI	61	Charge 8	12	Character	No	Enter an additional charge/ credit related to the eighth price break quantity that will automatically be created during order entry.
BJ	62	Charge 8 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the eighth charge.
BK	63	Charge 8 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 8 field, enter an amount or percentage for the eighth charge.
BL	64	Charge 9	12	Character	No	Enter an additional charge/ credit related to the ninth price break quantity that will automatically be created during order entry.
BM	65	Charge 9 +/-Sign	1	Character	No	Enter a + or - sign to designate the operation for the ninth charge.
BN	66	Charge 9 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 9 field, enter an amount or percentage for the ninth charge.
BO	67	Charge 10	12	Character	No	Enter an additional charge/ credit related to the tenth price break quantity that will automatically be created during order entry.
BP	68	Charge 10 +/- Sign	1	Character	No	Enter a + or - sign to designate the operation for the tenth charge.
BQ	69	Charge 10 Amount/Percentage	13	>>>>>>>9.9999	No	Depending on the additional charge entered for the Charge 10 field, enter an amount or percentage for the tenth charge.
BR	70	Freight Free - Break 1	3	Yes/No	No	Enter Yes if the first price break is freight free.
BS	71	Freight Free - Break 2	3	Yes/No	No	Enter Yes if the second price break is freight free.
BT	72	Freight Free - Break 3	3	Yes/No	No	Enter Yes if the third price break is freight free.
BU	73	Freight Free - Break 4	3	Yes/No	No	Enter Yes if the fourth price break is freight free.
BV	74	Freight Free - Break 5	3	Yes/No	No	Enter Yes if the fifth price break is freight free.
BW	75	Freight Free - Break 6	3	Yes/No	No	Enter Yes if the sixth price break is freight free.
BX	76	Freight Free - Break 7	3	Yes/No	No	Enter Yes if the seventh price break is freight free.
BY	77	Freight Free - Break 8	3	Yes/No	No	Enter Yes if the eighth price break is freight free.
BZ	78	Freight Free - Break 9	3	Yes/No	No	Enter Yes if the ninth price break is freight free.
CA	79	Freight Free - Break 10	3	Yes/No	No	Enter Yes if the tenth price break is freight free.
CB	80	Price Type	16	Character	No	Enter one of the following price types for the price matrix: Amount Discount - Select this option to enter a price matrix for which prices are costs or prices minus a specific discount amount. If you select this check box, the Price 1 - Price 10 fields are replaced by the Discount 1 - Discount 10 fields. If you select this option, enter the discount amounts and select a price or cost in the Price Source field. Fixed Price - Select this option to enter a price matrix of prices for quantity breaks. Percent Discount - Select this option to enter a price matrix for which prices are costs or prices minus a specific discount percentage. If you select this option, the Price 1 - Price 10 fields are replaced by the Discount % 1 - Discount % 10 fields. If you select this option, enter the discount amounts and select a price or cost in the Price Source field. Price Multiplier - Select this option to enter a price matrix for which prices are costs or prices multiplied by specific multiple values. If you select this option, the Price 1 - Price 10 fields are replaced by the Multiple 1 - Multiple 10 fields. If you select this option, enter price multiplier values and select a price or cost in the Multiply Against field.
CC	81	Unit of Measure	18	Character	No	If the price matrix is for a product, enter a valid selling unit of measure code for the price matrix. Otherwise, enter one of the following types of unit of measure for the price matrix: Default Selling Base UM Default Display Default Packaging Default Purchasing Default Receipt If this field is blank, the price matrix is based on the default selling unit of measure.
CD	82	Adjust	10	Character	No	Enter one of the following options when entering a price matrix that includes a price multiplier or discount off of a specific price: ADJUSTMENT - During order entry, enter the price discount or amount based on a multiplier as an adjustment. UNIT - During order entry, enter the price (including the discount or amount based on a multiplier) as the product unit price. If this field is blank, and the price matrix includes a price multiplier or discount, it defaults to ADJUSTMENT.
CE	83	Break 1	10	Character	No	Enter the first break quantity. If this field is blank, it defaults to zero.
CF	84	Mix and Match	3	Yes/No	No	Enter Yes if price break quantities can be met by the total of ordered products in a price class or product style (instead of the quantity ordered for individual products). Example A price matrix is set up for a price class that includes Product A and Product B. If 10 units are ordered, the products have a lower price. If Yes is entered for this field, the customer can order 6 units of Product A and 4 units of Product B to receive the lower price. If No is entered for this field, the customer must order 10 units of Product A or 10 units of Product B to receive the lower price. If this field is blank, it defaults to No.
CG	85	Shipping Rules	11	Character	No	Enter one of the following options: Proportion - Product quantities can only be shipped with a proportionate amount of the companion product’s quantities. Independent - Product quantities can ship independent of companion product quantities.
CH	86	Action during Order Entry	9	Character	No	Enter one of the following options: Prompt - When a product that is defined to have a companion product is entered for an order, ask the user whether the companion product should be added. Automatic - When a product that is defined to have a companion product is entered for an order, automatically add the companion product. If this field is blank, it defaults to Prompt.
CI	87	Companion Product Notes	500	Character	No	Enter any notes to display during order entry when asking the user whether to add companion products to an order. This field is only used if Prompt is entered for the Action during Order Entry field (position 86).
CJ	88	Ship and Debit Amount 1	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the first price break quantity.
CK	89	Ship and Debit Amount 2	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the second price break quantity.
CL	90	Ship and Debit Amount 3	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the third price break quantity.
CM	91	Ship and Debit Amount 4	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the fourth price break quantity.
CN	92	Ship and Debit Amount 5	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the fifth price break quantity.
CO	93	Ship and Debit Amount 6	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the sixth price break quantity.
CP	94	Ship and Debit Amount 7	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the seventh price break quantity.
CQ	95	Ship and Debit Amount 8	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the eighth price break quantity.
CR	96	Ship and Debit Amount 9	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the ninth price break quantity.
CS	97	Ship and Debit Amount 10	14	>>>,>>>,>>9.99	No	Enter the ship and debit amount for the tenth price break quantity.
CT	98	Maximum Number of Uses	7	Integer	No	Enter the maximum number of uses for the companion product (if applicable). If this field is blank, no maximum number of uses is set up for the companion product. EXAMPLE You only want to give away a free product once for a companion product combination. To set this up, enter 1 for this field.

Price Matrix Override Record

Column	Position	Field	Maximum Length	Format	Required	Description
A	1	Record Type	8	Character	Yes	Enter Override to indicate the record is a price matrix override record.
B	2	Product Code	40	Character	Yes	Enter a valid product code for the price matrix override. It must be a product code included in the related price matrix.
C	3	User Defined 1	60	Character	No	Enter unique data for user-defined field 1 for the associated price matrix. You only need to use this field if the row for the price matrix override record is not immediately below the row for the related price matrix record in the import file.
D	4	Price 1/Multiple 1/Discount 1/Discount % 1 Override	12	>,>>>,>>9.9999	No	Enter the first break price, multiplier, or discount for the product.
E	5	Price 2/Multiple 2/Discount 2/Discount % 2 Override	12	>,>>>,>>9.9999	No	Enter the second break price, multiplier, or discount for the product.
F	6	Price 3/Multiple 3/Discount 3/Discount % 3 Override	12	>,>>>,>>9.9999	No	Enter the third break price, multiplier, or discount for the product.
G	7	Price 4/Multiple 4/Discount 4/Discount % 4 Override	12	>,>>>,>>9.9999	No	Enter the fourth break price, multiplier, or discount for the product.
H	8	Price 5/Multiple 5/Discount 5/Discount % 5 Override	12	>,>>>,>>9.9999	No	Enter the fifth break price, multiplier, or discount for the product.
I	9	Price 6/Multiple 6/Discount 6/Discount % 6 Override	12	>,>>>,>>9.9999	No	Enter the sixth break price, multiplier, or discount for the product.
J	10	Price 7/Multiple 7/Discount 7/Discount % 7 Override	12	>,>>>,>>9.9999	No	Enter the seventh break price, multiplier, or discount for the product.
K	11	Price 8/Multiple 8/Discount 8/Discount % 8 Override	12	>,>>>,>>9.9999	No	Enter the eighth break price, multiplier, or discount for the product.
L	12	Price 9/Multiple 9/Discount 9/Discount % 9 Override	12	>,>>>,>>9.9999	No	Enter the ninth break price, multiplier, or discount for the product.
M	13	Price 10/Multiple 10/Discount 10/Discount % 10 Override	12	>,>>>,>>9.9999	No	Enter the tenth break price, multiplier, or discount for the product.
N	14	Break 1 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the first break ship and debit override amount for the product.
O	15	Break 2 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the second break ship and debit override amount for the product.
P	16	Break 3 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the third break ship and debit override amount for the product.
Q	17	Break 4 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the fourth break ship and debit override amount for the product.
R	18	Break 5 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the fifth break ship and debit override amount for the product.
S	19	Break 6 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the sixth break ship and debit override amount for the product.
T	20	Break 7 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the seventh break ship and debit override amount for the product.
U	21	Break 8 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the eighth break ship and debit override amount for the product.
V	22	Break 9 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the ninth break ship and debit override amount for the product.
W	23	Break 10 Ship and Debit Override Amount	14	>>>,>>>,>>9.99	No	Enter the tenth break ship and debit override amount for the product.

Companion Product Record

Column	Position	Field	Maximum Length	Format	Required	Description
A	1	Record Type	9	Character	Yes	Enter Companion to indicate the record is a companion product record.
B	2	Companion Product Code	40	Character	Yes	Enter a valid product code for a product that is going to be a companion product for the price matrix.
C	3	User Defined 1	60	Character	No	Enter unique data for user-defined field 1 for the associated price matrix. You only need to use this field if the row for the companion product record is not immediately below the row for the related price matrix record in the import file.
D	4	Companion Product Unit of Measure	8	Character	No	Enter the unit of measure to use as a basis for calculating companion quantities. This must be a valid selling unit of measure for the product entered in the Companion Product Code field (position 2). If this field is blank, it defaults to the default selling unit of measure for the product.
E	5	Pricing Option	8	Character	No	Enter one of the following options: Free - The customer is not charged for the companion product. The cost of the companion product still flows through. Regular - Determine the price as if it was entered as an independent product. Special - Use the price entered for the Special Price field (position 6). If this field is blank, it defaults to Free.
F	6	Special Price	12	>,>>>,>>9.99	Yes, only if you enter Special for the Pricing Option field (position 5)	Enter a special price for the companion product. This field is only used if you enter Special for the Pricing Option field (position 5).
G	7					This field is not used. Leave this field blank.
H	8					This field is not used. Leave this field blank.
I	9	Companion Quantity 1	12	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the first price break of the price matrix.
J	10	Companion Quantity 2	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the second price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
K	11	Companion Quantity 3	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the third price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
L	12	Companion Quantity 4	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the fourth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
M	13	Companion Quantity 5	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the fifth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
N	14	Companion Quantity 6	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the sixth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
O	15	Companion Quantity 7	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the seventh price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
P	16	Companion Quantity 8	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the eighth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
Q	17	Companion Quantity 9	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the ninth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
R	18	Companion Quantity 10	10	>>>,>>9.99	No	Enter the quantity of the companion product to add to orders for the tenth price break of the price matrix. This value is ignored if the second price break is not set up for the price matrix.
S	19	Free Goods Billback Percentage 1	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the first price break quantity.
T	20	Free Goods Billback Percentage 2	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the second price break quantity.
U	21	Free Goods Billback Percentage 3	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the third price break quantity.
V	22	Free Goods Billback Percentage 4	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the fourth price break quantity.
W	23	Free Goods Billback Percentage 5	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the fifth price break quantity.
X	24	Free Goods Billback Percentage 6	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the sixth price break quantity.
Y	25	Free Goods Billback Percentage 7	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the seventh price break quantity.
Z	26	Free Goods Billback Percentage 8	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the eighth price break quantity.
AA	27	Free Goods Billback Percentage 9	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the ninth price break quantity.
AB	28	Free Goods Billback Percentage 10	6	999.99	No	Enter the percentage of the cost that can be billed back to the supplier if the companion product is added to an order for the tenth price break quantity.

Prerequisites

Before using this import, the following must be set up:

customer, price books, products, price classes, or product styles

Import Format Notes

If using a price class, you must enter %NONE% for the Product Code field.
The first break quantity is always set to zero.
The start and end dates cannot overlap an existing definition with the same book/customer/class/product/unit of measure information. An error message will appear if there is an overlapping break.
There must be a record of blank space(s) at the end of an import file.