Skip to main content
Question

External Price List?

  • November 14, 2025
  • 3 replies
  • 46 views

Forum|alt.badge.img+5

Is anyone able to do away with their external price lists?  I have a price list in Excel.  So far, it has 1200 items or so...been building it since starting the company 20 months ago.

3 replies

KPeter
Rookie Member
Forum|alt.badge.img+1
  • Rookie Member
  • November 26, 2025

Hi ​@coltrane5000,

 

Not yet, Skimmer needs to add a few more fields to their product section for us to abandon our offline price list. Here is a idea of all the ‘pieces’ we collate to make a price in our offline system. This will be nice once we can store all this in Skimmer, but until then it is very easy to upload the updated products to Skimmer.

SPID    ProductName    Description    Category    DefaultPrice    Taxable    Income Account    GOAL GPM    LABOR RATE IN HOURS    ACTUAL GPM    ACTUAL GP $$    MFG PART NUMBER 1    Cost 1    MISC MATERIALS INCLUDED IN QUOTE    MFG PART NUMBER 2    Cost 2    MFG PART NUMBER 3    Cost 3    MFG PART NUMBER 4    Cost 4    MFG PART NUMBER 5    Cost 5    NOTES    COUNT OF BASE UNITS IN UOM    Parts    Tax    Labor    COGS    PRICE NEW FORMULA (COGS/1-GPM)    PRICE NEW FORMULA ROUNDED


Forum|alt.badge.img+5
  • Author
  • Contributor
  • December 5, 2025

Good point.  We are similar:

 

Category Part vs Labor Name Retail Price Labor Charge Cust Part Price LABOR Time Our Labor Cost
if repair tech $75/hr
Our Part Cost Trip Fee MFG # Description Resource Repair vs. Weekly Tax? Default Price List Price
(excludes cust discount)
Company SCP Poolcorp Heritage PWP AMZ / Other Leslie
(RETAIL)

Forum|alt.badge.img+5
  • Author
  • Contributor
  • December 5, 2025

Old order.   Here is our new column order:

 

Name Retail Price Labor Price Part Price LABOR Time Labor COST Part COST Trip Fee MFG # SCP Poolcorp Heritage PWP AMZ / Other Leslie
(RETAIL)
Description Resource Repair vs. Weekly Tax? Bundle ID Category Part vs Labor