Ungayingenisa kanjani imikhiqizo ku-PrestaShop

Susana Maria Urbano Mateos

Imizuzu ye-13

Ngenisa imikhiqizo ku-PrestaShop

Njengoba wazi, i-PrestaShop iyithuluzi le-eCommerce elisebenza kahle kakhulu lokukhulisa ukuthengisa futhi lisebenza kahle kakhulu ukulisebenzisa. Kodwa-ke, uma uphatha ikhathalogi enkulu , ukulayisha ngesandla into ngayinye kusuka ehhovisi elingemuva kungaba umsebenzi okhathazayo, ohamba kancane, futhi onamaphutha.

Ukuze kuxazululwe le nkinga, i-PrestaShop inikeza ikhambi elinamandla: ukungenisa imikhiqizo eminingi usebenzisa ifayela le-CSV. Leli thuluzi likuvumela ukuthi uphathe ngokushesha inani elikhulu ledatha, wenze kangcono isikhathi sokuphatha isitolo sakho esiku-inthanethi. Kungakhathaliseki ukuthi uthuthela kwenye ipulatifomu noma uqala ibhizinisi kusukela ekuqaleni, ukwazi inqubo yokungenisa kubalulekile ukuqinisekisa ukuthi uhlu lwakho lwemikhiqizo luphelele, luhlelwe kahle yi-SEO, futhi kulula ukulisebenzisa.

Iyini ifayela le-CSV futhi kungani liyindlela engcono kakhulu ye-PrestaShop?

Ngaphambi kokungena kumhlahlandlela wobuchwepheshe, kubalulekile ukuqonda ukuthi liyini ifayela le -CSV (Comma Separated Values). Liyifomethi yefayela egcina idatha kumbhalo ocacile , lapho umugqa ngamunye umelela irekhodi (esimweni sethu, umkhiqizo) kanti amakholomu ahlukaniswa yisihlukanisi, ngokuvamile i-comma noma i-semicolon.

Ngokungafani nefayela le-Excel .xlsx, i-CSV ilula kakhulu futhi ihambisana kahle nomhlaba wonke, okwenza kube indinganiso efanele yokudlulisa idatha phakathi kwamapulatifomu esofthiwe ahlukene. Izinzuzo zayo eziyinhloko yilezi:

  • lula ukuhlelaIngavulwa futhi iguqulwe ngamathuluzi avamile njenge I-Microsoft Excel, AmaSpredishithi e-Google o I-LibreOffice Calc.
  • isakhiwo esilulaNgokuthembela emigqeni nakumakholomu ahlukanisiwe, kugwema ubunzima befomethi yesipredishithi esinezinambambili.
  • Ukusebenza kahle kokulayisha: Ivumela iseva ye-PrestaShop ukuthi icubungule izinkulungwane zemigqa yedatha ngaphandle kwesidingo sokulayisha isikhombimsebenzisi esinzima sesithombe somkhiqizo ngamunye.

Ukuze ubone lokhu kangcono, cabanga ukuthi umugqa wokuqala wefayela uqukethe izihloko (njenge-ID, Igama, Intengo) kanye nomugqa ngamunye olandelayo ungumkhiqizo ohlukile. Isibonelo:
ID, Nombre, Precio, Cantidad
1, Camiseta Roja, 10.00, 100
2, Zapatos Deportivos, 50.00, 50

Amathiphu abalulekile ngaphambi kokuqala ukungenisa

