00:00:03.675 --> 00:00:04.965 Lefty. Ohh.
00:00:06.515 --> 00:00:07.855 That stole my chat.
00:00:11.495 --> 00:00:15.125 Battle kitchen price.
00:00:18.285 --> 00:00:21.865 Is 2499.
00:00:24.445 --> 00:00:26.245 Stock of.
00:00:28.165 --> 00:00:36.115 12 where a full army of kittens and my keywords.
00:00:37.245 --> 00:00:38.355 Our yarn.
00:00:39.865 --> 00:00:41.835 And ammo.
00:00:45.155 --> 00:00:48.545 How do I get this into my database using?
00:00:48.625 --> 00:00:51.085 Uh, an Excel spreadsheet.
00:00:51.795 --> 00:00:52.495 Yeah.
00:00:53.375 --> 00:00:56.678 OK. So I'll be like, hi, Mr. Client, this is how you're going
00:00:56.678 --> 00:01:00.088 to do this. You're going to log into stuff admin and you'll see
00:01:00.088 --> 00:01:03.178 this screen. If you go to the products tab here and click
00:01:03.178 --> 00:01:03.445 view.
00:01:04.785 --> 00:01:07.586 As if you were. Should I go to new? Because I know how to get
00:01:07.586 --> 00:01:08.445 to there from here.
00:01:08.285 --> 00:01:09.915 It's fine either way.
00:01:09.555 --> 00:01:09.895 OK.
00:01:10.985 --> 00:01:14.433 Then at the top you'll see this button called import products.
00:01:14.433 --> 00:01:17.499 Select that button and then you'll get this handy dandy
00:01:17.499 --> 00:01:18.375 import template.
00:01:19.075 --> 00:01:20.995 Download it and then open it.
00:01:24.535 --> 00:01:26.705 Ignore this one. I was looking at Tom's stuff.
00:01:29.705 --> 00:01:33.499 OK. So then you're at this handy dandy import template that has
00:01:33.499 --> 00:01:37.294 all the fields which you'll need to. What's it called? Fill out
00:01:37.294 --> 00:01:40.911 to make sure that the necessary information is put into your
00:01:40.911 --> 00:01:44.172 product so that it shows up in the back end and on the
00:01:44.172 --> 00:01:44.825 storefront.
00:01:46.095 --> 00:01:49.439 And then remind me which ones are the? I'm pretty sure it's
00:01:49.439 --> 00:01:49.885 the one.
00:01:51.225 --> 00:01:54.673 Charged with these little. Ohh no, these are comma delimited.
00:01:54.673 --> 00:01:56.675 Which ones are the required fields?
00:01:57.085 --> 00:01:58.725 You can phone a friend, but not me.
00:02:00.075 --> 00:02:02.335 OK, I know that's obviously it's the name.
00:02:03.385 --> 00:02:03.775 Mm-hmm.
00:02:03.475 --> 00:02:06.141 Categories that needs to be assigned to something, otherwise
00:02:06.141 --> 00:02:06.885 it won't show up.
00:02:07.595 --> 00:02:10.445 Uh, we have to have SEO URL.
00:02:12.395 --> 00:02:12.695 Yep.
00:02:12.685 --> 00:02:14.355 Sure. We have. Yeah, hold on.
00:02:14.935 --> 00:02:18.327 Do you want to do you want to find out the easiest way to do
00:02:18.327 --> 00:02:18.605 that?
00:02:19.395 --> 00:02:19.755 Mm-hmm.
00:02:20.565 --> 00:02:22.355 So go ahead and minimize this.
00:02:27.675 --> 00:02:30.135 Now go back to the products.
00:02:31.245 --> 00:02:32.605 And do new product.
00:02:37.125 --> 00:02:42.308 Anything in red, with the exception of SEO URL means it
00:02:37.335 --> 00:02:38.225 Ah.
00:02:42.308 --> 00:02:43.975 needs information.
00:02:45.195 --> 00:02:48.960 And that's going to be true all the way down the line. So if you
00:02:45.275 --> 00:02:45.505 OK.
00:02:48.960 --> 00:02:49.945 click on pricing.
00:02:51.105 --> 00:02:53.075 You'll need to have a price in there.
00:02:59.045 --> 00:03:00.885 And you don't have to have images.
00:03:02.895 --> 00:03:03.395 Please.
00:03:04.115 --> 00:03:05.715 So sessions.
00:03:06.555 --> 00:03:07.755 After those.
00:03:08.665 --> 00:03:10.745 Attributes OK.
00:03:12.355 --> 00:03:15.715 Let's go back to this one. This is the one.
00:03:18.205 --> 00:03:19.195 That's yeah.
00:03:19.205 --> 00:03:20.545 That was the Tom's one, wasn't it?
00:03:21.385 --> 00:03:22.205 It doesn't matter.
00:03:24.905 --> 00:03:27.588 Sorry, I've downloaded so many of these today. Can you guys
00:03:27.445 --> 00:03:30.145 You're in the. Yeah, you're in the correct one.
00:03:27.588 --> 00:03:28.215 tell how it's?
00:03:30.165 --> 00:03:30.765 OK, cool.
00:03:32.415 --> 00:03:32.825 So.
00:03:33.795 --> 00:03:35.105 What was the name?
00:03:37.205 --> 00:03:37.965 Laughing.
00:03:39.175 --> 00:03:39.825 At all.
00:03:42.745 --> 00:03:43.085 Ooh.
00:03:43.505 --> 00:03:47.195 Active true is visible true categories.
00:03:47.955 --> 00:03:48.655 But I want.
00:03:48.095 --> 00:03:48.805 It's just one.
00:03:49.435 --> 00:03:54.169 I want to buy a fluffy battle kitten from the fluffy battle
00:03:54.169 --> 00:03:55.195 cats section.
00:03:58.555 --> 00:04:01.265 So your name needs to be kittens.
00:04:02.305 --> 00:04:04.115 Your category needs to be cats.
00:04:04.945 --> 00:04:05.195 Ah.
00:04:10.635 --> 00:04:11.205 10.
00:04:34.375 --> 00:04:36.135 This be plural.
00:04:35.265 --> 00:04:36.215 Ooh.
00:04:36.895 --> 00:04:38.125 Yeah, I would do it, plural.
00:04:39.745 --> 00:04:43.045 Anybody have any guesses on what she's doing right now?
00:04:45.185 --> 00:04:46.095 You're setting up.
00:04:49.415 --> 00:04:53.334 So she had fluffy battle cats, and then she put a common and
00:04:53.334 --> 00:04:55.005 did fluffy battle kittens.
00:04:55.775 --> 00:04:56.755 Subcategory.
00:04:57.175 --> 00:04:58.075 Hell yeah.
00:04:58.635 --> 00:05:01.893 I watched that. I know that you need. I wrote it down. Sorry. I
00:04:58.725 --> 00:04:59.285 Nice.
00:05:01.893 --> 00:05:03.065 just had to pull it up.
00:05:05.315 --> 00:05:06.585 Kudos, good job.
00:05:07.645 --> 00:05:10.391 Also, this may be a dumb question but I am going to ask
00:05:10.391 --> 00:05:13.335 it anyway. Space this needs a space between it, doesn't it?
00:05:13.545 --> 00:05:13.755 No.
00:05:14.275 --> 00:05:16.345 No. OK, good thing I asked.
00:05:17.555 --> 00:05:19.145 OK, custom key.
00:05:18.355 --> 00:05:22.625 If you put a space in there, that's an interesting question.
00:05:22.625 --> 00:05:27.105 It might actually put a space in front of the F in the display.
00:05:27.775 --> 00:05:28.565 Hmm, OK.
00:05:32.345 --> 00:05:34.975 And then these other tabs are categories could also be.
00:05:35.765 --> 00:05:39.552 Sub ones as well right depending on how many like somebody wants
00:05:39.552 --> 00:05:41.825 to have. But for the most part if you.
00:05:40.975 --> 00:05:46.334 Umm, actually no. So a product can be assigned to multiple
00:05:46.334 --> 00:05:51.603 categories and multiple like groups of categories. So you
00:05:51.603 --> 00:05:55.055 could have a product that is part of.
00:05:56.275 --> 00:06:01.932 Fluffy battle cats and fluffy battle puppies as two different
00:06:01.932 --> 00:06:07.589 parent categories, so if you filled out column E and column D
00:06:07.589 --> 00:06:13.338 or column D&E, that's the better way to use your words. It
00:06:12.455 --> 00:06:12.715 Umm.
00:06:13.338 --> 00:06:18.356 would give it two parent categories, and So what we're
00:06:18.356 --> 00:06:24.105 doing with the comma is creating the tree for the subcategory.
00:06:25.015 --> 00:06:25.445 OK.
00:06:26.645 --> 00:06:30.475 Also that is doable to get something underneath two
00:06:28.845 --> 00:06:29.205 Umm.
00:06:30.475 --> 00:06:31.065 parents.
00:06:30.795 --> 00:06:31.865 Umm.
00:06:32.595 --> 00:06:33.085 OK.
00:06:35.225 --> 00:06:36.595 Alright, custom key.
00:06:38.465 --> 00:06:41.785 Should we just make it a number just for testing purposes?
00:06:42.725 --> 00:06:43.605 Or leave it at that.
00:06:43.065 --> 00:06:48.406 Whatever. Yeah, whatever you want. But can you tell me what a
00:06:48.406 --> 00:06:50.215 custom key here does?
00:06:53.675 --> 00:06:54.605 Ohm.
00:06:55.425 --> 00:06:59.230 Other than other than it being like the custom key of what you
00:06:59.230 --> 00:07:02.975 can search for and stuff that's like the identifier for it, I
00:07:02.975 --> 00:07:04.485 don't really know how to.
00:07:03.635 --> 00:07:04.605 It's a skew.
00:07:05.245 --> 00:07:07.335 Yeah. Ohh yeah, the skew.
00:07:08.475 --> 00:07:12.165 So the custom key, yes, you are both correct.
00:07:12.905 --> 00:07:17.292 Uh, so the custom key has a couple of different functions
00:07:17.292 --> 00:07:21.075 within CEF UM, so it is something that is tied to
00:07:21.075 --> 00:07:25.236 Elasticsearch for searching purposes. It is the unique
00:07:25.236 --> 00:07:29.699 identifier for most products within an ERP system. This is
00:07:29.699 --> 00:07:34.465 what we use to map back if we are pulling data in from an ERP.
00:07:34.465 --> 00:07:39.382 So in that case they would have the sellable skew which we would
00:07:39.382 --> 00:07:43.695 then tie into the custom key. It could be a part number.
00:07:43.775 --> 00:07:48.478 It could be like whatever we use in their database as the unique
00:07:48.478 --> 00:07:52.820 identifier is what gets pulled into there. So that's why we
00:07:52.820 --> 00:07:57.017 didn't name it skew necessarily, because we need a unique
00:07:57.017 --> 00:08:01.793 identifier across every table in Seth for each record that we are
00:08:01.793 --> 00:08:02.445 entering.
00:08:03.565 --> 00:08:04.195 So.
00:08:05.185 --> 00:08:08.670 Because we're not connected to anything and it's still a
00:08:08.670 --> 00:08:12.156 required field, it can be literally bobs, your uncle and
00:08:12.156 --> 00:08:13.685 the system wouldn't care.
00:08:15.515 --> 00:08:16.745 I do something funny.
00:08:19.285 --> 00:08:21.545 Umm. Spicy.
00:08:21.345 --> 00:08:23.575 Buffy Battle Kittens 69.
00:08:25.805 --> 00:08:28.475 It's Friday. I'm gonna funny mood, OK?
00:08:27.765 --> 00:08:28.425 I love it.
00:08:30.135 --> 00:08:33.148 Manufacturer, part number. I've seen this as a field and when
00:08:33.148 --> 00:08:34.655 you go into product details so.
00:08:35.625 --> 00:08:36.945 Sure. Show me.
00:08:35.655 --> 00:08:38.095 I'm A is this also some? Yeah.
00:08:38.485 --> 00:08:39.335 Show me.
00:08:40.215 --> 00:08:41.415 Show me what you're looking at.
00:08:41.975 --> 00:08:42.725 This.
00:08:42.965 --> 00:08:43.595 Yeah.
00:08:45.085 --> 00:08:48.596 Face it, whatever you input into an importer, there will import
00:08:48.596 --> 00:08:52.052 or it'll kind of populate here. And is this something too that
00:08:51.905 --> 00:08:52.295 Uh-huh.
00:08:52.052 --> 00:08:55.398 if someone's pulling from an ERP that they're probably using
00:08:55.398 --> 00:08:58.745 those same numbers? So it's kind of like a one to one match?
00:08:59.975 --> 00:09:01.645 Uh, we can map that.
00:09:03.175 --> 00:09:06.636 Certainly if they have that in their database, we just need to
00:09:06.636 --> 00:09:08.285 know that they want it mapped.
00:09:08.915 --> 00:09:09.405 Got it.
00:09:11.255 --> 00:09:14.915 Umm can I? Can I steal your screen though?
00:09:15.215 --> 00:09:15.495 Yeah.
00:09:16.175 --> 00:09:20.926 OK, so Amy and I actually went through this a little bit this
00:09:20.926 --> 00:09:23.225 morning. So there's something.
00:09:25.415 --> 00:09:30.554 Somewhat specific that we need to keep in mind here when you're
00:09:30.554 --> 00:09:35.452 using the product importer. If you add a column and it has a
00:09:35.452 --> 00:09:38.665 header of fluffy battle kitten collars.
00:09:40.935 --> 00:09:46.206 Or whatever, just some random thing that you're adding in that
00:09:46.206 --> 00:09:51.144 is going to map into Seth as an attribute. So an attribute
00:09:51.144 --> 00:09:56.666 within the database is something that we don't have in our normal
00:09:56.666 --> 00:10:02.189 schema, so every client is going to have some weird data point on
00:10:02.189 --> 00:10:03.445 their products.
00:10:04.075 --> 00:10:07.695 That we just don't have in our schema. So rather than building
00:10:07.695 --> 00:10:11.028 that out for every individual client, we use serializable
00:10:11.028 --> 00:10:14.534 attributes. The importer will just lump it in here and it'll
00:10:14.534 --> 00:10:18.040 display on the storefront and Amy will show you that when we
00:10:18.040 --> 00:10:18.615 get there.
00:10:21.735 --> 00:10:26.331 But if we are trying to map to something within this screen
00:10:26.331 --> 00:10:30.850 within our product editor, we need to make sure that we're
00:10:30.850 --> 00:10:35.523 using the right name because the importer is looking for the
00:10:35.523 --> 00:10:37.745 individual field name and so.
00:10:37.205 --> 00:10:38.455 It's all the apps now.
00:10:38.675 --> 00:10:39.705 This morning.
00:10:38.975 --> 00:10:39.945 Are you sharing your screen?
00:10:40.505 --> 00:10:40.965 Yeah.
00:10:41.415 --> 00:10:41.775 How I.
00:10:42.505 --> 00:10:44.845 I just see like a green tint. I see you're back.
00:10:46.555 --> 00:10:48.675 Alright, let me try it again.
00:10:50.205 --> 00:10:50.645 Better.
00:10:51.115 --> 00:10:51.775 Yes.
00:10:52.105 --> 00:10:53.885 OK so.
00:10:55.885 --> 00:10:59.384 If we don't know what it is, if it's not part of our schema,
00:10:59.384 --> 00:11:02.654 it's going to live in our attributes and it'll just be a
00:11:02.654 --> 00:11:04.835 data point associated to the product.
00:11:05.535 --> 00:11:09.350 But if we're trying to get something in here filled out,
00:11:09.350 --> 00:11:13.567 whether that is manufacturer, part number, brand name, unit of
00:11:13.567 --> 00:11:17.583 measure, we need to make sure that the header column on the
00:11:17.583 --> 00:11:21.532 importer matches exactly what the field name is in CEF. So
00:11:21.532 --> 00:11:24.545 there's a quick trick to be able to do that.
00:11:25.235 --> 00:11:29.854 If you Nope, I don't want to do that. If you, uh, right click
00:11:29.854 --> 00:11:31.345 and inspect element.
00:11:33.095 --> 00:11:36.893 It'll actually take you to the field that you're looking at,
00:11:36.893 --> 00:11:40.815 and you might have to go up to the full division so it'll take
00:11:40.815 --> 00:11:44.551 you to the label. We don't care about the label because the
00:11:44.551 --> 00:11:47.665 label is gonna be human readable, human friendly.
00:11:48.615 --> 00:11:53.117 So we're going to go up a level. This is still talking about the
00:11:53.117 --> 00:11:57.273 label. You can see here. So we're gonna go up and make sure
00:11:57.273 --> 00:12:01.429 that the screen is highlighted over here and shows the full
00:12:01.429 --> 00:12:01.845 thing.
00:12:02.985 --> 00:12:04.605 So when you look in here.
00:12:06.395 --> 00:12:10.972 You can see that the key associated to it is manufacturer
00:12:10.972 --> 00:12:15.629 part number. All is one word with proper casing, so you've
00:12:15.629 --> 00:12:20.759 got the capital M, the capital P and the capital N this is going
00:12:20.759 --> 00:12:25.652 to be the column title in your import Excel spreadsheet. Does
00:12:25.652 --> 00:12:26.915 that make sense?
00:12:29.255 --> 00:12:29.685 Yes.
00:12:30.175 --> 00:12:30.545 OK.
00:12:30.425 --> 00:12:30.765 Mm-hmm.
00:12:31.535 --> 00:12:34.935 All right, sorry. Side tangent back over to you, Amy.
00:12:51.375 --> 00:12:52.895 Related products.
00:12:56.035 --> 00:12:57.145 What would that do?
00:13:00.795 --> 00:13:02.525 Is that also an association?
00:13:03.045 --> 00:13:05.105 Yes, 100%.
00:13:06.065 --> 00:13:06.715 Nice.
00:13:07.805 --> 00:13:10.618 You wanna talk a little bit about where to find that in Seth
00:13:10.618 --> 00:13:10.895 Admin?
00:13:12.485 --> 00:13:13.875 Yeah, let's go look.
00:13:16.715 --> 00:13:20.284 Umm, should I go to the actual tab where associations are
00:13:20.284 --> 00:13:23.485 listed or should I go within a product and go here?
00:13:23.755 --> 00:13:24.175 Right there.
00:13:25.555 --> 00:13:31.045 So you can associate products that are similar.
00:13:31.765 --> 00:13:35.285 A business use case for this is.
00:13:36.405 --> 00:13:38.695 You've got T-shirts.
00:13:40.155 --> 00:13:46.315 Long sleeve T-shirts and tank tops. They're all similar. Ish.
00:13:48.205 --> 00:13:51.932 But, and they're all kind of grouped together under the same
00:13:51.932 --> 00:13:55.538 category. But you wanna show related products. If I have a
00:13:55.538 --> 00:13:57.005 long sleeve, a tank top.
00:13:57.725 --> 00:14:02.035 And a T-shirt that all have a fluffy battle kitten.
00:14:02.775 --> 00:14:04.405 Logo on the front of it.
00:14:06.285 --> 00:14:09.834 I want all of those to be grouped together so I can tie
00:14:09.834 --> 00:14:13.510 them together as an associated product here and that will
00:14:13.510 --> 00:14:15.855 display on the product details page.
00:14:17.635 --> 00:14:21.386 So, since we're only doing 1 product, we won't get too deep
00:14:21.386 --> 00:14:25.199 into associations at this point, but we will talk about it a
00:14:25.199 --> 00:14:29.200 little bit when I show you how that maps to the product details
00:14:29.200 --> 00:14:33.076 page, so we can gloss over this part for now, but essentially
00:14:33.076 --> 00:14:35.015 you're creating like items, so.
00:14:36.165 --> 00:14:40.975 You can group them together in whatever way you want this also.
00:14:41.915 --> 00:14:45.562 The associations tab also works for variance, but that's the
00:14:45.562 --> 00:14:47.595 different can of worms and we'll.
00:14:48.455 --> 00:14:49.825 We'll slow roll that one.
00:14:52.505 --> 00:14:53.885 So for now, can I take this out?
00:14:54.405 --> 00:14:54.615 Yeah.
00:14:59.215 --> 00:15:01.125 Right, it's 24.
00:15:05.275 --> 00:15:08.375 I would imagine that the manufacturer on this is Mama
00:15:08.375 --> 00:15:08.605 cat.
00:15:10.595 --> 00:15:11.465 Steer this way.
00:15:21.245 --> 00:15:23.355 Sorry, I had to put my stamp in there somewhere.
00:15:24.535 --> 00:15:25.645 I like it Picasso.
00:15:30.285 --> 00:15:31.865 OK, model number.
00:15:33.645 --> 00:15:35.955 Where is the. Is this a field? Let me check.
00:15:42.895 --> 00:15:43.995 Model number.
00:15:47.425 --> 00:15:49.505 What is model number in this?
00:15:50.135 --> 00:15:51.165 Model number.
00:15:50.235 --> 00:15:52.445 The model number of the actual product.
00:15:53.305 --> 00:15:57.885 It is the. It can be whatever the client wants it to be. This
00:15:57.885 --> 00:16:02.318 is a very common asked for attributes, so we included it in
00:16:02.318 --> 00:16:06.898 the product importer because so many people need some sort of
00:16:06.898 --> 00:16:11.257 part or model number that is different from their sellable
00:16:11.257 --> 00:16:15.985 skew. So it's typically brought in through the product importer
00:16:15.985 --> 00:16:20.861 as a serializable attribute, but we include it in here so that it
00:16:20.861 --> 00:16:23.595 indicates that they can import that.
00:16:24.405 --> 00:16:24.715 OK.
00:16:27.755 --> 00:16:30.254 So for our fluffy battle kittens, do we need a model
00:16:30.254 --> 00:16:30.585 member?
00:16:30.985 --> 00:16:34.123 No, I mean, there's only 12 of them. We don't need to get
00:16:34.123 --> 00:16:34.665 squirrely.
00:16:40.585 --> 00:16:40.945 Tea.
00:16:41.125 --> 00:16:45.965 Else and these are a bulleted list. Is this also an attribute?
00:16:47.385 --> 00:16:48.275 Yes.
00:16:53.755 --> 00:16:55.555 To retreat these to say something funny.
00:16:56.245 --> 00:16:56.905 Up to you.
00:17:06.605 --> 00:17:07.395 There, it's lovely.
00:17:09.215 --> 00:17:10.205 Six toes.
00:17:09.305 --> 00:17:10.395 Trying to be creative.
00:17:10.895 --> 00:17:12.565 Sit 6 toes.
00:17:14.425 --> 00:17:15.075 So.
00:17:15.555 --> 00:17:17.485 Comes with murder Mittens.
00:17:16.115 --> 00:17:16.785 Means.
00:17:25.275 --> 00:17:25.825 Murder.
00:17:26.675 --> 00:17:27.395 Attendance.
00:17:37.475 --> 00:17:39.125 That's what else do cats have?
00:17:41.485 --> 00:17:42.015 Puppy.
00:17:41.645 --> 00:17:42.675 Ah.
00:17:43.615 --> 00:17:47.911 What is? What's that? What's the helmet that soldiers have? Is
00:17:43.635 --> 00:17:44.455 Tail.
00:17:47.911 --> 00:17:50.025 there a specific name for that?
00:17:51.875 --> 00:17:53.755 The helmet that soldiers had.
00:17:52.205 --> 00:17:52.475 Or.
00:17:54.295 --> 00:17:57.600 Like the the you know like the the guys on the battlefield,
00:17:57.600 --> 00:18:00.796 they have a helmet. That's like it's not a hard hat, it's
00:18:00.796 --> 00:18:03.055 different, but it looks like a hard hat.
00:18:04.635 --> 00:18:06.785 Just battle helmet, yeah.
00:18:12.925 --> 00:18:13.415 That.
00:18:15.655 --> 00:18:17.585 Owners manual. I'm gonna keep that.
00:18:21.295 --> 00:18:24.906 Unit of measure each and this one. Wait. Actually, I have a
00:18:24.906 --> 00:18:28.759 question about this one because this one I can see it says it's
00:18:28.759 --> 00:18:30.385 all caps and one word each.
00:18:31.075 --> 00:18:33.445 But then this one see how it says EA.
00:18:36.285 --> 00:18:39.214 So what is the difference? Obviously I can there's there's
00:18:39.214 --> 00:18:42.391 a difference, but in terms of if you're importing, will that or
00:18:42.391 --> 00:18:45.370 something off if you have some listed as EA and then others
00:18:45.370 --> 00:18:46.115 listed as each.
00:18:47.725 --> 00:18:51.195 Go over to the.
00:18:52.675 --> 00:18:54.985 Pricing tab.
00:18:55.965 --> 00:18:59.265 No. Uh purchase shipping.
00:19:02.685 --> 00:19:08.071 Nope, I don't think it matters. It's really just kind of
00:19:08.071 --> 00:19:12.135 dependent on how their database is set up.
00:19:13.425 --> 00:19:16.265 Unless Shelton you have any thoughts on that piece?
00:19:17.695 --> 00:19:18.295 Or Kyle?
00:19:19.295 --> 00:19:20.695 If either of you are listening.
00:19:21.835 --> 00:19:26.105 What's the questions are as dense amounts.
00:19:26.935 --> 00:19:31.351 Listen, UM unit of measure on the product importer is that
00:19:31.351 --> 00:19:35.843 that one is actively filling out the unit of measure on the
00:19:35.843 --> 00:19:40.260 details editor. But in the product import description data
00:19:40.260 --> 00:19:44.452 we have each spelled out and capitalized but in unit of
00:19:44.452 --> 00:19:49.243 measure under a new product it shows as EA do you are am I safe
00:19:49.243 --> 00:19:53.885 to assume that these are the same fields and it's really just
00:19:53.885 --> 00:19:56.805 dependent on how their data is set up?
00:19:58.665 --> 00:20:01.395 Uh, yeah. Like I just went.
00:20:03.085 --> 00:20:08.772 Change the unit of measure for a Craig test product to each. For
00:20:08.772 --> 00:20:10.435 me A and it's just.
00:20:11.355 --> 00:20:13.365 It's just their data, OK?
00:20:11.465 --> 00:20:13.795 Now it is each. Yeah, yeah.
00:20:14.675 --> 00:20:15.055 Sweet.
00:20:15.035 --> 00:20:19.568 Yep, so that you doesn't have to be a. It can be anything
00:20:19.568 --> 00:20:20.585 basically so.
00:20:20.365 --> 00:20:21.655 OK, beautiful.
00:20:22.815 --> 00:20:23.445 Thank you, Sir.
00:20:25.825 --> 00:20:29.489 Other question, what are other units of measure that my guess
00:20:29.489 --> 00:20:32.445 clients use other than each? I've seen ones like.
00:20:32.995 --> 00:20:34.805 Hack case roll.
00:20:34.685 --> 00:20:36.625 Cases you.
00:20:35.995 --> 00:20:36.755 Box.
00:20:36.315 --> 00:20:37.745 Jesus, Niles.
00:20:41.105 --> 00:20:45.440 Just got to look at JBM. See all the unit of measure you wanted
00:20:42.855 --> 00:20:43.155 Yeah.
00:20:45.440 --> 00:20:45.915 to see.
00:20:49.705 --> 00:20:50.935 Description.
00:20:52.695 --> 00:20:56.135 I see we got a little. Uh, I know what this is. I know what
00:20:56.135 --> 00:20:57.855 this is, but it's escaping me.
00:21:00.845 --> 00:21:03.101 I've learned that this is in college and my information
00:21:03.101 --> 00:21:03.665 systems class.
00:21:05.475 --> 00:21:06.615 It's a little it's a.
00:21:07.525 --> 00:21:07.915 Ohh.
00:21:08.655 --> 00:21:09.365 Snippet.
00:21:09.135 --> 00:21:10.725 To pet it's a paragraph tag.
00:21:11.025 --> 00:21:12.825 Paragraph tag yes.
00:21:14.765 --> 00:21:16.795 So this shows up.
00:21:17.765 --> 00:21:18.725 Description.
00:21:20.615 --> 00:21:24.414 We have description and then short description and then
00:21:21.105 --> 00:21:21.575 Hey.
00:21:23.225 --> 00:21:23.875 Uh-huh.
00:21:24.414 --> 00:21:25.025 overview.
00:21:25.725 --> 00:21:28.279 And this is what we were talking about this morning, with Tom's
00:21:25.985 --> 00:21:26.505 Cactus.
00:21:28.279 --> 00:21:30.035 and being like, OK, which ones going where?
00:21:30.495 --> 00:21:31.295 Back to Seth.
00:21:36.195 --> 00:21:39.810 So where would you see description on here? Outside of
00:21:39.810 --> 00:21:41.585 short and long description?
00:21:42.955 --> 00:21:43.675 Here.
00:21:44.165 --> 00:21:44.465 Yep.
00:21:45.745 --> 00:21:49.253 And it has a paragraph tag, which means that that is
00:21:49.253 --> 00:21:53.424 something that is searchable by search engines. So whatever we
00:21:53.424 --> 00:21:57.595 put in there is something that will show up and be searchable.
00:21:59.095 --> 00:22:01.705 And it's it's in HTML.
00:22:04.415 --> 00:22:09.244 So you would do your P tag opening and closing brackets.
00:22:09.244 --> 00:22:12.125 It's not a required field, it is.
00:22:13.265 --> 00:22:18.160 Somewhat helpful, there are numerous uses for this across
00:22:18.160 --> 00:22:23.477 many many different projects, but if it's pretty standard most
00:22:23.477 --> 00:22:28.035 of the time description kind of falls by the wayside.
00:22:32.055 --> 00:22:32.395 OK.
00:22:35.755 --> 00:22:38.814 So this one kind of an optional field, this description one,
00:22:37.705 --> 00:22:38.145 Uh-huh.
00:22:38.814 --> 00:22:39.065 yeah.
00:22:39.625 --> 00:22:40.385 Correct.
00:22:40.815 --> 00:22:46.065 So for now, for this kitten, one to get a short description.
00:22:44.655 --> 00:22:45.445 Take it out.
00:22:47.135 --> 00:22:55.886 So this one is a specific set of characters. I believe that we
00:22:55.735 --> 00:22:56.405 55.
00:22:55.886 --> 00:22:58.665 can do 200 and 2555.
00:23:01.645 --> 00:23:03.085 No and no HTML.
00:23:01.795 --> 00:23:02.205 So we.
00:23:23.325 --> 00:23:25.035 My creative juices are not flowing.
00:23:28.125 --> 00:23:29.015 Yeah.
00:23:40.485 --> 00:23:42.205 Oh my God. I just heard it raining so hard.
00:23:42.705 --> 00:23:42.925 Hmm.
00:23:43.715 --> 00:23:46.659 It just started raining super hard. I hope that the
00:23:46.659 --> 00:23:50.283 thunderstorm doesn't start OK. Ohh fluffy battle kittens. Let's
00:23:50.283 --> 00:23:53.454 come up with this short description for these guys are.
00:23:53.454 --> 00:23:56.908 Wait are these are are these kittens sold individually or in
00:23:56.908 --> 00:23:57.475 a 12 pack?
00:23:58.155 --> 00:24:01.567 They are well, you tell me. You put the unit of measure in
00:24:01.567 --> 00:24:01.915 there.
00:24:02.325 --> 00:24:03.725 Each one at a time.
00:24:04.725 --> 00:24:05.555 Battle kitten.
00:24:11.955 --> 00:24:16.847 Fully battle ready and comes with aggressive teeth. I don't
00:24:16.847 --> 00:24:17.255 know.
00:24:18.795 --> 00:24:19.145 Thank you.
00:24:26.055 --> 00:24:26.685 He says.
00:24:30.055 --> 00:24:32.485 All right, now where does overview live?
00:24:33.475 --> 00:24:35.215 Overview labs.
00:24:39.015 --> 00:24:40.865 I know this one, I know this one.
00:24:40.645 --> 00:24:43.425 In your cursors in it if that helps.
00:24:42.605 --> 00:24:43.325 This.
00:24:44.255 --> 00:24:45.685 The long description.
00:24:46.505 --> 00:24:50.835 OK, what can I put in the long description that is different?
00:24:52.415 --> 00:24:53.695 You can do.
00:24:54.385 --> 00:24:56.075 You can do HTML in this.
00:24:56.285 --> 00:24:57.075 Mm-hmm.
00:24:58.935 --> 00:25:01.845 So I can use anything on this editor.
00:25:02.865 --> 00:25:03.665 Pop quiz.
00:25:03.115 --> 00:25:04.325 And no character limit.
00:25:05.165 --> 00:25:07.845 Correct. What does that editor called?
00:25:12.335 --> 00:25:13.465 Can iPhone a friend?
00:25:13.965 --> 00:25:14.345 Yep.
00:25:17.465 --> 00:25:18.495 Shelton, Kyle.
00:25:17.765 --> 00:25:18.065 I don't.
00:25:19.705 --> 00:25:20.305 Friends.
00:25:21.335 --> 00:25:22.045 Friends.
00:25:22.685 --> 00:25:23.395 Friends.
00:25:24.015 --> 00:25:28.135 It is it. Yeah. I'll give you a hint. It's the full name.
00:25:30.795 --> 00:25:31.145 It it.
00:25:32.515 --> 00:25:33.455 Acronym.
00:25:34.545 --> 00:25:37.605 Yes, it is an acronym for a very long.
00:25:36.445 --> 00:25:40.135 What you see, what you see is what you get.
00:25:41.225 --> 00:25:45.815 And if you put the 1st letter of those it spells out wizzywig.
00:25:48.955 --> 00:25:49.335 So.
00:25:50.045 --> 00:25:53.535 It's basically an HTML markup that you're able to do.
00:25:55.365 --> 00:26:00.405 It is basically you put anything you want in there and it will
00:26:00.405 --> 00:26:01.845 convert that text.
00:26:03.085 --> 00:26:06.877 To HTML code, so it'll do bold. It'll do italicize, don't
00:26:06.877 --> 00:26:10.735 underline bullets, all eggs, they just put it in there. So
00:26:10.735 --> 00:26:14.658 it's what you see is what you get on the site, basically so
00:26:14.658 --> 00:26:15.705 wizzywig editor.
00:26:16.905 --> 00:26:17.575 Wake at it.
00:26:17.955 --> 00:26:19.865 Hopefully it can just confuse you all even more.
00:26:20.855 --> 00:26:24.425 Uh, know you actually brought up another thing? Umm alaina.
00:26:25.375 --> 00:26:30.243 Do you happen to know if Wizzywig is in the glossary of
00:26:30.243 --> 00:26:30.765 terms?
00:26:31.605 --> 00:26:32.975 I haven't got to that part yet.
00:26:33.165 --> 00:26:33.855 Yeah. OK.
00:26:36.375 --> 00:26:38.675 So no, I will soon though.
00:26:36.395 --> 00:26:40.485 Let's go. Let's. Well, let's go check it.
00:26:41.865 --> 00:26:44.465 Amy, where would I find the glossary of terms?
00:26:48.725 --> 00:26:49.565 With with Jamie.
00:26:50.555 --> 00:26:55.105 Ah, whoever wants to answer in amylum.
00:26:50.595 --> 00:26:50.905 Me.
00:26:55.325 --> 00:26:56.425 A new clean now.
00:27:00.595 --> 00:27:01.915 That's an awfully good question.
00:27:03.025 --> 00:27:03.655 I know where.
00:27:03.175 --> 00:27:03.785 I don't know.
00:27:04.545 --> 00:27:05.235 No.
00:27:04.585 --> 00:27:06.215 The glossary of terms.
00:27:05.035 --> 00:27:06.385 Three terms.
00:27:06.655 --> 00:27:09.385 Well, let's help all of us out.
00:27:08.645 --> 00:27:10.575 It's in nuclino.
00:27:13.265 --> 00:27:17.608 We have a glossary of terms in here that is the common words
00:27:17.608 --> 00:27:21.738 that you're gonna hear often, and I don't see wizzywig in
00:27:21.738 --> 00:27:22.095 here.
00:27:22.835 --> 00:27:23.965 Sue.
00:27:29.235 --> 00:27:30.375 Wait, that's in here.
00:27:33.875 --> 00:27:35.925 The glossary of terms is in Nuclino.
00:27:36.095 --> 00:27:36.555 Ah.
00:27:39.715 --> 00:27:40.915 I would have spelled that.
00:27:41.985 --> 00:27:42.685 Way wrong.
00:27:45.095 --> 00:27:47.005 What you see is what you get.
00:27:52.075 --> 00:27:54.995 Oh, OK, now that I can see I'm like, OK.
00:28:00.985 --> 00:28:03.855 Wow, I can't spell. That was watching your screen.
00:28:04.275 --> 00:28:04.755 This is.
00:28:07.065 --> 00:28:07.955 It's too meta.
00:28:44.655 --> 00:28:45.165 Alright.
00:28:48.515 --> 00:28:48.985 Nice.
00:28:49.335 --> 00:28:50.115 Yay.
00:28:50.125 --> 00:28:52.035 Which see wig, right?
00:28:51.695 --> 00:28:52.645 Wizzywig.
00:28:53.005 --> 00:28:53.185 Yeah.
00:28:53.915 --> 00:28:57.565 OK, sorry. Side tangent again. Ha ha.
00:28:54.995 --> 00:28:55.625 Meat.
00:28:58.425 --> 00:29:01.299 That's what always happens. Whenever we do this, I don't
00:29:01.299 --> 00:29:03.215 think we ever get through a full one.
00:29:05.705 --> 00:29:09.535 Because I have the brain of a puppy seeing a squirrel.
00:29:10.985 --> 00:29:12.555 That's over there. What's that do?
00:29:16.025 --> 00:29:16.655 I.
00:29:17.335 --> 00:29:18.235 Listen here.
00:29:20.725 --> 00:29:23.318 Like that I wanted. I just want to see how that looks like once
00:29:23.318 --> 00:29:23.845 we import it.
00:29:24.455 --> 00:29:24.775 No.
00:29:24.635 --> 00:29:28.032 Into the long description. So that's just more of a little
00:29:28.032 --> 00:29:29.415 testy thing for me, but.
00:29:28.365 --> 00:29:32.835 OK, well, if you want a deep dive on how to do some HTML.
00:29:34.565 --> 00:29:35.955 Squirrely iness let me know.
00:29:37.565 --> 00:29:38.195 Sure.
00:29:39.095 --> 00:29:43.005 Images should we find an image of a fully punkin?
00:29:49.335 --> 00:29:53.125 Because let me see.
00:29:54.775 --> 00:29:55.905 Hey, let me see something.
00:29:59.455 --> 00:29:59.975 Hold on.
00:30:04.995 --> 00:30:05.415 No.
00:30:06.485 --> 00:30:07.195 We should not.
00:30:08.905 --> 00:30:11.655 Because it needs to be, um.
00:30:14.005 --> 00:30:18.501 A URL. So if we go and find like and just download one, it would
00:30:18.501 --> 00:30:22.514 effectively be on our local computers, so you wouldn't be
00:30:18.525 --> 00:30:18.895 Umm.
00:30:22.514 --> 00:30:27.011 able to click the link, it would just open it an image editor or
00:30:27.011 --> 00:30:31.508 your whatever your image program is, rather than being a browser
00:30:31.508 --> 00:30:36.004 link, so it has to be something that if you click it, it opens a
00:30:36.004 --> 00:30:36.835 browser tab.
00:30:37.615 --> 00:30:39.205 And I think that Google.
00:30:37.905 --> 00:30:38.475 Umm.
00:30:40.655 --> 00:30:44.405 Has effectively blocked that nonsense because of copyright.
00:30:49.975 --> 00:30:53.065 Spies material color, height, height, unit of measure.
00:30:54.325 --> 00:30:54.575 Matt.
00:30:54.715 --> 00:30:57.795 Phil is cat, can we say can we say meat?
00:30:54.925 --> 00:30:56.645 With yeah, I put that.
00:31:03.175 --> 00:31:05.625 OK, I'm, I'm done. I'm sorry. Carry on.
00:31:06.135 --> 00:31:07.785 But I have to say this is getting out of hand.
00:31:09.525 --> 00:31:10.705 I was gonna put feline.
00:31:13.505 --> 00:31:13.895 Alright.
00:31:15.805 --> 00:31:19.318 Color, height, unit of measure, width with unit of measure,
00:31:19.318 --> 00:31:21.075 depth, depth, unit of measure.
00:31:22.225 --> 00:31:24.615 What is the purpose of all of this?
00:31:26.735 --> 00:31:27.355 Shipping.
00:31:28.395 --> 00:31:29.005 Yes.
00:31:28.815 --> 00:31:29.205 Right.
00:31:29.845 --> 00:31:30.565 Hell yeah.
00:31:29.965 --> 00:31:31.545 Yeah, nice. Nice one.
00:31:30.035 --> 00:31:30.905 Yeah.
00:31:33.205 --> 00:31:36.695 I paid attention look a little bit.
00:31:34.805 --> 00:31:36.415 Hell yeah. Good job.
00:31:42.195 --> 00:31:44.675 Trade. Oh yeah, these are all for shipping.
00:31:44.705 --> 00:31:45.195 Mm-hmm.
00:31:45.465 --> 00:31:47.695 We are we gonna be shipping these these kittens?
00:31:48.005 --> 00:31:48.405 Yeah.
00:31:48.115 --> 00:31:49.505 How would you ship this?
00:31:51.265 --> 00:31:52.755 In a box.
00:31:55.955 --> 00:31:58.623 It'll have holes. That's fine. They're fine. They're battle
00:31:58.623 --> 00:31:58.935 tested.
00:32:01.735 --> 00:32:05.389 Bulleted specs. Ohh wait. No. Let's talk about these digital
00:32:05.389 --> 00:32:08.505 download. Can we digitally download these cats? No.
00:32:11.335 --> 00:32:18.721 What would be a use case for a client having a digital download
00:32:18.721 --> 00:32:19.645 product?
00:32:19.835 --> 00:32:20.695 An ebook.
00:32:21.655 --> 00:32:22.265 OK.
00:32:23.345 --> 00:32:24.815 But digital survey?
00:32:23.535 --> 00:32:23.995 With the.
00:32:25.575 --> 00:32:29.155 What other step would we need to take?
00:32:29.845 --> 00:32:31.935 For a digital download product.
00:32:34.595 --> 00:32:38.629 To make sure that it plays well within safe and they're not
00:32:38.629 --> 00:32:39.705 getting charged.
00:32:40.255 --> 00:32:40.935 Nothing to share.
00:32:41.875 --> 00:32:42.415 Good job.
00:32:44.265 --> 00:32:44.625 Nice.
00:32:45.085 --> 00:32:47.195 You wanna share where that lives?
00:32:47.725 --> 00:32:48.255 Yeah.
00:32:50.965 --> 00:32:51.725 Shipping.
00:32:52.775 --> 00:32:55.205 Fire shipping. Nothing to ship.
00:32:55.375 --> 00:33:00.291 And for for for bonus credit. If somebody can show me where that
00:32:55.595 --> 00:32:56.285 Hell yeah.
00:33:00.291 --> 00:33:03.165 downloadable product would be stored.
00:33:03.775 --> 00:33:05.135 Ooh.
00:33:08.615 --> 00:33:10.485 OK, let me think, let me think.
00:33:12.315 --> 00:33:15.975 The Arthy coming from Kyle Love that.
00:33:17.735 --> 00:33:21.260 I just know what hangs me up or what did hang me up when I first
00:33:21.260 --> 00:33:23.755 started learning about downloadable products.
00:33:25.375 --> 00:33:25.915 Ohh.
00:33:28.115 --> 00:33:29.335 I have no idea.
00:33:32.245 --> 00:33:35.507 I'm gonna phone a friend because, Kyle, I don't know
00:33:35.507 --> 00:33:35.815 this.
00:33:38.945 --> 00:33:40.475 You exploded by brain.
00:33:39.065 --> 00:33:42.193 Ohh man, I'm sorry this is a trick question. He doesn't have
00:33:42.193 --> 00:33:45.015 it turned on here. You have to save the product first.
00:33:46.065 --> 00:33:48.711 That's my bad. It's stored files, it's the stored files
00:33:47.545 --> 00:33:47.975 Ohh.
00:33:48.711 --> 00:33:51.735 tab. It's not turned on case you haven't saved the product yet.
00:33:52.185 --> 00:33:55.415 Ohh, got it. OK, so if we go.
00:33:52.615 --> 00:33:53.165 That's my bad.
00:33:52.735 --> 00:33:53.515 Umm.
00:33:54.495 --> 00:33:56.935 I was. I just knew you were in the product editor and I just
00:33:56.935 --> 00:33:58.415 didn't see my screen. That's my bad.
00:33:59.135 --> 00:34:02.721 No, no, no, that's that's good. Just open any one of those, it
00:33:59.455 --> 00:34:00.155 Your question.
00:34:02.721 --> 00:34:03.575 doesn't matter.
00:34:07.375 --> 00:34:07.695 Ohh.
00:34:10.225 --> 00:34:10.565 Ohh.
00:34:10.495 --> 00:34:11.475 There's no that turned on.
00:34:12.265 --> 00:34:12.725 Nope.
00:34:14.075 --> 00:34:14.785 OK.
00:34:14.535 --> 00:34:14.985 Well.
00:34:15.665 --> 00:34:18.915 Hey. No, that's excellent. So.
00:34:19.735 --> 00:34:24.523 What that says is if we have a client that has digital products
00:34:24.523 --> 00:34:28.862 that need to be downloaded, there are three steps that we
00:34:28.862 --> 00:34:29.835 have to take.
00:34:30.995 --> 00:34:35.533 There is an app setting to turn on stored files within the
00:34:35.533 --> 00:34:40.455 products they have to mark it as non shippable and it has to be
00:34:40.455 --> 00:34:43.225 marked for yes as digital download.
00:34:46.165 --> 00:34:49.244 And then they have to upload the file of whatever it is to the
00:34:49.244 --> 00:34:50.955 stored files content within there.
00:34:52.385 --> 00:34:53.105 Clear as mud?
00:34:56.715 --> 00:34:59.868 The step two and three are clear. Number one is where I'm
00:34:59.868 --> 00:35:01.825 like just cause I'm I can't see it.
00:35:01.965 --> 00:35:05.715 Because we can't see it. Yep. So there's an app setting which is
00:35:05.715 --> 00:35:06.985 done in the code base.
00:35:08.845 --> 00:35:13.542 To have stored files, there's an entity in there that is just
00:35:13.542 --> 00:35:18.088 called. Stored files that by default is set to false on the
00:35:18.088 --> 00:35:18.695 product.
00:35:20.345 --> 00:35:24.951 Table and so we have to have a developer go in. No, we don't
00:35:24.951 --> 00:35:29.181 anymore, do we? It's an app setting. Ohh, we're getting
00:35:29.181 --> 00:35:33.335 squirrely. Go up to inventory. Click on the drop down.
00:35:36.145 --> 00:35:41.710 Uh, Nope, sorry. Inventory. Yep. There you go. We are gonna go
00:35:41.710 --> 00:35:41.975 to.
00:35:43.025 --> 00:35:44.275 Where the app settings.
00:35:46.385 --> 00:35:47.655 Uh site maintenance.
00:35:52.735 --> 00:35:55.295 Ah, settings.
00:35:58.655 --> 00:36:02.775 Yeah, click on or start to type.
00:36:04.515 --> 00:36:06.205 Product dot.
00:36:11.555 --> 00:36:11.975 OK.
00:36:13.765 --> 00:36:15.695 Upload files.
00:36:16.685 --> 00:36:20.965 Import stored products allow save with store.
00:36:21.735 --> 00:36:22.185 Wait, no.
00:36:25.795 --> 00:36:26.285 Some of it.
00:36:31.915 --> 00:36:36.111 OK, remove product and just no, it wouldn't be digital download,
00:36:36.111 --> 00:36:38.435 would it? It would be stored files.
00:36:47.285 --> 00:36:48.375 Type stored.
00:37:00.255 --> 00:37:00.995 Start.
00:37:03.005 --> 00:37:06.545 URL allowed to path look up method which you URL.
00:37:10.375 --> 00:37:12.375 Nope, that one's gonna be above my head.
00:37:15.325 --> 00:37:16.155 I'm not going to go there.
00:37:18.465 --> 00:37:21.335 We'll still need a developer to turn on the app setting.
00:37:22.415 --> 00:37:25.035 And tell the UI is.
00:37:26.315 --> 00:37:27.205 Human readable.
00:37:30.925 --> 00:37:32.605 Back to the sheet.
00:37:32.395 --> 00:37:35.385 Back to this sheet. Sorry about that tangent.
00:37:38.425 --> 00:37:38.835 OK.
00:37:38.645 --> 00:37:41.975 Notes. I know this one not a required field, but then.
00:37:41.655 --> 00:37:42.145 Nope.
00:37:41.955 --> 00:37:42.325 Now.
00:37:43.285 --> 00:37:46.450 Notes are is that also an attribute because it's not. It's
00:37:46.450 --> 00:37:48.865 something that if they wanted to include it.
00:37:49.695 --> 00:37:51.075 But it's not really something that's.
00:37:51.905 --> 00:37:52.725 Standard.
00:37:53.525 --> 00:37:54.525 Exactly.
00:37:58.025 --> 00:38:00.915 Well, it expects. This is also an attribute, correct?
00:38:00.595 --> 00:38:01.965 Mm-hmm. Correct.
00:38:05.145 --> 00:38:06.365 A lot of stuff.
00:38:12.155 --> 00:38:12.775 OK.
00:38:13.705 --> 00:38:16.195 What else do y'all stop quantity?
00:38:18.185 --> 00:38:19.155 There's twelve of us.
00:38:18.215 --> 00:38:18.565 Well.
00:38:26.535 --> 00:38:31.741 SEO URL. I know this is a required field and it has to be.
00:38:31.741 --> 00:38:36.507 It can't be any special characters and no spaces only
00:38:36.507 --> 00:38:37.125 dashes.
00:38:38.275 --> 00:38:43.441 But we don't have any SEO and we're not actively getting our
00:38:43.441 --> 00:38:43.865 site.
00:38:46.045 --> 00:38:49.335 With any marketing, so why do I need that? What does it do?
00:38:50.455 --> 00:38:53.755 That is how the page itself will be able to display.
00:38:55.025 --> 00:38:58.525 With without this info then it the page has something like. The
00:38:58.525 --> 00:38:59.565 URL has nothing to.
00:39:00.785 --> 00:39:03.207 I know the answer, I just don't know how to explain it like I
00:39:03.207 --> 00:39:03.755 know why it's.
00:39:03.575 --> 00:39:08.165 Yeah, you're right there. Can you pull up?
00:39:08.885 --> 00:39:12.335 Uh browser tab and show me where it would be.
00:39:13.245 --> 00:39:13.505 Hmm.
00:39:15.485 --> 00:39:19.110 Just any old browser tab and just show me where the SEO URL
00:39:19.110 --> 00:39:19.775 appends to.
00:39:21.975 --> 00:39:24.315 So like if you go to Tom's.
00:39:22.405 --> 00:39:22.805 OK.
00:39:27.205 --> 00:39:30.195 Now, if I'm gonna have a product pulled up.
00:39:33.955 --> 00:39:34.665 This.
00:39:36.505 --> 00:39:37.205 Sort of.
00:39:37.895 --> 00:39:41.285 But what is the actual thing that we're typing in there?
00:39:43.945 --> 00:39:45.685 Yeah. There you go. You got it.
00:39:46.425 --> 00:39:47.355 This part.
00:39:47.785 --> 00:39:48.205 Right.
00:39:49.035 --> 00:39:54.515 So it is appended to the end of the domain.
00:39:55.995 --> 00:40:00.455 So that it has a page to display. So if you think of a
00:40:00.455 --> 00:40:05.564 URL in terms of bread crumbs, you can see that we are in Tom's
00:40:05.564 --> 00:40:10.673 truck clarity client.com. The next group is the forward slash.
00:40:10.673 --> 00:40:15.377 So we're in the products and then it's telling us exactly
00:40:15.377 --> 00:40:20.081 where we're at within the products. So it's giving us the
00:40:20.081 --> 00:40:23.325 page that it needs to display. So it's.
00:40:25.335 --> 00:40:29.657 It's working almost like a map to tell us how we got to where
00:40:29.657 --> 00:40:34.049 we are and how it's displaying. So if we go back one, it would
00:40:34.049 --> 00:40:38.093 be just the products kind of thing. So now we're just in,
00:40:38.093 --> 00:40:41.997 well now we're in categories because we went to the the
00:40:41.997 --> 00:40:42.625 category.
00:40:44.465 --> 00:40:48.405 So because of the the way that our site is structured, we have
00:40:48.405 --> 00:40:52.157 like the categories and then we have the individual product
00:40:52.157 --> 00:40:55.722 details page. So there's no products listing necessarily
00:40:55.722 --> 00:40:59.725 where it just shows all of the products outside of the category
00:40:59.725 --> 00:41:03.540 structure. But overall, if you think about the URLs that you
00:41:03.540 --> 00:41:07.481 see when you go to Amazon for example and it's this long thing
00:41:07.481 --> 00:41:11.608 and I'm sure we've all clicked a link like you can see the one in
00:41:11.608 --> 00:41:13.235 the chat here for nuclino.
00:41:13.795 --> 00:41:18.472 It's nuclino and then clarity team and then clarity and then
00:41:18.472 --> 00:41:23.303 PM glossary of terms. So it's giving bread crumbs of basically
00:41:23.303 --> 00:41:27.827 how we got to what it is we're trying to display. So it is
00:41:27.827 --> 00:41:32.811 required on every product or the search engine, the browser will
00:41:32.811 --> 00:41:37.565 not know how to get to it. That is a huge pitfall for people.
00:41:38.435 --> 00:41:40.645 They tend to hear SEO.
00:41:41.685 --> 00:41:44.913 And they think that that means Google Analytics. They think
00:41:44.913 --> 00:41:48.250 that that means marketing. They think that that means driving
00:41:48.250 --> 00:41:49.865 organic traffic to their site.
00:41:51.025 --> 00:41:55.534 It's really that we need the URL. It works for all of those
00:41:55.534 --> 00:41:59.366 things and it should be formatted in a way that is
00:41:59.366 --> 00:42:01.095 friendly, but it's not.
00:42:02.085 --> 00:42:04.795 It's not. It's only purpose. UM.
00:42:05.985 --> 00:42:10.386 The name is a little bit of a misnomer, so we just have to
00:42:10.386 --> 00:42:14.787 remember that and be able to explain to a client that it's
00:42:14.787 --> 00:42:19.263 because we need to have a page that it can go to, so it's a
00:42:19.263 --> 00:42:23.888 pending. The details of this to the end of the URL. So in the
00:42:23.888 --> 00:42:28.066 case of Toms or no, it wasn't Toms, it was was that PCs
00:42:28.066 --> 00:42:29.185 yesterday, Amy.
00:42:29.885 --> 00:42:31.665 MI think it was PCs.
00:42:33.045 --> 00:42:34.065 They they.
00:42:33.535 --> 00:42:35.185 Sorry, I was muted. Yeah.
00:42:35.015 --> 00:42:39.425 That they had a a tiny panic attack about the SEO URL.
00:42:40.105 --> 00:42:44.050 And they were trying to get out of it. And I was like, no, like,
00:42:44.050 --> 00:42:47.693 these are the reasons why we have to have this. And they're
00:42:47.693 --> 00:42:51.517 like, well, we don't have any SEO. We don't wanna do that. And
00:42:51.517 --> 00:42:55.402 I was like, OK, well, it can be as simple as the product key or
00:42:55.402 --> 00:42:59.105 the lot number. It doesn't have to be this big long drug out
00:42:59.105 --> 00:43:02.930 thing. They're just has to be something there and it has to be
00:43:02.930 --> 00:43:03.355 unique.
00:43:04.045 --> 00:43:04.765 So.
00:43:05.605 --> 00:43:09.223 It's it's important because if we have two of the same SEO URL,
00:43:09.223 --> 00:43:12.727 your browser's gonna crash every time because it doesn't know
00:43:12.727 --> 00:43:13.915 which one to display.
00:43:16.305 --> 00:43:20.143 So it just has to be unique and it has to be there, but we don't
00:43:20.143 --> 00:43:22.565 really care what it is unless they have.
00:43:23.935 --> 00:43:27.759 A major push for marketing and Google Analytics and driving
00:43:27.759 --> 00:43:31.902 traffic and all of that kind of stuff, in which case from the PM
00:43:31.902 --> 00:43:36.109 side of things, extra credit for anybody who wants to tell me how
00:43:36.109 --> 00:43:39.105 we would go ahead and drive that conversation.
00:43:45.625 --> 00:43:47.615 You can phone a friend. It can be me.
00:43:45.915 --> 00:43:47.905 Was the what was the question?
00:43:48.305 --> 00:43:51.055 The question is if somebody is very.
00:43:51.945 --> 00:43:55.905 Interested in SEO and driving organic traffic in Google
00:43:55.905 --> 00:44:00.220 Analytics and how to set up their SEO URL and their keywords
00:44:00.220 --> 00:44:04.676 and all of that fun stuff. What would? What would we as PMS do
00:44:04.676 --> 00:44:06.515 to help them through that?
00:44:08.445 --> 00:44:09.015 Who?
00:44:12.075 --> 00:44:12.785 Beats me.
00:44:14.975 --> 00:44:15.575 Stephanie.
00:44:16.555 --> 00:44:17.005 Yeah.
00:44:17.255 --> 00:44:18.895 Were found. We're phoning you.
00:44:17.455 --> 00:44:18.345 Shelton.
00:44:17.685 --> 00:44:18.145 She.
00:44:19.165 --> 00:44:22.438 Yeah, exactly. No, that's that's a fair and legit answer.
00:44:22.438 --> 00:44:23.455 Shelton, go ahead.
00:44:23.995 --> 00:44:27.465 I'll just say introduced into Stephanie, that's my. That's
00:44:27.465 --> 00:44:28.465 what you do, but.
00:44:28.435 --> 00:44:29.265 Good answer.
00:44:31.945 --> 00:44:37.339 And I am going to in turn turn around and say I can help you. I
00:44:37.339 --> 00:44:40.795 can get you to be a D + C minus student.
00:44:42.275 --> 00:44:46.155 But I have somebody that can get you to an A+. So let's get you a
00:44:46.155 --> 00:44:49.859 better GPA. I'm gonna move you over to our SEO guru. I'm gonna
00:44:49.859 --> 00:44:53.622 get you in touch with Ron, and he's gonna walk you through some
00:44:53.622 --> 00:44:56.855 formatting on all of these things to really drive your
00:44:56.855 --> 00:45:00.383 products forward so that you're getting the best traffic in
00:45:00.383 --> 00:45:00.795 Google.
00:45:02.475 --> 00:45:03.855 Ron is the answer.
00:45:04.245 --> 00:45:04.855 Ron.
00:45:07.165 --> 00:45:10.381 But you are always welcome to start with me because I can get
00:45:10.381 --> 00:45:11.315 them to a C minus.
00:45:17.005 --> 00:45:18.355 To a sea minus.
00:45:19.995 --> 00:45:24.053 Hey, for DNN training, I tell folks I'll get them to a B minus
00:45:24.053 --> 00:45:28.047 or even a B, but if they want a plus score they need to go to
00:45:28.047 --> 00:45:28.885 the youtubes.
00:45:35.135 --> 00:45:36.045 The youtubes.
00:45:36.435 --> 00:45:37.325 The youtubes.
00:45:42.075 --> 00:45:45.960 I want to Brandon's joke earlier and he was like, there's this
00:45:45.960 --> 00:45:49.045 thing called YouTube you can, like, watch recaps.
00:45:49.445 --> 00:45:52.974 Listen, I just don't. I don't like to do that because if I
00:45:52.974 --> 00:45:56.025 watch the last episode of something, the odds are.
00:45:57.265 --> 00:46:00.523 To me, that story's closed, and I'm never coming back to this
00:46:00.523 --> 00:46:03.623 series as so many series that I've watched like one to two
00:46:03.623 --> 00:46:05.305 seasons of and just walked away.
00:46:06.485 --> 00:46:07.255 I couldn't.
00:46:06.735 --> 00:46:07.135 So.
00:46:06.855 --> 00:46:10.493 So did you dislike wait eight years, though, watch Game of
00:46:10.493 --> 00:46:12.405 Thrones until listen off Anish.
00:46:11.675 --> 00:46:12.625 All done.
00:46:12.385 --> 00:46:15.675 OK. Listen, I have never watched Game of Thrones.
00:46:15.755 --> 00:46:17.985 Ah, what?
00:46:16.195 --> 00:46:17.475 That's that's fine.
00:46:18.605 --> 00:46:20.955 I refuse. I won't do it.
00:46:20.045 --> 00:46:21.725 Have you watched you watch House of Dragon?
00:46:22.435 --> 00:46:22.835 How?
00:46:22.605 --> 00:46:22.875 No.
00:46:24.025 --> 00:46:26.035 House of Dragon, in my opinion, better.
00:46:27.955 --> 00:46:30.725 While the Game of Thrones ending just uh.
00:46:27.975 --> 00:46:29.315 Is it complete?
00:46:30.685 --> 00:46:31.835 No, it's not complete.
00:46:31.475 --> 00:46:32.425 Wasn't great.
00:46:31.975 --> 00:46:34.085 Then I'm not. I'm not interested yet.
00:46:33.935 --> 00:46:37.985 Game of Thrones is complete. This that's a that's a spin off.
00:46:36.215 --> 00:46:37.525 I know and I've.
00:46:38.375 --> 00:46:41.827 I know, and I've heard so much ******** about the end of it
00:46:41.827 --> 00:46:45.279 because everybody likes to talk all the time that I have no
00:46:45.279 --> 00:46:48.674 desire. I'm just like me. It's the same reason why I won't
00:46:48.674 --> 00:46:49.595 watch Star Wars.
00:46:49.985 --> 00:46:53.955 As the poor man's uh Lord of the rings, sorry.
00:46:53.075 --> 00:46:55.275 What do you have against Star Wars?
00:46:55.195 --> 00:46:57.942 You've never watched Star Wars? I thought it was the only person
00:46:57.005 --> 00:46:59.075 What's your beef with Star Wars?
00:46:57.942 --> 00:46:59.845 left on Earth that hadn't watched Star Wars.
00:47:00.455 --> 00:47:03.075 I also haven't watched Star Wars or tried to.
00:47:00.725 --> 00:47:01.115 I.
00:47:02.335 --> 00:47:03.345 You haven't seen it either.
00:47:03.795 --> 00:47:06.862 No, but my boyfriend's obsessed. So he's, like, you want to watch
00:47:04.555 --> 00:47:04.805 Ah.
00:47:05.785 --> 00:47:06.675 That's awesome.
00:47:06.862 --> 00:47:08.025 Star Wars? I've like, no.
00:47:08.595 --> 00:47:09.685 I love Star Wars.
00:47:08.625 --> 00:47:11.512 There's only a very small band of us left that have not seen
00:47:11.512 --> 00:47:12.175 Star Wars, so.
00:47:12.145 --> 00:47:12.975 Umm.
00:47:13.075 --> 00:47:14.825 We need to hold, hold it strong, ladies.
00:47:15.355 --> 00:47:19.099 Ohh, you won't ever catch me. I've I've tried. I've tried
00:47:18.705 --> 00:47:20.615 I tried to it was it was terrible.
00:47:19.099 --> 00:47:23.295 numerous times. I've fall asleep within 1015 minutes every time.
00:47:23.735 --> 00:47:24.605 I did too.
00:47:23.795 --> 00:47:24.785 UM.
00:47:26.575 --> 00:47:27.065 So.
00:47:26.685 --> 00:47:28.945 Sorry, I was in the era of love hating.
00:47:30.255 --> 00:47:33.787 And that's set. I'm the second generation Star Wars movie
00:47:30.345 --> 00:47:30.905 Love it.
00:47:33.787 --> 00:47:37.625 lover, and everyone doesn't like those as much, but love them.
00:47:38.625 --> 00:47:41.124 Everybody tells like tells like if you haven't seen it,
00:47:38.725 --> 00:47:39.655 I mean that's fair.
00:47:41.124 --> 00:47:44.026 everybody says you need to watch it now because, like, we could,
00:47:44.026 --> 00:47:46.749 like choose the order we watch it in. We could like pick the
00:47:46.749 --> 00:47:49.606 newer ones and watch it in like the chronological. Or you could
00:47:49.606 --> 00:47:52.150 watch it in like the the original way they came out. And
00:47:52.150 --> 00:47:54.873 people have, like, very big opinions on the way to watch it.
00:47:54.455 --> 00:47:55.185 I mean, that's.
00:47:54.873 --> 00:47:55.945 If you've never seen it.
00:47:56.185 --> 00:47:58.999 That's an argument is all this time, like, that's the whole
00:47:56.605 --> 00:47:57.075 Barry.
00:47:58.999 --> 00:48:01.860 thing with the Chronicles of Narnia and the book order, it's
00:48:01.860 --> 00:48:02.095 fine.
00:48:03.825 --> 00:48:05.055 Made it this far in life.
00:48:07.495 --> 00:48:11.205 OK, what does SEO page title do?
00:48:13.715 --> 00:48:15.655 That I know that's over here.
00:48:19.735 --> 00:48:20.375 This.
00:48:21.515 --> 00:48:21.875 OK.
00:48:22.405 --> 00:48:27.330 Used by the browser tab and search engines, so this this
00:48:25.985 --> 00:48:27.775 OK. What? What's that? What's that do?
00:48:27.330 --> 00:48:27.935 format.
00:48:29.955 --> 00:48:33.939 So look up right where you see the tab for the PM glossary of
00:48:33.939 --> 00:48:34.325 terms.
00:48:34.875 --> 00:48:39.065 Ohh, this that's what we'll show up there. Ohh OK.
00:48:36.675 --> 00:48:36.925 Yeah.
00:48:38.525 --> 00:48:38.925 Uh-huh.
00:48:39.585 --> 00:48:43.467 Instead of how you see our stuff admin one where it gives you
00:48:43.467 --> 00:48:44.845 like the bread crumbs.
00:48:45.215 --> 00:48:45.605 Uh-huh.
00:48:47.195 --> 00:48:51.065 You control what the browser tab display looks like by entering
00:48:51.065 --> 00:48:52.215 the title in there.
00:48:52.745 --> 00:48:53.465 Ah.
00:48:54.145 --> 00:48:54.895 Me at.
00:48:57.595 --> 00:48:58.555 This good day.
00:49:18.455 --> 00:49:18.985 Now.
00:49:19.815 --> 00:49:23.781 I usually have so many tabs open that I forget what that looks
00:49:23.781 --> 00:49:25.545 like. All I see is favicons.
00:49:37.425 --> 00:49:41.295 And I get poked fun at from the doves because of my tab usage.
00:49:43.255 --> 00:49:44.025 So.
00:49:45.455 --> 00:49:50.184 You remember when I was making a joke about calling Jonathan
00:49:50.184 --> 00:49:55.068 Fernandez? Jonathan Hernandez cause of Himie for ohm? I set up
00:49:51.455 --> 00:49:51.795 Umm.
00:49:53.095 --> 00:49:54.085 Hi me. Hi me.
00:49:55.068 --> 00:50:00.029 his his user for their staging side as Jonathan Hernandez. So I
00:50:00.029 --> 00:50:04.293 had to go quickly change it, cause I sent the Basecamp
00:50:04.293 --> 00:50:08.635 message and had his name wrong in it. So I did in fact.
00:50:09.565 --> 00:50:12.165 How was the one making the joke and I ended up doing it.
00:50:13.235 --> 00:50:14.515 Ah.
00:50:13.285 --> 00:50:13.675 So.
00:50:16.995 --> 00:50:20.786 That's OK. I discovered today that whoever set up the base
00:50:20.786 --> 00:50:24.835 camp for ABS and that client has been around for like 5 years.
00:50:26.825 --> 00:50:29.235 The OK at the end of Mark is capitalized.
00:50:34.115 --> 00:50:36.345 He is never called it out to correct it.
00:50:40.535 --> 00:50:45.424 Well, after after Craig no names did. I mean it's anybody can be
00:50:45.424 --> 00:50:47.455 named anything. I wouldn't.
00:50:49.125 --> 00:50:50.165 And put it past them.
00:50:51.235 --> 00:50:54.648 I don't understand cause high his name's Hyme, but his
00:50:51.285 --> 00:50:51.965 Correct.
00:50:54.648 --> 00:50:56.635 coworkers are calling him Jamie.
00:50:58.565 --> 00:51:01.555 I noticed that too in in that meeting.
00:51:00.005 --> 00:51:04.377 Yeah. Jonathan was calling him Jamie. I'm like, I'm taking all
00:51:03.535 --> 00:51:04.815 And he said he's been.
00:51:04.377 --> 00:51:04.725 this.
00:51:05.575 --> 00:51:08.672 He's been there for 15 years, so like, he's been working with him
00:51:05.845 --> 00:51:06.525 Yeah.
00:51:08.672 --> 00:51:10.785 for 15 years and calling him the wrong name.
00:51:12.195 --> 00:51:14.895 You know, sometimes it's too late and you just can't correct.
00:51:17.855 --> 00:51:21.115 OK. Is our our import sheets all filled out?
00:51:21.525 --> 00:51:22.365 Yes.
00:51:23.235 --> 00:51:23.955 Do you wear it?
00:51:26.745 --> 00:51:28.345 Tell me what you're doing though I'm 5.
00:51:30.025 --> 00:51:31.695 Where'd you go? What are we doing? What? What?
00:51:30.485 --> 00:51:34.625 Hello Hello, 5 year old. Stephanie. I saved the file and
00:51:34.625 --> 00:51:35.425 now I went.
00:51:36.065 --> 00:51:39.662 Back in December, Admin and I clicked the import products and
00:51:39.662 --> 00:51:42.853 using the sheet that I downloaded from here and that I
00:51:42.853 --> 00:51:46.508 filled out accordingly with all the required fields, I'm going
00:51:46.508 --> 00:51:48.945 to drag and drop the save file into here.
00:51:50.585 --> 00:51:51.675 Ohh.
00:51:51.765 --> 00:51:52.075 Uh.
00:51:53.205 --> 00:51:54.555 What's that do?
00:51:56.785 --> 00:51:58.345 Please give me this. Why is it not green?
00:52:00.775 --> 00:52:02.015 Well, let's look at our name.
00:52:09.815 --> 00:52:11.245 Try and take out the 10.
00:52:12.435 --> 00:52:12.925 Ah.
00:52:23.865 --> 00:52:26.085 Oh, my God. Where is my computer being whack?
00:52:47.615 --> 00:52:50.465 Oh my God. My computer is just bugging out. Hold on.
00:52:51.455 --> 00:52:52.195 Umm.
00:52:51.925 --> 00:52:53.405 I'm trying to rename it and it's just.
00:52:54.365 --> 00:52:55.135 Pooping. It's all.
00:52:58.645 --> 00:53:01.921 Now that is not the proper way to describe that in a client
00:53:01.921 --> 00:53:02.195 call.
00:53:02.725 --> 00:53:05.175 Ohh no. Yeah, of course not. I would never.
00:53:05.835 --> 00:53:07.835 So we're having technical difficulties.
00:53:10.435 --> 00:53:12.095 OK. If I just take the turn out.
00:53:15.675 --> 00:53:16.975 How it's because I have it open.
00:53:18.225 --> 00:53:18.555 Mm-hmm.
00:53:20.975 --> 00:53:22.275 No. Should Amy come on.
00:53:25.705 --> 00:53:27.135 OK, I won't touch you.
00:53:29.025 --> 00:53:29.955 You're tired, right?
00:53:30.545 --> 00:53:31.105 So.
00:53:34.725 --> 00:53:38.273 Miss Bonnie is when she's sleepy. She does not want you to
00:53:35.095 --> 00:53:35.445 OK.
00:53:38.273 --> 00:53:38.875 touch her.
00:53:43.275 --> 00:53:49.000 Alright, so it uploaded that time and it imported super quick
00:53:49.000 --> 00:53:50.755 without any errors.
00:53:51.475 --> 00:53:54.015 Sue or let's go see our kittens.
00:54:11.895 --> 00:54:12.365 What the heck?
00:54:13.245 --> 00:54:13.695 Critical.
00:54:21.035 --> 00:54:22.685 Like that imported awful quick.
00:54:27.435 --> 00:54:28.155 So.
00:54:29.125 --> 00:54:32.335 Let's go back and take a look at it. Open up the file again.
00:54:41.315 --> 00:54:45.162 Usually if it goes that quickly, there's something something
00:54:45.162 --> 00:54:46.045 wonky with it.
00:54:46.905 --> 00:54:50.143 Alright, so we've got our name, we've got active, we've got
00:54:50.143 --> 00:54:50.575 visible.
00:54:51.505 --> 00:54:52.905 We have a category.
00:54:54.035 --> 00:54:55.145 Custom key.
00:54:57.875 --> 00:54:59.285 We have the price.
00:55:04.805 --> 00:55:08.895 We have short description. We've got the long description.
00:55:08.975 --> 00:55:10.145 And.
00:55:12.085 --> 00:55:12.515 Image.
00:55:12.595 --> 00:55:15.215 And size.
00:55:22.565 --> 00:55:23.425 Well, that was weird.
00:55:23.865 --> 00:55:24.455 Umm.
00:55:27.035 --> 00:55:28.115 That's weird me out.
00:55:30.195 --> 00:55:33.945 OK, so it looks good from what I can see.
00:55:40.855 --> 00:55:41.485 Let's.
00:55:41.045 --> 00:55:43.495 I just. I just wanna see if it's.
00:55:47.725 --> 00:55:47.955 No.
00:55:47.995 --> 00:55:48.165 No.
00:55:50.365 --> 00:55:53.075 So it errored out on something.
00:55:55.085 --> 00:55:57.085 So when the importer errors.
00:55:58.195 --> 00:56:01.786 It won't, and it doesn't. The funny part about this, so this
00:56:01.786 --> 00:56:04.965 is interesting troubleshooting for a project manager.
00:56:06.565 --> 00:56:09.873 If the if the importer goes super quick like that and it
00:56:09.873 --> 00:56:13.529 doesn't like take a second to kind of spin up, that's our key.
00:56:13.529 --> 00:56:15.735 That's something just is not working.
00:56:18.375 --> 00:56:22.725 It doesn't matter if it airs out on the first record or the.
00:56:23.535 --> 00:56:29.473 7900 and 33rd. If it errors nothing from that import, we'll
00:56:29.473 --> 00:56:31.255 get imported over.
00:56:32.835 --> 00:56:37.975 So there's something in the import that is mad.
00:56:40.875 --> 00:56:46.294 But I can't for the life of me from our spreadsheets see what
00:56:46.294 --> 00:56:51.015 it is. So as a moment of good measure, let's do F-12.
00:56:53.265 --> 00:56:55.225 And then empty cache and hard reload.
00:56:57.355 --> 00:57:00.718 And then we're going to try the importer one more time, and if
00:57:00.718 --> 00:57:03.867 that still doesn't work, then that is when we would report
00:57:03.867 --> 00:57:04.615 this as a bug.
00:57:18.445 --> 00:57:20.295 OK, so we've got our 100%.
00:57:27.615 --> 00:57:28.185 OK.
00:57:29.465 --> 00:57:31.405 Nothing showed up wonky there.
00:57:35.785 --> 00:57:39.923 Let's look for and. It's typically gonna show up on the
00:57:39.923 --> 00:57:42.215 very last page of the products.
00:57:43.465 --> 00:57:45.865 Because it's the last record that we imported.
00:57:47.115 --> 00:57:48.585 You scream mask is still there.
00:57:51.125 --> 00:57:52.585 Let's search for fluffy.
00:57:54.795 --> 00:57:55.995 Lucky.
00:58:02.005 --> 00:58:03.865 Huh. OK.
00:58:04.635 --> 00:58:08.615 So let's go back to the import products.
00:58:10.535 --> 00:58:12.455 Let's grab the template one more time.
00:58:23.695 --> 00:58:25.595 Changed just the name.
00:58:27.895 --> 00:58:29.145 To Amy's test.
00:58:32.755 --> 00:58:36.488 This will tell us if it's something in our spreadsheet or
00:58:36.488 --> 00:58:40.415 if this is something with the importer because our test data
00:58:40.415 --> 00:58:42.025 is filled out accurately.
00:58:44.745 --> 00:58:48.995 So save that as A and we're gonna want to take the 11 out.
00:58:54.355 --> 00:58:57.025 Need to clean up my desktop so please ignore.
00:58:57.495 --> 00:58:57.915 Dude.
00:58:58.865 --> 00:58:59.335 Choir.
00:59:00.125 --> 00:59:01.995 Hot pot kettle.
00:59:06.825 --> 00:59:09.192 I put a two in there just so it'll because that one was the
00:59:09.192 --> 00:59:11.165 one I just did. Is that gonna throw anything off?
00:59:10.805 --> 00:59:11.615 Yeah, that's fine.
00:59:12.755 --> 00:59:15.105 It's just the parentheses that it was mad about.
00:59:15.555 --> 00:59:15.865 Umm.
00:59:16.955 --> 00:59:17.985 That makes sense.
00:59:19.795 --> 00:59:20.395 OK.
00:59:21.545 --> 00:59:22.745 Let's try again.
00:59:40.225 --> 00:59:43.325 OK, so there's something in our sheet that's off.
00:59:46.585 --> 00:59:47.445 So what do we do now?
00:59:49.285 --> 00:59:50.725 I thought I filled it out correctly.
00:59:51.725 --> 00:59:53.555 Help me project manager help me.
01:00:00.535 --> 01:00:02.335 It's all look at it.
01:00:14.285 --> 01:00:16.945 To missing missing name after that.
01:00:18.295 --> 01:00:20.485 Raise your fall down key.
01:00:19.915 --> 01:00:22.355 Have all the necessary ones filled out so.
01:00:29.805 --> 01:00:33.665 So I would grab the first line.
01:00:34.905 --> 01:00:37.825 Of the demo 2.
01:00:39.495 --> 01:00:42.840 And copy paste it underneath and let's see if we can figure out
01:00:42.840 --> 01:00:43.625 the difference.
01:00:47.175 --> 01:00:49.115 Well, now this has turned into troubleshooting.
01:00:50.445 --> 01:00:51.265 This is fun.
01:00:53.615 --> 01:00:56.448 You didn't want to do a deep dive on CEF admin, you wanted to
01:00:56.448 --> 01:00:58.825 learn how to troubleshoot safe admin. Just kidding.
01:00:59.525 --> 01:00:59.875 Honey.
01:01:03.355 --> 01:01:03.785 OK.
01:01:37.955 --> 01:01:39.645 Does this one need to be filled out?
01:01:39.985 --> 01:01:43.515 It shouldn't matter, but let's give it a shot.
01:01:48.715 --> 01:01:50.955 This one looks like. Does this need to have the?
01:01:51.415 --> 01:01:52.205 It shouldn't.
01:01:54.775 --> 01:01:56.015 I just.
01:01:57.065 --> 01:01:58.435 The copy pasta.
01:02:30.465 --> 01:02:33.858 Maybe it's mad that we're trying to create a new category for
01:02:33.858 --> 01:02:34.515 some reason.
01:02:38.735 --> 01:02:39.415 Yeah, yeah.
01:02:40.595 --> 01:02:41.865 Doubt it, but.
01:02:44.635 --> 01:02:45.525 For giggles.
01:02:47.735 --> 01:02:52.245 Let's see if that's the problem. Let's try to put it into.
01:02:55.845 --> 01:02:57.905 Can electronic computer?
01:03:01.775 --> 01:03:04.025 And we'll see if that works.
01:03:50.775 --> 01:03:55.406 Huh. OK, so at this point, because I don't want to continue
01:03:55.406 --> 01:04:00.270 down a rabbit hole of trial and error and this likely is going
01:04:00.270 --> 01:04:05.133 to be a much larger spreadsheet from any client. The next step
01:04:05.133 --> 01:04:09.919 to this is actively getting a bug ticket in for the developer
01:04:09.919 --> 01:04:14.706 because they can attach and go line by line with break points
01:04:14.706 --> 01:04:19.492 to see where it's failing in the code itself and it will show
01:04:19.492 --> 01:04:21.345 them we don't have that.
01:04:21.405 --> 01:04:25.214 Option as project managers on Seth Admin when we're doing the
01:04:25.214 --> 01:04:25.645 import.
01:04:27.045 --> 01:04:32.107 As soon as you click the import button, that action is no longer
01:04:32.107 --> 01:04:36.390 a browser based action. It's actually happening on the
01:04:36.390 --> 01:04:40.517 server, so we can't go any further unless we were to
01:04:40.517 --> 01:04:44.723 actively remote into the desktop, which don't you all
01:04:44.723 --> 01:04:48.695 worry you're gonna get a lesson on that real soon.
01:04:51.155 --> 01:04:55.046 But one thing at a time. So unless we actively remote into
01:04:55.046 --> 01:04:59.134 the desktop and attached to the server and have a debugger up
01:04:59.134 --> 01:05:02.300 while it's going, this is the maximum amount of
01:05:02.300 --> 01:05:04.345 troubleshooting that we can do.
01:05:05.825 --> 01:05:06.375 So.
01:05:07.335 --> 01:05:11.630 The spreadsheet is correct. We went through theoretically that
01:05:11.630 --> 01:05:15.652 should work across the board. However, for whatever reason
01:05:15.652 --> 01:05:19.675 there's something within the fluffy battle kittens that is
01:05:19.675 --> 01:05:24.038 not working on this particular import, so I'm going to get that
01:05:24.038 --> 01:05:24.925 over to Eric.
01:05:26.815 --> 01:05:30.363 As the core thing, and we'll take a look at that and see if
01:05:30.363 --> 01:05:33.971 we can attach and figure out where it was going off and I'll
01:05:33.971 --> 01:05:37.579 report back to you guys what the resolution was. But overall
01:05:37.579 --> 01:05:41.009 those steps that we took is theoretically how the product
01:05:41.009 --> 01:05:42.725 importer is supposed to work.
01:05:43.845 --> 01:05:47.744 The idea behind the product importer is that it is taking
01:05:47.744 --> 01:05:51.508 and injecting all of the information that we're putting
01:05:51.508 --> 01:05:55.474 in that Excel spreadsheet into the SQL database in the SQL
01:05:55.474 --> 01:05:59.105 database is really just a series of rows and columns.
01:06:01.705 --> 01:06:05.805 Across multiple different tables that are all kind of joined
01:06:05.805 --> 01:06:09.838 together so that it is like a relational database, but it's
01:06:09.838 --> 01:06:13.804 basically taking the bits and pieces it needs based on the
01:06:13.804 --> 01:06:14.745 column header.
01:06:15.755 --> 01:06:18.285 As the field name so.
01:06:19.365 --> 01:06:22.443 Not the clearest visual representation of that, but at
01:06:22.443 --> 01:06:25.802 some point in your clarity career there will be a developer
01:06:25.802 --> 01:06:29.272 who is like, oh, let me just get into the database and adjust
01:06:29.272 --> 01:06:32.910 that real quick let and they'll be sharing their screen and they
01:06:32.910 --> 01:06:36.381 will show you and you will be like, cool. I'll stick with the
01:06:36.381 --> 01:06:36.885 importer.
01:06:40.095 --> 01:06:41.715 You're like, I know some of those words, yeah.
01:06:43.585 --> 01:06:48.292 While it is a wonderful thing to have the technical background to
01:06:48.292 --> 01:06:52.644 be able to kind of dive in in terms of troubleshooting, that
01:06:52.644 --> 01:06:57.209 is the maximum that I want us to go to on the importer, because
01:06:57.209 --> 01:07:01.560 other than that we are guessing and that's not useful to the
01:07:01.560 --> 01:07:05.911 client budget and it's not gonna help the developers. So the
01:07:05.911 --> 01:07:07.695 ticket for this would be.
01:07:08.055 --> 01:07:13.061 Under the product feature as a bug ticket for product importer
01:07:13.061 --> 01:07:17.432 failing on the product upload, no products from import
01:07:17.432 --> 01:07:22.439 spreadsheet displayed. Please attach and debug and then attach
01:07:22.439 --> 01:07:26.968 the spreadsheet that you actively filled out or that the
01:07:26.968 --> 01:07:30.545 client sent over and let them dive in on it.
01:07:31.775 --> 01:07:32.455 Makes sense?
01:07:33.645 --> 01:07:33.935 Umm.
01:07:35.935 --> 01:07:37.295 OK, cool beans.
01:07:38.105 --> 01:07:38.735 Umm.
01:07:39.995 --> 01:07:43.609 Well, now I'm disappointed that we don't have our cat, but
01:07:43.609 --> 01:07:44.345 that's cool.
01:07:46.245 --> 01:07:50.110 We are getting close to time, so within the product import
01:07:50.110 --> 01:07:54.370 section, is there anything else you guys wanted to dive in on or
01:07:54.370 --> 01:07:58.235 do you want to do any other areas within CEF admin that we
01:07:58.235 --> 01:08:01.839 can squeeze into 15 minutes? What are your big burning
01:08:01.839 --> 01:08:02.495 questions?
01:08:11.495 --> 01:08:13.045 Alex, look.
01:08:13.275 --> 01:08:14.655 I know you've got some.
01:08:15.695 --> 01:08:16.845 I always have questions.
01:08:16.875 --> 01:08:18.895 I have questions about Seth every day.
01:08:20.795 --> 01:08:23.929 Also give me one I'm gonna run to the bathroom. I'll be back in
01:08:23.929 --> 01:08:24.615 like 1 minute.
01:08:25.285 --> 01:08:25.605 OK.
01:08:26.845 --> 01:08:30.042 So Alaina you got through a good chunk of your homework, jumping
01:08:30.042 --> 01:08:31.715 in and answering questions there.
01:08:32.145 --> 01:08:36.844 Umm I have one. I'm finishing up my last video and then I was
01:08:36.844 --> 01:08:40.635 gonna start on the other when my other homeworks.
01:08:41.165 --> 01:08:43.495 Oh, my goodness. OK, well don't.
01:08:44.425 --> 01:08:45.615 There's no due date.
01:08:47.065 --> 01:08:47.535 So.
01:08:47.145 --> 01:08:51.370 You said today, so I'm doing it today. All I have is Azure and
01:08:48.985 --> 01:08:50.565 I OK.
01:08:51.370 --> 01:08:55.596 real and needs reallocation in a little while and that doesn't
01:08:55.596 --> 01:08:57.475 take very long, so I'm good.
01:08:57.935 --> 01:08:59.285 OK, alright.
01:08:58.745 --> 01:09:00.095 Cool as a cucumber here.
01:09:00.465 --> 01:09:01.245 Fair enough.
01:09:03.135 --> 01:09:07.442 So from the videos that you did get through, was there anything
01:09:07.442 --> 01:09:09.865 glaring that you're just like what?
01:09:08.495 --> 01:09:08.865 I.
01:09:10.375 --> 01:09:13.385 No, I actually I understand now.
01:09:14.815 --> 01:09:18.370 Because before I was like watching you guys do it and I
01:09:18.370 --> 01:09:22.306 was like, this is going over my head. But now walking through
01:09:22.306 --> 01:09:26.115 and explaining all the sections, I understand what it does.
01:09:27.485 --> 01:09:27.985 Sweet.
01:09:27.895 --> 01:09:31.925 Better not completely, but I have a better understanding.
01:09:30.835 --> 01:09:31.295 Well.
01:09:33.625 --> 01:09:37.929 To be fair, I'm not sure. To be fair, I'm not sure if I said,
01:09:35.435 --> 01:09:36.245 To before.
01:09:37.929 --> 01:09:42.303 hey, Kyle, do you have a perfect understanding of Seth that he
01:09:42.303 --> 01:09:43.275 would say yes.
01:09:45.755 --> 01:09:48.425 I don't even know that I could get that out of James Gray.
01:09:51.665 --> 01:09:54.339 Yeah, to be honest, there's so many hands in that in that
01:09:54.339 --> 01:09:57.106 cookie jar right now that I don't think anyone person knows
01:09:57.106 --> 01:09:59.735 the intricacies of self all the way through and through.
01:10:00.945 --> 01:10:01.125 You.
01:10:02.915 --> 01:10:07.480 It is a labor of love built by many hands, and so the big thing
01:10:07.480 --> 01:10:11.047 is knowing the base functionality and knowing the
01:10:11.047 --> 01:10:15.469 difference between when we need to customize something versus
01:10:15.469 --> 01:10:19.464 what we already offer. And so when I first started with
01:10:19.464 --> 01:10:20.035 clarity.
01:10:22.115 --> 01:10:28.667 I logged in to the Seth Admin on, I think my first project was
01:10:28.667 --> 01:10:29.395 spazzy.
01:10:30.335 --> 01:10:32.545 I logged into their Seth Admin.
01:10:34.575 --> 01:10:36.045 And I closed my browser.
01:10:36.855 --> 01:10:39.985 I I looked at that very first screen.
01:10:40.465 --> 01:10:41.165 You said no.
01:10:41.995 --> 01:10:44.875 I I did, I just noped I.
01:10:45.525 --> 01:10:46.705 I was like, I don't.
01:10:48.015 --> 01:10:49.925 There's so much.
01:10:50.675 --> 01:10:54.105 To look at on this screen that.
01:10:55.775 --> 01:11:00.855 I as a project manager coming in as a database developer with
01:11:00.855 --> 01:11:01.675 front end.
01:11:03.165 --> 01:11:06.685 Certification looked at this and said no.
01:11:07.785 --> 01:11:08.435 So.
01:11:10.225 --> 01:11:12.135 Imagine how our clients feel.
01:11:13.045 --> 01:11:13.475 Yeah.
01:11:13.245 --> 01:11:19.528 So it's incumbent upon us to be able to go in and have a safe
01:11:19.528 --> 01:11:25.610 place to click around play, see how the data works, see how
01:11:25.610 --> 01:11:30.475 things play together, what works, what doesn't.
01:11:31.635 --> 01:11:35.624 For what it is that you're trying to do and feel like
01:11:35.624 --> 01:11:40.279 you're not gonna break anything, and that's what This site is,
01:11:40.279 --> 01:11:44.564 the R2022-4 is our current playground with the latest and
01:11:44.564 --> 01:11:48.185 greatest. We have another release that was just.
01:11:48.305 --> 01:11:49.935 Uh, just done.
01:11:51.985 --> 01:11:55.610 That is the current active development branch, and at some
01:11:55.610 --> 01:11:59.543 point our playground is going to change over to that so that we
01:11:59.543 --> 01:12:02.985 are always moving with the team about a version behind.
01:12:04.185 --> 01:12:07.553 So most of our new client projects are stood up on the
01:12:07.553 --> 01:12:11.412 latest and greatest. There's not enough crazy changes that I'm
01:12:11.412 --> 01:12:14.965 not that I think that we need to dive over into that yet.
01:12:16.895 --> 01:12:21.601 But I do want you guys to feel like you can go in here and do
01:12:21.601 --> 01:12:25.852 literally anything you want. You're not gonna break it.
01:12:25.075 --> 01:12:25.555 OK.
01:12:25.852 --> 01:12:29.345 You're not gonna get in trouble, I would say.
01:12:30.695 --> 01:12:34.133 For my own sanity sake, because I am a supervisor and I do have
01:12:34.133 --> 01:12:37.035 to make these call outs, please keep it professional.
01:12:40.105 --> 01:12:44.487 It does not have to be serious. Fluffy battle kittens is fine.
01:12:44.487 --> 01:12:48.175 No curse words, no innuendos, things of that nature.
01:12:49.275 --> 01:12:53.275 But overall, you guys are fine to go in and do whatever you
01:12:53.275 --> 01:12:57.275 want in here and play around. There are areas in here where
01:12:57.275 --> 01:12:58.675 angels fear to tread.
01:13:01.005 --> 01:13:01.625 Umm.
01:13:02.625 --> 01:13:04.075 Coming into like.
01:13:04.855 --> 01:13:06.365 Adding a brand new user role.
01:13:11.205 --> 01:13:12.535 See how slow?
01:13:11.305 --> 01:13:12.755 That is a long list.
01:13:11.905 --> 01:13:14.285 I won't even go there, there.
01:13:15.225 --> 01:13:18.959 I won't even go there like that's that's way new. New, new
01:13:18.959 --> 01:13:20.795 new. There's like 5000 rolls.
01:13:21.165 --> 01:13:21.435 Yep.
01:13:22.165 --> 01:13:23.435 Or permissions, sorry.
01:13:22.375 --> 01:13:22.675 It's.
01:13:23.405 --> 01:13:26.315 It's bananas, but.
01:13:28.025 --> 01:13:30.025 If you're wondering how it works.
01:13:32.085 --> 01:13:34.135 If we're setting up a brand new one.
01:13:39.505 --> 01:13:43.055 I want this person to be able to do.
01:13:43.875 --> 01:13:44.975 Yeah. Pick in action.
01:13:47.325 --> 01:13:48.565 Delete products.
01:13:50.885 --> 01:13:54.745 But that's it. They can't create them, they can't view them.
01:13:56.675 --> 01:13:59.505 They can't do it. They can. They can only come in and delete.
01:13:59.505 --> 01:14:01.195 That seems like a useful permission.
01:14:04.415 --> 01:14:05.205 Right now.
01:14:04.415 --> 01:14:05.645 Yeah, they're just chaotic.
01:14:06.135 --> 01:14:06.625 Mm-hmm.
01:14:13.735 --> 01:14:18.413 Yeah. I mean that's just vendor deactivate. So this is basically
01:14:18.413 --> 01:14:21.365 the one thing that this new role can do.
01:14:23.315 --> 01:14:26.905 I'd have to add individual permissions.
01:14:28.235 --> 01:14:33.605 And what this is is based off of the table structure, so the CEF.
01:14:34.605 --> 01:14:38.890 Architecture would be that we have vendors as like a primary
01:14:38.890 --> 01:14:43.457 table. So all things vendor live under vendors and then the same
01:14:43.457 --> 01:14:47.742 way that a URL kind of splits things out. We have a subtable
01:14:47.742 --> 01:14:52.098 or a category tree structure. However you want to think about
01:14:52.098 --> 01:14:56.173 it. We have a subtable for vendor images and then we have
01:14:56.173 --> 01:15:00.739 actions that can be done on the vendor images and so that's kind
01:15:00.739 --> 01:15:02.215 of how you read this.
01:15:02.935 --> 01:15:07.342 I always tell our clients, let a developer handle this because
01:15:07.342 --> 01:15:11.750 nobody wants to take the time to learn this structure and what
01:15:11.750 --> 01:15:16.018 each one of these actions means. But it is something that if
01:15:16.018 --> 01:15:20.565 they're feeling feisty and they have a good understanding of it,
01:15:20.565 --> 01:15:21.755 they can do this.
01:15:23.845 --> 01:15:27.935 It's there, it's just a bit much. So depending on your
01:15:27.935 --> 01:15:31.728 clients level of you know technical know how it is
01:15:31.728 --> 01:15:36.636 something you can show them. But be aware there are areas in here
01:15:36.636 --> 01:15:41.321 that you're gonna get into and you will get a response from me
01:15:41.321 --> 01:15:41.545 of.
01:15:42.745 --> 01:15:44.035 Get a developer involved.
01:15:46.505 --> 01:15:48.315 Just because it's it's not.
01:15:49.095 --> 01:15:53.428 It's not worth our time or the client's time to go in and do
01:15:53.428 --> 01:15:55.205 it. Does that make sense?
01:15:57.085 --> 01:15:57.425 Yeah.
01:15:58.335 --> 01:16:03.139 Especially if there is any custom functionality because the
01:15:58.715 --> 01:15:59.005 OK.
01:16:03.139 --> 01:16:08.264 the permissions for that custom feature won't necessarily be in
01:16:08.264 --> 01:16:08.985 here yet.
01:16:10.445 --> 01:16:10.705 Yep.
01:16:10.955 --> 01:16:12.245 So now they're just call out.
01:16:12.925 --> 01:16:16.035 Yep. So if they have a.
01:16:17.345 --> 01:16:21.761 Let me think of a custom feature on JBM. We were talking about
01:16:21.761 --> 01:16:26.248 the shared carts and they have that set for just the supervisor
01:16:26.248 --> 01:16:30.595 role to be able to share those shopping lists and share carts
01:16:30.595 --> 01:16:35.152 down to the rest of their staff. That's not something that would
01:16:35.152 --> 01:16:39.498 be in and out of box version of CEF. That's something that we
01:16:39.498 --> 01:16:43.565 would have to create and then put the permission in here.
01:16:44.425 --> 01:16:45.025 So.
01:16:46.105 --> 01:16:50.132 Odds are it's likely not been ported over into this table for
01:16:50.132 --> 01:16:54.224 them to manipulate, so it's just better for any sort of custom
01:16:54.224 --> 01:16:57.796 functionality that we define. The roles we define, the
01:16:57.796 --> 01:16:59.875 permissions within the database.
01:17:00.605 --> 01:17:05.438 And those shouldn't change all. They're gonna be doing is
01:17:05.438 --> 01:17:10.355 assigning the user the role, so I wouldn't. I would never.
01:17:11.365 --> 01:17:14.957 Train JBM on coming in here to set it up because they have
01:17:14.957 --> 01:17:17.575 custom functionality, so there's no point.
01:17:19.005 --> 01:17:25.605 Umm, the one Kyle? Since I have you, would you give us?
01:17:27.115 --> 01:17:30.925 The Reader's Digest version of sales groups.
01:17:34.205 --> 01:17:36.985 Yeah. OK. Can you hear me alright?
01:17:36.475 --> 01:17:38.455 OK. Yeah, we got you.
01:17:37.715 --> 01:17:37.875 Yeah.
01:17:38.915 --> 01:17:44.571 Alright, cool. So yeah, a sales group is designed to be a global
01:17:44.571 --> 01:17:50.228 ID or a global container if you will. For the quote that goes to
01:17:50.228 --> 01:17:55.797 an order that goes to an invoice that could potentially go to a
01:17:55.797 --> 01:18:01.106 return. So the sales group is 1 ID and it's it's basically a
01:18:01.106 --> 01:18:06.676 small table in Seth that has the ID or the relationships to all
01:18:06.676 --> 01:18:09.635 of those different sales records.
01:18:09.865 --> 01:18:14.162 So as a group it is able to relate those together to where
01:18:14.162 --> 01:18:18.823 when you're looking at that on the user dashboard and you click
01:18:18.823 --> 01:18:23.194 the quotes tab, orders tab, invoices tab, that's all set up
01:18:23.194 --> 01:18:25.015 based on the sales group.
01:18:27.495 --> 01:18:28.445 So from.
01:18:27.805 --> 01:18:30.755 I try. I will. I will go too much more into that.
01:18:31.175 --> 01:18:33.685 No, no, that's perfect. So.
01:18:35.035 --> 01:18:39.297 One of the sort of sticking points that happens with clients
01:18:39.297 --> 01:18:40.415 because that is.
01:18:41.515 --> 01:18:47.015 Quotes. Correct me if I'm wrong, but quotes are very much a B to
01:18:47.015 --> 01:18:48.285 B centric idea.
01:18:49.995 --> 01:18:50.815 100%.
01:18:50.245 --> 01:18:55.425 In the in the beat of SeaWorld, which is what we're kind of
01:18:55.425 --> 01:18:58.015 driving most projects towards.
01:18:58.615 --> 01:19:02.998 And most of the time it is an often capture right then and
01:19:02.998 --> 01:19:07.678 there, and we're not doing terms where they're doing invoicing
01:19:07.678 --> 01:19:12.433 and we're not doing quotes quite as much. They do still come up
01:19:12.433 --> 01:19:15.925 and this is still very much an in use feature.
01:19:16.565 --> 01:19:20.962 Pretty much across the board, but there are a lot of net new
01:19:20.962 --> 01:19:25.432 projects that we're working with that don't have that. And so
01:19:25.432 --> 01:19:29.757 there's something that happens on orders that we need to be
01:19:29.757 --> 01:19:32.425 aware of and it is the master order.
01:19:33.245 --> 01:19:34.415 And this sub order.
01:19:35.225 --> 01:19:40.288 So when we go in and we're showing them how to administrate
01:19:40.288 --> 01:19:44.844 for orders within their instance, there's a couple of
01:19:44.844 --> 01:19:47.545 things I want us to be aware of.
01:19:49.435 --> 01:19:50.265 So with.
01:19:51.795 --> 01:19:55.045 I think John Cena here would be a good example.
01:19:55.895 --> 01:20:01.515 So we have order order #14 and order #15 with John Cena.
01:20:01.515 --> 01:20:07.629 They're both for the same price. They were both placed at the
01:20:07.629 --> 01:20:08.615 same time.
01:20:11.175 --> 01:20:14.805 A quiet looking at this is going to think, Oh my God, we're
01:20:14.805 --> 01:20:15.955 duplicating orders.
01:20:19.115 --> 01:20:20.095 But were not.
01:20:21.345 --> 01:20:24.425 Why do you think that is based on what Kyle just said?
01:20:29.895 --> 01:20:32.245 Because it's all of those associated to that.
01:20:33.355 --> 01:20:34.215 The main ID.
01:20:33.415 --> 01:20:33.825 Mm-hmm.
01:20:34.725 --> 01:20:39.855 Yep. So if they're going in and they're doing a capture.
01:20:41.935 --> 01:20:43.745 In their instance.
01:20:45.405 --> 01:20:49.965 They may come in to the first one and be like ohh.
01:20:51.255 --> 01:20:54.338 I should be able to do something with this, maybe it was the
01:20:54.338 --> 01:20:57.068 second one and it's going to be dependent on like the
01:20:57.068 --> 01:20:57.625 individual.
01:20:58.295 --> 01:21:01.525 Project itself, like with DERM, I think.
01:21:08.985 --> 01:21:12.195 So in here, Kyle, this just exploded my brain because it's
01:21:12.195 --> 01:21:15.460 really easy for me to tell on DERM, which is the master and
01:21:15.460 --> 01:21:16.385 which is the sub.
01:21:17.235 --> 01:21:20.055 But if I'm the client and I'm looking in here.
01:21:20.715 --> 01:21:24.090 How do I tell which one of these was the master versus the sub
01:21:24.090 --> 01:21:25.215 order from this view?
01:21:26.675 --> 01:21:27.745 Ohh you you care?
01:21:29.055 --> 01:21:31.185 How do I tell from within the editor?
01:21:32.205 --> 01:21:34.315 If you go over to associations.
01:21:36.555 --> 01:21:42.221 It should say right there invoices total page have an ID.
01:21:42.221 --> 01:21:46.325 It should have the suborders right there.
01:21:47.655 --> 01:21:48.565 Umm.
01:21:48.935 --> 01:21:49.665 Umm.
01:21:50.745 --> 01:21:56.987 Yeah, this is invoices, payments and nothing for other orders.
01:21:56.935 --> 01:21:57.165 For.
01:21:56.987 --> 01:21:58.275 Ohh actually.
01:22:00.685 --> 01:22:01.275 It's that.
01:22:01.045 --> 01:22:05.724 No, because that's a sales group ideas. The seven up there in the
01:22:02.235 --> 01:22:02.575 Right.
01:22:05.724 --> 01:22:06.575 upper right.
01:22:09.035 --> 01:22:11.125 Group ID 7 can I click that?
01:22:10.395 --> 01:22:11.675 And you're on the invoice.
01:22:11.975 --> 01:22:12.415 Yeah.
01:22:13.815 --> 01:22:16.940 Oh, Oh yeah. I I don't think there's a way to do it from the
01:22:16.940 --> 01:22:19.195 invoice. It just points to the sales group.
01:22:19.815 --> 01:22:20.215 OK.
01:22:20.065 --> 01:22:23.222 I think if you go to the seals. Great. Yeah. There we go. The
01:22:23.222 --> 01:22:26.075 master ordered and then the suborder is right below it.
01:22:26.995 --> 01:22:30.632 So typically the first one in the sequence should be the
01:22:30.632 --> 01:22:33.505 master and the second one should be the sub.
01:22:34.425 --> 01:22:35.295 Technically yes.
01:22:35.745 --> 01:22:36.435 Technically.
01:22:37.395 --> 01:22:39.385 But that logic breaks down.
01:22:42.395 --> 01:22:44.615 I will show you how and why and where.
01:22:47.485 --> 01:22:47.905 So.
01:22:48.545 --> 01:22:51.525 14 in this case is the.
01:22:53.455 --> 01:22:55.925 Master 15 is the sub.
01:22:56.775 --> 01:23:00.266 That seems fairly reasonable, but what tends to happen once
01:23:00.266 --> 01:23:03.933 people start actively processing orders is that we have things
01:23:03.933 --> 01:23:04.515 like this.
01:23:05.375 --> 01:23:09.025 Where we have the status that is different. This one has been
01:23:09.025 --> 01:23:12.557 captured. It's good to go. This one is in a pending status.
01:23:12.557 --> 01:23:15.325 These are net new orders. Red would be voided.
01:23:17.205 --> 01:23:22.676 If we end up with a whole bunch that are in pending status, the
01:23:22.676 --> 01:23:23.275 parent.
01:23:24.735 --> 01:23:28.585 The Master order is going to stay over here.
01:23:29.515 --> 01:23:30.335 Looking.
01:23:31.085 --> 01:23:35.815 All like a new order until it turns green so.
01:23:37.375 --> 01:23:42.366 The easiest way to administrate for your orders is to start with
01:23:42.366 --> 01:23:43.365 sales groups.
01:23:44.165 --> 01:23:49.054 Because then you can determine actively. OK, John Cena, let's
01:23:49.054 --> 01:23:54.102 go look at him and then you can see the master and then the sub
01:23:54.102 --> 01:23:59.149 and you can click on the sub and then navigate and confirm your
01:23:59.149 --> 01:24:02.935 order, capture the payment and bobs your uncle.
01:24:05.505 --> 01:24:09.895 So clients have a hard time with that because.
01:24:10.945 --> 01:24:14.505 They are just thinking that they want to deal with their sales
01:24:14.505 --> 01:24:17.726 orders. They're not thinking about sales groups. So it's
01:24:17.726 --> 01:24:20.890 something that we should be calling out to them that if
01:24:20.890 --> 01:24:24.225 they're actively using CEF admin to track their orders in.
01:24:24.825 --> 01:24:28.776 Uh, you know reporting way or if they're actively capturing
01:24:28.776 --> 01:24:32.397 payments within here, they should start with the sales
01:24:32.397 --> 01:24:36.414 group to find the customer, the sales group, the best way to
01:24:36.414 --> 01:24:39.904 describe it is rather than trying to search for your
01:24:39.904 --> 01:24:43.987 customer and then search for the invoice and all of that goes
01:24:43.987 --> 01:24:48.070 straight to your sales groups, look through the account name,
01:24:48.070 --> 01:24:50.375 find the human you're looking for.
01:24:51.485 --> 01:24:52.205 Go in.
01:24:52.865 --> 01:24:57.167 And process their suborder. It cuts out about four steps in 20
01:24:57.167 --> 01:24:58.465 hours of confusion.
01:25:02.275 --> 01:25:04.315 Did that help or make it worse?
01:25:09.295 --> 01:25:11.565 But a column a little bit of column B.
01:25:11.985 --> 01:25:16.270 Fair. Alright. Well, I will leave that brain exploding
01:25:16.270 --> 01:25:20.945 epiphany over in your in your brain pans and call it a day.
01:25:20.945 --> 01:25:25.620 Let me know if you guys need anything. Let's make sure that
01:25:25.620 --> 01:25:30.763 we are getting our invoice notes in before you leave for the day.
01:25:30.763 --> 01:25:35.905 And getting your projections for next month in Alaina ABS and Max
01:25:35.905 --> 01:25:40.425 have been moved over to your tab. In this instance I will
01:25:40.425 --> 01:25:42.295 take care of it because.
01:25:42.375 --> 01:25:46.692 I am a monster and have not done my duties yet, so don't worry
01:25:46.692 --> 01:25:49.845 about it on yours. If you have any questions.
01:25:48.255 --> 01:25:48.695 OK.
01:25:51.285 --> 01:25:54.178 Hit me up Monday before the invoicing meeting. Amy Morris,
01:25:54.178 --> 01:25:55.895 and we can go through it together.
01:25:57.245 --> 01:25:57.735 OK.
01:25:59.075 --> 01:26:03.004 All right, awesome. Thank you so much everybody. This was fun.
01:26:03.004 --> 01:26:06.435 Uh. Hopefully you got some good information out of it.
01:26:07.735 --> 01:26:12.585 Well, continue down this rabbit hole every few Fridays.
01:26:13.965 --> 01:26:18.754 And tell everyone it's kind of cozy in there, but I do see Amy.
01:26:18.754 --> 01:26:23.395 You got a couple scheduled for us for all three of us, right?
01:26:24.675 --> 01:26:27.492 I got one on the just like the next one on the calendar. I
01:26:24.935 --> 01:26:25.505 This.
01:26:27.492 --> 01:26:28.495 think it's next week.
01:26:28.935 --> 01:26:31.854 Umm so and then from there I just I didn't know how many
01:26:29.115 --> 01:26:29.505 OK.
01:26:31.854 --> 01:26:34.365 wanted to go forward so I just did the next one.
01:26:34.805 --> 01:26:38.136 OK, perfect. We'll just go from there and we'll just keep
01:26:38.136 --> 01:26:41.582 elaborating until everybody feels comfy and cozy. And Seth,
01:26:41.582 --> 01:26:44.913 you're never gonna feel 100% like you're on solid ground.
01:26:44.913 --> 01:26:48.015 That's OK. That's what developers are here for. But I
01:26:48.015 --> 01:26:51.633 want us to at least be able to explain to clients how all this
01:26:51.633 --> 01:26:55.195 works. So we'll carry on until we get everybody to that spot.
01:26:55.895 --> 01:26:56.165 And.
01:26:57.075 --> 01:26:57.905 Just to be clear.
01:26:58.845 --> 01:27:00.735 I never have all of the answers.
01:27:01.395 --> 01:27:05.157 There are many, many times where I'm like, I don't know. I need
01:27:05.157 --> 01:27:06.275 to ask a developer.
01:27:06.795 --> 01:27:10.140 Uh, I think my phrasing on that is I need bigger brains in the
01:27:10.140 --> 01:27:12.265 room than mine. Let me get back to you.
01:27:15.325 --> 01:27:17.899 Alright, thanks so much everybody. I hope you have an
01:27:17.899 --> 01:27:19.615 amazing weekend and get outta here.
01:27:20.225 --> 01:27:21.595 Thanks you too.
01:27:21.215 --> 01:27:22.385 Bye. Thanks for doing this.
01:27:22.835 --> 01:27:24.415 Yeah. OK, love you. Bye.
01:27:23.315 --> 01:27:23.915 Hi.
01:27:23.345 --> 01:27:23.665 Like.
01:27:24.775 --> 01:27:25.445 I.
01:27:25.325 --> 01:27:26.385 I love you. Bye.
01:27:26.595 --> 01:27:27.915 K love you. Bye.