Update Default Cost from Recent Purchase Order

LiquorStoreOwner405LiquorStoreOwner405 Member Posts: 1

It would be extremely helpful and eliminate a ton of manual entry time if there was an option to update the Default Cost of an Item based upon the current Purchase Order. I'm surprised this is not already an option?!

Optimally, it would be great to have a checkbox to the side of each item on a Purchase Order to indicate whether the Default Cost should be updated based upon the current price.

Our costs are continually changing/updating, but to have that option so we don't have to update the PO cost price manually and then have to manually update the Default Cost pricing at the Inventory Item level would be extremely helpful.

Surely I am not the only one

20 comments

  • meltechsmeltechs Member Posts: 1

    We moved across from Lightspeed Onsite a couple of weeks ago. Unfortunately the more we use Retail the more we find it pretty inadequet as an inventory managment system...

    This should be a very basic, essential feature!

  • janzenbrothersjanzenbrothers Member Posts: 6

    We would be interested in seeing this implemented as a checkbox option per PO or beside the "Add Received To Inventory" button, so that it only updates what is being received and not what has already been received or is still on the way. Some of our suppliers bill us in a different currency and we'd like the default cost to remain the same for those. For our Canadian suppliers though, this would save a lot of time, as we go into each product to manually update it. Thanks!

  • junglebobsjunglebobs Member Posts: 1

    I have to echo this sentiment of first comment "It would be extremely helpful and eliminate a ton of manual entry time if there was an option to update the Default Cost of an Item based upon the current Purchase Order. I'm surprised this is not already an option?!"

    Incredible that this doesn't exist. Makes the PO system minimally functional.Any way to expedite adding a feature?

  • Signet_WizardSignet_Wizard Member Posts: 10

    I have also posted about this in the past, in fact i suggested having a way to add basic rules to default costs: in my case it would be that if the new cost default cost, then change it, if the current PO cost is less, then leave it as is (as i most likely got this item on a promotion and will not necessarily have the same deal next order). But a simple check box by each item AND one for the entire PO would also suit.

    I definitely agree that, as is, the PO feature lacks key features to really be a time saver

  • ChanningChanning Member Posts: 4

    Fully agree.

    We often place POs from one of our suppliers that has hundreds of line items in it, and unfortunately the cost of many of those items change regularly depending on what our supplier paid for them and what the US/CAD exchange rate is currently.

    It takes a TON of time to adjust the cost of each item in the PO and it takes EVEN MORE time to then manually adjust the Default Cost of each item in each item's page.

    Having a checkboxes alongside each item in the PO that would let us adjust the Default Cost in each desired item's page without having to open each of those pages would be ideal.

  • KathleenRomKathleenRom Member Posts: 3
    edited January 20

    Hello

    My comment is similar to those up above and I fully agree with them.

    This should be done and done soon with how volatile the markets are and prices keep changing this really should be put in place.

    This would make life so much easier for many companies if the "default Cost" on each inventory item page would automatically update from the most recently entered PO unit cost entry. This would be a significant/helpful change to retail. I am a bit curious since the Retail Price updates from each PO.

    It take a significant amount of time to adjust the cost of each item in each PO. Then you have to go into each inventory item again and change the "Default Cost" manually.

    This would enhance lightspeed retail exceptional for all business!

  • KathleenRomKathleenRom Member Posts: 3

    Benjamin Lister (Lightspeed Retail)

    Jan 19, 2022, 10:56 EST has print screens as examples for the lightspeed team. Thank you

  • thislittlegallerythislittlegallery Member Posts: 16

    Agree with all above.

    Original comment was April 2021. Now it's Feb 2022. Any updates??? And how do we know if and when an update is made?

  • jtoddzillajtoddzilla Member Posts: 3

    Hey gang, this honestly should be a core function.

    The cost of goods fluctuates all the time, more so recently. If we order an item today the price most likely changed from the increase we saw just a few days ago.

    I SHOULD be able to update the cost in the system simply by updating the cost in the PO. Why that does not populate into the master record is beyond me. That's my current cost. Cost of goods is never static and it is ALWAYS captured at the point of Create Purchase Order.

    I SHOULD NOT have to click into the item from the PO and change the price there. It's a needless step, a waste of time, and time = money. I'm losing time (money) having to do something manually that is a basic automation in a database.

    Can you please update us on this?

  • emacgeeemacgee Member Posts: 65 

    This is something that I have requested as well and would be incredibly beneficial. I've found updating costs in LSR to be very very tedious. If a cost is changed on a PO then that cost should be updated in the product for that vendor and it's ID.


    For those looking for a quick workaround, you can use the updated PO to import these changes. Export the PO with the updated costs and correct your columns to include Default Cost, Vendor Cost, Vendor, and Vendor ID. Then import it and it will update these in the main database as well.

  • richwestrichwest Member Posts: 3

    Completely agree with this thread. We need the ability to update the default cost via PO and when using the manual "Add Inventory Function." Relating the cost to a specific vendor is less important than having the most recent cost. We also need the related ability to perform bulk price changes based on that default (most recent cost). Essentially real-time (triggered by a cost change) price changes that can be rounded to the nearest: $xx.99.

    In fact it doesn't have to be the default cost, it could be a field called last or most recent cost that is vendor agnostic and can be used for price changes, reports, export, etc.

    Managing this process for 2,000 products is not tenable and enough of an issue to consider a new platform. That and lack of integration with popular delivery services such as Grubhub and Uber Eats is major problem.

  • alanlloydalanlloyd Member Posts: 75 ✭

    I agree with the idea that it should be an option, but I'm surprised to see that so many people are MANUALLY updating costs! Just export your PO after adjusting all costs . . . Then import it back into your inventory, adjusting costs. Modify your exported excel csv file to have system ID and default cost columns and import the whole thing. Easy and fast!

  • ch_baucomch_baucom Member Posts: 11

    We were just dealing with this last week. I do not have time to do exports and imports to update costs. Can you please add a check box to the PO that will automatically do this for us?

  • alanlloydalanlloyd Member Posts: 75 ✭
    edited May 2

    @ch_baucom _baucom I don't know how much experience you have with Excel or the Import tool in LS, (or how incredibly busy your day might be), but I can tell you that I order over 1000 lines of products each week from at least seven or eight different vendors. It takes me about 15 minutes to update my default costs this way. If you do it once, you'll be an expert. Rather than tediously manually changing costs or just hoping that someone from LS will see your plea and add that feature, I'd give this method some consideration.

    Post edited by alanlloyd on
  • ch_baucomch_baucom Member Posts: 11

    @alanlloyd I am familiar with exporting, however I don't have much experience with importing. Can you give me more details on the steps you take to make this happen? Thanks in advance!

  • alanlloydalanlloyd Member Posts: 75 ✭

    @ch_baucom It is simply stripping out all columns that are not the system ID (which you are using as the key field on which to update your records), and the column on the exported file that is the same as the "Default Cost" field. I believe that it will be called something different on your exported PO spreadsheet. The import tool is actually a good interface and very intuitive. I'm not going to go into minute detail here to tell you how to import . . .as there are videos online of how to do that. I'd suggest you do a trial run with this method on maybe only update the costs on three SKUs first . . . .if you screw something up, you won't do much damage and it can be easily fixed. If you can do it with three lines . . . you can do it with 3000 lines. Good luck!

  • richwestrichwest Member Posts: 3

    Completely agree with this thread. We need the ability to update the default cost via PO and when using the manual "Add Inventory Function." Relating the cost to a specific vendor is less important than having the most recent cost. We also need the related ability to perform bulk price changes based on that default (most recent cost). Essentially real-time (triggered by a cost change) price changes that can be rounded to the nearest: $xx.99.

    In fact it doesn't have to be the default cost, it could be a field called last or most recent cost that is vendor agnostic and can be used for price changes, reports, export, etc.

    Managing this process for 2,000 products is not tenable and enough of an issue to consider a new platform. That and lack of integration with popular delivery services such as Grubhub and Uber Eats is major problem.

  • richwestrichwest Member Posts: 3

    Completely agree with this thread. We need the ability to update the default cost via PO and when using the manual "Add Inventory Function." Relating the cost to a specific vendor is less important than having the most recent cost. We also need the related ability to perform bulk price changes based on that default (most recent cost). Essentially real-time (triggered by a cost change) price changes that can be rounded to the nearest: $xx.99.

    In fact it doesn't have to be the default cost, it could be a field called last or most recent cost that is vendor agnostic and can be used for price changes, reports, export, etc.

    Managing this process for 2,000 products is not tenable and enough of an issue to consider a new platform. That and lack of integration with popular delivery services such as Grubhub and Uber Eats is major problem.

  • EricRileyEricRiley Member Posts: 22

    I absolutely want this feature, and I would like it to be updating per vendor, not as a default. We carry over 17k products from 300 different vendors and any one product could come from half a dozen different sources at marginally different costs. Every purchase order I enter I wind up having to update every single cost. This constant unnecessary editing is starting to really eat up a lot of my time. Any product we get from a vendor should update the cost on the Vendor IDs page from the most recently received PO. End of story.

  • EM_MAMAEM_MAMA Member Posts: 1

    I couldn't agree more this this! PLEASE, fix this feature ASAP. It seems like it would be easy enough to fix considering the cost is able to change automatically between the two pages.

Sign In or Register to comment.