Import Database Updates

Table References

Character set is utf8mb4 COLLATE utf8mb4_0900_ai_ci unless otherwise noted.

All dates must be in Y/M/D format.

All text must be MySQL encoded. Single quote text qualifier.

CSV delimiter is the | pipe character. See sample CSV file here.

is_preorder bit(1) NOT NULL DEFAULT b'0'
order_number varchar(10) NOT NULL DEFAULT '' DO NOT CHANGE THIS COLUMN!!
Existing records are matched by this field. If changed, a new order will be created without additional assets such as images and design files linked.