How do I upload my Advanced Lot template to me event?

What's the issue you're facing?

I have download a lot template for my Advanced Lot and filled it in. I now need to upload it. How do I do this?

Solution

Once you have downloaded the lot template and made the changes required, you then need to save the Excel Workbook and upload back into the Advanced Lot. You can do this by going into the Advanced Lot and clicking the ‘Upload Lot Template’ button. Once uploaded the advanced Lot table with columns, rows and cell data types will appear.

 

Top tip: when the upload has been completed check the cell types and names are what you were expecting to see.

Image 1: Showing where to find the upload lot template button.

*Note that if you have made any changes to the structure of the lots in the template that this will fail to upload and give you an error stating that the template did not match the structure of your lots. If you see this error it is reocmmended to download a fresh template and copy and paste your date making sure not to override any of the cells not highlighted yellow (the editable cells)

• Related Articles

• Simple Lots Template

  What is the issue you're facing? I need a template a template so that I can upload my lots. How can I do this? Solution Within our software you now have the ability to upload your Lots in one fell swoop, which means you can very much use the Lots as ...

• What are Advanced Lots?

  What is an advanced lot? In the MarketDojo Sourcing tool there are two options to building RFQ and eAuction lots. Either a simple lot or an advanced lot. A simple lot is as the name would suggest 'simple'. It allows you build a lot where you only ...

• What is the the Lot Library and how do I use it with Advanced Lots?

  What's the issue you're facing? I would like to know what the lot library is and how I can use this in my event? Solution Within advanced lots there is the ability to save and load lot templates to a library. If you are running events that are likely ...

• What do I do if I cannot add enough rows or columns to my Advanced Lot?

  What is the issue you're facing? Whilst creating my Advanced Lot I am not able to add enough rows or columns. How do I overcome this? Solution Within advanced lot event there is a maximum cell limit of 5000 cells. There is also a limit for the number ...

• How do I manually add line-item rows and cell data to my Advanced Lot?

  What's the issue you're facing? How do I add rows and column to my Advanced Lot manually? Solution Each advanced lot is made up of columns (lot components) and rows (line items). For each column you will determine what type of cell data will be ...