Latest / Inside Commerce: Ecommerce Strategy, CX and Technology Podcast / EP142: Data Migration For Ecommerce Projects - Lessons Learned & Key Considerations
Transcript
- 0:02Thanks for tuning into the re-platform podcast, spots find
- 0:05a clean. Sweep Levi, are you listening to
- 0:06myself? James, go ahead and my co-host.
- 0:08Paul Rogers. Hey there buddy.
- 0:10Yeah, good. Thanks but tired and it's Monday
- 0:13morning but yeah, pretty good overall.
- 0:15I really should tell people why your toe there is a there is a
- 0:18reason. What did you do yesterday?
- 0:19Yeah, yeah Road from London to Brighton where of no preparation
- 0:24and pretty bad for insurance. So yeah, pretty pretty tired.
- 0:28After that. All the top part Fleets do don't
- 0:30prepare and make sure they cycle in just so you've done well
- 0:33mate. Hello to everyone who's chicken
- 0:39back in and a warm welcome. If this is your first time,
- 0:42listen to podcasts, where P enjoy it.
- 0:44Do subscribe to get new episode alerts and we'd love a like on
- 0:47YouTube Spotify. Apple thank you very much.
- 0:49So today's topic is data, migration.
- 0:53Some key do's and don'ts it data.
- 0:55Migration is an essential part of all new site, builds or
- 0:59migrations from one site to new another one.
- 1:02However, it's not always. Just focus on after and
- 1:05Discovery and that can result in a lack of detailed statements of
- 1:08work. I've seen statements of work
- 1:09where she literally had a one-line saying data will be
- 1:12migrated to the new solution which is not good enough.
- 1:14Because what data, how much who's do when etcetera?
- 1:18And that causes for the problems further down the line and a good
- 1:21example is, I've been in a project where data migration was
- 1:25not specced out clearly enough and then it gets the point where
- 1:29there isn't enough time or the data is not in the fitness, take
- 1:32to get it. Clean enough ready for the Data
- 1:34needs to be imported into the new solution which then leads to
- 1:37a delay in a project. So this is absolutely essential
- 1:41and today we're going to go through and share some of our
- 1:43advice and guidance and I know Paul's done a lot of this.
- 1:46In fact Paul you're having from a data migration moment on you.
- 1:49Yeah yeah I am yeah just we've been working on a project where
- 1:54I guess it just wasn't clear. Exactly what has been migrating
- 1:57from a catalog perspective and there's a lot of variables
- 2:02around some Legacy Activator which is just as fine as
- 2:06manageable. But yeah, it's just kind of
- 2:08added a few and a bit of friction in place.
- 2:11It's I guess. Yeah.
- 2:13And I think that's why we are starting point is don't
- 2:15underestimate the need to plan for data migration early on in
- 2:19the project. It's often not something that's
- 2:21a quick fix towards the end unless you're willing to accept
- 2:25scope creep cost creep and delays.
- 2:27So we're going to talk about why you need to migrate, what you
- 2:31need to and why and key consideration for your project.
- 2:34Lessons Learned. So let's just start I'm going to
- 2:36start with a couple of importance of wine.
- 2:38It's important to define this. Before you start the development
- 2:41phase your project and then I guess it's gonna be a bit of an
- 2:43interview. Me asking you questions pulling
- 2:45us tough time at but I think a few reasons why it's important
- 2:50to find before you start your project is not every development
- 2:53partner is a specialist in data migration and some like to avoid
- 2:57having to do it. So let's get out there and you
- 3:00need to know that early and if so you need to have a
- 3:04Mitigation, whether that involves bringing somebody else
- 3:06in who do the data migration piece for you and the project,
- 3:09or then provision the right resource to do it.
- 3:13So you've got a set those expectations up front, it's got
- 3:15to be documented and it's got to be documented in sufficient
- 3:17detail. So that you can, when you're
- 3:20coming back and say, well we haven't done this bit of data
- 3:22migration, it's there a line item level.
- 3:24So that's that's it. You've got be clear who's
- 3:26responsible for what? And that is.
- 3:28What do you and your team need to do to get the data out and
- 3:31ready for a third party to then take it and Into new solution,
- 3:36you need to make sure you've got your compliance needs covered.
- 3:39What data you're legally required to maintain and migrate
- 3:43across? Thanks for customer service is,
- 3:44what do they need to handle? Customer inquiries.
- 3:47And this isn't just in the new model.
- 3:49The new system is also retrospectives that orders
- 3:51placed prior to migration have. What does the customer service
- 3:54team do when a customer queries and all that it's placed a month
- 3:57ago and then having the right data to protect your Revenue?
- 4:00So you can actually sell effectively online Ivar Missed
- 4:04anything in terms of why it's important to get this nailed up.
- 4:06From poor know, I think one thing I was going to go back to
- 4:10your first point around making it clear or and it'll say that
- 4:15who's going to capable from a date of migration?
- 4:17Sped up. I think a lot of agencies.
- 4:19Don't want to migrate day or and if they do they'll want to do it
- 4:22in its most basic form. And I think alongside that it's
- 4:26like who is best placed to migrate data?
- 4:29Because a lot of sis. Yeah.
- 4:32But they're just they don't have this.
- 4:34That's internally to either do it efficiently or do it to the
- 4:38highest possible standard. And the one that I always come
- 4:41back to its catalog product migration or catalog migration.
- 4:45And I think it's so common that I see projects were essentially
- 4:50an agency has taken a Magento, product catalog, and migrated to
- 4:54Shopify Bigcommerce. And it's just a mess because the
- 4:57way the product data is managed and those platforms is
- 5:00fundamentally different, you know, you get so many different
- 5:02third parties or liar. Anon product attributes of tags
- 5:06and meta field and, you know, there's that.
- 5:09Yeah, there's so many reasons why it needs to have like its
- 5:12own Discovery. And I think that's one thing
- 5:15that is often, not fact in today migration is because a lot of
- 5:18merchants there's try and hand it off to the ancient.
- 5:21They don't have technical people internally or you know they're
- 5:24trying to do a re-platform project quickly but that's
- 5:27probably one of the most common issues I see and it's fine for
- 5:30like a period of time but it just gets messy.
- 5:34Time, particularly when it comes to like tags where, you know,
- 5:37it's essentially free form text entry and you've got so much
- 5:42stuff relying on these tags and you just end up with an absolute
- 5:46mess. And that's a start to get to it,
- 5:49start to get issues of products, not being available and feeds or
- 5:51different collections, or whatever else.
- 5:53But, yeah, I think it's, it's a lot more important than people
- 5:56think it is. Yeah.
- 5:58And I need can really screw up your uat phase when you hit that
- 6:01when people go on to like this pages.
- 6:02And there's Just Junk. How they looking again?
- 6:04What the hell's going on? The feeds one is such a
- 6:07wonderful out because I say so, a lot of people times get your
- 6:11direct marketing people or agency involved, but why we
- 6:14don't need them, this is just eat.
- 6:16No because if the data feed, if the data migration screwed up
- 6:19data feeds and they don't have all the field.
- 6:21You need to pass the core requirements for date.
- 6:24For you can get rejected and all the sudden your ads are down and
- 6:26you're losing Revenue. See ya.
- 6:27Good point, right? So I know this is fresh in your
- 6:30mind because you've been doing a lot of this recently.
- 6:32So what, what should Migrated, and why?
- 6:36Yeah, so I mean from my perspective I think there's it
- 6:39can be contentious around orders.
- 6:42So most of the time on we've gone through like an initial
- 6:46like, pre sales, process agencies, or want to put a limit
- 6:51on the amount of orders migrate and just because, you know, it's
- 6:54a lot of time involved in doing it properly, I would usually
- 6:58say, migrate all lifetime orders, just because it helps
- 7:01them a reporting perspective. And, you know, as various third
- 7:04parties that use the Time value of a customer, whatever else.
- 7:09So I would you should migrate all orders, all customers, and
- 7:12there's you know, lots of variables around that in terms
- 7:15of model, put having multiple stores and you know, the kind of
- 7:18data points you have against your customers but I had
- 7:21migrated all customer data and then product, I guess in an
- 7:25Ideal World all product data, that a lot of people want to do
- 7:27a bit of a cleaner. So as long as it doesn't impact,
- 7:30like your kind of order data reporting or anything like that.
- 7:35And as long as Essentially things that kind of unify
- 7:38between any other systems and your econ platform.
- 7:43I think that's fine. But yeah, we'll come on to kind
- 7:47of product in a lot more detail later on.
- 7:48But yeah, I would as much as possible, really.
- 7:51Yeah, I think that's good much them as much as possible, more
- 7:54than one caveat put on that is is you need to I think the
- 7:58business needs to think about the quality of its current
- 8:01database special from a CRM. Point of view, there are too
- 8:03many businesses where they have lots of old customer data.
- 8:06His customers are completely obsolete.
- 8:08Now, they have not visited the website in years, they've got
- 8:11purchased in years and I questioned the value of
- 8:14obsessing over those cuts and less.
- 8:16You have a really good reactivation and chain
- 8:19management program in place. And these people are recent
- 8:22enough for them to be active in those CRM programs.
- 8:25Or you know, that a subset customers only ever by once
- 8:28every year or two years for very specific life events and you
- 8:31have that knowledge gray. I think sometimes you can reduce
- 8:35the XD of data Migration by being clear on what data is not
- 8:39good in the first place that you don't need in the new system.
- 8:42So I always urge people to have that conversation before they
- 8:46migrate, but then I'm with you on that is sometimes.
- 8:48Agencies will say, only go back 12 months as I gave it great, a
- 8:52custom he's been a customer for six years and they purchased two
- 8:55three times a year and you lose all that order history.
- 8:58Well that's not helping customer service, it's not helping CRM
- 9:00and it's not helping any of the lifecycle marketing programs.
- 9:04And it impacts obviously paid Media stuff As well.
- 9:06So I think you have to fight the for having the right data.
- 9:11Yeah, I think they are, there are variables around all of this
- 9:13as well. I think it a lot of it also
- 9:16depends on what other systems. You've got around the
- 9:18accomplished for more date. You've got stored in those.
- 9:22Yeah but yeah no that makes sense.
- 9:25Yeah, exactly. If you have a really good bi CRM
- 9:28setup where all of the data is there historically and you don't
- 9:31you're not going to lose anything and you know that
- 9:34customer service is don't need to Pacifically access today.
- 9:37Or if customer service is don't ever Access Data from
- 9:39e-commerce? They always go into an Erp CRM.
- 9:42Exactly. This is, and this is why it
- 9:43always pays to have these conversations is, is what is the
- 9:46purpose of the data in e-commerce, who needs to use it
- 9:48on a daily, weekly monthly basis?
- 9:51And what are they going to fail to be able to do, if we are,
- 9:54don't migrate for enough backwards.
- 9:55But sometimes you can get away with just migrate in the past,
- 9:5812 months worth of orders. Yeah yeah.
- 10:03Again I think it's really interesting because it just
- 10:06massively depends on the business doesn't it?
- 10:08And like let you know, people are likely to come back and
- 10:10repeat purchase or, you know, you want someone to have an
- 10:13account or, you know, yeah. How your kind of stitching
- 10:16together, different forms of data against the customer
- 10:19property, like, all of that kind of stuff, like, yeah, I think
- 10:22there's so many variables, right?
- 10:23You say, like some businesses, the value in holding order and
- 10:28customer data is minimal rose up.
- 10:30It's going to be massive even if there's like a period where
- 10:33people don't necessarily come back so yeah, I guess it does.
- 10:36It does depend listener? It does.
- 10:39So I think the key takeaway for people is, is you've got orders
- 10:43customers and products essential data to migrate, but you've got
- 10:45a question. What, what day did you need to
- 10:48legally? What day did you need from a
- 10:50service point of view to service their customers?
- 10:52And what data do you need from like a marketing or a trade in
- 10:55point of view and how far back you need to go to enable those
- 10:58campaigns? And try not to migrate stuff
- 11:01just for the sake of it and cut out dead data and you data, you
- 11:07know, that isn't cleaning is dirty that will just pull up a
- 11:09new system. Next question, I think this is
- 11:13the most important question for today's podcast is who should be
- 11:15responsible for migrating data right over to you.
- 11:19Yes, I think order and customer. You just need someone that's,
- 11:23you know, capable understands the platform.
- 11:26You know, he's able to kind of work with.
- 11:30Each day assets except try like within that could be an internal
- 11:33person. It could be a completely
- 11:35independent third party. It could be the development
- 11:38agency. Yeah.
- 11:40I think that what and also I guess the other thing is that
- 11:42efficiency, peace, let someone that can write script rather
- 11:45than do it all manually except ra.
- 11:47But yeah, I think that side is, it could be a number of
- 11:51different people. I think when it comes to
- 11:53catalog, I personally think the majority of the work should be
- 11:57done internally by Well in the business because I think there's
- 12:02such an important. The other thing of this which is
- 12:04quite interesting is timing. Because you mentioned about data
- 12:08migration being covered in the Discover, which I completely
- 12:10agree. But there's actually
- 12:12particularly with the new South platforms.
- 12:16I think it's important that it's done at the right time.
- 12:18Because I always try and get, let's say, it's Shoppers by, and
- 12:22like, even before an agency selected quite often, I'll have
- 12:25a bait shop by basic implementation up and running
- 12:28and we'll be trying to get the catalog in.
- 12:30Just because it's one of the best things to get ahead but
- 12:34it's interesting because there is subject to change that you
- 12:37almost in an Ideal World. You want to get the core
- 12:39information and as early as humanly possible and then post
- 12:43Discovery when, you know about all the third parties, how your
- 12:46structure in the stores, all of those kind of potential inputs
- 12:51into the kind of tagging. Matt Field product attributes
- 12:55that are you then want to go through the enrichment phase and
- 12:58then, in my view, it's Gonna let you start with the overall kind
- 13:02of architecture which is like all of the different data
- 13:04points, document what they are. So you've got that throughout
- 13:07the project and you can hand over to different people and
- 13:10then you essentially do a bit of a gap analysis and then hand it
- 13:13over to an internal team to ideally populate virus cell, be
- 13:18that manually or by a kind of formulas, or whatever else.
- 13:22And then you kind of migrated from there, what is amply?
- 13:27INS in a word it's freedom. The freedom to build a digital
- 13:32experience as Limitless as your vision create preview schedule,
- 13:36and manage, all your content in one easy place.
- 13:40Find out more at a lien. Start cam a lian's experience
- 13:45freedom. I think the the ownership bit
- 13:51and you, as you say, starting it the product piece early is so
- 13:55important because it links into certain other Stream.
- 13:58So it links into things I saw oxide architectural taxonomy, is
- 14:02if any of the classifications of changing people might have
- 14:05images in directories named and linked with category IDs but if
- 14:11that's changing you've got to remap otherwise you end up with
- 14:16really beautiful new site tax on A menu structure.
- 14:20And then the image is getting, they don't go into the right
- 14:23product. So I think the a decline team is
- 14:26got to own that and if they don't know what they're doing,
- 14:28they need to bring in an external specialist to lead it
- 14:32for them because sometimes people don't have the time or
- 14:35they can't make sense of data and disparate, you know, do you
- 14:37love people? It got data and all sorts of
- 14:39like, share points and and sharing network folders and it's
- 14:44all over the place and they might have some some archaic way
- 14:48of pump it through FTP into various places.
- 14:51So I think, yeah, you've got to get that clean and know what
- 14:53you're doing. And have a structure before you
- 14:57even try and pass that product data across to an agency
- 15:00partner. So totally agree with that.
- 15:02Yep. So we've got one of the
- 15:06opportunities that's one. So what?
- 15:08So I guess this is a mixture of what they've got is and what the
- 15:10opportunities to get data better.
- 15:13Yeah, so I mean, I've so I think one of the biggest opportunities
- 15:17particularly when it comes Product is cleaning your data
- 15:21and getting to a point where things are truly unified and,
- 15:25you know, going back to kind of like building out, you know,
- 15:28categories based on product attributes or even like the and
- 15:32rules, you know, getting ever thinking like that perfect
- 15:38taxonomy and making sure that everything is entirely
- 15:40consistent. Like, I think that's one of the
- 15:43biggest benefits of re-platforming.
- 15:45All those folks going for a rebuilding your catalog.
- 15:48So I think that's the big one of the big ones, another one.
- 15:51And I just added this a second ago.
- 15:54While you're talking, I think one of the benefits of having an
- 15:56internal team heavily involved or owning the catalog migration
- 16:00process. It's a the people involved fully
- 16:03understand how things are built into the platform.
- 16:06The role that different data points are playing and their
- 16:09catalog. So I think that's another
- 16:11massive benefits. I've also seen that before, an
- 16:13SI has migrated product data and then everyone Why is this the
- 16:19here? How is this working Etc.
- 16:20So I think that's another benefit and then another one
- 16:24that you mentioned was things like so almost always like
- 16:29things like product IDs, a customer IDs, order ideas will
- 16:33change when you re platform and there's an opportunity to make
- 16:38things consistent. So I guess that's one thing you
- 16:40need to think about as a variable like to migrate those
- 16:43within like an attribute or amount of field or whatever.
- 16:47But also that is your opportunity to make sure like as
- 16:50part of the project that you were talking about earlier that
- 16:52I'm working on. There's been quite a big
- 16:54exercise to get their Nets which implementation matching the shop
- 16:58of by implementation and there's like a shared ID for everything
- 17:01can. Yeah.
- 17:02Like now like essentially all of the there's a lot of attributes
- 17:06that consists of words that wasn't the case before so stuff
- 17:09like that as well. That's another opportunity.
- 17:11And then I guess the other one is to berber and Rich,
- 17:14potentially, if you do have additional data that isn't being
- 17:17used, Or you know there's additional things you want to
- 17:21store within the new econ platform.
- 17:23You have the opportunity to take advantage of people spending
- 17:27time on the catalog or the data essentially.
- 17:30So yeah. It's kind of like yeah I guess
- 17:32that's like always the case with every platform it's an
- 17:35opportunity to like rethink things and that applies today,
- 17:38migration as well. You know, I find them sometimes
- 17:42on projects, the the data migration conversations need to
- 17:47happen after some of the Like, uh, news a journey, which is
- 17:50more the creative session, because you'll see I've worked
- 17:53from Plenty of projects, where the user Journey was flawed in
- 17:56the old site and therefore, the category structures and right in
- 17:58the way people shop and that gets reinvented and then you
- 18:01have your standard categories which one is like your static,
- 18:04actually get populated fire product IDs then you have your
- 18:09Dynamic categories based on the attributes that exists against
- 18:13the product and you don't can't nail down your attributes sets
- 18:17until you've got that user. Journey nail down and know how
- 18:19you people will browse and discover products in different
- 18:22ways. So, I think, I think that's a
- 18:24really important thing to do is get understand that ux piece as
- 18:27well, what's changing? What that does?
- 18:29And what additional data, you might need whether that is
- 18:33private information. Additional categories,
- 18:36attributes, tie different products across different
- 18:38categories together. Yeah, I think that's a key
- 18:41opportunity. It really is not not rushing.
- 18:45That part until you've gone through the creative.
- 18:48He pays first. Yeah, I agree that I think
- 18:52without being too specific, I think shopify's an interest in
- 18:55one in this area because the catalog, the Reliance on the
- 18:59catalog and Shopify I think is much bigger than any other
- 19:02platform. I've worked it in the sense that
- 19:04your tags and your matter fields are dictating everything to do
- 19:08with filtering. You must almost were most brand
- 19:12new smart collections like almost exclusively within their
- 19:16catalog. All of that is Based on a
- 19:18combination of different tags, the third parties, he's tagged
- 19:22the math fields and and again that goes back to the thing and
- 19:25like there is a need to go through the design.
- 19:29The kind of technical Discovery and then start mapping out, you
- 19:33end up with quite a lot of data points.
- 19:35And yeah, it is. That's a really important at Sur
- 19:38but it's a, you know, on all platforms at the the how much it
- 19:42impacts and how it impacts it diff about it.
- 19:44Even on the Magento setup, you need to know what your
- 19:47attributes sets on you. By the values within because if
- 19:49you don't plan it correctly, then you end up with filters
- 19:54inaccurate filters on this Pages, you end up with crap
- 19:58values within those attributes sets and you end up with
- 20:01products appearing when they shouldn't appear because the
- 20:03wrong values, beeping. All somebody's attached that
- 20:06product to the wrong attribute set by mistake because it wasn't
- 20:08thought through. So yeah there's this bit is
- 20:11critical that the the understanding of categorization
- 20:15static versus Dynamic category, smart smart play.
- 20:18Actions dynamic characters, whatever the language is in the
- 20:20platform and which data field drives it and which values you
- 20:24want, because if you don't sit down and set them up and say,
- 20:27right actually set a, which might be color would be sighs,
- 20:32you know, there's so many different attribute types.
- 20:34You get out there and all the values are permitted, so that
- 20:37you don't end up with chunking because otherwise if you leave
- 20:39it somebody to just put stuff in without a kind of structures
- 20:43that you end up with duplicates, different, Jin's.
- 20:48I've seen this in sizes where somebody puts just dimension in
- 20:51the Senate, me as others in millimeters, and then it's chaos
- 20:54for the customer, okay? So those are, I guess, those are
- 20:58the key opportunities and some of the gotchas are some of the
- 21:01key things to focus on. Now, let's look at the SEO.
- 21:04So I know this is something you flagged early with catalytic
- 21:06migration. So what SEO considerations to
- 21:09people need to think about? Yes, I think obviously the key
- 21:13one is just for every platform project you want to avoid
- 21:16change. A lot of people.
- 21:18Oil, like we've been talking about see an opportunity to
- 21:21completely rebuild their catalog and Yuri platform the
- 21:24exceptions. Ideally are you in maintain a
- 21:27lot of the kind of important SEO data so things like the where
- 21:34possible the URL which isn't always possible but ideally you
- 21:38would kind of avoid change really can the long description
- 21:42and any of the kind of like front and content things like
- 21:44product reviews and then the metadata as well.
- 21:48So Dearly unit void change their just to limit the risks and
- 21:52alongside really wraps if you kind of nail those two areas
- 21:55you're definitely mitigating a lot of the risk around lose and
- 21:58organic visibility and then the other one I've added here is
- 22:03with the URLs, it can make redirects a lot easier if you if
- 22:07you are completely changed everything and you know you're
- 22:09moving to subdomains or subfolders like you're making
- 22:12major changes. And even kind of the product
- 22:16URLs if you're, you know, injecting I'm removing the
- 22:18skewer or whatever else. It's still quite important to
- 22:22think about really works and obviously that's a bit of a
- 22:24secondary thing that redirects are so important and you want to
- 22:28be able to do as effectively as possible.
- 22:30So that's another kind of better better.
- 22:34Yeah. The key of voice here is have an
- 22:37owner in the business for the SEO strain, which is the small
- 22:41business, is known. As the commercial manager if
- 22:43that equals minus doesn't have technical SEO expertise, then
- 22:47you, We need either a freelancer or an agency partner to have
- 22:52that to make sure you've thought about that was the new proposed
- 22:56catalog structure. A, it takes off user journey and
- 22:58ux demands. But be, does it align with
- 23:00search demand? Are you missing any any category
- 23:03opportunities where you could create a completely different
- 23:06category? That targets SEO, demand?
- 23:10Are you optimizing it? Well, do you have the right?
- 23:13You know, have you thought about the whole page title stuff?
- 23:15Have you also thought about where you have a genuine
- 23:19Category Or List page at might be really useful for me user
- 23:22Journey point of view, or from a branding point of view.
- 23:24But actually it's the duplication of something else.
- 23:28Coming at SEO point of, it would compete with an existing page
- 23:31and you need to set, canonical's and hierarchies.
- 23:35So yeah. Really pay Seven often.
- 23:37It's just a massive, it's a big spreadsheet that maps, all out
- 23:40and sets the rules in there and then the other bit of that as
- 23:43you said it's definitely the schema bit.
- 23:45I think people underestimate his people below Yeah, we're going
- 23:48to we're going to we want to hand write and make it all
- 23:51natural or not like you know, machine driven and then you get
- 23:55down a project and people realize how do you hand crank
- 23:59page titles descriptions Etc? Fur like thousands of skus is I
- 24:03it's not feasible to do each one individually.
- 24:06Then you have to come back to priorities.
- 24:07Like top-level categories, top products, and then create
- 24:10schemas that can automate things until you get to optimize the
- 24:13manually. And that I'm sure you've seen
- 24:18this. People underestimate how long
- 24:19this takes to get done. Yeah, agency.
- 24:22When dress to make this thing as well, is not thinking about some
- 24:26of this stuff up front like often, I'll see like some of
- 24:29this stuff come up later in the project and it just hasn't
- 24:31necessarily been for about. And and I do you think Yeah
- 24:36sometimes it's more. I think like working.
- 24:39Yeah, basically it's harder with some platforms and others like
- 24:42nothing generally like working with a Magento Magento is really
- 24:46mature in terms of catalog management and kind of how we
- 24:50even like you said actually just you know having different scopes
- 24:54of attributes etc etc. And I think some of the other
- 24:56platforms don't necessarily have some of that stuff and it's just
- 24:59there's more variables for sure. Yeah it is and also where you
- 25:03are limited in url. Structures, if you come from a
- 25:07platform where you're not limited in, you are stretching
- 25:09your couple ever folder path, you want.
- 25:11So then suddenly realize that all actually, I don't and uneven
- 25:15and platforms, where once, once a filter is applied, the default
- 25:21isn't generating indexable URL. How do you work around that?
- 25:25Let you know you have to build our additional Collections and
- 25:28then you have to make sure you manage that effectively.
- 25:30So, yeah, it's so important to get your SEO Dae to
- 25:33considerations soon as it To see the project starts the show work
- 25:38stream should have started already, and in Discovery, you
- 25:41should have set down what the needs are not just some of the
- 25:44challenges so that you can get the right resource onto.
- 25:47Okay, cool. So, SEO, definitely improve the
- 25:49data migration. So, what else, what else needs
- 25:52to be considered? And what are some of the they've
- 25:53got to? Do you see my people and thought
- 25:55about it? Yeah, so I think one of the, I
- 25:58mean, the big one is probably Reliance on data from other
- 26:02systems and Reliance on. Pacific attributes or meta
- 26:06Fields or just data points. I guess.
- 26:08So you mentioned earlier about ideas changing often, you know,
- 26:13you need to import a legacy ID, for the sake of an Erp
- 26:16integration or a CRM platform or something like that.
- 26:21So I think it's really again like going back to the timing of
- 26:24the day of migration now or it might be that you kind of handle
- 26:27a lot of it and then come back to it but there's definitely
- 26:30when it comes to Integrations of third parties there's usually
- 26:33some things that need to You considered?
- 26:37Yeah, I like we've got quite a lot of a metro area and quite
- 26:40often. Now be like specific data points
- 26:42that will need to maintain just for a metre or whereas had them
- 26:45in the past other platforms or, you know, yeah, that's kind of
- 26:48shared ideal need to be imported as a matter field, for example.
- 26:55But yes, I think that's big one. And then, the other third
- 26:57parties is another one. Like, one of the things that I
- 27:00see, a lot of people forget, it's like, say, you're using one
- 27:03search engine you. Keep that search engine with the
- 27:06new platform, but they because again, like the data structures
- 27:10are changing or like the ideas that most platforms will use
- 27:15product idea rather than ask you.
- 27:17So they will lose all of the retrospective data.
- 27:20And, and also planning for things like even product review
- 27:22migration, it's actually usually quite tricky and other mapping
- 27:26exercise. Again, as a result of the IDS,
- 27:30see ya, all of that stuff just needs to be factored as well.
- 27:34Yeah, that's a really good point actually.
- 27:36I think sometimes you forget that that it's not just the core
- 27:39e-commerce in the back office, but some of the stitching merch
- 27:42tools you're using and how you you can still use them.
- 27:47But you might lose some of that, like personalization history
- 27:51because you might use some of the Cross and upsell
- 27:54capabilities because that product ideas change and
- 27:57therefore the system's got to relearn on a new set of ID's.
- 28:01Have you ever have you ever been able to crack that of Being able
- 28:04to like, put my great map across old to new IDs in search of much
- 28:10tools. Yes.
- 28:13So what would usually happen. So we've done it.
- 28:15Quite a lot of klaviyo. Obviously, I work quite closely
- 28:17with klaviyo and what you would usually do and it does depend on
- 28:22the third party, all that your pose, another one.
- 28:26So your player is you take the product ID and then you import
- 28:30it as part of the migration, then your code essentially.
- 28:33I've got that failed with that idea.
- 28:37And then moving forward that we use in like the shop fire or
- 28:39like the new platform idea or the handle or whatever else.
- 28:43And then clay, the you can do the same thing or you can do a
- 28:47mapping exercise with Claver and you can use the skew.
- 28:50But you have to map the idea to the skewer if that makes sense.
- 28:54Interest of, I've worked a lot of those implementations but
- 28:57they've not been. They've been fresh
- 28:59implementations rather than migrations across interest.
- 29:05Prepare any anything else to add before we wrap up?
- 29:08Yeah. One other thing that I just
- 29:09added here that probably should have been done before was
- 29:13migration a gift cards promo codes and store credits.
- 29:17Their free other things that would need to be important
- 29:21things like still credit, so often forgotten and that will
- 29:25come up really late and it'll be like someone's refunding or
- 29:28ever. And then suddenly be like, what
- 29:30happens with still credit promo codes are usually Casey gift
- 29:34cards can be quite hard because the way that gift cards work in
- 29:37different platforms differs but that's another one.
- 29:42And then essentially all of these would need to be factored
- 29:45into like the integration of Erp and how you know date was
- 29:48handled etcetera etcetera. So yeah those three would be
- 29:51able and certainly to be factored into a plan from the
- 29:53start. Yeah I remember bummer of
- 29:56working with a charity while back and they because of the
- 29:59challenges of migrating like points balances they were Just
- 30:04going to wipe people's points balances.
- 30:06She's like no it's not very good customer experience to Sunny
- 30:11people think they've got rewards to redeem and all of a sudden we
- 30:15migrated to this great new system for you but you can't
- 30:17have your points is not a good way to start your new platform.
- 30:21That's that's actually really interesting one because
- 30:23sometimes the the Integrations of like a loyalty, vendor will
- 30:29differ and you can tissue points based on the same things that
- 30:32we've had a client move. On Shopify to magenta and not be
- 30:36able to do some of the same things essentially, which can
- 30:39impact the customer. And one of one, I just thought
- 30:43of based only sin, that probably the hardest thing, one of the
- 30:46hardest things to migrate is tokens for subscription Riders
- 30:50as well. If you're like switching
- 30:52subscription, bundle and payment provider and everything else.
- 30:54That's kind of one so night Mama And this, this is a reason for
- 30:59doing this episode today. You can, you can realize that
- 31:02there are so many data migration isn't just.
- 31:04Okay, we're going to bring over some orders and customers, there
- 31:07are so many different touch points to and implications.
- 31:10You have to think about how data is impacting all of your
- 31:13capabilities from an e-commerce and customer service serum point
- 31:16of view. So hopefully that's given people
- 31:18some food for thought and I guess my my parting comments
- 31:22would be new. Make sure Discovery covers data
- 31:24migration in detail and if the your the agency or the partner
- 31:28your work With doesn't want to do it that you, make sure that
- 31:31they do because it's got to be documented or you agree.
- 31:34Who's responsible for make sure they're detailed statement of
- 31:38work. So you seen how much we've gone
- 31:39through today? And that's not exhaustive.
- 31:41I'm sure everyone listening could probably come up with a
- 31:43few other things they've experienced and projects.
- 31:45The data migration be clear on who's responsible for writing
- 31:47each data set. And by when have data migration
- 31:50as a work stream in your project plan so that you can track
- 31:53progress and Milestones and all your missing specific
- 31:55deliverables and don't assume it will go Smoothly, it often, and
- 32:00rarely. But it rarely goes really,
- 32:02really smoothly. It's add contingency.
- 32:04So if you know you need something by day x building
- 32:07contingency. So the uh, not stressing on that
- 32:09last few days. Paul, what's your part in
- 32:12thoughts or advice? I think that's all really
- 32:15interesting. But one thing I was just
- 32:17thinking was and I don't I think we've probably already covered
- 32:20this in the past, but we should do an episode on building out
- 32:24like an internal project plan. I think that's always quite
- 32:26interesting because there's so many like Forgotten B.
- 32:30The internal teams don't realize they need to do at different
- 32:33points of the project and I've been that big get upset.
- 32:36Yeah the change management piece oh there we go. - so good.
- 32:39Thanks, as always for listening, I hope you've enjoyed it, feel
- 32:42free, it's always to challenge and disagree with us on stuff.
- 32:45Or or point out where we've missed things keep an ear out
- 32:48for next episode. We drop one every Tuesday and
- 32:50we'd love you to subscribe and get a rating on Apple Spotify or
- 32:53YouTube. Thanks very much take care.
- 33:02More information on this topic, head over to re-platform dot.
- 33:05F m, for our audio podcasts to discuss a project or if you like
- 33:08to chat about any of the topics covered in this episode in more
- 33:11detail. Please reach out to myself.
- 33:13James, curd and my co-host Paul Rodgers via LinkedIn and
- 33:15Twitter. Thanks again for listening and
- 33:17keep your ears peeled for the next episode.