MAS - Econoline Trailers, Inc. - GS30F042BA

DOC document 160 KB

Attached to: Federal Supply Schedule GS30F042BA Federal contract IDV
Contract number: GS30F042BA
Issued by: GSA Federal Acquisition Service

About this file

Written by GovTribe AI · Dec 27, 2024

This is a product catalog glossary file for GSA Federal Supply Schedule contractors that defines data fields and requirements for submitting product information to GSA Advantage. The file provides detailed specifications for completing four key tabs: PRODUCTS (required for all items), OPTIONS (for product configurations), PRODXACC (for accessories), and QTYVOL (for quantity/volume discounts). The file includes comprehensive field definitions covering manufacturer information, pricing, country of origin, delivery terms, warranties, dimensions, and other product attributes.

The associated Federal Supply Schedule contract GS30F042BA was awarded by the Federal Acquisition Service on September 26, 2014 with an ultimate completion date of September 25, 2029 and a ceiling value of $505,600. Based on the sample product entries, the contract appears to cover trailers and related equipment, including gooseneck, pintle pull, tilt bed, and dovetail trailers ranging from 6-24 tons capacity, with prices ranging from approximately $9,500-$19,600. Delivery terms indicate 60-day lead times and FOB Origin shipping to CONUS locations.

From the source

Econoline Trailers, Inc. Pricelist and/or Vendor Terms and Conditions for GS30F042BA, a Federal Supply Schedule awarded to Econoline Trailers, Inc., under Automotive Superstore (FSS-23-V)

View the file

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

READ ME

Glossary:
PRODUCTS Tab
Grouping	Column	Description	Published on Advantage	Required for Catalog Action Type:

A: Add B: Baseline C: Change D: Delete

T: TPR	Source
	Base Product or Accessory	item_type	Identify if the product is an accessory (A) or base product (B). An accessory is a standalone product that is associated with another standalone base product. Example: An extra set of tires can be purchased along with a tractor. (Purchasing an accessory will always increase the price in cart on Advantage.) If you are providing accessories as part of the product catalog, the item_type must be defined to differentiate the base product (B) and accessory product (A). If your catalog contains a combination of products with and without accessories, enter "B" for all products that are standalone.	No	A B C D T	Product File
	Manufacturer Information	manufacturer	Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product.	Yes	A B C D T	Product File
	Manufacturer Information	manufacturer_part_number	Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product.	Yes	A B C D T	Product File
	Vendor Part Number	vendor_part_number	Vendor part number, for use by the seller to track part numbers.	Yes	No	Product File
	Special Item Number	sin	SIN product is being offered under	Yes	A B C D	Product File
	Product Information	item_name	Product Name	Yes	A B C D	Product File
	Product Information	item_description	A description of the product. The description can be up to 1,000 characters long.	Yes	A B C D	Product File
	Product Information	recycled_content_percent	Recycled and/or post consumer material content percentage. (Optional, but required for copy paper offering) Express this value in decimal format only. (i.e 3%, enter 0.03; 50%, enter 0.5)	No	No	Product File
	Unit of measure	uom	Unit of measure / issue of the product.	Yes	A B C D	Product File
	Quantity Per Pack	quantity_per_pack	Quantity Per Pack, if the product is packed in quantities. (ex. BX 4 EA) Enter numeric value here.	Yes	No	Product File
	Quantity Per Pack	quantity_unit_uom	Quantity Per Pack, if the product is packed in quantities. Enter numeric value here. If your productis sold in set increments, use this section to identfiy how many are included. (ex. If your product is only sold in sets of 6, list the UOM as "ST", quantity_per_pack as "6" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "ST 6 EA".)	Yes	No	Product File
	MSRP	msrp	Manufacturer's Suggested Retail Price/Commercial List Price	No	A B C D	Product File
	MSRP	mfc_disc_off_msrp	mfc_disc_off_msrp is the percent discount relationship between the mfc_price and the msrp provided.	N/A	N/A	Compliance & Pricing Report
	MSRP	govt_disc_off_msrp	govt_disc_off_msrp is the percent discount relationship between the govt_price_no_fee and the msrp provided.	N/A	N/A	Compliance & Pricing Report
	Most Favored Customer	mfc_name	Only applies for non-TDR contracts. Most Favored Customer refers to the customer or category of customer that receives the most favorable pricing. The name of the customer of the category of customers goes in this column.	No	Conditional	Product File
	Most Favored Customer	mfc_price	Only applies for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount.	No	Conditional	Product File
	Price Proposal	govt_price_no_fee	This is the price offered to the government that does not include the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

First-time users submitting a Baseline action can use the following formula to calculated this figure off of the govt_price_with_fee. Inserted the formula in cell O3 in the PRODUCTS tab and dragged down for all products:

=IF(E3="339940OS4",P30.98,P30.9925)	No	A B C D	Product File
	Price Proposal	govt_price_with_fee	This is the price offered to the government that includes the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

Example of Discount Based (IFF only):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.9925 = $90.68

Example of Discount Based (IFF & CAF):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.98 = $91.84

Example of Markup Based:

MSRP = $100.00

Dealer Cost: $80.00 GSA Discount (govt_price_no_fee): 10% Markup Price Offered to GSA (govt_price_no_fee): $80*(1+.10) = $88.00

Markup Price Offered to GSA (govt_price_with_fee): $88.00/0.9925 = $88.66	Yes	A B C D T	Product File
	Dealer Markup	dealer_cost	Only applies if proposed pricing is markup based. This is allowed under specific SINs. Verify this is allowed for your offering. This is the dealer cost for the product.	No	Conditional	Product File
	Dealer Markup	mfc_markup_percentage	Only applies if proposed pricing is markup based. When compared to the dealer cost, this is the markup (in percentage points) given to the Most Favored Customer.	No	Conditional	Product File
	Dealer Markup	govt_markup_percentage	Only applies if proposed pricing is markup based. This is the markup given to GSA from the dealer cost that does not include the 0.75% Industrial Funding Fee (IFF).	No	Conditional	Product File
	Country of Origin	country_of_origin	Provide the Country of Origin(COO) for each product being proposed. If your product are sourced from multiple COO, you list additional country codes, separating each with a comma (,). Please note, only the first COO will be displayed on GSA Advantage.	Yes	A B C D	Product File
	Delivery Information	delivery_days	Delivery lead time-Provide a numeric value here for the number of days for product delivery.	Yes	A B C	Product File
	Delivery Information	lead_time_code	Delivery lead time codes-

AE: From date of PO receipt to shipment AF: From date of PO receipt to delivery AX: From Date of Award to Date of Completion (services only)

AY: From Date of Award to Date of Delivery	Yes	A B C	Product File
	Delivery Information	fob_us	Freight on Board to the 48 Contiguous US States and DC (CONUS): D-Destination or O-Origin. At minimum, delivery to CONUS locations is required.	Yes	A B C	Product File
	Delivery Information	fob_ak	Freight on Board-Alaska: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	Delivery Information	fob_hi	Freight on Board-Hawaii: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	Delivery Information	fob_pr	Freight on Board-Puerto Rico: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	National Stock Number	nsn	National Stock Number	Yes	No	Product File
	UPC	upc	Universal Product Code. This code must be 8-14 digits in length.	Yes	Conditional	Product File
	UNSPSC	unspsc	United Nations Standard Products and Services Code. This code must be 8 digits in length and cannot begin with a zero (0).	Yes	No	Product File
	Temporary Price Reduction (TPR)	sale_price_with_fee	ONLY provide information in this section if you are performing a Temporary Price Reduction catalog action. Information submitted in this section will be ignored for all other types of catalog actions (i.e. Add, Change, etc) Provide the sale price with the 0.75% Industrial Funding Fee (IFF) and/or 1.25% Contract Access Fee (CAF).	Yes	T	Product File
	Temporary Price Reduction (TPR)	start_date	If providing temporary price reductions, indicate the start date for the temporary pricing	Yes	T	Product File
	Temporary Price Reduction (TPR)	stop_date	If providing temporary price reductions, indicate the stop date for the temporary pricing	Yes	T	Product File
	Photo File References	default_photo	Provide the file name of the image uploaded. This photo will be the default photo on GSA Advantage. If you have more than 1 photo, identify those file names under photo_2, photo_3, and photo_4. Up to 4 photos are allowed per product. Supported photo formats: .jpeg \| .jpg \| .gif and the file name can only contain 1 dot (.).
Required for certain SINs. Visit the following website to determine if the SIN on your contract requires this information: https://vsc.gsa.gov/vsc/app-lookup-tables#sinMolPhotoUpc	Yes	Conditional	Product File
	Photo File References	photo_2	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	photo_3	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	photo_4	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	product_url	Provide the web address where additional product information can be found.	Yes	No	Product File
	Warranty Duration	warranty_period	Duration of Warranty.	Yes	No	Product File
	Warranty Duration	warranty_unit_of_time	Unit of time of the warranty duration	Yes	No	Product File
	Shipping Container Dimensions	length	Physical Length (Required for FOB Origin)	Yes	Conditional	Product File
	Shipping Container Dimensions	width	Physical Width (Required for FOB Origin)	Yes	Conditional	Product File
	Shipping Container Dimensions	height	Physical Height (Required for FOB Origin)	Yes	Conditional	Product File
	Shipping Container Dimensions	physical_uom	Unit of measure for shipping package (feet, inches, cm, etc.) (Required for FOB Origin)	Yes	Conditional	Product File
	Shipping Container Dimensions	weight_lbs	Weight in pounds of product's shipping weight (Required for FOB Origin)	Yes	Conditional	Product File
	Product Information / Categorization	product_info_code	Product Information Code: List the code(s) that is applicable to this product. If multiple codes apply to this product, separate each code with a comma ",".	Yes	No	Product File
	Product Information / Categorization	url_508	URL for 508 information	Yes	No	Product File
	Product Information / Categorization	hazmat	Product hazmat information. This a United Nations Identification number (UNID). It will start with UN, NA or MSDS.	Yes	No	Product File
	Summary	flag_summary	flag_summary is a list of the compliance and pricing flags at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	hits	hits are the number of offerings found on all contracts at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	self_hits	self_hits are the number of offerings found for same vendor at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	vendor_comments	vendor_comments are any input the vendor would like to share with their CO/CS.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	is_authorized_vendor	is_authorized_vendor provides insight into whether or not the the manufacturer or wholesale distributor listed the vendor as an authorized supplier.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	is_prohibited	is_prohibited provides insight into any regulatory compliance concerns that indicate whether an item can be sold or not.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	prohibition_comment	prohibition_comment provides information on why an item is flagged as prohibited.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	ets	ets is an item that is deemed Essentially the Same as an Ability One Item.	N/A	N/A	Compliance & Pricing Report
	Country of Origin	inferred_country_origin	inferred_country_origin is the Country of Origin listed by the majority of vendors. (A Country of Origin Inference of "XX" means no consensus is found, but the item is likely foreign-made.)	N/A	N/A	Compliance & Pricing Report
	Country of Origin	is_mia_risk	is_mia_risk is when the inferred_country_origin is not "US", while the provided country of origin was "US".	N/A	N/A	Compliance & Pricing Report
	Country of Origin	is_taa_risk	is_taa_risk is when the inferred_country_origin is from a non-TAA compliant country	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	market_threshold	market_threshold is the ceiling range established by the horizontal pricing model. This figure is meant to be a guide, price fairness is determined by the CO/CS.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	market_threshold_status	market_threshold_status is the line item level status, these statuses include the following:

