Here is a downloadable template of an Excel file with the header on row 1 and the data on row 2.
If you use the template just keep the column headers and replace the data with your own!
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:
Most spreadsheets have a header. The header has column names. Data is under the header. Fill in the Header row number and the row where your data starts:
Browse and select the Excel order guide you are going to import:
Now you'll map your Excel columns to reciProfity.
Find the column in your spreadsheet that matched 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)
And finally, 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 spreadsheets from this vendor you can just choose that template