Ukuze ugweme amaphutha avamile angakuphoqa ukuthi uphinde inqubo noma, okubi nakakhulu, ususe idatha ngephutha, landela lezi zincomo zamasu:

  • Ukudalwa kwesigabaKunconywa kakhulu ukudala izigaba ezidingekayo ehhovisi elingemuva ngaphambi kokuqala Ukungenisa. Nakuba i-PrestaShop ingadala ngokuzenzakalelayo izigaba uma ingazitholi, lezi zizodalwa ezingeni eliyinhloko ngaphandle kokuhlelwa, okuphoqa ukuthi uzihlele kabusha ngesandla kamuva.
  • Ukusetshenziswa kwethempulethi esemthethweniLanda njalo i- ifayela le-CSV eliyisibonelo ngaphambi kokugcwalisa eyakho. Isakhiwo senhlangano singahluka kuye ngenguqulo. Ukuze ubone lokhu, iya ku- Amapharamitha Athuthukisiwe / Ukungenisa bese uchofoza kusixhumanisi ukuze ulande ifayela lemikhiqizo yesampula.
  • gcina ifomethi: Qiniseka ukuthi ulondoloza ifayela ngokuqinile ku- Ifomethi ye-CSVUma uyigcina njengencwadi yokusebenza ejwayelekile ye-Excel, umngenisi ngeke ayibone.
  • Ukusebenza kwesithombeKunconywa ukuthi isithombe ngasinye sibe nesisindo ngaphezu kuka-500 kb futhi zibe nobukhulu obukhulu kune I-70cm x 70cm ukuqinisekisa ikhwalithi yokubonakala. Ngaphezu kwalokho, amagama amafayela kumele abe aqondile. ngaphandle kwezikhala futhi ngesakhiwo .jpg noma .png.
  • Izilingo ezilawulwayo: Ungazami ukulayisha imikhiqizo engu-5,000 ngesikhathi esisodwa okokuqala. Zama ukwethula umkhiqizo owodwa ukuqinisekisa ukuthi ukumaka ikholomu kulungile futhi kulungise noma yimaphi amaphutha okufometha.
  • IsipeleNjalo yenza isipele esiphelele sedatha yakho ngaphambi kokwenza ukungenisa ngobuningi, ikakhulukazi uma uzosebenzisa inketho yokususa imikhiqizo ekhona.

umhlahlandlela wokungenisa imikhiqizo ye-PrestaShop

Umhlahlandlela onemininingwane wokugcwalisa ithempulethi yomkhiqizo we-CSV

Indlela yokuvula nokuphatha ifayela le-CSV

Ukuze sihlele ithempulethi, sizosebenzisa uhlelo lwespredishithi. Uma usebenzisa i-Microsoft Excel , uma uvula ifayela le-.CSV, uhlelo cishe luzobonisa imiyalezo eminingana yesixwayiso mayelana nefomethi yedatha. Ukuze uvimbele i-Excel ekushintsheni isakhiwo, phendula kanje:

  1. Kumyalezo wokuqala, cindezela "Yebo".
  2. Kumyalezo wesibili, cindezela "Cha".
  3. Kumyalezo wokugcina, khetha "Ukwamukela".

Uma usebenzisa i-LibreOffice Calc noma i-Google Sheets , inqubo yokuvula ilula kakhulu, kodwa khumbula njalo ukuqinisekisa ukuthi isihlukanisi sensimu siyahambisana nalokho ozokulungisa kamuva ku-PrestaShop.

Ukuhlaziywa okuphelele kwamakholomu e-CSV

