Skip to content
MultiSaaS
Language: English

Import, export and barcode labels

Bring a whole catalogue in from a file, take yours out, and print stickers for goods that came without a barcode.

Typing five hundred products by hand is nobody's idea of a good week. If you already have them in a file — from Shopify, from WooCommerce, from Excel, from a shop you used before — you can bring the whole lot in at once.

Manage ProductAll ProductsImport CSV

What a CSV is

A CSV is just a spreadsheet saved in a plain, simple form. Excel and Google Sheets both make one from File → Save as / Download. If your list is in Excel today, it is one save away from being a CSV.

Taking your own products out#

Export CSV, next to Import CSV on the All Products page, downloads everything you sell as a file — prices, stock, barcodes, descriptions, categories, pictures, drafts and counter-only items included.

For copying a catalogue between shops, use THIS Export CSV — the one on the All Products page. The Export button on Manage Inventory is a stock report: it has no prices and no pictures at all, so importing it would give you a shop full of Rs 0 products with no photos.

Bringing products in#

  1. On All Products press Import CSV. A window opens headed Import products from CSV.
  2. Press Choose a CSV file and pick your file. You do not have to rename any column — a file from Shopify or WooCommerce is understood as it is.
  3. The window changes to a preview: a green number saying how many rows are ready to import, and beside it how many rows can't be used.
  4. Open Matched N columns from your file to see what it made of your column names — Variant Price → price, and so on. A wrong guess is far easier to fix here than afterwards.
  5. Press Import N products. A bar shows the progress — keep the window open until it finishes.
  6. At the end you get four figures: Created, Updated, Skipped, Failed, plus the names of any new categories. Press Done.
The import preview: rows ready to import, rows that can't be used, the matched columns list and the three switches.

The three switches before you press Import#

SwitchWhat it decides
Update existing productsOff (normal): a product with the same name is left untouched. On: it is overwritten with what is in the file.
Create missing categoriesCategory names in the file that you do not have yet are made for you. Leave it on unless you want to place everything by hand.
Copy images to our storageSlower, but your pictures keep working even if the old shop's website disappears. Worth the wait.
Watch the plan line in the preview. If your plan allows, say, 150 products and you already have 140, only the first 10 new ones come in and the rest are silently left out. The window tells you this BEFORE you press Import — read it, and talk to your provider first if you need more room.
Only the product name is truly required. A row with no price comes in at Rs 0 — perfectly saveable, and completely wrong on your website until you fix it. After a big import, sort by price and check for zeros.
Not sure how to lay out your own sheet? In the first step of the window, press Download template. It comes with the column names and one filled-in example row, so the shape is obvious.

Copying a catalogue from one shop to another#

  1. In the first shop, open All Products and press Export CSV. A file lands in your downloads.
  2. Sign in to the other shop and open All Products there.
  3. Press Import CSV, choose that same file, leave Copy images to our storage on, and import.
Some things are not part of a CSV at all and will not travel: option groups, add-ons and the specifications table. Add those in the product editor afterwards.

Printing barcode labels#

Loose or local goods come with no barcode printed on them. The dashboard makes one for each of them, and this screen prints the stickers so they can be scanned at the counter like anything else.

All ProductsBarcode labelsPrint labels
  1. Press Barcode labels at the top of All Products.
  2. In Add product, type a name, a barcode or an SKU and click the product in the list. It is added below.
  3. Set Copies for each one — how many stickers of that item you need.
  4. On the right choose Label size: an A4 sheet of 24, 40 or 65 labels, or a thermal label roll (38 × 25 mm).
  5. Tick Print the price on the label if you want the price on the sticker too.
  6. Press Print at the top right and your browser's print box opens.
The Barcode labels screen: chosen products with a Copies box on the left, label size and price options on the right.
In your printer settings set the scale to 100% and turn OFF “fit to page”. A barcode that has been shrunk even slightly stops scanning, and you will only find out at the counter with a customer waiting.
If the screen warns that some of these have no barcode yet, open each of those products and press Update & Publish once — a barcode is generated at that moment. Then come back and print.