- Within Market Threshold: the price falls below the market threshold price

- Exceeds Market Threshold: the price exceeds the market threshold price

- No Market Research Found: XSB was unable to find the product at the time of the previous refresh, or there were not at least 3 sources of supply to generate statistically valid results

- Found Only Commercial Research: XSB was unable to find any government market research, however; XSB did find commercial market research	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_min_price	government_min_price is the lowest price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	proposed_price_relative_to_government_min	proposed_price_relative_to_government_min is the govt_price_with_fee as a percentage of government_minimum_price (+/-).	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_min_price_supplier	government_min_price_supplier is the vendor offering the product at the government_minimum_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_median_price	government_median_price is the median price found across government contracts, excluding low outliers.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_median_price_supplier	government_median_price_supplier is the vendor offering the product at the government_median_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_average_price	government_average_price is the average price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_average_price_standard_deviation	government_average_price_standard_deviation is the pricing standard deviation of the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_max_price	government_max_price is the maximum price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_min_price	commercial_min_price is the lowest price found across the commercial catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	proposed_price_relative_to_commercial_min	proposed_price_relative_to_commercial_min is the govt_price_with_fee as a percentage of commercial_minimum_price (+/-).	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_min_price_supplier	commercial_min_price_supplier is the commercial supplier offering the product at the commercial_minimum_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_median_price	commercial_median_price is the median price found across the commercial catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_median_price_supplier	commercial_median_price_supplier is the commercial supplier offering the product at the commercial_median_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_min_price	government_transaction_min_price is the minimum transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_average_price	government_transaction_average_price is the average transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_median_price	government_transaction_median_price is the median transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_max_price	government_transaction_max_price is the maximum transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_min_price	tdr_min_price is the lowest price found across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_median_price	tdr_median_price is the median price across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_max_price	tdr_max_price is the maximum price across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	sales_likelihood	sales_likelihood: based on GSAAdvantage! transaction price points, how likely is the product to sell at the proposed price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	annual_demand_quantity	annual_demand_quantity is the sum of order quantities from the following sources on a rolling year frequency. The sources include GSAAdvantage transactions, FedMall transactions, DLA NSN procurement history, and TDR data.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	demand_weighted_index_score	demand_weighted_index_score incorporates the total GSAAdvantage! sales for the given product. The sum of this index represents how much a buyer would spend to purchase the proposed products, relative to purchasing each product the Market Baseline Supplier, for a $100 order.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	is_low_outlier	is_low_outlier are any products where the govt_price_with_fee is at least 50% less than the goverment_median_price.	N/A	N/A	Compliance & Pricing Report
	Product Information	unique_item_identifier	unique_item_identifier is XSB's unique identifier at the line item level.	N/A	N/A	Compliance & Pricing Report
	OPTIONS Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Manufacturer Information	manufacturer	Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	Yes	No	Product File
	Manufacturer Information	manufacturer_part_number	Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the products sheet.	Yes	No	Product File
	Options Information	option_manufacturer	Option Manufacturer name is a required field for all options..	Yes	No	Product File
	Options Information	option_part_number	Options part number is a required field for all options. The option part number is provided to vendors on the Purchase Order.	No	No	Product File
	Options Information	category	Category of options. Options of the same kind should have the same Category Name. Options with the same Category Name will be in the same drop down list on Advantage, with the ability to select 1 option from that category. You will create your own category names that appear on Advantage. Enter “Options” as a generic name.	Yes	No	Product File
	Options Information	name	Option name	Yes	No	Product File
	Options Information	base_item_relationship	Base Item Relationship. Identify how the selection of this option will impact the order.

I: Included - Option is included; No cost is associated with this option. (Price must be 0.) Only one (1) included 'I' option is allowed per category.

A: Added - Option can be added for an additional cost. (Price must be zero or greater.)

