Skip to the page content

Questions about importing and moving data

Answers about importing products, customers and suppliers from Excel, failed rows, exporting to Excel, and moving from Doctor Accounting or another program.

On this page

How do I add hundreds of products from Excel?

Open Master Data → Products, press Import Products, download the Excel example, fill in one row per product without changing its column headings, then upload it and press Import. The import runs in the background and its result is announced in the bell. See Importing and exporting products with Excel.

What data can be imported from Excel?

Products, customers, suppliers, special prices, services, and opening stock, receivables and payables. Each import button is on its own data page, and only shows for users who may import that data. See Data that can be imported.

How many rows can I import at once?

One file may hold up to 5.000 rows. More data is split into several files. See Import steps.

How do I update the prices of many products through an import?

Import a product file with the same code: that row updates its product. A row without a code updates the product with the same name, and empty cells leave its contents as they are. Staff who only hold certain branches cannot change selling prices through an import. See Updating existing products.

Some rows failed to import. What now?

Wrong rows are skipped and reported one by one with their reason, while the other rows still come in. Open Settings → Import History, press Download failed rows, fix them in Excel, then import again. See Seeing the import history.

Does a product import fill in the stock?

No. A product import does not fill in stock. The quantity already in the shop is recorded as opening stock in Settings → Opening Balances, the Opening Stock tab, which can be imported too. See Adding products and customers.

An opening receivables file was imported twice. What happens?

Each row of an opening receivables or payables import adds a new note, so the notes are doubled. Delete the extra opening notes in Settings → Opening Balances, and do not import the same file twice. See Importing data from Excel.

Why does the import button not show?

An import button only shows for users who may import that data. For example, importing products belongs to the Warehouse Manager, importing customers to the Cashier Manager, and importing opening balances to holders of the Settings role. See Importing data from Excel.

How do I export the product list to Excel?

In Master Data → Products, filter the list if needed, then press Export to Excel. Its download link appears in the bell once the file is ready. This button is there when the extra Excel export feature is on. See Exporting products to Excel.

I use Doctor Accounting. Can I move to Vende?

Yes. Contact the Vende team: they make an import package from your Doctor Accounting data. The shop owner then runs it in Settings → Full Data Import, with the products, customers, suppliers, balances and transaction history. See Moving from Doctor Accounting or another program.

I use another cashier program. Can I move?

For just the list of goods and customers, import from Excel and then enter the opening balances. For all data with its transaction history, contact the Vende team first to ask whether the data can be moved with Full Data Import. See Choose the way that suits you.

What is Full Data Import?

An extra feature to move all data from an old program at once, from one import package: a ZIP file holding several CSV files. Vende checks the package first without saving anything, then the import runs in the background. Only the shop owner can run it. See Running the import.

The result of a Full Data Import is not right. Can it be undone?

Yes, as long as the shop has not been used for new transactions since the import. Press Take back import in the import history. A full backup is made first, and only the data from that import is deleted. See Taking an import back.

A Full Data Import stopped halfway. What now?

When its status is Failed, press Resume. Data already brought in is not made twice. See Taking an import back.

Are the note numbers from the old program lost?

No. Vende gives new numbers, and the old number is written in the document's description. See During and after the import.

Why don't the imported records show one by one in Activity History?

To keep the shop's history short, one Full Data Import is recorded as one summary row of the record type Data Import: who ran it, when, from which program, and how many records of each type came in. Changes after the import are still recorded one by one. See Data imports.

How do I make sure the moved figures match?

Once the import is done, press Report in the import history. Its Reconciliation part compares the cash, receivable, payable and stock balances, and the sales, purchases and profit per month, with the figures in the package. See During and after the import.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp