Jump to content

Recommended Posts

10 hours ago, fridgebox said:

how do i know what is the:
"Original Encoded Data" (Highlighted in green).

I do get your point, but it's outside the scope of the storage of the Data... 🤷‍♂️


Help shape the future of Phoenix; join the Phoenix Club

Share this post


Link to post
Share on other sites

@BrockleyJohn i think that is kinda what i said.
@burt especialy not. the GTIN-14 contains "most likely" the kind of package used. ( same site you pointed out https://www.gtin.info/itf-14-barcodes/)

Real use case:

Imagine my laptop broken or my fridge.
For it i require a replacement part ( sometimes these numbers are ven inside the manual or on the part itself)
Now i wanna find on the internet the cheapest replacement part.
What number i should lookup?
The one on the part, right?
If use on the webshop a GTIN-14 , it is totally useless in this case.

You product will never be listed on the search engine.

But i made my point in what i tried to say for now.

Edited by fridgebox

- ICECAT specialist.
(Icecat: open feed with product information, data-sheets for oscommerce.)
- CSV IMPORT specialist.
(manage your suppliers via supplier manager)
Contact me via PM.

Share this post


Link to post
Share on other sites
2 hours ago, BrockleyJohn said:

If you are having trouble with the zero-padding of the data in osc you can just use string manipulation in your sql to cut it back to the required length, or use a numerical comparison.

This is the point i was refering to @BrockleyJohn as it is impossible to figure out if must cut 1 zero or 2 zero's to figure out it is a GTIN-13 a GTIN-12 or a GTIN-8 inside this GTIN-14.

Sigh.... now i really have to stop.


- ICECAT specialist.
(Icecat: open feed with product information, data-sheets for oscommerce.)
- CSV IMPORT specialist.
(manage your suppliers via supplier manager)
Contact me via PM.

Share this post


Link to post
Share on other sites

I'll try one more time...taking your pallet example;

  • You buy a pallet of laptops. 
    The pallets identifier is 12345678901234
    This means *nothing* to hardly anyone. 
    Who cares about it other than you...the next time you want to buy another pallet.
  • Each Laptop inside has an identifier
    0987654321123

In your shop you would sell individual laptops at 199.99 each, and in the GTIN input field you would insert:  0987654321123

That would allow your branded laptops to be sold on Google Shopping by you.

Does that make it more clear?  

I understand that you are struggling to come up with code to plug into a suppliers CSV, but that's outside the scope of oscommerce.


Help shape the future of Phoenix; join the Phoenix Club

Share this post


Link to post
Share on other sites
28 minutes ago, fridgebox said:

Real use case:

Imagine my laptop broken or my fridge.
For it i require a replacement part ( sometimes these numbers are ven inside the manual or on the part itself)
Now i wanna find on the internet the cheapest replacement part.
What number i should lookup?
The one on the part, right?
If use on the webshop a GTIN-14 , it is totally useless in this case.

Above example has nothing to do with sell on google shopping.
of course it is clear, but you even provide wrong data to google for your item.

Please take a look here: as THAT is GTIN-14 does https://www.gtin.info/itf-14-barcodes/
I repeat one more time ... by putting 

 

4 minutes ago, burt said:
  • Each Laptop inside has an identifier
    0987654321123

In your shop you would sell individual laptops at 199.99 each, and in the GTIN input field you would insert:  0987654321123

You insert a GTIN-13 in the field and ad a 0.
Now look in the above link the image as example the representation "GS1 Company Prefix"
It contain even two 0's.
There is no way to figure out what is the EXACT GTIN-12, GTIN-13 or GTIN-8 or even any other reference the ITEM.
The GTIN-14 is used for BATCHES of the same item.

It is not me who has it wrong.
In this case the adding of 0's in-front is obsolete. The information on gtin info website is misunderstood.

But i really now want to rest this case.


- ICECAT specialist.
(Icecat: open feed with product information, data-sheets for oscommerce.)
- CSV IMPORT specialist.
(manage your suppliers via supplier manager)
Contact me via PM.

Share this post


Link to post
Share on other sites

It believe it is you who is misunderstanding the concept.  The GTIN site clearly states that storage of GTIN *must* be 14 digits.

That you can't code a script to read that, is on you.  I found a nice class at phpclasses which you'll find useful. https://www.phpclasses.org/package/8560-PHP-Detect-type-and-check-EAN-and-UPC-barcodes.html

 

Edited by burt

Help shape the future of Phoenix; join the Phoenix Club

Share this post


Link to post
Share on other sites
Posted (edited)

Gtin-14/Ean-14 usually use internally for track packages or pallets and sometimes for complete box of boxes,
a box is more normal use a different ean13 or upc12, and individual package use other ean-13 or upc-12 or ean-8.
The normal is each manufacturer use one gtin for a specific quantity, but the rules not respect for all, and would use the same for all packaging.

@fridgebox the question is control digit with this you can calculate if code is correct and know type of code.

For example ean-8 : 88015514, GTIN-8 OK
000088015514, GTIN-12 OK
0000088015514, GTIN-13 OK
00000088015514, GTIN-14 OK

https://eancheck.com/

You can view js code algorithm for check and reuse it.

I'm with you in that it's confusing, but it seems that it can be handled without having to add or remove zeros to compare.
When export with easy populate the code export correctly without adding zeros, so I write ean-13, in admin show with plus zero but in the shop show ean-13 without adding zero, and when export the same.
The only problem is admin page or data stored, they can make you doubt for codes start with 0, and not is plan is check every time...

000–019 UPC-A compatible United States and Canada
020–029 UPC-A compatible - Used to issue restricted circulation numbers within a geographic region[m]
030–039 UPC-A compatible - United States drugs (see United States National Drug Code)
040–049 UPC-A compatible - Used to issue restricted circulation numbers within a geographic region[m]
050–059 UPC-A compatible - GS1 US reserved for future use
060–099 UPC-A compatible - United States and Canada

That's why I think not is necessary add zeros for not lost type of code, what's the point of changing an ean8 to gtin14

https://www.gs1.org/sites/default/files/docs/barcodes/GS1_General_Specifications.pdf

Reading the 2.1.1.10 GTIN data string, show not is a rule stored with zeros but it is optional

The presence or lack of these leading zeroes does not change the GTIN concerned.
Note: GTINs may be stored with or without leading zeroes in the same database field,
depending on the requirements of the particular application.
Note: A GTIN-12 may start with one, two or three leading zeros. These zeroes are
meaningful since they are part of the U.P.C. Company prefix, and therefore these must be
preserved when storing the GTIN-12 in a database field. For the list of U.P.C. Prefix ranges
see section 1.4.

https://www.gs1.org/sites/default/files/docs/barcodes/GS1_GTIN_Management_Standard.pdf
https://www.gs1.org/standards/id-keys/gtin
https://www.gs1.org/1/gtinrules//en/
https://www.gs1.org/sites/default/files/docs/barcodes/Missing-ID-ImpGuide-i1.pdf

Note: https://www.gtin.info/ not is official gs1 site, use https://www.gs1.org/

In other improvements I think various gtin for product is need one product not only one. And the relationship with the quantity would not be bad. And set default too.
And need MPN field, without needing add extra fields , model actually use for own code, so or use for own code or use for mpn, is limited use at now.
In osc 2.2 use module model2 for solution this.

Use MPN how key no is a good idea, is easy change some thing, and some manufacturers use spaces or include characters not alphanumerics...
gtin/ean/upc are unic, only numbers and have digit control, is unique key 1<->1.

Other thing is mask use, How amazon or other little stores, who have indexed pages with the code and you can search in the shop with code, but not show in the source page,
this is used for difficult and occult info to competitors and scraping data... Search is easy, but how they get indexed by code not show at the page???

Edited by domiosc

Share this post


Link to post
Share on other sites
4 minutes ago, domiosc said:

Search is easy, but how they get indexed by code not show at the page???

You put it in your google products feed (via adwords or merchant center)


For a new install or if your store isn't mobile-friendly, get the community-supported responsive osCommerce (Phoenix).

here: on the official osc download page

Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x

Share this post


Link to post
Share on other sites
On 8/22/2019 at 11:35 PM, burt said:

Note that Google Shopping does require use of GTIN, whereas use of MPN is not mandatory.

I suppose we should add a new field specifically for MPN?

Told yah!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×