• WELCOME Grumblers
    Backup is now done at 3PM EDT. You may find the server down for up to two minutes at that time.

Moulding Pricing Software

bruce papier

MGF, Master Grumble Framer
I know I'm sounding very 19th Century here, but is there a program that just does moulding pricing that updates as new price lists come out? We don't use a POS system. We tried Lifesaver, but setting the pricing tables for moulding is really ponderous.

For most of the moulding, we just need something that uses "between w & x multiply by y to get z". regardless of who makes the moulding.

We don't need the program to do more than that. The rest of our price list is an arcane thing that evolved over 35 years and doesn't bend to fit logical tables, so we're not going to change that part.
 
Sponsor Wanted

Rick Granick

SPFG, Supreme Picture Framing God
You might be able to use some kind of spreadsheet program to set up your own system. Before I got FrameReady I used to do that in AppleWorks.
However, you will still have to personally enter all the new prices when they change from each vendor, which is total drudge work.
One of the beauties of POS is that when you download the vendor files they update and calculate automatically. This has made my life so much easier.
I get a smile on my face every time I do an update now, as opposed to cringing when I got a new price list book in the mail.
:cool: Rick
 

Pat Murphey

SPFG, Supreme Picture Framing God
I've had minimal trouble getting price lists from my vendors in a spreadsheet compatible format. I just align columns to my needs and then have auto pricing. I add a letter code column for each vendor that allows me to vary the sort to amend the main data set. Just remember that lookup tables require item numbers to be sorted as text when mixed with item codes that include letters. If you know how to manipulate rows and columns, it's not difficult or tedious.
 
Last edited:

GUMBY GCF

SGF, Supreme Grumble Framer
here is what we used to do create groups. 1,2,3,,4,5,6,7,8,9,0 then assign dollar amounts to each. taht way all we had to do is ether change the dollar amount to the code or change the code on the frame that moved up out of the code range
I hope I explained that okay..
 

snafu

MGF, Master Grumble Framer
I use a excel spread sheet to markup Larson, Roma etc...
I have it setup to mark up based on Larson's recommended markup or I can change it to any markup I want.


It doesn't automatically update but it's fairly easy to do.
just copy and paste Item, description, width, list price and chop price. it automatically generates retail price.

pm me and I'll send you a copy
 

troyveluz

MGF, Master Grumble Framer
Bruce,
The "between w & x multiply by y to get z" can easily be done on an excel spreadsheet or access database but the automatic price update, you will need to get a POS for that.
 

shayla

WOW Framer
You might try Frame Ready. It's more flexible than the POS you tried, and we love it.
 

Jim Miller

SPFG, Supreme Picture Framing God
Count me among those recommending a professional POS system. There are several good ones that come with pre-pricing already installed, but I would highly recommend modifying it to fit your particular business ASAP. Yes, the POS will automatically update your moulding & matboard prices, and that may be all you "need".

However, the rest of the benefits of a professional POS system are also valuable and quite useful. For example, the customer database, the order histories, and the reporting capabilities can benefit a typical framing business.
 

Ylva

SPFG, Supreme Picture Framing God
POS for pricing is nice, but it is much more than that. You can get accurate pricing in other ways, like some people here have already mentioned.

I use it for reports. After price updates, I can generate a list by vendor with discontinued, newly added etc.
I can create lists with components of an order and the profit margins on that. Easy to spot when certain items need to be updated.
I tweaked my pos a lot and continue to do so.

I also like having order history. I have reports I can generate by year, or any period, with my highest spending customers. Easy to see when people came in, what they generally spend and if there is a period where I haven’t seen them in a while, I can, and do, contact them.

I spend less than $400 a year for my subscription and it is worth every penny
 
Sponsor Wanted
Top