CMI Pricebook Import File Specifications
This is DAC’s implementation of a standard record layout and file specification for CMI Pricebook Import. DAC will furnish a file in this format.
File Specification :
The file is written as a comma-delimited ASCIIfile.
If there is no data available for a field, the field is left blank, but the field is not eliminated from the file.
Double quotes (“) are eliminated from all of the alphanumeric fields.
Record Layout :
Field **Type*LenDescription
1. Item NumberA/N 15Identification for a product.
2. DescriptionA/N 30Product description.
3. Purchase Descrip.A/N 10Description of the way the product is
packed when sold by the wholesaler to the retailer.
Example:
Cigarettes - CARTON.
Candy bars - BOX.
4. Purchase QuantityN 5.0The number of retail units that are
packed and sold by the wholesaler to the retailer. This number is expressed in the smallest retail unit.
Example:
Cigarettes purchased by the carton are sold either by the pack or by the carton. With 10 packs to the carton you fill in purchase quantity with 10.
Candy Bars are purchased by the box and sold individually. With 24 bars to the box you fill in purchase quantity with 24.
For a candy bar that is packed twenty-four to a box, the purchase quantity would be 24.
5. CostN 10.5The amount the wholesaler charges for the
purchase quantity.
Example:
For cigarettes, the purchase cost would be the cost of a carton.
For a candy bar, the purchase cost would be the cost of a box.
6. Retail DescriptionA/N 10Description of the way the product is
sold by the retailer.
Example:
Cigarettes by the pack – PACK
Cigarettes by the carton – CARTON
Candy Bar – EACH
7. Selling QuantityN 5.0The number of retail units that are sold
by the retailer.
Example:
Using cigarettes as an example, the smallest retail unit is the pack.
Cigarettes by the pack - Sell Qty = 1
Cigarettes by the carton – Sell Qty = 10
For most items, this quantity is 1.
8. Retail priceN 8.2The amount the retailer charges for the
item at the selling quantity that has been set. If the selling quantity is 1, this is the retail price for one item.
Example:
For a carton of cigarettes where the selling quantity is 10, the retail price is the suggested retail for a carton of cigarettes.
For cigarettes by the pack, the retail price is the suggested retail for a pack of cigarettes.
9. Department/CategoryA/N 10This is the wholesaler’s department/category
When the pricebook is setup for the wholesaler in C-Store Books, this department /category must be cross-referenced to the retailer’s categories/departments.
10. UPCA/N 15This is the field that should be used if
there is only one UPC. This should be the product UPC for the retail unit. The check digit for the UPC is not needed. Explanation:
028000 – Manufacturer number
24210 - Product ID
7 - Check digit
For our use we need the Manufacturer code
and the product ID. The check digit is not needed.
11. 2nd UPCA/N 15Example:
For items such as cigarettes that have
two UPC codes, this is the second UPC code.
12. CaseqtyN 5.0The number of retail units that are sold
by the retailer for the case.
Example:
Using cigarettes as an example, the smallest retail unit is the pack.
Cigarettes by the pack - Sell Qty = 1
Cigarettes by the carton – Sell Qty = 10
13. CaseRetailN 8.2The amount the retailer charges for the
item at the selling quantity that has been set. If the selling quantity is 12, this is the retail price for the case.
Example:
For a carton of cigarettes where the selling quantity is 10, the retail price is the suggested retail for a carton of cigarettes.
** Type
A/N = Alphanumeric
N = Numeric
** Len – For a numeric field the format for len is :
total length of field . digits to right of decimal
** See notes below for items with multiple UPCs.
********************************************************************************
A list of the department numbers and description is also needed. This will ensure that the correct departments will be assigned when setting up the pricebook.
Example:
01 – Grocery
02 – Cigarettes
03 – Candy
Notes on items with multiple UPCs, such as cigarettes :
There are two methods for sending items with multiple UPCs.
- Send one record with both UPC codes. The pack UPC would be in the first
UPCfield and the carton UPC would be in the second UPC field.
This is the preferred method
Cigarette Example :
Item number
Description
Purchase descriptionCARTON
Purchase quantity10
Costcost for a carton
Retail descriptionPACK
Selling quantity1
Retail priceretail price for a pack
Department/Category
UPCpack UPC
2nd UPCcarton UPC
Caseqtycase selling qty
CaseRetailcase retail price
- Send two records for the same item. The first record would contain the
information for the pack and the second record would contain the carton information. The records must be in this order.
Cigarette Example :
1st record - PACK or EACH
Item number
Description
Purchase descriptionCARTON
Purchase quantity10
Costcost for carton
Retail descriptionPACK
Selling quantity1
Retail priceretail price for a pack
Department/Category
UPCpack UPC
2nd UPCleave blank
2nd record - CARTON
Item number*same as 1st record
Description*same as 1st record
Purchase descriptionCARTON
Purchase quantity10
Costcost for carton
Retail descriptionCARTON
Selling quantity10
Retail priceretail price for a carton
Department/Category
UPCcarton UPC
2nd UPCleave blank
Confidential Property of Creative Data Research October 4, 2004