The Item / Cost Compare template lists a variety of fields that can be used to compare retailer and supplier data. However, only two fields are required for a basic item compare: Product Code and Product Code Type. All other fields are required only if you wish to verify data at that level. For example, Net Weight and Net Weight Code are used only if weight synchronization is important to the match.
The same scenario is used with the Base Cost, Allowance, and Net Cost fields. If you are only verifying Product Codes you can leave the cost fields blank. However for a cost comparison, you must include the cost fields to be compared.
Use the following as a guide to completing the template. The template is called: DATA COMPARE TEMPLATE.XLS.
Additional Item Compare Fields
Template with basic Item Cost fields
Use these to compare basic item information. The Product Code and Product Code Type fields are required for both item and cost compares.
|
Col |
Field Name |
Description |
Notes |
|
A |
Product Code |
UPC, EAN, or other product code. |
REQUIRED for all compares. Do not include hyphens. For example, enter 0-55555-44444-1 as 05555544441. Must match the Product Code Type. Note: To avoid dropping leading zeros, format the cells to Text and Paste Special > Values. |
|
B |
Product Code Type |
Type of code, such as UABC for a UPC in 10-digit 0-5-5-0 format. |
REQUIRED for all compares. UABC -- UPC 10 digits in format 0-5-5-0 For example, enter 5555544444. UAUI -- UPC 11 digits in format 1-5-5-0 For example, enter 05555544444. UAUA -- UPC 12 digits in format 2-5-5-0 For example, enter 015555544444. UAUP -- UPC 12 digits in format 1-5-5-1 For example, enter 055555444441. UACD -- UPC 11 digits in format 0-5-5-1 For example, enter 55555444441. UAAD -- UPC 13 digits in format 2-5-5-1 For example, enter 0155555444441. UA3D -- UPC 14 digits in format 3-5-5-1 For example, enter 10055555444441. UA30 -- UPC 13 digits in format 3-5-5-0 For example, enter 1005555544444. UAZS -- UPC 6 digits zero suppressed For example, enter 545432. EAUA -- EAN 12 digits in format 2-5-5-0 For example, enter 005555544444. EAAD -- EAN 13 digits in format 2-5-5-1 For example, enter 0055555444441. GT3D -- GTIN 14 digits in format 3-5-5-1 For example, enter 10055555444441. VND -- Vendors (Suppliers) Item Number.
|
|
C |
Item Order Number |
Supplier's item number.
|
Optional. |
|
D |
Description |
Description or name of the item.
|
Optional. Should NOT include commas or double-quotes. These can cause errors and skew the results. |
|
E |
Size Unit of Measure Quantity |
Numerical value for the item's size, such as 12.
|
Optional. |
|
F |
Size Unit of Measure Code (units) |
Size unit, such as OZ or LB.
|
Optional. |
|
G |
Size Description |
Description or concatenation of the size, such as 12 OZ.
|
Optional. Use if separate Size Unit of Measure Quantity and Size Unit of Measure Codes are not available. |
|
H |
Pack |
The largest bundle of items within a vendor unit (such as a case). For example, a case of candy bars might contain 10 packs of individual bars.
|
Optional. |
|
I |
Inner Pack |
The next bundled-level within the vendor unit. For example, each box (pack) of candy bars could contain 25 bars (25 inner packs).
|
Optional. |
|
J |
OSUQ |
Order shipping unit quantity. The total number of consumer units within the vendor unit. A case of 10 boxes with 25 bars per box has an OSUQ of 250.
|
Optional. |
Use these to compare cost information. The Product Code and Product Code Type fields are required for both item and cost compares.
|
Col |
Field Name |
Description |
Notes |
|
K |
Retailer's Cost Zone ID |
If available, retailer's identification for the vendor's cost zone.
|
Optional. |
|
L |
Base Cost |
Item cost, without an allowance.
|
REQUIRED if the base cost will be compared. Otherwise can be left blank. |
|
M |
Allowance |
Any allowance off the base cost.
|
REQUIRED if the allowance will be compared. Otherwise can be left blank. |
|
N |
Net Cost |
Base cost minus the allowance.
|
REQUIRED if the net cost will be compared. Otherwise can be left blank. Many retailers store this amount only. |
|
O |
Cost Effective Date |
The date the cost became or will be effective.
|
Optional. Enter dates in the format mm/dd/yyyy or m/d/yyyy. May require formatting cells as Date. If left blank, assumed to be the current cost "as of" the compare date. This will show up as a discrepancy, with the supplier's current effective date highlighted. |
|
P |
Cost End Date |
The date the cost ends.
|
Optional. Enter dates in the format mm/dd/yyyy or m/d/yyyy. May require formatting cells as Date. Used only for promotions and "temporary costs" entered by the supplier. |
Additional Item Compare Fields
These compare retailer-specific information, such as SKU or Buyer Code, and shipping information such as Cube Adjusted Weight.
|
Col |
Field Name |
Description |
Notes |
|
Q |
SKU |
Retailer's stock keeping unit.
|
Optional. |
|
R |
Buyer Code |
Retailer's code for the buyer.
|
Optional. |
|
S |
MCAT Code |
Retailer's merchandise category code.
|
Optional. |
|
T |
Gross Weight |
Numerical gross weight of the item.
|
Optional. |
|
U |
Gross Weight Code |
Weight unit, such as OZ or LB.
|
Optional. |
|
V |
Net Weight |
Numerical net weight of the item.
|
Optional. |
|
W |
Net Weight Code |
Weight unit, such as OZ or LB.
|
Optional. |
|
X |
Cube Adjusted Weight |
Cube Adjusted Weight of the item.
|
Optional. |
|
Y |
Cube Adjusted Weight Code |
Weight unit, such as OZ or LB. |
Optional. |
|
Z |
Height |
Numerical height of the item.
|
Optional. |
|
AA |
Height Code |
Height unit, such as IN, CM, or MM.
|
Optional. |
|
AB |
Width |
Numerical width of the item.
|
Optional. |
|
AC |
Width Code |
Width unit, such as IN, CM, or MM.
|
Optional. |
|
AD |
Length |
Numerical length of the item.
|
Optional. |
|
AE |
Length Code |
Length unit, such as IN, CM, or MM.
|
Optional. |
|
AF |
Volume |
Numerical volume of the item.
|
Optional. |
|
AG |
Volume Code |
Volume unit, such as IN, CM, or MM.
|
Optional. |
|
AH |
Number of Layers per Pallet (HI) |
Number of Layers per Pallet.
|
Optional. |
|
AI |
Number of Cases per Pallet Layer (TI) |
Number of Cases per Pallet Layer.
|
Optional. |
Template with basic Item & Cost fields
The fields populated in this template will compare retailer UPCs, Size, and Costs with those submitted by the supplier in Park City Group.
New 4/3/2007