Skip to main content

Move from another inventory system

If you're leaving another inventory or order system, you bring your data across with spreadsheet imports. The order matters: each import looks up records the earlier ones created, and stock must be counted exactly once. This page walks the whole move, from the exports you take from the old system to the check that SKU.io's stock matches it on day one.

Moving from Extensiv Order Manager (formerly Skubana)? It has its own guided migration. See Move from Extensiv Order Manager to SKU.io.

Before you begin​

  • Finish Set your foundation, and set your inventory start date. Pick the day of the stock count you'll load as opening stock. Opening stock can't be loaded until the date is set.
  • Add your warehouses, including 3PLs. Opening stock is loaded per warehouse, and the supplier and purchase order imports look warehouses up by name.
  • Agree a freeze date with your team: the day you stop entering stock changes in the old system. It is usually the inventory start date.
  • Check your role has the import permissions: suppliers, products, purchase orders and sales orders each have their own Import permission.

What to export from the old system​

ExportUsed forNotes
Supplier listSuppliersNames, contact and purchase order emails, payment terms, currency.
Product listProductsSKU, name, barcode, brand, category, cost, selling price, weight and dimensions, default supplier.
Supplier price listProduct suppliersSupplier SKU, cost, minimum order and lead time per product.
Bundle and kit recipesBundles and kitsWhich components, and how many of each, make up each set.
Stock on hand by warehouseOpening stockUnits and unit cost per product, per warehouse, on the freeze date.
Open purchase ordersPurchase ordersOnly what is still to arrive on each line.
Customers (optional)CustomersMainly for wholesale customers who don't order through a sales channel.
Past sales orders (optional)Sales historyOnly orders that don't come from a sales channel you'll connect.
Stock valuation reportReconciliationUnits and value per warehouse on the freeze date. Keep it for the last step.

Import in this order​

  1. Suppliers. Import them first, so their payment terms, currency and purchase order email are in place before products and orders point at them. See Import suppliers from a spreadsheet.
  2. Products. Go to Products and click Import. The importer matches brands, categories and suppliers by name, and offers to create any it can't find. Then run the same importer again in Import Supplier Links mode to load each product's supplier SKU, cost, minimum order and lead time. See Import products from a spreadsheet.
  3. Bundles and kits. Set them up before any order comes in, so orders expand into their components. See Convert imported products into bundles or kits.
  4. Customers, if you need them. See Import customers from a spreadsheet. The sales order importer can also create a customer from a row it can't match.
  5. Opening stock. For each warehouse, create an initial count and load your stock export as a CSV with sku, quantity and unit_cost. The count is dated to your inventory start date. Product imports never create stock, so this is the only place opening stock comes from. See Load a warehouse's opening stock.
  6. Open purchase orders. Import each line with only the quantity still to arrive: for 100 ordered and 60 received, import 40. The 60 already received are in your opening stock. Imported orders land as drafts. Approve them so the stock counts as incoming, but don't Submit them unless you want SKU.io to email the order to the supplier again. See Import purchase orders from a spreadsheet and Approve and submit a purchase order.
  7. Past sales orders, if you want them as history. See Import sales orders. Imported orders arrive open: the importer can't mark them shipped or paid. Then close the ones dated before your inventory start date with Mark as Shipped Before Tracking, which records them as shipped without taking stock out of a warehouse. See Close orders that shipped before inventory tracking.

Every import validates your file before it writes anything, so you can fix and re-validate as often as you need.

Cut over​

  1. On the freeze date, take the last stock count in the old system, or export its stock on hand at the close of that day.
  2. Load that count as opening stock (step 5 above). If you loaded an earlier count while you were testing, load the final CSV into the same initial count: each row replaces that product's opening stock in the warehouse.
  3. Put the old system in read-only mode, so there is one place to change stock.
  4. Connect your sales channels. Before the first product sync, check the Auto Create/Link SKU Products switch on the store's Products tab: a listing whose SKU matches nothing in your catalog would become a duplicate product. Link those listings to your imported products first. See Link a channel listing to a product and Map listings in bulk with a spreadsheet.
  5. Let the channel bring in its own orders. Don't also import the same orders from your old system by spreadsheet, or they'll be in SKU.io twice. Channel orders dated before the inventory start date are kept out of allocation; close any that already shipped with Mark as Shipped Before Tracking.
  6. Make SKU.io the channel's Master of Stock only after opening stock is loaded. Until then, SKU.io's quantity for every listing is zero. See Set the stock each channel sees.

Leave Amazon FBA and AWD, Walmart WFS and TikTok FBT out of your opening-stock files. Those warehouses have no stock takes: their stock comes from the channel's own reports once you connect it.

Reconcile​

  1. Go to Insights → Reports and open Inventory Valuation.
  2. Set End of Day to your inventory start date.
  3. Under Group By, choose Warehouse, then SKU, and click Generate Report.
  4. Compare the on-hand units and value for each warehouse with the old system's valuation report for the same day. If a warehouse differs, compare it SKU by SKU, fix the CSV rows, and load them into the initial count again.
  5. Check Inbound Quantity against the open purchase orders you exported.

See Value your inventory for what each column means. Match your 3PL and FBA reports on the same date too, as Validate, then go live describes.

Next steps​

Last verified: