Module 02 · Catalog, Price Levels and Customers

Bulk Import of Items and Customers

Import a customer list from Excel into Reyuko: the .xlsx file, Code matching that updates or creates records, and the fields you enter by hand afterwards.

5 min readLesson 3 of 10 in this moduleUpdated 2026-10-24

Reyuko can import products, contacts, opening stock and sales or purchase documents from Excel files. The import is narrower than the forms, so this lesson shows what comes across and what you must enter by hand.

Key takeaways

  • Reyuko imports only .xlsx files, with at most 2000 rows per file. Split larger lists into several files.
  • Products are matched by SKU and contacts by Code. A match updates the record. No match creates one.
  • Conversions, quantity tiers, discounts and stock do not come with the product import.
  • Opening stock is a separate file, with SKU, Qty and Unit Cost, and it joins the Opening Balances draft.
  • Units are written as typed. Reyuko does not check them against your unit list in this import.

Where the import lives

Download Template and Upload XLS are on Settings > Initial Setup, one pair per step. The Import button on the command bar of the Products page opens an Import Products dialog instead: click Pick XLS File, review the valid and error rows, then click Import. Import buttons also appear on the detail panel of a Customer, Vendor or Employee, and on Sales Invoice.

Download the template first, and do not rename or reorder its headers.

Products

Each row needs a SKU, a Name, a Type (1 to 12) and a Unit. Optional columns include Category, prices, Tax (Y or N), Min Stock and Active (Y or N).

  • Category is matched to an existing category name. If no name matches, the field is left blank on a new product; an existing product keeps its current category. The import does not create categories, so create them first.
  • Unit is written exactly as typed, for example "pcs" or "ctn". It is not checked against Measurement Units in this import. A typo creates a unit code that does not match your master list.
  • Group is not used when the import is applied.

Not imported: conversions, quantity tiers, product discounts and stock. Add those on each product, as covered in Carton, Inner Pack and Piece: Different Units.

Illustration: Harbor Wholesale is a fictional business; numbers are examples. Harbor has 4,500 SKUs. It splits the list into three files of 2,000, 2,000 and 500 rows. Each file must have its own header row.

Customers and suppliers

Contacts need a Name and a Type (customer, vendor or employee). Optional columns include Code, phone, email, address, Group and Classification Discount (0 to 100).

  • Code is matched without regard to capitals. Leave it blank and Reyuko assigns one.
  • Group feeds the Customer Group.
  • Classification Discount is the L3 discount for that customer, which applies on every sale.

Not imported: credit limit, contact persons, classification name, bank details, notes and payment terms. Set those on each contact after the import, as covered in Contact Persons.

Opening stock

Opening stock is a separate file. Each row needs SKU, Qty and Unit Cost. Location and Name are optional. The rows are merged into the Opening Balances draft under Settings > Initial Setup. Review the draft before you post it. We did not verify how the Location column behaves, so check your version before you rely on it for a second warehouse.

Results and errors

Rows with errors are flagged in the dialog before you import, and they are not saved. Each import ends with a summary: created, updated and skipped. Check the skipped count first, since a skipped row was not saved.

Common mistakes
  • Splitting the file in the wrong place. The limit is 2000 rows per file. A file with 2001 rows is refused, and you must split it.
  • Missing categories. The import does not create categories. An unmatched name is left blank.
  • Assuming conversions came across. They did not. Check a sample product after each import.
  • Importing sales documents before contacts or products. Sales Invoices need the customer Code and every SKU to exist already. Purchase Bills come in as drafts.
Doing this in Reyuko
  1. Go to Settings > Initial Setup and click Download Template for Products.
  2. Fill in one row per SKU, keeping the header row. Save the file as .xlsx, with 2000 rows or fewer.
  3. Click Upload XLS, or go to Products > Products, click Import, then click Pick XLS File and choose your file.
  4. Check the valid and error rows, click Import, and read the created, updated and skipped counts. Fix the skipped rows.
  5. Open a few products and confirm the prices, Type and Unit.
Check yourself: is it a SKU match?

Your file has SKU RICE-5KG and the product already exists in Reyuko. The import updates that product and does not create a second one. A new SKU creates a new product.

Frequently asked questions

Does importing a customer list create duplicates or update existing records?

Existing records are updated when the Code matches, and a new Code creates a new customer. Contacts are matched by Code without regard to capitals, and a blank Code is assigned a new one by Reyuko, so keep the existing codes in your file for customers you already have.

What does a skipped row mean after the import?

A skipped row was not saved, so that customer or product is still missing from Reyuko. Each import ends with created, updated and skipped counts. Rows with errors are flagged before you import, so check the skipped count first and fix those rows before you import again.

What happens if a unit in my file is misspelled?

Units are written exactly as typed. The import does not check them against your Measurement Units list, so a typo creates a separate unit code that does not match your master list. Check the Unit column against Measurement Units before you upload the file.

Does the customer import keep credit limits?

No. Credit limits are not imported, and neither are contact persons, payment terms or bank details. Enter the credit limit on each customer's Contact Data tab after the import. Reyuko stores and shows the limit, but it does not block a sale that goes over it.

What happens to a category name that does not match?

The category is left blank on a new product, and an existing product keeps its current category. The import does not create categories, so create the category under Products > Categories before you import the product file. Then check a few products afterwards to confirm the category shows.

Is there a row limit for the import?

Yes. Each .xlsx file takes up to 2,000 rows, so split a longer list into several files. Only .xlsx files are accepted, so save a CSV or .xls file as .xlsx first. The limit applies to each file, not to the whole import, so three files of 2,000 rows each can be imported one after another.

Put this into practice in Reyuko

Reyuko's inventory, purchasing, sales, purchasing and reporting tools work together on one ledger, so your stock and your books always agree.

Download ReyukoSee what's included