Skip to content

Category: Workflow

Shouldn’t Have Drank that Ice Coffee

I shouldn’t have drank that cheap (but delicious) Iced Coffee.

The small was only $2 and I swear it was worth it.

Only problem,

I’m wide awake at 2am playing mortal combat and replying to some developers.

Is this productive?

Or detrimental?

Probably both.

Next time, I’ll request light ice. 🧊

Awkward Pickup from Planned Parenthood

Picked up a young college girl from planned parenthood today.

Short ride. Maybe 10 minutes (2 miles)

She was on the phone with one of her girlfriends.

Basically, I eavesdropped on the entire conversation.

Something about yeast infection, good bacteria, Pap smears, and her current relationship. Very awkward because I’m not normally exposed to this stuff.

She then explained how she can do better than the guy she’s seeing and that he needs more self confidence in himself. Safe to say she had a big ego and big problems.

Dropped her off and found myself temporarily scared of the opposite sex.

The Real MVP

The real MVP goes to the recent passenger who hooked me up with spray on hand sanitizer. Actually, it may have been alcohol.

Either way, she was rambling on about how “safe” she was and boating about how she applies alcohol and sanitizer to her hands (and gloves) multiple times during the day. I told her I do the same, but the alcohol I have really drys out my hands.

Out of the kindness of her heart, she gifted me a bottle of spray on sanitizer. It had a mix with glycerin to make your hands feel soft (or something like that). She says she was a housekeeper and makes it herself.

Shout out to this lady helping me out.

*as a side note, Sushi (my car’s name) showed me he has an advanced safety braking system. While on the 101 I was stuck in stop and go traffic and found myself in a situation where I was going to fast to stop. I had a 100% chance of rear ending the vehicle in front of me. I slammed on my brakes as hard as I could but it wasn’t enough…however Sushi’s safety’s brakes kicked in and stopped the hell out of my car. I somehow escaped financial ruin thanks to an automated system.

Maybe that’s why this lady gifted me the sanitizer. She still the MVP for that.

Crazy Rideshare Stories

I want to tell you about the crazy stories I’ve gone through while driving for Lyft and Uber.

The stay at home order has me driving more in order to cover my bills and to pay for all of the non-sense items I buy.

I started driving back in December and usually part time on the weekends. I’m not full time, but holy crap have I been in the wildest situations I’d never thought if be in.

I’m mainly drive around Los Angeles, so all the experiences you will soon read are from this area.

Here’s a list of some from the top of my head:

Passenger at 5am jumps out of bushes and does a full wardrobe in the backseat while heading to work.

Lady applies 3 large squirts of hand sanitizer within a 1 mile trip. Jumped out the car so fast when I stopped.

Chick doesn’t want me to drop her off at her pinned location. I follow her directions and go into circles before asking her to get out. She doesn’t.

Polo Gee falls asleep in my car and I couldn’t wake him up. Dropped him off half awake in the middle of the night.

Teenage moms kid kept asking if I was her daddy.

Wore the wrong colors and picked up someone at a liquor store. I was confronted and had to bribe my way out of the situation.

Dropped off a dog 30 minutes away to a grooming establishment. He kept licking my elbow.

Since I get multiple crazies every time I’ll drive, I’ll try to post my stories as many as possible.

Years from now, I may regret this 👀

Inventory Management Book Wishlist

I enjoy reading about management logistics and how to keep a business running smoothly. I came across these 3 books and am putting them on my wishlist. If you have a copy, share it with me!

Inventory Management Explained by David J. Piasecki

ISBN-10: 0972763112

Essentials of Inventory Management by Max Muller

ISBN-10: 1400212375

Inventory Accuracy: People, Processes, & Technology by David J. Piasecki

ISBN-10: 0972763104

Checking In

7 days without coffee.

5 hours of sleep.

1.5 hour commute.

What does that equal?

A whole lot of complaining and happy hour visits.

Copy and Paste 101: Data

Share Documents

Write down each step in your Notes.

Copy and paste links

*MPNs

Incognito Mode

Can’t find it skip it

How many can you do in 1 hour?

How many in 4 hours?

I need..

Magic Mouse

Simple Solutions to Big Problems

Spent 1 hour trying to figure out an issue with our WordPress site.
We just created a new custom post type and tested everything on our staging site.

Everything was working fine.

