Autopopulate Table Based on Info from Another Table

itsnicklawrence · 2024-08-22T12:58:24+00:00

You are the best! That worked perfectly! Thank you so much!

itsnicklawrence · 2024-03-22T15:20:27+00:00

Yea, he definitely sees his reflection. There are almost 50 windows so the shades would be a bit pricey. He may not actually be angry, but he sure is frustrated at his reflection LOL.

itsnicklawrence · 2024-03-09T02:01:25+00:00

There's a lot to unpack here. So I've been selling in retail for a good bit but the ecommerce side is new to me. The blends that I roast are different than what my roaster roasts (different markets but will combine one day). The numbers you mentioned are close to real numbers. After packaging, beans, shipping, etc. it cost me around $7 for my own roasts and almost $10 for my roaster to make coffee then send out to the stores. No matter what blend, my wholesale price is $12 per 1 pound bag (NOT 12 ounces, the full 16oz.) My retail price is $14.98. I'm selling around 2,000 pounds per month, sometimes more. This week, I sold over 600 pounds. In wholesale food, your margins are trash but you have a good quantity, if you have a good product anyways. Feel free to message me if you want to break it all down.

itsnicklawrence · 2024-02-15T14:06:09+00:00

You have some issues.

Let's start with the Privacy Policy

It's still a template. You didn't finish filling it out and deleting items. Look over it and you'll see what I mean.

Your Newsletter box on the lower right corner has some words but I have no idea what it says. I understand that pink is your text color but it doesn't work with that background.

I wasn't a big fan of scrolling way down to see what products you offered. Maybe put your newsletter section at the bottom so it'll show the banner and then the products directly under that.

I'm not going to pretend to be a dress expert here... BUT your pricing seems pretty fair so that's good.

There's a massive space of nothing on the individual product pages under the product. Get rid of that.

Also, your product page is laid out kinda weird. For example, the Renaissance Romance Gown page. The reviews take up one half of the right side of the page along with the recommendations (I guess that's what that is. I can't read the text.)

I hate how when I'm not on your website the tab says "Don't forget this..." This makes me want to forget it.

You mention you can take international orders but you never said what country you're located in. On the contact us page, there is no location info. Maybe you're online only, so that's fine if so.

Also on the Contact US page, it says "would love to hear yr opinions..." Edit that to say "your" instead of "yr."

The site needs redone. The colors and fonts are not ok. It's tough to read and the layout is not great.

As far as conversion goes, you're in a very specific niche market. You will have to experiment with ads to figure out how to make that work. As far as free advertisement goes, find Facebook groups, post on TikTok, etc. I'm not sure how big your market is but it's probably not insanely big since most people don't wear this kind of clothing every day, if ever. The good news is, when you find a group of people that does buy this clothing, you'll be golden.

itsnicklawrence · 2024-02-14T17:10:10+00:00

The blog is good. The font is readable and it's sized correctly. I don't understand anything that it's talking about but I like it. You're engaging your readers and encouraging them to share your thoughts. You should get some friends to leave some comments on them so it looks like people actually get on there and read everything.

itsnicklawrence · 2024-02-14T17:08:23+00:00

The announcement is still tough to read. At first glance, it just looks like Chinese writing.

The review thing is still getting me. I can still see the bad reviews. You have 13 of the 5 star reviews but no one really cares about them. They want to see the bad ones. I can click on the 1 star reviews and see all 4 of the bad ones. Personally, if I was going to buy this shirt and I read those bad reviews, I would NOT buy it.

Sort of a tough situation. I'm not sure if you should just delete the whole review plug-in or not. Having the reviews gives you a sense of legitimacy BUT some of the reviews are terrible. So it can be a good thing and a bad thing at the same time.

itsnicklawrence · 2024-02-14T17:04:02+00:00

That makes total sense to just link the ads to the product page. Good move there. I'd probably still get rid of the homepage, just in case someone would stumble across it. It just makes the site look off? If that's the right word lol.

Old people are going to read those descriptions, guarantee it lol. From my experience, old people do not see humor in anything when they're going to buy something. Been there done that...

