MAS - Rome Solutions LLC - 47QTCA24D0031
PDF 3 MB
- Attached to
- Federal Supply Schedule 47QTCA24D0031 Federal contract IDV
- Contract number
- 47QTCA24D0031
- Issued by
- GSA Federal Acquisition Service
About this file
This document is a Federal Supply Schedule (FSS) price list for Rome Solutions LLC, contract number 47QTCA24D0031 with a period of performance from December 20, 2023 to December 19, 2028.
The price list includes a variety of information technology products and services available under Special Item Numbers (SINs) 33411 (Purchasing of New Electronic Equipment) and 811212 (Maintenance of Equipment, Repair Services and/or Repair/Spare Parts). Key products listed include USB cables, docking stations, KVM switches, and audio/visual equipment from manufacturers such as StarTech and Clear-Com. Pricing, delivery information, and other contract terms are provided. The related Federal Contract IDV indicates a potential value of $475,000.00 under the General Services Administration's Federal Acquisition Service.
Rome Solutions LLC Pricelist and/or Vendor Terms and Conditions for 47QTCA24D0031, a Federal Supply Schedule awarded to Rome Solutions LLC, under Multiple Award Schedule (MAS)
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
Text version
READ ME
| Glossary: | |||||
| PRODUCTS Tab | |||||
| Grouping | Column | Field Description | Data validation rules | 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 | All products must be designated as an "Accessory" (A) or "Base" (B) product. |
•Base products are standalone products listed to GSA Advantage! for sale.
•Accessories are related to a Base product and are listed as related items available for purchase with the Base product, or independent from the Base Product, on Advantage •Product Options and QtyVol discounts can be applied to both A and B product types •If any "A" items are listed, the PRODXACC tab must be filled out •See Accessories Infographic on catalog.gsa.gov/help for more info MUST be "B" or "A" ; no other value allowed.
| If any A's are included, PRODXACC must be filled out. | No | A B C D T | Vendor provides in Product File |
| Manufacturer Information | manufacturer | Manufacturer name is a required field for all products. This should be the commercially recognized manufacturer brand name for the corresponding manufacturer part number. |
•It must be provided in every sheet referencing the same product (e.g. Options) •Must be 40 characters or fewer from the list of allowed ASCII printable charactersto publish to GSA Advantage!
•Can not be edited via a Change action; make sure this name is accurate during Adds and Baselines or it will need to be deleted & re-added.
| Note: GSA may request additional information related to the identification of the manufacturing facility for a given item in order to confirm product attributes and/or compliance with the MAS Solicitation. | Must be 40 characters or fewer from the list of allowed ASCII printable characters | ||
| Yes | A B C D T | Vendor provides in 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 •Must be 40 characters or fewer from the list of allowed ASCII printable charactersto publish to GSA Advantage!
| •Can not be edited via a Change action; make sure this number is accurate during Adds and Baselines or it will need to be deleted & re-added. | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | A B C D T | Vendor provides in Product File |
| Vendor Part Number | vendor_part_number | Vendor part number, for use by the seller to track part numbers. | ||
| •Vendor defined; can be edited via a Change action | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Vendor provides in Product File |
| Special Item Number | sin | SIN under which the product is being offered. | Must be a valid GSA Special Item Number |
| (Post-award, must be an awarded SIN or transaction will fail unless it is an Add-SIN transaction) | Yes | A B C | Vendor provides in Product File |
| Product Information | item_name | Product Name. |
•Must be at least 3 words as defined by space delineated.
•Must be be 40 ASCII characters or fewer to publish to GSA Advantage!
•Can not equal the product part number.
•Recommend: Brand + Model + Product Type + Key Features Must be 3 words Must be 40 characters or fewer from the list of allowed ASCII printable characters
| Must not be part number | Yes | A B C | Vendor provides in Product File |
| Product Information | item_description | A description of the product. |
•Must be at least 10 words as defined by space delineated.
•Must be be 1000 ASCII characters or fewer to publish to GSA Advantage!
| •Should be product focused, and should not include promotional language. •Recommend including descriptive qualities like product type, function, keyfeatures, unique uses, and specifications (e.g., color, size, material). •Consider spelling out uncommon acronyms and abbreviations. | Must be 10 words | ||
| Must be 1000 characters or fewer from the list of allowed ASCII printable characters | Yes | A B C | Vendor provides in Product File |
| Product Information | recycled_content_percent | Recycled and/or post consumer material content percentage. |
•Optional for all except copy paper offerings (required)
| •Express as a decimal between 0 and 1 only (e.g. enter .03 for 3%, enter .50 for 50%) | Percentages must be represented as a decimal | ||||||
| For example, enter .03 for 3% | No | No | Vendor provides in Product File | ||||
| Unit of measure | uom | Unit of measure / issue of the product. | Must be a valid reference code | Yes | A B C | Vendor provides in Product File | |
| Quantity Per Pack | quantity_per_pack | Quantity Per Pack, if the product is packed in quantities. |
•This is the number of items per pack and must be a numeric value.
•Example: If the product is sold in sets of 6, then enter “6”
| Note: If this field is populated then quantity_unit_uom must also be populated. | Must be a positive number | ||
| Must not contain special characters (e.g. "$") | Yes | No | Vendor provides in Product File |
| Quantity Per Pack | quantity_unit_uom | Quantity Unit Of Measurement, if the product is sold in set increments |
•Use this section to identify the unit of measurement.
| •Example: If your product is sold in sets of 6, then enter the UOM as "ST", the Quantity Per Pack as "6", and the Quantity Unit UOM as "EA". It will be displayed on GSA Advantage as "ST 6 EA" | Must be a valid reference code | Yes | No | Vendor provides in Product File |
| Commercial Price | commercial_price | Commercial Price | Must be a positive number |
Must have 2 decimals or fewer
| Must not contain special characters (e.g. "$") | No | A B C | Vendor provides in Product File | ||||
| Commercial Price | mfc_disc_off_commercial_price | mfc_disc_off_commercial_price is the percent discount relationship between the mfc_price and the commercial_price provided. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Commercial Price | govt_disc_off_commercial_price | govt_disc_off_commercial_price is the percent discount relationship between the govt_price_no_fee and the commercial_price provided. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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. | Required if non-TDR, | ||
| Must be characters from the list of allowed ASCII printable characters | No | Conditional (non-TDR) | Vendor provides in 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. | Required if non-TDR |
Must be a positive number Must have 2 decimals or fewer
| Must not contain special characters (e.g. "$") | No | Conditional (non-TDR) | Vendor provides in 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 the 1.25% Contract Access Fee (CAF), if applicable. |
•If the gov price no fee is based on a discount on commercial pricing, vendor can use the following formula where X is the discount percentage represented as a decimal (e.g. ".1" for 10%). Paste into O3: =L3*(1-X) •If the gov price no fee is based on a markup on commercial pricing, vendor can paste the following formula in O3: =((1+AU3)*AS3) •Existing contractors who have gov_price_with_fee available, can reverse calculate gov_price_no_fee by dragging down the formula in O3 or copying and pasting this formula into O3: =IF(E3="339940OS4",P3*0.98,P3*0.9925) Must be a number Must have 2 decimals or fewer
| Must not contain special characters (e.g. "$") | No | A B C | Vendor provides in 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). |
•Proposed prices must be inclusive of all costs associated with acceptance of the Governmentwide commercial purchase card (e.g., payment processing fees).
•Schedule contractors may not impose a surcharge at the order level for payment by Governmentwide commercial purchase card.
•For additional information, see SCP-FSS-001 Instructions Applicable to All Offerors, and GSA SmartPay Smart Bulletin No. 039.
FORMULA:
In column P of the Products Tab, drag down the pre-populated formula in P4, or paste the following formula in cell P3 and drag down to calculate:
=IF(E3="339940OS4",O3/.98,O3/0.9925) Must be a positive number Must have 2 decimals or fewer Must not contain special characters (e.g. "$")
| Must be calculated accurately to pass validations to load to Advantage | Yes | A B C T | Vendor provides in Product File |
| Dealer Markup | dealer_cost | Dealer cost for the product. | |
| •Markup based pricing is only allowed under specific SINs and should be verified. | Only allowed under certain SINs |
Must be a positive number Must have 2 decimals or fewer
| Must not contain special characters (e.g. "$") | No | Conditional (markup based contracts) | Vendor provides in Product File |
| Dealer Markup | mfc_markup_percentage | When compared to the dealer cost, this is the markup given to the Most Favored Customer |
•This should be calculated as a percentage and expressed as a decimal •Only applies if proposed pricing is markup based.
•Markup based pricing is only allowed under specific SINs and should be verified.
Only allowed under certain SINs Must be a decimal
| Must not contain special characters (e.g. "%") | No | Conditional (markup based contracts) | Vendor provides in Product File |
| Dealer Markup | govt_markup_percentage | When compared to the dealer cost, this is the markup given to GSA. This should be calculated against the Gov Price No Fee |
•This should be calculated as a percentage and expressed as a decimal •Only applies if proposed pricing is markup based.
•Markup based pricing is only allowed under specific SINs and should be verified. Only allowed under certain SINs Must be a decimal
| Must not contain special characters (e.g. "%") | No | Conditional (markup based contracts) | Vendor provides in Product File |
| Country of Origin | country_of_origin | Provide the Country of Origin(COO) for each product being proposed. |
•If a product is sourced from multiple COO, list additional country codes, separating each with a comma (,)
| •Please note, only the first COO will be displayed on GSA Advantage. | Must be a valid reference code | Yes | A B C | Vendor provides in Product File |
| Delivery Information | delivery_days | Delivery lead time | ||
| •Provide a numerical value here for the number of days for product delivery. | Must be a positive number | |||
| Must not contain special characters (e.g. "%") | Yes | A B C | Vendor provides in 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 | Must be a valid reference code | Yes | A B C | Vendor provides in Product File |
| Delivery Information | fob_us | Freight on Board to the 48 Contiguous US States and DC (CONUS). At minimum, delivery to CONUS locations is required. |
•D-Destination
| • O-Origin. | Must be a valid reference code | Yes | A B C | Vendor provides in Product File |
| Delivery Information | fob_ak | Freight on Board-Alaska |
•D-Destination •O-Origin
| •N- No Delivery | Must be a valid reference code | Yes | A B C | Vendor provides in Product File |
| Delivery Information | fob_hi | Freight on Board-Hawaii: |
•D-Destination •O-Origin
| •N- No Delivery | Must be a valid reference code | Yes | A B C | Vendor provides in Product File |
| Delivery Information | fob_pr | Freight on Board-Puerto Rico: |
•D-Destination •O-Origin
| •N- No Delivery | Must be a valid reference code | Yes | A B C | Vendor provides in Product File | |||
| National Stock Number | nsn | National Stock Number | Must be valid NSN code. Limited to 13 digits, dashes allowed. | Yes | No | Vendor provides in Product File | |
| UPC | upc | Universal Product Code. | |||||
| •If UPCs are utilized, this code must be 8-14 digits in length | Must be 8-14 digits | Yes | Conditional | Vendor provides in 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) | Must be 8 digits and can not begin with a zero "0" | Yes | No | Vendor provides in Product File | |||
| Temporary Price Reduction (TPR) | sale_price_with_fee | ONLY provide information in this section for a Temporary Price Reduction catalog action |
•Information submitted in this section will be ignored for all other types of catalog actions (e.g. Baseline, Add, Change) •Provide the sale price with the 0.75% Industrial Funding Fee (IFF) and/or 1.25% Contract Access Fee (CAF) Must be a positive number Must have 2 decimals or fewer Must not contain special characters (e.g. "$")
| Must be lower than awarded Gov Price With Fee | Yes | T | Vendor provides in Product File | ||||
| Temporary Price Reduction (TPR) | start_date | If providing temporary price reductions, indicate the start date for the temporary pricing | Value must be in date format 'mm/dd/yyyy' | Yes | T | Vendor provides in Product File | |
| Temporary Price Reduction (TPR) | stop_date | If providing temporary price reductions, indicate the stop date for the temporary pricing. To change the stop date of an existing sale, start by creating a new TPR mod | Value must be in date format 'mm/dd/yyyy'ust be a valid date | Yes | T | Vendor provides in Product File | |
| Photo File References | default_photo | Provide the file name associated with the image for GSA Advantage. This photo will be the main/default photo*. |
•For multiple photos, 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 requires this information: https://vsc.gsa.gov/vsc/app-lookup-tables#sinMolPhotoUpc *When photos from the Verified Products Portal are available, they will display first.
| For BPAs: Photos are inherited from the MAS catalog. Do not include photo file names in BPA submissions. | Photo filename must be between 5 and 80 characters, only contain letters, numbers, dashes ( - ), underscore ( _ ), and a valid extension (.jpg | .jpeg | .gif. | ||||||
| Photo file reference must match the name of the photo file uploaded via ZIP file in order to publish to Advantage | Yes | Conditional | Vendor provides in Product File | ||||
| Photo File References | photo_2 | Provide the file name of the image uploaded (leave blank for BPA catalogs) | Photo filename must be between 5 and 80 characters, only contain letters, numbers, dashes ( - ), underscore ( _ ), and a valid extension (.jpg | .jpeg | .gif. | ||||
| Photo file reference must match the name of the photo file uploaded via ZIP file in order to publish to Advantage | Yes | Conditional | Vendor provides in Product File | ||||
| Photo File References | photo_3 | Provide the file name of the image uploaded (leave blank for BPA catalogs) | Photo filename must be between 5 and 80 characters, only contain letters, numbers, dashes ( - ), underscore ( _ ), and a valid extension (.jpg | .jpeg | .gif. | ||||
| Photo file reference must match the name of the photo file uploaded via ZIP file in order to publish to Advantage | Yes | Conditional | Vendor provides in Product File | ||||
| Photo File References | photo_4 | Provide the file name of the image uploaded (leave blank for BPA catalogs) | Photo filename must be between 5 and 80 characters, only contain letters, numbers, dashes ( - ), underscore ( _ ), and a valid extension (.jpg | .jpeg | .gif. | ||||
| Photo file reference must match the name of the photo file uploaded via ZIP file in order to publish to Advantage | Yes | Conditional | Vendor provides in Product File | ||||
| Photo File References | product_url | Provide the web address where additional product information can be found (leave blank for BPA catalogs). | Must be between 5 and 80 characters within the list of allowed ASCII printable characters | Yes | No | Vendor provides in Product File | |
| Warranty Duration | warranty_period | Duration of Warranty | Must be a positive number |
Must not exceed 999 (use larger unit of time)
| Must not contain special characters | Yes | No | Vendor provides in Product File | ||||
| Warranty Duration | warranty_unit_of_time | Unit of time of the warranty duration | Must be a valid reference code | Yes | No | Vendor provides in Product File | |
| Product Dimensions | length | Physical Length | |||||
| •Must be provided when another Shipping Container Dimension is provided | Must be provided if any other dimension is provided |
Must be a positive number
| Must not contain special characters | Yes | Conditional | Vendor provides in Product File |
| Product Dimensions | width | Physical Width | |
| •Must be provided when another Shipping Container Dimension is provided | Must be provided if any other dimension is provided |
Must be a positive number
| Must not contain special characters | Yes | Conditional | Vendor provides in Product File |
| Product Dimensions | height | Physical Height | |
| •Must be provided when another Shipping Container Dimension is provided | Must be provided if any other dimension is provided |
Must be a positive number
| Must not contain special characters | Yes | Conditional | Vendor provides in Product File | |
| Product Dimensions | physical_uom | Unit of measure for shipping package (feet, inches, cm, etc.) | ||
| •Must be provided when another Shipping Container Dimension is provided | Must be valid reference code | Yes | Conditional | Vendor provides in Product File |
| Product Dimensions | weight_lbs | Weight in pounds of product's shipping weight | ||
| •Must be provided when another Shipping Container Dimension is provided | Must be provided if any other dimension is provided |
Must be a positive number
| Must not contain special characters | No | Conditional | Vendor provides in 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 ",". | Must be valid reference code | Yes | No | Vendor provides in Product File | |||
| Product Information / Categorization | url_508 | URL for 508 information | Must contain characters within list of allowed ASCII printable characters | Yes | No | Vendor provides in Product File | |
| Product Information / Categorization | hazmat | Product hazmat information. | |||||
| • This a United Nations Identification number (UNID). It will start with UN, NA or MSDS. | Must be characters from the list of allowed ASCII printable characters | Yes | No | Vendor provides in Product File | |||
| Summary | flag_summary | flag_summary is a list of the compliance and pricing flags at the line item level. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Summary | hits | hits are the number of offerings found on all contracts at the line item level. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Summary | self_hits | self_hits are the number of offerings found for same vendor at the line item level. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Summary | vendor_comments | vendor_comments are any input the vendor would like to share with their CO/CS. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Compliance Considerations | is_authorized_vendor | is_authorized_vendor provides insight into whether or not the manufacturer or wholesale distributor listed the vendor as an authorized supplier in GSA's Verified Products Portal (VPP) |
- Unauthorized - The contractor is not on the list of authorized vendors supplied by the manufacturer.
- Authorized - The contractor appears on the list of authorized vendors supplied by the manufacturer.
| - Review LoS Requirement - The Verified Product Portal does not have authorization data for the item, review the Letter of Supply requirements to see if the product is required to have an LoS on file (Consult the MAS Solicitation for the most current LoS Requirements.) | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |||
| Compliance Considerations | is_prohibited | is_prohibited provides insight into any regulatory compliance concerns that indicate whether an item can be sold or not. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Compliance Considerations | prohibition_comment | prohibition_comment provides information on why an item is flagged as prohibited. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Compliance Considerations | ets | ets is an item that is deemed Essentially the Same as an Ability One Item. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Country of Origin | inferred_country_origins_source | inferred_country_origins_source shows the source of the inferred_country_origins field. Only the most authoritative source will be used to determine the COO(s) and only the most authoritative source will display. |
| In order of authority, sources are: GSA (GSA Admin record in VPP), VPP-MFR (Manufacturer or their authorized representative record), VPP-Non-MFR (Wholesaler or content provider record), and Vendor Pool (MAS vendors on GSA Advantage). All sources come from the Verified Products Portal except Vendor Pool. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |||
| Country of Origin | inferred_country_origins | inferred_country_origins displays the Country of Origin(s) for the item returned during the market research process. This value is an array and can contain multiple countries. (An inference of "XX" means no consensus is found, but the item is likely foreign-made.) | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Country of Origin | is_mia_risk | is_mia_risk is when the inferred_country_origins indicate the item is most likely not "US", while the provided primary country of origin was "US". | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Country of Origin | is_taa_risk | is_taa_risk is when the inferred_country_origins do not contain a TAA compliant country. | This information is generated as a part of the market research process. |
New Awards: CS/Cos run this report
| Post Award Mods: FAS Catalog Platform generates for vendors | N/A | N/A | Generated by C&P process | ||||
| 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. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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
| - Self Hits Only: Perform Manual Market Research: the only instances of the product found within the government marketplace are the vendor’s own product. Manual market research is required | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |||
| Pricing Market Research | government_min_price | government_min_price is the lowest price found across the government catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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 (+/-). | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_min_price_supplier | government_min_price_supplier is the vendor offering the product at the government_minimum_price. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_median_price | government_median_price is the median price found across government contracts, excluding low outliers. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_median_price_supplier | government_median_price_supplier is the vendor offering the product at the government_median_price. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_average_price | government_average_price is the average price found across the government catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_average_price_standard_deviation | government_average_price_standard_deviation is the pricing standard deviation of the government catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_max_price | government_max_price is the maximum price found across the government catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | commercial_min_price | commercial_min_price is the lowest price found across the commercial catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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 (+/-). | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | commercial_min_price_supplier | commercial_min_price_supplier is the commercial supplier offering the product at the commercial_minimum_price. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | commercial_median_price | commercial_median_price is the median price found across the commercial catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | commercial_median_price_supplier | commercial_median_price_supplier is the commercial supplier offering the product at the commercial_median_price. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_transaction_min_price | government_transaction_min_price is the minimum transaction price found across the GSAAdvantage! and FedMall catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_transaction_average_price | government_transaction_average_price is the average transaction price found across the GSAAdvantage! and FedMall catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_transaction_median_price | government_transaction_median_price is the median transaction price found across the GSAAdvantage! and FedMall catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | government_transaction_max_price | government_transaction_max_price is the maximum transaction price found across the GSAAdvantage! and FedMall catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | tdr_min_price | tdr_min_price is the lowest price found across Transactional Data Reporting (TDR) catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | tdr_median_price | tdr_median_price is the median price across Transactional Data Reporting (TDR) catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | tdr_max_price | tdr_max_price is the maximum price across Transactional Data Reporting (TDR) catalogs. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | sales_likelihood | sales_likelihood: based on GSAAdvantage! transaction price points, how likely is the product to sell at the proposed price. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| 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. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Product Information | unique_item_identifier | unique_item_identifier is XSB's unique identifier at the line item level. | This information is automatically generated as a part of the market research process; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | mas_price_with_fee | If BPA catalog, this field will display the MAS contract price with fee when the BPA and MAS item have the same exact manufacturer name and part number. Field must be blank for MAS Catalogs. | This information is generated automatically for BPA catalogs; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | bpa_to_mas_price_ratio | If BPA catalog, this field will show the BPA to MAS price ratio as a percentage when the BPA and MAS item have the same exact manufacturer name and part number. Calculated as: ((MAS Price With Fee - BPA Price With Fee) / BPA Price With Fee). A negative percentage indicates a BPA price that is higher than the MAS price. Field must be blank for MAS catalog. | This information is generated automatically for BPA catalogs; no user action | N/A | N/A | Generated by C&P process | |
| Pricing Market Research | bpa_to_mas_flag | If BPA catalog, this flag will indicate if the BPA price with fee is higher than the MAS price with fee, or indicate that an item with the exact same manufcaturer name and part number is not found on the MAS contract. Field must be blank for MAS catalog. | This information is generated automatically for BPA catalogs; no user action | N/A | N/A | Generated by C&P process | |
| OPTIONS Tab | |||||||
| Grouping | Column | Description | Data validation rules | Published on Advantage | Required | Source | |
| Manufacturer Information | manufacturer | Manufacturer name is a required field for all products | |||||
| •List the manufacturer for the base/accessory product from the PRODUCTS tab to associate with the options | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Manufacturer Information | manufacturer_part_number | Manufacturer part number is a required field for all products | |||||
| •List the manufacturer part number for the base/accessory product from the PRODUCTS tab to associate with the options | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Options Information | option_manufacturer | Option Manufacturer name is a required field for all option | |||||
| •List the manufacturer of the option | Must be 40 characters or fewer from the list of allowed ASCII printable characters | 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. | Must be 40 characters or fewer from the list of allowed ASCII printable characters | No | No | Product File | |||
| Options Information | category | Category of options. |
•Categories are vendor defined groupings to list Options of the same Category (e.g. "size") in a Dropdown menu on Advantage •Provide the category name that will appear on Advantage. Repeat the same category name for every option in that category •“Options” may be used as a generic category; reminder customers can only select one option per category •Must be 40 characters or fewer from the list of allowed ASCII printable charactersto publish to GSA Advantage!
| •See Options infographic on catalog.gsa.gov/help for more info | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File |
| Options Information | name | Option name |
•Option names are vendor defined titles to list the Options associated with each category (e.g. small, medium, large with repeated category of "size") •Option names are used to populate the dropdown menus on GSA Advantage
| •Must be 80 characters or fewer from the list of allowed ASCII printable charactersto publish to GSA Advantage! | Must be 80 characters or fewer from the list of allowed ASCII printable characters | 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 by default in the purchase on Advantage unless a customer makes a different selection -Description of this option should be included in base description -Option price must be 0. Capture price in base item price -Only (1) included option is allowed per category •S: Substitutes: Can only be used if there is an "I" included for the category. Customers can select to substitute with an "S" on Advantage -Option price can be positive if adds to price; negative if decreases price; 0 if no impact to price -E.g. 100% cotton is included; subsitute leather for cost increase, cotton blend for cost decrease, polyester for no price change •A: Added- Customer can opt to add the option to the base item. An "A" can NoT be included in a category with an "I" -Price must be zero or greater (e.g. add optional assembly; add optional warranty) •See Options infographic on catalog.gsa.gov/help for more info If using an "S", must have an "I" If using "I", only 1 "I" per category allowed
| If using an "A", must NoT have an "I" | Yes | No | Product File | ||||
| Options Information | quantity | Quantity of the option; numerical value | |||||
| •Populates in front of the unit of measure (e.g. "6 EA") | Must be a positive number | Yes | No | Product File | |||
| Options Information | unit_of_measure | Unit of measure / issue of the product's option | Must be a valid reference code | Yes | No | Product File | |
| Options Price | price_with_fee | This is the cost associated with the option. This number will be added to the base/accessory item price for a total item price. |
•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) 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).
Must be a number; limited to 2 decimals.
| Must not contain special characters (e.g. "$") | Yes | No | Product File | ||||
| PRODXACC Tab | |||||||
| Grouping | Column | Description | Data validation rules | Published on Advantage | Required | Source | |
| Product Manufacturer Information | manufacturer | Manufacturer name is a required field for all products | |||||
| •List the manufacturer for the "B" base product from the PRODUCTS tab to associate with the accessory | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Product Manufacturer Information | manufacturer_part_number | Manufacturer part number is a required field for all products | |||||
| • List the manufacturer part number for the "B" base product from the PRODUCTS tab to associate with the accessory | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Accessory Manufacturer Information | accessory_manufacturer | Accessory manufacturer name is a is a required field for all products | |||||
| • List the manufacturer for the "A" accessory product from the PRODUCTS tab to associate with the base | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Accessory Manufacturer Information | accessory_manufacturer_part_number | Accessory part number is a required field for all products | |||||
| • List the accessory part number for the "A" accessory product from the PRODUCTS tab to associate with the base | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| QTY/VOL Tab | |||||||
| Grouping | Column | Description | Data validation rules | Published on Advantage | Required | Source | |
| Manufacturer Information | manufacturer | Manufacturer name is a required field for all products | |||||
| • List the manufacturer for the base/accessory product from the PRODUCTS tab to associate with the qty/vol discount | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Manufacturer Information | manufacturer_part_number | Manufacturer part number is a required field for all products | |||||
| • List the manufacturer part number for the base/accessory product from the PRODUCTS tab to associate with the qty/vol discount | Must be 40 characters or fewer from the list of allowed ASCII printable characters | Yes | No | Product File | |||
| Volume or Quantity | discount _type | Quantity or Volume Discount: |
•Choose "Quantity" when the discount is based on the number of units required to be purchased to receive this discount
| •Choose "Volume" when the discount is based on the price range of the purchase to receive the discount | Must be a valid reference code | 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. (e.g. A product with 3 price buckets will have bucket numbers 1, 2, 3. It cannot be 1,2,4.) | Must be number between 1-7 | |||
| Must be sequential | 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 •For Quantity discounts, bucket_number 1 must begin with a quantity of 1.
See catalog.gsa.gov/help for help with qty/vol discounts Must be a whole number Must follow the end_of_range from the prior price bucket
| For Quantity discounts, bucket_number 1 must begin with a quantity of 1. | 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 | Must be a whole number | ||
| 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).
•For Quantity discounts, the discount_price for bucket_number 1 must be equal to the govt_price_with_fee of the base item on the PRODUCTS tab Discount price must be lower than Gov Price With Fee Must not use both discounted_price and percentage_discount for the same product.
| For Quantity discounts, the discount_price for bucket_number 1 must be equal to the govt_price_with_fee of the base item on the PRODUCTS tab. | Yes | No | Product File |
| Discount Range | percent_discount | Percent Discount provided for bucket | |
| •Express this value in decimal format only (e.g. 5% off for orders greater than $100 would be expressed as ".05") | Must be expressed as a decimal between 0 and 1 | ||
| Must not use both discounted_price and percentage_discount for the same product. | Yes | No | Product File |
&"Calibri"&10&K000000 Sensitivity Label: CGIF Internal&1#_x000D_
Overview (Product File - Version 1.4-20251217)
The Product File collects contract and 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! Remove sample data from every tab in this file before uploading
REQUIRED:
•PRODUCTS: This tab is required for every action containing products published to GSA Advantage! Includes product information such as name, part number, price, unit of measure, UPC, and photo file references. Base items or Accessories included in the PRODUCTS tab are prohibited from being duplicated and published to the text file posted on GSA eLibrary.
AS APPLICABLE:
The below tabs should be used as applicable to your product configurations.
•OPTIONS: Use this tab to represent product options (e.g. size, color, fabric, warranty, assembly, engraving). Product options can be applied to a base item or an accessory. By using the Options tab, an Options menu will be created on GSA Advantage for customers to make selections. Options must be selected at time of purchase, and an option can increase, decrease, or not incur a cost. Options have their own part numbers for sales reporting purposes, but cannot be sold independently of a base item or accessory. For products with a large number of options or option categories, list the most popular configurations on the Product File for publishing to GSA Advantage! and maintain pricing for other options in the Services Plus File for non-orderable products.
Example: Listing 3 different sizes (options) for a shirt (base); listing 5 different colors (options) for a notebook (base).
•PRODXACC: This tab is required if any product on the PRODUCTS tab is coded as “item_type: A” (Accessory). Use this tab to link accessory products to their base product, which will create a drop down menu of "related products" on GSA Advantage for customers. Accessories have their own unique product information, and can be purchased alone or with the base item. An accessory may be related to multiple base items. For accessories that MUST be purchased with the base, indicate in Product Description or consider using Services Plus File for non-orderable products.
Example: Listing 3 different tire brands (accessories) with a tractor (base); listing 5 different types of chairs (accessories) with various desks (base).
•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 facilitates the defining of the "price buckets'' for each product. Each bucket has a manufacturer name and part number, start/end range, and a price.
Example: The first 1-99 units of an order receive the usual gov price with fee; orders of 100-500 units get a reduced base price, orders of over 500 units get an even lower price.
FOR REFERENCE:
Reference: This tab contains allowable codes for certain fields such as Country of Origin or Unit of Measure
PRODUCTS
| Base Product or Accessory | Manufacturer Information | Vendor Part Number | Special Item Number | Product Information | Unit of Measure | Quantity Per Pack | Commercial Price | 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 | Product Dimensions | Product Information / Categorization | Dealer Markup | |
| item_type | |||||||||||||||||||||
| MankwongYau: All products must be designated as an "Accessory" (A) or "Base" (B) product. Product Options and QtyVol discounts can be applied to both A and B product types. If any "A" items are listed, the PRODXACC tab must be filled out | manufacturer |
MankwongYau: Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product (e.g. Options). Must be 40 characters or fewer from the list of allowed ASCII printable characters to publish to GSA Advantage! Can not be edited via a Change action; make sure this name is accurate during Adds and Baselines or it will need to be deleted & re-added.
| manufacturer_part_number | |
| MankwongYau: Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. Must be 40 characters or fewer from the list of allowed ASCII printable charactersto publish to GSA Advantage! Can not be edited via a Change action; make sure this number is accurate during Adds and Baselines or it will need to be deleted & re-added. | vendor_part_number |
| MankwongYau: Vendor part number, for use by the seller to track part numbers. Vendor defined; optional to provide; can be edited via a Change action. | sin |
| MankwongYau: SIN under which the product is being offered. | item_name |
MankwongYau: Product Name. Must be at least 3 words as defined by space delineated. Must be be 40 ASCII characters or fewer to publish to GSA Advantage! Can not equal the product part number.
| item_description | |
| MankwongYau: A description of the product. Must be at least 10 words as defined by space delineated. Must be be 1000 ASCII characters or fewer to publish to GSA Advantage! Should be product focused, and should not include promotional language. | recycled_content_percent |
| MankwongYau: Recycled and/or post consumer material content percentage. Optional for all except copy paper offerings (required). Express as a decimal between 0 and 1 only (e.g. enter .03 for 3%, enter .50 for 50%) | uom |
| MankwongYau: Unit of measure / issue of the product. | quantity_per_pack |
| MankwongYau: Quantity Per Pack, if the product is packed in quantities. This is the number of items per pack and must be a numeric value. Example: If the product is sold in sets of 6, then enter “6”. Note: If this field is populated then quantity_unit_uom must also be populated. | quantity_unit_uom |
| MankwongYau: Quantity Unit Of Measurement, if the product is sold in set increments. Use this section to identify the unit of measurement. Example: If your product is sold in sets of 6, then enter the UOM as "ST", the Quantity Per Pack as "6", and the Quantity Unit UOM as "EA". It will be displayed on GSA Advantage as "ST 6 EA" | commercial_price |
| MankwongYau: Commercial Price | mfc_name |
| MankwongYau: Leave blank if TDR. 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. | mfc_price |
| MankwongYau: Leave blank if TDR. Only applies for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount. | govt_price_no_fee |
MankwongYau: This is the price offered to the government that does not include the 0.75% Industrial Funding Fee (IFF) and the 1.25% Contract Access Fee (CAF), if applicable.
•If the gov price no fee is based on a discount on commercial pricing, vendor can use the following formula where X is the discount percentage represented as a decimal (e.g. ".1" for 10%). Paste into O3: =L3*(1-X) •If the gov_price_with_fee is available, the vendor can reverse calculate gov_price_no_fee by copying and pasting this formula into O3: =IF(E3="339940OS4",P3*0.98,P3*0.9925) govt_price_with_fee MankwongYau: 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).
•Proposed prices must be inclusive of all costs associated with acceptance of the Governmentwide commercial purchase card (e.g., payment processing fees).
•Schedule contractors may not impose a surcharge at the order level for payment by Governmentwide commercial purchase card.
•For additional information, see SCP-FSS-001 Instructions Applicable to All Offerors, and GSA SmartPay Smart Bulletin No. 039.
FORMULA:
In column P of the Products Tab, drag down the pre-populated formula or paste the following formula in cell P3 and drag down to calculate:
| =IF(E3="339940OS4",O3/.98,O3/0.9925) | country_of_origin |
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 .