Manufacturer Pricing Maintenance Tool

Manufacturer Pricing Maintenance Tool

Manufacturer Pricing Maintenance will allow you to enter the Cost and MSRP for all items included in your Frequent Buyer programs and Offers. This feature pairs beautifully with the Advanced Distributor Free Goods Batches portal because it will allow you to edit the cost of items before they appear in batch reports. You will also be able to upload spreadsheets of values all at once which is a huge time saver. The MSRP and Cost values will appear on your exportable reports: Frequent Buyer and Offer Redemptions, Frequent Buyer and Offer Transactions and Frequent Buyer and Offer Redemptions with Transactions. The MSRP values will also be included in the item descriptions of items added to a frequent buyer or offer card. 

The Manufacturer Pricing Maintenance Tool is an Addon that you will need to request from the Help Desk in order to add it to your account. Once we turn it on for you it will appear under your Actions menu as MFG Pricing Maintenance. Only Admin Users can access this tool.

Located under the Actions menu

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. 

    • Related Articles

    • Pricing | Marketing Suite

      Membership Subscription for the Astro Loyalty Marketing Suite Creating a successful marketing platform shouldn't cost a paw and a leg. With the Astro Loyalty Marketing Suite get ready so get so much more for so much less.  Marketing Suite Membership ...
    • How to Draft and Send a Mass Email | Included Basic Mass Email Tool

      How to Draft and Send a Basic Mass Email This article goes over how to use our Basic Mass Email System. This is one of the marketing tools that is included with a Standard Astro Loyalty Frequent Buyer Membership Subscription. This is not the same ...
    • Advanced Distributor Free Goods Credit Status Report | Addon Feature

      Advanced Distributor Free Goods Credit Batches If you have not yet learned how the Standard Distributor Free Goods Credit Status Report functions independently I recommend starting there first so you have a foundational understanding of how the ...
    • Astro Offers | Reports | Distributor Rebate Credit Batches & Distributor Free Goods Credit Status

      Redemption Reports for Astro Offers There are two main types of Astro Offers - Free Good Offers & Rebate Offers. Free Good Offers - These Offers reward the customer with a free item. They must purchase either a certain item or a certain number of ...
    • POS Report Accounts on Astro

      POS Report Astro Accounts | Account Setup  The setup for all POS Report accounts on Astro is the same regardless of what POS System Tracking Software you are using.  Step One - Enroll in Frequent Buyer Programs The first thing you need to do is ...