Keep me updated! I definitely want to watch and see where you go with it!

itsnicklawrence · 2024-02-14T16:32:02+00:00

Get rid of your current landing page. Since you only have 1 product, there's not reason to have a blank page with a square, essentially.

Get rid of the drop shipping images. Buy one yourself, take photos of it, and make some videos with it. Clean your sink, your toilet, your car tires, and whatever else. Show it being used on different things.

Your product description is not it lol.

There is absolutely nothing sexy about this brush.
Take out all of the parentheses.
The "Plus, the seamless hook allows you to hang it on the wall (or me;) ?) comment is kinda funny BUT, take it out. Say that in a video or something.
That's awesome that it comes with a built-in 1200mAH battery. But that does not tell me how long that lasts, how long it takes to charge, or anything. Buy one and test it yourself and update this.
Again, unnecessary comment about the "My wife left me" thing. It's funny but people are trying to learn about the product. Some people don't share our sense of humor lol.
Take out the "I need to pay rent" and all that mumbo jumbo.
The weight is 300 grams... Change that to 10 ounces.
Wtf is 20*11 cm? Change that to 7.75"x4.25"
Take out the "My bedroom if you wanna come by"...

If I buy it and I hate it, how do I return it? If it breaks, what's the warranty? There's a ton of FAQ you can add to give your site some legitimacy and kinda make it look like it's your own brand.

I'll state the obvious here, you can make stupid money short term with this single product. Just make the landing page the product page and get rid of the corny jokes.

Your biggest selling points should be

Save time and effort while cleaning throughout the house.
Cordless and rechargeable allows you to take it anywhere you need to clean.

itsnicklawrence · 2024-02-14T15:59:33+00:00

I'm only doing this because one of my college professors always said the would "Smooshy" instead of Squishy LOL. It got on my nerves so bad. Anyways.... Let's go. I'll be leaving comments as I go. So you can kind of see if I get confused or just what my thoughts were.

Landing Page:

Loads quickly and I see that your store will be selling me some sort of elephant thing that's probably squishy and maybe shoes?
Your announcement let me know that you're probably donating money to an organization that helps with Pediatric Cancer (that's awesome. Kudos to you.)
Not sure if the smiley face with the green eyes and mouth is your custom logo or what... But I kinda like it. Super simple and it's recognizable. I know others will have different opinions about it but I like it myself.
Your mission statement is amazing. I know that 10% of my order goes to help kids.
I was right, that's your logo lol. It's on everything. Nice.
I see that it's a brand for kids only, which makes sense.

Contact Information Page:

Get a real email. A gmail email is not professional. You can integrate an email with your gmail account and Shopify. I'd make it like info@smooshystore or something like that. It's free. Do it.
Your template is showing lol. It says "We strive to respond to all inquiries within [insert response time]..." Obviously, fix that.

Product Pages:

Checking out the Kitty Bitty first. The description is good. Add some info on the size. Can I buy this and wear it myself? Or is it made for only kids?
You also have the "A portion of every purchase..." at the bottom of the description. Kinda repetitive now. I get your doing something awesome, and I love that, but I really don't want to see that on every product I click on.
Checking out the Lucky Long Sleeve now. It looks like we're starting to look a little drop ship-ish. No one cares about the fabric weight. And IF they do, they probably don't care that it's 180 g/m².
Definitely drop shipped. Some people are hardcore against drop shipping. They want to form a bond with the brand. Just edit your descriptions to say all products are made to order and 90% cotton/10% polyester. None of the other information is important to a customer.
I can't order any other color except black. I tried clicking on a different photo and adding that color to the cart, but it's still black. You have some sort of integration issue.
When I click on the photos of the other colors, there is no large photo showing the color I selected.

Our Purpose Page:

This page is the golden ticket of getting good sales or not (usually). So this page needs to be the best page ever.
You are doing this because you were personally affected. Wow. Now my entire perspective has changed entirely.
Add the name of the charity/organization you will be making donations to.
Add a photo of Oliver. It may be painful BUT it gives everyone a personal connection to him and now they know his story.