Ithempulethi ye-PrestaShop inamakholomu amaningi. Awudingi ukuwagcwalisa wonke; kuphela lawo ayimpoqo ( amakwe nge-asterisk kuthempulethi esemthethweni) noma anezela inani kucebo lakho lokuthengisa kanye ne-SEO. Ngezansi, sichaza ngayinye:

  • Ikholomu A (ID)Lena inombolo yokuhlonza eyingqayizivele yomkhiqizo. Uma ushiya le kholomu akunaluthoI-PrestaShop izokhiqiza i-ID ngokuzenzakalelayo. Sebenzisa lokhu kuphela uma ufuna ukuphoqa i-ID ethile noma uma ubuyekeza imikhiqizo ekhona.
  • Ikholomu B (Ifa)Lawula ukubonakala. Sebenzisa 1 ngo-YEBO (ebonakalayo) futhi 0 ngo-CHA (kufihliwe).
  • Ikholomu C (Igama Lomkhiqizo): Inkambu edingekayo. Ngokombono we- SEOLeli gama ngokuvamile liba ilebula <title> kwekhasi, ngakho-ke kufanele kube okuchazayo futhi kube negama elingukhiye eliyinhloko.
  • Ikholomu D (Izigaba)Chaza ukuthi umkhiqizo uzovela kuphi. Ungasebenzisa igama lesigaba noma yakhe ID (kunconywa ukugwema amaphutha). Uma umkhiqizo ungowezigaba eziningana, zihlukanise ngekhefana elilodwa (ngaphandle kwezikhalaIsigaba sokuqala esibalwe kuzoba yi- isigaba esikhulu.
  • Ikholomu E (Intengo ngaphandle kwe-VAT): Kubonisa intengo ehlanzekile yento.
  • Ikholomu F (Umthetho Wentela): Nansi ungena ku- I-ID yomthetho wentela kuchazwe ku-Indawo > Imithetho Yezilinganiso.
  • Ikholomu G (Intengo Yokuthengisa Ngobuningi)Ikholomu ongayikhetha yokusetha izindleko zomkhiqizo noma intengo yokuthengisa ngobuningi. Lokhu kuyasiza ohlelweni ukubala izinzuzo zezinzuzo emibikweni yangaphakathi.
  • Ikholomu H (Iyathengiswa): Kubonisa ukuthi umkhiqizo unesaphulelo esisebenzayo (0 = CHA; 1 = YEBO).
  • Ikholomu I (Inani Lesaphulelo): Inani eliqondile lesaphulelo ngohlobo lwemali lwesitolo.
  • Ikholomu J (Iphesenti Lesaphulelo): Amaphesenti azosetshenziswa entengo yokuqala.
  • Amakholomu K no-L (Izinsuku Zesaphulelo)Basungula isikhathi sokusebenza kwephromoshini. Kufanele usebenzise ifomethi I-YYYY-MM-DDUma kungekho usuku, shiya lungenalutho.
  • Ikholomu M (Inkomba)Ikhodi yokubhekisela yangaphakathi. Iyisihlonzi esizimele ku-ID ye-PrestaShop futhi iwusizo kakhulu ekuphathweni kwempahla yokugcina impahla.
  • Ikholomu N (Inkomba Yomhlinzeki): Ikhodi ethile enikezwe umkhiqizo ngumkhiqizi noma umhlinzeki.
  • Amakholomu O no-P (Umhlinzeki kanye nomkhiqizi)Bagcwele I-ID Yomhlinzeki futhi i I-ID YomkhiqiziUma igama lingekho, uhlelo luzokwazi ukudala elisha.
  • Ikholomu Q (EAN-13): Ibhakhodi ejwayelekile enezinombolo ezingu-13. Yiyo kubalulekile ekuthengeni kwe-Google kanye nezinye izimakethe.
  • Ikholomu R (UPC): Ikhodi yebha esetshenziswa kakhulu eNyakatho Melika (izinombolo ezingu-12).
  • Ikholomu S (Izinga Lemvelo)Izintela ezengeziwe ngenxa yomthelela wemvelo (njengentela yezemvelo kwezinye izifunda). Lokhu kungashiywa kungenalutho.
  • Amakholomu ka-T, U, V kanye no-W (Ubukhulu kanye nesisindo)Zibonisa ukuthi Ububanzi (T), Ukuphakama (U), Ukujula (V) kanye nesisindo (W)Kubalulekile ukusebenzisa iyunithi efanayo yokulinganisa (isb., amasentimitha namakhilogremu), njengoba le datha ibalulekile ku- abathwali bala izindleko zokuthumela ngokuzenzakalelayo.
  • Ikholomu X (Ubuningi/Isitoko): Inani lamayunithi atholakalayo. Kuyi- ikholomu edingekayo ukuphatha ukutholakala.
  • Ikholomu Y (Ubuningi obuncane): Inani elincane lamayunithi okumele ikhasimende liwathenge (isb., amabhodlela ewayini athengiswa ngamaphakethe abantu abathathu). Okuzenzakalelayo yi-1.
  • Ikholomu Z: Ngokuvamile ishiywa ingenalutho ngokuzenzakalelayo.
  • Ikholomu AA (Izindleko ezengeziwe zokuthumela): Izindleko ezengeziwe zemikhiqizo emikhulu noma ethambile.
  • Ikholomu AB (Iyunithi Yokuqukethwe): Igama leyunithi (isb. ucezu, ibhodlela, ilitha).
  • Ikholomu ye-AC (Intengo ngeyunithi ngayinye): Intengo yeyunithi uma umkhiqizo uthengiswa njengesethi.
  • Ikholomu AD (Incazelo emfushane)Isifinyezo somkhiqizo esisheshayo. Ivumela ukusetshenziswa kwe Amathegi e-HTML ukufometha (okugqamile, uhlu).
  • Ikholomu AE (Incazelo Enwetshiwe)Imininingwane ephelele yento. Le nsimu ibalulekile ku- Ukubeka i-SEO kanye nokuguqulwa komsebenzisi. Iphinde isekele i-HTML.
  • Ikholomu ye-AF (Amathegi): Amagama angukhiye ahlukaniswe ngamakhoma ukuze kuthuthukiswe usesho lwangaphakathi kanye ne-taxonomy.
  • Amakholomu e-AG, AH kanye ne-AI (Imethadatha): Isihloko se-Meta (AG), amagama angukhiye e-Meta (AH) kanye nencazelo ye-Meta (AI)Incazelo ye-meta yilokho okuvela ku-Google futhi kufanele kube yinto ekholisayo ukuthuthukisa CTRQaphela: I-Google ayisawaniki amandla amagama angukhiye e-meta (AH).
  • Ikholomu AJ (i-URL elula): The I-URL slugI-PrestaShop iyikhiqiza ngokuzenzakalelayo ngokusekelwe egameni, kodwa ungayihlela ngokwezifiso ukuze uthuthukise i-SEO.
  • Ikholomu AK (Umbhalo uyatholakala): Umyalezo ikhasimende eliwubonayo uma kukhona isitoko.
  • Ikholomu AL (Umbhalo uceliwe umisiwe)Umlayezo wemikhiqizo engekho esitokweni kodwa evumela ama-oda.
  • Ikholomu ye-AM (Iyatholakala uma iceliwe): Kubonisa ukuthi umkhiqizo ungathengwa noma ngabe awusekho esitokweni (0 = CHA; 1 = YEBO).
  • Amakholomu AN kanye ne-AO (Izinsuku)Usuku lokutholakala kanye nosuku lokudalwa.
  • Ikholomu ye-AP (Bonisa intengo): Hlola ukuthi intengo iyabonakala yini ohlwini (1 = YEBO; 0 = CHA).
  • Ikholomu AQ (Izithombe)Ama-URL Esithombe. Ungafaka amaningana ahlukaniswe ngamakhoma. Esokuqala kuzoba isithombe esiyinhloko. Ifomethi enconywayo yile ./upload/imagen.jpg uma ulayisha izithombe ngo- FTP kufolda kuseva.
  • Ikholomu ye-AR (Susa Izithombe): Kubonisa ukuthi izithombe zangaphambilini kufanele zisuswe yini ngaphambi kokulayisha ezintsha (0 = CHA; 1 = YEBO).
  • Ikholomu ye-AS (Izici)Izimfanelo ezithile (isb., Umbala: Obomvu, Usayizi: XL). Zihlukaniswa ngamakhoma futhi zidinga ifomethi eyinkimbinkimbi (Igama:Inani:Isikhundla).
  • Ikholomu ye-AT (Ku-inthanethi Kuphela): Kubonisa ukuthi umkhiqizo ungowewebhusayithi kuphela (1 = YEBO).
  • Ikholomu ye-AU (Isimo)Isimo somkhiqizo: "okusha" (okusha), "kusetshenzisiwe" (kusetshenzisiwe) noma kuvuselelwe (kulungisiwe).
  • Ikholomu ye-AV (Ingenziwa Ngokwezifiso)Uma kungu-1, kuzovela ibhokisi lombhalo ukuze ikhasimende lengeze amanothi enziwe ngokwezifiso.
  • Ikholomu AW (Okunamathiselwe): Ikuvumela ukuthi ulayishe amafayela ahlobene nomkhiqizo (amabhukwana e-PDF, njll.).
  • Ikholomu AX (Izinkambu Zombhalo): Inika amandla inketho yokuthi ikhasimende libhale amazwana kurekhodi.
  • Ikholomu AY (Vumela ama-oda aphelelwe yisikhathi)Njengekholomu ye-AM, isebenzisa ukuthengisa kwangaphambi kokuthengiswa noma okwenziwe ukuze ku-odwe.
  • Ikholomu AZ (Isitolo/Umkhiqizo)Kusetshenziswa ezindaweni ze- izitolo eziningi ukwabela umkhiqizo endaweni ethile.

Ukucushwa kwe-PrestaShop CSV

Inqubo yokulondoloza nokulayisha ithempulethi

Indlela yokulondoloza ifayela ngendlela efanele

Uma usufake ulwazi ku-Excel noma ku-LibreOffice, kubalulekile ukulondoloza ifayela ngefomethi efanele. Uma uchofoza isithonjana sokugcina, i-Excel ingase ikhiphe izexwayiso mayelana nokulahlekelwa ezinye izici zokufometha. Ukuze kugcinwe ubuqotho be- Izinga le-CSV, aphendule "Yebo" umyalezo wokuqala futhi "Cha" Owesibili. Ifayela kufanele libe nesandiso .csv.

Izinyathelo zokungenisa ehhovisi elingemuva

Njengoba ifayela selilungile kukhompyutha yakho, siqhubekela ekulayisheni ngobuningi ku-PrestaShop:

  1. Finyelela iphaneli yokuphatha bese uya esigabeni se- Amapharamitha Athuthukisiwe bese uchofoza ukungenisa.
  2. Okwehliswayo "Ufuna ukungenisa ini?", khetha inketho Imikhiqizo.
  3. Layisha ifayela le-.CSV kusuka kukhompyutha yakho usebenzisa inkinobho yokukhetha ifayela.
  4. Ukucushwa kwefayelaLapha kufanele unake kakhulu amaphuzu alandelayo:
    • Ulimi lwefayela: Khetha ulimi lapho ikhathalogi ibhalwe khona (isb., iSpanishi).
    • Ukubhala ikhodi kwe-ISO 8859-1: Ibhrendi "Yebo" Uma ikhathalogi yakho iqukethe izinhlamvu ezikhethekile njenge- «ñ» noma izinhlamvu ezigqanyisiwe, ukuze kugwenywe ukubonakala kwezimpawu ezingavamile.
    • Isihlukanisi sensimu: Kubonisa uhlamvu olusetshenziswa ukuhlukanisa amakholomu. Okuvame kakhulu yi- isemikholoni (;) noma i dla (,)Qiniseka ukuthi ifana ncamashi nesihlukanisi sakho sefayela.
    • Abahlukanisi abanamanani amaningiIsetshenziselwa izinkambu ezifana nezigaba. Ngokuvamile kuyi- dla (,) noma ibha eqondile (|).
    • Susa yonke imikhiqizo ngaphambi kokungenisa: Ukuqapha okukhuluUma ukhetha okuthi "Yebo," ikhathalogi izobe ingenalutho ngokuphelele. Vumela le nketho kuphela uma kuyisitolo esisha noma ufuna ukususa uhlu lwakho lwezinto.
    • Sebenzisa ireferensi njengesihluthuleloUma uvumela le nketho, i-PrestaShop izosebenzisa ireferensi yomkhiqizo njengesihlonzi esiyingqayizivele esikhundleni se-ID.
    • Yeqa ukuvuselelwa kwesithonjanaUma ukhetha le nketho, inqubo yokungenisa izoshesha ngoba uhlelo ngeke ludale ngokuzenzakalelayo osayizi bezithombe abahlukene. Akukhuthazwa ukuvumela le nketho uma ufuna ukuthuthukisa ukusebenza kwewebhusayithi.
    • Phoqelela zonke izinombolo ze-IDMaka okuthi "Yebo" uma ufuna i-PrestaShop ihloniphe ngqo ama-ID kufayela lakho le-CSV (eliwusizo ekubuyekezweni). Uma kuyimikhiqizo emisha, yishiye ingenalutho. "Cha".
  5. Qhafaza Okulandelayo.

Ukumapha kwensimu kanye nokuqedwa kwenqubo

Ngemva kokusetha kokuqala, uzongena esikrinini sokumapha insimu . Yilapho utshela khona uhlelo ukuthi iyiphi ikholomu kufayela lakho le-CSV ehambisana nensimu ngayinye emininingwaneni yomkhiqizo we-PrestaShop. Isibonelo, kufanele unikeze ikholomu "C" ensimini ethi "Igama" kanye nekholomu "X" ensimini ethi "Ubuningi".

Uma ifayela lakho le-CSV linomugqa wama-header (amagama ekholomu), kufanele ufake u-1 ensimini ethi "Imigqa yokweqa" . Ngaphandle kwalokho, i-PrestaShop izozama ukungenisa igama elithi "Igama" njengokungathi igama lomkhiqizo, okudala iphutha.

Uma ukumepha sekuqediwe, chofoza ku- Import CSV data . Kuye ngobuningi bemikhiqizo kanye nenani lezithombe, le nqubo ingathatha imizuzu eminingana. Ungase ube nesikhathi sokuvala (isiphequluli sizobonisa ukuthi ikhasi aliphenduli), kodwa ungakhathazeki: inqubo ivame ukuqhubeka isebenza ngemuva kuseva.

Qedela ukungenisa i-PrestaShop

Ukuxazulula izinkinga ezivamile zokungenisa impahla

Naphezu kokulandela izinyathelo, ngezinye izikhathi inqubo yokungenisa ingahluleka. Lezi yizimbangela ezivame kakhulu kanye nezixazululo zazo:

  • Iphutha LokuhlukanisaIphutha elivame kakhulu livela lapho ifayela lisebenzisa amakhoma kodwa ukucushwa kwe-PrestaShop kucacisa ama-semicolon. Hlola isihlukanisi ukuvula ifayela ngomhleli wombhalo olula (njenge-Notepad).
  • Izithombe ezinkulu noma izindlela ezingalungileUma izithombe zingaveli, hlola ukuthi i-URL ilungile nokuthi ifayela alilikhulu kakhulu. Uma ulayishe izithombe nge-FTP, qiniseka ukuthi izimvume zefolda vumela uhlelo ukuthi lufundwe.
  • Izigaba ezingekhoNakuba i-PrestaShop ingazidala, ngezinye izikhathi ziyahluleka uma kukhona abalingiswa abangajwayelekile. Qiniseka ukuthi izigaba eziyinhloko sezivele zikhona.
  • Ifomethi yefayela engalungile: Iqinisekisa ukuthi ifayela ngempela CSV hhayi ifayela le-Excel eliqanjwe kabusha ngesandla (.xlsx).
  • Izingxabano ze-IDUma uzama ukungenisa umkhiqizo one-ID esivele ikhona futhi ungakayivumeli i-ID ukuthi iphoqelelwe, uhlelo lungase lunikeze iphutha noma luphinde umkhiqizo.

Ukungenisa ngobuningi kuyithuluzi elinamandla, nakuba kungase kubonakale kuyinkimbinkimbi ekuqaleni, elinikeza inzuzo enkulu yokuncintisana ngokwenhlangano kanye nokukhula. Ngokuzenzakalela ukulayishwa kwekhathalogi yakho, awugcini nje ngokusindisa amahora omsebenzi wezandla, kodwa futhi usungula isizindalwazi esihlanzekile nesihlelekile esizokuvumela ukuthi wandise ibhizinisi lakho emhlabeni jikelele futhi ufinyelele amakhasimende amaningi ngokufakwa ohlwini kwemikhiqizo okulungiselelwe kahle nangobungcweti.


Engeza njengomthombo okhethwayo ku-Google