批量上传一般用于大的代理。她们每天有数百个包裹要发货,没有办法一行一列的填写。于是有了批量上传的方法。

https:///www.3bao.co.uk

登陆后,用户中心-》快速下单-》批量下单-》下载批量下单模板

文件名:cartBatchTemplateV2

批量上传只适合经济包,含优先包小包的服务线路。

批量上传一共28列。

前六列:是详细的每个箱子的:

1)装箱内容物content name,海关关税代码tariff code ,原产地country of manufactured,重量unit weight,单价unit price,数量amount。

2)第7列到第28列是填写整个箱子的数据

a) 整个箱子的称重,net weight

b)整个箱子的尺寸,长(length(cm),宽(width (cm),高Heigh(cm)

c)发件人英语地址

d)收件人拼音地址

e)收件人中文地址

f)发件人英国eroi 的号码,GB开始后面跟9位数字,GB123456789

g)Shipment Purpose 可以为:Gift,Sold,Sample,Not Sold, Personal Effects

重点来了,当你同一个箱子里装了其他物品的时候,第2个物品开始之需要填写前六列,后面22列是不需要填写的,请务必留空。

重点二,当你同一个箱子的物品全填写完可以继续填写第二箱子的物品,同理第一行全需要填写。

这样你一次输入成千上百的包裹都能从系统里领出物流单证。

重点三,你所有的运费折扣设定包括纸箱福利都会有的。

现在来观察一下:

Eori number就是GB开头的后面跟着9位数字,GB123456789在cn23表 里显示三处。

Eori number就是GB开头的后面跟着9位数字,GB123456789在commercial invoice 里显示两处。

Tariff code 和 country of manufacure在在cn23表里 显示2处。

Tariff code 和 country of manufacure在在commercial invoice 里显示。

sold 在在commercial invoice 里显示一处。

sold 在在cn23 里显示两处。

重要提示:

到那里查原产地国家代码?

Country of Manufacture

每个国家用两个字母表示,

请查这里https://laendercode.net/en/2-letter-list.html

ISO 3166 ALPHA-2COUNTRY
AFAfghanistan
AXAland Islands
ALAlbania
DZAlgeria
ASAmerican Samoa
ADAndorra
AOAngola
AIAnguilla
AQAntarctica
AGAntigua and Barbuda
ARArgentina
AMArmenia
AWAruba
AUAustralia
ATAustria
AZAzerbaijan
BSBahamas
BHBahrain
BDBangladesh
BBBarbados
BYBelarus
BEBelgium
BZBelize
BJBenin
BMBermuda
BTBhutan
BOBolivia
BQBonaire, Saint Eustatius and Saba
BABosnia and Herzegovina
BWBotswana
BVBouvet Island
BRBrazil
IOBritish Indian Ocean Territory
VGBritish Virgin Islands
BNBrunei
BGBulgaria
BFBurkina Faso
BIBurundi
KHCambodia
CMCameroon
CACanada
CVCape Verde
KYCayman Islands
CFCentral African Republic
TDChad
CLChile
CNChina
CXChristmas Island
CCCocos Islands
COColombia
KMComoros
CKCook Islands
CRCosta Rica
HRCroatia
CUCuba
CWCuracao
CYCyprus
CZCzech Republic
CDDemocratic Republic of the Congo
DKDenmark
DJDjibouti
DMDominica
DODominican Republic
TLEast Timor
ECEcuador
EGEgypt
SVEl Salvador
GQEquatorial Guinea
EREritrea
EEEstonia
ETEthiopia
FKFalkland Islands
FOFaroe Islands
FJFiji
FIFinland
FRFrance
GFFrench Guiana
PFFrench Polynesia
TFFrench Southern Territories
GAGabon
GMGambia
GEGeorgia
DEGermany
GHGhana
GIGibraltar
GRGreece
GLGreenland
GDGrenada
GPGuadeloupe
GUGuam
GTGuatemala
GGGuernsey
GNGuinea
GWGuinea-Bissau
GYGuyana
HTHaiti
HMHeard Island and McDonald Islands
HNHonduras
HKHong Kong
HUHungary
ISIceland
INIndia
IDIndonesia
IRIran
IQIraq
IEIreland
IMIsle of Man
ILIsrael
ITItaly
CIIvory Coast
JMJamaica
JPJapan
JEJersey
JOJordan
KZKazakhstan
KEKenya
KIKiribati
XKKosovo
KWKuwait
KGKyrgyzstan
LALaos
LVLatvia
LBLebanon
LSLesotho
LRLiberia
LYLibya
LILiechtenstein
LTLithuania
LULuxembourg
MOMacao
MKMacedonia
MGMadagascar
MWMalawi
MYMalaysia
MVMaldives
MLMali
MTMalta
MHMarshall Islands
MQMartinique
MRMauritania
MUMauritius
YTMayotte
MXMexico
FMMicronesia
MDMoldova
MCMonaco
MNMongolia
MEMontenegro
MSMontserrat
MAMorocco
MZMozambique
MMMyanmar
NANamibia
NRNauru
NPNepal
NLNetherlands
ANNetherlands Antilles
NCNew Caledonia
NZNew Zealand
NINicaragua
NENiger
NGNigeria
NUNiue
NFNorfolk Island
KPNorth Korea
MPNorthern Mariana Islands
NONorway
OMOman
PKPakistan
PWPalau
PSPalestinian Territory
PAPanama
PGPapua New Guinea
PYParaguay
PEPeru
PHPhilippines
PNPitcairn
PLPoland
PTPortugal
PRPuerto Rico
QAQatar
CGRepublic of the Congo
REReunion
RORomania
RURussia
RWRwanda
BLSaint Barthelemy
SHSaint Helena
KNSaint Kitts and Nevis
LCSaint Lucia
MFSaint Martin
PMSaint Pierre and Miquelon
VCSaint Vincent and the Grenadines
WSSamoa
SMSan Marino
STSao Tome and Principe
SASaudi Arabia
SNSenegal
RSSerbia
CSSerbia and Montenegro
SCSeychelles
SLSierra Leone
SGSingapore
SXSint Maarten
SKSlovakia
SISlovenia
SBSolomon Islands
SOSomalia
ZASouth Africa
GSSouth Georgia and the South Sandwich Islands
KRSouth Korea
SSSouth Sudan
ESSpain
LKSri Lanka
SDSudan
SRSuriname
SJSvalbard and Jan Mayen
SZSwaziland
SESweden
CHSwitzerland
SYSyria
TWTaiwan
TJTajikistan
TZTanzania
THThailand
TGTogo
TKTokelau
TOTonga
TTTrinidad and Tobago
TNTunisia
TRTurkey
TMTurkmenistan
TCTurks and Caicos Islands
TVTuvalu
VIU.S. Virgin Islands
UGUganda
UAUkraine
AEUnited Arab Emirates
GBUnited Kingdom
USUnited States
UMUnited States Minor Outlying Islands
UYUruguay
UZUzbekistan
VUVanuatu
VAVatican
VEVenezuela
VNVietnam
WFWallis and Futuna
EHWestern Sahara
YEYemen
ZMZambia
ZWZimbabwe

Tariff Code

到那里查Tariff code?

也可以从parcelforce 查海关代码Tarriff code

https://www.parcelforce.com/tariffcode

更多的请移步英国税务局的网站

https://www.gov.uk/trade-tariff

Comments are closed, but trackbacks and pingbacks are open.