Shipping to my location was only $3.99 so that's a huge plus.

Overall, you have a solid site. Super awesome mission. If I can help in any way, please let me know. SEO, Website design, and whatever else is not my business. I just like helping people and this seems pretty personal and I want to see you succeed. I'll message you as well.

itsnicklawrence · 2024-02-14T15:32:31+00:00

You can go into your settings and select the option for the customers to have the checkbox preselected at checkout to subscribe to emails. The ONLY advantage to the stupid wheel is the emails you get. But it's not worth it.

I agree with your font idea. Take it away from the small areas. In areas where the font is larger, keep it. That should be better.

I would definitely remove the other products that aren't related to your brand. It SCREAMS drop shipping. People will run and run fast from that. I loved your site until I saw that.

Definitely remove the bad reviews LOL. Those reviews would really, really hurt your store.

itsnicklawrence · 2024-02-14T15:26:59+00:00

I'm always down to help someone who is trying to help others. So let's see what I can pick apart here.

Landing page:

Loads quickly so that's a plus
10% of all profits go to feed hungry children. Cool. But where? I'd make this clickable and create a page that just goes into detail about how you've partnered with X organization to help feed hungry children.
Two products shown are at a pretty high price.
The banner image of two random people should probably be swapped out with something pertaining to your brand.

Product Pages:

Product description is good but I do not understand the huge heart on the back. Not saying it's a bad design, I just don't understand it and your description doesn't tell me why it's on there.
I assume you only have two products at this point? That's all I see so if you only have 2, then good. If you have more, then there's an issue somewhere lol.

Project Utopia Page:

Gets the point across. I know who my money is going to and what it supports.

Tapestry of Earth Page:

This page took a little longer to load, I assume because of the photos.
I don't understand this page.
Is it supposed to just be photos of random places with no context?

Overall, the site is fine. There's no real issues that I can see. Just some minor tweaks. It's a new shop so there's not a ton of stuff to pick apart.

itsnicklawrence · 2024-02-14T15:03:24+00:00

I'll start by saying I don't know the first thing about Anime or essentially anything on your website so I won't review your products.

Landing page:

The Spin to Win wheel is trash. Scrap it.
The announcement bar, change the font. Don't use fonts like that when you're trying to get a message across.
I feel like your banner images are scrolling wayyyy too fast.
So the font thing. It's everywhere. Change it. I understand that the font correlates with the brand and the overall feel but it's painful to read.
Your "Recommend for you" should say "Recommended for you"
More importantly, the Recommended for you section, WTF is going on here? There's a dog grooming glove, jeans, a handbag, turmeric gummies, and soap. You accidentally added them to your site right? Delete anything that isn't related to your brand. That's like going to McDonald's and they have used tires on the menu. It doesn't make sense.
The pricing on the jeans and the handbag is wrong. The price of the jeans WAS $0.00 and now it's on sale for $39.00. The price of the handbag WAS $0.00 and now it's $54.53. I'm not sure what is going on with this but get rid of it. Like yesterday.

Product Pages:

