RELATED TOPICS
Item Master
Overview
The Item Master provides Radial with the client's product information at the SKU level. Data is used to drive Radial’s ERP and WMS system. Radial receives new items and changes to existing items in this file.
An item error report is generated and sent to the client upon load failure. (An email is sent to a distribution list provided by the client.)
Feed Characteristics
| Characteristic | Description |
|---|---|
| Exchange Frequency | Daily to Weekly |
| Timing | Determined with client |
| Sender/Receiver | From client to Radial |
| File Name | StoreCode_ITMMST_yyyymmddhhmmss.XML |
| File Format | XML |
| Receipt Acknowledgement -Standard Receipt Acknowledgement | TBD; File Name: ITMMSTRECACK_yyyymmddhhmmss.XML |
| Exception Reporting |
An acknowledgement report email will be sent to Client for Items successfully loaded and one(s) that fail with reason. |
Feed Attributes
|
ID |
Field |
Description |
Type |
Length |
Required |
Comments |
|---|---|---|---|---|---|---|
|
1 |
StoreCode |
Store number that is assigned by Radial to represent the Client’s web store |
String |
10 |
Yes |
Radial assigned store Code |
|
2 |
ClientItemId |
Client’s item number |
String |
15 |
Yes |
This is the lowest level item number (SKU) |
|
3 |
OperationType
|
Identifies if the record is a new item being added or a change to an existing item Values are: A-Add C-Change |
String |
1 |
Yes |
A product will not get loaded if it is on the item master feed as an Add (A) and it already exists Radial system. Change Record (C): will not be processed if there isn’t a matching SKU in Radial system
|
|
4 |
StyleNum |
This is a code that groups products by size and color. If a product has multiple sizes this number will allow the dropdown box on the web site to display all the sizes for that particular product.
|
String |
15 |
No |
This value cannot be changed via a ‘Change’ record.
If the Client’s Style Number is changed to meet the requirements of the Radial web store, check other processes which may use the Client Style Number (e.g. printed on the Product Packaging and used by the Warehouse) |
|
5 |
StyleDesc |
|
String |
30 |
No |
|
|
6 |
ItemDesc |
The item description is loaded to JDA |
String |
30 |
Yes |
Short Description. |
|
7 |
VendorNum |
Vendor Id Vendor number assigned to Client is default if not sent. For drop-ship items Radial assigned vendor number for fulfiller is required. |
Integer |
6,0 |
No |
|
|
8 |
VendorPartNum |
Vendor part (SKU) number |
String |
15 |
No |
Only used for drop ship items. ’Drop Ship’ flag MUST be set to ‘Y. This field must be blank if not a drop ship item. |
|
9 |
MSRPPrice |
MSRP reference price if using value pricing on the web-store |
Float |
9.2 |
No |
|
|
10 |
RetailPrice |
Retail selling price |
Float |
9.2 |
Yes |
Initial price only. All price updates via Item Price feed.
|
|
11 |
BrandCode |
Brand code |
Integer |
10,0 |
No |
Value for reference only. |
|
12 |
BrandDesc |
Brand Description Will default if no brand is included |
String |
25 |
No |
Configured Field Type = D (Default) This default will be used if Client sends a blank value. Also this value, once assigned, cannot be changed via a ‘Change’ record. |
|
13 |
ColorCode |
Color Code |
String |
10 |
No |
|
|
14 |
ColoDesc |
Color Name |
String |
25 |
No |
|
|
15 |
SizeCode |
Size Code |
String |
10 |
No |
|
|
16 |
SizeDesc |
Size Name |
String |
25 |
No |
|
|
17 |
DimensionCode |
Dimension Code |
String |
10 |
No |
|
|
18 |
DimensioDesc |
Dimension Name
|
String |
25 |
No |
|
|
19 |
DeptCode |
Product Hierarchy Level 1 (department) This is the highest level of the hierarchy. Radial will need to provide this number to the Client |
Integer |
3,0 |
Yes |
|
|
20 |
DeptDesc |
Product Hierarchy Level 1 description |
String |
25 |
No |
|
|
21 |
SubDeptCode |
Product Hierarchy Level 2 (sub-department) |
Integer |
3,0 |
Yes |
|
|
22 |
SubDeptDesc |
Product Hierarchy Level 2 description |
String |
25 |
No |
|
|
23 |
Class |
Product Hierarchy Level 3 (Class) |
Integer |
3,0 |
Yes |
|
|
24 |
ClassDesc |
Product Hierarchy Level 3 description |
String |
25 |
No |
|
|
25 |
SubClass |
Sub Class Code |
Integer |
3,0 |
Yes |
|
|
26 |
SubClassDesc |
Sub Class Description |
String |
25 |
No |
|
|
27 |
UnitCost |
Product cost per unit |
Float |
9.2 |
No |
Drop-ship product purchased via Radial ONLY otherwise default to 0. Used for PO cost for drop ship product. Do not include leading zeroes
|
|
28 |
SeasonCode |
Attribute for seasonal code |
String |
5 |
No |
Configured Field Type = D (Default) If Client sends a blank value this default value will be used. |
|
29 |
ItemStatus |
Identifies the lifecycle of a product, valid values: A = Active D = Discontinued I = Inactive
|
String |
1 |
Yes |
Products with an Active (A) Status or a Discontinued (D) Status will be displayed on the website. There is no functional difference between status A and D. Clients may use A and D for reporting purposes. Products with an Inactive (I) Status will not be displayed on the website.
See related backorder code (field 32). |
|
30 |
DropShipFlag |
Product will be shipped from drop ship vendor to customer Valid values: Y/N Default = N |
String |
1 |
No |
If this field is “Y’, Vendor Number (field 7) and Vendor Part Number (field 9) must be populated. |
|
31 |
BackorderCode |
Used to indicate that backordering is allowed. Blank and N = Never backorder, R= Always backorder.
|
String |
1 |
No |
Valid Values: Blank, N, R If Item status is changed to I (inactive) then the Backorder Status code will need to be changed to N (Never). If a Backorder exists for a product and the Item Status for the product is changed to I (and Backorder Status is changed to N), Customer Service will cancel the backorders (An email will be generated to inform the customer that the product is no longer available.
|
|
32 |
CountryOrg |
Identifies the country in which the product was manufactured.
|
String |
2 |
Yes |
If Radial provides fulfilment services, then the Country of Origin will be updated by the warehouse during product receiving (Product profiling). ISO 3166-1-alpha-2 country codes are used. |
|
34 |
SafetyStock |
Safety Stock Level Quantity
|
Integer |
2,0 |
No |
If used, once the inventory for a product reaches the safety stock level it will be removed from the website.
|
|
35 |
UPC |
Only if items have a single UPC otherwise use UPC feed.
|
Integer |
14,0 |
No |
This value cannot be changed via a ‘Change’ record. The UPC feed supports changes to the UPC and allows multiple UPCs for an item.
|
|
36 |
Length |
The length of the package in centimetres or inches.
|
Float |
5.1 |
No |
If length is not initially valued (via the feed) it will be defaulted; however, once the product is received at the Distribution Facility the actual length will be determined and loaded into the system Do not include leading zeroes |
|
37 |
LengthUOM |
Length Unit of Measure I = Imperial M = Metric |
String |
2 |
No |
|
|
38 |
Height |
The Height of the package in centimetres or inches.
|
Float |
5.1 |
No |
If height is not valued (via the feed) it will be defaulted; however, once the product is received at the Distribution Facility the actual height will be determined and loaded into the system. Do not include leading zeroes |
|
39 |
HeightUOM |
Height Unit of Measure I = Imperial M = Metric |
String |
2 |
No |
– |
|
40
|
Width |
The Width of the package in centimetres or inches.
|
Float |
5.1 |
No |
If width is not valued (via the feed) it will be defaulted; however, once the product is received at the Distribution Facility the actual width will be determined and loaded into the system Do not include leading zeroes |
|
41 |
WidthUOM |
Width Unit of Measure I = Imperial M = Metric |
String |
2 |
No |
– |
|
42
|
Weight |
The Weight of the package in kilograms or pounds (lbs).
|
Float |
7.3 |
No |
If weight is not valued (via the feed) it will be defaulted; however, once the product is received at the Distribution Facility the actual weight will be determined and loaded into the system Do not include leading zeroes |
|
43
|
WeightUOM |
Weight Unit of Measure I = Imperial M = Metric |
String |
2 |
No |
|
|
44 |
ReleaseDate |
If populated with a date, orders will be accepted but not shipped until the date is met
|
String |
10 |
No |
Only the date portion will be used. The time portion is stripped off at this time. ISO-YYYY-MM-DD
|
|
45 |
ScanFlag |
Determines if item needs to be scanned during shipping to capture serial number
|
String |
1 |
No |
A value of Y would indicate that the item needs to be scanned during shipping. |
|
46 |
HazmatCode |
Hazardous Material Code |
String |
2 |
No |
|
|
47 |
ItemAttribute |
Client SKU attribute |
String |
30 |
No |
|