How to set up and maintain Customer cross reference and UPCs in Impress.

How to set up and maintain Customer cross reference and UPCs in Impress.

🔎 Overview

Customer SKU cross-references are essential for: - EDI 850/846/810 compliance - PromoStandards Inventory/Item/Invoice APIs - Pre-decorated Pick/Pack programs - Hangtag and barcode generation - Retail integration (Amazon, Walmart, team stores)

Every SKU + Garment Design + Size combination must have a valid cross-reference if the customer requires it. Customer cross-references must be consistent in type per customer account.

📁 Types of Cross-References

Cross-Ref Type

Use Case

Ours Base SKU only

For basic POS (retail) – ignores decoration, not suitable for integration. It is maintained by Inventory Sourcing or Merchndising in the SKU maintenance.

Ours

Vantage-assigned UPCs by Customer Service in the Customer account

Customer Provided

UPC provided by the customer (e.g., Walmart, Amazon)

⚙️ Setup Per Customer

1.     Navigate to
A/R > Maintenance > Customers

2.     Under Order Entry Setup tab:

o  Enable ✔️ “Customer’s SKU Numbers Required” if cross-references are mandatory

o  Set appropriate UPC Option:

§ Ours

§ Customer Provided

§ Optional

§ None

o  Use Use Customer# field if this is a child account referencing a master

Note: DO NOT mix cross-reference types within the same customer account. This causes integration failures.

📒 Creating & Managing Cross-References

Path:
A/R > Maintenance > Customers > Customer SKU# Tab

1.     Select the customer account

2.     Click
Add-F2 or Import

3.     Fill in each row:

o  Garment Design#

o  SKU#

o  Size

o  Customer SKU#

o  Customer UPC

o  Pack, Pre-Price, Price (optional)

o  Commission %

4.     Update:

o  EDI 846 Flag (UserDefinedString1):

§ Active: Included in EDI/PromoStandards

§  Inactive: Excluded from all integrations

§  ZERO: Sent with 0 available qty (e.g., expired CLC SKUs)

o  Process (UserDefinedString2):

§  PickPack: Enables exposure of decorated warehouse stock in predecorated program
A screenshot of a computer AI-generated content may be incorrect.

5.     Save using F10

📅 Importing From Excel

1.     Create your Excel file and save on your H drive (you should be in office) with the following columns:

o  Customer #, Garment Design#, SKU#, Size

o  Customer SKU#, UPC, Description

2.     Format UPC column as Text to avoid scientific notation

3.     Save as.xls

4.     Click
Import in the Customer SKU screen

5.     Map the columns, click
Next and review before importing
A screenshot of a computer AI-generated content may be incorrect.

❌ Common Errors to Avoid

·        No Auto-Created UPCs: Disable auto-create in SOE; they store in Item Master and disrupt integrations

·        No mixed cross-ref types within a customer account

·        No reuse of exposed UPCs

·        No missing cross-ref if required by the customer (SO cannot be saved)

·        No UPC validation unless you are certain UPCs are accurate

📌 Maintenance Notes

·        Use the Customer Listing Report to distribute active cross-references

·        Use Inactive or ZERO to block expired SKUs or licensing restrictions

·        Use Use Customer# to allow child accounts to inherit master cross-reference lists

·        Impress allows duplicate UPCs – only enable validation when required



    • Related Articles

    • Custom EDI Integration with Fanatics

      This document outlines the processes and responsibilities for integrating with Fanatics’ custom EDI and API systems. It includes steps for onboarding, sales order management, packing and shipping, invoicing, and IT processes. Each department is ...

    • How to keep Fanatics Inventory EDI 846 accurate.

      Here are the step you need to follow in Impress Customer Maintenance. When you enter the new UPC, you set it to “INACTIVE.” When the 10-digit Customer SKU is received from Fanatics (entered in Impress) AND the valid collegiate license approved, you ...

    • How to check and submit Fanatics ASNs in Impress

      How to check and submit Fanatics ASNs in Impress Run Shipping report Select Fanatics Shipping Report version Add Shipment Created Date ( depending on when you are doing it, it might be today or yesterday) Save to CSV, print Once excel opens sort by ...

    • Integration SKUs

      For any integrated program… when customers are passing SKUs, we need 1 of the following… · Blank Product - The Valid Full Vantage SKU, IE… 2600BLKSM Decorated Product – a Valid Full Vantage SKU with GarmentDesign Shortcut IE… 2600BLKSM-G1234567 A ...

    • Process for Impress placement setup

      Process to setup placements. Select the name and unique codes based on attached set placements (Mngmt) Arrange for CSR and Production training, SOP, etc. Submit to Merchandising (Breanna W) a request for placement template image - JPG <120 KB size ...