{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/d37576926ece4f12a2af35629f26ffa4\" frameborder=\"0\" width=\"1670\" height=\"1252\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1252,"width":1670,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1252,"thumbnail_width":1670,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/d37576926ece4f12a2af35629f26ffa4-6fba6dd2dbcf2682.gif","duration":1329.901,"title":"Importing Price Sheets Into RPS","description":"This Loom explains how to import a formatted price sheet into RPS to set desired pricing. Before importing, it covers cleaning the spreadsheet by removing blank rows and formulas by pasting values, and ensuring each row has a model number. In RPS, you start from the product data menu, select the correct product category such as appliances, choose the manufacturer (for example Bosch), create a price sheet entry, upload the file, and map each spreadsheet column to the required RPS fields including the effective start date. After uploading and mapping, click Import, then use View Results to check imported cost and MSRP via model and price levels, and verify using Price Tags and Pricing with the same date range."}