Order list and inventory management

Shoporama's order list helps you keep track of which products need to be reordered. The system automatically calculates what you need based on your minimum stock and you can export the list as a CSV to your suppliers. You can also receive goods by uploading invoices or CSV files.

Order list

You can find the order list under Warehouse > Ordering in the admin. Here you get an overview of all products that are running low:

• Current stock status - See the current quantity in stock for each product
• Minimum stock - The minimum quantity you want to have in stock
• Calculated order - The system automatically calculates how many you need to order home
• Minimum order quantity - If you have set a minimum order quantity, it will automatically round up

Filtering and searching

The order list can be filtered so you can easily order from one supplier at a time:

• Supplier - Filter by specific supplier
• Brand - Filter by brand
• Online/offline status - Show only online or offline products
• Out of stock only - Only show products that are below minimum stock
• Free text search - Search by product name, item number, etc.

You can also choose which columns to show in the list, such as item number, secondary item number, MPN, EAN, labels and notes.

Export as CSV

Once you have your order list ready, you can download it as a CSV file via the "Download order list (.csv)" button. The CSV file contains:

• Item number (SKU)
• Secondary item number
• MPN and EAN
• Quantity to order
• Product name
• Purchase price

You can send this file directly to your suppliers or use it for internal planning.

Products with variants

The order list supports products with variants (e.g. colors and sizes). Stock is tracked per variant, so you can see exactly which variants are missing and order the right amount of each.

Receive goods via CSV

When you receive goods from the supplier, you can upload a CSV file under Stock > Order > Upload order list. The system automatically matches item numbers to your products and adds the received quantity to the inventory. You get a preview before the items are posted so you can verify that everything is correct.

AI-based goods receipt

Shoporama has a smart feature that lets you upload PDF invoices or images of delivery notes. The system uses AI to automatically read item numbers and quantities from the document. You get a preview of the items found and can approve them before they are added to the warehouse.

The feature supports:

• PDF invoices from suppliers
• Delivery note images (JPG and PNG)
• Automatic extraction of item numbers and quantities
• Preview and approval before posting

Set up minimum stock levels

For the order list to work optimally, you should set minimum stock levels for your products. You do this when editing the individual product in the Minimum stock field. You can also set a minimum order quantity if your supplier requires a certain minimum per order.