Import large batches of serial keys into your store at once using a CSV or TXT file. Bulk import is a premium feature of WC Serial Numbers and supports two file formats, depending on the level of control you need over each key entry.
Where to Find This Setting
- Go to Serial Numbers → Tools → Import from your WordPress admin menu.
- Choose your preferred file format and follow the steps below.
CSV Import
CSV is the recommended format for bulk imports as it supports the widest range of fields, giving you full control over each key entry. Download the sample CSV file to see how your file should be formatted before uploading.
Bulk imports process the first 1,000 serial keys from the uploaded CSV file.
Steps to Import Keys via CSV
- Download the sample CSV file and open it in any application that supports CSV editing.
- Fill in the respective fields with your key data. Refer to the Supported Fields table below for details on each field.
- Make sure you are using the correct
product_idfrom your WooCommerce store. An incorrect Product ID will result in keys being assigned to the wrong product or failing to import. - Avoid using duplicate serial keys unless intended. If you need to allow duplicate keys, enable the setting first by following the Allow Duplicate Keys guide.
- Save the file and upload it to complete the import.
Supported Fields
| Field | Description | Required | Default |
|---|---|---|---|
serial_key | The serial key value | Yes | — |
product_id | ID of the product the serial key is assigned to | Yes | — |
activation_limit | Number of allowed activations | Optional | 1 |
order_id | Assigns the serial key to a specific order | Optional | null |
status | Status of the serial key | Optional | available |
validity | Number of days the key remains valid from the date of purchase | Optional | 0 |
order_date | Date of the order | Optional | null |
TXT Import
TXT format is ideal for quick bulk uploads. The file contains only the serial keys, and all other settings, such as product, status, activation limit, and validity, are configured during the upload process.
Steps to Import Keys via TXT
- Download the sample TXT file and open it in any text editor.
- Add your serial keys to the file, one key per line.
- Avoid using duplicate serial keys unless intended. If you need to allow duplicate keys, enable the setting first by following the Allow Duplicate Serial Keys guide.
- Save the file.
Configure the following options before importing:
- Product: Select the target product from the dropdown.
- Status: Set the key status.
- Activation Limit: Define the number of allowed activations.
- Validity: Set the expiry period for the keys.
Once configured, upload the updated txt file and click Import to complete the upload. All keys in the file will be imported with the settings you defined above.