Product Data Template Overview

 

Overview  

The purpose of the Nordstrom-NuORDER Product Data Template is to collect the information you would typically be preparing for the Nordstrom IIF (Item Intent Form). Our goal is to have your product data loaded in NuORDER prior to your appointments so that your Buyers can take notes and create visual assortments. We've designed this template to be as intuitive and user friendly as possible, with reference tables and drop downs to streamline the process. You’ll notice we’ve provided helpful notes throughout the template to aid in set up.

Helpful Tips

• Note the first fifteen columns ("Style Number" - "Size 1") are required fields.
• The more complete information you provide, the more seamlessly you will be able to interact with the Nordstrom buyers. There will be less follow up required to complete the fields post-market. 
• Any restrictions on formatting, character limitations, etc. are detailed in the first row of template.
• Avoid copying and pasting HTML code in these fields as it can corrupt data.
• Save the file as CSV (Comma Separated Value) format.

Filling Out the Template

Critical Fields

 “Style Number,” “Season,” and “Color” create a unique product in NuORDER. 

• Style Number | In most cases, this is the same as the Nordstrom VPN Number.
• Season | If you don’t apply Seasons to your products, we recommend a placeholder like “Core.”
• Color | Usually the same as color name. Placeholders like “Assorted” or “Multi” are commonly used. Pattern names like “Plaid” or “Polka Dot” are also common.
• Parent Style Number | If your ERP or PLM system has a style master where all product attributes roll up into a style number id, the below field is where you can provide this. This field can be disregard if your system does not provide.
• Brand_ID | If your ERP or PLM system has a style master where all product attributes roll up into a style number/color id, the below field is where you can provide this.  This field can be disregard if your system does not provide.

Additional Required Fields

• Name | This the same as the Nordstrom Description.
• Wholesale USD & Retail USD | Enter as currency without a dollar sign. Retail USD is the same as MSRP.
• Size Notes | Indicate the size range the item is available in - use the exact sizes that will be loaded into the e-catalog. Note if European sizes.
• Size | You must fill out the “Size 1” column.
  • If you do not have size run info available, common placeholders include “OS” for “One Size,” “Multi," or "Assorted."
  • If you have a full size run, list them broken out horizontally (Size 2, Size 3, etc.). If the provided number of columns is not sufficient, add more as needed. 

• Size Descriptions | This in a sizes physical description of dimensions. Example: 7 Med, 7 Wide, 32x34
• UPC | This is where you can upload and assign a UPC, if you'd like this information on NuORDER. 
• SKU ID | Please specify an internal non-changing id that uniquely points to a product at the size level. This is an internal peer to UPC (which is external and can be recycled)

The Nordstrom Recommended Fields

Nordstrom buyers will require these fields are completed, we strongly recommend you have these completed before your market dates.

• Special Cost | IMPORTANT: ANNIVERSARY PRICING. Additional discounted cost from the standard cost offered to Nordstrom. 
• Actual Retail | The price Nordstrom can sell this in their stores. (Negotiated discount)
• NRF Color Code | Please refer to the "NRD & Direct Color" tab to view NRF and Direct Color Family Chart for color codes.
• DS Indicator, Case Pack Indicator, & Hazmat Indicator | Simply mark with and “X” if applicable.
• Case Pack Description | Provided detail of the contents. 

• Order Multiple | Please indicate if an item can only be shipped in multiple units BY LOCATION - EX. EACH STORE must receive either 6, 12 or 18 units but NEVER can be shipped 10 - then your order multiple is 6.
• Allocation | If you have a maximum number of items that Nordstrom can order, please indicate that here.

Optional Nordstrom Fields

• Collection Name, Care Instructions, Fabric Description | Note character limitations in template notes for these short descriptions.
• Order Multiple | Indicate if an item can only be shipped in multiple units by location.EX. EACH STORE must receive either 6, 12, or 18 unites but NEVER 10 - then your order multiple is 6.
• Allocation | Indicate the maximum number of items Nordstrom can order. 

International Fields

• UT HTS Code(s) | Reserved for 10 digit code used for importing goods in the US & Puerto Rico.
• US Country of Sourcing, US Country of Manufacture, & Import Country | Reference the "Country Code" tab for appropriate code.
• CA Style Number | Alternate style number for Canadian products
• Wholesale USI & Retail USI | Prices entered here are prices for Canadian stores in Supplier Currency (USI stands for US International pricing). Enter as currency without a dollar sign.
• CA Special Cost
• CA HTS Code(s) | Place 10 digit code for importing goods from Canada.
• CA Country of Sourcing & CA Country of Manufacture | Reference the "Country Code" tab for appropriate code. 

If you have any additional questions about filling out this template, please contact [e-mail] for assistance.