Update Inventory Pricing

From High5Wiki
Revision as of 15:50, 27 March 2015 by Marks (talk | contribs) (Created page with "Updating inventory pricing is similar to importing inventory but with less information to import. You basically use the SME UID field plus cost and price for the items. It's us...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Updating inventory pricing is similar to importing inventory but with less information to import. You basically use the SME UID field plus cost and price for the items.

It's useful to understand UID's, see Before Importing - About UID

To import NEW inventory items see Importing Inventory Items

Manually updating pricing with excel

Just updating cost and price for inventory items:

  • pictures coming soon...
  1. Export your inventory list using exporting, see SME Import Export Process
    1. Pick the following fields for export: UID, ItemName or ItemNumber (so you know which part), Cost, Retail1 (standard price)
    2. You may want to export Vendor or Manufacturer name if you plan to update pricing for just one vendor or manufacturer
  2. Open the file in excel
    1. File:InventoryExportPriceUpdate.png
  3. Filter the data for the items you want to update. Do internet search for excel filtering if you need to know how.
  4. Copy the filtered data into a separate excel file
  5. Update the cost and pricing in excel and save
    1. File:PriceUpdate.png
  6. Import this file into SME using the importing process.
    1. File:ImportPriceUpdate.png


Updating pricing from a vendor excel sheet

  1. ..coming soon..