China Pack

Excel Format

Required Columns: Order ID | Status | Tracking Number | Notes | COD Amount | Estimated Delivery Date

Upload .xlsx files only. First 10 rows will be previewed before confirmation.

Preview (First 10 Rows)

How to run it

1. Once — Chrome/Edge: drag the green button onto your bookmarks bar. Can't see the bar? Press Ctrl+Shift+B (Mac: Cmd+Shift+B).
   Once — Safari: Safari will not accept a dragged bookmarklet. Press Copy the bookmark instead, then on any page: Bookmarks → Add Bookmark → save it to Favourites and name it China Pack ← 1688. Then Bookmarks → Edit Bookmarks, right-click that bookmark → Edit Address, and paste. Show the bar with Cmd+Shift+B.
2. Open 1688 → 已买到的货品 / My orders, signed in to the China Pack account.
3. Click the China Pack ← 1688 bookmark. A box appears on 1688 and this dashboard opens in a new tab. Keep both open for about 2 minutes.
4. When the box says Done, come to this tab, check the list and press Add … tracking numbers.

Warehouse sheets

🇱🇧 Items in Lebanon — Chinagate invoice

🚚 Aramex — where are the parcels?

📦 Ship with Aramex — create, labels, pickup

Send a checkout to your 1688 cart

1. Open 1688.com in the same browser, signed in to the China Pack account.
2. Click the China Pack → 1688 cart bookmark.
3. A China Pack tab opens — pick ✈️ Air or 🚢 Sea. They go to different warehouses, so do one, pay it, then the other.
4. Check the cart on 1688 and pay.

Failed Orders

A product appears here once you move its order to “Ordered from Supplier” — that is the moment the real weight and volume become knowable. Newest first, each tagged with its order code so you can match it to the box. Record the real numbers and the estimator learns from them permanently.
Orders still at “Order Placed” are not listed: nothing has been sourced yet, so there is nothing to measure.
This list is complete: unlike “To confirm” below it is never trimmed, because a reading is worth taking whenever somebody is standing next to the goods.

Ask the supplier for one packed piece. If they give a master pack — screws, cable ties, small parts — enter the whole pack weight and size plus its pcs count; we divide both. ⚠️ Weight and L/W/H must describe the same pack. Always choose WHICH size or option the supplier confirmed; the exact ordered variant and a listing's only option are preselected, and the system never guesses. Use L/W/H in cm, or direct CBM when that is what the supplier gives you. Press Enter to save and move to the next.

The AI is priority (since 24 Sep): the seller's figure bills only when it agrees with the AI (within 1.8×). When they disagree, the AI's weight bills and the box is the middle of the two (🤖 AI BILLS rows). This list shows the disagreements with real money at stake. Merchant is right puts the seller's figure back on both axes; Enter a real size records a reading, which outranks everything.

Learned from sellers

Learned

Add by product ID

Paste a batch

One product per line: link or ID, kg, L, W, H — or link or ID, kg, cbm=0.0107 if the supplier gave you a volume instead of sides. Paste straight from Excel.

Accuracy

Biggest misses

Actions

Cache Statistics

One row per call that actually reached Elim. A text search costs 1 credit, an image search 2 (upload + search), opening a product 1. Cached repeats cost nothing and never appear here — so if this list is short while the balance dropped, the spend was not customer traffic.

Recent Notifications

Shipping Prices

Payment Gateway (Whish)

Which Whish environment the backend is actually talking to, and whether the credentials work. Sandbox means no real money moves. Set on Railway, not here.

Processing fees charged to the customer at checkout. Shown per method so the cheaper one is visibly cheaper, and added to the total. Card rates apply once the gateway is signed — one rate for all cards, since the local/international split depends on the card's issuing bank, which is unknowable before it's entered.

Customer Markup — your regular prices

Hidden markup added on top of the real 1688 cost. It slides by price: cheap items carry a high percent, expensive items a low one. Between two rows the percent is blended smoothly. Below the first row the first percent applies; above the last row, the last.
This is your normal price list. It is what customers pay whenever no promo is running — and what they go back to the day a promo ends, automatically.
Saving takes effect immediately — no redeploy.

Launch Promo

A temporary sale. While it runs, customers pay the promo price below and see the regular price crossed out with a % off badge.
🔴 It never touches Customer Markup above. So when the promo ends — or you untick it — prices return to your regular list on their own. Nothing to restore, nothing to remember.

Copies Customer Markup above into the promo column and sets the crossed-out column so cheap items show 50% off, tapering to 35% off on items costing $200+ — the charged price stays your regular price. Press this again whenever you change Customer Markup, then Save Promo.

One row per cost level. Promo markup is what customers actually pay while the sale runs. Crossed-out markup is the higher number shown with a line through it — it is never charged, and must be above the promo markup or the badge would show a negative saving.

Change Password

Two-Factor Authentication

Adds a 6-digit code from your phone on top of your password. Strongly recommended.