Verify EAN UPC and Reference Number to be unique

Verify EAN UPC and Reference Number to be unique

Avatar image
Feb 25, 2016
Radu wrote
As it happens in reality, is needed to make sure EAN, UPC and Reference Number is unique for a Article or Combination. Neither Prestashop nor PrestaShop Manager does that, so it is open to error. From experience, I found this situation, simultaneously, in a combination of a article as well as on a article without combination. And that caused a whole mess in ERP.
New
2 votes
Vote
Reply
16 Answers
Avatar image
Feb 25, 2016
Alex Pryshlivskiy agent wrote
Thanks for comment. Are you talking about work with combination of speical Addon + Store Manager ?
Amazon Integration + Store Manager
or
IceCate + Store Manager.
Avatar image
Feb 25, 2016
Radu wrote
I newer thought so specifically. If can be inside PSManager, hat would be ok. Now to deduplicate one has to export and work in excel, and than correct in PSManager and than after re-upload. It is just a suggestion of enhancement based on a real-life problem. Example: now EAN and UPC fields accept only numbers ( which is great ). If after download data from Prestashop, PSManager coud verify duplications among all EAN and UPC ( inside Articles as well as Combinations ), that would be a major time saver, one can realize only after having spend many hours with colleagues in logistics, accounting, payment to trace duplicates impact.
Avatar image
Feb 25, 2016
Alex Pryshlivskiy agent wrote
ok. it's clear.
How about this option? - to add this feature into Reports section.
For example - you'll be able to run report and check duplicated in few clicks. :-)
Avatar image
Feb 25, 2016
Radu wrote
That's a smart solution ! Very Good.
Avatar image
Feb 25, 2016
Alex Pryshlivskiy agent wrote
Do you want to be Beta tester for this Report? please let me know.
Avatar image
Feb 25, 2016
Radu wrote
So another one could be another report for Invalid EAN / UPC ( the ones with Kontrol digit not validatet by original formula ). That would close the loop for issues around EAN / UPC.
Avatar image
Feb 25, 2016
Radu wrote
yes, off course.
Avatar image
Feb 25, 2016
Radu wrote
I can supply the formulas, also if ok with you
Avatar image
Feb 25, 2016
Alex Pryshlivskiy agent wrote
I'll create for this. :-) thanks for you time. Formulas will be fine. ;-)
Avatar image
Feb 26, 2016
Radu wrote
Sergy,

EAN and UPC organizations have been merged into GS1, now all these codes are named GTIN. GTIN8, GTIN12, GTIN13, GTIN14.

Because PrestaShop has 2 fields, I suggest to remain with the 2 validations.
Formula is the same, in the attached spreadsheet.

I would also extend filed name from EAN13 to EAN 8,13,14 and from UPC to UPC 8,12

For PSManager fields, I attached some recommendations, in the picture. Help wording as well as field customization for when inputting manual the digits not when importing from PS.

Let me know if I can help further.

Cheers,

Avatar image
Feb 26, 2016
Radu wrote
I have not seen the picture and table as attachment, so I reload
Avatar image
Feb 26, 2016
Radu wrote
and table
Avatar image
Feb 26, 2016
Alex Pryshlivskiy agent wrote
Thanks for table.
but as an quick decision for us to create Special report to find duplicate values of EAN \ UPC for Products.
According to validation of EAN and UPC - we've found some issues for it - I've created task for it.
Thanks again! :-)
Right now we don't allow more 13 symbols except of number - see screenshot.
Avatar image
Feb 26, 2016
Radu wrote
great. just not to forget, must be cross verified EAN / UPC from articles and also from combinations, as some EAN / UPC could have started as a individual articole and with extension of brand, could have been re-listed as Combination.

EAN & UPC max numers are already implemented, Congratulations. was my fault not to notice.

cheers,
Avatar image
Feb 26, 2016
Alex Pryshlivskiy agent wrote
Thanks for update.. ! :-)
Mar 02, 2016
System wrote
Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team