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

    • Related Articles

    • Suppliers list

      Suppliers list 1. How to access The suppliers list is available from menu : Purchasing >> Suppliers 2. Suppliers grid There, you will find a grid that contains all suppliers you have already registered into Connect. This grid displays usefull ...
    • Suppliers Export

      Suppliers export 1. How to access To access the supplier Export function, simply go into menu : Purchasing >> Suppliers There, you will find located at the top left corner an "Export" button, allowing you to export the suppliers grid data. 2. Process ...
    • Import data from Embedded ERP Magento 2

      This article explains how to export suppliers from ERP Magento2 and import them into Connect Suppliers To export suppliers from Magento2, run the following query : select * from bms_supplier Then export this query under CSV format and save it in your ...
    • Import data from Embedded ERP Magento 1

      This article explains how to extract data from Embedded ERP Magento1 and import in Connect. Stock information Stock information includes physical quantity, bin location, warning and ideal stock levels. Export must be done warehouse by warehouse. To ...
    • Order import settings

      For every integrations you can find a specific section to import orders depending of their order status : Menu > Integrations > Manage Integrations > Your integration > Configuration > Order import settings Example ;  Order states There are 2 ...