Hikaserial Importer is allowing duplicate serials

-- HikaShop version -- : 2.6.0
-- HikaSerial version -- : 1.10.0
-- Joomla version -- : 3.4.5

Hikashop importer allows duplicate serial numbers. When I import a set of serial numbers into a pack in hikaserial it allows me to import the same set of serial numbers 2 times causing duplicate serial numbers. This cannot happen for the company we are doing this for because they will have different people importing the csv and we cannot rely on them to know if they have already uploaded the csv already.

For example with the set of data below. If I import this csv in 2 times then the hikaserial importer imports the serial data twice and then we have duplicate serial numbers. I do realize I can use the serial_id column, but that is not a viable option for the company we are doing this for. It is for a very large company and the upload has to be full proof . I need the hikashop importer to check the serial_data column when the csv is uploaded and if it sees that the serial already exists in the serial_data column that it will not import that line in, in the csv or allow that duplicate serial number to be imported.?

How would I go about getting this to work? I do not think the importer currently has an option for this. However, this particular company pays for each serial number they use and each serial is attached to a specific dollar amount so there absolutely cannot be duplicate serial numbers. If duplicate serials accidentally happened they would be overselling their serials and then when a customer would come in their gift certificate would not work which would be very bad.

I cannot be the only one that needs this, I cannot see how any company would want duplicate serial numbers allowed in the database. What I would see making the most sense is having an option in the back end of the hikaserial import that says "do not allow duplicate serials when importing" or something like that, that would allow for this functionality.

This is a pretty urgent thing any help would be greatly appreciated.

Hi,

That's right, there is currently no check made during the import in order to avoid the serial duplication.
But that is something which can be added.
With a little modification of the structure, the import could check the "serial data" before the insertion (only when there is no "serial_id") and exclude the serial which already exist in the database.

Regards,

Hi,

After a deeper analyze ; HikaSerial could have such kind of option to avoid serial duplication during import.
It can't be the default value because having identical serials is authorized and can be useful for some specific cases.
Now ; that's also right that some case need checks to avoid duplication.

But ; in order to know more about the specifications ; When it checks if the serial already exists, does HikaSerial have to check only in the same pack or in all packs ?
You import sample only concern one single pack but it could also list other packs.
Depending if your using several packs or not, if the duplication can be authorized or not.. The algorithm will change a lot !

Regards,

Thank you for the reply. It would need to check in all packs not just the same pack it is under.

I would think that would be the case though with anyone using serial numbers. The pack should be irrelevant because you only want someone using a serial number 1 time regardless of the pack it is under.

I would think it would just need to check the serial_data column and look to see if the serial already exists and if it does not import it into any pack but maybe it is more complicated than that?

Hi,

See: www.hikashop.com/support/documentation/1...erial-changelog.html

Regards,

Thank you so much works perfectly! You all have amazing support I always recommend this shopping cart and your products to everyone!

Thanks !

With the issue reported on another thread ; I was working on a new release.
So it was a good opportunity to include directly that feature into HikaSerial than just giving you the files to modify.
www.hikashop.com/forum/16-serial-bug-rep...-problem.html#223094

After that, I'm really fan of recommandation by word of mouth but HikaSerial is also listed on the Joomla extension directory and, for a partially unknown reason, just have 2 reviews.

Regards,

Hi! I need exactly the contrary, I need some duplicated serials. After the update, I can't import duplicated serials even though the button "Check duplicate serials" is set to NO. It says "DUPLICATE_SERIAL_IN_CONTENT".

Let's say that there is 3 unique serials and 3 duplicated.

So HikaSerial imports the 3 unique serials and 1 from the duplicated ones. I have to import manually every duplicated serial.

Help Please!

There may be some sort of bug with the update and I am not sure about if the button is broke, but from what I understand if you assign a serial_id along with serial_data I am pretty sure that will allow you to do what you are trying to do. Each serial_data has its own serial_id assigned with it just like each joomla article has its own article id associated with each article. So, if you have a 3 duplicated serials but you assign 3 different serial_id's to each it should allow for this if you are doing a csv import and have the button turned to no.

Hi,

The serial import default behavior hasn't changed.
By default the setting "check duplicate serials" is "no" ; to continue to not check the serial duplication.

If you ask HikaSerial to check for duplicates, it will do so ; except if you specify the "serial_id" because it means that you are updating serials (and you know exactly what you do).

Regards,

I'm sorry for insisting, but I have more than a year working importing serials with hikaserials and never before got the DUPLICATE_SERIAL_IN_CONTENT error even though having duplicated serials in the list. All this is happening after the last update.

I tried what you said, to add ,serial_id in the top and to assing a number to each of the serials in order not to have conflicts. It didn't work. The "Check duplicate serials" button is set to NO and still receiving a DUPLICATE_SERIAL_IN_CONTENT error for each repeated serial.

All this is delaying my work

Hi,

Okay.
In the file "administrator/components/com_hikaserial/helpers/import.php" you will find the block You can replace it with to avoid the internal check in the imported content.
I'll also update the HikaSerial package.

Regards,

I did it. I don't get the error. But I'm trying to import 10 duplicated serials and Hikaserial imports only 1. What to do?

Hi,

Ah yes, there is still the merge on the serial data.
You need to replace By which is just below the previous modification.
I'll arrange a little bit more the code, process some tests and I'll update the HikaSerial package. But that patch would fix your issue.

Regards,

Jerome, now it works as it used to. Thank you very much