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.
- 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.
- Go to Settings > Initial Setup and click Download Template for Products.
- Fill in one row per SKU, keeping the header row. Save the file as .xlsx, with 2000 rows or fewer.
- Click Upload XLS, or go to Products > Products, click Import, then click Pick XLS File and choose your file.
- Check the valid and error rows, click Import, and read the created, updated and skipped counts. Fix the skipped rows.
- 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.
Reyuko