Order Extractor

Seller Central se copy karke paste karein — Orders aur Transaction fees dono ek jagah, sequence hamesha safe.

📌 Home screen pe add karne ke liye: browser ke top-right menu (⋮ ya Share icon) mein jayein aur "Add to Home screen" select karein.
Workspace

Har workspace ke Orders, Transactions aur Saved History mukammal alag hain — ek friend ka data doosre se kabhi match ya mix nahi hota. Sirf CP Database sab friends mein shared hai.

Current Working Day No saved day yet
Orders Saved: 0 Last Updated: —
📦
AMAZON ORDERS TEXT
Import Amazon Orders
💷
AMAZON TRANSACTION TEXT
Match Amazon Fees
🏷️
CP MANAGEMENT
Shared Cost Price database
Paste text daal kar "Import Orders" dabayein.

DATE, Amazon ID, ASIN, QTY aur EARNING PRICE nikalta hai — STATUS blank rakha jata hai (sheet mein dropdown hai). CP column ASIN ke against shared CP Management database se automatically fill hoti hai — agar us ASIN ki CP saved nahi hai to CP blank rehti hai (kabhi 0/N-A/dusre ASIN ki CP nahi). "Copy" dabate hi Amazon IDs history mein save ho jate hain taake dobara paste karne par duplicate na banein. "Import Orders" har baar day-memory bhi save karta hai — is memory ko sirf "Clear Daily History" clear karta hai.

Pehle "AMAZON ORDERS TEXT" se orders import karein, phir yahan transactions paste karke "Import Transaction Fees" dabayein.

Matching hamesha exact Amazon Order ID se hoti hai — row position ya date se nahi. Amazon fee hamesha row ke 3rd currency column se liya jata hai (Total product charges → Total promotional rebates → Amazon fees → Other → Total), kabhi bhi Total ya subtraction se nahi. Minus sign hamesha remove hota hai. Missing fee ko khali (blank) chhora jata hai — 0 ya N/A kabhi nahi likha jata. Agar fee confidently na nikle to "FEE PARSE ERROR — REVIEW REQUIRED" dikhta hai aur Copy Fees tab tak disabled rehta hai jab tak sab clear na ho jaye ("READY TO COPY").

Add / Update ASIN Cost Price

Yeh CP database sab 4 friends mein shared hai — kisi bhi workspace se ASIN add/update/delete karein, baaki sab ko turant (ya refresh par) nazar aayega. Har ASIN ki sirf ek hi entry rehti hai — dobara same ASIN save karne se woh update ho jati hai, duplicate nahi banti.

Bulk Import from Sheet

Apni sheet ka data (Date, ASIN, Quantity, CP columns — tab ya comma separated, header row ke saath ya bina) yahan paste karein. Same ASIN multiple dates mein ho to sabse latest date wali CP ko current CP maana jayega.

CP Database

ASINCurrent CPLast UpdatedActions

Search Saved Order

Saved History

Har din ka generated Order Output aur Fee Output yahan hamesha ke liye saved rehta hai — refresh/close/reopen se delete nahi hota, sirf aap khud delete karein.

Copied — history updated