Instructions for editing FastTrack Excel product listings

Back

11542

Issue:

This article provides complete instructions on how to edit an Excel file for FastTrack entry.

Solution:

BASIC RULES:

 

·         Always start with the Excel file downloaded from the SAGE Supplier Center.  See How to submit your product information to SAGE using FastTrack.

 

·         DO NOT delete or otherwise alter any part of the header on the spreadsheet

 

·         Never change the ProductID (Column A)

 

·         When sorting, start the sort below the header on row 8 and expand all columns

 

·         If the product already exists in the list, update that row of the spreadsheet.  DO NOT delete the row and re-add a new one for the same product.

 

·         For “True/False” fields you may use the values “True/False”, “Yes/No”, or “1/0” (1=True/Yes, 0=False/No).  These are not case sensitive.

 

·         If uploading a PDF catalog with your FastTrack, attach the catalog to “PDF Catalog” under “Bulk Update” BEFORE submitting the FastTrack.  The “Catalog Year” and “Catalog Expiration Date” MUST match the dates on the spreadsheet.

 

·         Required fields are denoted with an asterisk (*)

 

INSTRUCTIONS FOR SPECIFIC FIELDS:

 

Column A – ProductID *

·         For existing products, the product ID uniquely identifies the product and CANNOT be changed

·         For each new product, set the ProductID to “-1”.  This indicates to the system that it is a new product and will be added and assigned a unique product ID.

 

Column B – ItemNum *

·         Character limit: 25

·         This field should contain the product’s internal item number

·         All items MUST have an item number.  If the product DOES NOT have an item number, you may enter an asterisk (e.g., “star”) to have the system assign the product an item number automatically.

·         Item numbers may contain letters, numbers and special characters (hyphens, spaces, periods and forward slashes)

 

Column C – Name *

·         Character limit: 100

·         This field should contain the product name

·         Make sure that the product name clearly identifies what the product is (e.g., a flashlight called a “Maxbright” should be read “Maxbright Flashlight”)

 

Column D – CatYear *

·         Enter year of the printed/digital catalog you are using

·         If you don’t have a printed/digital catalog, enter the current year

·         This year MUST match the year you input when submitting the FastTrack on step 3 of the Bulk Update option in the SAGE Supplier Center

 

Column E – ExpirationDate *

·         Enter the date your product listing should expire

·         This year MUST match the year you input when submitting the FastTrack on step 3 of the Bulk Update option in the SAGE Supplier Center

 

Column F – Discontinued *

·         False =Not discontinued, True=Discontinued

·         DO NOT delete the row if the product is discontinued

·         Discontinued products will not show up in product searches but may be located (with a note that it is discontinued) if a distributor searches for the product using the specific SAGE Product Code

·         Discontinued products will be marked “For Deletion” in the SAGE Supplier Center

 

Columns G & H – Cat1Name * & Cat2Name

·         These fields specify the product category for your product

·         The category is whatever the product is

·         You can specify up to two categories, but most products will only have one category

·         Features of the products are keywords, not categories (e.g. a ceramic mug would be in the Mugs category, a keychain with a flashlight would be in the Keychains and Flashlights categories)

·         The categories MUST correspond to a category listed in SAGE.  You can use the SAGE Supplier Center to view the available category list by navigating to “Supplier Profile and Catalog” -> “Catalog” - > “5. Edit Products” -> “Add Product” -> “Category” drop-down menu

·         Ensure that the full category name is spelled out correctly

 

Columns I & J – Page1 & Page2

·         These are the catalog pages for your product

·         If you do not have a catalog, leave both blank

·         If the product is on one catalog page, fill in Page1 (Column I) and leave Page2 (Column J) blank

·         If the product is on two catalog pages, Page1 (Column I) will be the page the product image is shown on while Page2 (Column J) will be the product pricing or additional information page

 

Column K – Description

·         Character limit: 500

·         This should be a sentence-based description of the product

·         It MUST be end-user safe (e.g. pricing, company or contact information including web or social media addresses should NOT be listed in the description)

·         Incorporating inappropriate content will cause your update to fail and/or indexing penalties for your products in our research services

 

Column L – Keywords *

·         Character limit: 200, 35 characters between commas

·         This fields should contain a comma-separated list of search words or phrases

·         The words in your description will ALREADY be included as search words.  Therefore, this field should only include additional search terms for your products. 

·         Repetition of keywords/key phrases is NOT necessary (e.g. American Flag, American, Flag).  This will result in automatic index penalties.  However, you are encouraged to specify words in different ways (e.g. “American Flag” and “US Flag”).

·         Do NOT include colors in your keywords/ key phrases.  Colors go in the colors field.

·         Use “title case” for punctuation (e.g. Flashlight, Xenox Bulb, Metal Body”).

·         You may not use AND, OR, NOT or WITH in keywords/key phrases

 

Column M – Colors *

·         Character limit: 1,000, 35 characters between commas

·         Comma-separated list of colors

·         Use “title case” for punctuation (e.g. Red, Green, Blue)

·         If the color is not a basic color, be sure to specify the basic color with the true color name (e.g. instead of “Emerald, Navy, Brick” it would be “Emerald Green, Navy Blue, Brick Red”)

·         If the product is multiple colors, separate the colors with a forward slash listing the main color first (e.g. Red/White)

·         Do NOT use the words “Any, All, PMS, Many, Most, See Picture, Full” as colors

 

Column N – Themes

·         Comma-separated list of themes

·         Maximum of 5 themes per product

·         These MUST correspond to the approved themes list.  You can use the SAGE Supplier Center to view the approved themes list by navigating to “Supplier Profile and Catalog” -> “Catalog” - > “5. Edit Products” -> “Add Product” -> “Themes” and scrolling through the options.

 

Columns O, P, Q, R, S, T, U, V & W – Dimensions

·         The physical measurements of the product in the order presented in your catalog or website

·         There are three fields for the three different dimensions of the product

·         If you fill in a dimension value, you MUST also fill in the corresponding dimension unit and type

·         Each dimension requires a numerical value, unit and type

o    Dimension1 (Column O), Dimension2 (Column R) & Dimension3 (Column U)

§  This will be the first, second and third-dimension values (e.g., “7”, “3 1/2”, “0.25)

o    Dimension1Units (Column P), Dimension2Units (Column S) & Dimension3Units (Column V)

§  This will be the first, second and third-dimension unit of measurement. Use the indicated value to specify the unit of measurement.

·         1 = Inches

·         2 = Feet

·         3 = Yards

·         4 = Millimeter (mm)

·         5 = Centimeter (cm)

·         6 = Meters

·         7 = Mil

o    Dimension1Type (Column Q), Dimension2Type (Column T) & Dimension3Type (W)

§  This will be the first, second and third-dimension type of measurement. Use the indicated value to specify the type of measurement.

·         1 = Length

·         2 = Width

·         3 = Height

·         4 = Depth

·         5 = Diameter

·         6 = Thickness

 

Columns X, Y, Z, AA, AB & AC – Qty1 thru Qty6

·         Indicate the quantity breaks of the product starting with the minimum order quantity

·         Quantities must go from smallest to largest, left to right

·         Quantities should be listed in PER UNIT terms

·         The number of quantities MUST match the number of prices

 

Columns AD, AE, AF, AG, AH & AI – Prc1 thru Prc6 *

·         Indicate the suggest retail (end-user/catalog) price of the product

·         The number of prices MUST match the number quantities

·         Prices MUST either remain the same through each price break or be LOWER than the previous price break

·         This is a required field IF QuoteUponRequest (Column AQ) is “false”

 

Column AJ – PrCode *

·         Indicate the industry price code for each quantity break

·         You may use different price codes for each pricing break

·         This is a required field IF you have any pricing breaks

 

Columns AK, AL, AM, AN, AO & AP – PiecesPerUnit1 thru PiecesPerUnit6 *

·         Indicate how many pieces there are per unit 

·         This field will automatically default to “1”

 

Column AQ – QuoteUponRequest *

·         Indicate if set pricing for the product is not available

·         False = Not quoted upon request (Default)

·         True = Quoted upon request (in which case columns X-AP should be BLANK)

o    If you have pricing listed in AD-AI and change this field to “True”, the pricing will be removed

·         This is a required field if columns X-AP are blank

 

Column AR – PriceIncludeClr

·         How many imprint colors the price includes (e.g., “1 color”)?

 

Column AS – PriceIncludeSide

·         How many imprint sides the price includes (e.g., “1 side”)?

 

Column AT – PriceIncludeLoc

·         How many imprint locations the price includes (e.g., “1 location”)?

 

Column AU – SetupChg

·         The setup charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column AV – SetupChgCode

·         The industry price code for the setup charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column AW – ScreenChg

·         The screen charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column AX – ScreenChgCode

·         The industry price code for the screen charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column AY – PlateChg

·         The plate charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column AZ – PlateChgCode

·         The industry price code for the plate charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column BA – DieChg

·         The die charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column BB – DieChgCode

·         The industry price code for the die charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column BC – ToolingChg

·         The tooling charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column BD – ToolingChgCode

·         The industry price code for the tooling charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column BE – RepeatChg

