v222

📥 Offline Write Queue

⚠ Last pick may not have saved — tell your supervisor if this repeats. (tap to dismiss)
ArtzFolio Super App
Tap 📷 to open camera — QR · Code 128 · Code 39 · EAN · UPC · ITF and more
1 PICK LIST
›
2 BIN
›
3 PRODUCT
📷 Camera not available The camera is off, missing or blocked.

💡 You can still scan without the camera: Use a Bluetooth barcode scanner joined to the phone. Or type the code in the box and press Enter.
📦 Multi-Item Order
Item 1 of ...
📱 Scan Pick List QR Code Tap 📷 and point at the QR code on the printed pick slip
No printed slip? Use Pick from a list. If nothing is waiting, ask a supervisor to print slips on the Bulk pick sheet tab.
Waiting for a pick slip.
🔍 Scan a barcode to check the product
Scan the SKU barcode or the ASIN (Code 128) barcode.
⚠ We cannot reach the live database now. Moves cannot be saved until it is back. Check your internet.

📋 Daily stock check ▼

A small daily list of SKUs to physically recount, so drift gets caught early. Tap Count to enter what you actually find, or Skip for today.
❓ Which button do I press?
  • Add stock received - new goods arrived. Customer return - a customer sent it back.
  • Add found stock - stock turned up that was not counted. Remove lost stock - lost, broken or stolen.
  • Hold for quality check - set aside for a quality check; the button after it puts the stock back on sale once it has passed.
  • Correct the count - you counted a bin; type what is really there. Send out - an order leaves without a pick slip. Move between bins - move stock from one bin to another.
  • Changing the button clears the product code, bin, quantity and note you typed.
📦 Add stock received
↩ Customer return
➖ Remove lost stock
⚖ Correct the count
📤 Send out
⇆ Move between bins
Other stock moves
➕ Add found stock
🔧 Hold for quality check
🔓 Release from quality check

📦 Add stock received

Scan or type the product code or Amazon number. Enter the quantity, then submit. This adds to live stock at once.
Product — scan or type the product code or Amazon number
A scanner gun types by itself. To type with the keyboard, tap the box once.
Type the code, the Amazon number or part of the name.
Bin

💾 Upload many stock changes from a spreadsheet

For many rows at once. Download the template, fill it in Excel, then upload it here. The template is a real Excel file — a drop-down list in the Action column, filters, an Instructions sheet and sample rows. You never have to guess what to type. Save it as Spreadsheet before uploading. Action can be: INBOUND, RETURN_IN, FOUND, LOST, REJECTED, QC_HOLD, QC_RELEASE, TRANSFER (needs both Bin and ToBin), or DISPATCH (stock leaving for an order — put the order number in the ToBin column).
In plain words: INBOUND = new stock in. RETURN_IN = customer return. FOUND = extra stock found. LOST = lost or stolen. REJECTED = failed the quality check and taken out. QC_HOLD = set aside for a check. QC_RELEASE = put back after a check. TRANSFER = move between bins. DISPATCH = leaves for an order. Rows marked OK are saved; if some fail, fix only those rows and upload them again.
⚠ We cannot reach the live database now. There is no data to show until it is back.
What do these words mean?
Stock: see how many units of each product are on the shelf and in which bin. Buy-more level = the stock level at which you should buy or make more. Sales speed: A sells fastest, C sells slowest.

🔄 Move stock

📦 Add stock receivedUnits arrive
📤 Send outUnits leave
⇆ Move between binsSame units, new bin
⚖ Correct the countFix a wrong number
↩ Customer returnSent back to us
➖ Remove lost stockLost or damaged

📦 Find stock

Type or scan a bin, SKU, ASIN or name: a product shows its bins, a bin shows what is inside.
📖 Look up a product listing
Find any product listing by product code (SKU), Amazon number (ASIN) or words from the title (3 letters or more). Tap Open to see the whole card and copy a value.
Searching the whole product list. This is every listing we have.

Live Stock: 0 products

Excel holds every product with a stock record, with bins, sales and held units (up to 20,000 rows). PDF and WhatsApp send the list shown now.
Tap the camera to scan a SKU, ASIN or QR code into the search box below
⚠ 0 low or out of stock
Loading...

