Stock Price Finder

Loading…
Margin %
Selling = cost ÷ (1 − margin)
⚠ Margin below 15% — make sure this covers overheads.
Enable Face ID / Touch ID for faster sign-in? Uses your device biometric. Password still works.

Type at least 2 characters to search.

📥 Upload or Update a Pricelist

Drop a supplier's pricelist in any format — XLSX, XLS, CSV, PDF, or even a photo/scan (JPG, PNG). The converter reads only item code, description, cost ex VAT and the picture if there is one, ignoring everything else. Matches an existing supplier to update prices, or adds a new one. Photos/scans use on-screen OCR — check the preview before applying.

📂
Drop pricelist here or click to choose · XLSX · XLS · CSV · PDF · WORD · JPG · PNG Any format — even a photo or scan. It reads only code, description, cost ex VAT & picture and ignores the rest.

🔁 Update from the shared supplier folder

Keeps prices current from the latest supplier pricelists & catalogues only — other documents (notices, specs, POs) are ignored. It looks back 4 weeks, and for each supplier only applies a file that is newer than the version already on file and actually has new prices or new items. Matching items get their prices updated; unchanged files are left alone. You can also just drag & drop a pricelist above.

Shared folder \\172.16.1.81\Company Shared Folders\SUPPLIER PRICES & DATA
⚠ Mount the PB share first. In Finder press ⌘K → smb://172.16.1.81 and sign in (your saved username/password fill in automatically). Then click the button and pick the SUPPLIER PRICES & DATA folder when prompted. The app can't log into the share for you — browsers can't access network drives directly — but once it's mounted it reads the folder and finds the recently-changed files by itself.
Last update: —
Loading suppliers…

