Import stores from a CSV file

Use this page to add new stores, or update existing ones, from one CSV file instead of one form at a time. Only admin users who can edit stores see Import.

​

Prepare the file

Save your stores as a CSV file with one row for each store and the column names below, in the first row. Stores that are new to Lobyco and stores you want to change go in the same file. A day you leave empty gets no opening hours. If the store already has opening hours for that day, the import removes them. When you next edit that store, the form marks the empty day with Please, fill out the field, and Save stays greyed out until you fill in its hours or switch on Store is closed all day. The import can’t create chains. Create a chain first, on the Chains tab of the Stores screen. See Manage stores and chains.

​

Date-specific opening hours

Opening hours for single dates, such as a public holiday, go in a separate file. Each row is one date for one store. To close the store all day, write the same time in both columns, such as 00:00:00 and 00:00:00. To keep it open all day, write 00:00:00 and 23:59:59. A store can have one entry for each date, so each store and date can appear only once in the file. A row replaces the store’s existing entry for that date. The store’s other dates stay as they are.

​

Open the import screen

1. Open Store configuration → Stores.
2. On the Stores tab, select Import.

You see the Import Log, a list of every file imported so far. Each row shows the File name, Date, File type, Status and who imported it, with a View link at the end. Use the filters above the list to find a file, and Refresh to reload it. The Import Log for stores

​

Import the file

1. Select Import new info. The Import new info dialog opens.
2. Under Select which data to import, choose Stores. To import a file of date-specific opening hours, choose Date specific opening hours instead.
3. Under Select file format, leave CSV selected. JSONL is the other choice.
4. Under Add file, drop your file on the area, or select select file and pick it.
5. Select Import file.

Once you’ve chosen the data, See expected columns in file appears under Add file. Open it to see every column the portal expects for that data. The columns marked with * are required. Import file stays disabled until you have chosen the data, the format and a file. If you select Cancel after filling in the dialog, the portal asks “Leave without importing new file?”. Choose Stay to go back, or Leave to close the dialog. The dialog says that rows with new IDs are added, and rows with existing IDs replace the existing rows with those IDs. The Import new info dialog, with Stores chosen

​

Check the result

Your file appears at the top of the Import Log. Select Refresh if it isn’t there yet. Look at its Status:

• Successful, with numbers in brackets such as (10/10), means every row went in. The numbers are the rows imported out of the rows in the file.
• Verification needed, with numbers such as (1/2), means some rows didn’t go in. In this example, one row of two was imported.

Rows that pass are imported even when other rows in the same file fail. Select View on a row to open its File details: what was imported, the file, and when the import started and ended. For a file with failed rows, it also lists Errors, one for each failed row, with the reason, such as “The Name field is required.” The number in square brackets counts rows from 0, so [1] is the second store in your file. File details says “The file was not imported” whenever any row failed, even though the rows that passed did go in. Fix the failed rows and import the file again. The stores that already went in are replaced with the same values, so importing them twice does no harm. To see a store itself, go back to the Stores tab and search for its ID. See Manage stores and chains.

​

Troubleshooting

​

Related

• Manage stores and chains covers finding, creating, editing and exporting stores, and looking after chains.