Suppliers Import

Suppliers Import

Suppliers import

1. How to access

To access the supplier import screen, simply go into menu :

Purchasing >> Suppliers

There, you will find located at the bottom right corner an "Import" button, allowing you to access the Import screen.

2. Process import

From this page you can import a list of suppliers from a CSV file with semi-colon ";" or comma "," separator.

Available fields for import are the following ones :
  • sup_name
  • sup_contact
  • sup_code (mandatory)
  • sup_email
  • sup_website
  • sup_locale
  • sup_notes
  • sup_street1
  • sup_street2
  • sup_postcode
  • sup_city
  • sup_state
  • sup_country
  • sup_telephone
  • sup_fax
  • sup_minimum_of_order
  • sup_carriage_free_amount
  • sup_currency
  • sup_tax_rate
  • sup_shipping_delay
  • sup_shipping_instructions
  • sup_sales_contact
  • sup_accounting_contact
  • sup_aftersale_contact
  • sup_sales_email
  • sup_accounting_email
  • sup_aftersale_email
  • sup_sales_phone
  • sup_accounting_phone
  • sup_aftersale_phone
  • sup_sales_notes
  • sup_accounting_notes
  • sup_aftersale_notes
  • sup_opened_order
  • sup_payment_terms
  • sup_website_id

You can get a model CSV file using the CSV Export fonction.

3. File details


FILE HEADERsup_namesup_codesup_contactsup_emailsup_localesup_is_activesup_notessup_street1sup_street2sup_postcodesup_citysup_statesup_countrysup_telephonesup_faxsup_minimum_of_ordersup_carriage_free_amountsup_currencysup_tax_ratesup_shipping_delaysup_shipping_instructionssup_sales_contactsup_accounting_contactsup_aftersale_contactsup_sales_emailsup_accounting_emailsup_aftersale_emailsup_sales_phonesup_accounting_phonesup_aftersale_phonesup_sales_notessup_accounting_notessup_aftersale_notessup_payment_termssup_supply_delaysup_enable_notification
FORMATTEXTTEXTTEXTTEXTXX_YY0 : Disabled 1 : EnabledTEXTTEXTTEXTTEXTTEXTTEXTXXNUMBERNUMBERNUMBERNUMBERXXX%NUMBER (DAY)TEXTTEXTTEXTTEXTEMAILEMAILEMAILNUMBERNUMBERNUMBERTEXTTEXTTEXTTEXTNUMBER (DAY)0 : Disabled 1 : Enabled
EXAMPLEMy SupplierSUP1John Doejdoe@supplier.frfr_FR1My best supplierSupplier streetSupplier street2605001ParisIle de FranceFR123456789112345679120003000EUR205No delivery on saturdayJohn SalesJohn AccountingJohn Aftersalessales@supplier.comaccounting@supplier.comaftersales@supplier.com12345678912345678913456789Sales NoteAccounting NoteAftersales NoteNet 60101

 Mandatory for creation
 Mandatory for updates

To import a file, click on "Choose a file", then select the file from your computer and finally click on "Import".

Locales code

LanguageLocaleRegion
Afaraa---
aa_DJDjibouti
aa_EREritrea
aa_ETEthiopia
Afrikaansaf---
af_NANamibia
af_ZASouth Africa
Akanak---
ak_GHGhana
Amharicam---
am_ETEthiopia
Arabicar---
ar_AEUnited Arab Emirates
ar_BHBahrain
ar_DZAlgeria
ar_EGEgypt
ar_IQIraq
ar_JOJordan
ar_KWKuwait
ar_LBLebanon
ar_LYLibya
ar_MAMorocco
ar_OMOman
ar_QAQatar
ar_SASaudi Arabia
ar_SDSudan
ar_SYSyria
ar_TNTunisia
ar_YEYemen
Assameseas---
as_INIndia
Azerbaijaniaz---
az_AZAzerbaijan
Belarusianbe---
be_BYBelarus
Bulgarianbg---
bg_BGBulgaria
Bengalibn---
bn_BDBangladesh
bn_INIndia
Tibetanbo---
bo_CNChina
bn_INIndia
Bosnianbs---
bs_BABosnia and Herzegovina
Blinbyn---
byn_EREritrea
Catalanca---
ca_ESSpain
Atsamcch---
cch_NGNigeria
Copticcop---
Czechcs---
cs_CZCzech Republic
Welshcy---
cy_GBUnited Kingdom
Danishda---
da_DKDenmark
Germande---
de_ATAustria
de_BEBelgium
de_CHSwitzerland
de_DEGermany
de_LILiechtenstein
de_LULuxembourg
Divehidv---
dv_MVMaldives
Dzongkhadz---
dz_BTBhutan
Eweee---
ee_GHGhana
ee_TGTogo
Greekel---
el_CYCyprus
el_GRGreece
Englishen---
en_ASAmerican Samoa
en_AUAustralia
en_BEBelgium
en_BWBotswana
en_BZBelize
en_CACanada
en_GBUnited Kingdom
en_GUGuam
en_HKHong Kong
en_IEIreland
en_INIndia
en_JMJamaica
en_MHMarshall Islands
en_MPNorthern Mariana Islands
en_MTMalta
en_NANamibia
en_NZNew Zealand
en_PHPhilippines
en_PKPakistan
en_SGSingapore
en_TTTrinidad and Tobago
en_UMUnited States Minor Outlying Islands
en_USUnited States
en_VIU.S. Virgin Islands
en_ZASouth Africa
en_ZWZimbabwe
Esperantoeo---
Spanishes---
es_ARArgentina
es_BOBolivia
es_CLChile
es_COColombia
es_CRCosta Rica
es_DODominican Republic
es_ECEcuador
es_ESSpain
es_GTGuatemala
es_HNHonduras
es_MXMexico
es_NINicaragua
es_PAPanama
es_PEPeru
es_PRPuerto Rico
es_PYParaguay
es_SVEl Salvador
es_USUnited States
es_UYUruguay
es_VEVenezuela
Estonianet---
et_EEEstonia
Basqueeu---
eu_ESSpain
Persianfa---
fa_AFAfghanistan
fa_IRIran
Finnishfi---
fi_FIFinland
Filipinofil---
fil_PHPhilippines
Faroesefo---
fo_FOFaroe Islands
Frenchfr---
fr_BEBelgium
fr_CACanada
fr_CHSwitzerland
fr_FRFrance
fr_LULuxembourg
fr_MCMonaco
fr_SNSenegal
Friulianfur---
fur_ITItaly
Irishga---
ga_IEIreland
Gagaa---
gaa_GHGhana
Geezgez---
gez_EREritrea
gez_ETEthiopia
Gallegangl---
gl_ESSpain
Swiss Germangsw---
gsw_CHSwiss
Gujaratigu---
gu_INIndia
Manxgv---
gv_GBUnited Kingdom
Hausaha---
ha_GHGhana
ha_NENiger
ha_NGNigeria
ha_SDSudan
Hawaiianhaw---
haw_USUnited States
Hebrewhe---
he_ILIsrael
Hindihi---
hi_INIndia
Croatianhr---
hr_HRCroatia
Hungarianhu---
hu_HUHungary
Armenianhy---
Interlinguaia---
Indonesianid---
id_IDIndonesia
Igboig---
ig_NGNigeria
Sichuan Yiii---
ii_CNChina
Indonesianin---
Icelandicis---
is_ISIceland
Italianit---
it_CHSwitzerland
it_ITItaly
Inuktitutiu---
Hebrewiw---
Japaneseja---
ja_JPJapan
Georgianka---
ka_GEGeorgia
Jjukaj---
kaj_NGNigeria
Kambakam---
kam_KEKenya
Tyapkcg---
kcg_NGNigeria
Korokfo---
kfo_CIIvory Coast
Kazakhkk---
kk_KZKazakhstan
Kalaallisutkl---
kl_GLGreenland
Khmerkm---
km_KHCambodia
Kannadakn---
kn_INIndia
Koreanko---
ko_KRSouth Korea
Konkanikok---
kok_INIndia
Kpellekpe---
kpe_GNGuinea
kpe_LRLiberia
Kurdishku---
ku_IQIraq
ku_IRIran
ku_SYSyria
ku_TRTurkey
Cornishkw---
kw_GBUnited Kingdom
Kirghizky---
ky_KGKyrgyzstan
Lingalaln---
ln_CDCongo - Kinshasa
ln_CGCongo - Brazzaville
Laolo---
lo_LALaos
Lithuanianlt---
lt_LTLithuania
Latvianlv---
lv_LVLatvia
Macedonianmk---
mk_MKMacedonia
Malayalamml---
ml_INIndia
Mongolianmn---
mn_CNChina
mn_MNMongolia
Romanianmo---
Marathimr---
mr_INIndia
Malayms---
ms_BNBrunei
ms_MYMalaysia
Maltesemt---
mt_MTMalta
Burmesemy---
my_MMMyanmar
Norwegian Bokmalnb---
nb_NONorway
Low Germannds---
nds_DEGermany
Nepaline---
ne_INIndia
ne_NPNepal
Dutchnl---
nl_BEBelgium
nl_NLNetherlands
Norwegian Nynorsknn---
nn_NONorway
Norwegianno---
South Ndebelenr---
nr_ZASouth Africa
Northern Sothonso---
nso_ZASouth Africa
Nyanjany---
ny_MWMalawi
Occitanoc---
oc_FRFrance
Oromoom---
om_ETEthiopia
om_KEKenya
Oriyaor---
or_INIndia
Punjabipa---
pa_INIndia
pa_PKPakistan
Polishpl---
pl_PLPoland
Pashtops---
ps_AFAfghanistan
Portuguesept---
pt_BRBrazil
pt_PTPortugal
Romanianro---
ro_MDMoldova
ro_RORomania
Russianru---
ru_RURussia
ru_UAUkraine
Kinyarwandarw---
rw_RWRwanda
Sanskritsa---
sa_INIndia
Northern Samise---
se_FIFinland
se_NONorway
Serbo-Croatiansh---
sh_BABosnia and Herzegovina
sh_CSSerbia and Montenegro
sh_YUSerbia
Sinhalasi---
si_LKSri Lanka
Sidamosid---
sid_ETEthiopia
Slovaksk---
sk_SKSlovakia
Sloveniansl---
sl_SISlovenia
Somaliso---
so_DJDjibouti
so_ETEthiopia
so_KEKenya
so_SOSomalia
Albaniansq---
sq_ALAlbania
Serbiansr---
sr_BABosnia and Herzegovina
sr_CSSerbia and Montenegro
sr_MEMontenegro
sr_RSSerbia
sr_YUSerbia
Swatiss---
ss_SZSwaziland
ss_ZASouth Africa
Southern Sothost---
st_LSLesotho
st_ZASouth Africa
Swedishsv---
sv_FIFinland
sv_SESweden
Swahilisw---
sw_KEKenya
sw_TZTanzania
Syriacsyr---
syr_SYSyria
Tamilta---
ta_INIndia
Telugute---
te_INIndia
Tajiktg---
tg_TJTajikistan
Thaith---
th_THThailand
Tigrinyati---
ti_EREritrea
ti_ETEthiopia
Tigretig---
tig_EREritrea
Tagalogtl---
Tswanatn---
tn_ZASouth Africa
Tongato---
to_TOTonga
Turkishtr---
tr_TRTurkey
Tarokotrv---
trv_TWTaiwan
Tsongats---
ts_ZASouth Africa
Tatartt---
tt_RURussia
Uighurug---
ug_CNChina
Ukrainianuk---
uk_UAUkraine
Urduur---
ur_INIndia
ur_PKPakistan
Uzbekuz---
uz_AFAfghanistan
uz_UZUzbekistan
Vendave---
ve_ZASouth Africa
Vietnamesevi---
vi_VNVietnam
Walamowal---
wal_ETEthiopia
Wolofwo---
wo_SNSenegal
Xhosaxh---
xh_ZASouth Africa
Yorubayo---
yo_NGNigeria
Chinesezh---
zh_CNChina
zh_HKHong Kong
zh_MOMacau
zh_SGSingapore
zh_TWTaiwan
Zuluzu---
zu_ZASouth Africa

    Unlock your online store's potential

    Whatever your e-commerce business, discover how to streamline your operations and boost your business growth with Boostmyshop.