S: Substituted - If another option is already included (I) for the category, this option can substitute it. The price of a substituted option can be negative, zero, or positive. Enter a negative price where the substituted option is less than the included option, and a positive price if the substituted option costs more than the included option. A price of zero (0) indicates that the substituted item has the same cost as the included item. A price of zero coupled with an option name of 'None' can be used to allow a buyer to refuse the included item.	Yes	No	Product File
	Options Information	quantity	Quatity of the option (i.e. 6 EA)	Yes	No	Product File
	Options Information	unit_of_measure	Unit of measure / issue of the product's option.	Yes	No	Product File
	Options Price	price_with_fee	This is the cost associated with this option. Must be zero (0) if the option is included (I). Must be zero or greater if the option is added (A). Can be negative, zero, or positive if the option is a substitute (S).	Yes	No	Product File
	PRODXACC Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Product Manufacturer Information	manufacturer	Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.	Yes	No	Product File
	Product Manufacturer Information	manufacturer_part_number	Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.	Yes	No	Product File
	Accessory Manufacturer Information	accessory_manufacturer	Accessory manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.	Yes	No	Product File
	Accessory Manufacturer Information	accessory_manufacturer_part_number	Accessory Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.	Yes	No	Product File
	QTYVOL Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Manufacturer Information	manufacturer	Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	Yes	No	Product File
	Manufacturer Information	manufacturer_part_number	Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	Yes	No	Product File
	Volume or Quantity	discount _type	Quantity or Volume Pricing: Choose "Volume" or "Quantity"	Yes	No	Product File
	Price Buckets	bucket_number	Price Buckets must be numbered for quantity or volume price breaks. Up to 7 buckets can be proposed and must be sequential for each bucket. (i.e. A product with 3 price buckets will have bucket_number 1, 2, 3. It cannot be 1,2,4.)	Yes	No	Product File
	Discount Range	start_of_range	Start of Range for Bucket. Must be a whole number. This must follow the end_of_range from the prior price bucket.	Yes	No	Product File
	Discount Range	end_of_range	End of Range for Bucket. Must be a whole number. The end of range of the last discount bucket must be 99999999.	Yes	No	Product File
	Discount Range	discounted_price	Discounted price provided for Bucket. This is the tier-discounted price offered to the government that includes the Industrial Funding Fee (IFF) and, if applicable, Contract Access Fee (CAF). You can propose a Discounted Price or Percentage Discount, but not both for the same product.	Yes	No	Product File
	Discount Range	percent_discount	Percent Discount provided for bucket. Express this value in decimal format only. (i.e 3%, enter 0.03; 50%, enter 0.5) You can propose a Discounted Price or Percentage Discount, but not both for the same product.	Yes	No	Product File
	Zone	zone	Zone for Quantity / Volume Pricing, Values: 01-10. Up to 10 zones can be proposed.	Yes	No	Product File
	ZONEPRICES Tab
	Grouping	Column	Description	Published on Advantage	Required
	Manufacturer Information	manufacturer	Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	Yes	No
	Manufacturer Information	manufacturer_part_number	Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	Yes	No
	Zone Number	zone	Specify Zone for pricing, You may propose up to 10 zones. Values: 01-10	Yes	No
	Offered Price	govt_price_no_fee	This is the zonal price offered to GSA that does not include the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).	No	No
	Offered Price	govt_price_with_fee	This is the zonal price offered to GSA that include the 0.75% Industrial Funding Fee (IFF) and, if applicable,1.25% Contract Access Fee (CAF).

Example of Discount (IFF only):

Commercial Price List = $100.00 GSA Discount (exclusive of IFF): 10% Discount Price Offered to GSA (excluding IFF): $100*(1-.10) = $90.00 Discount Price Offered to GSA (including IFF): $90.00/0.9925 = $90.68

Example of Discount (IFF & CAF):

Commercial Price List = $100.00 GSA Discount (exclusive of IFF): 10% Discount Price Offered to GSA (excluding IFF): $100*(1-.10) = $90.00

Discount Price Offered to GSA (including IFF): $90.00/0.98 = $91.84	Yes	No
	Temporary Price Reductions (w/ Fees)	sale_price_with_fee	If you are providing temporary price reductions, provide a sale price for each zone without the Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).	Yes	No
	Temporary Price Reductions (w/ Fees)	start_date	If providing temporary price reductions, indicate the start date for the temporary pricing	Yes	No
	Temporary Price Reductions (w/ Fees)	stop_date	If providing temporary price reductions, indicate the stop date for the temporary pricing	Yes	No

Overview (Product File - Version 1.2)

The Product File collects catalog information for products intended for sale on GSA Advantage! See the glossary below for full details on the information collected and which fields will be published on GSA Advantage!

This file contains sample catalog data on every tab. Remove this data before uploading the file.

REQUIRED:

•PRODUCTS: This tab is required for all products intended for sale on GSA Advantage. Includes product information such as name, part number, price, unit of measure, UPC, and images.

AS APPLICABLE: The below tabs should be used as applicable to your product configurations.

•OPTIONS: An option is not a standalone product, and can only be purchased with a base product. An option can reduce, increase, or have no impact on cost. Example: A tractor can be purchased with the options of cloth or leather upholstery, and they have different prices associated with them.

•PRODXACC: This tab is required if any product on the PRODUCTS tab is coded as “item type: Accessory”. An accessory is a standalone product, and can be purchased alone or with a base product. Purchasing an accessory will always increase the cost. Example: An extra set of tires can be purchased along with a tractor.

•QTYVOL: A quantity discount is based on the number of units being ordered, and a volume discount is based on the total price of the product being ordered. This tab allows you to define the "price buckets'' for each product. Each bucket has a manufacturer name and part number, start/end range, and a price.

FOR REFERENCE:

Reference: This tab contains allowable codes for certain fields such as Country of Origin or Unit of Measure Help Text: Column titles have additional help text anywhere there is a red triangle. Hover your pointer over the cell to see this additional information.

PRODUCTS

Base Product or Accessory

Manufacturer Information

Vendor Part Number

Special Item Number

Product Information

Unit of Measure

Quantity Per Pack

MSRP

Most Favored Customer

Price Proposal

Country of Origin

Delivery Information

National Stock Number

UPC

United Nations Standard Products and Services Code

Temporary Price Reduction (TPR)

Photo File References

Warranty Duration

Shipping Container Dimensions

MankwongYau: Required if FOB OR-Origin applies to the item

Product Information / Categorization

Dealer Markup

item_type

MankwongYau: (REQUIRED) Identify the product as an accessory (A) or base product (B). An accessory is a standalone product that can be purchased alone or with the base product. Accessories will be associated with their base product on GSA Advantage! If any product is coded as an accessory, the PRODXACC tab is required. Example: an extra set of tires (accessory) can be purchased with a tractor (base).If your catalog contains a combination of products with and without accessories, enter "B" for all products that are standalone.

manufacturer

MankwongYau: (REQUIRED) Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product.

	manufacturer_part_number
MankwongYau: (REQUIRED) Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product.	vendor_part_number
MankwongYau: Vendor part number, for use by the seller to track part numbers. (Optional)	sin
MankwongYau: (REQUIRED)	item_name

MankwongYau: (REQUIRED)

	item_description
MankwongYau: (REQUIRED) A description of the product. The description can be up to 1,000 characters long.	recycled_content_percent
MankwongYau: Recycled and/or post consumer material content percentage. (Optional, but required for copy paper offering) Express this value in decimal format only. (i.e 3%, enter 0.03; 50%, enter 0.5)	uom
MankwongYau: (REQUIRED)	quantity_per_pack
MankwongYau: Quantity Per Pack, if the product is packed in quantities. Enter numeric value here. If your productis sold in set increments, use this section to identfiy how many are included. (ex. If your product is only sold in box of 4, list the UOM as "BX", quantity_per_pack as "4" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "BX 4 EA"). The quantity_unit_uom must also be provided when an entry is made here.	quantity_unit_uom
MankwongYau: Quantity Per UOM is the unit of measure of the product that is packed in quantities. If your product is sold in box increments, use this section to identify how many are included. (ex. If your product is only sold in box of 4, list the UOM as "BX", quantity_per_pack as "4" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "BX 4 EA".) The quantity_per_pack must also be provided when an entry is made here.	msrp
MankwongYau: (REQUIRED) Manufacturer's Suggested Retail Price/Commercial List Price. This information is not published on GSA Advantage.	mfc_name
MankwongYau: Must be provided for non-TDR contracts. Most Favored Customer refers to the customer or category of customer that receives the most favorable pricing. The name of the customer of the category of customers goes in this column.	mfc_price
MankwongYau: Must be provided for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount.	govt_price_no_fee

MankwongYau: (REQUIRED) This is the price offered to the government that does not include the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

=IF(E3="339940OS4",P3*0.98,P3*0.9925) govt_price_with_fee MankwongYau: (REQUIRED) This is the price offered to the government that includes the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

Example of Discount Based (IFF only):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.9925 = $90.68

Example of Discount Based (IFF & CAF):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.98 = $91.84

Example of Markup Based:

Dealer Cost: $80.00 Government Markup Percentage (govt_markup_percentage): 10% Markup Price Offered to GSA (govt_price_no_fee): $80*(1+.10) = $88.00

Markup Price Offered to GSA (govt_price_with_fee): $88.00/0.9925 = $88.66	country_of_origin
MankwongYau: (REQUIRED) Provide the Country of Origin(COO) for each product being proposed. If your product are sourced from multiple COO, you list additional country codes, separating each with a comma (,). Please note, only the first COO will be displayed on GSA Advantage.	delivery_days

MankwongYau: (REQUIRED) Delivery lead time-Provide a numerical value here for the number of days for product delivery.

lead_time_code MankwongYau: (REQUIRED) Lead Time Codes- AE: From date of PO receipt to shipment AF: From date of PO receipt to delivery AX: From Date of Award to Date of Completion (services only)

AY: From Date of Award to Date of Delivery	fob_us
MankwongYau: (REQUIRED) Freight on Board-48 Contiguous US States and DC (CONUS): D-Destination or O-Origin. At minimum, delivery to CONUS locations is required.	fob_ak
MankwongYau: (REQUIRED) Freight on Board-Alaska: D-Destination, O-Origin, or N-No Delivery.	fob_hi
MankwongYau: (REQUIRED) Freight on Board-Hawaii D-Destination, O-Origin, or N-No Delivery.	fob_pr
MankwongYau: (REQUIRED) Freight on Board-Puerto Rico: D-Destination, O-Origin, or N-No Delivery.	nsn	upc
MankwongYau: Universal Product Code. This code must be 8-14 digits in length.	unspsc
MankwongYau: UNSPSC must be 8 digits in length and cannot begin with a zero (0).	sale_price_with_fee
MankwongYau: ONLY provide information in this section if you are performing a Temporary Price Reduction (TPR) catalog action. Information submitted in this section will be ignored for all other types of catalog actions (i.e. Add, Change, etc) Provide the sale price with the 0.75% Industrial Funding Fee (IFF) and/or 1.25% Contract Access Fee (CAF). This price must be less than the govt_price_with_fee. If you want to end an active TPR, only provide the item_type, manufacturer, and manfacturer_part_number, and leave the sale_price_with_fee, start_date and stop_date empty.	start_date
MankwongYau: If providing temporary price reductions, indicate the start date for the temporary pricing.	stop_date
MankwongYau: If providing temporary price reductions, indicate the stop date for the temporary pricing. This must be a date in the future and must be later than the start_date.	default_photo

MankwongYau: Provide the file name of the image uploaded. This photo will be the default photo on GSA Advantage. If you have more than 1 photo, identify those file names under photo_2, photo_3, and photo_4. Up to 4 photos are allowed per product. Supported photo formats: .jpeg | .jpg | .gif and file names can only contain 1 dot (.).

Required for certain SINs. Visit the following website to determine if the SIN on your contract requires this information: https://vsc.gsa.gov/vsc/app-lookup-tables#sinMolPhotoUpc photo_2 photo_3 photo_4 product_url MankwongYau: Provide the web address where additional product information can be found.

warranty_period MankwongYau: Duration of Warranty. Must be included when warranty_unit_of_time is provided. Provide a numeric value in this column.

MankwongYau: Required if FOB OR-Origin applies to the item warranty_unit_of_time MankwongYau: Warranty unit of time:

DA: Calendar Days DW: Work Days MO: Months

WK: Weeks	length
MankwongYau: Physical Length (Required for FOB Origin) Must be provided when another Shipping Container Dimension is provided.	width
MankwongYau: Physical Width (Required for FOB Origin) Must be provided when another Shipping Container Dimension is provided.	height
MankwongYau: Physical Height (Required for FOB Origin) Must be provided when another Shipping Container Dimension is provided.	physical_uom
MankwongYau: Unit of measure for shipping package (feet, inches, cm, etc.) (Required for FOB Origin) Must be provided when another Shipping Container Dimension is provided.	weight_lbs
MankwongYau: Weight in pounds of product (Required for FOB Origin) Must be provided when another Shipping Container Dimension is provided.	product_info_code
MankwongYau: Product Information Code: List the code(s) that is applicable to this product. If multiple codes apply to this product, separate each code with a comma ",".	url_508
MankwongYau: URL for 508 information, as applicable	hazmat
MankwongYau: Product hazmat information. This a United Nations Identification number (UNID). It will start with UN, NA or MSDS.	dealer_cost
MankwongYau: Only applies if proposed pricing is markup based. This is allowed under specific SINs. Verify this is allowed for your offering. This is the dealer cost for the product.	mfc_markup_percentage
MankwongYau: Only applies if proposed pricing is markup based. When compared to the dealer cost, this is the markup (in percentage points) given to the Most Favored Customer. Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 150%, enter 1.5)	govt_markup_percentage

MankwongYau: Only applies if proposed pricing is markup based. This is the markup given to GSA from the dealer cost that does not include the 0.75% Industrial Funding Fee (IFF). Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 150%, enter 1.5)

B	Econoline Trailers, Inc	BG0725TE	336212	BG0725TE	7 Ton 25' Gooseneck Tilt Electric Brake	EA	14558.00	Dealer	10065.72	11133.87	11218.01	US	60	AF	O	O	O	O	BG0725TE.jpg	1	YR	33	102	83	FT	5300
B	Econoline Trailers, Inc	BP0721DE	336212	BP0721DE	7 Ton 21' Pintle Pull Dovetail Electric Brake	EA	12587.00	Dealer	8685.03	9566.46	9638.75	US	60	AF	O	O	O	O	BP0721DE.jpg	1	YR	26	102	42	FT	5400
B	Econoline Trailers, Inc	BP0721TE	336212	BP0721TE	7 Ton 21' Pintle Pull Tilt Electric Brake	EA	13814.00	Dealer	9531.66	10231.42	10308.74	US	60	AF	O	O	O	O	BP0721TE.jpg	1	YR	26	102	42	FT	5050
B	Econoline Trailers, Inc	DP1023DE	336212	DP1023DE	10 Ton 23' Pintle Pull Dovetail Dual Tandem	EA	14560.00	Dealer	10046.40	10991.38	11074.44	US	60	AF	O	O	O	O	DP1023DE.jpg	1	YR	28	102	44	FT	6200
B	Econoline Trailers, Inc	DP1025TE	336212	DP1025TE	10 Ton 25' Pintle Pull Tiltbed Electric Brake	EA	19884.00	Dealer	13719.96	13556.24	13658.68	US	60	AF	O	O	O	O	DP1025TE.jpg	1	YR	30	102	44	FT	6950
B	Econoline Trailers, Inc	DP2025DA	336212	DP2025DA	20 Ton 25' Pintle Pull Dovetail Dual Tandem Air Brake	EA	25754.00	Dealer	17770.26	18408.56	18547.67	US	60	AF	O	O	O	O	DP2025DA.jpg	1	YR	30	102	44	FT	9000
B	Econoline Trailers, Inc	DP2425DA	336212	DP2425DA	24 Ton 25' Pintle Pull Dovetail Dual Tandem Air Brake	EA	28548.00	Dealer	19698.12	19472.50	19619.65	US	60	AF	O	O	O	O	DP2425DA.jpg	1	YR	30	102	44	FT	9800
B	Econoline Trailers, Inc	MG1025TE	336212	MG1025TE	10 Ton 25' Tiltbed Multimax Gooseneck	EA	18904.00	Dealer	13043.76	14031.21	14137.24	US	60	AF	O	O	O	O	MG1025TE.jpg	1	YR	33	102	83	FT	7500
B	Econoline Trailers, Inc	MP0617TE	336212	MP0617TE	6 Ton Mini Max 17' Pintle Pull Tilt Trailer	EA	12884.00	Dealer	8889.96	9471.47	9543.04	US	60	AF	O	O	O	O	MP0617TE.jpg	1	YR	22	102	35	FT	4350
B	Econoline Trailers, Inc	MP1023DE	336212	MP1023DE	10 Ton Multi Max 23' Pintle Pull Electric Brake	EA	13480.00	Dealer	9301.20	9841.95	9916.32	US	60	AF	O	O	O	O	MP1025DE.jpg	1	YR	28	102	44	FT	6200
B	Econoline Trailers, Inc	MP1025TE	336212	MP1025TE	10 Ton 25' Pintle Pull Tiltbed Electric Brake	EA	18756.00	Dealer	12941.64	13176.26	13275.83	US	60	AF	O	O	O	O	MP1025TE.jpg	1	YR	30	102	44	FT	6950
B	Econoline Trailers, Inc	SP1423DE	336212	SP1423DE	14 Ton 23' Pintle Pull Dovetail Electric Brake	EA	19863.00	Dealer	13705.47	12556.89	12651.78	US	60	AF	O	O	O	O	SP1423DE.jpg	1	YR	28	102	45	FT	8600
B	Econoline Trailers, Inc	SP1425DE	336212	SP1425DE	14 Ton 25' Pintle Pull Dovetail Electric Brake	EA	20065.00	Dealer	13844.85	12876.08	12973.38	US	60	AF	O	O	O	O	SP1425DE.jpg	1	YR	30	102	45	FT	8600

OPTIONS

	Manufacturer Information	Options Information	Options Price
	manufacturer
MankwongYau: Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	manufacturer_part_number
MankwongYau: Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	option_manufacturer
MankwongYau: Option Manufacturer name is a required field for all options. It must be provided and reference a product in the PRODUCTS tab.	option_part_number
MankwongYau: Options part number is a required field for all options. The option part number is provided to vendors on the Purchase Order.	category
MankwongYau: Category of options. Options of the same kind should have the same Category Name. Options with the same Category Name will be in the same drop down list on Advantage, with the ability to select 1 product from that category. You will create your own category names that appear on Advantage. Enter “Options” as a generic name.	name
MankwongYau: Option name	base_item_relationship

MankwongYau: Base Item Relationship. Identify how the selection of this option will impact the order.

I: Included - Option is included; No cost is associated with this option. (Price must be 0.) Only one (1) included 'I' option is allowed per category.

A: Added - Option can be added for an additional cost. (Price must be zero or greater.)

S: Substituted - If another option is already included (I) for the category, this option can substitute it. The price of a substituted option can be negative, zero, or positive. Enter a negative price where the substituted option is less than the included option, and a positive price if the substituted option costs more than the included option. A price of zero (0) indicates that the substituted item has the same cost as the included item. A price of zero coupled with an option name of 'None' can be used to allow a buyer to refuse the included item.	quantity
MankwongYau: Quantity of the option (i.e. 6 EA)	unit_of_measure
MankwongYau: Unit of measure / issue of the product's option.	price_with_fee

MankwongYau: This is the cost associated with this option. Must be zero (0) if the option is included (I). Must be zero or greater if the option is added (A). Can be negative, zero, or positive if the option is a substitute (S).

PRODXACC

	Product Manufacturer Information	Accessory Manufacturer Information
	manufacturer
MankwongYau: Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.	manufacturer_part_number
MankwongYau: Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.	accessory_manufacturer
MankwongYau: Accessory manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.	accessory_manufacturer_part_number

MankwongYau: Accessory Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.

QTYVOL

	Manufacturer Information	Volume or Quantity	Price Bucket: Provide buckets from 1 up to 7	Discount Range
	manufacturer
MankwongYau: Product Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	manufacturer_part_number
MankwongYau: Product Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.	discount_type
MankwongYau: Quantity or Volume Pricing: Choose "Volume" or "Quantity"	bucket_number
MankwongYau: Price Buckets must be numbered for quantity or volume price breaks. Up to 7 buckets can be proposed and must be sequential for each bucket. (i.e. A product with 3 price buckets will have bucket_number 1, 2, 3. It cannot be 1,2,4.)	start_of_range
MankwongYau: Start of Range for Bucket. Must be a whole number. This must follow the end_of_range from the prior price bucket.	end_of_range
MankwongYau: End of Range for Bucket. Must be a whole number. The end of range of the last discount bucket must be 99999999.	discounted_price
MankwongYau: Discounted price provided for Bucket. This is the tier-discounted price offered to the government that includes the Industrial Funding Fee (IFF) and, if applicable, Contract Access Fee (CAF). You can propose a Discounted Price or Percentage Discount, but not both for the same product.	percent_discount

MankwongYau: Percent Discount provided for bucket. Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 50%, enter 0.5) You can propose a Discounted Price or Percentage Discount, but not both for the same product.

REFERENCE

Special Item Number (SIN)

Unit of Measure (UOM)

Country of Origin - ISO-2 Codes

Delivery Information - Lead Time Code

Freight On Board (FOB)

Warranty Period

Product or Accessory - Item Type

Quantity/Volume Discounts

Options Code - Base Item Relationship

Product Information / Categorization

Physical UOM

Code

Description

Code

Description

Code

Territory Name

Code

Description

Code

Location Qualifier Description

Code

Description

Code

Description

Values

Code

Description

Code

Description

Code

Description

334290OS

Overseas (International) Audio/Visual Products

Each

(Waiver Required) Andorra

From date of PO receipt to shipment

Destination

Calendar Days

ACCESSORY

Quantity

Option is not included, but can be added for an additional cost.

FEMP Energy Efficiency item

Centimeter

334310

Professional Audio/Video Products

Package

(Waiver Required) United Arab Emirates (the)

From date of PO receipt to delivery

Origin

Work Days

BASE

Volume

No cost is associated with this option. One of multiple options that can be chosen. (i.e. shirt sizes S, M, L) This can also be used for informational purposes.

Low VOC

Decimeter

334511T

Telecommunications Equipment

Carton

Afghanistan

From Date of Award to Date of Completion (services only)

No Delivery

Lifetime

If another option is already included (I), this option can substitute it

Ability One item

Foot

541990AV

Professional Audio/Video Services

Box

Antigua and Barbuda

From Date of Award to Date of Delivery

Months

UNICOR item

Inch

518210DC

Document Conversion Services

Case

Anguilla

Weeks

Comprehensive Procurement Guidelines (CPG) compliant

Meter

541611LIT

Litigation Support Solutions

Pair

(Waiver Required) Albania

EPA Significant New Alternatives Program approved

Yard

561439

Document Production On-site and Off-site Services

Pounds Gross

Armenia

Ergonomic item

561990

Document Destruction Services

Cassette

Angola

Section 508 item

561499M

Mail Management, Systems, Processing Equipment and Related Solutions

Roll

(Waiver Required) Antarctica

Pre-purchased stock

811212R

Repair of Government-Owned Equipment (for equipment NOT under Maintenance Service Agreement)

Set

(Waiver Required) Argentina

Shipboard Use Approved item

811212SA

Maintenance Service Agreement For Office Equipment

Dozen

American Samoa

Hazmat item

511130

Books and Pamphlets

Kilogram

Austria

BioPreferred item

5191M

Entertainment, News and Library Media

Kit

Australia

This product requires custom text when ordered

511120

Periodicals, Subscriptions, Online Book Selling and Lending Library Services

Bundle

Aruba

EPA Recommended

561410

Editorial, Publishing, and Library Media Services

Bag

(Waiver Required) Azerbaijan

FIPS 201 approved item

541611O

Office Management Needs Assessment and Analysis Services

Piece

(Waiver Required) Bosnia and Herzegovina

Safer Choice

541614OR

Office Relocation and Reconfiguration

Foot

Barbados

561110

Office Administrative Services

Pack (PAK)

Bangladesh

561320SBSA

Temporary Staffing (SBSA)

Round

Belgium

561499N

Network Connectivity Support Services

Ream

Burkina Faso

333318

Dictating and Transcribing Machines and Systems

Actual Pounds

Bulgaria

333318SBSA

Office Security Equipment and IT Products (Small Business Set Aside)

Statute Mile

Bahrain

339940

Office Products

Seconds

Burundi

339940OS4

OS4 Office Products and Supplies

Small Spray

Benin

339940OVER

OS4 Overseas Office Products and Supplies

Lifts

(Waiver Required) Saint Barthélemy

339940SVC

Office Supply Support Services

Digits

(Waiver Required) Bermuda

325992

Micro-photographic Film, Paper, Chemical Preparation and Equipment

Strand

(Waiver Required) Brunei Darussalam

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jun 6, 2019.