Export Requirements

Export Format

All data export is provided in .csv format files.
Separator — ; (semicolon)
File encoding — UTF-8 without BOM

Important

• The separator symbol (;) must not be present in the data to avoid incorrect loading.
• Mandatory fields are marked with an asterisk (*).
• Other fields are optional but recommended to be filled if data is available.

---

Clients

The user export must contain the following fields:

1. Card number
2. Card type (master, student, cumulative)
3. Phone*
4. Email
5. First name
6. Last name
7. Middle name
8. Identifier of the store where the client was registered
   (must match the identifier from the store export)
9. Card / customer registration date
10. Current card discount size

---

Stores

Before loading purchases, stores must be created.
If purchases from closed stores are to be loaded, such stores must also be present in the export.

The store export must contain the following fields:

1. Unique store identifier*
2. Store name*
3. Unit / city
4. Store address
5. Status "closed / open"

---

Purchases

To load purchases, it is necessary to form a line-by-line order export, where each line corresponds to one order position.

In the export, the following fields must be specified:

1. Unique order / receipt number*
2. Store identifier (must match the identifier from the store export)*
3. Card number or customer phone (must match data from the client export)*
4. Product barcode (code)*
5. Product quantity (cannot be less than 1)*
6. Price (product of quantity and price per unit, cannot be less than 0)*
7. Product discount (product of quantity and discount per unit, discount amount cannot exceed the price)*
8. Sale date (strictly in YYYY-MM-DD HH:MM:SS format)*

Purchase export example

Important

• Empty values are allowed only in the "Card number" or "Phone" fields.
  In this case, a purchase will be created without binding to a specific client.
• Data must be sorted by sale date and order number in ascending order.