Available in: Agile | Aware| Analyzer | Multi-Outlet
Why it's important
When you upload your order guides, all the items you purchase from each vendor will be imported. This includes all the packaging information required by reciProfity for recipe costing. Additionally, item codes are imported to match items on invoices.
Uploading your order guides eliminates the need to manually enter each item. When you upload the latest order guides, reciProfity will only add new products; existing products will not be duplicated. reciProfity checks each product's item code and skips over any existing ones.
How it works
Give your vendor this downloadable template of an Excel file
For ease of importing, keep the header on row 1, and the data begins on row 2.
If your vendor gives you the pack size in one field such as 10/1lb reciProfity can read and understand that also!
How to use
-
Choose the Import Order Guides from the menu:
-
Select your vendor, or add a new one, from the pull down:
- Select the template. Choose + Import your own custom Excel or CSV File:
-
Fill in the Header row number and the row where your data starts:
Most spreadsheets have a header. The header has column names. The data is under the header.
- Browse and select the Excel order guide file you are going to import:
-
Map your Excel columns to reciProfity.
Find the column in your spreadsheet that matches the reciProfity name.
For example Column 4 Product description form the spreadsheet matches reciProfity Item Name
- Continue until all the matches are made (Description and Group are optional)
-
Save the Template to use again for this vendor
If your vendor sends you Excel order guides with the same column headings each time, you can save the mappings.
The next time you import Excel files from this vendor, you can use this template.
- Click the green Continue button
- Look Over the Imported Data. Do the fields look right?
-
If you think it does, then you can click the Check All box:
-
Final Import and the Option to Undo
Now the import is happening for real. You still get another chance to Undo the Import if you want. Here's how to check that the data imported in correct. Click on any item to see the data pop up:
-
Check the fields. If anything is missing or looks strange, click the red Undo Import button at the bottom of the import screen.
Now you can redo the import and fix those missing or strange fields!
The biggest hurdle to using any software is data entry. Vendors can give you order guides in Excel format. By uploading order guides, you import hundreds of items without having to enter each item individually.