Bolton stock value
£0
0 units on hand
Sign in
Email code login
Enter a work email on the allowlist. We will send a one-time login code.
Reports
Reports
Company IDs that can open each report, and the SKU paste cap. Leave company IDs blank to hide a report from non-admins.
Admins always see every report. Max SKUs is the paste cap for that report. Default 1500.
Tools
Company IDs that can open each tool. Leave blank to hide it from non-admins. SQL Lab uses the same database connection. Non-admin queries are limited to those company IDs.
Admins always see every tool and can query any company. Ticking SQL Lab on a person lets them run it for the company IDs above.
People
Who can log in, their company IDs, and which reports and tools they can open. A new person starts with nothing ticked. Existing ticks stay until you press Save.
| IDs | Role | |
|---|---|---|
| No people yet. | ||
Select a person to view or change access. Saved ticks stay as they are until you save.
Run history
Lookups triggered across reports. Who ran them and how long they took.
| Report | User | Date & time | Duration | SQL |
|---|---|---|---|---|
| No runs yet. | ||||
Connection
Orderspace and BigCommerce. Open a card to store, edit, or disconnect. Nothing is contacted until you press Test.
Connection
This connection does not exist.
No webhook. The portal calls this API with the credentials below.
Access
You do not have permission to view this report
Your account is not allowed to open this page. Ask an admin if you need access.
Query
Results
| No rows yet. |
SKU list
One per line, or comma separatedMax 1500 SKUs per lookup. Extra lines are ignored.
Results
| Barcode | SKU | Item | Bolton qty | Alloc | ECOM pick | ECOM stor | WH pick | WH stor | Prem pick | Prem stor | St Helens qty | St Helens stor |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paste SKUs and run lookup. | ||||||||||||
SKU list
One per line, or comma separated · optional filterMax 1500 SKUs if filtering. Leave empty for all products in range.
Results
| Product | SKU | Commodity | Eliquid ml | MAC | Brand | Group | Category | Origin | Units sold | Units value |
|---|---|---|---|---|---|---|---|---|---|---|
| Set filters and run lookup. | ||||||||||
SKU list
One per line, or comma separated · optional filterMax 1500 SKUs if filtering. Leave empty for all products in range.
Results
| Product | SKU | Commodity | Eliquid ml | MAC | Brand | Group | Category | Origin | Units sold | Units value | Bolton qty | Alloc | On hand | ECOM stor | WH pick | WH stor | Prem pick | Prem stor | St Helens qty | On hand | ST HELENS ECOM PICK | St Helens stor |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Set filters and run lookup. | ||||||||||||||||||||||
SKU list
Parent or size SKU · one per line, or comma separatedMax 1500 SKUs per lookup. Extra lines are ignored.
Results
| Product ID | Product SKU | Product name | Product deleted | Size ID | Size SKU | Size name | Size deleted |
|---|---|---|---|---|---|---|---|
| Paste SKUs and run lookup. | |||||||
Contacts
FED and Procuria tags only
Searching…
Type FED or Procuria, then press Search or Enter.
Results
| Order date | Contact | Brand | Group | Category | Total Quantity | Net Sales |
|---|---|---|---|---|---|---|
| Select contacts and run lookup. | ||||||
| Combined total | 0 | 0.00 | ||||
SKU list
Max 1500 if filtering. Leave empty for all.
Results
| SKU | Name | Brand | Group | Category | Tags | Bolton Qty | St Helens Qty | Peterlee (P2R) Qty | Bibby Qty | Total Qty | Orderspace Qty | Bigcommerce Qty | Difference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paste SKUs and run lookup. | |||||||||||||
SKU list
Max 1500 if filtering. Leave empty for all.
Results
| SKU | Name | Brand | Group | Category | Tags | Bolton Qty | St Helens Qty | Peterlee (P2R) Qty | Bibby Qty | Total Qty | App Qty | Bigcommerce Qty | Difference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paste SKUs or leave empty for all products, then run lookup. | |||||||||||||
SKU list
One per line, or comma separatedMax 1500. Each pasted SKU is marked Parent SKU or Alternative SKU.
Results
| Product | SKU | Alternative SKU | Status |
|---|---|---|---|
| Paste SKUs, then run lookup. | |||
Results
Bibby Storage only. Press Run lookup.| SKU | Product Name | Bibby Qty | Bibby Storage |
|---|---|---|---|
| Press Run lookup to load Bibby stock. | |||
| Transfer | Created At | Received At | Route | Status | SKUs | |
|---|---|---|---|---|---|---|
| Press Run lookup to load Bibby transfers. | ||||||
Customers
Search, then tick who to include
Searching…
Type a customer name, then press Search.
No customers selected.
Results
| Contact | SKU | Product | Total Quantity | Net Sales |
|---|---|---|---|---|
| Select customers and run lookup. | ||||
| Combined total | 0 | 0.00 | ||
Category
Choose a price book, then Run lookup.
Brand
| SKU | Product | Price | MAC | Tags |
|---|---|---|---|---|
| Pick a brand. | ||||
| Name | Brand | Category | Barcode | Unit | SKU | Price | Loyalty | Qty | Deleted |
|---|---|---|---|---|---|---|---|---|---|
| Choose a price book, then Run lookup. | |||||||||
SKU list
Max 1500 SKUs if filtering. Leave empty for all.
Results
| Account | Contact | SKU | Name | Brand | Category | Qty | Value | vs last month | vs last year |
|---|---|---|---|---|---|---|---|---|---|
| Set filters and run lookup. | |||||||||
SKU list
Additional SKUs · one per line, or comma separatedMax 1500 if filtering. Leave SKUs and tag empty for all parents. Extra lines are ignored.
Results
| Pasted SKU | Name | Variant | SKU | Additional SKU | Tags |
|---|---|---|---|---|---|
| Paste additional SKUs or enter a tag, then run lookup. | |||||
SKU list
SKU or barcode · one per line, or comma separatedMax 1500. Leave empty for all parent products. Extra lines are ignored.
Results
| Barcode | SKU | Additional SKU | Item name | Bolton Qty | St Helens Qty | Peterlee (P2R) Qty | 3PL (P2R) Qty | Bibby Qty | Target | Adjusted | Incoming | Days | Ringfence Qty |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Paste SKUs or barcodes, then run lookup. Empty paste lists all parents. | |||||||||||||
Results
| Order Number | Reference | Order Date | Due Date | Origin | Contact Name | Status |
|---|---|---|---|---|---|---|
| Paste a sales order number in the header search, then click the match. 3002839 or SO03002839. | ||||||
Stores
Lincolnshire, SGN, and EGOTM. Head office is left out.Run lookup to load the stores.
Details
| Choose the invoice dates, then run lookup. |
Results
All
| SKU | Name | Brand | Group | Category | Bolton Qty | St Helens Qty | Peterlee (P2R) Qty | 3PL (P2R) Qty | Status |
|---|---|---|---|---|---|---|---|---|---|
| Run lookup to load Bolton and St Helens stock. | |||||||||