Master Prefix Mapper every saved courier name, synced to backend
📁
0
Files
📦
0
AWBs
✅
0
Scanned
⚠️
0
Not found
📉
0
Loss
1Upload master sheet(s)
No file loaded yet. Stays saved for 30 days — no need to re-upload daily.
2Single scan
Result appears here.
3Bulk paste
Product
Qty
Channel
Profit
Cost
AWB
Order No
Product
Channel
Qty
Profit
Cost
Order Date
SLA Date
Source
Date
AWB
Order No
Channel
Date
No unmatched AWBs.
Amazon: Self Ship (has customer mobile) flagged if profit ≤ ₹50; Easy Ship (no mobile) flagged if profit ≤ ₹10. Other channels: flagged if profit is below ₹20.
AWB
Product
Channel
Ship Type
Profit
Date
No loss-making orders found.
Auto-saved data
Everything you scan or upload saves automatically in this browser and is kept permanently until you delete it.
Stored Data
Order Mapper's own data — price lists, vendors, and remembered matches. Kept permanently until you delete it. Not shown on the main tabs — manage it here.
Cloud sync (Firebase — real-time)
Paste your Firebase config once. Every device connected this way syncs instantly — no waiting, no polling.
Not connected.
Saved Excel backups
Click "Save Data" in the Order Scanner tab to store an Excel copy here — open it anytime, from any device.
File
Saved
No backups yet.
Download backup
Save a copy of all current data (courier scans + order data) as a file you can keep safe or move to another computer.
Restore from backup
Upload a previously downloaded backup file to bring that data back. This replaces what's currently loaded.
Clear all data
Permanently erases everything saved in this browser. Download a backup first if you might need it.
New Courier Detected
Prefix ""
This AWB prefix hasn't been seen before. Name it once — it's remembered on every device from now on, for every AWB starting with this prefix.
Duplicate AWB
This AWB is already in the list.
Forget Courier Name
Prefix ""
Currently saved as "". Existing scans keep their AWBs — this only means it'll ask again next time this prefix is scanned.
Multiple Items Found
has items
This AWB/Order matched more than one product. Choose which to add to the scan log — all are checked by default.
1LOTS price listUpload once — Item Code + Product Name, saved for next time.
2Other vendorsJust add their names — no file needed.
3Upload order fileYour product + quantity file (no item ID).
4Match & downloadFix what needs a look, get one file per vendor.
LOTS Price List
Item Code + Product Name file exported from LOTS. Uploaded once — saved in this browser, so you won't need to upload it again next time.
Other Vendors
Just their names — no price list needed. Order lines you map to them get their product name and quantity, ready to send.
Order File
Pulled directly from this console's own Product Summary — no upload, no config to paste, always up to date with whatever's been scanned (including from other devices via Cloud sync).
Or upload a file instead
Review matches
Rows that need a decision are open below — pick the right match and they tidy themselves away. Everything already sorted out sits collapsed to one line — click it any time to make a change.
Product
Qty
Match / Vendor
Order Qty
Rate & Value
Status
Vendor Order Summary
What will actually go out to each vendor — exactly what the download files contain.
Master Mapping File
Every product mapping learned so far, in one place — which vendor it goes to, the item code, the pack conversion, and whether it's part of a combo. This is remembered permanently, so it only grows as you go.
Order Product
Vendor Product
Vendor
Item Code
Pack Conversion
Combo
Actions
Sasta Store · Self-Ship Operations
Amazon Shipping Confirmation Generator
Upload your OMS Guru export — get the ready-to-upload Amazon flat file
1Upload
Click to choose file, or drag it here
OMS Guru order export · .csv or .xlsx
1BZippy / Nexshyp
Optional — used as fallback if tracking number is missing in the OMS file.
Click to choose file, or drag it here
Zippy / Nexshyp export · .csv or .xlsx
2Order IDs
Paste only the Amazon order-ids you want this file for (one per line, or comma-separated). Only these will be included.
0
Order-ids Entered
0
Matched In File
0
Ready To Confirm
No matching rows to download yet — check the note above.
Flagged Order-ids
◆Logic applied: Only the order-ids you paste in Step 2 are included — nothing else from the file. order-item-id comes from Channel Sub Order Id, tracking number from Shipment Tracker (Zippy/Nexshyp is checked as a fallback if it's missing there). ship-date is always today's date, ship-method is always "Surface". Carrier-code and carrier-name are always the same value (ATS is mapped to "Amazon Shipping"). After matching, each seller account/channel (e.g. Praso, E-commerce Munda) gets its own row with its own Download button — a separate file attachment per account, ready for its own Seller Central upload. If a pasted order-id isn't found, or has no tracking number in either file, it's flagged and left out.
Output matches Amazon's ShippingConfirmation.xlsx column format exactly — upload it straight to Seller Central.
Loss Orders
Pulled from the same auto-synced OMS Guru data as OMS Orders, filtered to loss-making orders using the exact rule from Order/AWB Scanner: Amazon Self-Ship (has buyer phone) ≤₹50 profit, Amazon Easy Ship (no phone) ≤₹10, other channels <₹20.
to
Waiting for first sync — connect Firebase in Backend/Data if you haven't, then wait up to 15 minutes.
Order Date
Order Number
Product
Channel
Qty
Total
Profit
Status
AWB
Courier
OMS Orders
Auto-pulled from OMS Guru every 15 minutes by a background sync — nothing to upload here. Rolling last-15-day window. Newest first.
to
Waiting for first sync — connect Firebase in Backend/Data if you haven't, then wait up to 15 minutes.
Order Date
SLA Date
Order Number
Product
Channel
Qty
Total
Profit
Status
AWB
Courier
Zippy Shipments
Live shipment status for your Amazon self-ship orders, pulled from Zippy and cross-referenced with the matching OMS order for product/buyer context.
Upload a Zippy export (manual sync fallback)
Waiting for first sync — connect Firebase in Backend/Data if you haven't, or upload a Zippy export above.
Order Number
Product
Buyer
Status
Sub Status
AWB
Courier
Shipping Cost
Synced
SP-APINot synced yet
SP-API — Praso Enterprises
Orders, inventory, and competitor pricing pulled directly from Amazon via SP-API — no OMS Guru needed for this account.
Order ID
Item(s)
Status
Total
Tax
Referral Fee (est.)
Shipping Fee
Product Cost
Est. Profit
Fulfillment
Purchase Date
Waiting for first sync.
Product Name
SKU
ASIN
Quantity
Price
Cost (₹)
Last Updated
Waiting for first sync.
Product Name
ASIN
Lowest Price
Offer Count
All Sellers
Waiting for first sync.
Shared Documents
Upload important files here — every employee can see and download them. Stays here permanently until someone deletes it. Max ~700KB per file (PDFs, Word docs, images work fine — large videos won't fit).
No documents uploaded yet.
📦 Label Generator
Product data is pulled from the Zippy Shipments tab — just upload the label PDF. If an order isn't found in Zippy data, the label is kept as-is with only the VA box removed.
Zippy order data not loaded
Upload a Zippy export in the Zippy Shipments tab first.
SHIPMENT LABELS PDF
0
Total Pages
0
Amazon-style
0
Zippy Collection
0
Zippy PrePaid
0
Matched
0
Unmatched
⚠ Labels with no matching AWB/Order in your order sheet: