Orders

Load the BackerKit shipping export, pick the Service Guids for this batch, then generate the warehouse packing list and the YunExpress import sheet.

1. BackerKit export

Drop the Shipping Address export here.xlsx or .csv · one column per item

Skip hidden rows No export loaded

2. Service Guids to ship

or drop a filter sheet (column "Service Guid")

Group identical packages

Only selected

	Guid	Backer	Country	Method	Items	Declared	Problems

SKU map

One row per BackerKit item column. The warehouse name goes on the packing list; the YunExpress SKU and declaration fields go on the import sheet. Items are combined into one declaration line only when they share a Merge group.

Import sheet

BackerKit column	Warehouse name	Unit	Pack	Declare	Insure	Battery	Merge group	YunExpress SKU	Declared name	Declared name (CN)	FOB $	Unit kg	HS code

Merge group: give related items the same group name (e.g. all glow-fob colours) and they are summed into one declaration line, using the declaration fields of the first row in that group that has a YunExpress SKU. Members can leave their own declaration fields empty.

Import accepts your existing "SKU - Shipping" sheet (SKU code, SKU, declared names, FOB, weight) and the two-column warehouse-name sheet; matching rows are updated, new codes are added. Rows greyed out are not present in the loaded export.

Shipping & tax

How each order is routed and labelled on the YunExpress sheet.

Shipping method

Default method code

EU & CH extra service

Highlight EU/CH rows green

Country overrides

Countries	Method code	Extra service

Countries accept ISO codes or names, comma separated. "EU" expands to all EU members.

Tax label

Shown in the review column of the YunExpress sheet, based on the declared total in USD.

Countries	Mode	Rule

Threshold: label "under" when total ≤ threshold, otherwise "over". Bands: "limit:label" pairs, "*" for the rest.

Order & sender

Customer order number suffix Pieces per parcel Parcel weight (kg) Sender email Sender phone

Customer order number = Service Guid + suffix, e.g. 88ZENZSWGS.

Rules

Entries are "COUNTRY:value" separated by commas. A country is an ISO code; "EU" applies to every EU member and an exact country entry wins over it.

Package splitting

Split parcels over the threshold

Thresholds (USD) Elasticity Parcel suffixes

Declared value

Compress declared value against the caps

Cap factor Minimum countries Minimum declared (USD) Tier countries Above last tier (USD) 预估关税 = 0 for

Tiers "min-max:declare" Caps "country:cap:currency" FX to USD "currency:rate" Duty/VAT % "country:duty/vat"

Insurance & signature

Fill 保价服务 / 签名服务

Insurance code Insured amount Signature countries Insured alone ≥ Insured mid ≥ …with order total ≥ Insured low, total ≥ No insured items, sign ≥ No insured items, insure ≥

"Insured" totals come from SKU map rows with Insure ticked.

US mainland method

Override the method code for the US mainland

Island states Method code Battery method code

The battery code applies when any item has Battery ticked in the SKU map.

Unit suffix on packing list

Imperial countries Imperial suffix Metric suffix

Applied only to SKUs with "Unit" ticked in the SKU map.

Settings

Campaign naming, packing-list layout and YunExpress sheet options. Export the configuration to back it up or to start a new campaign from it.

Campaign

Campaign name Packing list file prefix YunExpress file prefix

Files are named prefix + date, e.g. ZEN发货20260901.xlsx.

Configuration

Import config JSON

Packing list layout

Header font (pt) Body font (pt) Notes font (pt) Group ids font (pt) Line height factor Header row height Print scale % Width: Guid Width: Items Width: Remark

YunExpress sheet

Prepend review columns (预估关税 tax label, 实际金额, 申报总价值)

Hide these headers Hide empty columns from