📜 Stock history

📜 Every entry

Every stock move saved in the database. It comes from phones, Excel and the Admin Panel. All times are India time.

    📱 This phone’s own scan log (0)

    Every scan made on this phone, newest first. It is kept on this phone only; the Stock history above is the full record.
    • No scans yet. Scan a pick slip under Pick orders, or save a stock change under Move stock, and it will appear here.
    🏭 Raw Materials
    👥 Customers
    🛠 Production
    🗃 Product Listings
    This is every product listing. It has all fields from tab 6 of your Excel file. Only an Admin or Supervisor sees this tab. Changes ask for your own PIN, are saved in the change log. They reach the Excel product sheet when you open Excel or press SYNC NOW there. Cost and price fields are shown only after your PIN.

    🔧 Listing problems ▼

    🧾 Change GST in bulk ▼

    🗄 Bins ▼

    ⚠ We cannot reach the live database now. The dashboard cannot load until it is back.
    ⚠ 0 products are at or below their buy-more level
    ⚠ Some products show less than zero stock. Tap to see which.

    📊 Owner Dashboard

    One page for the owner: stock value, what is low or out, today’s picks and moves. Figures are as of the last Refresh. Tap Refresh for the latest.
    🔍 Filters
    Sales speed: A = sells fastest, C = sells slowest. From / To and Bin read the data again when you tap Apply Filters (no dates = today). Category, Sales speed and Stock Status only narrow what is already on screen.
    Loading...
    More figures and charts

    📦 Stock Status

    📁 Category Breakdown

    🏷️ Sales speed

    🏭 Bin UtilizationTop bins by units, within selected date range

    🔥 Top MoversBy number of entries, for the dates you picked

    📈 Actions each dayUnits in vs. out, within selected date range

    👤 Work done by each personTransactions per employee, last 14 days

    👤 What each person did today

    Loading...

    📅 Work done by each person (last 14 days)

    Loading...
    Active hours are a guess based on scans. They are not shift records. Use them as a rough guide.
    Start here. This guide explains how to use the ArtzFolio Super App on your phone: pick orders, record stock, find stock and fix mistakes. New? Read “Daily Workflow” first. Steps marked (laptop) are done on the office computer, not on the phone. Guide last updated 6 Nov 2026.

    🔔 Today, Needs your help, Labels and Undo

    1. Today: shows the jobs waiting for you and what is late. Tap the button on a job card: Accept when you start it, then Complete when it is done. On label and restock cards one Done button does both.
    2. Needs your help: a list of products the app could not add by itself (a missing or doubtful name, SKU, MRP (price), ASIN or pieces-in-a-pack number), so a person can fix them. It asks for a manager PIN to open. Admins and Supervisors deal with the items; other people see it only if an Admin has allowed it.
    3. Labels: the Labels button opens Label Studio, where you print product and shelf stickers. The button shows only for people who are allowed to make labels (Admin, Supervisor, Inventory Lead, Production Lead). Printing is for Admins and Supervisors.
    4. Undo: after some stock changes a bar with Undo can show for a short time. If you see it, tap it to take the change back. When it has gone, use Void in Stock history (Supervisor or Admin PIN).

    📋 Daily Workflow

    1. Amazon orders (laptop): on the laptop run the print step (2_MERGE_AND_STAMP) and print the QR file. Printing an invoice holds its stock until the slip is scanned.
    2. Pick orders: tap the camera and scan the pick QR code on the slip. Go to the bin and scan the product. The slip ends with a green Picked ✓.
    3. Other sales (Shopify, Flipkart, Myntra, direct, referral): Move stock → Send out. You must pick a channel. For Amazon channels you must also give the order number. Book one sale in one place only.
    4. Stock in, returns, found, lost, quality hold or release, moves between bins and counts: Move stock. A bin is needed on every movement, including Correct the count.
    5. Raw materials: items, vendors, receiving, bills and raw-material stock. Production (Production orders): production jobs and what they use. Customers (Customers): customer list, orders, warranty and quotes. Reports (Dashboard): sales, stock, forecast and production figures. Each opens with a short line saying what it is for. Admin and Supervisor see them; others only when the Admin switches them on. The lower menu shows Today, Stock, Orders, Labels and More (you only see the groups your role may open).
    6. Finding stock: Find stock. Type a SKU, ASIN, name or size (4x6, 4 by 6). Suggestions appear as you type; tap a result for the full SKU page.
    7. Stock history: full stock history with filters. A wrong entry is corrected with Void (Supervisor / Admin PIN). Void before the daily Excel stock sync.
    8. Dashboard: Overview, Sales, Inventory, Forecast and Production. You need the Analytics permission. Tap a row to open its SKU page.
    9. Product Listings (Admin / Supervisor): find a listing, open it, edit fields, switch ON / OFF, or Quick Add. Percentages are typed as %, for example 18 for 18%. If you leave the app, the open sheet is kept for 3 minutes.
    10. Every title, SKU, ASIN, order, bin and entry number has a small 📋 button: tap it to copy.

    📷 Camera — How to Open & Scan

    1. Tap the blue camera button inside the app (in the scan bar at the top)
    2. Tap Allow when Chrome asks for camera permission
    3. The camera overlay will open — point it at a barcode or QR code
    4. Supported formats: QR Code, Code 128, Code 39, EAN-13, EAN-8, UPC-A, UPC-E, ITF, DataMatrix, PDF417, Aztec
    5. Tap the floating ✕ button (top of the camera view) to close the scanner at any time. The phone's Back button now also closes the scanner. It does not leave the app.
    6. If the camera button shows an error, use a Bluetooth scanner. Or type the code and press Enter.

    📱 Opening the App on a Phone

    1. Open the ArtzFolio Super App link your Admin gave you (it looks like app.artzfolio.com) in Chrome and sign in with your code and PIN.
    2. Chrome menu → Add to Home screen, so it opens like an app.
    3. Tap Allow when Chrome asks for the camera.
    4. If the small badge at the top corner is not the newest version, close the app. Then open it again, or pull down to refresh.
    5. Camera still blocked? In Chrome, open the menu. Tap Settings, then Site settings, then Camera. Allow it for this site.

    📚 Glossary

    Held stock (stock set aside for an order) — Units held for an order after its pick slip is printed. No other order can take them. They are free again when the slip is picked or released
    Quality check — Hold for quality check sets stock aside while it is checked. Release from quality check puts it back on sale after it passes
    Sales speed (A fastest, C slowest) — How fast a product sells: A sells fastest, C sells slowest or not at all yet
    Buy-more level — The stock level at which it is time to buy or make more
    Waiting for stock — Not enough free stock when the slip printed (or another line of this order could not be covered). The slip says DO NOT PICK
    Daily stock check — Find it in Today and in Stock. A short daily list of products to count again on the shelf. It helps catch mistakes early
    Buying pattern — In Customers: how often a person buys. Examples are Regulars and Slipping away
    PIN — Your own 4-digit secret number. It is asked when you sign in, and again only for steps that cannot be undone. Ask the Admin if you forget it
    AF2 — the first letters of every ArtzFolio pick-list QR code (the code on a pick slip). A pick-list QR code starts with AF2|
    BIN — Physical shelf location. BIN QR stickers are on the shelf/rack. Bin QR data starts with BIN|
    ASIN — The Amazon product ID. At step 3, scan its Code 128 barcode. Use it in place of the SKU barcode
    Pieces per set — Pieces in one unit you sell (for example, a Set of 10 has 10 pieces)

    🔄 ACTIONS / STOCK / Bulk Upload — Bin-Level Stock

    • Move stock — records one stock move at a time. The moves are New Stock In, Returns In, Found, Remove-Lost, Hold for quality check, Release from quality check, Correct the count and Transfer. A Every move needs a bin, even Correct the count — the app auto-fills the SKU's usual bin, but you can always overwrite it (e.g. new stock landing in RECEIVING instead of the SKU's normal shelf).
    • Correct the count — a pill on the Move stock, for a physical stock count only (not daily use). This counts ONE BIN at a time. Type the bin you physically counted and the number you found in that bin; the app compares it against what that same bin currently shows and saves only the difference. Any other bin holding the same SKU is listed in the confirmation box and is never changed. A note is recommended but not required. Bin is required here too, like every other action.
      Why one bin at a time: an older version compared your one-bin count against the SKU's total across every bin, so counting a SKU that lived in two bins silently pushed one bin negative — and the next action on that bin then failed with a confusing error. If a SKU sits in several bins, count each bin separately.
    • 💾 Bulk DISPATCH — The bulk-upload spreadsheet now also accepts DISPATCH, for booking out many orders at once. Put the order number in the ToBin column. This is the same action, same wording and same column as the Excel sheet's DISPATCH, so one filled-in sheet works in either place.
    • 📤 Send out — A button on the Move stock. Use it when stock leaves for a customer order. Scan the SKU. Confirm the bin it came from. Enter how many. Add the order number and channel.
      Why this matters: low-stock alerts, the fast / slow seller tiers (A / B / C) and the forecast are all worked out from what leaves the warehouse. Book every dispatch here, or finish the pick on the Pick orders, so those figures stay right.
    • 🗃 Product Listings (Admin or Supervisor): find any listing, Open it to see and edit every field from your product spreadsheet (Excel tab 6), switch it ON or OFF for stock, or use Add a product for a product that is not in the system yet (name, product code, Amazon number and type. Bin and starting stock are optional.) Every change needs your own PIN. It is saved in the Audit Log. The Bins section lists every bin and lets you delete an empty one.
      What happens if you just scan an unknown code instead: nothing is ever placed in a random bin. On New Stock or Returns an amber “Add a new product” panel opens so you can add it and carry straight on. On Remove/Lost, Hold for quality check, Release from quality check or Correct the count the app says no. Counting or removing something never received is a mistake, not a new product.
    • Release from quality check — a pill on the Move stock, previously only reachable via the bulk upload. Releases stock that was held for a quality check back into sellable count, using the same product code / bin / quantity / note form as the rest of this tab.
    • Transfer — a button on the Move stock. Moves existing stock from one bin to another — the SKU's total is unchanged. Enter the bin it's moving FROM (the usual Bin field), the bin it's moving INTO, and the quantity. Writes as two linked rows (stock out of the old bin, into the new one) — the same way a bulk-upload TRANSFER row already worked, just as a single-item action here. To move an entire scanned session's contents to a different bin in one go, use the Admin Panel's Scan Sessions page instead.
    • Upload many stock changes from a spreadsheet — on the Move stock: download the template, fill it, upload. There are exactly 8 allowed Action values. Anything else is blocked:
      • INBOUND — New stock that reaches the warehouse for the first time. It is a new purchase or a new batch being put away. (adds to stock; needs SKU, Bin, Qty)
      • RETURN_IN — A customer sent it back and we got it. (adds to stock; needs SKU, Bin, Qty)
      • FOUND — Stock found during a count. It is on the shelf but missing from the system. (adds to stock; needs SKU, Bin, Qty)
      • LOST — Stock leaving the system without a sale: missing, shrinkage, theft, damage, expiry or any deliberate write-off. Put the actual reason in the Note column — that is what separates a breakage from a theft in the permanent record. (reduces stock; needs SKU, Bin, Qty, Note)
      • REJECTED — Stock that failed a quality check. It is taken out of sellable stock for good. (reduces stock; needs SKU, Bin, Qty, Note)
      • QC_HOLD — Hold for quality check: sets stock aside, not sellable until checked. Takes stock out of the sellable count while it waits for a quality decision. The goods are still physically there — they just must not be sold yet. Release them later with QC_RELEASE. (reduces stock; needs SKU, Bin, Qty)
      • QC_RELEASE — Release from quality check: puts stock that passed back on sale. It is the opposite of QC_HOLD. (adds to stock; needs SKU, Bin, Qty)
      • TRANSFER — Moves stock from one shelf location to another. Total stock does not change — only where it sits. Bin is where it is moving FROM, ToBin is where it is moving TO. (moves stock from one bin to another; needs SKU, Bin, ToBin, Qty)
      TRANSFER is the only Action that uses ToBin, and one TRANSFER row writes two lines in the stock history. One takes stock out of a bin. One puts it into the other bin. Every row needs a Bin and a positive Qty — never type a negative number. The Action decides the direction. Each row still shows OK or FAILED.
    • Bin-mismatch note — if the bin you use is different from that SKU's usual bin, the result still says OK (this is never blocked) but adds a short note so you can catch a typo, e.g. "OK (note: this SKU's usual bin is A12, this entry used B04)".
    • Find stock — live, read-only view of current quantities. Search by SKU, ASIN, or Bin to find where something is right now.
    • Actions / STOCK / Bulk Upload all write to the SAME live database as this Excel file and the Admin Panel — there is no separate copy anywhere, and every write is tagged with which tool made it (visible to an admin as "entry_source").

    🔧 Troubleshooting

    • Camera button not working, or the screen is black — Tap the blue button inside the app (not the Chrome address bar icon). On first use, wait 2–3 s for permission prompt
    • QR not scanning — Hold phone 15–25 cm from QR code, good light, keep still; the orange scanning line shows it is active
    • Product mismatch — Try scanning the ASIN barcode instead of SKU label (or vice versa)
    • Wrong bin scanned — Tap ← Back, go to the correct bin and scan again
    • The pick will not finish — Check that every line shows its full count scanned. The slip ends with a green Picked ✓ only when all lines are done.
    • QR missing in Excel pick list — Re-run Step3_GenerateBarcodes in Excel

    🔠 Text size

    Makes all text on this phone smaller or bigger. Saved for you on this phone.

    👤 Logged-In Employee

    Not set

    🔒 Phone Code

    Loading...

    ☁ My actions, saved online

    Your last 50 stock actions, taken from the live database. They stay saved even if you clear this phone. This is your lasting record.

    🔄 Continue where I left off

    Your current pick session is auto-saved. If the app is refreshed mid-order, it will resume where you left off.
    📦 ArtzFolio Super App v222
    Tap the button below to see what is new in this version.
    1.0x
    ⚠ No barcode scanner on this phone or connection Close this and type the code manually in the field, or use a Bluetooth/USB scanner gun.
    Point at the barcode or QR code
    👁 The picture is blurry. Hold the barcode a bit further away and keep it still.
    Zoom1.0x
    Loading scanner...
    Scanning…

    🔒 Sign in

    Enter your employee code and 4-digit PIN to begin.

    Forgot your PIN? Ask the Admin or your Supervisor.

    Choose

    🔒 Held stock: by printed batch
    ❓ What is this screen?
    • Printing reserves stock. When pick slips are printed, their units are held for those orders, so no other order can take them.
    • Picking removes it. Scanning the slip, the bin and the product takes the units out of stock - the hold ends there.
    • Release only if an order was cancelled or will not be packed. Releasing puts the units back as free stock, and that slip will no longer work.
    • Finished batches close on their own once nothing in them is held any more.
    📋 Held stock: every line
    ❓ What is reserved stock? When should I release it?
    • Reserved means these units are kept aside for one order, because a pick slip was printed (Amazon bill stamping) or a bulk / Excel pick sheet was made. No other order can take them.
    • Picking the slip takes the units out and ends the hold by itself.
    • Release a line only when it will not be picked. The order was cancelled, or the team packed it from other stock.
    • Order already dispatched another way the same order and product already left stock another way (phone send out, bulk or Excel). Or its Amazon order line is marked picked. It is usually safe to release. Check first.
    • Some units of this order already went out another way part of the order went out by another route, but not all the reserved units. Check before releasing.
    • Old – check held more than 2 days. Find out if the order is still coming.
    • All dates and times on this screen are India time (IST).
    • Releasing only frees the stock in this app. It does not change or cancel anything on Amazon. The printed slip for that line stops working.

    🔒 Your code and PIN

    Type your PIN once to continue. It is kept in this phone's memory only (never saved).

    Why am I asked?
    Your PIN proves it is you before costs, customer details or stock changes are shown or saved.
    No PIN yet, or forgot it? Ask the Admin or your Supervisor.

    🔒 Your code and PIN

    Type your PIN once to continue. It is kept in this phone's memory only (never saved).

    Why am I asked?
    Your PIN proves it is you before costs, customer details or stock changes are shown or saved.
    No PIN yet, or forgot it? Ask the Admin or your Supervisor.

    🔒 Your PIN

    Confirm this change with your own PIN.

    Void entry

    Why are you releasing?

    Count this bin now

    You said the stock was not on the shelf. Count the bin now so the stock figure is corrected.

    Add it again?