Rather than the traditional manual entry of items into an order, MarketTime also allows the ability to import items via Excel sheet during the Order Entry process by way of the Quick Import feature.
NOTE: It's important to ensure that only XLSX files are used, as CSV files are not supported. Additionally, any invalid symbols will cause the file to be rejected. Ensure that the Item Number field includes only accepted characters that match the Item Number in MarketTime, and the Quantity field only includes whole numbers, no decimals.
The Quick Import button is found on the right side of the Basket screen, and is available after selecting a Manufacturer.
Once you've clicked the Quick Import button, you will be asked to find the file containing your desired items and their quantities on your PC.
This file must have an Item Number and Quantity column.Locate your file and choose Open.
Once you've chosen your file, the import will begin, and you will be notified of the results.
This process can be repeated multiple times within the same basket for multiple Manufacturers if you desire, provided you've chosen the correct Manufacturer in the drop-down prior to uploading an additional file.
If you are finding that Item Numbers that are a long string of digits are preventing you from importing products, we recommend using the Text to Columns feature in Excel on the Item Number column to correct it.