RPM LLC

All right, and Mrs. Stakes. Beth, I really wanted to show you an idea here. It's not an idea. It's how you'd want to do it. This col In normal circ Product code. So, since there's not one, right, that's okay, let's make up our own, but the product code needs to be synonymous with the product line, if you will. Us doing this, we kind of know how this is going to flow. So, AR-153MR is a good product code, right? Then the name of it is a 3MR, but the platform that the application it goes to is AR15. Now, the dashes work in this case You just can't use the dot. The dot doesn't get recognized in this particular feeds. Dashes do, spaces kind of cause a problem. So, if it doesn't go together, right, it needs to be separate. But in your col Product code, the name of the product, long descriptions, typically two lines. Yeah, that's where when you scroll down lower in that bigger bank at the bottom, there's a bigger paragraph about what this thing is, how it was made, whatever. But the short term is, That right there is where it's by the picture and by the price and all that. Weight, I need that in ounces, right? Right, so ounces. If you have grams, just convert it. Because by the time we take however big this list is and try to convert it separately just for the table to read it, you see what I mean? It's kind of Once I put it in the chamber, once I fire that thing to upload, it's got to hit all the marks. Because if we miss anything, it takes a minute to go fix. So AR 15 is the platform in this one. AR 10 would be that platform. AK 47 3MR, right? Same thing, ounces. AK 47 is going to be its platform. So however those are, this allows us to break down all the minutiae into categories. I get to the website, I look up going, I got an AR 10, did they have it for that? They just hit the search filter and bam, it pops up in front of them. Between us, we know a lot of this is the same part because it has multiple applications. Totally get that. But we still want to name it. Then what is the customer price? What do you sell it for? Sale price. Let'say you had some AK 47 parts. You probably won't have this problem because they're not so uniquely different. It probably has multiple uses. So you'd never run out of stock. But let'say the ambidextrous thing is running low and you can run that on sale to be a coupon or something You can leave that col The reason why this is so important, because you're going to want to go name the pictures. When I give you the Dropbox link, you can upload photos of the product from the cat. And when you upload the photos into the Dropbox, you want to make sure you name that photo. You can put a label on it. So I would name it AR-153MR. That way, when we go to suck those pictures in, it'll tag itself into everything there. Now, if it's the same part to an AR-103MR, then you have to upload that picture. And even though it could be the exact same picture, but it has its own different label. You cannot run Then I need five pictures of it with its right label on it. If you don't do that, it will never match the picture to the inventory. That's just how these work. Pictures come in separate because they have to be compressed and organized for mobile, desktop, use, But it comes in a separate channel and ties to the spreadsheet. You can't add an image col If you did, you would blow up that spreadsheet and then to upload it, we'd be a nightmare. Okay, we do this from 10,000 products to 100 works exactly So this is the idea of how that would need to work. Were talking me and some of the guys, this list of 2500. If we can see that list, because I'm looking at the back order form, it's just a Google form, name, address, email all required. I think shipping address was required and in quantity. What part is that? Okay, what product was that for? Right? If it's just all one product, I may have a solution. Okay, if it's one product and we can identify that, then I can actually take your 2500 list, import them in and create a new user account. Then I can do an email broadcast on MailChimp saying, hey, congratulations, your back order has been moved to production. Scan the QR code, click the link, update your account information, verify order, proceed to checkout. Then we'll let them just go pay for it in the store. But here's the deal. So we've got to get that ready pretty quick. Yours will be easy enough just because the amount of products you really have, though there might be several applications there. So then once we do that, we're going to give them a temporary password. So the user account's always going to be their email. And that's unique to every individual. No emails are the same. But the password might be first initial last name, first full name, last initial, we'll tell them that in the email, how they get in, they log in, update it, change your password, something personal, then they go verify their order. And that order sitting inside the back shop of your store is an incomplete order. Once they go verify all that, then it gets automatically moved to an actual order. They'll be prompted in their cart to go and pay to go check out. And then we've also told them that. This is a multi step process. It might be a search chart for that because here's what's going to happen. We got to load and create an accounts 2500s a little bit. That's 20 minute upload, but it takes several hours to get this organized. Then we're going to reload it again and apply the orders to the users, right? We're going to actually create our own file. We're going to take your original and make three copies of it, make one for users, one for orders, right? And then one for passwords, right? We have to do a little bit of a scenario. So that's what that would take. But that'll allow these people to get notified that they're invited to come validate their account and update their back order and then proceed to checkout, right? Confirm everything. I think that's going to be your best way, but I won't have the website ready for, I mean, it takes typically week to 10 days. To get a website ready, but I will try to go as fast as I can. I'm just trying to do a d Now, if I do all of this, this would be useless for you to send them to a portal to make a payment. Because if I order 10 and it is only one part, I need to know what my total is with tax and shipping, how we're going to get them that information. I can't customize individual emails in a bulk email. Then we're back to the same conundr We moved it from back order to production and give us a call to update your order, right? Then you'll just one by one, whoever calls in, start cleaning that up and then billing them out, right? Then yeah, we can set up a payment portal and then they'll go and just pay that. But you have to have the shipping and all that down manually before you can do it in the store. We did put a call in to tax jar. Don't have that answer yet, I'll find out. But this was attainable. This is attainable. One of the techs said he was thinking it through and we mapped it out. We could actually do that. We do that for other clients that have an old website and they want to move their existing user base over. But man, this has never been more than 200. So the system can email out 100 out of time when we don't get spam blocked because we know how to do that. But man, if it gets to 2,500, we would exceed all limits. Even if we got to day three, we'd probably get shut down, right? Because that would take 100 a day. How many days is that? See, that would take forever in a minute. So we're trying to help you with how we know that works. But the spreadsheet, there you go. This spreadsheet needs to be If I can get the list of the 2,500, let my guys tinker with it for a minute, we could probably see the best way to load that in. But then we still have the process that I just explained. Okay, so good for your thought. Thanks a lot.