·         The repeat setup charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column BF – RepeatChgCode

·         The industry price code for the repeat setup charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column BG – AddClrChg

·         The additional imprint color setup charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Column BH – AddClrChgCode

·         The industry price code for the additional color setup charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Columns BI, BJ, BK, BL, BM & BN – AddClrRunChg1 thru AddClrRunChg6

·         The additional color run charge for the product

·         If a specific charge doesn’t apply to that item, leave the charge field blank

 

Columns BO – AddClrRunChgCode

·         The industry price code for the additional color run charge

·         If a specific charge doesn’t apply to that item, leave the code field blank

 

Column BP – IsRecyclable

·         Mark “true” if product can be recycled

·         Automatically defaults to “false”

 

Column BQ – IsEnvironmental

·         Mark “true” if the product can be considered environmentally friendly

·         Automatically defaults to “false”

 

Column BR – IsNewProd

·         Mark “true” if the product is listed as new in your catalog or website

·         Automatically defaults to “false”

 

Column BS – NotSuitable

·         Mark “true” if the product may not suitable for all audiences

·         Automatically defaults to “false”

 

Column BT – Exclusive

·         Mark “true” if the product is an exclusive item

·         Automatically defaults to “false”

 

Column BU – Hazardous

·         Mark “true” if the product can be considered hazardous or contains hazardous materials

·         This ties into the shipping estimator function

·         Automatically defaults to “false”

 

Column BV – OfficiallyLicensed

·         Mark “true” if your company is registered and has the appropriate license to market your product as “Officially Licensed”

·         Automatically defaults to “false”

 

Column BW – IsFood

·         Mark “true” if the product is a consumable food item

·         Automatically defaults to “false”

 

Column BX – IsClothing

·         Mark “true” if the product is considered an article of clothing

·         Accessories, such as hats or gloves, should not be identified as clothing

·         Automatically defaults to “false”

 

Columns BY, BZ, CA, CB, CC, CD, & CE – Imprint Area

·         Dimensions for the first imprint area on the product

·         You can list up to two imprint areas per product

·         There are two fields for the imprint dimensions of the product

·         If you fill in a dimension value, you MUST also fill in the corresponding dimension unit and type

o    ImprintSize1 (Column BY) & ImprintSize2 (Column CB)

§  This will be the first and second imprint dimension values (e.g. “7”, “3 1/2”, “.5”)

o    ImprintSize1Units (Column BZ) & ImprintSize2Units (Column CC)

§  This will be the first and second dimension unit of measurement. Use the indicated value to specify the unit of measurement.

·         1 = Inches

·         2 = Feet

·         3 = Yards

·         4 = Millimeter

·         5 = Centimeter

·         6 = Meters

·         7 = Mil

o    ImprintSize1Type (Column CA) & ImprintSize2Type (Column CD)

§  This will be the first and second type of measurement. Use the indicated value to specify the type of measurement.

·         1 = Length

·         2 = Width

·         3 = Height

·         4 = Depth

·         5 = Diameter

·         6 = Thickness

o    ImprintLoc (Column CE)

§  Indicate where the location of the imprint will be on the product

 

Columns CF, CG, CH, CI, CJ, CK & CL – Second Imprint Area

·         Dimensions for the second imprint area on the product, if available

·         Follow instructions for First Imprint Area above

·         If you fill in a second imprint dimension value, you MUST also fill in the corresponding second imprint dimension unit, type and location

 

Column CM – DecorationMethod

·         Indicate the types of decoration method offered (e.g. Screen Printed, Embroidery, Laser Engraved)

 

Column CN – NoDecoration

·         Indicate whether decoration is included in the price of the product

·         Automatically defaults to “False”

·         Set to “True” if pricing listed is for a blank product

 

Column CO – NoDecorationOffered

·         Indicate whether decoration is offered on the product

·         Automatically defaults to “False”

·         Set to “True” if you do not offer decoration on your products.  This is if you sell blank goods only.

 

Columns CP, CQ, CR, CS, CT, CU & CV – Product Images

·         If you would like to keep the existing images, leave these fields blank

·         You may add images with a URL or with an image folder

·         You may add (1) primary logoed image and/or (1) primary blank image per product. Additional images may be added through the SAGE Supplier Center or Supplier Direct Connect. 

·         Images must be in .jpg or .png format

·         Product images shouldn’t contain any company information

·         The blank image should be identical to the logoed image with no logo (blank)

 

Column CP – NewPictureURL

·         Add URL to a new sample-decorated image for the product

 

Column CQ – NewPictureFile

·         Set to “True” if a new picture is being included as a stand-along image file with the submission

