How to Import External serial numbers from the back office?

How to Import External serial numbers from the back office?


Notes
A Serial numbers are unique identifiers assigned to individual items or products. They are essential for tracking, managing, and distinguishing products within batches or inventories. In Dyrect, importing external serial numbers enables seamless integration of your existing data into the system, ensuring data accuracy and preventing duplication.

Important Guidelines

Please read these requirements carefully before importing to avoid errors:

Batch ID Requirements

  • Batch IDs must be unique for different SKU IDs
  • Each batch requires a distinct Batch ID
  • No two batches can share the same ID

Serial Number Requirements

  • Serial numbers must be unique across all batches and SKU IDs
  • No duplicate serial numbers are permitted in the system
  • Each product must have its own distinct serial number

Character Restrictions

  • Do not use special characters in Batch IDs, SKU IDs, or Brand IDs
  • Stick to alphanumeric characters only
  • Avoid symbols such as: @, #, $, %, &, *, etc.

Prerequisites

Before you begin, ensure you have:

  • Access to the Dyrect back office
  • An Excel file ready with your serial number data (or use the provided template)
  • Verified that all serial numbers are unique

Step-by-Step Import Process

Step 1: Navigate to Create Batch

  1. Log into your Dyrect back office
  2. Go to Serialization> Batches
  3. Click the "Create Batch" button in the top right corner

Step 2: Download the Excel Template

  1. A new page will open after clicking "Create Batch"
  2. Click "Download" to get the Excel template file
  3. Click "Next" to proceed

The template includes the following columns for your data entry.

The Excel template contains the following columns:

  • Batch ID - Unique identifier for the batch
  • SKU ID - Stock Keeping Unit identifier for the product
  • Serial Number - Unique identifier for each individual item
  • Brand ID - Brand name associated with the product

Step 3: Fill in the Excel Template

  1. Open the downloaded Excel template
  2. Enter all required details.
  3. Important: Ensure every serial number is unique across your entire inventory

Step 4: Upload Your Completed File

  1. Click "Upload" and select your filled Excel file
  2. Click "Next" to proceed to the review screen



Step 5: Review and Import

  1. A new page will display all the details you've entered
  2. Carefully review the information for accuracy
  3. Click "Import"
  4. Confirm by selecting "Yes, Import"

Step 6: Verify Import

Once the import is complete, you can view all imported serial numbers on the batch page. The system will confirm successful import.



FAQ

1. Can I use the same Batch ID for two different products?

No. Each Batch ID must be unique. You cannot assign the same Batch ID to different SKU IDs or products.

2. What happens if my Excel file contains duplicate serial numbers?

The system will reject the import and show an error. All serial numbers must be globally unique across all batches.

3. Can I include special characters in Batch ID or SKU ID?

No. Dyrect does not allow special characters such as @, #, $, %, &, *.
Only letters and numbers are permitted.

4. How many serial numbers can I import at once?

You can import as many serial numbers as needed in one file, as long as the file follows the required format and contains no duplicates.

5. What file format should I upload?

You must upload the file in Excel (.xlsx or .xls) format using the template provided by Dyrect.

6. Why is the system not accepting my file?

Common reasons include:

  • Duplicate serial numbers

  • Missing mandatory fields

  • Special characters in Batch ID or SKU ID

  • Wrong file structure (template not followed)

  • Incorrect column headers

7. Can I edit or delete serial numbers after import?

Editing is restricted for security and tracking purposes.
You may need to reassign or contact the Dyrect support team depending on your permissions.

8. Do I need to create the batch before importing?

No. The system creates the batch during the import process through the Excel file.

9. What should I do if I uploaded the wrong file?

If the import is already completed, contact your administrator or Dyrect support. If you are still on the review screen, simply cancel and re-upload the correct file.

10. Will the system notify me after a successful import?

Yes. A confirmation message will appear, and the imported serial numbers will be visible on the batch page.

    Need Assistance?

    If you require Dyrect to assist you with an integration, you can do so by following these steps:

    1. Create a support ticket by submitting a form here or email us at support@dyrect.co
      1. A support will reach out to you to request access to your Shopify store.


      Schedule a Personalize Demo

      Book your 30 minutes Personalised Demo with our Onboarding and Solutions Expert

        • Related Articles

        • How to Download Codes in Excel?

          In this guide, we will walk you through the process of downloading codes in Excel format from the Dyrect client portal. This process will allow you to efficiently manage and analyze your data for better tracking and reporting. Step-by-Step Guide to ...

        • How to generate Serialized Codes?

          In Dyrect, serialized codes are unique identifiers such as numbers or QR codes assigned to each product. These codes enable tracking and managing product details. Customers can scan QR codes to verify product authenticity, earn loyalty points, and ...

        • How to Reassign Serialized Codes to another Batch?

          Tags are QR codes that allow users to verify product authenticity, earn loyalty points, and activate product warranties. Once scanned, the product is registered under the customer's name. Reassigning tags to a different batch ensures proper ...

        • How to Track History of Codes?

          Tracking tag history in Dyrect allows you to monitor the activity and status of each tag, providing valuable insights into product authentication, warranty activation, and customer interactions. By following a few easy steps, you can view detailed ...

        • Printing Guide

          1. Overview This document outlines the complete process of creating, downloading, and printing QR codes using the Dyrect Portal. It also highlights recommended best practices to ensure QR codes are durable, scannable, and suitable for long-term use ...