Skip to content

Marceel E. Marchena Posts

Don’t Be Afraid to Ask A Professional

Don’t be afraid to ask a professional for help.

They know more than you do.

They usually want to help.

They can help you NOT make rookie mistakes.

For example,

Last night I asked a coworker’s advice on what image to post on Instagram.

She has a better eye for quality (and probably gets 10x more likes than I ever will).

She basically looked at the images I took with my iPhone, grimaced at them and chose the least crooked photo out of the 4.

The post performed well.

And this method still hasn’t failed me yet.

If you ever doubt yourself, reach out to a professional. They’ll end up saving you a lot of time in the long run.

Are We Under Cyber Attack?

First the FCC announced they plan to vote on ending internet freedom, now everything tech is malfunctioning.

Our site keeps delivering 500 errors.

My computer won’t let me write to our servers.

Our phone systems are glitchy.

And now McDonalds tablets are acting up.

Coincidence?

Maybe…

How well do you understand your job?

You understand a concept.

You’ve tested it.

The theory makes sense.

You understand the process.

You have the right tools.

You know the steps.

Your method is foolproof.

But ask yourself…

Can you teach this method to somebody else?

How well do you really know your job?

Can you teach someone your process and expect them to deliver the same results you do?

Maybe.

But probably not.

Or, maybe you’re scared of teaching them.

Scared to teach someone how to do your job.

Scared that teaching them to do your job will lead to you not having a job.

Think about it…

Sometimes you need help doing a task.

You know that extra hand can help you be more productive.

But you don’t do it.

You make up excuses.

You make an excuse about not having excuses.

And then you say, I can do it on my own.

How well do you really understand your job?

*Re-reads job description*

Oh nevermind, that task is not in my job description.

(another excuse)

Too Busy to Do Anything

Ever been so busy that nothing seems to get done?

Feeling like that right now on my Uber ride.

Tired

Exhausted

Mentally…but not so much physically.

The belly grows

The numbers show production, but nothing is getting done.

You start dabbling in this

You start dabbling in that

And at the end of the day, nothing gets done.

*Sips Coffee* ☕️

Who works on Weekends?

Wake up: 8:00am

Do Laundry: 9:00am

Go to Costco: 11:00am

Take a nap: 1:00pm

Go to work: 4:00pm

I’m behind on projects. Might as well catch up while I have the day off.

Music. Coding, Designing,

Water. Tea. Bathroom

Facebook. Repeat

Get off: 11:00pm

Just requested my UberPool and waited forever for them to show up.

I’m in.

The ride home is relaxing.

I enjoy seeing people dressed up in costumes and having a good time.

They must be celebrating Halloween. Even though the 31st is four days out.

Tonight is the night to party.

But not for me.

I’m a workaholic.

Im on my way home to relax. I’ll save my energy for the next one.

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.

You’re Not Trendy

Why do what everyone else is doing?

Be yourself

Do you.

Find your own style

Find your own niche

Find your own community

If anything, you write to entertain yourself. You use it as a way to recap what you learn and to remind you how far you have come.

And to think…

You always told yourself you wouldn’t do it.

Look at you now.

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

Just Another Friday

Have you ever been in a situation where your supervisor tells you to work on a task, but you have no idea how to do it?

You probably have.

This happened to me today…on a Friday.

I was asked to create a custom post type template with PHP and connect it to our WordPress staging site.

Now…I’m pretty good at HTML and CSS, but anything outside of that, I struggle with.

But even with my obvious discomfort with the task I did it anyway.

I relied on Google to help me out.

I searched a few tutorials and web forums and was able to get the basic idea of what I needed to do.

But man…the coding.

The coding was so difficult.

I must’ve broke our staging site 3 times by misplacing a bracket or by looping in the wrong function.

So much frustration.

Oh is it already time to leave?

Deuces ✌🏼

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.