How to complete a bulk upload of stock into The Layer

Firstly you will need to access the stock module from your dash board as indicated below

Now you will need to select ‘Stock Movements’ on the left of your screen

Select ‘Create a new session’ then ‘ next step’ as indicated below

You are now able to select if the stock is related to a PO number or not, in our example we have selected ‘No’, you are also able to select which supplier the stock has come from. In our example I have selected ‘Apple’. Once you have completed the information you wish please click on ‘Next step’ at the bottom of the screen as indicated.

If you wish to book your stock in bulk please firstly select the ‘import’ option below, to ensure that you are booking in your stock in the correct format.

You will be presented with the following spread sheet.

In the columns you will need to complete the following:-

Manufacturer

Product name (this will need to be details exactly how this appears in your pricebook)

Serial number

Barcode

Internal SKU (This will also need to match the internal SKU code you have detailed on your pricebook or alternatively you are able to leave this column blank)

Condition you will need to select one of the following 4 options

New/Unopened
Grade A
Grade B
Grade C

Warranty you are also able to input the warranty for the device here

N.B Please ensure your worksheet is saved as a CSV file as any other format will not import successfully

Once you have entered all the information into the spreadsheet you are now ready to import this, if you return to the stock movement session from above please selected ‘Import’ as indicated below

Now please click select files as indicated below

This will allow you to select the file you wish to import from your saved files once you have selected your file please select Import as indicated below.

You will now see your items detailed and also you will see a pop up box at the top right of your screen to advise you the import was successful.

Now you are able to book in the stock, using any of the finalise options,

as I am completing a bulk stock order and in this instance I don’t want to allocate it to any order I have selected ‘Book in Only’

This will finalise your stock import.

Author: Natalie Dryburgh