Data upload price books (import prices from a spreadsheet)

Ideas & feature requests
1

Is it possible to have an upload functionality so we can update pricing in a spreadsheet then do an upload into Breww?

Currently my understanding is if you are not increasing all prices by a set percentage you have to edit each product in each price book manually.

1 Like
3

Definitely. We don’t find the pricing models work for some of our customers so the ability to just do whatever we want, in a spreadsheet or via the API would be much better.

1 Like
5

We’re happy to look at this feature, don’t worry, but I just wanted to point out that this does come with a downside - you have to manually calculate and set your prices for every base price book, every time you create a new product. If you have 15 price books (which isn’t that uncommon), this could be very time-consuming. Whereas, with the rules, it’s done automatically and you hopefully only have to enter one or two prices for your base price books.

Regardless, we’re still happy to look at this feature request as it picks up votes. We know it’s important, and despite encouraging you to use rules where possible, we know the rules can’t always cover all situations.

6

Hey Luke, this would be a very handy tool for our brewery. We can’t really use the automated rules the way the are currently (we’d need more options for input criteria & decision logic). Excel is made for this kind of thing and if you could expose price list fields on the product updater tool, that would solve some issues.
I do understand that this would be a lot of extra columns in the csv file for some breweries that have a lot of price lists, so I’m not sure what to do about that. For us, it would be very helpful.
Dave

2 Likes
7

Hey Luke, just as a follow-up to this - I just updated an entire price book manually, keying it in by hand. Not too fun and I’m sure there could be mistakes… just over 200 products. I’ll have to do this for each of our (non-AGLC) price books, which would be minor as a one-time thing, but I’m worried that this will need to be a fairly regular maintenance item. I’m kinda cranky about it right now but I’m sure by tomorrow it won’t seem quite as important… until next time I have to do it :slight_smile: Anyway, just a bump in support of this feature request. Thanks,
Dave

1 Like