45worlds



45worlds Forums  »  Magazines  »  View Topic

Magazine Barcode Field   


Add Reply

  11th Jun 2015, 11:09 AM#1  REPORT  
Pridesale

Member since Mar 2013
792 Points
Appears 1 Digit too short on displaying
eg TV Choice (England)[2015] 9 772044 733022 09

The 022 indicates 2015 year, 09 9th Week
It was 015 for 2014 and I cannot read the older ones for now!


  13th Jun 2015, 8:25 AM#2  REPORT  
sladesounds

Turning rebellion into money since 1962
Member since Nov 2009
6552 Points
Moderator
If you check this site it states that UK barcodes are either 13 or 15 digits in length not 16.


  14th Jun 2015, 11:37 PM#3  REPORT  
Pridesale

Member since Mar 2013
792 Points
sladesounds wrote:
If you check this site it states that UK barcodes are either 13 or 15 digits in length not 16.

Some publications add a 2 digit supplement barcode after the main barcode – this can then vary with the issue eg it could be 01-12 for 12 monthly issues, or 01-52 for weekly issues, or 01-04 for quarterly issues. These barcodes can be reused each year – they only need to be changed when the price changes.

(I'll check Price changes IF I can re-read the Scans as magazines went in the re-cycling - I cannot afford the unit rents for EVERY bit of paper through my life)

(That is 15 barcode digits) Looks like Worlds has 13digit field length


  17th Jun 2015, 4:10 PM#4  REPORT  
Orbiting Cat

Member since Jan 2008
1167 Points
Administrator
Pridesale wrote:
Appears 1 Digit too short on displaying
eg TV Choice (England)[2015] 9 772044 733022 09

The 022 indicates 2015 year, 09 9th Week
It was 015 for 2014 and I cannot read the older ones for now!

Thanks for raising this. It seems that magazines sometimes have an extra 2 digits representing the issue number. I've extended the magazine barcode to support up to 15 digits now.


  24th Oct 2017, 2:19 PM#5  REPORT  
rustieneil SUBS

Member since Feb 2012
12628 Points
Orbiting Cat wrote:
Pridesale wrote:
Appears 1 Digit too short on displaying
eg TV Choice (England)[2015] 9 772044 733022 09

The 022 indicates 2015 year, 09 9th Week
It was 015 for 2014 and I cannot read the older ones for now!

Thanks for raising this. It seems that magazines sometimes have an extra 2 digits representing the issue number. I've extended the magazine barcode to support up to 15 digits now.

The barcode field appears to only be displaying 13 digits again. I've just added the latest issue (289) of "Mojo" and am pretty sure I entered the extra 2 digits. To check I found another recent entry (Mojo 286) where I hadn't previously entered the barcode, definitely added all 15 digits, but only 13 appearing.


  24th Oct 2017, 6:46 PM#6  REPORT  
Lee Wrecker

If you can't dig me, you can't dig nothin'
Member since Nov 2013
2282 Points
You will also find that some magazines have a UK and International barcode. Both Uncut and Mojo magazines are examples of this. So if we enter the barcodes should we have two entries one for the UK and one for the international versions of the magazines? This will also have consequences for the cover CDs that come with these magazines and make them all international or both UK and international. Or are we still going to turn a blind eye to this and pretend that these magazines are UK only publications as we have done for years now?

Edited by Lee Wrecker on 24th Oct 2017, 6:51 PM

  25th Oct 2017, 1:02 PM#7  REPORT  
ppint.

Member since Aug 2012
6389 Points
prob'ly the latter, at least initially - it's easier to do naught wrong, think about it, and then format things "correctly", than to change format, discover the new firmat isn't " right", introduce a new new format - and prob'ly need to re-re-format/re-entering all the items in the database to fit the new new format (iyswim).

- i _think_ the best choice would be to allow for a single entry to be given a second bar-code at time of initial entry or afterwards - together with a note of encouragement to the catter entering the item to enter both - local country (if there is one)/area/continent bar-code first, continent/international bar-code second - if there are two different bar-codes.

- this would allow the issue to be one item, which it is, indexable by either, depending upon whether one was querying by the country (etc.), or by the continent (etc.) - or by any of the other fields, as at present - and avoid immediately doubling the amount of "space" the item takes up, by treating it as two separate items with field entries identical in all-but-one fields.

- n.b. this does not deal with how 45worlds handles "the "international" question"°,°°, but it does provide as flexible a way as possible for however that question is eventually determined by the semi-divine beings in conclave°°°, as it preserves as much as possible of the - and all of the relevant - information in separate fields, for however "international" will later be treated. it does (currently) assume no items carry more than two bar-codes.


° - cf. "the muntab question"°°

°° - cf. the schleswig-holstein question

(both feetnotes are str - duckduckgoing/googling should not be resorted to, save to banish ignorance ;-))


  3rd Nov 2017, 8:22 AM#8  REPORT  
