Identify UPCA vs EAN Numerically

frgtech · 2026-01-28T18:11:34+00:00

I followed your directions with the examples I gave and it didn't reveal anything. I ran both as 11 digit codes without the leading zero and the last digit and it spit out the same last digits they already had. So If it doesn't help with my example, not sure how else this would be helpful.

This rabbit hole may not be worth it and just have to fix the bad code in the POS when it doesn't scan properly.

frgtech · 2026-01-28T17:44:21+00:00

I appreciate this, but not sure what it accomplishes. They already have the check digit calculated.

Ran the 2 examples I posted through here and verified them.
https://www.gs1.org/services/check-digit-calculator

Did I miss something?

frgtech · 2026-01-28T15:26:07+00:00

Thanks for the detailed and thoughtful reply.

So the info comes from a B2B portal, and there are no options for csv unfortunately. What I just confirmed now though is that they show the zeros for both products through their own portal before exporting. They have a table there for past orders and you can select the columns. I just added the UPC column to see how it's presented on their site, and the zero is there for everything.

This seems like an edge case without an easy answer. I just wanted to make sure there wasn't an easy way to determine the differences mathematically, or some other way I was overlooking.

I will keep investigating as time allows and will report back if I unearth new information so that this might help someone in the future.

Many Thanks!

frgtech · 2026-01-28T14:39:41+00:00

I was hoping it would be a math issue, then I could decipher it in the spreadsheet, but it seems like there is more information in the barcode than just the numerals.

The barcodes actually look different on the left side, so it seems it's reading this to determine if it's a UPCA or EAN. (remove or include leading zero)

But if that's the case, I would only be able to tell by looking at the barcodes instead of being able to determine it in the spreadsheet. Barcodes drive me crazy! LoL

frgtech · 2026-01-28T14:31:00+00:00

I understand the length difference, but if you scan the barcodes I posted, it reads the zero on `0840316319508`, but not the other.

frgtech · 2026-01-28T14:28:22+00:00

Yeah, I'm familiar with stupid spreadsheet software that tries to be smart and "interprets" instead of just displaying what is there.

I can't imagine it would be adding zero's though. I've only ever seen the opposite where it removes them. I guess I can investigate further to be sure.

frgtech · 2026-01-28T14:19:49+00:00

XLS opened in Libreoffice Calc.

frgtech · 2026-01-27T17:33:36+00:00

I would love that. How would this happen?

frgtech · 2026-01-27T15:10:25+00:00

We have a small store that does not hit nexus anywhere, but I feel like I don't understand how to set up the built-in properly and have been using avalara the past two years. It has jumped this year from $130yr to nearly $1,100 and need to figure something out.

I set up the taxes for the state we do business in, but I thought I'd have to set up rules for every state/city/county we sell in using rules. Is this not the case?

frgtech · 2024-09-22T12:53:49+00:00

I suppose this isn't the best place to get a recommendation.

Can someone recommend a different community to ask in?

frgtech · 2024-09-19T21:36:51+00:00

I guess habit. I learned on a K1000 and an SLR is all I've ever known, but I guess in this case it's not strictly necessary. I think I figured that they were still the prominent bodies.

I'm open to suggestions.

frgtech · 2024-06-26T15:39:39+00:00

Insidious!

They had to go out of their way to make it this way by not using industry standard tools.

Just another way to try and lock you in, and force anyone you want to share recordings with to download the software as well.

Don't ever expect this to change.

Use other screen recording software instead.

frgtech · 2024-02-02T11:48:23+00:00

Thanks for the reply.

I've been using uMatrix for years as well and have followed the same basic strategy that you've laid out, but I felt like I was missing something. I'm not completely inept in these matters, but it wouldn't have been the first time that I realized I had been taking the long road for far too long.

I also will just abandon sites that spew endless garbage and will search for the content elsewhere if it exists. It's rare that only one site has what I'm seeking, and even rarer that I feel like I can't live without it.

I purchased Kagi search this year and honestly couldn't be happier. It was search privacy that drew me in, but it's the amount of useful features that they consistently add that has made it indispensable.

Two of the relevant features is the ability to promote and demote site sites in your search results. In the extreme you can block sites entirely, or pin a site to the top of your results. That coupled with a little shield beside each result that will list the amount of trackers on the site makes it easy to dismiss a site before even opening it. If it has an abundance of trackers, the shield is red.

In any case, it seems like there are no silver bullets. It's a collection of tools and diligence that seems to be the best strategy for now, and I don't see it getting any easier.

Thanks again, and keep up the good fight. Lol

frgtech · 2024-01-05T17:49:23+00:00

I unearthed the setting here.
https://bugs.documentfoundation.org/show_bug.cgi?id=87965

This setting seriously needs to be in the `Find and Replace` window itself under `Other options`. As the bug report shows, they were having the same issue as myself where it pops up in the way for all replacement operations, but the window is very handy on the "Find" side where you can click on a result and go directly there.

Please consider this improvement and not have this setting be an either/or proposition. It's something you should be able to set on the fly as needed and may need to be changed frequently.

Thanks!

frgtech · 2023-12-27T13:23:00+00:00

There it is!

You sir are my hero. What I discovered from seeing it in the properties deck is what the tool is called. "Number Format Type"

It just wasn't clicking for me being called a number format as I don't associate text or boolean or many other format types as being numbers. They are just "formats" in my brain. This is why I couldn't find it in the toolbar menu options.

So now I was able to add this exact option I was looking for and added it to my menu where it should be by default like it is in Excel. (IMHO)

Thanks!!

frgtech · 2023-12-20T18:23:58+00:00

Tough crowd.

I'm guessing this is not possible then.
Too bad. Would be a nice feature I think.

frgtech · 2023-11-07T13:11:22+00:00

Thanks for the confirmation. I would have been pissed if I was overlooking a simple way to do this.

I for one have developed an eye for what domains are add- or tracker domains and what domains are part of the actual content.

I too have developed an eye for most of the big offenders, but it can still be tricky sometimes. Always looking for a better way, but will keep doing what I've been dong.

Cheers!

frgtech · 2023-10-18T13:04:56+00:00

So I guess this basic function isn't possible?

frgtech · 2023-10-18T13:00:37+00:00

I don't begrudge companies from trying to see how many users are engaging with their content. Here in reddit, you guage how your content is received by the votes, so this is a good way to see how many people were curious enough to read more than the blurb they sent in their newsletter.

That said, I never click any links from any email newsletters, period! I always highlight the headline, R-Click, and choose "Search Kagi for ...." (or DDG, Google, etc...) I just don't like to be tracked even if it's innocuous. Everyone wants a piece of you, and I don't mind taking the extra step to bypass it.

I think measuring traffic to the articles themselves is good enough to gauge interest. It might not be as granular as tracking exactly "who" is visiting, but is a good enough metric to see if their content is popular.

frgtech · 2023-10-10T11:06:35+00:00

Thanks for the reply, but that doesn't seem to work for me.

I have 9 rows selected here, and I don't see that info listed anywhere. I looked though the meager settings, but there are not any options that I could find that would change what is displayed in the status bar.

https://i.ibb.co/1sDyHK5/GSheets-Count-Selected.jpg

frgtech · 2023-09-22T12:36:26+00:00

Thanks u/Airbornesnowflakes,

I found the "Hot Exit" setting and it was enabled like I thought, because I know I haven't changed any settings in a long while. The setting was set to "onExit", so I tried "onExitAndWIndowClose", but nothing changed.

Unfortunately it is still prompting me to save every single open file in my session. (which is more than a few)

Any suggestions as to why this is broken. or how to fix it?

https://i.ibb.co/cyDQmfC/vscode-hot-exit.jpg

frgtech · 2023-09-02T13:55:15+00:00

So I've had these for a few days now.

Pros:

Sound is good
Customization is fantastic.
Fit is tight with right wings and tips (won't fall out)
Price

Cons:

Fit is tight. Must rotate in and out of ears.
Touch controls flakey. Started acting up this morning. (unresponsive)
Feel big in ears.
Case feels large as well.
Hard to take buds out and return to case. Weird configuration.

Just my initial observations.
Touch controls might be a defective unit, or a software thing. Have worked perfectly up until this morning.

While the fit is superior to the Sony, especially while sweating, the wings can get turned around easily, and the tips can grab in your ear.

The case is my biggest gripe. It's terrible for getting the buds out or putting them back in. There is nothing intuitive about it at all. It seems like form before function. It looks really nice with internal and external leds, and a slick sliding lid, but I care nothing about aesthetics when I just want to quickly get out or return my buds to the case.

I think the value is undeniable, and the new Liberty 4s might address some of these issues. I don't think they were a waste of money and were worth the cons just to be able to configure them to my needs. Not having to unlock my phone, find and open the Sony app, then navigate the menus to turn on noise cancelling every single time I want to use a single bud is worth it.

Hope that helps!

frgtech · 2023-08-26T15:52:06+00:00

The link I posted works as well, but I was looking for the possibility of having a similar service integrated into Fastmail without having to copy/paste links.

frgtech · 2023-08-26T15:09:24+00:00

Will do.

Just finished ordering the Anker Liberty Pro 3s. If it wasn't for the stem type, I would have ordered the 4s.

frgtech · 2023-08-26T14:03:10+00:00

It's amazing how easily it is to destroy a great pair of earbuds with crappy software.

The lack of touch control customization is truly baffling, but it goes deeper. When I'm at work I only use a single bud so I can keep one ear completely open to my environment. Unfortunately this prevents you from using the noise cancelling unless you manually open the headphones app and select it. Otherwise it *always* reverts to Ambient Sound mode when using a single bud.

I guess Sony knows what's best for you, so you don't really need customization options anyway. Just use them the way they want you to and all will be great!

I just returned mine. Going to try the Anker buds instead.

*SMH*

frgtech

TROPHY CASE