Item data type (SKU)
Item is a master list of products available for shipment within the fulfillment network.
The Item data feed is used to determine the cost of the item and in determining the stockout cost. It is also used to determine the final inventory performance cost including estimating key indicators like retail price and category (which have different stock-out chances), the velocity/week of supply of the items at different granularity such as at style, sub-class, or major-class level, and uses SKU details like size and categories to improve demand and model estimates.
Delta updates are supported for the item data feed.
File name and separator
This data type uses the pipe (|) separator.
The recommended format for the file name is: SKU_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv
Multiple CSV files can be uploaded by compressing into a tar.gz file.
Fields
| Field Name | Required | Type | Description |
|---|---|---|---|
| SKU Number | Yes | STRING | The SKU Number must be the unique identifier for the item for the effective period. |
| Brand ID | No | INT | The Brand ID attribute is the identifier for a specific brand of a product. |
| Corporate Unit Cost | Yes | DECIMAL | The Corporate Unit Cost attribute is the retail unit amount for a SKU of a product. |
| Custom Color Description | No | STRING | Provides a custom color description. |
| Display Style Description | No | STRING | The style description that is shown to the customer. |
| Display Color Description | No | STRING | The color description that is shown to the customer. |
| Hierarchy3 Number | No | INT | The third level of Hierarchy values such as subclass number, major class number, department number, DMA number, GMA Number or Style. This can be used to help impute data for missing dimensional data. The entire hierarchy combination must be unique. Data will be used in the inventory model. At least one level of the hierarchy, must be defined. |
| Hierarchy3 Name | No | STRING | The third level of Hierarchy names such as subclass, major class, department, DMA, GMA, Style. This can be used to help impute data for missing dimensional data. |
| Direct Ship | No | STRING | The Direct Ship attribute is set to Y if the product is shipped direct from
the vendor, N if the product is not. |
| Hierarchy2 Number | No | INT | The second level of Hierarchy values such as subclass number, major class number, department number, DMA number, GMA Number or Style. This can be used to help impute data for missing dimensional data. The entire hierarchy combination must be unique. Data will be used in the inventory model. At least one level of the hierarchy, must be defined. |
| Hierarchy2 Name | No | STRING | The second level of Hierarchy names such as subclass, major class, department, DMA, GMA, Style. This can be used to help impute data for missing dimensional data. |
| Depth | Conditional | INT | The length of the product. This is required if the Ship Depth is not present. |
| Style ID | No | BIGINT | Enterprise specific identifier for the style. |
| Gift Card | No | STRING | Set the Gift Card attribute to Y if the product is a gift card,
N if the product is not. |
| Gift Wrap | No | STRING | Set Gift Wrap to Y if the product can be gift wrapped, N if
the product cannot be gift wrapped. |
| Hierarchy1 Number | No | INT | The first level of Hierarchy values such as subclass number, major class number, department number, DMA number, GMA Number or Style. This can be used to help impute data for missing dimensional data. The entire hierarchy combination must be unique. Data will be used in the inventory model. At least one level of the hierarchy, must be defined. |
| Hierarchy1 Name | No | STRING | First level of Hierarchy names such as subclass, major class, department, DMA, GMA, Style. This can be used to help impute data for missing dimensional data. |
| Group code | No | STRING | Group code |
| Hazardous Material | No | STRING | Set the Hazardous Material attribute to Y if the product is made of
hazardous material, N if the product is not. |
| Height | Conditional | INT | The height of the product. This is required if the Ship Height is not present. |
| Inner Pack Quantity | No | INT | This attribute is the quantity of products in the inner pack. |
| Hierarchy4 Number | No | INT | The fourth level of Hierarchy values such as subclass number, major class number, department number, DMA number, GMA Number or Style. This can be used to help impute data for missing dimensional data. The entire hierarchy combination must be unique. Data will be used in the inventory model. At least one level of the hierarchy, must be defined. |
| Hierarchy4 Name | No | STRING | The fourth level of Hierarchy names such as subclass, major class, department, DMA, GMA, Style. This can be used to help impute data for missing dimensional data. |
| NRF color code | No | STRING | National Retail Foundation color code |
| Outer Pack Quantity | No | INT | Number of units in the outer pack. For example, a case of 144 lighters may contain 12 packs of 12 lighters each. In this case, the Outer Pack Quantity is 144. |
| Liquidity code | No | STRING | Liquidity code for the replenishment cycle. |
| Group indicator | No | STRING | Group indicator |
| Replenishment Indicator | No | STRING | The Replenishment Indicator should be set to Y if an indicator needs to be made when the product must be replenished, or N if an indicator does not need to be made. |
| Seasonality sequence number | No | INT | Seasonality sequence number |
| Ship Alone | No | STRING | Set the Ship Alone attribute to Y if the product must be shipped alone,
N if the product does not need to be shipped alone. |
| Shipping Surcharge Fee | No | DECIMAL | The surcharge fee for shipping, if applicable. |
| Size | No | STRING | The size of the product, such as small, medium, or large. If available, valid values need to be defined. |
| Size unit of measure | No | STRING | The unit of measure for the size. If available, valid values need to be defined. |
| SKU Description | Yes | STRING | The description of the product that matches the SKU number. |
| Custom style description | No | STRING | Custom style description |
| Hierarchy5 Number | No | INT | The fifth level of Hierarchy values such as subclass number, major class number, department number, DMA number, GMA Number or Style. This can be used to help impute data for missing dimensional data. The entire hierarchy combination must be unique. Data will be used in the inventory model. At least one level of the hierarchy, must be defined. |
| Hierarchy5 Name | No | STRING | The fifth level of Hierarchy names such as subclass, major class, department, DMA, GMA, Style. This can be used to help impute data for missing dimensional data. |
| Vendor Style ID | No | STRING | The Vendor Style ID is the vendor style identifier obtained from a specific vendor. |
| Width | Conditional | INT | The width of the product. This is required if the Ship Width is not present. |
| Web Exclusivity Indicator | No | STRING | The Web Exclusive attribute is set to Y if the product is sold exclusively
on the website. If the product is sold online and in-store, the attribute is set to
N. |
| Web ID | No | BIGINT | The Web ID is the identifier for the product that can be queried to get a product image from the web. |
| Warehouse replenishment indicator | No | STRING | Indicates if the product can be replenished from a warehouse. Must be set to Y or N. |
| Weight Unit of Measure | No | STRING | The unit of weight. Valid values are LBS, KGS. Default value is LBS. |
| Weight | Conditional | INT | The weight of a product. This is mandatory if the Ship Weight is not included. |
| Effective Date | No | DATE | The Effective Date attribute corresponds to the date in which a SKU is effective. This attribute is used in the case that a SKU needs to be re-used for a different product. |
| Landed cost | No | DECIMAL | The cost of the item, including customs, taxes, tariffs, and fees. Required for inventory optimization only. |
| Retail price | No | DECIMAL | The retail price without any discounts, adjustments due to commodity price changes. Some customers may have this mapped to InitialUnitRetailAmount. Required for inventory optimization only. |
| Status | No | STRING | The Status attribute indicates the status of the product, such as Corporate level, active, inactive, clearance, promotional, new, or unknown. |
| Expiration Date | No | DATE | The Expiration Date attribute corresponds to the expiration date of a SKU for a product. This is assumed to be a date in the future. |
| Safety Stock | No | DECIMAL | Safety stock for the product at a store. |
| Category | No | STRING | The category to which the product belongs |
| Eligible for ship from store | No | STRING | Indicate if the item can be shipped from a store. |
| Breakable | No | STRING | Set the Breakable attribute to Y if the product is breakable,
N if the product is not breakable. |
| Sell Individually | No | STRING | This attribute indicates if a product can be sold individually if the product is part of a pack. |
| Color | No | STRING | Color of the item. If available, valid values must be defined. If available, use this field instead of custom color description. |
| Style | No | STRING | The style of the item, such as polo or turtleneck. If available, valid values must be defined. |
| Brand Description | No | STRING | The Brand Description is a description for a specific brand of a product. |
| Width unit of measure | No | STRING | The unit of measure for the width of the product. The unit of measure for width, height and depth must be the same. |
| Depth unit of measure | No | STRING | The unit of measure for the depth of the product. The unit of measure for width, height, and depth must be the same. |
| Height unit of measure | No | STRING | The unit of measure for the height of the product.. The unit of measure for width, height, and depth must be the same. |
| Ship Weight | Yes | DECIMAL | The SKU weight dimension is the unit of measure for shipping. |
| Ship Weight Unit of Measure | No | STRING | The weight unit of measure, for example, pounds (LB). |
| Ship Height | Yes | DECIMAL | The height of a product that is used to estimate shipping costs and feasibility. |
| Ship height unit of measure | No | STRING | Unit of measure for height. |
| Ship Length | Yes | DECIMAL | The length of a product that is used to estimate shipping costs and feasibility. |
| Ship Length unit of measure | No | STRING | Unit of measure for length. |
| Ship Width | Yes | DECIMAL | The width of a product that is used to estimate shipping costs and feasibility. |
| Ship width unit of measure | No | STRING | Unit of measure for width. |
| Unit Volume | No | DOUBLE | Volume of the product |
| Unit Volume UOM | No | STRING | Unit of measure in which the volume of the product is measured. |
| Lead time | No | DOUBLE | The lead time associated with the product for fulfillment. |
| Cost currency | No | STRING | The currency that is associated with the cost of a product. This value needs to be in the ISO three letter currency format. For example, USD, GBP, or EUR. |
| Global TIN | No | STRING | The global identification number for the product. |
| Delivery allowed | No | STRING | Is delivery allowed for the product. |
| Pickup allowed | No | STRING | Is pick up allowed for the product. |
| Product class | No | STRING | The product group to which the product belongs. |
| Product UOM | No | STRING | Unit of measure for the product. |
Sample for SKU_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv
|
sku_nbr|brnd_id|corp_unt_cost_amt|cstm_clor_desc|cust_facg_styl_desc|custfacg_clor_desc|dept_nbr|dept_nm|dir_ship_ind|dma_nbr|dma_nm|dpth_um_qty|ei_styl_id|gc_ind|gft_wrap_avl_ind|gma_nbr|gma_nm|gp_cde|hazds_ind|ht_um_qty|innr_pk_qty| maj_cl_nbr|maj_cl_nm|nrf_clor_cde|outr_pk_qty|po_shrt_cyc_ind|prd_gp_ind|rplnt_ind|sea_seq_nbr|ship_aln_ind|ship_srchg_fee_amt|size_cde|size_um_cde|sku_desc|styl_desc|sub_cl_nbr|sub_cl_nm|vnd_styl_id|wd_um_qty|web_exclv_ind|web_id| whse_rplnt_ind|wt_um_cde|wt_um_qty|eff_dte|landed_cost|rtl_price|sku_status_code|exp_date|safety_stock|category|is_sfs_eligible|brk_ind|sell_indv_ind|color|style|brand_desc|wd_um_cde|dpth_um_cde|ht_um_cde|unit_weight|unit_weight_uom|unit_height| unit_height_uom|unit_length|unit_length_uom|unit_width|unit_width_uom|unit_volume|unit_volume_uom|lead_time|cost_currency|global_tin|delivery_allowed|pickup_allowed|prod_class|prod_uom 18037418|12|12.12|RED|MOD|RED|TEST|TEST|TEST|12|TES|3|13133343|y|y|4|test|r|y|3|4|45124561|ret|red|5|y|y|y|4|y|32.23|M|M|sku1|mod|23|ret|tre|5|y|32842348|y|er|2|42736|12.12|12|act|45658|3|serf|y|y|y|red|trer|gret|r|m|m|1|kg|1|m|1|m|1|m|EACH|2.0|USD|YN00876576|Y|Y|prodclass|EACH|USD 18502062|12|12.12|RED|MOD|RED|TEST|TEST|TEST|12|TES|3|13133343|y|y|4|test|r|y|3|4|45124561|ret|red|5|y|y|y|4|y|32.23|M|M|sku1|mod|23|ret|tre|5|y|32842348|y|er|2|42736|12.12|12|act|45658|3|serf|y|y|y|red|trer|gret|r|m|m|1|kg|1|m|1|m|1|m|EACH|2.0|EUR|YN00876576|Y|Y|prodclass|EACH|GBP 18509107|12|12.12|RED|MOD|RED|TEST|TEST|TEST|12|TES|3|13133343|y|y|4|test|r|y|3|4|45124561|ret|red|5|y|y|y|4|y|32.23|M|M|sku1|mod|23|ret|tre|5|y|32842348|y|er|2|42736|12.12|12|act|45658|3|serf|y|y|y|red|trer|gret|r|m|m|1|kg|1|m|1|m|1|m|EACH|2.0|USD|YN00876576|Y|Y|prodclass|EACH|EUR 27620934|12|12.12|RED|MOD|RED|TEST|TEST|TEST|12|TES|3|13133343|y|y|4|test|r|y|3|4|45124561|ret|red|5|y|y|y|4|y|32.23|M|M|sku1|mod|23|ret|tre|5|y|32842348|y|er|2|42736|12.12|12|act|45658|3|serf|y|y|y|red|trer|gret|r|m|m|1|kg|1|m|1|m|1|m|EACH|2.0|GBP|YN00876576|Y|Y|prodclass|EACH|USD 27620934|12|12.12|RED|MOD|RED|TEST|TEST|TEST|12|TES|3|13133343|y|y|4|test|r|y|3|4|45124561|ret|red|5|y|y|y|4|y|32.23|M|M|sku1|mod|23|ret|tre|5|y|32842348|y|er|2|42736|12.12|12|act|45658|3|serf|y|y|y|red|trer|gret|r|m|m|1|kg|1|m|1|m|1|m|EACH|2.0|EUR|YN00876576|Y|Y|prodclass|EACH|GBP |
Sample script to upload data by using the file adapter
/<Install_dir>//AsperaClientLinuxDist/asperaTransferClient.sh -jobname SKUPush
-contentType SKU -server -userid -password -op UPLOAD -src -dest/SKU
-conf /<Install_dir>//AsperaLinuxDist/asperaTransferOption.properties