·         The image should be saved in a folder with ONLY the images for the submission.  The entire folder will be uploaded as part of the submission. 

·         Files are to be labeled with the item number followed by an underscore and an “L”.  For example, “12345_L.png”.  The “L indicates that it has a logo (is a sample-decorated image).

 

Column CR – ErasePicture

·         Set to “True” to erase existing image

 

Column CS – NewBlankPictureURL

·         Add URL to a new blank (not decorated) image for the product

 

Column CT – NewBlankPictureFile

·         Set to “True” if a new picture is being included as a stand-along image file with the submission

·         The image should be saved in a folder with ONLY the images for the submission.  The entire folder will be uploaded as part of the submission. 

·         Files are to be labeled with the item number followed by an underscore and a “B”.  For example, “12345_B.png”.  The “B” indicates that it is a blank image (not decorated with a sample logo).

 

Column CU – EraseBlankPicture

·         Set to “True” to erase existing image

 

Column CV – NotPictured

·         If there is already a picture in the SAGE database, this field will be set to “False” 

·         If you have added a new item and don’t have a picture set to “True”

 

Column CW – MadeInCountry

·         Indicate the country in which the product is manufactured using the two-character country code (e.g., US=United States, CA=Canada, CN=China)

 

Column CX – AssembledInCountry

·         Indicate the country in which the product is assembled using the two-character country code (e.g., US=United States, CA=Canada, CN=China)

 

Column CY – DecoratedInCountry

·         Indicate the country in which the product is decorated using the two-character country code (e.g., US=United States, CA=Canada, CN=China)

 

Columns CZ – ComplianceList

·         Indicate the standards your product complies with using a comma-separated list

·         You can view a full list of compliances by navigating to “Supplier Profile and Catalog” -> “Catalog” -> “5. Edit Products” -> “Add Product” -> “Compliance”

 

Columns DA – WarningLbl

·         Character limit: 500

·         Indicate the appropriate warning label to be displayed for the product

·         Most often used for Prop 65 warning labels

 

Columns DB – ComplianceMemo

·         Character limit: 500

·         Details about testing or labeling policies or if there is additional information regarding listed compliances that should be included, you may add it here

 

Columns DC, DD, DE & DF – Production Time

·         ProdTimeLo (Column DC) and ProdTimeHi (Column DD)

o    Indicate the minimum and maximum possible production time for the product, measured in business days (5 days per week)

·         RushProdTimeLo (Column DE) and RushProdTimeHi (Column DF)

o    If rush service is available, indicate the minimum and maximum possible rush production time for the product, measured in business days (5 days per week)

 

Column DG – Packaging

·         Enter a description of how the products are packaged

·         e.g. Bulk, Individually Polybagged, Gift Boxed, etc.

 

Columns DH, DI, DJ, DK & DL –

·         CartonL (Column DH) – Shipped carton length in inches

·         CartonW (Column DI) – Shipped carton width in inches

·         CartonH (Columns DJ) – Shipped carton height in inches

·         WeightPerCarton (Column DK) – Weight per carton in pounds

·         UnitPerCarton (Column DL) – Number of actual units in each shipping carton

 

Columns DM & DN – Shipping Information

·         ShipPointCountry (Column DM) – Indicates the country from which the product is shipped from, using the two-letter postal code for the country. (e.g., US- United States, CA=Canada, CN=China)

·         ShipPointZip (Column DN) – Enter the ship point zip/postal code the product is shipped from

 

Column DO – Comment

·         Character limit: 150

·         Add additional notes or instructions for the distributor

·         Field will be blank most of the time

 

Column DP – Verified *

·         Set to “True” once you have checked accuracy of all fields

·         Unverified products marked “False” may affect visibility of product

 

Columns DQ, DR, DS & DT – Inventory

·         UpdateInventory (Column DQ) – Set to “True” if you are updating inventory

o    Must be updated weekly

o    Automatically defaults to false

·         InventoryOnHand (Column DR) – Enter the amount (numeric value) of inventory you have on hand

·         InventoryOnHandAdd (Column DS) – Enter the amount (numeric value) of increase in inventory you have on hand

·         InventoryMemo (Column DT) – Break out inventory on hand by color or size

 

More Information:

Note: If you have a traditional printed or PDF catalog, click on "Upload Your PDF catalog" to submit a PDF of your catalog after submitting your FastTrack Update.

Product Options are currently not supported.  After upload and approval, you may edit any Options and associated pricing in using SAGE Supplier Center.

See also:SAGE Product Data Field Layout

Type: Info Publish Date: 12/7/2014 10:45:26 PM
Applies To: Other Last Updated: 2/8/2019 11:39:02 AM
Platform: All Expiration Date: