Serial Import

This page allow you to import serials, pack or product-pack association.
You can upload a CSV file which would be process by HikaSerial or just paste some text.

Importing serial

When you import a list of serial, you can specify if you want to import all serial in a specific pack or you can import multiple serial for different packs.
In that case, you have to provide the information about the pack (serial_pack_id, pack_name, ...)

It is possible to create packs in the same time you are importing serial. Instead of using a pack_id you have to use the pack_name.
If the pack with that name already exists, it will be used. Otherwise it will be created with a default configuration.

Here the list of the authorized columns during the import :

  • serial_data - required - The serial content
  • serial_status - optional - The status of the serial, by default it will be free
  • extradata.name - optional - You can provide multiple columns for the different extra data you want to store in the serial.
  • serial_pack_id - optional - You can force a pack id for the serial.
  • serial_order_id - optional - You can already assign the serial with an existing HikaShop order.
  • serial_user_id - optional - You can already assign the serial with an HikaShop user id.
  • serial_order_product_id - optional - You can already assign the serial with an HikaShop order product
  • pack_name - optional - If you are not using serial_pack_id, you can select (or create) a pack for the serial.

Import association

You can import product-pack associations with the HikaSerial system.
The association allow you to link products with packs.

Here the list of the authorized columns during the import :

  • pack_id - If you already know the pack id, you can provide directly the value.
  • pack_name - If you are not using the pack id, you can provide the pack name.
  • pack_quantity - You can specify the number of serial that the product will give to the user.
  • product_id - If you already know the produc tid, you can provide directly the value.
  • product_code - If you are not using the product id, you can provide the product code and HikaSerial will look for the product for you.

Because the column serial_data is a mandatory field during the import, you must provide that column.
But if you are just importing product-pack association, the column serial_data can stay empty.