15
Apr 15, 2026 06:21
· 25:42
· English
· Whisper Turbo
· 2 ลำโพง
ใบรับรองนี้หมดอายุในวันนี้
ปรับปรุงสำหรับเก็บข้อมูลถาวร →
แสดงเฉพาะ
0:00
S…
Speaker 1 (15)
version we have the free ones okay okay yeah sure so i mean then i guess uh probably probably the
0:12
S…
Speaker 1 (15)
google translate more suitable google translate can do excel yeah so we will just translate those
0:21
S…
Speaker 1 (15)
and from english to french english to french french okay okay that's done and then we have
0:34
S…
Speaker 1 (15)
the um translations of the specs and the contents the key setting points okay yes uh looks quite okay
0:52
S…
Speaker 1 (15)
like the um yeah also the setting points so this part uh this part this part so we will
1:08
S…
Speaker 1 (15)
so you will ask the country to check it first okay so uh of course if you for example you guys know
1:16
S…
Speaker 1 (15)
french so maybe you can already have a look but otherwise you will for example you will
1:25
S…
Speaker 1 (15)
just ask the country to check um either you have a cell or somewhere you have a flow
1:33
S…
Speaker 1 (15)
and then um for example you mark uh yellow and the country after the check they put it in green
1:45
S…
Speaker 1 (15)
and you know that okay that is done you are ready to go to the next step okay let's say the country
1:52
S…
Speaker 1 (15)
already check next step next step we are using the excel vba um so we have written a code which is also
2:05
S…
Speaker 1 (15)
from ai that is a developer and a visual basic if you don't have developer i think you just need to
2:16
S…
Speaker 1 (15)
select it customize the ribbon and there is a developer here it will appear then you will open the visual basic
2:31
S…
Speaker 1 (15)
and then you will insert a module and then we give you a code this is the code
2:48
S…
Speaker 1 (15)
and then you just save it okay once you have the code you can uh uh you can just active you can just
3:05
S…
Speaker 2 (15)
activate it you just press i think save it okay once you have it you will run it you uh where is the run
3:51
S…
Speaker 2 (15)
button is okay i'll use another file example yeah once you have the code you should see like this
4:13
S…
Speaker 2 (15)
you will see the the macros yeah like convert to html then you press run it will it will then generate
4:53
S…
Speaker 1 (15)
the html here so they will combine all the columns of these into
5:00
S…
Speaker 1 (15)
html here with the format we want yeah so then you can double check the html
5:09
S…
Speaker 1 (15)
with some html viewer or inside of a journal directly and you will see okay that looks
5:19
S…
Speaker 1 (15)
that looks okay that looks no problem then you can copy this to the bulk upload file
5:29
S…
Speaker 1 (15)
the bulk upload file yeah you remember here uh you have the store view and everything name
5:40
S…
Speaker 1 (15)
and there's your description let's say if you if you are doing this 10 product this week
5:46
S…
Speaker 1 (15)
and you have this you can copy paste here and then upload or of course you can use xlookup
5:58
S…
Speaker 1 (15)
for the for the part numbers and then the um and then um and uh get the html for it for example
6:14
S…
Speaker 1 (15)
this is here and your html is here yeah then you get the html okay you save this and you upload this
6:32
S…
Speaker 1 (15)
and you are done for the this week so this week's for french uh for france 10 product this week
6:42
S…
Speaker 1 (15)
okay yeah let me go through again so you will uh you will get this sheet where you have we upload we
6:56
S…
Speaker 1 (15)
update the road data every week uh and then we will also add the product summary every week outside
7:07
S…
Speaker 1 (15)
either from outside or if we are busy we ask your help to use the prompt to to check if you are doing
7:13
S…
Speaker 1 (15)
from your side you will mark let's say yellow and we will check you will tell us and we go check okay
7:21
S…
Speaker 1 (15)
this english looks good okay yeah then you then we remark green then you know you will proceed to the
7:28
S…
Speaker 1 (15)
next step is next step is to translate you just copy this you copy uh this to to another sheet or
7:41
S…
Speaker 1 (15)
directly upload the whole file to google right maybe maybe you only need to upload the one you need
7:49
S…
Speaker 1 (15)
translate for example only if there's only this full model this week to translate you can just upload
7:56
S…
Speaker 1 (15)
this and translate once you have the translation file um let's say here you have a translation file
8:09
S…
Speaker 1 (15)
then you add the visual basic code to to it so that you can convert to a html
8:19
S…
Speaker 1 (15)
uh visual basic code of course we will share with you the visual basic code so you can yeah but in the
8:36
S…
Speaker 1 (15)
future if you guys um discover some better code of format uh welcome to discuss as well but this is what we
8:45
S…
Speaker 1 (15)
have now okay you have the codes and uh you you close it and now you you can think press f5 or here
9:02
S…
Speaker 1 (15)
press f5 and there is a convert to html and just run it then the html code will be generated here uh you can
9:14
S…
Speaker 1 (15)
then uh do a xlookup or copy paste to the valga blog file but if today there is only one product you can
9:24
S…
Speaker 1 (15)
even you can even directly copy paste in uh magento itself directly for example here you say uh we'll delete all
9:35
S…
Speaker 1 (15)
this so there's all this so there's nothing bases here yeah and then you will show the
9:42
S…
Speaker 1 (15)
that's also one way of course
9:45
S…
Speaker 1 (15)
biocaplo for multiple skills or just
9:48
S…
Speaker 1 (15)
directly copy paste here for one model okay okay yeah so that's the quick overview
9:59
S…
Speaker 1 (15)
um
10:00
S…
Speaker 1 (15)
you some more technical details we can always go over or whenever if you are when you're doing it
10:08
S…
Speaker 1 (15)
you find some question you can let us know and then um but i think that's the overall scope so
10:18
S…
Speaker 1 (15)
now what we need to do is to break down each step and set up sop for when to do what who is doing
10:30
S…
Speaker 1 (15)
what yeah uh between you me or i mean us and also country because every country may may may have
10:41
S…
Speaker 1 (15)
different um every country may have different requirement as well so um we need to set up
10:50
S…
Speaker 1 (15)
the communication flow and then the sop for uh for it okay yes so every i would just say in average
11:03
S…
Speaker 1 (15)
every week probably you will get uh every week it could be ranging from 20 to 50 products probably
11:21
S…
Speaker 1 (15)
to to new products to put online 50. sometimes it's a smaller one this is the notebook it's a
11:30
S…
Speaker 1 (15)
little bit more complicated if it's just accessories accessory is much easier accessory you you actually
11:38
S…
Speaker 1 (15)
no need of the specs so accessories you actually only need the this kind of contents so we have
11:48
S…
Speaker 1 (15)
another html template for accessories that is a bit easier i can explain it another day yeah but in any
11:55
S…
Speaker 1 (15)
cases every week is like 20 to 50 products and then um every week you will have also uh in average once a
12:05
S…
Speaker 1 (15)
month every country may have one campaign that you need your help to add for 50 or 100 products to add the
12:16
S…
Speaker 1 (15)
banners uh let's say who has a banner like this span has a banner like every usually once a month
12:28
S…
Speaker 1 (15)
once a month country will ask you for example they will give you 50 pound number and ask you to add this
12:36
S…
Speaker 1 (15)
to the 50 pound numbers it's also very straightforward is it's um i think like what we already
12:47
S…
Speaker 1 (15)
show i'll just quickly show i'll just quickly give you an example of all span let's say they want you to add
12:57
S…
Speaker 1 (15)
that for 50 products you will um you will first add to one maybe manually and then just copy paste the code for
13:20
S…
Speaker 1 (15)
50. so let's say that is the image so they upload image or something like that or they ask you have to upload
13:34
S…
Speaker 1 (15)
images upload images here uh insert image and you just upload image from whatever they give you
13:44
S…
Speaker 1 (15)
just upload images let's say you upload images and you find it usually in the end you find the images
13:52
S…
Speaker 1 (15)
of their campaign image and then um uh you they may also ask you to write some descriptions for example
14:04
S…
Speaker 1 (15)
this is a spring sale there's an example okay and then the size or something okay you have this one
14:15
S…
Speaker 1 (15)
even the url url going to the spring sale link so you set up one manually like this and then you will get
14:27
S…
Speaker 1 (15)
a html code right here okay here so you say they say okay i want to add the 50 to 50 products then you just
14:38
S…
Speaker 1 (15)
use the bulk upload um here let's say not 50 let's say these uh 10 products oh sorry uh now this is
14:55
S…
Speaker 2 (15)
then you you will
15:00
S…
Speaker 2 (15)
just tell you some ways usually we do but you of course you know your way let's say
15:11
S…
Speaker 2 (15)
these are the original contents without the uh without the banners banner is here these are the
15:21
S…
Speaker 2 (15)
banners uh html so what we do is usually we will i'll just show you this is without without without
15:37
S…
Speaker 1 (15)
banner without banner look like this okay this is without banner right and then the banner is here
15:51
S…
Speaker 2 (15)
banner banner is banner is like this and i will combine it this and then afterward is the content
16:01
S…
Speaker 2 (15)
so then we will have um the banner first and then the contents yeah we can do like this for all the
16:17
S…
Speaker 2 (15)
50 product or 10 20 products yeah so everybody are your banner plus i mean end the contents and this
16:26
S…
Speaker 2 (15)
will be so this will look like um okay and then i will just replace the original descriptions
16:38
S…
Speaker 2 (15)
that's here and i can delete those and i will re-upload the i will upload this part this will
16:45
S…
Speaker 2 (15)
be a banner plus contents yeah so now you see banner plus contents if the banner want to be after
16:55
S…
Speaker 2 (15)
content then it's just other way around you just content and banner so the banner will be below okay
17:04
S…
Speaker 2 (15)
so that's that's usually so yeah every week you may get 20 50 products to put new new contents and then
17:15
S…
Speaker 2 (15)
they maybe they will also add some and then every week you may get a from country saying you as your
17:21
S…
Speaker 2 (15)
help to remove and add the banners of the products okay so that that will be the usual work that look
17:34
S…
Speaker 2 (15)
like for you okay so now we just need to establish this workflow and um yeah so that country can tell you
17:44
S…
Speaker 2 (15)
every week what they need what are the new products you need on show or what are the current product that
17:51
S…
Speaker 2 (15)
what are the new campaign they need to put a banner or a message or block or html block the whole complex
17:58
S…
Speaker 2 (15)
stuff they give you html and then you help them put and after where you help them remove remove is not
18:08
S…
Speaker 2 (15)
mention remove is um in this example we will suggest uh that you will save this file without banner
18:25
S…
Speaker 2 (15)
and after the command finish you just upload this back then it's the original version without banner
18:33
S…
Speaker 2 (15)
instead of instead of um trying to find okay oh this bar is the banner so i will delete this
18:43
S…
Speaker 2 (15)
one by one that will take a bit of time and maybe not so precise you can do that as well but uh
18:51
S…
Speaker 2 (15)
it's or sure there's some other ways but it doesn't always work very well that is a replace for example
19:03
S…
Speaker 1 (15)
we can do like this substitute the old text is this one
19:14
S…
Speaker 1 (15)
oh yeah new text is nothing no sorry not this way uh you can for example you can put the all the the
19:44
S…
Speaker 1 (15)
thing you want to remove here okay i'll put it here to make it easy these are the banner you want to remove
19:54
S…
Speaker 1 (15)
you want to remove and you are substitute
19:57
S…
Speaker 1 (15)
you
19:57
S…
Speaker 1 (15)
you
20:03
S…
Speaker 2 (15)
here the old text is this one the new text is nothing okay so yeah this also they can help you
20:12
S…
Speaker 2 (15)
remove the banner so you see you see here there's no banner in front of it anymore yeah so that's
20:25
S…
Speaker 2 (15)
the one way to remove banners uh but it sometimes may not work just to warn you in advance so that's
20:34
S…
Speaker 2 (15)
why we recommend saving the original descriptions without banners or redo again the original
20:43
S…
Speaker 2 (15)
description by by this this way like the bba whatever and you will get the you get the
20:55
S…
Speaker 2 (15)
stml yeah then you go back then it will be without banner as well either way okay um
21:04
S…
Speaker 2 (15)
um yes that's a quick overview so how would you suggest the next step would be i mean i i could
21:15
S…
Speaker 2 (15)
share all these files with you you can play around sure i just that currently uh you don't have access
21:24
S…
Speaker 2 (15)
to the magento yet so but you can still do uh other try other stuff until until this step that to upload
21:34
S…
Speaker 1 (15)
the file to the gentle i think yeah it would be very interesting for us because uh and useful as
21:43
S…
Speaker 1 (15)
well because the moment we understand and we mastered uh the the fights first because uh it depends on
21:55
S…
Speaker 1 (15)
on them so the moment we will have access we will master to kind of i say everything or
22:04
S…
Speaker 2 (15)
almost everything yes that would be great so um you you tried um check the video there's recording and
22:16
S…
Speaker 2 (15)
if there are questions while you're trying uh let us know um and we will we can resolve and then once
22:25
S…
Speaker 2 (15)
then you can break down and tell us about the step or workflow you want to
22:33
S…
Speaker 2 (15)
establish for example we say okay on monday a country can use this form or this something to tell us
22:43
S…
Speaker 2 (15)
what they what new product they need okay and then we will do this on tuesday or we and then they can they
22:51
S…
Speaker 2 (15)
to confirm the translation on wednesday for example and then thursday it will be uploaded for example
22:59
S…
Speaker 2 (15)
things like that so step by step if you can help come up with the sop communication flow steps and then
23:08
S…
Speaker 2 (15)
uh we can uh we can discuss further about how to um to set up a flow for the countries that would be great
23:21
S…
Speaker 2 (15)
okay yeah okay there's a lot of digest a lot of information but uh i will share the files after the meeting
23:30
S…
Speaker 2 (15)
and yeah and um um and uh let us know uh next week if you have some time to have the next sync yeah
23:47
S…
Speaker 2 (15)
when you have some more proposal of about the flow or the sops then we can discuss the next step
23:55
S…
Speaker 1 (15)
you see uh normally after after this call and the beginning of uh of next week on monday uh we will
24:09
S…
Speaker 1 (15)
review this call first and we will do a kind of uh procedure internal procedure uh we will put there
24:20
S…
Speaker 1 (15)
the way we understand uh everything that you you have just explained and uh i don't know if we can
24:29
S…
Speaker 1 (15)
share that with you uh so that you can validate uh saying something okay uh this is really uh what
24:38
S…
Speaker 1 (15)
i meant and at the same time in the meantime we can as well practice with the the files you will give
24:49
S…
Speaker 2 (15)
after the call i don't know if that makes sense yes yes yes yes so um we can do that totally and i will
24:59
S…
Speaker 1 (15)
share that
25:00
S…
Speaker 2 (15)
files you can practice i'll share all the prompts vba code uh excel sheet about upload sheet
25:09
S…
Speaker 2 (15)
and you could uh try it out if that works on your site or if any questions in between yeah
25:19
S…
Speaker 1 (15)
about uh monday do you still have time for a call a regular call like a conference call
25:27
S…
Speaker 1 (15)
that is like today on monday okay um i don't know the same word yes today or i don't know the monday next
25:42
S…
Speaker 1 (15)
month
ข้อความที่แปลเป็นภาษาอังกฤษนี้ถูกสร้างขึ้นโดย AI (การรับรู้เสียงอัตโนมัติ) อาจมีข้อผิดพลาด - ตรวจสอบกับเสียงต้นฉบับเพื่อใช้อย่างสำคัญ ข้อกำหนด AI
สรุป
คลิกที่ ทำสรุป เพื่อสร้างสรุป AI ของการแปลนี้
ขอสรุป...
ถาม AI เกี่ยวกับการแปลนี้
ถามอะไรก็ได้เกี่ยวกับบทบันทึกนี้ เอไอจะหาส่วนที่เกี่ยวข้องและตอบ