Print this pagePrint this page

How to import predefined serial numbers in database


Here is an example of a SQL query that you can run via admin section (Tools > DB Management >Run SQL Query):

INSERT INTO va_items_serials (item_id, serial_number) VALUES (1, 'Serial #1'), (1, 'Serial #2'), (1, 'Serial #3');

In this example three serial numbers will be added to product with ID 1.