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
Περίληψη
Κάντε κλικ στο Summarize για να δημιουργήσετε μια περίληψη AI αυτής της μεταγραφής.
Συνοψίζοντας...
Ρωτήστε τον Αλ γι' αυτό το σενάριο.
Ρωτήστε οτιδήποτε σχετικά με αυτό το αντίγραφο, το AI θα βρει σχετικές ενότητες και θα απαντήσει.