-
Open your Excel file and click "Enable Editing" if that message displays.
-
Do not edit these columns. These are important columns for the import/upload process to work. If these columns are edited, your import may fail. These columns are the far right of the file.
-
These columns are to identify your product. "Item" is the GFI Item Number.
-
Catch Weight N is priced by the case. Catch Weight Y is priced by the pound
- If you deliver to any GFI divisions, please enter the cost by division. If you do not (and cannot) deliver to a particular GFI division, please leave that blank. The Current cost columns will not import into Mantis. You must enter your costs in the "New" column.
- If GFI picks up orders from your facility, please enter FOB pricing. If you are able to deliver, we encourage you to enter divisional delivered pricing as well.
-
GFI requires you to provide the reasons for your cost change. Please see Cost Change Reasons for descriptions and examples. In the image below, columns AF, AH, AJ, AL, AN, AO, and AR should be numbers only - no symbols, spaces or letters.
-
If an item on your Excel file and is not receiving a cost change, please delete the row for that item.
- If you notice an item is missing from your excel file, you can still add it to your cost change request! Add the GFI Item Number to the Item column, then complete the New cost fields and Cost Change Reasons as you would for any other item. Be sure to copy your Vendor ID and Interface Header Key so that this added line matches your exported lines.
-
Frequently save your changes. Close the file when complete.
Excel Tips:
-
Delete rows any items that will not have a cost change.
-
Select and Hide columns that you do not need to edit.
-
You can use the Freeze Panes feature to be able to keep item identifying information visible when you scroll to complete columns.