We decided to push the modified files to our live site and started to add content.

These pages weren’t loading.

We discussed our steps, removed excess plugins, and copied over entire site folders…

These pages still wouldn’t load.

This damn 404 page kept showing up on everything.

1 hour later, I decided to take a walk.

I knew we did everything right…what was the issue?

I sat back down and saw the other team members frantically checking the site PHP files.

They were panicking!

I was panicking.

But I stayed relaxed and tried not to think too hard.

If we did everything right, it must be a simple problem.

A problem we have no control of.

Once I thought about that, a lightbulb popped into my head.

No way could this fix the issue, I thought.

I navigated to the permalink structure page and didn’t change anything. I just hit “save changes”

Your Permalink Structure Has Been Updated

This showed up on my screen and I reloaded the issues pages.

Everything was working fine now.

WOW.

The most difficult issue had the most simple solution.

Think about that next time you try overthinking.

Formatting Product Image URLs

Formatted correctly:

https://1mc51l3v9iyu3otpsg36nnvf-wpengine.netdna-ssl.com/wp-content/uploads/2017/10/presonus-faderport_16-top_big.jpg | https://1mc51l3v9iyu3otpsg36nnvf-wpengine.netdna-ssl.com/wp-content/uploads/2017/10/presonus-faderport_16-top_big.jpg | https://1mc51l3v9iyu3otpsg36nnvf-wpengine.netdna-ssl.com/wp-content/uploads/2017/10/presonus-faderport_16-top_big.jpg

We need the product image to be formatted in a specific way.
image1.jpg | image2.jpg | image3.jpg

When copying the image url, you need to add [Space] [line] [Space] before pasting the next image url.

If you need to find the image url, right click on the image and save the image address. The image address will look like this.

https://1mc51l3v9iyu3otpsg36nnvf-wpengine.netdna-ssl.com/wp-content/uploads/2017/10/presonus-faderport_16-top_big.jpg

Task: Build a 10,000 Product Database Fast

This month I have an interesting task of building a 10,000 product database.

The only problem is: I have about 30 days to do it.

Currently there are about 3000 products listed in this database and they are all optimized for search engines.

I have identified another 4000 products that are missing from the database that need to be added.

And, from historical data, can estimate that 2000-3000 products will be added this holiday season for Black Friday and Holiday sales.

Since I only have a small team to work with, we are going to have to cut this project up into pieces and make sure we are using resources efficiently.

Here’s the breakdown:

1) Focus on getting the MVP out

2) Tweak and Adjust in Bulk

3) Import and Submit to Search Engines

4) Maintain

This is just a theory and I will follow up in about a month to see how it pans out.

Step 1: Focus on Getting the MVP Out

With so many products missing from the database, we will need to focus all of our attention to adding them with bare bones listings.

Right now, if someone searches for a product not in our database, they get empty results.

I’d rather the database return a basic listing instead of nothing at all.

So we will focus on string the basic attributes:

Product Name

Brand

Price (MSRP if possible)

Image (Optional)

Step 2: Tweak and Adjust in Bulk

After these bare bone product listings are added, we can then focus on adding additional search attributes. Export out all of the listings added within a certain time range and edit them in bulk.

Add additional details such as product descriptions, gallery images, features, specs, and taxonomies here.

The fastest and most convenient way to do this is through a collaborative spreadsheet. I suggest using Google Sheets and collaboratively working on sections based on priority.

If a brand sells well, prioritize them over a lesser known brand. If we know certain categories sell well (such as Audio Interfaces) then prioritize that over less ROI products.

Step 3: Import and Submit to Search Engines

Since we are on a tight deadline, not everything is going to be complete with 100% accuracy. This margin of error is fine at this stage.

Take this completed sheet and format it correctly for your database manager or website and import it.

This will update your simple listings with the added attributes.

After that’s uploaded, resubmit your website to Google/Bing/Baidu for indexing. This will probably shoot back hundreds, if not thousands of SEO errors, but those can always be fixed later.

Step 4: Maintain

Once the database has been filled, we need to focus on maintaining everything with updated listings and add new products that are released.

The easiest way is to have an XML feed directly from our vendors. This will dynamically update our database with the product data from the vendors database.

The only problem is most vendors don’t have these.

So we will have to rely on manually updating our listings via the price sheets we receive.

One dedicated person can handle this duty if they repeat the steps outlined above.