How to update vendor item prices without an EDI integration, invoices, or vendor price guides.
There are three ways to manually update the price of a vendor item in Galley:
1. From an ingredient's detail page
3. By exporting and re-importing vendor data
Updating vendor item prices from an ingredient's page
Go to the Ingredients catalog and select the ingredient that you would like to edit. Then, scroll down to the Vendor Items section. You can change the vendor item price by updating the price within the text box under Cost.
Updating vendor item prices from a vendor item's page
Go to the Vendors catalog and click a specific vendor. From that Vendor's detail page, you can either update costs directly in the Vendor Items table or by opening the detail page of a specific vendor item. This price update will be reflected in your cost across all recipes at locations that use this vendor item.
Exporting and Re-importing Vendor Items
If you have a large number of vendor item prices for a single vendor that you need to update, it may be best to export your vendor items, edit the costs in an external spreadsheet, and re-import the file.
Vendor data can be exported from a Vendor's detail page by selecting the item(s) that you would like to export and clicking the Export button from the toolbar at the bottom of the page.
Open the exported file and adjust the Cost as needed. If you would only like to update the costs of the vendor items and leave the rest of the information as is you can remove all columns other than:
-
ID
-
Name
-
Cost
-
Cost Unit
-
SKU
Note: You don't have to delete the extra columns and could instead ignore them in the next step.
Once your file is ready it's time to import it. Return to the Vendor's detail page, click the Actions dropdown, and select Import Products. From there, upload your file and perform the import.
Note: For a more detailed walkthrough of the vendor item importer check out the article: How do I add new vendor items for one of my vendors?