How To Import a Supplier Price List

Learn more about importing a supplier Price List on Tradify from a .CSV file, and what you'll need to get started. Price List Items are a list of commonly used materials or services that can easily be added to Jobs, Quotes, Invoices, Bills and Purchase Orders at the click of a button.

Note: There are six ways to create Price List Items in Tradify. For the purpose of this guide, we're going to focus on supplier price list importation method, but to view our guides on the other methods, simply use the links below.

• Creating Price List Items (Materials)
• Import Price List Items via Xero
• Import Price List Items via QuickBooks
• Import Price List Items via MYOB AccountRight
• Import Price List Items via MYOB Essentials

• Price List File Template

A Note For Australian Users
Rexel, Ideal, John R Turk and Lear & Smith in Australia make it even easier to import price lists with them formatted for instant import into Tradify.

Simply complete this online form to start receiving your Rexel files tuned for Tradify or mention it to your local rep next time you're in a Rexel, Ideal, John R Turk or Lear & Smith branch.

How to import 

To import a supplier price list:

1. Head to the Settings tab in the left-hand navigation bar.
2. Select Price List.
3. Select the Options drop-down menu. 
4. Select Import Price List File. 
   
   
5. Select or add your Supplier.
6. Select OK. 
7. Choose your .CSV file from your computer and choose whether the CSV has a header row or not.
   
   
8. Select Start Matching.
   
   
9. Tradify will automatically assign the fields it detects but you can manually change them around. 
   
   
10. When you're ready, select Import Price List File.

If you’re creating a new supplier, the only mandatory field is the Supplier Name. The rest of the fields can be left blank or as default. These can be updated at a later stage if required.

If the Price List File you are importing is one you have created specific to your business, then the Supplier Name could be any fictitious name, e.g. Your Company Name.

Tradify will start uploading your Price List file. Depending on the file size, it may take several minutes to import, so please be patient for files containing more than 30,000 items. Once the file has been imported, Tradify will show a 'saved' banner in the top right-hand corner for a short duration and the loading symbol will disappear.  Once the file has been imported, you’ll be able to use the supplier price file in Tradify.

Importing a . CSV file into Tradify

Tradify requires a CSV format file (Comma Separated Values). It can also be .txt, however, it must still be compiled in a comma-separated value format when it was generated by your supplier.

Not all columns need to be populated either. Only the Item Code, Description and Buy Price are mandatory. If you’re unsure at all, please use the table below as a reference.

Tips, Tricks & Troubleshooting

If you experience any problems importing a supplier Price List File, please check the following.

Note: to open the file, you’ll need to use an application which is compatible with CSV files (i.e - Excel, Google Sheets, Open Office).

1. There is no limit to the number of items you can import. That being said, we recommend keeping your item list to a manageable level. If your item list exceeds 100,000, you may slower than average response times when searching for items.
2. Ensure that every line item has an Item Code, Description, and a Buy Price. These three fields are mandatory and without them, the system won’t be able to import the file.
3. If you want Tradify to auto-calculate the retail price (based on the pricing level mark-up), please ensure that you leave the pricing level columns off the import altogether (standard is the default pricing level).
4. Account codes only require the account number, not the name. Example - 200  Sales should be input as 200.
5. If you're integrated with QuickBooks, please leave account codes off the import.
6. Check to make sure there are no missing or blank rows (common issue on larger files).
7. Certain characters can cause issues if they’re used in specific ways. For this reason, we recommend removing the following characters/symbols:
1. $   (dollar symbol)
2. “   (quotation symbol)
3. -   (En dash symbol)
4. –   (Em dash symbol)
5. ,   (Coma symbol)

1. If you’re using column headers, please ensure that there are no duplicates. i.e. you can't have two columns with the same header.
2. File size must be no larger than 20mb
3. Check to ensure that Item Codes are not duplicated. A quick way to check this in Excel is to select the Item Code Column rows (excluding the header) and click on the Home tab > Conditional Formatting > Highlight Cell Rule > Duplicate Values, as shown below.
   

Simply remove the duplicate items or change the Item Code on the duplicate row to make it unique.

If you have performed all these checks and are still encountering an error when importing a Supplier's Price List File, then please contact support by sending details of the error and the file you are trying to import to support@tradifyhq.com. 

Additional Information

for more info on Importing see here: How to Import Historical Jobs Into Tradify