nboldock

Lend me ten pounds and I'll buy you a drink.
Member since Feb 2012
7132 Points
Moderator
Lee Wrecker wrote:
You will also find that some magazines have a UK and International barcode. Both Uncut and MojoOr are we still going to turn a blind eye to this and pretend that these magazines are UK only publications as we have done for years now?

Comments like this aren't helpful. We are not "pretending" anything. It is a UK magazine which is available internationally. There is really no harm in having it listed as UK.


  7th Nov 2017, 10:56 PM#9  REPORT  
Lee Wrecker

If you can't dig me, you can't dig nothin'
Member since Nov 2013
2282 Points
nboldock wrote "There is really no harm in having it listed as UK." and I agree but where do we list the copies with an international barcode that is different to the UK barcode. Probably best if we had them both on the same page even if the international versions are listed as UK issues. There could be a need for having the facility to list multiple barcodes at the entry stage in cases such as this and we do do it some other cases such as this. but it would be nice to be able to do it without having to send a correction to the notes.

I'm fully aware Mojo and Uncut are UK magazines however they have not taken a consistent global approach to production and distribution and both magazines have at various times been published globally with the same barcode as the UK issue. This however is not always the case and both have both magazines sometimes have two distinctly different copies produced one for the UK and one for the rest of the world that have different barcodes and sometimes different covers.

I had a few of these lying around that I entered before they went to the tip but my problems arose when the data (barcodes) on the 45Worlds entry didn't match my edition of the magazines. It's not of much consequence really in the scheme of things but it is a real problem in terms of the fact that the data doesn't match in a lot of cases. All I know is that there are inconsistencies here on the publishing side of things.

Apologies for appearing to be being not "helpful". That has never been my intention but these are genuine problems I have come up against when listing these magazines.

Edited by Lee Wrecker on 7th Nov 2017, 11:02 PM

  9th Nov 2017, 7:07 AM#10  REPORT  
The_Vinyl_Junkie SUBS

My body is on the diminishing streak.
Member since Dec 2011
8045 Points
Moderator
The original magazine publication(s) only have a single barcode printed.

In Australia the retailer(s) often print a second barcode for the magazine(s) which is used for the return date of the item since all magazines are on a sale or return basis.
For imported magazines that come from the UK and USA once again the retailer prints his own barcode for the Australian dollar price.

Hence in Australia we can have two different barcodes on a single item. Keep in mind that the method each retailer uses varies from one to the next.


  9th Nov 2017, 7:38 AM#11  REPORT  
nboldock

Lend me ten pounds and I'll buy you a drink.
Member since Feb 2012
7132 Points
Moderator
Lee Wrecker wrote:
nboldock wrote "There is really no harm in having it listed as UK." and I agree but where do we list the copies with an international barcode that is different to the UK barcode. Probably best if we had them both on the same page even if the international versions are listed as UK issues. There could be a need for having the facility to list multiple barcodes at the entry stage in cases such as this and we do do it some other cases such as this. but it would be nice to be able to do it without having to send a correction to the notes.

I'm fully aware Mojo and Uncut are UK magazines however they have not taken a consistent global approach to production and distribution and both magazines have at various times been published globally with the same barcode as the UK issue. This however is not always the case and both have both magazines sometimes have two distinctly different copies produced one for the UK and one for the rest of the world that have different barcodes and sometimes different covers.

I had a few of these lying around that I entered before they went to the tip but my problems arose when the data (barcodes) on the 45Worlds entry didn't match my edition of the magazines. It's not of much consequence really in the scheme of things but it is a real problem in terms of the fact that the data doesn't match in a lot of cases. All I know is that there are inconsistencies here on the publishing side of things.