Type at least 2 characters, or pick a supplier / category to browse.

    💰 Quote Builder0 SKUs loaded

    Paste SKUs, set margin %, lookup cost & generate a copy-ready quote / pricelist. Cost = Wadeville cost from latest sheet snapshot. Margin formula: Price = Cost ÷ (1 − Margin%).

    2️⃣ Customer details

    Shows as "Prepared by" on the quote and lets reports be filtered by salesperson.

    4️⃣ Pricing rules

    0% = Active Price Incl VAT · raise it to add margin
    💡 Tip: type hide to instantly hide all cost, GP & margin info (if a customer is looking over your shoulder), and show to bring it back.

    3️⃣ Paste SKUs

    Inline quantities: add a qty after the code using :5, x 5, @5 or a space.
    Templates

    5️⃣ Special order

    A one-off item that isn't in the catalogue — type everything in, then add it straight to the quote.

    R
    R
    Reuse

    6️⃣ Reports

    Every saved quote is logged with its salesperson, customer and totals — open the report to review, filter and export.

    ⏳ Aged Stock Lookup

    Per-SKU breakdown · national or per-branch · last GRV · qty & value at cost
    📐 What counts as aged stock
    Define your rules to get accurate results…
    Tip · all terms must match (in code or description). Use commas or spaces between terms. Wrap a phrase in quotes for exact match.

    🛍️ Consignment Order Builder

    Curate a recommended retail product line for consignment customers — by category, price tier, and brand.

    📈 Sales Report · pool of recommendable SKUs

    Upload your last-6-months sales report (CSV or XLSX). Recommendations will then come only from items that have sold in the period — so you're suggesting the latest, retail-relevant SKUs only.
    📂 No sales report loaded · recommendations will draw from all Wadeville stock.

    1️⃣ Customer & Defaults

    Each picked category will return up to 3 items per Low / Mid / High tier, prioritised by Wadeville stock-on-hand.
    When on, every category still uses the same tiers and brand mix — but only draws from the barcoded SKU set.

    2️⃣ Categories to Recommend

    Tick the categories below. Click 🎯 Strategy on any category to build a custom selection mix — top sellers by value, by volume, per brand, and per price bracket.

    🚚 RAWTEQ · Orders, GRV & Consignment

    The full stock flow: PO → supplier invoice/GRV → showroom order → month-end recon → invoice. Item costs build up as weighted average + last cost. Consignment works both ways — suppliers place stock with you, and you place stock with reseller stores.

    🏠 What's on your plate

    Your work board. Stages complete shows every order cycle on the go and what's been done so far; Due now lists what still has to be done; Completed shows the cycles that have finished every stage. Tap any card to jump to it. Updates automatically as you capture.

    Start something — what are you doing?

    Pick a task to open its guided capture flow.
    Everyday
    Tools & reports

    🤝 Partners & Customers

    The two sides of the RAW chain: a Showroom Partner supplies you on consignment — at month end you compare what they delivered to what sold, and pay them only for what was sold (their recon & sales report, SCR). A RAW Customer is the retailer using RAW to stock their store from you on consignment — they place an order on you, you place it on your partner, the stock flows partner → you → customer, all on consignment, and their month-end recon generates your invoice (RIN).

    📦 Showroom Partners consignment suppliers — paid monthly for what sold

    🏪 RAW Showrooms retailers stocked by you on consignment

    1Purchase Order · order placed with Showroom supplier

    Record the entire supplier order — order number, date, every SKU, qty and cost. Deliveries (step 2) are matched against it so you always see what's outstanding.
    Supplier & order
    Terms & delivery — optional · prints on the purchase order
    Ordered goods
    Item code / SKU Description Category Qty Unit cost R Line total

    Purchase order book

    2GRV · stock received from Showroom Supplier

    Capture the delivery against the supplier's invoice and/or delivery note. Link it to the purchase order to tick off what arrived. If the supplier placed the stock with you on consignment (their showroom stock in your hands), mark it as such — you'll report and be invoiced for it only when it sells (step 5).
    Item code / SKU Description Category Qty Unit cost R Line total

    GRV log

    3Item Cost Master · average cost, last cost & warehouse stock

    Average cost is weighted by quantity: total value received ÷ total qty received. Each GRV line creates a permanent stock lot. Ownership / lots shows exactly whose units remain in the warehouse, even when several suppliers use the same SKU.
    CodeDescriptionCategory Qty recdValue recd Avg costLast cost In whseOwnership / lots in warehouseLast receivedGRVs

    4Store Order · PO received from a reseller

    Usually the real first step of supplying: a reseller sends you their purchase order for showroom stock. Record who it's from (with their details), their PO number, and the terms — consignment (invoiced at month-end recon for what sold) or on account (invoiced in full when delivered). The showroom order in step 5 is then generated against this order and ticks it off line by line.
    Store / retailer details — saved with the store and printed on its documents.
    Item code / SKU Description Category Qty Unit price R Line total

    Store order book

    5Showroom Order · sending goods to a showroom

    When stock goes out, RAWTEQ allocates the oldest available stock lots first. The lot and owner print on the showroom order so the picker sends the correct physical units. Split ownership is preserved when one SKU comes from several suppliers.
    Item code / SKU Description Qty Availability · owner / lot

    Showroom orders

    🛒 Capture Weekly Sales · reported by the showroom

    Showrooms send their sales every week. RAWTEQ lists everything still on consignment and allocates each sale to the exact owner lots held by that showroom. The oldest lot sells first; mixed-supplier SKUs remain separated.
    CodeDescription On consignmentOwner / lot Sold this week Price R Line total

    Statement

    Sales log

    6Claims & Returns

    Supplier shortage claim (CLM): the supplier invoiced quantities that never arrived — record the shortage against their invoice and send the claim so they credit you. Claims don't touch stock: the GRV only ever records what actually arrived.
    Customer return (RET): a reseller sends stock back — wrong item supplied, damaged, not selling. The stock goes back onto warehouse on hand and comes off the store's consignment balance. If the units were already invoiced as sold, tick the credit option and a credit note (CRN) is issued.
    Item code / SKU Description Qty Unit cost R Reason Line total

    Claims & returns log

    ⚖️ Stock Adjustments · permanent audit record

    Use this only when a physical count proves that stock is short, damaged, over, or an earlier quantity was wrong. Every adjustment requires a reason and carries the exact owner/lot. Saved adjustments cannot be deleted.

    Adjustment log

    7Month-end Recon · delivered vs sold → invoice

    Reseller recon: ask the store for their current stock per item. Sold = delivered − counted, and an invoice (RIN-nnnn) is generated for it. A physical stock check is stricter: its count must agree with the ledger. Capture genuine sales first, or use a permanent Stock Adjustment for shortage, damage, overage or correction.
    Supplier consignment recon: count what's left of the stock a supplier placed with you. Sold = received − counted, and a sales report (SCR-nnnn) is generated for the supplier to invoice you against.
    Owner lots are carried into every recon automatically. Prices default to the selling price charged to the store. Leave a count blank to carry its balance forward. A manually increased opening balance is clearly marked owner to verify and cannot be dispatched later until its ownership is resolved.
    CodeDescription Expected on handOwner / lot Counted now Sold Price R Line total Note

    🧾 Statements

    Running accounts. A showroom supplier statement shows what RAWTEQ owes that partner and why (consignment sold, stock purchased, claims, payments made). A showroom reseller statement shows what that showroom was invoiced, credited and paid. The RAWTEQ statement is the internal one — revenue, cost of sales and profit.

    Record a payment

    Money actually moved — paid to a showroom supplier, or received from a showroom reseller. It posts to the account selected above and settles the balance.

    7. 💳 Payments made

    Capture money that moved — out (you paid a supplier/sponsor) or in (a reseller/sponsor paid you) — with the amount, reference and proof of payment (screenshot or PDF). Stored on this device.

    📊 Statement — payments vs stock

    A full picture per party: what you paid them (with proofs), the stock they delivered and against which GRV, what's still on hand and its value, and — for a stand sponsor/investor — the stands they back and the stock value on them. Everything a bookkeeper needs to reconcile.

    🧾 Showroom / Owner Payment Recon Report

    A sendable statement for an owner, investor or supplier: the payments made to them, the products & the stand/location each relates to, and the stock reconciliation for each location — delivered − sold (paid for) − returned = on hand — with the current holding and its value. Print or export to send.

    📑 Reports

    📊 Transaction Report · the full chain per item

    Every item's complete story in one place: who it was received from and at what cost → where it was delivered → what it sold for → the margin (revenue net of credit notes, cost at weighted average). Consignment items also show what's owed to the showroom partner. Tap an item for its full document-by-document trail.

    8Invoices & Recon History

    Every reconciliation and the document it generated — reseller invoices (RIN) and supplier sales reports (SCR) — newest first. Tap to expand; print or export to send on.

    RAW Deployed Stands

    Track what's on each deployed stand — where it is, which products are on it, how many units, and the cost and selling price per item.

    🎓 Training

    How the RAWTEQ consignment process works — an animated walkthrough and the full operating manual.

    ▶️ Process animation · watch the chain

    Nine steps from the showroom's order to the partner's payment — stock, documents and money moving between the three parties, with the books updating as each document is captured. Press Play, or step through with Next.

    📘 Operating manual · the written guide

    Every document, every flow, step-by-step procedures, a worked month, the one-page section for showroom staff, and the quick-reference card.
    On a phone the embedded viewer may not render — use “Open the manual (PDF)” instead.
    Compare 0 items Tap "+ Compare" on items to add them