Once inside you will see a list containing All Products by All Manufacturers. You can use the two drop-down menus provided to filter this list. The first drop-down menu filters manufacturers so you can look up one at a time. This is recommended especially if you are uploading spreadsheets. The second drop-down menu will allow you to switch from a view that includes All Products or Products With No Pricing.
All Manufacturers | All Products
If you choose to you can only enter the Cost of each item. This will help with the Advance Distributor Free Goods Batches portal. If you add MSRP values this will help at the register. Especially if a customer doesn't understand a Least Value Free program, or if a cashier needs to split up a card according to MSRP.
You can choose to enter values or update values manually. Or you can upload a spreadsheet containing the values. We recommend that you load one manufacturer list at a time, but it is possible to load in your entire inventory all at once. To upload a spreadsheet click the red Upload File button.
Price Maintenance Upload
In order to upload an excel file, it will need to be in the proper format. Data needs to be divided up into their own columns; UPC, Item Description, MSRP, Cost. If you do not want to add MSRP leave that column blank. There is a reminder just below the upload in case you forget. Before you upload the file check the boxes for the locations you want the values to apply to. You do have the option of loading values according to location so each location can have different cost and MSRP values assigned to their items.
After you Choose the File and click Upload Astro will show you how the file will load. You then can choose to load the file or cancel the upload.
Frequently Asked Questions
Where do I find these values so I can add them?
You can request product lists from your distributors that include the Cost and the suggested sale price (MSRP) of each item. Cost does fluctuate rather often so it is not an exact science. You can also request product lists from your manufacturers that will include MSRP. If you receive distributor invoices on your POS you should have a Cost and MSRP list right at your fingertips. Your POS should record the average cost you pay for each item as well as the sale price of each item. Most POS systems have an export which will allow you to pull this information out into an excel sheet. Then all you would need to do is make sure it is in the proper format.
What is MSRP?
MSRP stands for Manufacturer's Suggested Retail Price. MSRP may be a little bit different from your sale price of each item so keep that in mind. If you choose to you can load your sale price for each item into the MSRP fields.