Import Supplier Files into your Reference file… it’s simple!
Peach Software has two Product Files. Your active file for active products, then the Supplier Files, we call this the Reference file.
Suppliers files have many more items than you would typically use, so instead of storing them with your active products, you can store these in your Reference file. All of the powerful editing tools are now also available in the reference file so you can update these products with the correct Supplier Codes, Group Codes, Subgroup Codes and Markup or Price Level Codes. This way your system price matrices can provide a selling price.
So next time your supplier sends an update, import this into the reference file to Updating or replace the existing products, then run a simple routine to update the prices and details into the Active products file.
Now with a Box of new Tools your Reference file comes to life as a genuine and complete extension of the product file.
When a search result from Oscar refers to a part in your Reference file, til now, the challenge has been to present the customers correct net price based on their Price Level or Customer Matrix.
Because of this many of our clients would overpopulate their product file so they could have the products priced by the system.
No one disputes that the Reference File is a great way of having Suppliers Part files readily available, but pricing has been the challenge since Oscar and Peach Online started working together.
Problem now resolved – With the Combination of being able to import Supplier files with Groups, Subgroups and Prices A through F and Prices from the reference file now using the customer Matrix even before the product hits the main product file, you can now send all those inactive products back to the Reference file. Check out this Video or call for more information
The Tutorial coming Soon
Importing Products into the Reference file
There are two file formats when importing supplier files into the Reference file. These are either Part & Supplier Code (MfgCode) or Part & Branch
If you purchase products directly from your Individual Suppliers, then you will probably want to import using the Part / Supplier Code format. If you purchase from multiple suppliers through a distributor then you may want to use the Parts Code / Brand format as you may find that your Central supplier has duplicate parts from their multiple Suppliers. So in our Reference file, you may end up with a duplicate part which is not the issue, but these duplicates may also have with the same (Central) Supplier code.
Update your product File from the Reference File
The Reference file should be where you save your supplier product Files. It can hold Hundreds of thousands of products from many suppliers. When Suppliers provide Updates with New products or Price changes, you can update and append to your reference file and then Update products in your active product file from the Reference file. Any products stored in the reference file can be accessed directly from any transaction screen, and if you have kept your reference file up to date and sorted with the required Groupings, Sell Prices and other details then you can be sure the information will come into your product file ready to Price up and Sell.