Knowledgebase: Tips and Tricks
How to do a supplier barcode import
Posted by Tim Solemate, Last modified by Tim Solemate on 15 November 2017 11:15 AM

Please see attached pdf and excel spreadsheet



Once you have completed all fields except for the status column on your spreadsheet, open up Solemate Back Office and go to the ‘On Request’ menu.  The spreadsheet needs to be in Excel 97-2003 format with the .xls extension.

Select the option ‘Supplier Barcode Import’.

  1. This takes you to a window that confirms the columns you need on your spreadsheet for it to work. Knowing that you have these columns on your prepared spreadsheet, click on the ‘Load Data’ button.

Please note if these columns don’t appear with the same wording as in the above picture the import won’t work.

  1. A browser window will open asking you to locate the spreadsheet that you wish to import. Locate the file and select the open button with your mouse.
  2. Information on the spreadsheet needs to reflect what has been entered in Solemate. All styles, colours and sizes on the spreadsheet need to exist in Solemate prior to importing and where a colour or size on the spreadsheet is connected to a style then it must also be connected in Solemate. If it doesn’t an error message like the one below will appear.
  3. If all completed fields in the spreadsheet are valid, the following message will appear on the screen confirming the number of barcodes that have been imported.

Once you click the OK button in this message it will revert to the screen you saw in step 2.

From this screen you can cancel out or proceed to import more spreadsheets.

(0 vote(s))
Not helpful

Comments (0)