•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula for updating large volume of retail cost prices
Our take
Updating retail cost prices for thousands of products can feel overwhelming, especially when faced with tedious manual changes. Fortunately, by leveraging a simple formula in Excel, you can automate this process and save significant time. Using the order code as a unique identifier, you can easily pull updated cost prices from your separate spreadsheet and populate them in your main product list. Keep reading to discover step-by-step instructions for implementing this formula, ensuring a seamless and efficient update process for your business.
Hi everyone, hoping someone more capable than me can help.
I'm trying to update a load of cost prices for my business - I've exported a list of the products I want to change with the relevant fields as an Excel spreadsheet and I've imported a spreadsheet with updated cost prices onto a separate sheet within the same workbook.
Each product has an order code that matches the product code from the cost price spreadsheet.
Is it possible to use a formula to pull the updated cost price from its sheet and have it populate the relevant field in the product sheet using the order code as an identifier to match the information so I don't have to change them all manually?
There's a few thousand products so any help is greatly appreciated 😅
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Automated invoice updating systemSo, I have recently been tasked with fixing our costing at my restaurant job. Nothing is currently automated, I am manually updating everything. I would like to create an Excel sheet that automatically updates a list of products from various providers with pricing and amount from invoices that we scan in I understand that the process should work in Microsoft power automate to pull data from invoices as I add them to a folder. What I am confused about is how I can get the prices to update without adding more rows of the same product. For example: week 1 I order 20# of chicken for $30. Week 2 I order the same product, however price has increased to $35. I would like this new information to override the old information instead of create a new line with a different cost. The PLU# would stay the same week to week so it seems like it would be doable by just overriding info that has the same PLU# I'm just not sure how I would go about doing that. Thanks for any advice submitted by /u/jelloman070 [link] [comments]
- Price Page Automation/Efficiency Help NeededPart of what I manage in our family's company is overseeing our customer service and order entry team. We have all of our price sheets in excel files, which works well. The only problem is we have over 100 price page files now as we have at least one per customer and it becomes time consuming to update each sheet when we have price increases or decreases due to material costs. In the photo, you can see the previous pricing (2/1/2026) and the current pricing (3/8/2026). We multiply the previous case price times 1.1 if there's a 10% increase and divide that new case price by the case weight to determine price per pound. Very basic formulas. https://preview.redd.it/hnbgi9b4slvg1.jpg?width=1483&format=pjpg&auto=webp&s=cc726a1f37510165f279d404891b656ce0aa3137 What is the best way to get this automated or improve the speed of updating all of our spreadsheet? I know macros or some form of AI might be helpful but I am not familiar with macros and only use AI for basic research and problem solving. Any feedback or help would be greatly appreciated as I am trying to figure out how to keep my employees from having to work late since we are experieincing monthly price changes right now with current world events. Side note, I know we could switch to a different CRM (we have Sage 50) but that has already been shot down even though I know we could easily do price changes through the newer Sage or Netsuite. submitted by /u/CarelessSet6591 [link] [comments]
- XLookup or SUMIF to return updated amounts?Is it possible to use XLookup to return the updated amount using multiple identifiers? Company number, product number and product name is the only combination that will create a unique identifier. I’ll be refreshing this large data set weekly in another worksheet and need a quick way to pull in and track updated amounts to show a variance summary. Or is there a better formula to use to achieve this? l https://preview.redd.it/jb4ve5hsvupg1.png?width=1215&format=png&auto=webp&s=96032a97e3415ec2707ac2c83e5e15d13147b733 submitted by /u/Winter_Hawk_7595 [link] [comments]
- List and net pricing workbook formulaI'm creating a workbook for our list and net pricing for one of our products. I have two sheets so far. Sheet 1 will show the list and net pricing while sheet 2 has our costs for the product. I need help creating a formula that will take our costs from sheet 2, multiply that by the tariffs, plus freight. Then I would need for it to multiple that result by 3 to get our net price. Then I would need to take our net price and divide that by .3 to get our list price. The list price would also need to be rounded up to the nearest $0.25. Can someone help me with that? submitted by /u/woody_splinter [link] [comments]