What is a Supplier Price List?
A supplier price list is a document containing essential information about the products offered by your suppliers — including item codes, descriptions, purchase formats, and prices.
In tSpoonLab, you can easily import these lists in .xlsx format to keep your supplier items up to date.
This feature allows you to process, add, and link supplier items quickly and accurately, ensuring all data remains centralized and consistent across your account.
How to Import Supplier Price Lists
In this video, we show you how to import price lists provided by your suppliers into tSpoonLab.
Follow the steps below to upload and process items efficiently.
Step-by-Step Guide to Import Price Lists
1. Review the File Format
Ensure the supplier’s file is in .xlsx format and includes at least two of the following basic columns:
Item code
Item description or name
Purchase format (e.g., case, box, 5L jerrycan)
Price per format (excluding VAT)
If the file does not include a product code or format, you can still proceed and import the available data.
2. Access the Suppliers Section
From the main menu, go to Management > Suppliers.
Select the supplier associated with the price list.
3. Upload the Price List File
Open the Price Lists section within the supplier profile.
Click on the three dots in the top-right corner of the box and select Add.
In the pop-up window:
Set the corresponding date for the price list.
Upload the .xlsx document.
Click Accept to save it.
You can add multiple price lists per supplier, each corresponding to different dates.
4. Import the Items
Locate the uploaded list and click Import next to it.
A new window will open displaying the file content.
Assign each column in your file to the correct tSpoonLab field:
Item Code → Code
Description → Description
Format → Format / Comment
Price (excl. VAT) → Price
Additional columns can be left unassigned.
Click the Analyze button (green) above the table header.
A window will inform you about any new items not currently listed for that supplier.
Click Add to include those new items.
Once processing is complete, a confirmation message will appear indicating the price list was successfully imported.
The new items will appear under Other Supplier Items in the supplier’s profile.
📢 Note:
If you encounter errors or need assistance, contact the tSpoonLab support team through the chat icon located in the bottom-right corner of the screen.