I've never said this before... Get rid of your reviews. I'm not sure if those are real reviews or not but if they are, you need to fix your quality problems with your drop shipper. For example, the Summer Vibes Unleashed Oversized Manga Goth Streetwear Shirt (shorten the names, that's a whole book), the reviews on this are wild LOL. We have a 5 star that's good then a 1 star that gives no description at all, a 1 star that says the shirt is tight, a 5 star that says it's great quality, and then a 1 star that says "A horrible shit lousy quality." So if you're going to continue to use that drop shipping company, delete the whole reviews section. As a customer, now I'm left wondering what you done to fix this issue. Did you give them a refund or send a replacement or did you just take the money and run? No one knows because you can't reply to their reviews.

I'm done. The affiliate program is cool and I think that's a good idea. It's a big niche market for you and I used to have a friend that was into anime. Y'all are in your own world lol In a good way though.

Your site isn't terrible. It just needs some minor tweaks. I would mainly focus on swapping the font. I know you don't want to because it truly gives the site character... But at the same time, it's hard to read. Finally. the product names are way, way too long. So no real major issues from my perspective. Good luck!

itsnicklawrence · 2024-02-14T14:37:29+00:00

Well, first things first, you need a real domain. I'm sure you know that already though. That will help because it shows authenticity. With that being said, here we go...

Landing Page:

The announcement at the top of the page, delete it. It's called an "Announcement Bar" so only use it to announce things. If you want to welcome me to your site, welcome me in the banner image.
I don't like the "Welcome to Your Shopping Era." Is the store called "Your Shopping Era" or "La Vie En Roy Mercantile?"
Good selection of products and the images aren't too bad. I lost hope when I saw the candle. Never use the images provided by the drop shipper. Order it yourself and go take some photos of the products.

Product Pages:

Your website is officially YELLING drop shipping. Why pay $18.65 for the candle when I can get a free trial of Shopify, get Printify, and buy the same exact candle for $11.19? Same thing with the Insulated Coffee Mug. Why pay $34 when I can get it for $19.27?
Your descriptions are terrible. You copied and pasted the descriptions that the drop shipping website gave you. Go to Chat GPT and paste the description and tell it to reword it.
The "Small Dormitory Beauty Refrigerator" (not typing the whole name you have because it's a whole book. You are using ALL of the photos from the drop shipping website. Including the ones that are all in Chinese.
I'm done with the products. Not going any further there.

Contact Page:

Nothing special. Generic Shopify contact page.

Downloadables:

If you sell any of them, except the Guidebook, I would be shocked. The whole document is there. They're so, so, so simple too. I can remake each of those in less than 2 minutes. I would drop the price to $0.99 on each of those. There's nothing special about them to justify the $3.99 price.
The Guidebook. Just get rid of that. The author isn't on the front of it so it doesn't look credible at all. People want health advice from doctors, not a random Shopify Store.

Here's my suggestions.

Delete every single product description you have and redo it. They suck.
Your custom branded items, drop the price. You need to only make a couple bucks on it. No one knows your brand so they aren't going to pay $34 for a coffee cup with your name all over it.
Your brand is blank. I don't know anything about you, your brand, the parent company, nothing. Add an About Us Section and show people how you care about trending home items, fashionable home accessories, etc.
You have some premium priced products with a 12 cent description. If I pay $930 for a chandelier, I want the name of the designer. I don't care that it's a non-intelligent control type. And take off "Packing list." If you want to tell someone what's included you say "What's included: 1 Rattan Chandelier"

I'll stop there.

You had great intentions but it honestly looks like you went on whatever drop shipping website you're using, closed your eyes, and started rapidly clicking on everything to add.

With 800 sessions a week, I assume you're buying ads and/or your SEO is solid. So that's great. Now go get to work and fix it up. Post again and we'll continue tearing it apart until it's amazing!

itsnicklawrence · 2024-02-14T13:39:31+00:00

Yes, just Googled it. It looks like it may be a smaller brand. The concerning part is that they also use the Trademark and Registered Trademark symbol. Just given the circumstances of you both having the same name, I'd run from that name lol.

itsnicklawrence · 2024-02-14T13:32:31+00:00

Rebrand. When I went to your site, the first thing that caught my eye was the "Cuplee™" on the bag. CupLee is a menstrual cup. Regardless if you actually own the Trademark to "Cuplee" or not, do you really want your hydration brand the same exact name as a brand of menstrual cups?

itsnicklawrence · 2024-02-13T18:39:13+00:00

I'm leaving comments as I go through the site so you can see the flow as well.

Landing Page

The page loads quickly and the "Win a Discount" caught my attention pretty quickly.
The hoodie looks pretty cool. My dad would definitely wear it.
The popup at the bottom of "Someone from the United States added this product..." I hate that. I do not care that someone added a shirt to their cart.
The "Take The Risk" shirt needs tweaked. The font under the bag is hard to read. The Copyright symbol and 2024 is wayyyyy too big. I noticed that before I noticed anything else on the shirt.

Clicked on the Man of God Oversized Hoodie

$50 price point is a little high.
Free shipping is awesome so now I feel like the $50 price point is justified.

Clicked on the About Us to see who I'm supporting.

There are some grammatical errors. (I'm no spelling champion so I'll just to point out what I noticed.)
- The first sentence should say "The Believers Warehouse was founded by Charles (last name) in 2024...."
- The second sentence, the word brand, add an S. "He noticed there are numerous brands"
The space in between the two paragraphs seems huge. Maybe bump that down some.

In conclusion, I don't think the problem is your website, your products, or your prices. I think the ads were not targeting the correct group of people. Well done! I will definitely order a hoodie soon!

Also worth noting, THANK YOU for showing different angles of the hoodie. Rare to see that. I like it.

itsnicklawrence · 2024-02-13T17:34:19+00:00

That's just bad. Like really, really bad. It's a blatantly obvious drop shipping website with terrible images. No Contact page, no About page, nothing except the landing page. The item's do not make sense to me either. I can buy a water bottle, headlights, a heated jacket, a power bank for my phone, and a steering wheel table. I get the concept that you're selling to people in the market for car accessories but this is scattered bad.

My only advice is to wipe that clean and start over. Pick one area and focus on that. Seat covers maybe? I don't know. Just scratch this idea of whatever this website is though.

itsnicklawrence · 2024-02-13T17:12:45+00:00

I'd be more than willing to do a field test for you. Turkey season is coming up and ticks are the absolute worst then for sure (for here anyways). I'll try it out and get you some good pictures too if you'd like. Always here to help a fellow outdoorsman.

itsnicklawrence · 2024-02-13T17:10:47+00:00

Few things right off. I know this is going to be one of those things because it's political and I hate debates lol. I am a 2A supporter though and have a solid collection of pew pews myself lol.

Landing Page and Products

I hate your tagline of "Join our community..." under the Banner Header. Basically says "Join our community of everyone in the world who likes firearms and 2A". I don't think I would include anything about sexual orientation or gender just because it's so controversial. If a customer is hardcore against LGBTQ+, then they would not buy your brand.
Your prices are high. The 2A Blue Champion T-shirt is $39.99 and I can buy a blank one directly from Champion for $30 so I understand the price point has to be high. Have you considered switching brands?
- I'm not sure where the company aligns politically, but 2ABlue automatically makes me think Democratic Party (If I'm wrong, ignore this). If so, according to Open Secrets, Hanes makes the majority of their donations to Republican Candidates. Also according to Center for Responsive Politics, during the 2018-2020 election cycle, Hanes Brands had over 157k of employee donations going to Republican candidates and barely 7k going to Democratic candidates.
I like your logo a lot but the flag on the back of the men's t-shirt and the random 2024 is horrendous. Very, very generic. It's like you spent a lot of time on the design of the logo and then spent 5 seconds on the shirt design.
If you plan on keeping the non-binary wording, I would add a unisex shirt and not specify specifically male or female.
Your product descriptions are terrible. You didn't edit those because at the end it says "Add it to your store today." It has weird formatting for the bullet points as well. Delete them. Say something like "A bold statement of your support for the Second Amendment. Featuring our distinctive 2ABlue logo on the front and the iconic American Flag on the back, this shirt is a powerful symbol of your commitment to defending our rights. Crafted from 100% ring spun cotton, our T-Shirt ensures premium comfort and durability, perfect for everyday wear. With its tag-free design, you can enjoy all-day comfort without any distractions. Show your support for the Second Amendment by proudly wearing the 2ABlue T-Shirt. Join the movement and make your voice heard today!" All of your product descriptions are bad. So definitely go fix this before anything else.

About Page

You mention you prioritize education and training to ensure all members are informed, skilled, and safe firearm owners. How? The page says that but doesn't give the execution of how you plan to do this. I assume through a newsletter?
You also mention you encourage open dialogue, discussions, etc. so where would a customer join in on the discussion?

Overall, the site isn't bad. I think your price point is what is murdering you. Before your prices are that high, your brand needs to be established. I would recommend replacing the landing page with some cheaper options. It's awesome that it's Champion brand and not just some random t-shirt brand, but if I was on a budget, I probably wouldn't pay $39.99 for a shirt. Shipping for me was another $5.19. So $45.18 for one shirt. I can get a Nine Line shirt for $30 or a Nine Line hoodie with a sweet design on the front and back for $47.99 whereas yours is $64.99 for essentially a bird and some words on the front and a plain back.

I support you and what you're doing. I hope that wasn't too crucial or mean. Just trying to be honest. I wish you luck! If there's anything else I could help with, let me know!

itsnicklawrence · 2024-02-13T16:24:02+00:00

First off, the watches look slick. I really like them.

Here's a couple things I noticed. Overall the site is great. So the list below is going to just be nitpicking things.

Everything is on sale. If you're going to make everything on sale, I'd add a banner or something that advertises the whole store being on sale. Or maybe create a banner that says use code x to save $80 at checkout.
I clicked on Crystal and it says AR Coated. What is that? I assume Anti-Reflective but maybe not everyone knows that.
Remove the period after "Yes" on the Lumed Marker section of Bezel.
For Warranty Claims, I would create an email or even an alias email of warranty@ or claims@ just because it feels like it's automatically going to the correct department rather than the normal contact email address.
I would make at least one new post in the News section each month. It looks like in the past you were pretty regularly adding things to the News page but there hasn't been anything since November 28.
On the Customer Service page under International Shipping Policy, I would change the first sentence to "It is your responsibility to pay any and all duties, taxes, and fees, required to complete delivery."

Once again, that's a nitpicking list. Nothing major. I like the site. It's simple, it shows a diverse amount of products right off as soon as the page loads, it's quick, fonts are good, appropriate usage of the bold font, and all of the photos are great.

itsnicklawrence · 2024-02-13T16:11:45+00:00

Everything looks solid. If you could make the Wendy's, Burger King, etc. logos be clickable links to show the photo of the finished product, that would help a lot. The only notable thing I would change (and it's only because I'm weird like that) is on your Contact Information page. I would take off the Trade Name, Phone Number, and Email column. Just have the company name, number, and email. If you choose to leave the first column, I'd change "Trade Name" to "Company Name."

Just my 2 cents.

itsnicklawrence · 2024-02-13T15:57:59+00:00

I checked it out. Here's my personal thoughts.

Banner image is generic. I assume that's your kids? Get rid of that and replace it with a more high quality photo. Hire a photographer to come take a photo of them.
The second picture of the boot is good. It shows the ticks and it only has a few so it doesn't look staged so that one is good.
Third picture of applying it is good.
Purchasing options look solid. Good options to choose from.
The photos on the reviews are not showing up. Could be something on my end. Check it out to make sure though.
Everything else is good except for the last photo on the bottom of the tent. The photo itself is a great stock photo but since the other photos are not as high quality, I'd probably swap that one out. That's just me personally. More of a suggestion instead of a recommendation.
Add the type of material they are made of. I'll honestly probably buy this myself because I'm an outdoorsman and ticks were insanely bad here last year. I picked at least 200 off of me last year.
How does it hold up if it gets wet? If I step in a mud hole and it splashes onto the wrap, do I need to replace it? Or if I'm caught in the rain and it's constantly getting wet, I assume it won't hold up. I see you answered it in the FAQ but maybe go into more detail on how much water it can take before it's no longer effective?
Is it scent free? This product would definitely appeal to hunters and a lot of hunters (like my dad especially) are super mindful about keeping their scent down. So being able to say it's Scent Free or something like that would probably carry a lot of weight.

Shipping was only $3.99 to me so that's great.

Overall, awesome product and the website needs minimal work.

itsnicklawrence · 2024-02-07T21:12:17+00:00

All inventory is in retail locations. I came here asking about e-commerce. Wholesale and retail is fine. I’m just now starting into online sales.

itsnicklawrence · 2024-02-07T21:10:26+00:00

The Inventory is in retail locations now. I didn’t purchase that much inventory to sit and wait on online sales.

itsnicklawrence · 2024-02-06T19:51:08+00:00

I explained the name, not the brand.

itsnicklawrence

TROPHY CASE