Uploading Parts into Trades Assist

Many of your jobs will likely require using parts and materials to complete them.  In Telstra Trades Assist you can add and manage your parts and materials and allocate them to new quotes and jobs. 

 

Bulk Upload Parts

If you have an existing parts list or if you are managing your parts in another system and want to import them into Trades Assist you can upload these into Trades Assist using the bulk upload facility.

Tip: if your parts are in another system, you will need to export them into a .csv file. Please review your system's manual or help guide to learn how to do this.

Tip: You can also sync your parts across from MYOB or Xero. Click here to learn how to integrate Telstra Trades Assist with MYOB, or here for Xero.

 

  1. Click  from the Side Menu 
  2. Click  from the expanded menu

  3. Your parts list needs to be in a .csv (comma separated value) format (eg. Excel spreadsheet) Choose  to download the Trades Assist template for entering your parts
  4. Open the downloaded CSV file and, if prompted, click on



  5. Click  at the bottom of the template.  
  6. Start adding information into the columns. The more information you enter, the easier it is to order and assign stock in Telstra Trades Assist.

    Column Name

    Description

    New

    Update

    Part No.

    Part number of the product to load. Will be used first to match against existing parts in the Telstra Trades Assist system.

     

     

    Part Name

    Name of the part being loaded. If the part number match fails, the part name will be used to match against existing parts.

    Required

    Required

    Part Type

    Has to be Material or Cost.

    Required

     

    Part Group

    A grouping for the type of part being loaded. This will be used to match against the system part groups. If no match then the part group will be created by the system.

    Required

     

    Cost Price

    The cost price to you of this part.

    Required

     

    Price

    The Sell price to your customers for this part.

    Required

     

     

    Tax Code

    Tax description that applies to this part. The description must match a tax code in your Telstra Trades Assist system.

    Required

     

    Tax-exempt

    Y, N or blank. If this part is tax except then specify Y. 

     

     

    Tax Exempt Code

    The exception code can be blank

     

     

    Preferred Supplier

    Preferred supplier name matching the name recorded in the Telstra Trades Assist partner’s application. Can be blank.

     

     

    Stocked Amount  

    Number to Set current stock level.    

     

     

    Delete

    Set to Y to remove this record from the database. The record will only be removed if it has not been used.

     

    * Note On update any blank column will not be altered        

     

  7. Save the spreadsheet as a CSV (Comma delimited) file (not the standard Excel file) when you are done entering your parts list. You can choose CSV over the standard Excel file format when you ‘save as’.

  8. You may want to save the CSV file to your desktop so you can easily access the file for your bulk upload.

 

Uploading the saved CSV file to Telstra Trades Assist

  1. You can Drag and Drop the file in the section where it mentions 'CSV Drag and Drop' or
  2. Click on the box that says 'Drag and Drop File' and select the saved CSV file from the folders on your desktop.

Tip:  Make sure you have enabled pop-ups in your browser settings, so Telstra Trades Assist can tell you when the upload has been successful (go to your browser settings to do this).

 

Telstra Trades Assist will automatically match the data to the appropriate area. A new screen or tab will open to show you the success or failure of each part line.  You are looking for an OK label at the end of each line (as highlighted in red below) to show the success of your changes.

  • Example: 44332211,Electrical Wire 10m,Material,,18,40,gst,,,,100,,OK 11223344,Extra Large Gasket,Material,,12.5,15.5,gst,,,,100,, Ok end Processing file

 The new parts and/or and updated parts will now be adjusted within Telstra Trades Assist. Any new quotes or jobs will being using the updated information.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.