Apologies for appearing to be being not "helpful". That has never been my intention but these are genuine problems I have come up against when listing these magazines.

No apology needed. Some good points here - I wonder if an alternative barcode field would be useful for magazines perhaps.


  9th Nov 2017, 7:56 PM#12  REPORT  
Lee Wrecker

If you can't dig me, you can't dig nothin'
Member since Nov 2013
2282 Points
The_Vinyl_Junkie, I'm fully aware of local barcodes being added to magazines here but that was not what I was really getting at. It is more this situation I was trying to to describe where the publisher manufactures two versions of the same issue that have two different barcodes one for the UK and one for the rest of the world. See link for clarification and see this link for an example of Uncut following the same practice.


Edited by Lee Wrecker on 9th Nov 2017, 8:50 PM

  10th Nov 2017, 5:55 AM#13  REPORT  
The_Vinyl_Junkie SUBS

My body is on the diminishing streak.
Member since Dec 2011
8045 Points
Moderator
Lee Wrecker wrote:
The_Vinyl_Junkie, I'm fully aware of local barcodes being added to magazines here but that was not what I was really getting at. It is more this situation I was trying to to describe where the publisher manufactures two versions of the same issue that have two different barcodes one for the UK and one for the rest of the world. See link for clarification and see this link for an example of Uncut following the same practice.

I can see where you are coming from now Lee.

Just quickly, the UK issues with the barcode starting "977' means "Serial Publication" and is ISSN (International Standard Serial Number) compatible.

The issues starting within the range "060" to "099" are USA / Canada and are UPC-A compatible. (UPC = Universal Product Code).

A copy of Mojo I purchased has the "977" and would have come through Gordon And Gotch in Perth. It is highly possible that both printings are available to the retailers from the wholesaler(s) within their area.

By the way I only purchased mine for the CD.


  13th Nov 2017, 5:53 PM#14  REPORT  
Whyperion SUBS

Too Many Records , Too Little Time
Member since Jan 2013
306 Points
thanks,

does similar apply to books as trying to get Amazon to de-duplicate UPCs and UK Barcodes is taking me hell


  3rd Jan 2019, 6:27 PM#15  REPORT  
rustieneil SUBS

Member since Feb 2012
12628 Points
rustieneil wrote:
Orbiting Cat wrote:
Pridesale wrote:
Appears 1 Digit too short on displaying
eg TV Choice (England)[2015] 9 772044 733022 09

The 022 indicates 2015 year, 09 9th Week
It was 015 for 2014 and I cannot read the older ones for now!

Thanks for raising this. It seems that magazines sometimes have an extra 2 digits representing the issue number. I've extended the magazine barcode to support up to 15 digits now.

The barcode field appears to only be displaying 13 digits again. I've just added the latest issue (289) of "Mojo" and am pretty sure I entered the extra 2 digits. To check I found another recent entry (Mojo 286) where I hadn't previously entered the barcode, definitely added all 15 digits, but only 13 appearing.

Can't remember if this got fixed last time around but the barcode field is definitely only displaying 13 digits again.


  4th Jan 2019, 5:42 PM#16  REPORT  
Orbiting Cat

Member since Jan 2008
1167 Points
Administrator
rustieneil wrote:
Can't remember if this got fixed last time around but the barcode field is definitely only displaying 13 digits again.

15 digit barcodes working again on Magazines. The excess digits got trimmed during a database conversion. I'm going to try and recover the trimmed barcodes from a backup.


Add Reply

45cat Forums  :  45worlds Forums  : 


45worlds website ©2024  :  Homepage  :  Search  :  Sitemap  :  Help Page  :  Privacy  :  Terms  :  Contact  :  Share This Page  :  Like us on Facebook
Vinyl Albums  :  Live Music  :  78 RPM  :  CD Albums  :  CD Singles  :  12" Singles  :  7" Singles  :  Tape Media  :  Classical Music  :  Music Memorabilia  :  Cinema  :  TV Series  :  DVD & Blu-ray  :  Magazines  :  Books  :  Video Games  :  Create Your Own World
Latest  »  Items  :  Comments  :  Price Guide  :  Reviews  :  Ratings  :  Images  :  Lists  :  Videos  :  Tags  :  Collected  :  Wanted  :  Top 50  :  Random
45worlds for music, movies, books etc  :  45cat for 7" singles  :  45spaces for hundreds more worlds