menu

Help : BACKOFFICE : Import/Export : Customer Table

Video

  • 60+ videos dealing with more complex topics are available for free on YouTube

Help : BACKOFFICE : Import/Export : Customer Table

  • For help, scroll through the below BackOffice topics and then click on desired topic, or click here

Help : BACKOFFICE : Import/Export : Customer Table

  • AttributeTypeDescription
    email[7, 64] CharCustomer Email Address
    Example: zeta@yourshop.com
    pwd[6, 32] CharCustomer Password
    Notes:
    1)Passwords cannot be exported, only imported
    2)During import, passwords are encrypted
    Example: R5&gL8v-Mo
    idPositive IntCustomer Identity
    Example: 93547
    nos[0, 2^32] IntNumber of Sales
    Note: Number of Sales can only be exported
    lang[en, de, fr, it, ru]Customer Language
    Example: en
    state[0, 3] IntCustomer State
    0means guest, can only be exported
    1means standard
    2means blocked
    3means customer not vat registered
    Example: 1
    nthPositive IntClient's NTH Address
    During customer import, state which address is to be modified
    nth = 1means 1st address
    nth = 2means 2nd address
    nth = 3means 3rd address
    ...
    Example: 2
    billing[0, 2] IntCustomer Billing Address
    0means delivery address
    1means delivery and billing address
    2means billing address
    Example: 1
    htc[0, 2^32] IntHow To Charge
    YourShop provides several delivery payment plans
    One of the plans is as many times as ... or the maximum number
    Htc is the number of times the customer must pay for the most expensive delivery service of the purchase
    Example: 3
    wrVarcharWrite a Review
    Write a Review can only be exported
    Write a Review contains a summary of reviews a customer has written
    The wr record #:#:#:#:#:#:#:# consists of 8 numbers which are separated by a colon:
    1st #means average
    2nd #means number of 1 star reviews
    3rd #means number of 2 stars reviews
    4th #means number of 3 stars reviews
    5th #means number of 4 stars reviews
    6th #means number of 5 stars reviews
    7th #means number of reviews
    8th #means number of comments
    Example: 4.6:0:0:1:0:4:5:2
    paymethVarcharPayment Methods
    If for selected customers only payment methods are specified in [TOOLS] -> [Payment Methods], the customer can only use them, if they are colon separated as stated in paymeth i.e. #:#:#
    Including additional payment methods adds them to the list of the default payment methods
    Example: 100 that is the customer can also pay per invoice within 45 days
    Prepending a hyphen - excludes all other payment methods
    Example: -8:-100 that is the customer can only pay by Credit Card or invoice within 45 days
    deliservVarcharDelivery Services
    If for selected customers only delivery services are specified in [TOOLS] -> [Delivery Services], the customer can only use them, if they are colon separated as stated in deliserv
    Including additional delivery services adds them to the list of the default delivery services
    Example: 33 that is the customer can also have the purchase delivered by Helicopter
    Prepending a hyphen - excludes all other delivery services
    Example: -33:-66 that is the customer can only have the purchase delivered by Helicopter or Speedboat
    beinformed[0, 1] IntBe Informed
    You can in [TOOLS] -> [Checkout behaviour] specify whether be informed is asked or not:
    0means not be informed i.e. customer does not receive marketing emails
    1means be informed
    Example: 1
    company[0, 128] CharCompany Name
    You can in [TOOLS] -> [Client details] specify whether company is asked at all, optional or compulsory
    Example: YourShop SA
    department[0, 48] CharDepartment
    You can in [TOOLS] -> [Client details] specify whether department is asked at all, optional or compulsory
    Example: Accounting
    gender-1, 1, 2 IntGender Identity
    You can in [TOOLS] -> [Client details] specify whether gender identity is Asked at all, optional or compulsory:
    -1means not specified
    1means male
    2means female
    Example: 2
    birthdateYYYY-MM-DDBirthdate
    You can in [TOOLS] -> [Client details] specify whether birthdate is asked at all, optional or compulsory
    Example: 1964-05-07
    lname[0, 48] CharLast Name
    Note: If company name is provided, last name can be left blank
    Example: Eichenberger
    fname[0, 48] CharFirst Name
    Note: If company name is provided, first name can be left blank
    Example: Zeta
    address1[1, 128] CharAddress 1
    Example: Chemin de la Cure 2A
    address2[0, 128] CharAddress 2
    You can in [TOOLS] -> [Client details] specify whether address2 is asked at all, optional or compulsory
    Example: 2nd floor
    zip[2, 24] CharPostcode
    Example: 1000
    city[1, 48] CharCity
    Example: Lausanne
    province[-1, 26] IntProvince
    You can in [TOOLS] -> [Client details] specify whether province is asked at all, optional or compulsory
    By default, the provinces are specified as:
    0##Outside Switzerland
    1AGAargau
    2AIAppenzell Innerrhoden
    3ARAppenzell Ausserrhoden
    4BEBern
    5BLBasel-Landschaft
    6BSBasel-Stadt
    7FRFreiburg
    8GEGenf
    9GLGlarus
    10GRGraubünden
    11JUJura
    12LULuzern
    13NENeuenburg
    14NWNidwalden
    15OWObwalden
    16SGSt. Gallen
    17SHSchaffhausen
    18SOSolothurn
    19SZSchwyz
    20TGThurgau
    21TITessin
    22URUri
    23VDWaadt
    24VSWallis
    25ZGZug
    26ZHZürich
    Example: 11 that is Jura
    Example: -1 that is province is not provided
    country[4, 894] IntCountry Code
    The countries are specified in ISO 3166 country code as:
    4AFAfghanistan
    8ALAlbania
    12DZAlgeria
    16ASAmerican Samoa
    20ADAndorra
    24AOAngola
    28AGAntigua and Barbuda
    31AZAzerbaijan
    32ARArgentina
    36AUAustralia
    40ATAustria
    44BSBahamas
    48BHBahrain
    50BDBangladesh
    51AMArmenia
    52BBBarbados
    56BEBelgium
    60BMBermuda
    64BTBhutan
    68BOBolivia
    70BABosnia and Herzegovina
    72BWBotswana
    76BRBrazil
    84BZBelize
    90SBSolomon Islands
    96BNBrunei Darussalam
    100BGBulgaria
    104MMMyanmar
    108BIBurundi
    112BYBelarus
    116KHCambodia
    120CMCameroon
    124CACanada
    132CVCabo Verde
    136KYCayman Islands
    140CFCentral African Republic
    144LKSri Lanka
    148TDChad
    152CLChile
    156CNChina
    158TWTaiwan
    162CXChristmas Island
    170COColombia
    174KMComoros
    175YTMayotte
    178CGDR Congo
    180CDCongo, Democratic Republic (Zaire)
    184CKCook Islands
    188CRCosta Rica
    191HRCroatia
    192CUCuba
    196CYCyprus
    203CZCzechia
    204BJBenin
    208DKDenmark
    212DMDominica
    214DODominican Republic
    218ECEcuador
    222SVEl Salvador
    226GQEquatorial Guinea
    231ETEthiopia
    232EREritrea
    233EEEstonia
    234FOFaroe Islands
    238FKFalkland Islands
    239GSS. Georgia and S. Sandwich Isls.
    242FJFiji
    246FIFinland
    250FRFrance
    254GFFrench Guiana
    258PFFrench Polynesia
    262DJDjibouti
    266GAGabon
    268GEGeorgia
    270GMGambia
    276DEGermany
    288GHGhana
    292GIGibraltar
    296KIKiribati
    300GRGreece
    304GLGreenland
    308GDGrenada
    312GPGuadeloupe
    320GTGuatemala
    324GNGuinea
    328GYGuyana
    332HTHaiti
    336VAVatican City
    340HNHonduras
    344HKHong Kong
    348HUHungary
    352ISIceland
    356INIndia
    360IDIndonesia
    364IRIran
    368IQIraq
    372IEIreland
    376ILIsrael
    380ITItaly
    384CICote D'Ivoire
    388JMJamaica
    392JPJapan
    398KZKazakhstan
    400JOJordan
    404KEKenya
    408KPNorth Korea
    410KRSouth Korea
    414KWKuwait
    418LALaos
    422LBLebanon
    426LSLesotho
    430LRLiberia
    434LYLibya
    438LILiechtenstein
    440LTLithuania
    442LULuxembourg
    446MOMacau
    450MGMadagascar
    454MWMalawi
    458MYMalaysia
    462MVMaldives
    466MLMali
    470MTMalta
    474MQMartinique
    478MRMauritania
    480MUMauritius
    484MXMexico
    492MCMonaco
    496MNMongolia
    498MDMoldova
    500MSMontserrat
    504MAMorocco
    508MZMozambique
    512OMOman
    516NANamibia
    520NRNauru
    524NPNepal
    528NLNetherlands
    533AWAruba
    540NCNew Caledonia
    548VUVanuatu
    554NZNew Zealand (Aotearoa)
    558NINicaragua
    562NENiger
    566NGNigeria
    574NFNorfolk Island
    578NONorway
    586PKPakistan
    591PAPanama
    598PGPapua New Guinea
    600PYParaguay
    604PEPeru
    608PHPhilippines
    612PNPitcairn
    616PLPoland
    620PTPortugal
    624GWGuinea-Bissau
    634QAQatar
    642RORomania
    643RURussian Federation
    646RWRwanda
    654SHSt. Helena
    659KNSaint Kitts and Nevis
    660AIAnguilla
    662LCSaint Lucia
    666PMSt. Pierre and Miquelon
    670VCSaint Vincent and the Grenadines
    674SMSan Marino
    682SASaudi Arabia
    686SNSenegal
    690SCSeychelles
    694SLSierra Leone
    702SGSingapore
    703SKSlovakia
    704VNVietnam
    705SISlovenia
    706SOSomalia
    710ZASouth Africa
    716ZWZimbabwe
    724ESSpain
    729SDSudan
    740SRSuriname
    748SZSwaziland
    752SESweden
    756CHSwitzerland
    760SYSyria
    762TJTajikistan
    764THThailand
    768TGTogo
    776TOTonga
    780TTTrinidad and Tobago
    784AEUnited Arab Emirates
    788TNTunisia
    792TRTurkiye
    795TMTurkmenistan
    796TCTurks and Caicos Islands
    798TVTuvalu
    800UGUganda
    804UAUkraine
    818EGEgypt
    826GBUnited Kingdom
    834TZTanzania
    840USUnited States
    854BFBurkina Faso
    858UYUruguay
    860UZUzbekistan
    862VEVenezuela
    876WFWallis and Futuna Islands
    882WSSamoa
    894ZMZambia
    Example: 756 that is Switzerland
    tel[5, 24] CharTelephone Number
    You can in [TOOLS] -> [Client details] specify whether tel is asked at all, optional or compulsory
    Depending on whether the online shop is specified international or national, the telephone number must be either preceded by a + sign or the number 0
    Example: +41 21 67 17 111 that is International Swiss Telephone Number
    Example: 021 67 17 111 that is National Swiss Telephone Number
    fax[5, 24] CharFacsimile Number
    You can in [TOOLS] -> [Client details] specify whether fax is asked at all, optional or compulsory
    Depending on whether the online shop is specified international or national, the facsimile number must be either preceded by a + sign or the number 0
    Example: +41 21 67 17 112 that is International Swiss Facsimile Number
    Example: 021 67 17 112 that is National Swiss Facsimile Number

Support

  • If you cannot find an answer to your query in the YourShop videos or in the YourShop help guides, contact us by phone on +41 21 67 17 111 or by email
Support

Tech News

  • Follow the developments of YourShop on X or on our News page.
Tech News

Become a YourShop fan

Become a YourShop fan
Speed Sells Choose an offer
X
 X