Invalid barcode
Good afternoon, there are more than 2k products, but a little more than 1000 products contain an incorrect barcode (instead of 13, 11 characters) how to automatically generate new barcodes on these products
Original question is available on version: ru
Answers:
Good day. In the box, there is no way to generate a barcode for already created products, only when creating a new product, the system can generate a barcode according to a specific prefix ( http://i.imgur.com/HKXsWzf.png )
You need to generate a third-party service.
But I once found such a file https://drive.google.com/file/d/1CSPy6u1v0XWYoc0Sd9s3pHcPu4DkIM9s/view?usp=shari... and used it successfully. The Excel file has a macro that can generate any number of barcodes with the given parameters.
We can export goods from the box, filter out only the necessary goods with the wrong barcode in the file, count their number, generate the required number of codes in the specified file using the link, put barcodes on the goods in the export file, then this file back to import into boxing.
You need to generate a third-party service.
But I once found such a file https://drive.google.com/file/d/1CSPy6u1v0XWYoc0Sd9s3pHcPu4DkIM9s/view?usp=shari... and used it successfully. The Excel file has a macro that can generate any number of barcodes with the given parameters.
We can export goods from the box, filter out only the necessary goods with the wrong barcode in the file, count their number, generate the required number of codes in the specified file using the link, put barcodes on the goods in the export file, then this file back to import into boxing.
30.09.2020, 14:43
Original comment available on version: ru
We can export goods from the box, filter out only the necessary goods with the wrong barcode in the file, count their number, generate the required number of codes in the specified file using the link, put barcodes on the goods in the export file, then this file back to import into boxing.
Will there be duplicate products?
30.09.2020, 14:47
Original comment available on version: ru
so that there are no duplicates, you need to correctly export and import the file.
To do this, export only the product ID, name (for clarity) and the barcode itself to a file.
Replace the barcodes for products in the file and re-import the file, but it is important to specify both the product ID and the barcode for the import columns. The system will find this product in the system by the product ID (because it has priority over the barcode) and rewrite the barcode for it.
Yes, the system may already have a product with the same barcode that will generate the file, so before importing, check the box http://i.imgur.com/y3PQiYe.png
Based on the results of the import, you will receive a letter that will indicate that they say so and so, 1000 out of 1000 have been updated, or there 900 out of 1000, then you need to look in the same letter (csv-file attached to the letter) for which products the update did not pass - these will be the very goods that already have such a barcode.
To do this, export only the product ID, name (for clarity) and the barcode itself to a file.
Replace the barcodes for products in the file and re-import the file, but it is important to specify both the product ID and the barcode for the import columns. The system will find this product in the system by the product ID (because it has priority over the barcode) and rewrite the barcode for it.
Yes, the system may already have a product with the same barcode that will generate the file, so before importing, check the box http://i.imgur.com/y3PQiYe.png
Based on the results of the import, you will receive a letter that will indicate that they say so and so, 1000 out of 1000 have been updated, or there 900 out of 1000, then you need to look in the same letter (csv-file attached to the letter) for which products the update did not pass - these will be the very goods that already have such a barcode.
30.09.2020, 14:55
Original comment available on version: ru
Poliit Max Ruslanovich wrote:
Thanks, all worked well
I was glad to help)) Mark the execution pzhl.
01.10.2020, 11:59
Original comment available on version: ru
Shcherbatykh Ivan Alexandrovich Employee wrote:
Polyit Max Ruslanovich wrote: Thank you, everything turned out I was glad to help)) Please mark the execution.
Tell me how exactly?
08.10.2020, 09:38
Original comment available on version: ru
Poliit Max Ruslanovich
Client wrote:
Shcherbatykh Ivan Alexandrovich Employee wrote: Poliit Max Ruslanovich wrote: Thank you, everything turned out I was glad to help)) Please mark the execution. Tell me how exactly?
You need to mark one of my answers as completed - there is a checkmark next to each answer. You can choose any of my answers, well, or the most detailed one.
08.10.2020, 10:00
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
