Import from a file
Upload a spreadsheet, PDF or Word document and let Loger find the products, variants and prices inside it.
On this page
Choose Import from file when your supplier sent a price list or catalog as a document. It is the most common way to import.
#What you can upload
- Spreadsheets:
.csv,.tsv,.txt,.xlsxand.xls. - Documents:
.pdf,.docand.docx. - One file at a time, up to 20 MB. PDFs can be up to 50 MB.
#Upload and import
Open Import from file
On the New import page, choose Get started on the Import from file card. The page is called Upload supplier files.
Drop your file
Drag the file into Drop your file, or click to choose it.
Pick a sheet, if asked
An Excel workbook with several tabs shows Multiple sheets in this workbook. Choose the one with your products under Sheet to import, then Continue with this sheet.
Check the columns, if asked
If Loger is not confident it matched your columns, the Review columns window opens. See below.
Confirm pricing and review
Loger builds the products and takes you to pricing and review.
#How Loger reads your columns
Column names are matched without regard to capital letters, and many common alternatives and languages are recognised: Spanish, French, German, Italian, Portuguese, Dutch, Chinese, Japanese, Korean, Polish and more. Blank rows or a letterhead above the real header row are skipped.
| Loger field | Headers it recognises (examples) |
|---|---|
| Title | title, product name, name, item name, product, item |
| SKU | sku, item number, item code, product code, part number, model, article number |
| Barcode | barcode, upc, ean, gtin, isbn |
| Vendor | vendor, brand, supplier, manufacturer |
| Price | price, retail price, selling price, sale price, web price, msrp, rrp |
| Compare-at price | compare at price, original price, was price, list price, srp |
| Cost | cost, unit cost, wholesale price, trade price, dealer price, purchase price, cogs |
| Inventory | inventory, stock, quantity, qty, available, on hand |
| Description | description, product description, body html, short description |
| Images | images, image url, image src, photo, picture, image1, image2 |
#Variants
Loger understands the common ways suppliers write variants:
- One row per variant, with the same title repeated for each size or colour.
- Columns such as Size, Color or Material, with one row per variant.
- Packed values in one cell, such as
Color: Blue, Black, White. - Option name and value pairs, such as Option1 Name and Option1 Value.
#Review columns
The Review columns window opens by itself when Loger is unsure: no title column was found, there is neither a price nor a SKU, or a product name was only identifiable from the values in a column. It also opens if you have turned on Always review supplier columns in Settings.
For each column in your file, choose what it is: Title, SKU, Barcode, Vendor, Description, Price, Compare-at price, Cost, Inventory, Tags, Images or a variant field. You can also:
- Set a Default vendor when missing, used for rows with no vendor.
- Send leftover columns to Store metafields so the data is not lost.
- Choose Apply mapping to continue, or Cancel to go back.
Loger remembers a mapping you apply. Next time you upload a file with the same headers, a toast reading Applied saved mapping confirms it was reused. Saved mappings can be edited, copied or deleted under Import mapping in Settings.
If some columns are left over that do not map to anything, a Please review column matching prompt can ask whether to Use a different file, Continue anyway or Review column matching. Turn this on or off with Ask when leftover columns cannot be matched in Settings.
#PDFs and Word files
Loger reads tables and lists out of PDFs and Word documents. Large or complicated PDFs are read page by page. Pictures inside a PDF are skipped, so add product photos separately (see below) if you need them.
#Add product images
Above the drop zone, under Supplement with product images (optional), choose Add image files or Add image folder. Do this before you drop your file, because the import starts as soon as the file is in. Loger matches pictures to products by SKU, file name, folder name or an image column in your spreadsheet, and flags any it could only match by a similar name so you can check them in review.
#When columns cannot be mapped
If the file is too irregular for column matching, Loger offers Let Loger reconstruct this for you. Choose Reconstruct with AI and it reads the file as a human would, then builds the products. You still review everything before publishing.