Export stock list

Export stock list


How can I export my entire stock?

1. Click on 'Assortiment' in the menu
2. Under filter 'Locations' select the option 'With stock'
3. Click the button with the 3 dots at the top right.
4. Click on the 'Export products' option
5. A new screen appears. Select additional, desired product details under 'Standard Details' and 'Product Details'.
6. Click on the 'Export' button.


How do I export all my products?

1. Click on 'Assortiment' in the menu
2. Click the button with the 3 dots at the top right.
3. Click on the 'Export products' option
4. A new screen appears.Turn off the 'Use selected filters' switch to export all products.
5. Select additional product details under 'Standard Details' and 'Product Details'.
6. Click on the 'Export' button.


How do I export all products from a supplier?

1. Click on 'Suppliers' in the menu
2. Click the 'View' button behind a supplier
3. Click on the 'Stand List' button on the right



4. Point the cursor the 'three dots' button on the right.
5. Choose the option you would like to download.By default, 'Download CSV file' is for an Excel file and Download PDF file for an overview in PDF.

Info
By clicking on the filter icon behind the supplier name, an additional filter or other supplier can be selected immediately.




How do I export items from a certain category?

1. Click on 'Assortiment' in the menu
2. Under filters, select the desired categories.
3. Click the button with the 3 dots at the top right.
4. Click on the 'Export products' option
5. A new screen appears. Select additional product details under 'Standard Details' and 'Product Details'.
6. Click on the 'Export' button.


Export stock of a particular brand or item group

Please note that the trademark is not obliged to complete, therefore our advice to make an export per item group or supplier.
This can be done both when exporting via the supplier page with the filter icon (see above) and with the export via the range (see below).
For example, go through the following steps:

1. Click on 'Suppliers' in the menu
2. Click the 'View' button behind a supplier
3. Click on the 'Stand List' button on the right



4. Click on the filter icon behind the company name



5. Select the brands or article groups.

Info
It is not mandatory to add a brand to a product, so it may be missing. An article group is mandatory, so for a full list it is best to select it.

6. Click the 'Submit' button. The list will be adjusted.
7. Point the cursor the 'three dots' button on the right.
7. Choose the option you would like to download. By default, 'Download CSV file' is for an Excel file and Download PDF file for an overview in PDF.


Via Assortment page (only as Excel file)

1. Click on 'Assortiment' in the menu
2. Select the filters you want to use
3. Point the cursor on the right with the cursor on the right.
4. Click on the 'Export products' option



5. A new screen appears. If necessary, select the switch 'Share products only' and click on the 'Export' button at the bottom



    • Related Articles

    • Export historical stock list

      Do you want to download a stock list from a date in the past? This can only be done as Excel file. 1. Click on 'Assortiment' in the menu 2. Click the button with the 3 dots at the top right. 3. Click on the option 'Export old stock list. 4. Please ...
    • View and export products with minimal stock

      Do you want to know which products you have in minimum stock? 1. Click on 'Assortiment' in the menu 2. Under filter 'Locations' select the option 'Minimal stock' 3. Click the button with the 3 dots at the top right. 4. Click on the 'Export products' ...
    • Purchase order based on minimum stock and sales

      It is possible to generate a purchase order based on minimum stock and sales in a specific period. Please note:This order list does not show ordered products that have not yet been put in stock. So look at purchase orders in the status 'Pending', ...
    • Inventory / Balance sheets - Stock counting

      For convenience, use a laptop and barcode scanner to scan the products through the search bar. You can also search for the product number. To count the stock, take the following steps: 1 In the menu, click on 'Inventory / Stock count' 2. Find or scan ...
    • Serial numbers

      Products from expensive brands can have a unique serial number for warranty and theft. In PrismaNote, you can add it to the purchase order when booking articles. You can also export a list from the menu 'Assortiment'. Add serial number Do you want to ...