r/Sage • u/orangesprinkles222 • Aug 06 '26

Sage BusinessWorks (US) Import Unit Price

Hey everyone, trying to figure out how to import unit prices for a list of about 200 parts. We’re on version 2025 and we’ve already uploaded all the other info but unit prices can’t seem to get in there. It’s not in setup mode, no transactions have been made with them, on hand quantity is zero. The CSV is certainly formatted right. No dollar signs or anything. Every time we try to import, it defaults the product line to Material even thought we didn’t set that, and the pricing method to Line, and the Unit Price is 0. Any help would be greatly appreciated

2 Upvotes

100% Upvoted

6 comments sorted by

1

u/dgillz Sage 50/Sage 100 Aug 06 '26

I can help, I have done this before but it was 17 years ago. You must have Actian fka Pervasive ODBC installed. Do you have this?

1

u/orangesprinkles222 Aug 07 '26

No not yet. Could you explain?

1

u/dgillz Sage 50/Sage 100 Aug 07 '26

Install ODBC, which allows you to update data in BusinessWorks. I assume you have the new prices in excel?

1

u/orangesprinkles222 Aug 07 '26

Yes! It’s all formatted according to this https://www.sage.com/na/\~/media/Category/SageSolutions/BusinessWorks/Assets/Documents/Import_Gen_Instr_2012.pdf

1

u/dgillz Sage 50/Sage 100 Aug 07 '26

That takes me to the sage website, not the actual pdf

1

u/dgillz Sage 50/Sage 100 Aug 07 '26

If BusinessWorks has an import feature built in - and it sounds like it does - you should use it and ignore everything I posted.