Switch

From spreadsheets to Humryk

If your products, customers and stock are in spreadsheets today, you bring them over sheet by sheet: save each one as CSV and upload it where it belongs in Humryk. For business customers and stock you match your own column names, and you see every row before anything changes. Products go in through our template and arrive hidden until you've checked them.

  • Business customers with organisation number, payment terms, customer groups and price list
  • Price lists with percent, amount or fixed price, and quantity steps
  • Stock per place, and spot, batch and best-before with their parts on
  • Imports of business customers and stock can be undone

Then from €25/mo excl. VAT. No lock-in, and we'll be in touch before your trial ends.

Last checked

Sheet by sheet

Save each sheet as CSV first. In Excel that's «Save as» and CSV.

  1. 1ProductsUnder Products, choose «Import products» and «Manual template». Copy your columns into the template: name, SKU, description, price, variants, weight, cost price, categories, tags and image address. The products arrive hidden, so you check them before they show.
  2. 2Business customersUnder Customers → Companies, choose «Import», upload your sheet and match its columns: company name, email, country, organisation number, address, contact person, payment terms, customer groups and price lists. Invite them now or later.
  3. 3Price listsOpen a price list under Products → Price lists and choose «Import». The file from «Export» shows the columns: SKU, rule (percent, amount or fixed price), value and quantity. You see the new prices in the list before you save.
  4. 4StockSwitch on «Stock» under Settings → Features, then upload your stock sheet under «Import your stock». Each row is matched to a product by barcode, SKU or name, with its place and quantity, and its spot, batch and best-before when «Spots and picking» and «Batches and dates» are on.

Good to know before you start

  • Every import reads CSV, not an Excel file, so save the sheet as CSV first.
  • The product template has fixed column names in English, and no barcode column. Add barcodes under «Item numbers and barcodes» on the product, or with «Add the barcode to the item» the first time you scan it in «Receiving».
  • A product import can't be undone. A business customer import can, until you've sent invitations or they've ordered, and a stock import can, for what hasn't moved since.
  • Suppliers aren't imported. You add each one in «Receiving» the first time they deliver.
  • Order history stays in your sheets.

Common questions

Can I upload an Excel file?
Save it as CSV first. The imports of business customers and stock read semicolons, commas and tabs, in Unicode and in Western European encoding, so æ, ø and å come through.
Do I have to rename my columns?
Not for business customers or stock: you match your own column names once. Products and price lists use our column names.
Can cost prices come along?
Yes. The product template has a «Cost price (excl. VAT)» column. Switch on «Cost price and margin» to see them.
Will I get help moving?
Yes. Get in touch and we'll help you with the move.

Try it on your own business

Try it free for 30 days, with no card. We help you move products and customers, and you can keep your old shop running until you're ready.

Then from €25/mo excl. VAT. No lock-in, and we'll be in touch before your trial ends.